{"id":"https://openalex.org/W3138831836","doi":"https://doi.org/10.1109/bigdata50022.2020.9378196","title":"A Genetic Optimization Physical Planner for Big Data Warehouses","display_name":"A Genetic Optimization Physical Planner for Big Data Warehouses","publication_year":2020,"publication_date":"2020-12-10","ids":{"openalex":"https://openalex.org/W3138831836","doi":"https://doi.org/10.1109/bigdata50022.2020.9378196","mag":"3138831836"},"language":"en","primary_location":{"id":"doi:10.1109/bigdata50022.2020.9378196","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata50022.2020.9378196","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2020 IEEE International Conference on Big Data (Big Data)","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/A5062934077","display_name":"Soumia Benkrid","orcid":null},"institutions":[{"id":"https://openalex.org/I4210149016","display_name":"\u00c9cole Nationale Sup\u00e9rieure d'Informatique","ror":"https://ror.org/04dj1dn66","country_code":"DZ","type":"education","lineage":["https://openalex.org/I4210149016"]}],"countries":["DZ"],"is_corresponding":true,"raw_author_name":"Soumia Benkrid","raw_affiliation_strings":["Ecole nationale Sup\u00e9rieure d\u2019Informatique (ESI), Algeria","ESI - \u00c9cole Nationale Sup\u00e9rieure d'Informatique [Alger] (Alger Oued Smar, 16309 - Algeria)"],"affiliations":[{"raw_affiliation_string":"Ecole nationale Sup\u00e9rieure d\u2019Informatique (ESI), Algeria","institution_ids":["https://openalex.org/I4210149016"]},{"raw_affiliation_string":"ESI - \u00c9cole Nationale Sup\u00e9rieure d'Informatique [Alger] (Alger Oued Smar, 16309 - Algeria)","institution_ids":["https://openalex.org/I4210149016"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003638249","display_name":"Yacine Mestoui","orcid":null},"institutions":[{"id":"https://openalex.org/I4210149016","display_name":"\u00c9cole Nationale Sup\u00e9rieure d'Informatique","ror":"https://ror.org/04dj1dn66","country_code":"DZ","type":"education","lineage":["https://openalex.org/I4210149016"]}],"countries":["DZ"],"is_corresponding":false,"raw_author_name":"Yacine Mestoui","raw_affiliation_strings":["Ecole nationale Sup\u00e9rieure d\u2019Informatique (ESI), Algeria","ESI - \u00c9cole Nationale Sup\u00e9rieure d'Informatique [Alger] (Alger Oued Smar, 16309 - Algeria)"],"affiliations":[{"raw_affiliation_string":"Ecole nationale Sup\u00e9rieure d\u2019Informatique (ESI), Algeria","institution_ids":["https://openalex.org/I4210149016"]},{"raw_affiliation_string":"ESI - \u00c9cole Nationale Sup\u00e9rieure d'Informatique [Alger] (Alger Oued Smar, 16309 - Algeria)","institution_ids":["https://openalex.org/I4210149016"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006507514","display_name":"Ladjel Bellatreche","orcid":"https://orcid.org/0000-0001-9968-0066"},"institutions":[{"id":"https://openalex.org/I4210116740","display_name":"Laboratoire d'Informatique et d'Automatique pour les Syst\u00e8mes","ror":"https://ror.org/02b5vq778","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I4210113334","https://openalex.org/I4210116740","https://openalex.org/I4210139971"]},{"id":"https://openalex.org/I171246369","display_name":"\u00c9cole Nationale Sup\u00e9rieure de M\u00e9canique et d'A\u00e9rotechnique","ror":"https://ror.org/04jx68594","country_code":"FR","type":"facility","lineage":["https://openalex.org/I171246369"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Ladjel Bellatreche","raw_affiliation_strings":["LIAS/ISAE-ENSMA, France","IDD - Ing\u00e9nierie des Donn\u00e9es et des moD\u00e8les (Laboratoire LIAS - ENSIP B\u00e2timent B25 - 2 rue Pierre Brousse TSA 41105 86073 Poitiers Cedex 9 France \r\nLaboratoire LIAS - ISAE-ENSMA T\u00e9l\u00e9port 2 - 1 avenue Cl\u00e9ment Ader BP 40109 86961 Chasseneuil France - France)","LIAS [Poitiers] - Laboratoire d'informatique et d'automatique pour les syst\u00e8mes [EA 6315] (LISI-ENSMA T\u00e9l\u00e9port 2 \u2013 1 avenue Cl\u00e9ment Ader \u2013 BP 40109 \u2013 86961 Futuroscope Chasseneuil cedex \u2013 france - France)"],"affiliations":[{"raw_affiliation_string":"LIAS/ISAE-ENSMA, France","institution_ids":["https://openalex.org/I171246369"]},{"raw_affiliation_string":"IDD - Ing\u00e9nierie des Donn\u00e9es et des moD\u00e8les (Laboratoire LIAS - ENSIP B\u00e2timent B25 - 2 rue Pierre Brousse TSA 41105 86073 Poitiers Cedex 9 France \r\nLaboratoire LIAS - ISAE-ENSMA T\u00e9l\u00e9port 2 - 1 avenue Cl\u00e9ment Ader BP 40109 86961 Chasseneuil France - France)","institution_ids":["https://openalex.org/I171246369"]},{"raw_affiliation_string":"LIAS [Poitiers] - Laboratoire d'informatique et d'automatique pour les syst\u00e8mes [EA 6315] (LISI-ENSMA T\u00e9l\u00e9port 2 \u2013 1 avenue Cl\u00e9ment Ader \u2013 BP 40109 \u2013 86961 Futuroscope Chasseneuil cedex \u2013 france - France)","institution_ids":["https://openalex.org/I4210116740","https://openalex.org/I171246369"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048296533","display_name":"Ordonez Carlos","orcid":null},"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":false,"raw_author_name":"Carlos Ordonez","raw_affiliation_strings":["University of Houston, USA","University of Houston (Houston, TX 77204 - United States)"],"affiliations":[{"raw_affiliation_string":"University of Houston, USA","institution_ids":["https://openalex.org/I44461941"]},{"raw_affiliation_string":"University of Houston (Houston, TX 77204 - United States)","institution_ids":["https://openalex.org/I44461941"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5062934077"],"corresponding_institution_ids":["https://openalex.org/I4210149016"],"apc_list":null,"apc_paid":null,"fwci":0.3223,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.65274877,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"406","last_page":"412"},"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9991000294685364,"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/T11106","display_name":"Data Management and Algorithms","score":0.9987999796867371,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8509855270385742},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.7705637216567993},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.6373762488365173},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.6260011792182922},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.5960416793823242},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.5099421739578247},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5072852969169617},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.47406524419784546},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.38045790791511536},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.3637236952781677}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8509855270385742},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.7705637216567993},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6373762488365173},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.6260011792182922},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.5960416793823242},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.5099421739578247},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5072852969169617},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.47406524419784546},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.38045790791511536},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3637236952781677},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/bigdata50022.2020.9378196","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata50022.2020.9378196","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2020 IEEE International Conference on Big Data (Big Data)","raw_type":"proceedings-article"},{"id":"pmh:oai:HAL:hal-03986818v1","is_oa":false,"landing_page_url":"https://hal.science/hal-03986818","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proc. IEEE Big Data Conference (IEEE Big Data 2020), Dec 2020, Atlanta,USA(Virtual Conference), United States. ⟨10.1109/BigData50022.2020.9378196⟩","raw_type":"Conference papers"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4300000071525574,"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":29,"referenced_works":["https://openalex.org/W74090038","https://openalex.org/W1482997398","https://openalex.org/W1528326260","https://openalex.org/W1561058006","https://openalex.org/W1997375126","https://openalex.org/W2111162011","https://openalex.org/W2133741724","https://openalex.org/W2140342613","https://openalex.org/W2150630976","https://openalex.org/W2158454296","https://openalex.org/W2170476109","https://openalex.org/W2170853664","https://openalex.org/W2271870283","https://openalex.org/W2403720054","https://openalex.org/W2584555500","https://openalex.org/W2597173860","https://openalex.org/W2613206411","https://openalex.org/W2794711922","https://openalex.org/W2795346422","https://openalex.org/W2799015892","https://openalex.org/W2799237774","https://openalex.org/W2804924008","https://openalex.org/W2889252017","https://openalex.org/W2945539433","https://openalex.org/W3003063159","https://openalex.org/W6676974665","https://openalex.org/W6733403177","https://openalex.org/W6735049879","https://openalex.org/W6773439798"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","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/W2382180329","https://openalex.org/W2375394542"],"abstract_inverted_index":{"Workload-driven":[0],"approaches":[1,27],"for":[2],"partitioning":[3,54,76,124,139],"and":[4,55,77,99,143,155],"tuning":[5],"traditional":[6],"Parallel":[7],"Database":[8],"systems":[9],"are":[10,28,60],"well":[11],"studied":[12],"in":[13,17,114,152],"the":[14,18,37,41,105,119],"literature.":[15],"Unfortunately,":[16],"context":[19],"of":[20,43,121],"new":[21],"generation":[22],"\"Big":[23],"Data\"":[24],"warehouses,":[25],"these":[26],"not":[29],"correctly":[30],"adapted":[31],"to":[32,62,83,102,126],"Business":[33],"Intelligence":[34],"2.0,":[35],"where":[36],"analyst":[38],"is":[39],"at":[40],"heart":[42],"decision":[44],"support":[45],"systems.":[46],"This":[47],"\"disconnect\"":[48],"situation":[49],"strongly":[50],"impacts":[51],"both":[52],"data":[53,75,168],"fragment":[56,78],"allocation":[57,79],"processes,":[58],"which":[59],"essential":[61],"achieve":[63],"good":[64],"query":[65,85,109,132],"performance.":[66],"To":[67],"overcome":[68],"this":[69],"problem,":[70],"recent":[71],"studies":[72],"proposed":[73],"online":[74,144],"using":[80],"AI":[81],"techniques":[82],"improve":[84],"performance":[86],"with":[87],"adaptive":[88],"behavior.":[89],"Nevertheless,":[90],"they":[91,95,100],"have":[92],"important":[93],"limitations:":[94],"add":[96],"significant":[97],"overhead":[98],"tend":[101],"focus":[103],"on":[104,130,165,174],"current":[106],"workload,":[107],"ignoring":[108],"logs.":[110],"With":[111],"such":[112],"motivation":[113],"mind,":[115],"we":[116],"first":[117],"formulate":[118],"problem":[120],"optimizing":[122],"database":[123],"subject":[125],"feasibility":[127],"constraints,":[128],"based":[129],"a":[131,137,166],"workload.":[133],"We":[134,160],"then":[135],"introduce":[136],"proactive":[138],"approach":[140],"combining":[141],"offline":[142],"processing":[145],"phases,":[146],"inspired":[147],"by":[148],"closed-loop":[149],"control":[150],"(used":[151],"engineering":[153],"disciplines)":[154],"genetic":[156],"algorithms":[157],"(from":[158],"AI).":[159],"present":[161],"an":[162],"experimental":[163],"validation":[164],"big":[167],"cluster":[169],"that":[170],"shows":[171],"promising":[172],"results":[173],"typical":[175],"OLAP":[176],"workloads.":[177]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":1}],"updated_date":"2026-03-24T08:02:53.985720","created_date":"2021-03-29T00:00:00"}