{"id":"https://openalex.org/W2089916605","doi":"https://doi.org/10.1145/1143997.1144120","title":"Multiobjective genetic algorithms for materialized view selection in OLAP data warehouses","display_name":"Multiobjective genetic algorithms for materialized view selection in OLAP data warehouses","publication_year":2006,"publication_date":"2006-07-08","ids":{"openalex":"https://openalex.org/W2089916605","doi":"https://doi.org/10.1145/1143997.1144120","mag":"2089916605"},"language":"en","primary_location":{"id":"doi:10.1145/1143997.1144120","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1143997.1144120","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 8th annual conference on Genetic and evolutionary computation","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/A5017899962","display_name":"Michael A. Lawrence","orcid":"https://orcid.org/0009-0006-9218-8427"},"institutions":[{"id":"https://openalex.org/I129902397","display_name":"Dalhousie University","ror":"https://ror.org/01e6qks80","country_code":"CA","type":"education","lineage":["https://openalex.org/I129902397"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Michael Lawrence","raw_affiliation_strings":["Dalhousie University, Halifax, NS, Canada"],"affiliations":[{"raw_affiliation_string":"Dalhousie University, Halifax, NS, Canada","institution_ids":["https://openalex.org/I129902397"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5017899962"],"corresponding_institution_ids":["https://openalex.org/I129902397"],"apc_list":null,"apc_paid":null,"fwci":1.8922,"has_fulltext":false,"cited_by_count":52,"citation_normalized_percentile":{"value":0.87360686,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"699","last_page":"706"},"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.9991999864578247,"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.9991999864578247,"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.9983999729156494,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9825999736785889,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.942745566368103},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.9425255060195923},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8931640386581421},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7664838433265686},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.6787088513374329},{"id":"https://openalex.org/keywords/genetic-algorithm","display_name":"Genetic algorithm","score":0.5225876569747925},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4882490932941437},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4740217328071594},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3254275918006897},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.324496865272522},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.13814285397529602},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.09947335720062256},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.08580198884010315}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.942745566368103},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9425255060195923},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8931640386581421},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7664838433265686},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.6787088513374329},{"id":"https://openalex.org/C8880873","wikidata":"https://www.wikidata.org/wiki/Q187787","display_name":"Genetic algorithm","level":2,"score":0.5225876569747925},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4882490932941437},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4740217328071594},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3254275918006897},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.324496865272522},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.13814285397529602},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.09947335720062256},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.08580198884010315},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1143997.1144120","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1143997.1144120","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 8th annual conference on Genetic and evolutionary computation","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.420.6553","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.420.6553","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.york.ac.uk/rts/docs/GECCO_2006/docs/p699.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4300000071525574,"display_name":"Partnerships for the goals","id":"https://metadata.un.org/sdg/17"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W1291450","https://openalex.org/W38346608","https://openalex.org/W1508018302","https://openalex.org/W1512383952","https://openalex.org/W1514365875","https://openalex.org/W1520432709","https://openalex.org/W1522055873","https://openalex.org/W1538267625","https://openalex.org/W1594502603","https://openalex.org/W1612556207","https://openalex.org/W1635132392","https://openalex.org/W1905847227","https://openalex.org/W1957430778","https://openalex.org/W1977786400","https://openalex.org/W2017782374","https://openalex.org/W2061660313","https://openalex.org/W2071288167","https://openalex.org/W2072916859","https://openalex.org/W2074713486","https://openalex.org/W2087869882","https://openalex.org/W2113888164","https://openalex.org/W2122816893","https://openalex.org/W2124751909","https://openalex.org/W2132681112","https://openalex.org/W2143401113","https://openalex.org/W2143515359","https://openalex.org/W2143628939","https://openalex.org/W2156554027","https://openalex.org/W2167159964","https://openalex.org/W2167443373","https://openalex.org/W2261054240","https://openalex.org/W2504494713","https://openalex.org/W4285719527"],"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":{"On-Line":[0],"Analytical":[1],"Processing":[2],"(OLAP)":[3],"tools":[4],"are":[5,175],"frequently":[6],"used":[7,150],"in":[8,25,60,164,170,191],"business,":[9],"science":[10],"and":[11,21,69,96],"health":[12],"to":[13,119,129,141,147],"extract":[14],"useful":[15],"knowledgefrom":[16],"massive":[17],"databases.":[18],"An":[19],"important":[20],"hard":[22],"optimization":[23,81],"problem":[24,58,82,184],"OLAP":[26],"data":[27,44],"warehouses":[28],"is":[29,78,128],"the":[30,43,55,61,64,73,94,109,131,134,142,156,162,167,171,178],"view":[31,56,74,120,143],"selection":[32,57,121,144],"problem,":[33,145],"consisting":[34],"of":[35,39,42,54,66,98,101,106,133,136,161,166,183,195],"selecting":[36],"a":[37,90,99,123,148,181,192],"set":[38],"aggregate":[40],"views":[41],"for":[45],"speeding":[46],"up":[47],"future":[48],"query":[49,70],"processing.":[50],"A":[51],"common":[52],"variant":[53],"addressed":[59],"literature":[62],"minimizes":[63],"sum":[65],"maintenance":[67],"cost":[68],"time":[71],"on":[72,180],"set.":[75],"Converting":[76],"what":[77],"inherently":[79],"an":[80],"with":[83,89,138,177],"multiple":[84],"conflicting":[85],"objectives":[86],"into":[87],"one":[88],"single":[91],"objective":[92],"ignores":[93],"need":[95],"value":[97],"variety":[100,182],"solutions":[102,188],"offering":[103],"various":[104],"levels":[105],"trade-off":[107],"between":[108],"objectives.":[110],"We":[111,153],"apply":[112],"two":[113],"non-elitist":[114],"multiobjective":[115],"evolutionary":[116,157],"algorithms":[117],"(MOEAs)":[118],"under":[122],"size":[124],"constraint.":[125],"Our":[126],"emphasis":[127],"determine":[130],"suitability":[132],"combination":[135],"MOEAs":[137,174],"constraint":[139],"handling":[140],"compared":[146],"widely":[149],"greedy":[151,163,179],"algorithm.":[152],"observe":[154],"that":[155,160],"process":[158,169],"mimics":[159],"terms":[165],"convergence":[168],"population.":[172],"The":[173],"competitive":[176],"instances,":[185],"often":[186],"finding":[187],"dominating":[189],"it":[190],"reasonable":[193],"amount":[194],"time.":[196]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":5},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":10},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":6},{"year":2012,"cited_by_count":5}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}