{"id":"https://openalex.org/W4318187123","doi":"https://doi.org/10.1109/bigdata55660.2022.10020703","title":"The Impact of Multicore CPUs on Eco-Friendly Query Processors in Big Data Warehouses","display_name":"The Impact of Multicore CPUs on Eco-Friendly Query Processors in Big Data Warehouses","publication_year":2022,"publication_date":"2022-12-17","ids":{"openalex":"https://openalex.org/W4318187123","doi":"https://doi.org/10.1109/bigdata55660.2022.10020703"},"language":"en","primary_location":{"id":"doi:10.1109/bigdata55660.2022.10020703","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata55660.2022.10020703","pdf_url":null,"source":{"id":"https://openalex.org/S4363607709","display_name":"2022 IEEE International Conference on Big Data (Big Data)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2022 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/A5063175773","display_name":"Ayoub Bouhatous","orcid":null},"institutions":[{"id":"https://openalex.org/I119856527","display_name":"Cadi Ayyad University","ror":"https://ror.org/04xf6nm78","country_code":"MA","type":"education","lineage":["https://openalex.org/I119856527"]},{"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","MA"],"is_corresponding":true,"raw_author_name":"Ayoub Bouhatous","raw_affiliation_strings":["ISAE-ENSMA,LIAS,Poitiers,France","LISI, Cadi Ayyad University, Marrakech, Morocco","LIAS, ISAE-ENSMA, Poitiers, France"],"affiliations":[{"raw_affiliation_string":"ISAE-ENSMA,LIAS,Poitiers,France","institution_ids":["https://openalex.org/I171246369"]},{"raw_affiliation_string":"LISI, Cadi Ayyad University, Marrakech, Morocco","institution_ids":["https://openalex.org/I119856527"]},{"raw_affiliation_string":"LIAS, ISAE-ENSMA, Poitiers, France","institution_ids":["https://openalex.org/I171246369"]}]},{"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":["ISAE-ENSMA,LIAS,Poitiers,France","LIAS, ISAE-ENSMA, Poitiers, France"],"affiliations":[{"raw_affiliation_string":"ISAE-ENSMA,LIAS,Poitiers,France","institution_ids":["https://openalex.org/I171246369"]},{"raw_affiliation_string":"LIAS, ISAE-ENSMA, Poitiers, France","institution_ids":["https://openalex.org/I171246369"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034603156","display_name":"El Hassan Abdelwahed","orcid":"https://orcid.org/0000-0002-2786-6707"},"institutions":[{"id":"https://openalex.org/I119856527","display_name":"Cadi Ayyad University","ror":"https://ror.org/04xf6nm78","country_code":"MA","type":"education","lineage":["https://openalex.org/I119856527"]}],"countries":["MA"],"is_corresponding":false,"raw_author_name":"El Hassan Abdelwahed","raw_affiliation_strings":["Cadi Ayyad University,LISI,Marrakech,Morocco","LISI, Cadi Ayyad University, Marrakech, Morocco"],"affiliations":[{"raw_affiliation_string":"Cadi Ayyad University,LISI,Marrakech,Morocco","institution_ids":["https://openalex.org/I119856527"]},{"raw_affiliation_string":"LISI, Cadi Ayyad University, Marrakech, Morocco","institution_ids":["https://openalex.org/I119856527"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5031610238","display_name":"Carlos Ordo\u0144\u1ebdz","orcid":"https://orcid.org/0009-0005-1135-9726"},"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,Department of Computer Science,USA","Department of Computer Science, University of Houston, USA"],"affiliations":[{"raw_affiliation_string":"University of Houston,Department of Computer Science,USA","institution_ids":["https://openalex.org/I44461941"]},{"raw_affiliation_string":"Department of Computer Science, University of Houston, USA","institution_ids":["https://openalex.org/I44461941"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5063175773"],"corresponding_institution_ids":["https://openalex.org/I119856527","https://openalex.org/I171246369"],"apc_list":null,"apc_paid":null,"fwci":0.5821,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.69547564,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"4463","last_page":"4472"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9973999857902527,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9973999857902527,"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/T11478","display_name":"Caching and Content Delivery","score":0.9957000017166138,"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.9937000274658203,"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/frequency-scaling","display_name":"Frequency scaling","score":0.8194828629493713},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7971851825714111},{"id":"https://openalex.org/keywords/multi-core-processor","display_name":"Multi-core processor","score":0.7093029618263245},{"id":"https://openalex.org/keywords/energy-consumption","display_name":"Energy consumption","score":0.6579684019088745},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.630868136882782},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.5655337572097778},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.47283607721328735},{"id":"https://openalex.org/keywords/efficient-energy-use","display_name":"Efficient energy use","score":0.4488532543182373},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.35641759634017944},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2505510747432709},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.12573307752609253}],"concepts":[{"id":"https://openalex.org/C157742956","wikidata":"https://www.wikidata.org/wiki/Q3237776","display_name":"Frequency scaling","level":3,"score":0.8194828629493713},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7971851825714111},{"id":"https://openalex.org/C78766204","wikidata":"https://www.wikidata.org/wiki/Q555032","display_name":"Multi-core processor","level":2,"score":0.7093029618263245},{"id":"https://openalex.org/C2780165032","wikidata":"https://www.wikidata.org/wiki/Q16869822","display_name":"Energy consumption","level":2,"score":0.6579684019088745},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.630868136882782},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.5655337572097778},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.47283607721328735},{"id":"https://openalex.org/C2742236","wikidata":"https://www.wikidata.org/wiki/Q924713","display_name":"Efficient energy use","level":2,"score":0.4488532543182373},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.35641759634017944},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2505510747432709},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.12573307752609253},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","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/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C119599485","wikidata":"https://www.wikidata.org/wiki/Q43035","display_name":"Electrical engineering","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/bigdata55660.2022.10020703","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata55660.2022.10020703","pdf_url":null,"source":{"id":"https://openalex.org/S4363607709","display_name":"2022 IEEE International Conference on Big Data (Big Data)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2022 IEEE International Conference on Big Data (Big Data)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Affordable and clean energy","id":"https://metadata.un.org/sdg/7","score":0.8899999856948853}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":30,"referenced_works":["https://openalex.org/W1597936319","https://openalex.org/W1605827952","https://openalex.org/W1678315924","https://openalex.org/W1985848498","https://openalex.org/W1994100271","https://openalex.org/W2002552415","https://openalex.org/W2026965159","https://openalex.org/W2032681711","https://openalex.org/W2041392558","https://openalex.org/W2077997907","https://openalex.org/W2083477168","https://openalex.org/W2119414841","https://openalex.org/W2143705506","https://openalex.org/W2170965549","https://openalex.org/W2284351912","https://openalex.org/W2582107883","https://openalex.org/W2592638109","https://openalex.org/W2594861944","https://openalex.org/W2605134047","https://openalex.org/W2799069368","https://openalex.org/W2911576101","https://openalex.org/W2984315402","https://openalex.org/W3128761669","https://openalex.org/W3136319525","https://openalex.org/W3138493698","https://openalex.org/W3210861663","https://openalex.org/W4205358167","https://openalex.org/W4282836010","https://openalex.org/W6637486922","https://openalex.org/W6790392843"],"related_works":["https://openalex.org/W2488897859","https://openalex.org/W2036213524","https://openalex.org/W1591147808","https://openalex.org/W2093683727","https://openalex.org/W1980146226","https://openalex.org/W2088566334","https://openalex.org/W3175984090","https://openalex.org/W3163376028","https://openalex.org/W2116283643","https://openalex.org/W3006648805"],"abstract_inverted_index":{"Given":[0],"the":[1,35,55,65,85,95,141,148,179,197],"large":[2],"and":[3,9,70,78,87,109,122,133,147,157,191,214],"growing":[4],"volume":[5],"of":[6,12,19,67,90,97,104,126,144,150,200,222],"big":[7],"data":[8,211],"frequent":[10],"use":[11],"complex":[13],"analytical":[14,127],"queries,":[15],"understanding":[16],"energy":[17,49,124,158,198,206,223],"efficiency":[18],"query":[20],"processing":[21],"has":[22],"become":[23],"a":[24,116,169],"critical":[25],"research":[26],"issue,":[27],"as":[28],"highlighted":[29],"by":[30,186],"database":[31],"systems":[32],"papers":[33],"in":[34,64,182,220],"last":[36],"few":[37],"years.":[38],"Common":[39],"software":[40],"solutions":[41,60,105],"mainly":[42],"consider":[43],"IO":[44],"cost":[45,173],"models":[46],"to":[47,94,120],"estimate":[48],"consumption":[50,89,125,224],"when":[51,129],"executing":[52],"queries.":[53],"On":[54],"other":[56],"hand,":[57],"current":[58],"hardware":[59],"benefit":[61],"from":[62],"advances":[63],"development":[66],"green":[68],"components":[69],"their":[71],"associated":[72],"tuning":[73],"techniques,":[74],"especially":[75],"dynamic":[76],"voltage":[77],"frequency":[79,135,146,180],"scaling":[80,181],"(DVFS),":[81],"which":[82],"can":[83],"balance":[84],"performance":[86],"power":[88,156],"multicore":[91],"CPUs.":[92],"Unfortunately,":[93],"best":[96],"our":[98,176,217],"knowledge,":[99],"there":[100],"is":[101],"an":[102,163,201],"absence":[103],"mixing":[106],"both":[107],"(hardware":[108],"software).":[110],"Heeding":[111],"this":[112],"gap,":[113],"we":[114,161,195],"propose":[115],"novel":[117],"predictive":[118,165],"model":[119,166,174,204],"measure":[121],"predict":[123],"queries":[128],"using":[130,187],"multi-core":[131,183],"processors":[132],"different":[134],"configurations.":[136],"We":[137],"first":[138],"experimentally":[139],"illustrate":[140],"surprising":[142],"impact":[143],"CPU":[145],"number":[149],"processor":[151],"cores":[152],"on":[153],"execution":[154],"time,":[155],"consumption.":[159],"Second,":[160],"introduce":[162],"extended":[164],"that":[167],"enriches":[168],"well-known":[170],"machine":[171],"learning":[172],"with":[175,209],"new":[177],"angle,":[178],"environment.":[184],"Specifically,":[185],"Support":[188],"Vector":[189],"Regression":[190],"Random":[192],"Forest":[193],"Regression,":[194],"compute":[196],"coefficients":[199],"accurate":[202],"regression":[203],"for":[205],"prediction.":[207],"Experiments":[208],"benchmark":[210],"sets":[212],"TPC-H":[213],"TPC-DS":[215],"evaluate":[216],"proposed":[218],"framework":[219],"terms":[221],"reduction,":[225],"showing":[226],"promising":[227],"results.":[228]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}