{"id":"https://openalex.org/W171916601","doi":null,"title":"I/O Reference Behavior of Production Database Workloads and the TPC","display_name":"I/O Reference Behavior of Production Database Workloads and the TPC","alternate_titles":[],"publication_year":1999,"publication_date":"1999-11-04","ids":{"openalex":"https://openalex.org/W171916601","mag":"171916601"},"language":"en","primary_location":{"id":"mag:171916601","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=894382","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W171916601"],"child_works_count":0,"type":"article","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/A5111426489","display_name":"Windsor W. Hsu","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Windsor W. Hsu","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103418131","display_name":"Alan Jay Smith","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Alan Jay Smith","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5048407385","display_name":"Honesty C. Young","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Honesty C. Young","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.6366999745368958,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.6366999745368958,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.3452000021934509,"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.006899999920278788,"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/tpc-c","display_name":"TPC-C","score":0.765999972820282},{"id":"https://openalex.org/keywords/tpc-ds","display_name":"TPC-DS","score":0.9980000257492065},{"id":"https://openalex.org/keywords/caching","display_name":"caching","score":0.621999979019165},{"id":"https://openalex.org/keywords/prefetching","display_name":"prefetching","score":0.921999990940094},{"id":"https://openalex.org/keywords/i-o-optimization","display_name":"I/O optimization","score":0.5550000071525574},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"online transaction processing","score":0.6809999942779541},{"id":"https://openalex.org/keywords/decision-support-system","display_name":"decision support system","score":0.9940000176429749},{"id":"https://openalex.org/keywords/benchmark-limitations","display_name":"benchmark limitations","score":0.39399999380111694}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7758969068527222},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.7655541896820068},{"id":"https://openalex.org/C2780513914","wikidata":"https://www.wikidata.org/wiki/Q18210350","display_name":"Bottleneck","level":2,"score":0.6693139672279358},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.6251921057701111},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5728212594985962},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.5488021969795227},{"id":"https://openalex.org/C2778348673","wikidata":"https://www.wikidata.org/wiki/Q739302","display_name":"Production (economics)","level":2,"score":0.5223578214645386},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.4913767874240875},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.1654658317565918},{"id":"https://openalex.org/C139719470","wikidata":"https://www.wikidata.org/wiki/Q39680","display_name":"Macroeconomics","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:171916601","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=894382","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W1965893058","https://openalex.org/W1545516211","https://openalex.org/W1536585203","https://openalex.org/W2094322553","https://openalex.org/W3171566424","https://openalex.org/W130779010","https://openalex.org/W2139480184","https://openalex.org/W2087735340","https://openalex.org/W1962224248"],"abstract_inverted_index":{"As":[0],"improvements":[1,9],"in":[2,10,18,22,331],"processor":[3],"performance":[4,38,190],"continue":[5],"to":[6,34,40,79,123,126,133,159,172],"far":[7],"outpace":[8],"storage":[11],"performance,":[12],"I/O":[13,37,56,103,279],"is":[14,39,229,286,295,315],"increasingly":[15],"the":[16,54,60,68,101,108,117,127,148,153,166,173,234,238,242,249,252,261,267,289,319,323,333,336,343,353],"bottleneck":[17],"computer":[19],"systems,":[20],"especially":[21],"large":[23],"database":[24,63],"systems":[25,197,201],"that":[26,97,116,236,247,276,346],"manage":[27],"huge":[28],"amounts":[29],"of":[30,53,59,67,95,129,155,169,226,233,255,263,298,335,342,352],"data.":[31],"The":[32],"key":[33],"achieving":[35],"good":[36],"thoroughly":[41],"understand":[42],"its":[43],"characteristics.":[44],"In":[45,162],"this":[46],"paper,":[47],"we":[48,164],"present":[49],"a":[50,223],"comprehensive":[51],"analysis":[52,228],"logical":[55],"reference":[57,167,253],"behavior":[58,254,264],"peak":[61],"production":[62,109,243,268,337],"workloads":[64,77,170,345],"from":[65,288],"ten":[66],"world''s":[69],"largest":[70],"corporations":[71],"by":[72,136,266,350],"focusing":[73],"on":[74,230],"how":[75,99],"these":[76],"respond":[78],"different":[80],"techniques":[81,105,281],"for":[82,107,192,248,291,302,318],"caching,":[83],"prefetching":[84,304],"and":[85,152,182,198,209,219,257,310],"write":[86,149,311],"buffering.":[87],"Our":[88],"findings":[89],"include":[90],"several":[91],"broadly":[92],"applicable":[93],"rules":[94],"thumb":[96],"describe":[98],"effective":[100,317],"various":[102],"optimization":[104,280],"are":[106,186,221,272,347],"workloads.":[110,244,269],"For":[111],"instance,":[112],"our":[113,227],"results":[114],"indicate":[115],"buffer":[118,130,156],"pool":[119,131,157],"miss":[120,150],"ratio":[121,128,151,154],"tends":[122],"be":[124,213],"related":[125],"size":[132,135,158],"data":[134,160],"an":[137],"inverse":[138],"square":[139],"root":[140,145],"rule.":[141],"A":[142],"similar":[143,171],"fourth":[144],"rule":[146],"relates":[147],"size.":[161],"addition,":[163],"characterize":[165],"characteristics":[168,334],"Transaction":[174],"Processing":[175],"Performance":[176],"Council":[177],"(TPC)":[178],"benchmarks":[179,205,235,326],"C":[180],"(TPC-C)":[181],"D":[183],"(TPC-D),":[184],"which":[185],"de":[187],"facto":[188],"standard":[189],"measures":[191],"on-line":[193],"transaction":[194],"processing":[195],"(OLTP)":[196],"decision":[199],"support":[200],"(DSS)":[202],"respectively.":[203],"Since":[204],"such":[206,282],"as":[207,283],"TPC-C":[208,256,292],"TPC-D":[210,258],"can":[211],"only":[212],"used":[214],"effectively":[215],"if":[216],"their":[217],"strengths":[218],"limitations":[220],"understood,":[222],"major":[224],"focus":[225],"identifying":[231],"aspects":[232,341],"stress":[237],"system":[239],"differently":[240],"than":[241],"We":[245],"discover":[246],"most":[250],"part,":[251],"fall":[259],"within":[260],"range":[262],"exhibited":[265],"However,":[270],"there":[271,294,339],"some":[273],"noteworthy":[274],"exceptions":[275],"affect":[277],"well-known":[278],"caching":[284],"(LRU":[285],"further":[287],"optimal":[290],"while":[293],"little":[296],"sharing":[297],"pages":[299],"between":[300],"transactions":[301],"TPC-D),":[303],"(TPC-C":[305],"exhibits":[306],"no":[307],"significant":[308],"sequentiality)":[309],"buffering":[312,314],"(write":[313],"less":[316],"TPC":[320,325],"benchmarks).":[321],"While":[322],"two":[324],"generally":[327],"complement":[328],"one":[329],"another":[330],"reflecting":[332],"workloads,":[338],"remain":[340],"real":[344],"not":[348],"represented":[349],"either":[351],"benchmarks.":[354]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W171916601","counts_by_year":[{"year":2026,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
