{"id":"https://openalex.org/W2001623470","doi":"https://doi.org/10.1145/1739041.1739070","title":"Warm cache costing","display_name":"Warm cache costing","publication_year":2010,"publication_date":"2010-03-16","ids":{"openalex":"https://openalex.org/W2001623470","doi":"https://doi.org/10.1145/1739041.1739070","mag":"2001623470"},"language":"en","primary_location":{"id":"doi:10.1145/1739041.1739070","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1739041.1739070","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 13th International Conference on Extending Database Technology","raw_type":"proceedings-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/A5012233734","display_name":"H. S. Ramanujam","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"H. S. Ramanujam","raw_affiliation_strings":["Sybase Software India Pvt Ltd, Pune","Sybase Software India Pvt Ltd, Pune#TAB#"],"affiliations":[{"raw_affiliation_string":"Sybase Software India Pvt Ltd, Pune","institution_ids":[]},{"raw_affiliation_string":"Sybase Software India Pvt Ltd, Pune#TAB#","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5057269791","display_name":"Edwin Seputis","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Edwin Seputis","raw_affiliation_strings":["Sybase Inc., Dublin, CA"],"affiliations":[{"raw_affiliation_string":"Sybase Inc., Dublin, CA","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5012233734"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.11631851,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"219","last_page":"227"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998999834060669,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998999834060669,"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.9994999766349792,"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"}},{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9904000163078308,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8820676803588867},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.7797497510910034},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.7054018974304199},{"id":"https://openalex.org/keywords/activity-based-costing","display_name":"Activity-based costing","score":0.6572362184524536},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.6359537839889526},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.5871843695640564},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.5602709650993347},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.49337664246559143},{"id":"https://openalex.org/keywords/cpu-cache","display_name":"CPU cache","score":0.45877349376678467},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4365866184234619},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.34016725420951843},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.31763356924057007},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.21090751886367798},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.12843692302703857},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.11563798785209656}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8820676803588867},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.7797497510910034},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7054018974304199},{"id":"https://openalex.org/C164624739","wikidata":"https://www.wikidata.org/wiki/Q754331","display_name":"Activity-based costing","level":2,"score":0.6572362184524536},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.6359537839889526},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5871843695640564},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.5602709650993347},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.49337664246559143},{"id":"https://openalex.org/C189783530","wikidata":"https://www.wikidata.org/wiki/Q352090","display_name":"CPU cache","level":3,"score":0.45877349376678467},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4365866184234619},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.34016725420951843},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.31763356924057007},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.21090751886367798},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.12843692302703857},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.11563798785209656},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1739041.1739070","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1739041.1739070","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 13th International Conference on Extending Database Technology","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","score":0.47999998927116394,"id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W11135144","https://openalex.org/W1480809079","https://openalex.org/W1975731516","https://openalex.org/W2004806949","https://openalex.org/W2007069074","https://openalex.org/W2026896584","https://openalex.org/W2059877472","https://openalex.org/W2086681205","https://openalex.org/W2102166438","https://openalex.org/W2107102574","https://openalex.org/W2123209274","https://openalex.org/W2136195851","https://openalex.org/W2153329411","https://openalex.org/W2155166680","https://openalex.org/W2158237121","https://openalex.org/W2212047990","https://openalex.org/W4255671299"],"related_works":["https://openalex.org/W2941854747","https://openalex.org/W2006459955","https://openalex.org/W1977331029","https://openalex.org/W2955368753","https://openalex.org/W4361194359","https://openalex.org/W203907944","https://openalex.org/W3125756434","https://openalex.org/W1608254253","https://openalex.org/W4386051213","https://openalex.org/W2004087594"],"abstract_inverted_index":{"Most":[0],"modern":[1],"RDBMS":[2,39],"depend":[3],"on":[4,113],"the":[5,13,22,46,55,67,78,82,89,114,126,136,151,197,204,211],"query":[6,102,146,179,212],"processing":[7,213],"optimizer's":[8],"cost":[9,41],"model":[10,94,195,224],"to":[11,30,148,155,203,219],"choose":[12],"best":[14],"execution":[15,115],"plan":[16],"for":[17,99],"a":[18,27,96,107,130],"given":[19],"query.":[20],"Since":[21],"physical":[23],"IO":[24],"(PIO)":[25],"is":[26,48,62,106,133,217,225],"costly":[28],"operation":[29],"execute,":[31],"it":[32],"naturally":[33],"has":[34],"an":[35,228],"important":[36],"weight":[37],"in":[38,54,135,144,162,178,181,191,242],"classical":[40],"models,":[42],"which":[43,132],"assume":[44],"that":[45,173],"data":[47],"disk-resident":[49],"and":[50,87,185,215],"does":[51],"not":[52],"fit":[53],"available":[56],"main":[57,72],"memory.":[58],"However,":[59],"this":[60,74,223],"assumption":[61],"no":[63,201],"longer":[64],"true":[65],"with":[66,186],"advent":[68],"of":[69,80,129,199,227],"cheap":[70],"large":[71],"memories.In":[73],"paper,":[75],"we":[76],"discuss":[77],"importance":[79],"considering":[81],"buffer-cache":[83],"occupancy":[84],"during":[85],"optimization":[86,110,231,237],"propose":[88],"Warm":[90],"Cache":[91],"Costing":[92],"(WCC)":[93],"as":[95],"new":[97],"technique":[98],"buffer-pool":[100],"aware":[101],"optimization.":[103],"The":[104,122],"WCC-model":[105],"novel":[108],"feedback":[109,230,236],"technique,":[111],"based":[112],"statistics":[116],"by":[117],"learning":[118],"PIO-compensation":[119],"(PIOC)":[120],"factors.":[121],"PIOC":[123,140],"factor":[124],"defines":[125],"average":[127],"percentage":[128],"table":[131],"cached":[134],"buffer":[137,205],"pool.":[138],"These":[139],"factors":[141],"are":[142],"used":[143],"subsequent":[145],"optimizations":[147],"better":[149,156],"estimate":[150],"PIO,":[152],"thus":[153],"leading":[154],"plans.These":[157],"techniques":[158,234],"have":[159,171],"been":[160],"implemented":[161],"Sybase":[163],"Adaptive":[164],"Server":[165],"Enterprise":[166],"(ASE)":[167],"database":[168],"system.":[169],"We":[170],"observed":[172],"they":[174],"provide":[175],"considerable":[176],"improvements":[177],"timings,":[180],"Decision":[182],"Support":[183],"environments":[184],"almost":[187],"negligible":[188],"regression(if":[189],"any)":[190],"other":[192,208,233],"environments.":[193],"This":[194],"enjoys":[196],"advantage":[198],"requiring":[200],"change":[202],"manager":[206],"or":[207],"modules":[209],"underlying":[210],"layer":[214],"therefore":[216],"easy":[218],"implement.":[220],"Also,":[221],"since":[222],"part":[226],"extensive":[229],"architecture,":[232],"using":[235],"framework":[238],"can":[239],"be":[240],"plugged":[241],"easily.":[243]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-06-24T00:00:00"}