{"id":"https://openalex.org/W4251139570","doi":"https://doi.org/10.1109/isca.1998.694761","title":"An analysis of database workload performance on simultaneous multithreaded processors","display_name":"An analysis of database workload performance on simultaneous multithreaded processors","publication_year":2002,"publication_date":"2002-11-27","ids":{"openalex":"https://openalex.org/W4251139570","doi":"https://doi.org/10.1109/isca.1998.694761"},"language":"en","primary_location":{"id":"doi:10.1109/isca.1998.694761","is_oa":false,"landing_page_url":"https://doi.org/10.1109/isca.1998.694761","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings. 25th Annual International Symposium on Computer Architecture (Cat. No.98CB36235)","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/A5086802899","display_name":"J.L. Lo","orcid":"https://orcid.org/0000-0002-6164-7065"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"J.L. Lo","raw_affiliation_strings":["Department of Computer Science and Engineering, University of Washington, Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, University of Washington, Seattle, WA, USA","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057539565","display_name":"Luiz Andr\u00e9 Barroso","orcid":"https://orcid.org/0000-0002-7854-9955"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"L.A. Barroso","raw_affiliation_strings":["Western Research Laboratory, Digital Equipment Corporation, Palo Alto, CA, USA"],"affiliations":[{"raw_affiliation_string":"Western Research Laboratory, Digital Equipment Corporation, Palo Alto, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051475447","display_name":"Susan J. Eggers","orcid":null},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"S.J. Eggers","raw_affiliation_strings":["Department of Computer Science and Engineering, University of Washington, Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, University of Washington, Seattle, WA, USA","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069896359","display_name":"Kourosh Gharachorloo","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"K. Gharachorloo","raw_affiliation_strings":["Western Research Laboratory, Digital Equipment Corporation, Palo Alto, CA, USA"],"affiliations":[{"raw_affiliation_string":"Western Research Laboratory, Digital Equipment Corporation, Palo Alto, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069107397","display_name":"Henry M. Levy","orcid":"https://orcid.org/0009-0008-7786-8541"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"H.M. Levy","raw_affiliation_strings":["Department of Computer Science and Engineering, University of Washington, Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, University of Washington, Seattle, WA, USA","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5081512985","display_name":"S. Parekh","orcid":"https://orcid.org/0000-0001-9337-8552"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"S.S. Parekh","raw_affiliation_strings":["Department of Computer Science and Engineering, University of Washington, Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, University of Washington, Seattle, WA, USA","institution_ids":["https://openalex.org/I201448701"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5086802899"],"corresponding_institution_ids":["https://openalex.org/I201448701"],"apc_list":null,"apc_paid":null,"fwci":4.5436,"has_fulltext":false,"cited_by_count":52,"citation_normalized_percentile":{"value":0.95637139,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"39","last_page":"50"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9995999932289124,"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"}},"topics":[{"id":"https://openalex.org/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9995999932289124,"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"}},{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9994999766349792,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9994000196456909,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.9022228121757507},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.6617994904518127},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.6141546964645386},{"id":"https://openalex.org/keywords/simultaneous-multithreading","display_name":"Simultaneous multithreading","score":0.5552468299865723},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.5174791812896729},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.5066984295845032},{"id":"https://openalex.org/keywords/multithreading","display_name":"Multithreading","score":0.502403974533081},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.43495509028434753},{"id":"https://openalex.org/keywords/cache-coloring","display_name":"Cache coloring","score":0.4118487536907196},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.40534621477127075},{"id":"https://openalex.org/keywords/cpu-cache","display_name":"CPU cache","score":0.3260859251022339},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.27385690808296204},{"id":"https://openalex.org/keywords/thread","display_name":"Thread (computing)","score":0.20076191425323486}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9022228121757507},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.6617994904518127},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.6141546964645386},{"id":"https://openalex.org/C85717602","wikidata":"https://www.wikidata.org/wiki/Q82178","display_name":"Simultaneous multithreading","level":4,"score":0.5552468299865723},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.5174791812896729},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.5066984295845032},{"id":"https://openalex.org/C201410400","wikidata":"https://www.wikidata.org/wiki/Q1064412","display_name":"Multithreading","level":3,"score":0.502403974533081},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.43495509028434753},{"id":"https://openalex.org/C201148951","wikidata":"https://www.wikidata.org/wiki/Q5015976","display_name":"Cache coloring","level":4,"score":0.4118487536907196},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.40534621477127075},{"id":"https://openalex.org/C189783530","wikidata":"https://www.wikidata.org/wiki/Q352090","display_name":"CPU cache","level":3,"score":0.3260859251022339},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.27385690808296204},{"id":"https://openalex.org/C138101251","wikidata":"https://www.wikidata.org/wiki/Q213092","display_name":"Thread (computing)","level":2,"score":0.20076191425323486}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/isca.1998.694761","is_oa":false,"landing_page_url":"https://doi.org/10.1109/isca.1998.694761","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings. 25th Annual International Symposium on Computer Architecture (Cat. No.98CB36235)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W1602595707","https://openalex.org/W1975025054","https://openalex.org/W1977964581","https://openalex.org/W2047226031","https://openalex.org/W2070906137","https://openalex.org/W2112300321","https://openalex.org/W2118532220","https://openalex.org/W2129269323","https://openalex.org/W2140455011","https://openalex.org/W2141751983","https://openalex.org/W2147285994","https://openalex.org/W2153131460","https://openalex.org/W2161268347","https://openalex.org/W2162071106","https://openalex.org/W2169040626","https://openalex.org/W2171989104","https://openalex.org/W4243587504","https://openalex.org/W4246687778","https://openalex.org/W4251262730","https://openalex.org/W4252533346","https://openalex.org/W6635933415","https://openalex.org/W6683820741"],"related_works":["https://openalex.org/W2118532220","https://openalex.org/W4240807263","https://openalex.org/W4249709097","https://openalex.org/W2913446311","https://openalex.org/W1532726325","https://openalex.org/W2115561485","https://openalex.org/W2354938433","https://openalex.org/W3142147837","https://openalex.org/W1987511199","https://openalex.org/W2017040309"],"abstract_inverted_index":{"Simultaneous":[0],"multithreading":[1,52],"(SMT)":[2],"is":[3,35,111,204],"an":[4,37,168,217],"architectural":[5],"technique":[6],"in":[7,115,225],"which":[8],"the":[9,49,54,71,84,126,141,160],"processor":[10,220],"issues":[11],"multiple":[12,15],"instructions":[13],"from":[14],"threads":[16],"each":[17],"cycle.":[18],"While":[19],"SMT":[20,66,170,219],"has":[21,53],"been":[22],"shown":[23],"to":[24,56,174,183,195],"be":[25,137],"effective":[26,206],"on":[27,32,65,167,176],"scientific":[28],"workloads,":[29],"its":[30],"performance":[31,64],"database":[33,42,63,73,88,208],"systems":[34,43,89],"still":[36],"open":[38],"question.":[39],"In":[40],"particular,":[41],"have":[44,106],"poor":[45],"cache":[46,58,129,187],"performance,":[47],"and":[48,94,151],"addition":[50],"of":[51,70,87,144],"potential":[55],"exacerbate":[57],"conflicts.":[59],"This":[60],"paper":[61],"examines":[62],"processors":[67],"using":[68,212],"traces":[69],"Oracle":[72],"management":[74],"system.":[75],"Our":[76,99,155],"research":[77],"makes":[78],"three":[79],"contributions.":[80],"First,":[81],"it":[82],"characterizes":[83],"memory-system":[85],"behavior":[86],"running":[90],"on-line":[91],"transaction":[92],"processing":[93],"decision":[95],"support":[96],"system":[97],"workloads.":[98],"data":[100,113,128],"show":[101,124,199],"that":[102,125,158,200],"while":[103],"DBMS":[104],"workloads":[105],"large":[107],"memory":[108],"footprints,":[109],"there":[110],"substantial":[112],"reuse":[114],"a":[116,177,213,222,229],"small,":[117],"cacheable":[118],"\"critical\"":[119],"working":[120],"set.":[121],"Second,":[122],"we":[123,198],"additional":[127],"conflicts":[130],"caused":[131],"by":[132,140,193],"simultaneous-multithreaded":[133],"instruction":[134,186,226],"scheduling":[135],"can":[136],"nearly":[138],"eliminated":[139],"proper":[142],"choice":[143],"software-directed":[145],"policies":[146],"for":[147,207],"virtual-to-physical":[148],"page":[149],"mapping":[150],"per-process":[152],"address":[153],"offsetting.":[154],"results":[156],"demonstrate":[157],"with":[159,232],"best":[161],"policy":[162],"choices,":[163],"D-cache":[164],"miss":[165,191],"rates":[166,192],"8-context":[169,218],"are":[171],"roughly":[172],"equivalent":[173],"those":[175],"single-threaded":[178,230],"superscalar.":[179],"Multithreading":[180],"also":[181],"leads":[182],"better":[184],"interthread":[185],"sharing,":[188],"reducing":[189],"I-cache":[190],"up":[194],"35%.":[196],"Third,":[197],"SMT's":[201],"latency":[202],"tolerance":[203],"highly":[205],"applications.":[209],"For":[210],"example,":[211],"memory-intensive":[214],"OLTP":[215],"workload,":[216],"achieves":[221],"3-fold":[223],"increase":[224],"throughput":[227],"over":[228],"superscalar":[231],"similar":[233],"resources.":[234]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1},{"year":2015,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}