{"id":"https://openalex.org/W2088267379","doi":"https://doi.org/10.1145/2064676.2064689","title":"Column-oriented query processing for row stores","display_name":"Column-oriented query processing for row stores","publication_year":2011,"publication_date":"2011-10-28","ids":{"openalex":"https://openalex.org/W2088267379","doi":"https://doi.org/10.1145/2064676.2064689","mag":"2088267379"},"language":"en","primary_location":{"id":"doi:10.1145/2064676.2064689","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2064676.2064689","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP","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/A5018277136","display_name":"Amr El-Helw","orcid":null},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Amr El-Helw","raw_affiliation_strings":["University of Waterloo, Waterloo, ON, Canada"],"affiliations":[{"raw_affiliation_string":"University of Waterloo, Waterloo, ON, Canada","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5021663937","display_name":"Kenneth A. Ross","orcid":"https://orcid.org/0000-0001-9397-6990"},"institutions":[{"id":"https://openalex.org/I78577930","display_name":"Columbia University","ror":"https://ror.org/00hj8s172","country_code":"US","type":"education","lineage":["https://openalex.org/I78577930"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kenneth A. Ross","raw_affiliation_strings":["Columbia University, New York, NY, USA"],"affiliations":[{"raw_affiliation_string":"Columbia University, New York, NY, USA","institution_ids":["https://openalex.org/I78577930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069125151","display_name":"Bishwaranjan Bhattacharjee","orcid":"https://orcid.org/0009-0009-7097-4891"},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Bishwaranjan Bhattacharjee","raw_affiliation_strings":["IBM Watson Research Center, Hawthorne, NY, USA"],"affiliations":[{"raw_affiliation_string":"IBM Watson Research Center, Hawthorne, NY, USA","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110235377","display_name":"Christian A. Lang","orcid":null},"institutions":[{"id":"https://openalex.org/I4210164055","display_name":"Acelot (United States)","ror":"https://ror.org/05g51bs78","country_code":"US","type":"company","lineage":["https://openalex.org/I4210164055"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Christian A. Lang","raw_affiliation_strings":["Acelot, Inc., Santa Barbara, CA, USA"],"affiliations":[{"raw_affiliation_string":"Acelot, Inc., Santa Barbara, CA, USA","institution_ids":["https://openalex.org/I4210164055"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5003559911","display_name":"George A. Mihaila","orcid":"https://orcid.org/0000-0002-6185-9658"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"George A. Mihaila","raw_affiliation_strings":["Google, Inc., New York, NY, USA","Google Inc., New York, NY, USA#TAB#"],"affiliations":[{"raw_affiliation_string":"Google, Inc., New York, NY, USA","institution_ids":["https://openalex.org/I1291425158"]},{"raw_affiliation_string":"Google Inc., New York, NY, USA#TAB#","institution_ids":["https://openalex.org/I1291425158"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5018277136"],"corresponding_institution_ids":["https://openalex.org/I151746483"],"apc_list":null,"apc_paid":null,"fwci":1.4003,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.8257776,"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":"67","last_page":"74"},"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.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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","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"}},{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","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"}},{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.9977999925613403,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.7776088714599609},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.7343059778213501},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5735858082771301},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.4218406677246094},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3970903754234314},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.10226759314537048}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7776088714599609},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.7343059778213501},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5735858082771301},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.4218406677246094},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3970903754234314},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.10226759314537048},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2064676.2064689","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2064676.2064689","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4699999988079071,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W1526124194","https://openalex.org/W1967930269","https://openalex.org/W1982558719","https://openalex.org/W2005112390","https://openalex.org/W2058178853","https://openalex.org/W2063601856","https://openalex.org/W2068644217","https://openalex.org/W2074125039","https://openalex.org/W2084757499","https://openalex.org/W2085601491","https://openalex.org/W2110423232","https://openalex.org/W2112479717","https://openalex.org/W2113045536","https://openalex.org/W2123686039","https://openalex.org/W2124851765","https://openalex.org/W2133300302","https://openalex.org/W2135003477","https://openalex.org/W2160761840","https://openalex.org/W2161437384","https://openalex.org/W2407165745","https://openalex.org/W2964070196","https://openalex.org/W3138367763","https://openalex.org/W6678708722","https://openalex.org/W6681416973","https://openalex.org/W6713860211"],"related_works":["https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W2382290278","https://openalex.org/W2478288626","https://openalex.org/W2350741829","https://openalex.org/W2530322880","https://openalex.org/W1596801655"],"abstract_inverted_index":{"Column-oriented":[0],"DBMSs":[1],"have":[2],"gained":[3],"increasing":[4],"interest":[5],"due":[6],"to":[7,17,36,91],"their":[8,38],"superior":[9],"performance":[10,60],"for":[11,41],"analytical":[12],"workloads.":[13],"Prior":[14],"efforts":[15],"tried":[16],"determine":[18],"the":[19,23,59,72,93],"possibility":[20],"of":[21,27,61,75],"simulating":[22],"query":[24,54],"processing":[25,55],"techniques":[26],"column-oriented":[28,53],"systems":[29],"in":[30,33],"row-oriented":[31,62,110],"databases,":[32],"a":[34,104,108],"hope":[35],"improve":[37,58],"performance,":[39],"especially":[40],"OLAP":[42],"and":[43,80,88],"data":[44,76],"warehousing":[45],"applications.":[46],"In":[47],"this":[48],"paper,":[49],"we":[50],"show":[51],"that":[52,68],"can":[56],"significantly":[57],"DBMSs.":[63],"We":[64,95],"introduce":[65],"new":[66,82],"operators":[67],"take":[69],"into":[70],"account":[71],"unique":[73],"characteristics":[74],"obtained":[77],"from":[78],"indexes,":[79],"exploit":[81],"technologies":[83],"such":[84],"as":[85],"flash":[86],"SSDs":[87],"multi-core":[89],"processors":[90],"boost":[92],"performance.":[94],"demonstrate":[96],"our":[97],"approach":[98],"with":[99],"an":[100],"experimental":[101],"study":[102],"using":[103],"prototype":[105],"built":[106],"on":[107],"commercial":[109],"DBMS.":[111]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}