{"id":"https://openalex.org/W4244428894","doi":"https://doi.org/10.1109/micro.2003.1253191","title":"Scaling and characterizing database workloads: bridging the gap between research and practice","display_name":"Scaling and characterizing database workloads: bridging the gap between research and practice","publication_year":2004,"publication_date":"2004-05-25","ids":{"openalex":"https://openalex.org/W4244428894","doi":"https://doi.org/10.1109/micro.2003.1253191"},"language":"en","primary_location":{"id":"doi:10.1109/micro.2003.1253191","is_oa":false,"landing_page_url":"https://doi.org/10.1109/micro.2003.1253191","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"22nd Digital Avionics Systems Conference. Proceedings (Cat. No.03CH37449)","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/A5006683324","display_name":"Richard A. Hankins","orcid":null},"institutions":[{"id":"https://openalex.org/I1343180700","display_name":"Intel (United States)","ror":"https://ror.org/01ek73717","country_code":"US","type":"company","lineage":["https://openalex.org/I1343180700"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"R. Hankins","raw_affiliation_strings":["Microprocessor Research Laboratories, Intel Corporation, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microprocessor Research Laboratories, Intel Corporation, USA","institution_ids":["https://openalex.org/I1343180700"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5056624655","display_name":"T. Diep","orcid":null},"institutions":[{"id":"https://openalex.org/I1343180700","display_name":"Intel (United States)","ror":"https://ror.org/01ek73717","country_code":"US","type":"company","lineage":["https://openalex.org/I1343180700"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"T. Diep","raw_affiliation_strings":["Microprocessor Research Laboratories, Intel Corporation, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microprocessor Research Laboratories, Intel Corporation, USA","institution_ids":["https://openalex.org/I1343180700"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018033573","display_name":"Murali Annavaram","orcid":"https://orcid.org/0000-0002-4633-6867"},"institutions":[{"id":"https://openalex.org/I1343180700","display_name":"Intel (United States)","ror":"https://ror.org/01ek73717","country_code":"US","type":"company","lineage":["https://openalex.org/I1343180700"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"M. Annavaram","raw_affiliation_strings":["Microprocessor Research Laboratories, Intel Corporation, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microprocessor Research Laboratories, Intel Corporation, USA","institution_ids":["https://openalex.org/I1343180700"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5083755533","display_name":"B. Hirano","orcid":null},"institutions":[{"id":"https://openalex.org/I4210107681","display_name":"Oracle (United Kingdom)","ror":"https://ror.org/01pe8xs92","country_code":"GB","type":"company","lineage":["https://openalex.org/I1342911587","https://openalex.org/I4210107681"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"B. Hirano","raw_affiliation_strings":["Server Technologies, Oracle Corporation, UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Server Technologies, Oracle Corporation, UK","institution_ids":["https://openalex.org/I4210107681"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037106969","display_name":"H. Eri","orcid":null},"institutions":[{"id":"https://openalex.org/I4210107681","display_name":"Oracle (United Kingdom)","ror":"https://ror.org/01pe8xs92","country_code":"GB","type":"company","lineage":["https://openalex.org/I1342911587","https://openalex.org/I4210107681"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"H. Eri","raw_affiliation_strings":["Server Technologies, Oracle Corporation, UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Server Technologies, Oracle Corporation, UK","institution_ids":["https://openalex.org/I4210107681"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5014192095","display_name":"H. Nueckel","orcid":null},"institutions":[{"id":"https://openalex.org/I4210107681","display_name":"Oracle (United Kingdom)","ror":"https://ror.org/01pe8xs92","country_code":"GB","type":"company","lineage":["https://openalex.org/I1342911587","https://openalex.org/I4210107681"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"H. Nueckel","raw_affiliation_strings":["Software Solutions Group, Oracle Corporation, UK"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Software Solutions Group, Oracle Corporation, UK","institution_ids":["https://openalex.org/I4210107681"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5009313575","display_name":"J.P. Shen","orcid":null},"institutions":[{"id":"https://openalex.org/I1343180700","display_name":"Intel (United States)","ror":"https://ror.org/01ek73717","country_code":"US","type":"company","lineage":["https://openalex.org/I1343180700"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"J.P. Shen","raw_affiliation_strings":["Microprocessor Research Laboratories, Intel Corporation, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microprocessor Research Laboratories, Intel Corporation, USA","institution_ids":["https://openalex.org/I1343180700"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":7,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.4933,"has_fulltext":false,"cited_by_count":27,"citation_normalized_percentile":{"value":0.9369535,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"151","last_page":"162"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9812999963760376,"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.9812999963760376,"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.980400025844574,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9775000214576721,"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/online-transaction-processing","display_name":"Online transaction processing","score":0.9630154371261597},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8456299304962158},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.7103052139282227},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.5720745921134949},{"id":"https://openalex.org/keywords/transaction-processing-system","display_name":"Transaction processing system","score":0.5514430403709412},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.5249454975128174},{"id":"https://openalex.org/keywords/throughput","display_name":"Throughput","score":0.48631319403648376},{"id":"https://openalex.org/keywords/distributed-transaction","display_name":"Distributed transaction","score":0.4733056128025055},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.47090697288513184},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.466150164604187},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.46150070428848267},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.42538586258888245},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.2743426561355591}],"concepts":[{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.9630154371261597},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8456299304962158},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.7103052139282227},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.5720745921134949},{"id":"https://openalex.org/C11354467","wikidata":"https://www.wikidata.org/wiki/Q953487","display_name":"Transaction processing system","level":4,"score":0.5514430403709412},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.5249454975128174},{"id":"https://openalex.org/C157764524","wikidata":"https://www.wikidata.org/wiki/Q1383412","display_name":"Throughput","level":3,"score":0.48631319403648376},{"id":"https://openalex.org/C25185021","wikidata":"https://www.wikidata.org/wiki/Q4053284","display_name":"Distributed transaction","level":4,"score":0.4733056128025055},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.47090697288513184},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.466150164604187},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.46150070428848267},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.42538586258888245},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2743426561355591},{"id":"https://openalex.org/C555944384","wikidata":"https://www.wikidata.org/wiki/Q249","display_name":"Wireless","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/micro.2003.1253191","is_oa":false,"landing_page_url":"https://doi.org/10.1109/micro.2003.1253191","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"22nd Digital Avionics Systems Conference. Proceedings (Cat. No.03CH37449)","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.5.9686","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.5.9686","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.microarch.org/micro36/html/./pdf/annavaram-ScalingCharacDatabase.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":19,"referenced_works":["https://openalex.org/W1510808677","https://openalex.org/W1977964581","https://openalex.org/W2110121725","https://openalex.org/W2112854218","https://openalex.org/W2129269323","https://openalex.org/W2141386638","https://openalex.org/W2155651153","https://openalex.org/W2170653240","https://openalex.org/W2172190421","https://openalex.org/W3148484433","https://openalex.org/W4234767864","https://openalex.org/W4243587504","https://openalex.org/W4251139570","https://openalex.org/W4252533346","https://openalex.org/W6630600562","https://openalex.org/W6676320952","https://openalex.org/W6676829229","https://openalex.org/W6683066674","https://openalex.org/W6793277613"],"related_works":["https://openalex.org/W2123909466","https://openalex.org/W579270350","https://openalex.org/W590454891","https://openalex.org/W4288089517","https://openalex.org/W2169387894","https://openalex.org/W2981349997","https://openalex.org/W2090136942","https://openalex.org/W2364250032","https://openalex.org/W2028650062","https://openalex.org/W2588999713"],"abstract_inverted_index":{"On-line":[0],"transaction":[1,43,92],"processing":[2,44],"(OLTP)":[3],"workloads":[4,25],"are":[5,26,101],"crucial":[6],"benchmarks":[7],"for":[8,175],"the":[9,32,54,73,87,95,104,128,133,136,147],"design":[10],"and":[11,94,135,149],"analysis":[12],"of":[13,28,48,65,76,113,131,145,185],"server":[14],"processors.":[15],"Typical":[16],"cached":[17],"configurations":[18,35,146,189],"used":[19,36],"by":[20,37,160],"researchers":[21],"to":[22,40,52,103,126],"simulate":[23],"OLTP":[24,59,118,188],"orders":[27],"magnitude":[29],"smaller":[30],"than":[31],"fully":[33],"scaled":[34],"OEM":[38],"vendors":[39],"achieve":[41],"world-record":[42],"throughput.":[45],"The":[46],"objective":[47],"this":[49,68],"study":[50],"is":[51],"discover":[53],"underlying":[55],"relationships":[56],"that":[57,85,140],"characterize":[58,127],"performance":[60],"over":[61],"a":[62,142,173,177],"wide":[63,143],"range":[64,144],"configurations.":[66],"To":[67],"end,":[69],"we":[70,83,171],"have":[71],"derived":[72],"\"iron":[74],"law\"":[75],"database":[77],"performance.":[78,106],"Using":[79],"our":[80,169],"iron":[81],"law,":[82],"show":[84],"both":[86,132],"average":[88,96],"instructions":[89],"executed":[90],"per":[91,98],"(IPX)":[93],"cycles":[97],"instruction":[99],"(CPI)":[100],"critical":[102],"transaction-throughput":[105],"We":[107,138],"use":[108],"an":[109,114,121],"extensive,":[110],"empirical":[111],"examination":[112],"Oracle":[115],"based":[116],"commercial":[117],"workload":[119,180],"on":[120,168],"Intel":[122],"Xeon":[123],"multiprocessor":[124],"system":[125],"scaling":[129],"behaviour":[130,151],"IPX":[134,148],"CPI.":[137],"demonstrate":[139],"across":[141],"CPI":[150],"follows":[152],"predictable":[153],"trends,":[154],"which":[155,183],"can":[156,190],"be":[157,191],"accurately":[158,192],"characterized":[159],"simple":[161],"linear":[162,165],"or":[163],"piece-wise":[164],"approximations.":[166],"Based":[167],"data,":[170],"propose":[172],"method":[174],"selecting":[176],"minimal,":[178],"representative":[179],"configuration":[181],"from":[182],"behaviours":[184],"much":[186],"larger":[187],"extrapolated.":[193]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2015,"cited_by_count":2},{"year":2012,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}