{"id":"https://openalex.org/W2894630172","doi":"https://doi.org/10.1109/tpds.2018.2874014","title":"GreenDB: Energy-Efficient Prefetching and Caching in Database Clusters","display_name":"GreenDB: Energy-Efficient Prefetching and Caching in Database Clusters","publication_year":2018,"publication_date":"2018-10-04","ids":{"openalex":"https://openalex.org/W2894630172","doi":"https://doi.org/10.1109/tpds.2018.2874014","mag":"2894630172"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1109/tpds.2018.2874014","pdf_url":null,"source":{"id":"https://openalex.org/S97130795","display_name":"IEEE Transactions on Parallel and Distributed Systems","issn_l":"1045-9219","issn":["1045-9219","1558-2183","2161-9883"],"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":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"journal-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/A5100753053","display_name":"Yi Zhou","orcid":null},"institutions":[{"id":"https://openalex.org/I199172307","display_name":"Columbus State University","ror":"https://ror.org/002nf6z37","country_code":"US","type":"education","lineage":["https://openalex.org/I199172307"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yi Zhou","raw_affiliation_strings":["TSYS School of Computer Science, Columbus State University, 4225 University Avenue, Columbus, GA, USA"],"affiliations":[{"raw_affiliation_string":"TSYS School of Computer Science, Columbus State University, 4225 University Avenue, Columbus, GA, USA","institution_ids":["https://openalex.org/I199172307"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5020988249","display_name":"Shubbhi Taneja","orcid":"https://orcid.org/0000-0002-2403-9407"},"institutions":[{"id":"https://openalex.org/I158011677","display_name":"Sonoma State University","ror":"https://ror.org/04wjxkk25","country_code":"US","type":"education","lineage":["https://openalex.org/I158011677"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Shubbhi Taneja","raw_affiliation_strings":["Department of Computer Science, Sonoma State University, CA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Sonoma State University, CA","institution_ids":["https://openalex.org/I158011677"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101769884","display_name":"Chaowei Zhang","orcid":"https://orcid.org/0000-0002-4165-9552"},"institutions":[{"id":"https://openalex.org/I82497590","display_name":"Auburn University","ror":"https://ror.org/02v80fc35","country_code":"US","type":"education","lineage":["https://openalex.org/I82497590"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Chaowei Zhang","raw_affiliation_strings":["Department of Computer Science and Software Engineering, Auburn University, AL, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Software Engineering, Auburn University, AL, USA","institution_ids":["https://openalex.org/I82497590"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5042766429","display_name":"Xiao Qin","orcid":"https://orcid.org/0000-0002-8345-3587"},"institutions":[{"id":"https://openalex.org/I82497590","display_name":"Auburn University","ror":"https://ror.org/02v80fc35","country_code":"US","type":"education","lineage":["https://openalex.org/I82497590"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xiao Qin","raw_affiliation_strings":["Department of Computer Science and Software Engineering, Auburn University, AL, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Software Engineering, Auburn University, AL, USA","institution_ids":["https://openalex.org/I82497590"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.077,"has_fulltext":true,"fulltext_origin":"ngrams","cited_by_count":12,"citation_normalized_percentile":{"value":0.962907,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":86,"max":87},"biblio":{"volume":"30","issue":"5","first_page":"1091","last_page":"1104"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":1.0,"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":1.0,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9989,"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/T11478","display_name":"Caching and Content Delivery","score":0.9989,"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/table","display_name":"Table (database)","score":0.5108144}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.86782646},{"id":"https://openalex.org/C2742236","wikidata":"https://www.wikidata.org/wiki/Q924713","display_name":"Efficient energy use","level":2,"score":0.6493224},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.63655454},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5789158},{"id":"https://openalex.org/C2780165032","wikidata":"https://www.wikidata.org/wiki/Q16869822","display_name":"Energy consumption","level":2,"score":0.5603471},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.52037114},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5108144},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.45723212},{"id":"https://openalex.org/C2778774385","wikidata":"https://www.wikidata.org/wiki/Q4437810","display_name":"Power management","level":3,"score":0.4337524},{"id":"https://openalex.org/C164866538","wikidata":"https://www.wikidata.org/wiki/Q367351","display_name":"Cluster (spacecraft)","level":2,"score":0.410052},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.4043092},{"id":"https://openalex.org/C163258240","wikidata":"https://www.wikidata.org/wiki/Q25342","display_name":"Power (physics)","level":2,"score":0.324226},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.3196668},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.26121992},{"id":"https://openalex.org/C119599485","wikidata":"https://www.wikidata.org/wiki/Q43035","display_name":"Electrical engineering","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/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","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/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","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/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1109/tpds.2018.2874014","pdf_url":null,"source":{"id":"https://openalex.org/S97130795","display_name":"IEEE Transactions on Parallel and Distributed Systems","issn_l":"1045-9219","issn":["1045-9219","1558-2183","2161-9883"],"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":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/7","display_name":"Affordable and clean energy","score":0.9}],"grants":[{"funder":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation","award_id":"CNS-0917137"},{"funder":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation","award_id":"IIS-1618669"},{"funder":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation","award_id":"CCF-0845257"}],"datasets":[],"versions":[],"referenced_works_count":30,"referenced_works":["https://openalex.org/W1485641553","https://openalex.org/W1527821982","https://openalex.org/W1544262444","https://openalex.org/W1584812882","https://openalex.org/W1586956242","https://openalex.org/W1594176915","https://openalex.org/W1677915453","https://openalex.org/W1977183758","https://openalex.org/W2020290119","https://openalex.org/W2021689699","https://openalex.org/W2063259549","https://openalex.org/W2079521996","https://openalex.org/W2101161250","https://openalex.org/W2117079933","https://openalex.org/W2120881346","https://openalex.org/W2124942711","https://openalex.org/W2127286557","https://openalex.org/W2128472672","https://openalex.org/W2130104887","https://openalex.org/W2143705506","https://openalex.org/W2148459868","https://openalex.org/W2163454967","https://openalex.org/W2164145049","https://openalex.org/W2168843283","https://openalex.org/W2203404336","https://openalex.org/W2315342500","https://openalex.org/W2399794586","https://openalex.org/W2492448646","https://openalex.org/W2594794757","https://openalex.org/W2752365584"],"related_works":["https://openalex.org/W986318368","https://openalex.org/W2990194547","https://openalex.org/W2384410913","https://openalex.org/W2352878646","https://openalex.org/W2130149817","https://openalex.org/W2004734601","https://openalex.org/W2000785801","https://openalex.org/W1993210935","https://openalex.org/W179829755","https://openalex.org/W1480123525"],"abstract_inverted_index":{"In":[0],"this":[1],"study,":[2],"we":[3],"propose":[4],"an":[5,73],"energy-efficient":[6],"database":[7,32,88],"system":[8,147],"called":[9],"GreenDB":[10,14,34,55,81,119,141],"running":[11],"on":[12],"clusters.":[13,89],"applies":[15],"a":[16,25,31],"workload-skewness":[17],"strategy":[18,108],"by":[19,128,145],"managing":[20],"hot":[21,40],"nodes":[22,29,46],"coupled":[23],"with":[24,109],"set":[26],"of":[27,62,98,124,140,155,158],"cold":[28,45],"in":[30,47,51,87,96,113],"cluster.":[33],"fetches":[35],"popular":[36],"data":[37],"tables":[38],"to":[39,43,58,82,130],"nodes,":[41,156],"aiming":[42],"keep":[44],"the":[48,60,84,110,121,125,137],"low-power":[49],"mode":[50],"increased":[52],"time":[53],"periods.":[54],"is":[56],"conducive":[57],"reducing":[59],"number":[61,154,157],"power-state":[63],"transitions,":[64],"thereby":[65],"lowering":[66],"energy-saving":[67],"overhead.":[68],"A":[69],"prefetching":[70,107],"model":[71,76],"and":[72,101,160],"energy":[74,94,122,138],"saving":[75],"are":[77],"seamlessly":[78],"integrated":[79],"into":[80],"facilitate":[83],"power":[85],"management":[86],"We":[90,104],"quantitatively":[91],"evaluate":[92],"GreenDB's":[93,106],"efficiency":[95,139],"terms":[97],"managing,":[99],"fetching,":[100],"storing":[102],"data.":[103],"compare":[105],"one":[111],"implemented":[112],"Postgresql.":[114],"Experimental":[115],"results":[116],"indicate":[117],"that":[118,136],"conserves":[120],"consumption":[123],"existing":[126],"solution":[127],"up":[129],"98.4":[131],"percent.":[132],"The":[133],"findings":[134],"show":[135],"can":[142],"be":[143],"optimized":[144],"tuning":[146],"parameters,":[148],"including":[149],"table":[150],"size,":[151],"hit":[152],"rates,":[153],"disks,":[159],"inter-arrival":[161],"delays.":[162]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2894630172","counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":3}],"updated_date":"2025-01-02T11:06:38.437744","created_date":"2018-10-12"}