{"id":"https://openalex.org/W4401110894","doi":"https://doi.org/10.1109/intcec61833.2024.10602830","title":"Multi-Objective Genetic Algorithm for Materialized View Optimization in Data Warehouses","display_name":"Multi-Objective Genetic Algorithm for Materialized View Optimization in Data Warehouses","alternate_titles":[],"publication_year":2024,"publication_date":"2024-06-11","ids":{"openalex":"https://openalex.org/W4401110894","doi":"https://doi.org/10.1109/intcec61833.2024.10602830"},"language":"en","primary_location":{"id":"doi:10.1109/intcec61833.2024.10602830","doi":"https://doi.org/10.1109/intcec61833.2024.10602830","is_oa":false,"landing_page_url":"https://doi.org/10.1109/intcec61833.2024.10602830","pdf_url":null,"source":{"id":"https://openalex.org/S7407097131","display_name":"Interdisciplinary Conference on Electrics and Computer (INTCEC)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 4th Interdisciplinary Conference on Electrics and Computer (INTCEC)","raw_type":"proceedings-article"},"parent_works":[],"lineage":["https://openalex.org/W4401110894"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2403.19906","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5065001359","display_name":"Mahdi Manavi","orcid":"https://orcid.org/0000-0003-4379-3568","observed_orcids":["https://orcid.org/0000-0003-4379-3568"]},"institutions":[{"id":"https://openalex.org/I44461941","display_name":"University of Houston","ror":"https://ror.org/048sx0r50","country_code":"US","type":"education","lineage":["https://openalex.org/I44461941"]}],"countries":["US"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Mahdi Manavi","raw_affiliation_strings":["University of Houston,Department of Computer Science,Houston,USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Houston,Department of Computer Science,Houston,USA","institution_ids":["https://openalex.org/I44461941"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5065001359"],"corresponding_institution_ids":["https://openalex.org/I44461941"],"apc_list":null,"apc_paid":null,"fwci":0.756,"has_fulltext":true,"cited_by_count":5,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.74416274,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":86,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"6"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9922000169754028,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9922000169754028,"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/T11891","display_name":"Big Data and Business Intelligence","score":0.002300000051036477,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.0008999999845400453,"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/materialized-view-selection","display_name":"materialized view selection","score":0.9639999866485596},{"id":"https://openalex.org/keywords/multi-objective-genetic-algorithm","display_name":"multi-objective genetic algorithm","score":0.9549999833106995},{"id":"https://openalex.org/keywords/query-performance","display_name":"query performance","score":0.6830000281333923},{"id":"https://openalex.org/keywords/execution-time-reduction","display_name":"execution time reduction","score":0.7300000190734863},{"id":"https://openalex.org/keywords/adaptive-mutation-rate","display_name":"adaptive mutation rate","score":0.968999981880188},{"id":"https://openalex.org/keywords/lexicase-selection","display_name":"lexicase selection","score":0.9789999723434448},{"id":"https://openalex.org/keywords/tpc-h","display_name":"TPC-H","score":0.8379999995231628}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9233354330062866},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8270658254623413},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7795026302337646},{"id":"https://openalex.org/C8880873","wikidata":"https://www.wikidata.org/wiki/Q187787","display_name":"Genetic algorithm","level":2,"score":0.5811333656311035},{"id":"https://openalex.org/C50416739","wikidata":"https://www.wikidata.org/wiki/Q181623","display_name":"Warehouse","level":2,"score":0.41255420446395874},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.33817532658576965},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.10196614265441895},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.08142581582069397},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/intcec61833.2024.10602830","doi":"https://doi.org/10.1109/intcec61833.2024.10602830","is_oa":false,"landing_page_url":"https://doi.org/10.1109/intcec61833.2024.10602830","pdf_url":null,"source":{"id":"https://openalex.org/S7407097131","display_name":"Interdisciplinary Conference on Electrics and Computer (INTCEC)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 4th Interdisciplinary Conference on Electrics and Computer (INTCEC)","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:2403.19906","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2403.19906","pdf_url":"https://arxiv.org/pdf/2403.19906","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"doi:10.48550/arxiv.2403.19906","doi":"https://doi.org/10.48550/arxiv.2403.19906","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2403.19906","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2403.19906","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2403.19906","pdf_url":"https://arxiv.org/pdf/2403.19906","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4401110894.pdf","grobid_xml":"https://content.openalex.org/works/W4401110894.grobid-xml"},"referenced_works_count":18,"referenced_works":["https://openalex.org/W2000709835","https://openalex.org/W2007800946","https://openalex.org/W2065907517","https://openalex.org/W2070168269","https://openalex.org/W2100799582","https://openalex.org/W2152380186","https://openalex.org/W2241362225","https://openalex.org/W2945459156","https://openalex.org/W2968683814","https://openalex.org/W3133733881","https://openalex.org/W3166174009","https://openalex.org/W4214505893","https://openalex.org/W4214920055","https://openalex.org/W4302358401","https://openalex.org/W4311111384","https://openalex.org/W4376855352","https://openalex.org/W4380433181","https://openalex.org/W4391827376"],"related_works":["https://openalex.org/W2085605698","https://openalex.org/W880354395","https://openalex.org/W2353328913","https://openalex.org/W2070168269","https://openalex.org/W2319588674","https://openalex.org/W2386560199","https://openalex.org/W2364900825","https://openalex.org/W3035894368","https://openalex.org/W2347922525","https://openalex.org/W4234591895"],"abstract_inverted_index":{"Materialized":[0],"views":[1,14,174],"can":[2],"significantly":[3,146],"improve":[4],"database":[5],"query":[6],"performance":[7],"but":[8],"identifying":[9],"the":[10,70,98,102,135],"optimal":[11],"set":[12],"of":[13,104,129,137,172],"to":[15,47,53,74,91,108],"materialize":[16],"is":[17],"challenging.":[18],"Prior":[19],"work":[20,161],"on":[21,97],"automating":[22],"and":[23,33,57,68,88,120,156,169],"optimizing":[24],"materialized":[25,48,63,123,149,173],"view":[26,49,64,124,150],"selection":[27,50,90,151],"has":[28],"limitations":[29],"in":[30,153,166,175],"execution":[31,55,115],"time":[32,56,116],"total":[34,58,122,157],"cost.":[35,59],"In":[36],"this":[37],"paper,":[38],"we":[39],"present":[40],"a":[41,138],"novel":[42],"genetic":[43,93,143],"algorithm":[44,144],"based":[45],"approach":[46,112],"that":[51],"aims":[52],"minimize":[54],"Our":[60,142],"technique":[61],"encodes":[62],"configurations":[65],"as":[66],"chromosomes":[67],"evolves":[69],"population":[71],"over":[72],"generations":[73],"discover":[75],"high":[76],"quality":[77],"solutions.":[78],"We":[79],"employ":[80],"an":[81,127,163],"adaptive":[82],"mutation":[83],"rate,":[84],"multi-objective":[85],"fitness":[86],"function,":[87],"lexicase":[89],"enhance":[92],"search.":[94],"Comprehensive":[95],"experiments":[96],"TPC-H":[99],"benchmark":[100],"demonstrate":[101],"effectiveness":[103],"our":[105,111],"algorithm.":[106],"Compared":[107],"state-of-the-art":[109],"methods,":[110],"improves":[113],"average":[114,128],"by":[117,126],"11":[118],"%":[119],"reduces":[121],"costs":[125],"16":[130],"million.":[131],"These":[132],"gains":[133],"highlight":[134],"benefits":[136],"data-driven":[139],"evolutionary":[140],"approach.":[141],"framework":[145],"outperforms":[147],"current":[148],"techniques":[152],"both":[154],"efficiency":[155],"cost":[158],"reduction.":[159],"This":[160],"represents":[162],"important":[164],"advance":[165],"enabling":[167],"performant":[168],"cost-effective":[170],"utilization":[171],"enterprise":[176],"systems.":[177]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4401110894","counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1}],"updated_date":"2026-11-21T10:27:49.728292","created_date":"2024-07-31T00:00:00"}
