{"id":"https://openalex.org/W1982547447","doi":"https://doi.org/10.1109/tc.2015.2394309","title":"Online Energy Estimation of Relational Operations in Database Systems","display_name":"Online Energy Estimation of Relational Operations in Database Systems","publication_year":2015,"publication_date":"2015-01-27","ids":{"openalex":"https://openalex.org/W1982547447","doi":"https://doi.org/10.1109/tc.2015.2394309","mag":"1982547447"},"language":"en","primary_location":{"id":"doi:10.1109/tc.2015.2394309","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tc.2015.2394309","pdf_url":null,"source":{"id":"https://openalex.org/S157670870","display_name":"IEEE Transactions on Computers","issn_l":"0018-9340","issn":["0018-9340","0016-9340","1557-9956","2326-3814"],"is_oa":false,"is_in_doaj":false,"is_core":true,"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":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Computers","raw_type":"journal-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/A5041407793","display_name":"Zichen Xu","orcid":"https://orcid.org/0000-0001-9293-8028"},"institutions":[{"id":"https://openalex.org/I52357470","display_name":"The Ohio State University","ror":"https://ror.org/00rs6vg23","country_code":"US","type":"education","lineage":["https://openalex.org/I52357470"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zichen Xu","raw_affiliation_strings":["Department of Electrical and Computer Engineering, The Ohio State University, Columbus, OH","[Dept. of Electrical and Computer, Engineering, The Ohio State University, Columbus, OH]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Electrical and Computer Engineering, The Ohio State University, Columbus, OH","institution_ids":["https://openalex.org/I52357470"]},{"raw_affiliation_string":"[Dept. of Electrical and Computer, Engineering, The Ohio State University, Columbus, OH]","institution_ids":["https://openalex.org/I52357470"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5032673243","display_name":"Yi-Cheng Tu","orcid":"https://orcid.org/0000-0002-4062-2694"},"institutions":[{"id":"https://openalex.org/I2613432","display_name":"University of South Florida","ror":"https://ror.org/032db5x82","country_code":"US","type":"education","lineage":["https://openalex.org/I2613432"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yi-Cheng Tu","raw_affiliation_strings":["Department of Computer Science and Engineering, University of South Florida, Tampa, FL","Department of Computer Science & Engineering, University of South Florida, Tampa, FL#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, University of South Florida, Tampa, FL","institution_ids":["https://openalex.org/I2613432"]},{"raw_affiliation_string":"Department of Computer Science & Engineering, University of South Florida, Tampa, FL#TAB#","institution_ids":["https://openalex.org/I2613432"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100658019","display_name":"Xiaorui Wang","orcid":"https://orcid.org/0000-0001-9633-1418"},"institutions":[{"id":"https://openalex.org/I52357470","display_name":"The Ohio State University","ror":"https://ror.org/00rs6vg23","country_code":"US","type":"education","lineage":["https://openalex.org/I52357470"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xiaorui Wang","raw_affiliation_strings":["Department of Electrical and Computer Engineering, The Ohio State University, Columbus, OH","[Dept. of Electrical and Computer, Engineering, The Ohio State University, Columbus, OH]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Electrical and Computer Engineering, The Ohio State University, Columbus, OH","institution_ids":["https://openalex.org/I52357470"]},{"raw_affiliation_string":"[Dept. of Electrical and Computer, Engineering, The Ohio State University, Columbus, OH]","institution_ids":["https://openalex.org/I52357470"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":4.8758,"has_fulltext":false,"cited_by_count":24,"citation_normalized_percentile":{"value":0.95037273,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":93,"max":98},"biblio":{"volume":"64","issue":"11","first_page":"3223","last_page":"3236"},"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.9998000264167786,"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.9998000264167786,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9954000115394592,"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.9932000041007996,"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.8367500305175781},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.834135115146637},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.620606541633606},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.5434343218803406},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5353937745094299},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.5163310766220093},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.514244019985199},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5129448771476746},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.49779319763183594},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.4617170989513397},{"id":"https://openalex.org/keywords/energy-consumption","display_name":"Energy consumption","score":0.4534298777580261},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.44834089279174805},{"id":"https://openalex.org/keywords/energy","display_name":"Energy (signal processing)","score":0.447956919670105},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.43039095401763916},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4250809848308563},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.20515358448028564},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.196923166513443},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.10361486673355103}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8367500305175781},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.834135115146637},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.620606541633606},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.5434343218803406},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5353937745094299},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.5163310766220093},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.514244019985199},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5129448771476746},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.49779319763183594},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.4617170989513397},{"id":"https://openalex.org/C2780165032","wikidata":"https://www.wikidata.org/wiki/Q16869822","display_name":"Energy consumption","level":2,"score":0.4534298777580261},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.44834089279174805},{"id":"https://openalex.org/C186370098","wikidata":"https://www.wikidata.org/wiki/Q442787","display_name":"Energy (signal processing)","level":2,"score":0.447956919670105},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.43039095401763916},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4250809848308563},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.20515358448028564},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.196923166513443},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.10361486673355103},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","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/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/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tc.2015.2394309","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tc.2015.2394309","pdf_url":null,"source":{"id":"https://openalex.org/S157670870","display_name":"IEEE Transactions on Computers","issn_l":"0018-9340","issn":["0018-9340","0016-9340","1557-9956","2326-3814"],"is_oa":false,"is_in_doaj":false,"is_core":true,"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":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Computers","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4099999964237213,"id":"https://metadata.un.org/sdg/7","display_name":"Affordable and clean energy"}],"awards":[{"id":"https://openalex.org/G1416055158","display_name":null,"funder_award_id":"CSR-1143607","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G4720044567","display_name":null,"funder_award_id":"IIS-1117699","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G4726913513","display_name":null,"funder_award_id":"IIS-1156435","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":58,"referenced_works":["https://openalex.org/W184075017","https://openalex.org/W757205093","https://openalex.org/W1024946574","https://openalex.org/W1533943721","https://openalex.org/W1544509019","https://openalex.org/W1678315924","https://openalex.org/W1836162701","https://openalex.org/W1852059679","https://openalex.org/W1905105378","https://openalex.org/W1973892824","https://openalex.org/W1977570286","https://openalex.org/W1985393821","https://openalex.org/W1988344165","https://openalex.org/W1991271936","https://openalex.org/W1994100271","https://openalex.org/W2000682045","https://openalex.org/W2002552415","https://openalex.org/W2009872315","https://openalex.org/W2010082999","https://openalex.org/W2024446827","https://openalex.org/W2045350099","https://openalex.org/W2060458052","https://openalex.org/W2064359039","https://openalex.org/W2085930856","https://openalex.org/W2092614923","https://openalex.org/W2097964682","https://openalex.org/W2098395496","https://openalex.org/W2099786809","https://openalex.org/W2103485348","https://openalex.org/W2104947652","https://openalex.org/W2107961034","https://openalex.org/W2109546606","https://openalex.org/W2110100243","https://openalex.org/W2116436709","https://openalex.org/W2123664494","https://openalex.org/W2136244995","https://openalex.org/W2143705506","https://openalex.org/W2149813938","https://openalex.org/W2162462435","https://openalex.org/W2167786944","https://openalex.org/W2170965549","https://openalex.org/W2171762108","https://openalex.org/W2963349600","https://openalex.org/W2996833377","https://openalex.org/W3128761669","https://openalex.org/W4242216994","https://openalex.org/W4244451178","https://openalex.org/W4244593655","https://openalex.org/W4254943404","https://openalex.org/W6607475950","https://openalex.org/W6622225394","https://openalex.org/W6637486922","https://openalex.org/W6638950451","https://openalex.org/W6639877576","https://openalex.org/W6661621978","https://openalex.org/W6675036873","https://openalex.org/W6675513775","https://openalex.org/W6790392843"],"related_works":["https://openalex.org/W2992414350","https://openalex.org/W2249768123","https://openalex.org/W3125756434","https://openalex.org/W2955368753","https://openalex.org/W2294818385","https://openalex.org/W185198413","https://openalex.org/W1971797742","https://openalex.org/W2186907183","https://openalex.org/W4281289408","https://openalex.org/W2250332863"],"abstract_inverted_index":{"Data":[0],"centers":[1],"are":[2,14,157],"well":[3],"known":[4],"to":[5],"consume":[6],"a":[7,21,62,79,101,105,117,120,160,168,179],"large":[8],"amount":[9],"of":[10,16,37,41,69,81,87,100,107,132],"energy.":[11],"As":[12,97],"databases":[13],"one":[15],"the":[17,38,65,98,113,125,130],"major":[18],"applications":[19],"in":[20,48,159],"data":[22],"center,":[23],"building":[24,78],"energy-aware":[25],"database":[26,42,162],"systems":[27,43],"has":[28],"become":[29],"an":[30,45,142],"active":[31],"research":[32],"topic":[33],"recently.":[34],"The":[35,172],"quantification":[36],"energy":[39,66,85,122,198],"cost":[40,67],"is":[44,104],"important":[46],"task":[47],"design.":[49],"In":[50],"this":[51,59],"paper,":[52],"we":[53,111,140],"report":[54],"our":[55,176],"recent":[56],"efforts":[57],"on":[58,64,92,151,167],"issue,":[60],"with":[61,195],"focus":[63],"estimation":[68,86],"query":[70,73,102,193],"plans":[71,194],"during":[72],"optimization.":[74],"We":[75],"start":[76],"from":[77],"series":[80],"physical":[82,114,169],"models":[83,115,156,189],"for":[84,119,124],"individual":[88],"relational":[89,109],"operators":[90],"based":[91,150],"their":[93],"resource":[94],"consumption":[95],"patterns.":[96],"execution":[99],"plan":[103],"combination":[106],"multiple":[108],"operators,":[110],"use":[112],"as":[116],"basis":[118],"comprehensive":[121],"model":[123,148],"entire":[126],"query.":[127],"To":[128],"address":[129],"challenge":[131],"maintaining":[133],"accuracy":[134,181],"under":[135],"system":[136,164],"and":[137,165],"workload":[138],"dynamics,":[139],"develop":[141],"online":[143],"scheme":[144],"that":[145,175],"dynamically":[146],"adjusts":[147],"parameters":[149],"statistical":[152],"signal":[153],"modeling.":[154],"Our":[155,188],"implemented":[158],"real":[161],"management":[163],"evaluated":[166],"test":[170],"bed.":[171],"results":[173],"show":[174],"solution":[177],"achieves":[178],"high":[180],"(worst-case":[182],"error":[183],"13.7":[184],"percent)":[185],"despite":[186],"noises.":[187],"also":[190],"help":[191],"identify":[192],"significantly":[196],"higher":[197],"efficiency.":[199]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":3},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":2}],"updated_date":"2026-02-19T06:27:42.648592","created_date":"2025-10-10T00:00:00"}