{"id":"https://openalex.org/W1908544460","doi":"https://doi.org/10.1109/aiccsa.2005.1387024","title":"Algorithms for selecting materialized views in a data warehouse","display_name":"Algorithms for selecting materialized views in a data warehouse","publication_year":2005,"publication_date":"2005-04-01","ids":{"openalex":"https://openalex.org/W1908544460","doi":"https://doi.org/10.1109/aiccsa.2005.1387024","mag":"1908544460"},"language":"en","primary_location":{"id":"doi:10.1109/aiccsa.2005.1387024","is_oa":false,"landing_page_url":"https://doi.org/10.1109/aiccsa.2005.1387024","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The 3rd ACS/IEEE International Conference onComputer Systems and Applications, 2005.","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5079820394","display_name":"Noha A. Yousri","orcid":"https://orcid.org/0000-0003-1918-0331"},"institutions":[{"id":"https://openalex.org/I84524832","display_name":"Alexandria University","ror":"https://ror.org/00mzz1w90","country_code":"EG","type":"education","lineage":["https://openalex.org/I84524832"]}],"countries":["EG"],"is_corresponding":true,"raw_author_name":"N.A.R. Yousri","raw_affiliation_strings":["Computer Science Department, Faculty of Engineering, Alexandria University, Egypt","Comput. Sci. Dept., Alexandria Univ., Egypt"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, Faculty of Engineering, Alexandria University, Egypt","institution_ids":["https://openalex.org/I84524832"]},{"raw_affiliation_string":"Comput. Sci. Dept., Alexandria Univ., Egypt","institution_ids":["https://openalex.org/I84524832"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103177151","display_name":"K.M. Ahmed","orcid":"https://orcid.org/0000-0001-9495-6422"},"institutions":[{"id":"https://openalex.org/I84524832","display_name":"Alexandria University","ror":"https://ror.org/00mzz1w90","country_code":"EG","type":"education","lineage":["https://openalex.org/I84524832"]}],"countries":["EG"],"is_corresponding":false,"raw_author_name":"K.M. Ahmed","raw_affiliation_strings":["Computer Science Department, Faculty of Engineering, Alexandria University, Egypt","Comput. Sci. Dept., Alexandria Univ., Egypt"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, Faculty of Engineering, Alexandria University, Egypt","institution_ids":["https://openalex.org/I84524832"]},{"raw_affiliation_string":"Comput. Sci. Dept., Alexandria Univ., Egypt","institution_ids":["https://openalex.org/I84524832"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5053593861","display_name":"Nagwa El-Makky","orcid":"https://orcid.org/0000-0002-9571-7543"},"institutions":[{"id":"https://openalex.org/I84524832","display_name":"Alexandria University","ror":"https://ror.org/00mzz1w90","country_code":"EG","type":"education","lineage":["https://openalex.org/I84524832"]}],"countries":["EG"],"is_corresponding":false,"raw_author_name":"N.M. El-Makky","raw_affiliation_strings":["Computer Science Department, Faculty of Engineering, Alexandria University, Egypt","Comput. Sci. Dept., Alexandria Univ., Egypt"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, Faculty of Engineering, Alexandria University, Egypt","institution_ids":["https://openalex.org/I84524832"]},{"raw_affiliation_string":"Comput. Sci. Dept., Alexandria Univ., Egypt","institution_ids":["https://openalex.org/I84524832"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5079820394"],"corresponding_institution_ids":["https://openalex.org/I84524832"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":16,"citation_normalized_percentile":{"value":0.12291593,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"93","last_page":"100"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9983000159263611,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9907000064849854,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.9810535907745361},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.9125723838806152},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.9003205299377441},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8312260508537292},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5953588485717773},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.5780892968177795},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5292681455612183},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5031268000602722},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4638199210166931},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.44072264432907104},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.391679048538208},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.30114907026290894},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.08742159605026245},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.07287579774856567}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9810535907745361},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.9125723838806152},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.9003205299377441},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8312260508537292},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5953588485717773},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.5780892968177795},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5292681455612183},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5031268000602722},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4638199210166931},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.44072264432907104},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.391679048538208},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.30114907026290894},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.08742159605026245},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.07287579774856567},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/aiccsa.2005.1387024","is_oa":false,"landing_page_url":"https://doi.org/10.1109/aiccsa.2005.1387024","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The 3rd ACS/IEEE International Conference onComputer Systems and Applications, 2005.","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","score":0.7400000095367432,"id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":44,"referenced_works":["https://openalex.org/W1326169","https://openalex.org/W114500405","https://openalex.org/W1482520531","https://openalex.org/W1495399242","https://openalex.org/W1502629466","https://openalex.org/W1520432709","https://openalex.org/W1532064934","https://openalex.org/W1538267625","https://openalex.org/W1539154812","https://openalex.org/W1565760524","https://openalex.org/W1581805425","https://openalex.org/W1738857073","https://openalex.org/W1778331442","https://openalex.org/W1995999642","https://openalex.org/W2007362211","https://openalex.org/W2017782374","https://openalex.org/W2038176938","https://openalex.org/W2055343463","https://openalex.org/W2071288167","https://openalex.org/W2098416578","https://openalex.org/W2113888164","https://openalex.org/W2114712170","https://openalex.org/W2117242988","https://openalex.org/W2123614097","https://openalex.org/W2132729409","https://openalex.org/W2143401113","https://openalex.org/W2145559627","https://openalex.org/W2158447492","https://openalex.org/W2170515491","https://openalex.org/W2751199251","https://openalex.org/W2951321531","https://openalex.org/W4247387026","https://openalex.org/W4285719527","https://openalex.org/W4289258943","https://openalex.org/W4297851124","https://openalex.org/W6600049524","https://openalex.org/W6604780688","https://openalex.org/W6628941440","https://openalex.org/W6631138925","https://openalex.org/W6634765471","https://openalex.org/W6637887040","https://openalex.org/W6655000594","https://openalex.org/W6678486080","https://openalex.org/W6992659470"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W1988774479","https://openalex.org/W2363019959","https://openalex.org/W6138692","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W2381646725"],"abstract_inverted_index":{"Summary":[0],"form":[1],"only":[2],"given.":[3],"A":[4],"data":[5,11,89],"warehouse":[6],"stores":[7],"materialized":[8,41,72,85],"views":[9,42,58,73,86],"of":[10,20,28,40,57,64,67,93,146],"from":[12],"one":[13],"or":[14,24],"more":[15],"sources,":[16],"for":[17,83,132],"the":[18,29,38,47,61,71,107,114,129,133,139],"purpose":[19],"efficiently":[21],"implementing":[22],"decision-support":[23],"OLAP":[25],"queries.":[26],"One":[27],"most":[30],"important":[31],"decisions":[32],"in":[33,87],"designing":[34],"a":[35,88,123,143,147],"DW":[36],"is":[37,51,74,100],"selection":[39,135],"to":[43,52,101,105,142],"be":[44],"maintained":[45],"at":[46],"warehouse.":[48,90],"The":[49,97,118],"goal":[50],"select":[53],"an":[54,103],"appropriate":[55],"set":[56,66],"so":[59],"that":[60,127],"sum":[62],"cost":[63],"processing":[65],"queries":[68],"and":[69,113,137],"maintaining":[70],"minimized.":[75],"In":[76],"this":[77],"paper,":[78],"new":[79],"algorithms":[80],"are":[81,95],"proposed":[82],"selecting":[84],"Two":[91],"targets":[92],"research":[94],"considered.":[96],"first":[98],"target":[99,120],"propose":[102],"approach":[104],"solve":[106],"problem":[108],"considering":[109],"both":[110],"multi-query":[111],"optimization,":[112],"maintenance":[115],"process":[116],"optimization.":[117],"other":[119],"considers":[121],"using":[122],"simple":[124],"search":[125,130],"strategy":[126],"reduces":[128,138],"space":[131],"view":[134],"problem,":[136],"time":[140],"complexity":[141],"linear":[144],"instead":[145],"quadratic":[148],"one.":[149]},"counts_by_year":[{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":4}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}