{"id":"https://openalex.org/W3198743557","doi":"https://doi.org/10.1145/3472163.3472180","title":"Bringing Common Subexpression Problem from the Dark to Light: Towards Large-Scale Workload Optimizations","display_name":"Bringing Common Subexpression Problem from the Dark to Light: Towards Large-Scale Workload Optimizations","publication_year":2021,"publication_date":"2021-07-14","ids":{"openalex":"https://openalex.org/W3198743557","doi":"https://doi.org/10.1145/3472163.3472180","mag":"3198743557"},"language":"en","primary_location":{"id":"doi:10.1145/3472163.3472180","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3472163.3472180","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"25th International Database Engineering & Applications Symposium","raw_type":"proceedings-article"},"type":"conference-paper","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/A5075537686","display_name":"Mohamed Kechar","orcid":"https://orcid.org/0000-0002-5350-8516"},"institutions":[{"id":"https://openalex.org/I137407579","display_name":"Universit\u00e9 Oran 1 Ahmed Ben Bella","ror":"https://ror.org/059et2b68","country_code":"DZ","type":"education","lineage":["https://openalex.org/I137407579"]}],"countries":["DZ"],"is_corresponding":false,"raw_author_name":"Mohamed Kechar","raw_affiliation_strings":["Universite d'Oran Es-Senia, Algeria"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universite d'Oran Es-Senia, Algeria","institution_ids":["https://openalex.org/I137407579"]}]},{"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/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":["Ecole Nationale Superieur de Mecanique et d'Aeronautique, France"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Ecole Nationale Superieur de Mecanique et d'Aeronautique, France","institution_ids":["https://openalex.org/I171246369"]}]},{"author_position":"last","author":{"id":null,"display_name":"Safia Nait-bahloul","orcid":null},"institutions":[{"id":"https://openalex.org/I137407579","display_name":"Universit\u00e9 Oran 1 Ahmed Ben Bella","ror":"https://ror.org/059et2b68","country_code":"DZ","type":"education","lineage":["https://openalex.org/I137407579"]}],"countries":["DZ"],"is_corresponding":false,"raw_author_name":"Safia Nait-bahloul","raw_affiliation_strings":["Universite d'Oran Es-Senia, Algeria"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universite d'Oran Es-Senia, Algeria","institution_ids":["https://openalex.org/I137407579"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.3562,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.78934061,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":97},"biblio":{"volume":"15","issue":null,"first_page":"27","last_page":"35"},"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.9994999766349792,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9918000102043152,"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/computer-science","display_name":"Computer science","score":0.870489239692688},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.8578393459320068},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.8324947357177734},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.7183679342269897},{"id":"https://openalex.org/keywords/redundancy","display_name":"Redundancy (engineering)","score":0.6569641828536987},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.6315119862556458},{"id":"https://openalex.org/keywords/heuristic","display_name":"Heuristic","score":0.49304959177970886},{"id":"https://openalex.org/keywords/data-redundancy","display_name":"Data redundancy","score":0.4898051917552948},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.46970030665397644},{"id":"https://openalex.org/keywords/scale","display_name":"Scale (ratio)","score":0.4353598952293396},{"id":"https://openalex.org/keywords/field","display_name":"Field (mathematics)","score":0.4195752739906311},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.38125738501548767},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3618101179599762},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3441612124443054},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.19894087314605713},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.13434824347496033},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.12776032090187073},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.12504228949546814},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.1137351393699646}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.870489239692688},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.8578393459320068},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.8324947357177734},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.7183679342269897},{"id":"https://openalex.org/C152124472","wikidata":"https://www.wikidata.org/wiki/Q1204361","display_name":"Redundancy (engineering)","level":2,"score":0.6569641828536987},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.6315119862556458},{"id":"https://openalex.org/C173801870","wikidata":"https://www.wikidata.org/wiki/Q201413","display_name":"Heuristic","level":2,"score":0.49304959177970886},{"id":"https://openalex.org/C7545210","wikidata":"https://www.wikidata.org/wiki/Q838123","display_name":"Data redundancy","level":2,"score":0.4898051917552948},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.46970030665397644},{"id":"https://openalex.org/C2778755073","wikidata":"https://www.wikidata.org/wiki/Q10858537","display_name":"Scale (ratio)","level":2,"score":0.4353598952293396},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.4195752739906311},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.38125738501548767},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3618101179599762},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3441612124443054},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.19894087314605713},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.13434824347496033},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.12776032090187073},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.12504228949546814},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.1137351393699646},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"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/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","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/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3472163.3472180","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3472163.3472180","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"25th International Database Engineering & Applications Symposium","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.46000000834465027,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":27,"referenced_works":["https://openalex.org/W1536741282","https://openalex.org/W1597931764","https://openalex.org/W1635132392","https://openalex.org/W1972648780","https://openalex.org/W2030148067","https://openalex.org/W2058978608","https://openalex.org/W2072530859","https://openalex.org/W2079329679","https://openalex.org/W2081417442","https://openalex.org/W2086028392","https://openalex.org/W2116476518","https://openalex.org/W2124751909","https://openalex.org/W2143401113","https://openalex.org/W2143515359","https://openalex.org/W2156554027","https://openalex.org/W2168406720","https://openalex.org/W2792920932","https://openalex.org/W2799237774","https://openalex.org/W2890919505","https://openalex.org/W2913374448","https://openalex.org/W2945459156","https://openalex.org/W2950821398","https://openalex.org/W3010823339","https://openalex.org/W3153258780","https://openalex.org/W4232666159","https://openalex.org/W6657681534","https://openalex.org/W6681207993"],"related_works":["https://openalex.org/W2919686661","https://openalex.org/W1496981381","https://openalex.org/W4372184962","https://openalex.org/W2074877482","https://openalex.org/W2002428578","https://openalex.org/W2897258045","https://openalex.org/W2018406690","https://openalex.org/W2072332896","https://openalex.org/W2951748633","https://openalex.org/W2542042335"],"abstract_inverted_index":{"Nowadays":[0],"large-scale":[1,34,123],"data-centric":[2],"systems":[3,31],"have":[4,62,110,202],"become":[5],"an":[6],"essential":[7],"element":[8],"for":[9],"companies":[10],"to":[11,133,188,205],"store,":[12],"manipulate":[13],"and":[14,57,113,209],"derive":[15],"value":[16,24],"from":[17],"large":[18,91,216],"volumes":[19],"of":[20,29,41,45,55,81,93,105,144,157,160,162,168,173,211],"data.":[21],"Capturing":[22],"this":[23,126],"depends":[25,176],"on":[26,141,178],"the":[27,42,82,87,94,103,135,142,145,154,158,166,169,179,190,207],"ability":[28],"these":[30,46,72],"in":[32,53,66,86,115,121],"managing":[33,122],"workloads":[35],"including":[36],"complex":[37],"analytical":[38],"queries.":[39,150],"One":[40],"main":[43],"characteristics":[44],"queries":[47,69],"is":[48,79,186],"that":[49],"they":[50,101,119],"share":[51],"computations":[52],"terms":[54],"selections":[56],"joins.":[58],"Materialized":[59],"views":[60,139,194],"(MV)":[61],"shown":[63],"their":[64],"force":[65],"speeding":[67],"up":[68],"by":[70,195,214],"exploiting":[71],"redundant":[73],"computations.":[74,107],"MV":[75,175],"selection":[76,161],"problem":[77,159],"(VSP)":[78],"one":[80],"most":[83,136,191],"studied":[84],"problems":[85],"database":[88],"field.":[89],"A":[90],"majority":[92],"existing":[95],"solutions":[96],"follow":[97],"workload-driven":[98],"approaches":[99],"since":[100],"facilitate":[102],"identification":[104],"shared":[106,148],"Interesting":[108],"algorithms":[109],"been":[111,203],"proposed":[112],"implemented":[114],"commercial":[116],"DBMSs.":[117],"But":[118],"fail":[120],"workloads.":[124,217],"In":[125],"paper,":[127],"we":[128],"presented":[129],"a":[130,184],"comprehensive":[131],"framework":[132,152],"select":[134,189],"beneficial":[137,192],"materialized":[138,193],"based":[140],"detection":[143],"common":[146,163],"subexpressions":[147,164],"between":[149],"This":[151],"gives":[153],"right":[155],"place":[156],"representing":[165],"causes":[167],"redundancy.":[170],"The":[171],"utility":[172],"final":[174],"strongly":[177],"selected":[180],"subexpressions.":[181],"Once":[182],"selected,":[183],"heuristic":[185],"given":[187],"considering":[196,215],"different":[197],"query":[198],"ordering.":[199],"Finally,":[200],"experiments":[201],"conducted":[204],"evaluate":[206],"effectiveness":[208],"efficiency":[210],"our":[212],"proposal":[213]},"counts_by_year":[{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":2}],"updated_date":"2026-07-30T17:31:21.811387","created_date":"2025-10-10T00:00:00"}