{"id":"https://openalex.org/W2072590764","doi":"https://doi.org/10.1093/comjnl/bxl028","title":"Automated Configuration of Multiple Buffer Pools","display_name":"Automated Configuration of Multiple Buffer Pools","alternate_titles":[],"publication_year":2006,"publication_date":"2006-05-23","ids":{"openalex":"https://openalex.org/W2072590764","doi":"https://doi.org/10.1093/comjnl/bxl028","mag":"2072590764"},"language":"en","primary_location":{"id":"doi:10.1093/comjnl/bxl028","doi":"https://doi.org/10.1093/comjnl/bxl028","is_oa":false,"landing_page_url":"https://doi.org/10.1093/comjnl/bxl028","pdf_url":null,"source":{"id":"https://openalex.org/S44643521","display_name":"The Computer Journal","issn_l":"0010-4620","issn":["0010-4620","1460-2067"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-b","cwts-core","dongbi-c","jufo-1","norway-1","poland-40","russia-white-list-2","vabb-shw"],"host_organization":"https://openalex.org/P4310311648","host_organization_name":"Oxford University Press","host_organization_lineage":["https://openalex.org/P4310311648","https://openalex.org/P4310311647"],"host_organization_lineage_names":["Oxford University Press","University of Oxford"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The Computer Journal","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2072590764"],"child_works_count":0,"type":"article","is_traditional":true,"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/A5049754266","display_name":"Patrick Martin","orcid":"https://orcid.org/0000-0003-3210-9441","observed_orcids":["https://orcid.org/0000-0003-3210-9441"]},"institutions":[{"id":"https://openalex.org/I204722609","display_name":"Queen's University","ror":"https://ror.org/02y72wh86","country_code":"CA","type":"education","lineage":["https://openalex.org/I204722609"]}],"countries":["CA"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"P. Martin","raw_affiliation_strings":["School of Computing, Queen's University, Kingston, Ontario, Canada, K7L 3N6"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computing, Queen's University, Kingston, Ontario, Canada, K7L 3N6","institution_ids":["https://openalex.org/I204722609"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5049754266"],"corresponding_institution_ids":["https://openalex.org/I204722609"],"apc_list":{"value":2877,"currency":"GBP","value_usd":3794},"apc_paid":null,"fwci":2.1761,"has_fulltext":false,"cited_by_count":7,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.88616441,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":92,"max":95},"biblio":{"volume":"49","issue":"4","first_page":"487","last_page":"499"},"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.9980000257492065,"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.9980000257492065,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.0006000000284984708,"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.00039999998989515007,"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/database-management-systems","display_name":"database management systems","score":0.6359999775886536},{"id":"https://openalex.org/keywords/workload-analysis","display_name":"workload characterization","score":0.8700000047683716},{"id":"https://openalex.org/keywords/object-partitioning","display_name":"object partitioning","score":0.7319999933242798},{"id":"https://openalex.org/keywords/access-patterns","display_name":"access patterns","score":0.7049999833106995},{"id":"https://openalex.org/keywords/greedy-algorithm","display_name":"greedy algorithm","score":0.9010000228881836},{"id":"https://openalex.org/keywords/database-tuning","display_name":"database performance tuning","score":0.5009999871253967}],"concepts":[{"id":"https://openalex.org/C145018004","wikidata":"https://www.wikidata.org/wiki/Q4985944","display_name":"Buffer (optical fiber)","level":2,"score":0.8749536275863647},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8629628419876099},{"id":"https://openalex.org/C89089495","wikidata":"https://www.wikidata.org/wiki/Q8038418","display_name":"Write buffer","level":5,"score":0.6969997882843018},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.561820387840271},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.5477288961410522},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5212598443031311},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.5096986293792725},{"id":"https://openalex.org/C85686653","wikidata":"https://www.wikidata.org/wiki/Q1224994","display_name":"Circular buffer","level":2,"score":0.47869589924812317},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.47496554255485535},{"id":"https://openalex.org/C2781238097","wikidata":"https://www.wikidata.org/wiki/Q175026","display_name":"Object (grammar)","level":2,"score":0.4664928913116455},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.4055248498916626},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.3010583519935608},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.26151910424232483},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.08013132214546204},{"id":"https://openalex.org/C189783530","wikidata":"https://www.wikidata.org/wiki/Q352090","display_name":"CPU cache","level":3,"score":0.07739201188087463},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.07264474034309387},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","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},{"id":"https://openalex.org/C38556500","wikidata":"https://www.wikidata.org/wiki/Q13404475","display_name":"Cache algorithms","level":4,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1093/comjnl/bxl028","doi":"https://doi.org/10.1093/comjnl/bxl028","is_oa":false,"landing_page_url":"https://doi.org/10.1093/comjnl/bxl028","pdf_url":null,"source":{"id":"https://openalex.org/S44643521","display_name":"The Computer Journal","issn_l":"0010-4620","issn":["0010-4620","1460-2067"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-b","cwts-core","dongbi-c","jufo-1","norway-1","poland-40","russia-white-list-2","vabb-shw"],"host_organization":"https://openalex.org/P4310311648","host_organization_name":"Oxford University Press","host_organization_lineage":["https://openalex.org/P4310311648","https://openalex.org/P4310311647"],"host_organization_lineage_names":["Oxford University Press","University of Oxford"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"The Computer Journal","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.99.2857","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.99.2857","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://comjnl.oxfordjournals.org/cgi/reprint/49/4/487.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W320896","https://openalex.org/W73246605","https://openalex.org/W1272147091","https://openalex.org/W1499399028","https://openalex.org/W1502949834","https://openalex.org/W1520638886","https://openalex.org/W1559215823","https://openalex.org/W1569974523","https://openalex.org/W1570896006","https://openalex.org/W1580054209","https://openalex.org/W1987225815","https://openalex.org/W1992419399","https://openalex.org/W1996676736","https://openalex.org/W2055958975","https://openalex.org/W2097630597","https://openalex.org/W2099023682","https://openalex.org/W2104999292","https://openalex.org/W2125358400","https://openalex.org/W2127085526","https://openalex.org/W2164893646","https://openalex.org/W2168503413"],"related_works":["https://openalex.org/W2104999292","https://openalex.org/W7097194498","https://openalex.org/W2122317274","https://openalex.org/W7098019193","https://openalex.org/W2383226856","https://openalex.org/W1480732106","https://openalex.org/W6989957561","https://openalex.org/W7135052735","https://openalex.org/W1502949834"],"abstract_inverted_index":{"Database":[0],"management":[1],"systems":[2],"(DBMSs)":[3],"use":[4],"a":[5,10,21,30,46,69,104,148,158],"main":[6],"memory":[7],"area":[8,28],"as":[9,185,187],"buffer":[11,27,34,48,55,65,75,93,111,128,143],"to":[12,45,64,91,114,153],"reduce":[13],"the":[14,26,54,59,74,101,126,141,155,167,172],"number":[15,31],"of":[16,32,52,61,73,103,157,163],"disk":[17],"accesses":[18],"performed":[19],"by":[20,175,190],"transaction.":[22],"Some":[23],"DBMSs":[24],"divide":[25],"into":[29,110,125],"independent":[33],"pools":[35,66,112,144],"and":[36,67,107,118,169],"each":[37,72],"database":[38,62,193],"object":[39],"(table":[40],"or":[41],"index)":[42],"is":[43,145],"assigned":[44],"specific":[47],"pool.":[49],"The":[50],"tasks":[51],"configuring":[53],"pools,":[56,76],"which":[57],"define":[58],"mapping":[60],"objects":[63,109,122,133],"setting":[68],"size":[70,138],"for":[71,79,140],"are":[77,123],"crucial":[78],"achieving":[80],"optimal":[81],"performance.":[82],"In":[83],"this":[84],"paper":[85],"we":[86],"describe":[87],"an":[88,191],"automated":[89],"approach":[90,168],"multiple":[92,142],"pool":[94],"configuration.":[95],"Our":[96],"approach,":[97],"called":[98],"BPCluster,":[99],"analyses":[100],"characteristics":[102],"given":[105],"workload":[106],"partitions":[108],"according":[113],"their":[115],"access":[116],"patterns":[117],"inherent":[119],"characteristics.":[120],"Similar":[121],"grouped":[124],"same":[127],"pool,":[129],"thus":[130],"separating":[131],"those":[132],"that":[134,151,171],"may":[135],"conflict.":[136],"A":[137,161],"configuration":[139],"determined":[146],"using":[147],"greedy":[149],"algorithm":[150],"attempts":[152],"minimize":[154],"cost":[156],"logical":[159],"read.":[160],"set":[162],"experimental":[164],"results":[165],"validate":[166],"show":[170],"configurations":[173,179,188],"suggested":[174,189],"BPCluster":[176],"outperform":[177],"na\u00efve":[178],"and,":[180],"in":[181],"most":[182],"cases,":[183],"perform":[184],"well":[186],"experienced":[192],"administrator.":[194]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2072590764","counts_by_year":[{"year":2025,"cited_by_count":2}],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2016-06-24T00:00:00"}
