{"id":"https://openalex.org/W2047433654","doi":"https://doi.org/10.1145/1458082.1458306","title":"Characterization of TPC-H queries for a column-oriented database on a dual-core amd athlon processor","display_name":"Characterization of TPC-H queries for a column-oriented database on a dual-core amd athlon processor","publication_year":2008,"publication_date":"2008-10-26","ids":{"openalex":"https://openalex.org/W2047433654","doi":"https://doi.org/10.1145/1458082.1458306","mag":"2047433654"},"language":"en","primary_location":{"id":"doi:10.1145/1458082.1458306","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1458082.1458306","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 17th ACM conference on Information and knowledge management","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/A5019971512","display_name":"Pranav Vaidya","orcid":null},"institutions":[{"id":"https://openalex.org/I55769427","display_name":"Indiana University \u2013 Purdue University Indianapolis","ror":"https://ror.org/05gxnyn08","country_code":"US","type":"education","lineage":["https://openalex.org/I55769427","https://openalex.org/I592451"]},{"id":"https://openalex.org/I135191193","display_name":"University of Indianapolis","ror":"https://ror.org/052133d12","country_code":"US","type":"education","lineage":["https://openalex.org/I135191193"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Pranav Vaidya","raw_affiliation_strings":["Purdue School of Engineering and Technology, Indianapolis, IN, USA"],"affiliations":[{"raw_affiliation_string":"Purdue School of Engineering and Technology, Indianapolis, IN, USA","institution_ids":["https://openalex.org/I135191193","https://openalex.org/I55769427"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100762136","display_name":"John J. Lee","orcid":"https://orcid.org/0000-0002-5335-9071"},"institutions":[{"id":"https://openalex.org/I55769427","display_name":"Indiana University \u2013 Purdue University Indianapolis","ror":"https://ror.org/05gxnyn08","country_code":"US","type":"education","lineage":["https://openalex.org/I55769427","https://openalex.org/I592451"]},{"id":"https://openalex.org/I135191193","display_name":"University of Indianapolis","ror":"https://ror.org/052133d12","country_code":"US","type":"education","lineage":["https://openalex.org/I135191193"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jaehwan (John) Lee","raw_affiliation_strings":["Purdue School of Engineering and Technology, Indianapolis, IN, USA"],"affiliations":[{"raw_affiliation_string":"Purdue School of Engineering and Technology, Indianapolis, IN, USA","institution_ids":["https://openalex.org/I135191193","https://openalex.org/I55769427"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5019971512"],"corresponding_institution_ids":["https://openalex.org/I135191193","https://openalex.org/I55769427"],"apc_list":null,"apc_paid":null,"fwci":0.6907,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.75220972,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"1411","last_page":"1412"},"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.9961000084877014,"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.9961000084877014,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9957000017166138,"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.9944999814033508,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.805487871170044},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6635926961898804},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.6173331141471863},{"id":"https://openalex.org/keywords/thread","display_name":"Thread (computing)","score":0.5921896696090698},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.5041056871414185},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.4660922586917877},{"id":"https://openalex.org/keywords/multi-core-processor","display_name":"Multi-core processor","score":0.4508138597011566},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.4352417588233948},{"id":"https://openalex.org/keywords/isolation","display_name":"Isolation (microbiology)","score":0.4278287887573242},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.3976866602897644},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.361425518989563},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.10214632749557495}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.805487871170044},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6635926961898804},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.6173331141471863},{"id":"https://openalex.org/C138101251","wikidata":"https://www.wikidata.org/wiki/Q213092","display_name":"Thread (computing)","level":2,"score":0.5921896696090698},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.5041056871414185},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.4660922586917877},{"id":"https://openalex.org/C78766204","wikidata":"https://www.wikidata.org/wiki/Q555032","display_name":"Multi-core processor","level":2,"score":0.4508138597011566},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.4352417588233948},{"id":"https://openalex.org/C2775941552","wikidata":"https://www.wikidata.org/wiki/Q25212305","display_name":"Isolation (microbiology)","level":2,"score":0.4278287887573242},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3976866602897644},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.361425518989563},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.10214632749557495},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C89423630","wikidata":"https://www.wikidata.org/wiki/Q7193","display_name":"Microbiology","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1458082.1458306","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1458082.1458306","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 17th ACM conference on Information and knowledge management","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.546.3348","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.546.3348","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.ece.iupui.edu/TR/TR-ECE-07-03.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/8","score":0.47999998927116394,"display_name":"Decent work and economic growth"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W142762403","https://openalex.org/W1515932031","https://openalex.org/W1543127925","https://openalex.org/W1555915743","https://openalex.org/W1874295121","https://openalex.org/W1973441419","https://openalex.org/W2005112390","https://openalex.org/W2015823077","https://openalex.org/W2038057969","https://openalex.org/W2082701182","https://openalex.org/W2116420167","https://openalex.org/W2138709157","https://openalex.org/W2143110746","https://openalex.org/W2143401113","https://openalex.org/W2150054597","https://openalex.org/W2155350341","https://openalex.org/W2155651153","https://openalex.org/W2162071106","https://openalex.org/W2166441508","https://openalex.org/W2187405563","https://openalex.org/W2404326078","https://openalex.org/W2788962374","https://openalex.org/W3138367763"],"related_works":["https://openalex.org/W2033778626","https://openalex.org/W2187110187","https://openalex.org/W2026780467","https://openalex.org/W2181722423","https://openalex.org/W2394779770","https://openalex.org/W2347222412","https://openalex.org/W2085601491","https://openalex.org/W2375996887","https://openalex.org/W2002371119","https://openalex.org/W2018697868"],"abstract_inverted_index":{"Column-oriented":[0],"databases":[1,13,193],"are":[2],"reported":[3],"to":[4,112,129,154,169,188],"perform":[5],"orders":[6],"of":[7,31,46,69,78,83,88,97,116,147,166,173,182,192,195],"mag-nitude":[8],"faster":[9],"than":[10],"traditional":[11],"row-oriented":[12,150],"for":[14,36,50,149],"Decision":[15],"Support":[16],"System":[17],"(DSS)":[18],"workloads.":[19],"However,":[20],"there":[21],"have":[22],"been":[23],"few":[24],"investigations":[25],"on":[26,58,144],"the":[27,44,47,67,79,86,95,98,114,145,155,171,174,180,183,190],"detailed":[28,76],"hardware":[29],"characterization":[30,146],"DSS":[32],"benchmarks":[33],"namely":[34,101],"TPC-H":[35,48,89,148],"column-oriented":[37,53,121,134],"databases.":[38,122,135,151],"In":[39],"this":[40],"paper,":[41],"we":[42,65,137,162],"characterize":[43,189],"performance":[45,68,118,172,191],"benchmark":[49],"a":[51,59],"popular":[52],"database":[54,167,175],"called":[55],"MonetDB":[56],"running":[57],"dual-core":[60],"AMD":[61],"Athlon":[62],"machine.":[63],"Specifically,":[64],"measure":[66],"key":[70],"microarchitectural":[71],"components":[72],"and":[73,107],"provide":[74],"very":[75],"analysis":[77],"execution":[80,87],"time":[81],"breakdown":[82],"Mon-etDB":[84],"during":[85],"queries.":[90],"We":[91,123],"analyze":[92],"in":[93,110,120,133,177],"detail":[94],"nature":[96],"various":[99],"stalls":[100,106,109,132],"cache":[102],"stalls,":[103],"branch":[104],"mis-prediction":[105],"resource":[108],"order":[111],"identify":[113],"causes":[115],"these":[117,131],"impediments":[119],"then":[124],"indicate":[125],"possible":[126],"research":[127],"directions":[128],"minimize":[130],"Finally,":[136],"compare":[138],"our":[139],"re-sults":[140],"with":[141],"published":[142],"results":[143],"As":[152],"opposed":[153],"previous":[156],"approaches":[157],"that":[158],"used":[159,163],"system-level":[160],"monitoring,":[161],"thread-level":[164],"monitor-ing":[165],"threads":[168],"study":[170],"alone":[176],"isolation":[178],"from":[179],"rest":[181],"system.":[184],"This":[185],"enabled":[186],"us":[187],"independent":[194],"any":[196],"other":[197],"executing":[198],"processes.":[199],"1.":[200]},"counts_by_year":[{"year":2018,"cited_by_count":2},{"year":2015,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}