{"id":"https://openalex.org/W2963349600","doi":"https://doi.org/10.48550/arxiv.0909.1767","title":"Towards Eco-friendly Database Management Systems","display_name":"Towards Eco-friendly Database Management Systems","alternate_titles":[],"publication_year":2009,"publication_date":"2009-09-09","ids":{"openalex":"https://openalex.org/W2963349600","doi":"https://doi.org/10.48550/arxiv.0909.1767","mag":"2963349600"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:0909.1767","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/0909.1767","pdf_url":"https://arxiv.org/pdf/0909.1767","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"parent_works":[],"lineage":["https://openalex.org/W2963349600"],"child_works_count":0,"type":"preprint","is_traditional":true,"indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/0909.1767","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5038895307","display_name":"Willis Lang","orcid":"https://orcid.org/0009-0005-0365-9892","observed_orcids":["https://orcid.org/0009-0005-0365-9892"]},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Lang, Willis","raw_affiliation_strings":["University of Wisconsin-Madiso","University of Wisconsin\u2013Madison, Madison, United States"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madiso","institution_ids":["https://openalex.org/I135310074"]},{"raw_affiliation_string":"University of Wisconsin\u2013Madison, Madison, United States","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5069237428","display_name":"Jignesh M. Patel","orcid":"https://orcid.org/0000-0003-3653-2538","observed_orcids":["https://orcid.org/0000-0003-3653-2538"]},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Patel, Jignesh","raw_affiliation_strings":["Wisconsin","University of Wisconsin-Madison, #TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Wisconsin","institution_ids":[]},{"raw_affiliation_string":"University of Wisconsin-Madison, #TAB#","institution_ids":["https://openalex.org/I135310074"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I135310074"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":86,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.6518999934196472,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.6518999934196472,"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/T14098","display_name":"Energy Efficiency in Computing","score":0.2736999988555908,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/T12238","display_name":"Green IT and Sustainability","score":0.0502999983727932,"subfield":{"id":"https://openalex.org/subfields/2208","display_name":"Electrical and Electronic Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/query-aggregation","display_name":"query aggregation","score":0.8399999737739563},{"id":"https://openalex.org/keywords/energy-performance-tradeoff","display_name":"energy-performance trade-off","score":0.6790000200271606},{"id":"https://openalex.org/keywords/response-time","display_name":"response time","score":0.6769999861717224},{"id":"https://openalex.org/keywords/mysql","display_name":"MySQL","score":0.5090000033378601}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.845379114151001},{"id":"https://openalex.org/C2780165032","wikidata":"https://www.wikidata.org/wiki/Q16869822","display_name":"Energy consumption","level":2,"score":0.8057394027709961},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6384074091911316},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.5874012112617493},{"id":"https://openalex.org/C19012869","wikidata":"https://www.wikidata.org/wiki/Q578372","display_name":"Response time","level":2,"score":0.5490050315856934},{"id":"https://openalex.org/C153083717","wikidata":"https://www.wikidata.org/wiki/Q6535263","display_name":"Leverage (statistics)","level":2,"score":0.548991322517395},{"id":"https://openalex.org/C2742236","wikidata":"https://www.wikidata.org/wiki/Q924713","display_name":"Efficient energy use","level":2,"score":0.5345014929771423},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.32123517990112305},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2690584659576416},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","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/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","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},{"id":"https://openalex.org/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"pmh:oai:arXiv.org:0909.1767","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/0909.1767","pdf_url":"https://arxiv.org/pdf/0909.1767","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"doi:10.48550/arxiv.0909.1767","doi":"https://doi.org/10.48550/arxiv.0909.1767","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.0909.1767","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"},{"id":"mag:2963349600","doi":null,"is_oa":false,"landing_page_url":"http://pages.cs.wisc.edu/~jignesh/publ/ecoDB.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S4306418070","display_name":"Conference on Innovative Data Systems Research","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Conference on Innovative Data Systems Research","raw_type":null},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.145.945","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.145.945","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www-db.cs.wisc.edu/cidr/cidr2009/Paper_51.pdf","raw_type":"text"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:0909.1767","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/0909.1767","pdf_url":"https://arxiv.org/pdf/0909.1767","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2963349600.pdf","grobid_xml":"https://content.openalex.org/works/W2963349600.grobid-xml"},"referenced_works_count":11,"referenced_works":["https://openalex.org/W2008633193","https://openalex.org/W2058978608","https://openalex.org/W2085930856","https://openalex.org/W2103565249","https://openalex.org/W2107751141","https://openalex.org/W2118955868","https://openalex.org/W2122465391","https://openalex.org/W2130805783","https://openalex.org/W2134807578","https://openalex.org/W2173213060","https://openalex.org/W7098745455"],"related_works":["https://openalex.org/W2959063876","https://openalex.org/W2972984985","https://openalex.org/W2594861944","https://openalex.org/W3128761669","https://openalex.org/W2170965549","https://openalex.org/W4415721565","https://openalex.org/W2020290119","https://openalex.org/W2539244828","https://openalex.org/W4409561744"],"abstract_inverted_index":{"Database":[0],"management":[1],"systems":[2],"(DBMSs)":[3],"have":[4],"largely":[5],"ignored":[6],"the":[7,11,69,85,130,137,142,210],"task":[8],"of":[9,87,110,136,162,213],"managing":[10],"energy":[12,30,41,70,75,132,153,188],"consumed":[13],"during":[14],"query":[15,49,104],"processing.":[16,216],"Both":[17,72],"economical":[18],"and":[19,96,122],"environmental":[20],"factors":[21],"now":[22],"require":[23],"that":[24,59,126,175],"DBMSs":[25],"pay":[26],"close":[27],"attention":[28],"to":[29,66,90,106,180],"consumption.":[31,71],"In":[32,200],"this":[33,37,201],"paper":[34,202],"we":[35,124,173,203],"approach":[36],"issue":[38],"by":[39,63,134,145,155,190],"considering":[40],"consumption":[42,76,133,139,154,189],"as":[43],"a":[44,52,64,113,119,158,193],"first-class":[45],"performance":[46],"goal":[47],"for":[48,77,185,192],"processing":[50],"in":[51,112,196,209],"DBMS.":[53],"We":[54],"present":[55],"two":[56],"concrete":[57],"techniques":[58,73],"can":[60,128,151,177],"be":[61,178],"used":[62,179],"DBMS":[65,121],"directly":[67],"manage":[68],"trade":[74,182],"performance.":[78],"The":[79,98],"first":[80],"technique,":[81,100],"called":[82,101],"PVC,":[83],"leverages":[84],"ability":[86],"modern":[88],"processors":[89],"execute":[91],"at":[92],"lower":[93],"processor":[94,131],"voltage":[95],"frequency.":[97],"second":[99],"QED,":[102],"uses":[103],"aggregation":[105],"leverage":[107],"common":[108],"components":[109],"queries":[111,168],"workload.":[114],"Using":[115],"experiments":[116],"run":[117],"on":[118],"commercial":[120],"MySQL,":[123,149],"show":[125,174],"PVC":[127,150],"reduce":[129,152],"49%":[135],"original":[138],"while":[140],"increasing":[141],"response":[143,159,183,198],"time":[144,160,184],"only":[146,163],"3%.":[147],"On":[148],"20%":[156],"with":[157,169],"penalty":[161],"6%.":[164],"For":[165],"simple":[166],"selection":[167],"no":[170],"predicate":[171],"overlap,":[172],"QED":[176],"gracefully":[181],"energy,":[186],"reducing":[187],"54%":[191],"43%":[194],"increase":[195],"average":[197],"time.":[199],"also":[204],"highlight":[205],"some":[206],"research":[207],"issues":[208],"emerging":[211],"area":[212],"energy-efficient":[214],"data":[215]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2963349600","counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":5},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":6},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":7},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":7},{"year":2014,"cited_by_count":10},{"year":2013,"cited_by_count":10},{"year":2012,"cited_by_count":10}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2019-07-30T00:00:00"}
