{"id":"https://openalex.org/W2070168269","doi":"https://doi.org/10.4304/jcp.6.1.130-138","title":"An Improved Algorithm for Materialized View Selection","display_name":"An Improved Algorithm for Materialized View Selection","publication_year":2011,"publication_date":"2011-01-01","ids":{"openalex":"https://openalex.org/W2070168269","doi":"https://doi.org/10.4304/jcp.6.1.130-138","mag":"2070168269"},"language":"en","primary_location":{"id":"doi:10.4304/jcp.6.1.130-138","is_oa":false,"landing_page_url":"https://doi.org/10.4304/jcp.6.1.130-138","pdf_url":null,"source":{"id":"https://openalex.org/S77894049","display_name":"Journal of Computers","issn_l":"1796-203X","issn":["1796-203X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318660","host_organization_name":"Academy Publisher","host_organization_lineage":["https://openalex.org/P4310318660"],"host_organization_lineage_names":["Academy Publisher"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Computers","raw_type":"journal-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/A5103475894","display_name":"Lijuan Zhou","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Lijuan Zhou","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5085268918","display_name":"Haijun Geng","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Haijun Geng","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5076396589","display_name":"Mingsheng Xu","orcid":"https://orcid.org/0000-0001-6595-2297"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mingsheng Xu","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5103475894"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.7504,"has_fulltext":false,"cited_by_count":10,"citation_normalized_percentile":{"value":0.85370381,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"6","issue":"1","first_page":null,"last_page":null},"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.9987999796867371,"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.9987999796867371,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9983999729156494,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11719","display_name":"Data Quality and Management","score":0.9975000023841858,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"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.8871793150901794},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7345723509788513},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.6039897799491882},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.4043310284614563},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.23430567979812622},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.21443474292755127},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.0383952260017395}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.8871793150901794},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7345723509788513},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.6039897799491882},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.4043310284614563},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.23430567979812622},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.21443474292755127},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.0383952260017395},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.4304/jcp.6.1.130-138","is_oa":false,"landing_page_url":"https://doi.org/10.4304/jcp.6.1.130-138","pdf_url":null,"source":{"id":"https://openalex.org/S77894049","display_name":"Journal of Computers","issn_l":"1796-203X","issn":["1796-203X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318660","host_organization_name":"Academy Publisher","host_organization_lineage":["https://openalex.org/P4310318660"],"host_organization_lineage_names":["Academy Publisher"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Computers","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","score":0.6100000143051147,"id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":28,"referenced_works":["https://openalex.org/W38346608","https://openalex.org/W1595062593","https://openalex.org/W1635132392","https://openalex.org/W1793365533","https://openalex.org/W1905142731","https://openalex.org/W1975322779","https://openalex.org/W1975968096","https://openalex.org/W2056018408","https://openalex.org/W2073382728","https://openalex.org/W2087869882","https://openalex.org/W2113888164","https://openalex.org/W2114712170","https://openalex.org/W2122816893","https://openalex.org/W2123695542","https://openalex.org/W2132681112","https://openalex.org/W2143401113","https://openalex.org/W2143515359","https://openalex.org/W2145559627","https://openalex.org/W2154929945","https://openalex.org/W2167920923","https://openalex.org/W2911756228","https://openalex.org/W4285719527","https://openalex.org/W6601512833","https://openalex.org/W6631138925","https://openalex.org/W6639938994","https://openalex.org/W6677220311","https://openalex.org/W6678597633","https://openalex.org/W6681744526"],"related_works":["https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2125738398","https://openalex.org/W2376402673","https://openalex.org/W2038176938","https://openalex.org/W1680377312","https://openalex.org/W2953224074","https://openalex.org/W2585331044","https://openalex.org/W2588278736","https://openalex.org/W2114713465"],"abstract_inverted_index":{"The":[0,65,128,180],"data":[1,10,20,26,51,103,207],"warehouse":[2,21,52,208],"is":[3,13,53,70,98,117,131,178],"subject":[4],"oriented,":[5],"integrated,":[6],"nonvolatile":[7],"and":[8,78,152,171,194],"time-varying":[9],"sets,":[11],"which":[12],"used":[14],"to":[15,59,133,167],"support":[16],"management":[17],"decision-making.":[18],"A":[19],"stores":[22],"materialized":[23,57,96,124,135],"views":[24,58,69,87,97,125],"of":[25,35,43,56,67,74,86,102,143,173],"from":[27],"one":[28],"or":[29,39],"more":[30,151,153],"sources,":[31],"with":[32,94,140],"the":[33,44,54,63,75,90,95,99,110,120,134,141,146,169,184],"purpose":[34],"efficiently":[36],"implementing":[37],"Decision-support":[38],"OLAP":[40],"queries.":[41],"One":[42],"most":[45],"important":[46],"decisions":[47],"in":[48,161,165,191,197],"designing":[49],"a":[50,83],"selection":[55,114,137],"be":[60],"maintained":[61],"at":[62],"warehouse.":[64],"materialization":[66],"all":[68],"not":[71],"possible":[72],"because":[73],"space":[76],"constraint":[77],"maintenance":[79],"cost":[80,92,112],"constraint.":[81],"Selecting":[82],"suitable":[84],"set":[85],"that":[88,183],"minimize":[89],"total":[91],"associated":[93],"key":[100],"objective":[101],"warehousing.":[104],"In":[106],"this":[107,162],"paper,":[108],"first":[109],"query":[111],"view":[113,136],"problem":[115],"model":[116],"proposed.":[118],"Second,":[119],"methods":[121,186],"for":[122,206],"selecting":[123],"are":[126],"presented.":[127],"genetic":[129,144],"algorithm":[130,157],"applied":[132],"problem.":[138],"But":[139],"development":[142],"process,":[145],"legal":[147],"solution":[148],"produced":[149],"become":[150,203],"difficult.":[154],"Therefore,":[155],"improved":[156],"has":[158],"been":[159],"presented":[160],"paper.":[163],"Finally,":[164],"order":[166],"test":[168],"function":[170],"efficiency":[172],"our":[174],"algorithms,":[175],"experiment":[176],"simulation":[177],"adopted.":[179],"experiments":[181],"show":[182],"given":[185],"can":[187],"provide":[188],"near-optimal":[189],"solutions":[190],"limited":[192],"time":[193],"work":[195],"well":[196],"practical":[198],"cases.":[199],"Randomized":[200],"algorithms":[201],"will":[202],"invaluable":[204],"tools":[205],"evolution.":[209]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}