{"id":"https://openalex.org/W3138493698","doi":"https://doi.org/10.1109/bigdata50022.2020.9377819","title":"Towards Green Query Processing - Auditing Power Before Deploying","display_name":"Towards Green Query Processing - Auditing Power Before Deploying","publication_year":2020,"publication_date":"2020-12-10","ids":{"openalex":"https://openalex.org/W3138493698","doi":"https://doi.org/10.1109/bigdata50022.2020.9377819","mag":"3138493698"},"language":"en","primary_location":{"id":"doi:10.1109/bigdata50022.2020.9377819","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata50022.2020.9377819","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/A5087683683","display_name":"Simon Pierre Dembele","orcid":"https://orcid.org/0000-0001-9203-0562"},"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":true,"raw_author_name":"Simon Pierre Dembele","raw_affiliation_strings":["LIAS/ISAE-ENSMA, France"],"affiliations":[{"raw_affiliation_string":"LIAS/ISAE-ENSMA, 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":["LIAS/ISAE-ENSMA, France"],"affiliations":[{"raw_affiliation_string":"LIAS/ISAE-ENSMA, France","institution_ids":["https://openalex.org/I171246369"]}]},{"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, USA"],"affiliations":[{"raw_affiliation_string":"University of Houston, USA","institution_ids":["https://openalex.org/I44461941"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5087683683"],"corresponding_institution_ids":["https://openalex.org/I171246369"],"apc_list":null,"apc_paid":null,"fwci":2.1352,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.9077134,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"2492","last_page":"2501"},"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.9990000128746033,"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.9990000128746033,"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/T12292","display_name":"Graph Theory and Algorithms","score":0.9973000288009644,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9969000220298767,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7077044248580933},{"id":"https://openalex.org/keywords/audit","display_name":"Audit","score":0.6537575125694275},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5549147129058838},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.42598995566368103},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.33796167373657227},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.1220737099647522},{"id":"https://openalex.org/keywords/accounting","display_name":"Accounting","score":0.10945841670036316}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7077044248580933},{"id":"https://openalex.org/C199521495","wikidata":"https://www.wikidata.org/wiki/Q181487","display_name":"Audit","level":2,"score":0.6537575125694275},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5549147129058838},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.42598995566368103},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.33796167373657227},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.1220737099647522},{"id":"https://openalex.org/C121955636","wikidata":"https://www.wikidata.org/wiki/Q4116214","display_name":"Accounting","level":1,"score":0.10945841670036316}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/bigdata50022.2020.9377819","is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata50022.2020.9377819","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"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/7","score":0.8799999952316284,"display_name":"Affordable and clean energy"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":42,"referenced_works":["https://openalex.org/W1605827952","https://openalex.org/W1678315924","https://openalex.org/W1821730416","https://openalex.org/W1936410615","https://openalex.org/W1966533006","https://openalex.org/W1994100271","https://openalex.org/W2002552415","https://openalex.org/W2026676775","https://openalex.org/W2042370186","https://openalex.org/W2092614923","https://openalex.org/W2118659595","https://openalex.org/W2129147768","https://openalex.org/W2143705506","https://openalex.org/W2157666539","https://openalex.org/W2198249415","https://openalex.org/W2284351912","https://openalex.org/W2294209438","https://openalex.org/W2467826469","https://openalex.org/W2539244828","https://openalex.org/W2582107883","https://openalex.org/W2592638109","https://openalex.org/W2594861944","https://openalex.org/W2736578080","https://openalex.org/W2747076629","https://openalex.org/W2757140470","https://openalex.org/W2798102897","https://openalex.org/W2799069368","https://openalex.org/W2803920407","https://openalex.org/W2811042349","https://openalex.org/W2912995176","https://openalex.org/W2931606697","https://openalex.org/W2963078671","https://openalex.org/W2984315402","https://openalex.org/W3008485252","https://openalex.org/W3014008218","https://openalex.org/W3128761669","https://openalex.org/W4214894150","https://openalex.org/W4233478165","https://openalex.org/W4301700300","https://openalex.org/W6637486922","https://openalex.org/W6775689629","https://openalex.org/W6790392843"],"related_works":["https://openalex.org/W2096359267","https://openalex.org/W2006459955","https://openalex.org/W2146885082","https://openalex.org/W3001245047","https://openalex.org/W2572349046","https://openalex.org/W4386051213","https://openalex.org/W185198413","https://openalex.org/W3125756434","https://openalex.org/W3049728138","https://openalex.org/W1873153460"],"abstract_inverted_index":{"Nowadays,":[0],"energy":[1,68,93,167],"reduction":[2],"has":[3],"become":[4],"a":[5,122,137,170,173,186],"critical":[6],"and":[7,48,78,90,94,111,126,156,176,209,211,217],"urgent":[8],"issue":[9],"for":[10,23],"the":[11,65,84,87,99,143,182,192,215,218,221],"database":[12],"community.":[13],"A":[14,60],"lot":[15],"of":[16,62,67,108,136,149,161,179,181,194,220],"initiatives":[17],"have":[18,83],"been":[19],"launched":[20],"on":[21,172,200],"energy-efficiency":[22],"intensive-workload":[24],"computation":[25,35],"covering":[26],"individual":[27],"hardware":[28,77,155],"components,":[29,158],"system":[30],"software,":[31],"to":[32,50,154],"applications.":[33],"This":[34,102],"is":[36],"mainly":[37],"ensured":[38],"by":[39,57],"query":[40,70,124,144,171],"optimizers.":[41],"Their":[42],"current":[43],"versions":[44],"minimize":[45],"inputs-outputs":[46],"operations":[47],"try":[49],"exploit":[51],"RAM":[52],"as":[53,55],"much":[54],"possible,":[56],"ignoring":[58],"energy.":[59],"couple":[61],"studies":[63],"proposed":[64],"integration":[66],"into":[69,76],"optimizers":[71],"that":[72,86,118,140],"can":[73],"be":[74],"classified":[75],"software":[79,96,157],"solutions.":[80],"Several":[81],"researchers":[82],"idea":[85],"operating":[88,109],"systems":[89,110],"firmware":[91],"manage":[92],"put":[95],"solutions":[97],"in":[98],"second":[100],"plan.":[101],"does":[103],"not":[104],"distinguish":[105],"between":[106],"tasks":[107],"DBMSs.":[112],"In":[113],"this":[114,195],"paper,":[115],"we":[116,197],"claim":[117],"building":[119],"from":[120],"scratch":[121],"green":[123],"processors":[125],"revisiting":[127],"existing":[128],"ones":[129],"pass":[130],"through":[131],"4-steps":[132],"procedure:":[133],"(1)":[134],"establishment":[135],"deep":[138],"audit":[139],"allows":[141],"understanding":[142],"processor":[145],"functioning,":[146],"(2)":[147],"identification":[148],"relevant":[150],"energy-sensitive":[151,183],"parameters":[152,184],"belonging":[153],"(3)":[159],"elaboration":[160],"mathematical":[162],"cost":[163],"models":[164],"estimating":[165],"consumed":[166],"when":[168],"executing":[169],"target":[174],"DBMS":[175],"(4)":[177],"setting":[178],"values":[180],"using":[185,214],"nonlinear":[187],"regression":[188],"technique.":[189],"To":[190],"show":[191],"effectiveness":[193],"procedure,":[196],"apply":[198],"it":[199],"two":[201],"open-source":[202],"DBMSs":[203],"with":[204],"different":[205],"functioning":[206],"policies:":[207],"PostgreSQL":[208],"MonetDB":[210],"compared":[212],"them":[213],"dataset":[216],"workload":[219],"TPC-H":[222],"benchmark.":[223]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}