{"id":"https://openalex.org/W11135144","doi":null,"title":"Buffer Pool Aware Query Optimization","display_name":"Buffer Pool Aware Query Optimization","alternate_titles":[],"publication_year":2005,"publication_date":"2005-01-01","ids":{"openalex":"https://openalex.org/W11135144","mag":"11135144"},"language":"en","primary_location":{"id":"mag:11135144","doi":null,"is_oa":false,"landing_page_url":"http://cidrdb.org/cidr2005/papers/P21.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},"parent_works":[],"lineage":["https://openalex.org/W11135144"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"indexed_in":[],"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/A5102149080","display_name":"Ravishankar Ramamurthy","orcid":null,"observed_orcids":[]},"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":"Ravishankar Ramamurthy","raw_affiliation_strings":["University of Wisconsin, Madison"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Wisconsin, Madison","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5055300310","display_name":"David J. DeWitt","orcid":"https://orcid.org/0009-0007-5037-5205","observed_orcids":["https://orcid.org/0009-0007-5037-5205"]},"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":"David J. DeWitt","raw_affiliation_strings":["University of Wisconsin, Madison"],"raw_orcid":"https://orcid.org/0009-0007-5037-5205","affiliations":[{"raw_affiliation_string":"University of Wisconsin, Madison","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":1.1415,"has_fulltext":false,"cited_by_count":22,"citation_normalized_percentile":{"value":0.76294657,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":92,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"250","last_page":"261"},"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.9970999956130981,"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.9970999956130981,"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/T11106","display_name":"Data Management and Algorithms","score":0.000699999975040555,"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.00019999999494757503,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/query-optimizer","display_name":"query optimizer","score":0.6050000190734863},{"id":"https://openalex.org/keywords/buffer-pool","display_name":"buffer pool","score":0.5870000123977661},{"id":"https://openalex.org/keywords/query-plan-selection","display_name":"query plan selection","score":0.7559999823570251},{"id":"https://openalex.org/keywords/64-bit-processors","display_name":"64-bit processors","score":0.8169999718666077},{"id":"https://openalex.org/keywords/database-server","display_name":"database server","score":0.8080000281333923}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8710715770721436},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7803267240524292},{"id":"https://openalex.org/C145018004","wikidata":"https://www.wikidata.org/wiki/Q4985944","display_name":"Buffer (optical fiber)","level":2,"score":0.7182484865188599},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.622099757194519},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.5166038274765015},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.514805018901825},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.464739054441452},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3809654116630554},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.3568059504032135},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.21879145503044128},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.20191216468811035},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.17333179712295532},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:11135144","doi":null,"is_oa":false,"landing_page_url":"http://cidrdb.org/cidr2005/papers/P21.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}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":19,"referenced_works":["https://openalex.org/W32321764","https://openalex.org/W1633637678","https://openalex.org/W1975731516","https://openalex.org/W2007069074","https://openalex.org/W2020584928","https://openalex.org/W2059877472","https://openalex.org/W2102116440","https://openalex.org/W2102166438","https://openalex.org/W2107887442","https://openalex.org/W2110631345","https://openalex.org/W2121866233","https://openalex.org/W2127069799","https://openalex.org/W2136390693","https://openalex.org/W2153329411","https://openalex.org/W2157979971","https://openalex.org/W2158237121","https://openalex.org/W2169012378","https://openalex.org/W2171903035","https://openalex.org/W2201552871"],"related_works":["https://openalex.org/W1557550158","https://openalex.org/W2177373506","https://openalex.org/W2143003759","https://openalex.org/W4244404287","https://openalex.org/W7097773649","https://openalex.org/W1987645871","https://openalex.org/W4238536395","https://openalex.org/W7096909957","https://openalex.org/W2159209233"],"abstract_inverted_index":{"With":[0],"the":[1,65,70,80],"advent":[2],"of":[3,52,72,83],"64-bit":[4],"processors,":[5],"large":[6],"main":[7],"memories":[8],"are":[9],"set":[10],"to":[11,19],"become":[12,50],"very":[13],"common.":[14],"This":[15,40],"in":[16,24,54,64,75],"turn":[17],"translates":[18],"larger":[20],"buffer":[21,48,66],"pool":[22,67],"configurations":[23],"database":[25],"servers.":[26],"Query":[27],"optimizers":[28],"however,":[29],"currently":[30],"assume":[31],"all":[32],"data":[33,62],"is":[34],"disk":[35],"resident":[36],"while":[37],"optimizing":[38],"queries.":[39],"assumption":[41],"will":[42],"no":[43],"longer":[44],"be":[45],"valid":[46],"when":[47],"pools":[49],"100\u2019s":[51],"gigabytes":[53],"size.":[55],"In":[56],"this":[57],"paper":[58],"we":[59],"examine":[60,79],"how":[61],"presence":[63],"can":[68],"affect":[69],"choice":[71],"query":[73,86],"plans":[74],"an":[76,96],"optimizer.":[77,97],"We":[78],"possible":[81],"benefits":[82],"buffer-pool":[84],"aware":[85],"optimization":[87],"and":[88],"propose":[89],"a":[90],"generic":[91],"architecture":[92],"for":[93],"implementing":[94],"such":[95]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W11135144","counts_by_year":[{"year":2018,"cited_by_count":2},{"year":2016,"cited_by_count":2},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":2}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
