{"id":"https://openalex.org/W2003580796","doi":"https://doi.org/10.14778/2350229.2350259","title":"Processing a trillion cells per mouse click","display_name":"Processing a trillion cells per mouse click","publication_year":2012,"publication_date":"2012-07-01","ids":{"openalex":"https://openalex.org/W2003580796","doi":"https://doi.org/10.14778/2350229.2350259","mag":"2003580796"},"language":"en","primary_location":{"id":"doi:10.14778/2350229.2350259","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2350229.2350259","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5003829918","display_name":"Alexander Hall","orcid":"https://orcid.org/0000-0002-5866-2221"},"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":"Alexander Hall","raw_affiliation_strings":["Google, Inc","GOOGLE INC "],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google, Inc","institution_ids":["https://openalex.org/I1291425158"]},{"raw_affiliation_string":"GOOGLE INC ","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022697118","display_name":"Olaf Bachmann","orcid":null},"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":"Olaf Bachmann","raw_affiliation_strings":["Google, Inc","GOOGLE INC "],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google, Inc","institution_ids":["https://openalex.org/I1291425158"]},{"raw_affiliation_string":"GOOGLE INC ","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038554519","display_name":"Robert B\u00fcssow","orcid":null},"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":"Robert B\u00fcssow","raw_affiliation_strings":["Google, Inc","GOOGLE INC "],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google, Inc","institution_ids":["https://openalex.org/I1291425158"]},{"raw_affiliation_string":"GOOGLE INC ","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5083408098","display_name":"Silviu G\u0103nceanu","orcid":null},"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":"Silviu G\u0103nceanu","raw_affiliation_strings":["Google, Inc","GOOGLE INC "],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google, Inc","institution_ids":["https://openalex.org/I1291425158"]},{"raw_affiliation_string":"GOOGLE INC ","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5051123931","display_name":"Marc Nunkesser","orcid":null},"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":"Marc Nunkesser","raw_affiliation_strings":["Google, Inc","GOOGLE INC "],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google, Inc","institution_ids":["https://openalex.org/I1291425158"]},{"raw_affiliation_string":"GOOGLE INC ","institution_ids":["https://openalex.org/I1291425158"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":13.0423,"has_fulltext":false,"cited_by_count":90,"citation_normalized_percentile":{"value":0.98966711,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":100},"biblio":{"volume":"5","issue":"11","first_page":"1436","last_page":"1446"},"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.9995999932289124,"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.9995999932289124,"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.9991999864578247,"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"}},{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9976999759674072,"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.8504851460456848},{"id":"https://openalex.org/keywords/memory-footprint","display_name":"Memory footprint","score":0.6819005608558655},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.599422812461853},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.5642363429069519},{"id":"https://openalex.org/keywords/footprint","display_name":"Footprint","score":0.46047037839889526},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4577670395374298},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.32914215326309204},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.25966793298721313},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.12487360835075378}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8504851460456848},{"id":"https://openalex.org/C74912251","wikidata":"https://www.wikidata.org/wiki/Q6815727","display_name":"Memory footprint","level":2,"score":0.6819005608558655},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.599422812461853},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.5642363429069519},{"id":"https://openalex.org/C132943942","wikidata":"https://www.wikidata.org/wiki/Q2562511","display_name":"Footprint","level":2,"score":0.46047037839889526},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4577670395374298},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.32914215326309204},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.25966793298721313},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.12487360835075378},{"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/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","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}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.14778/2350229.2350259","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2350229.2350259","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.258.9554","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.258.9554","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://research.google.com/pubs/archive/40379.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5699999928474426,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":29,"referenced_works":["https://openalex.org/W1494049834","https://openalex.org/W1514659981","https://openalex.org/W1565225458","https://openalex.org/W1570051269","https://openalex.org/W1785933978","https://openalex.org/W1981420413","https://openalex.org/W1998964210","https://openalex.org/W2003549201","https://openalex.org/W2005112390","https://openalex.org/W2020635076","https://openalex.org/W2025051251","https://openalex.org/W2032866865","https://openalex.org/W2072764742","https://openalex.org/W2080600916","https://openalex.org/W2085601491","https://openalex.org/W2106867122","https://openalex.org/W2114720809","https://openalex.org/W2119565742","https://openalex.org/W2123686039","https://openalex.org/W2124851765","https://openalex.org/W2126683703","https://openalex.org/W2144570882","https://openalex.org/W2167631575","https://openalex.org/W2173213060","https://openalex.org/W3138367763","https://openalex.org/W3139115194","https://openalex.org/W4238584892","https://openalex.org/W6637957267","https://openalex.org/W6678708722"],"related_works":["https://openalex.org/W2330537534","https://openalex.org/W2368534554","https://openalex.org/W2181722423","https://openalex.org/W2148469257","https://openalex.org/W2999244305","https://openalex.org/W2168827721","https://openalex.org/W2347222412","https://openalex.org/W2085601491","https://openalex.org/W3137434606","https://openalex.org/W4372263373"],"abstract_inverted_index":{"Column-oriented":[0],"database":[1],"systems":[2,19],"have":[3,20],"been":[4],"a":[5,115,125,132],"real":[6],"game":[7],"changer":[8],"for":[9],"the":[10,26,45,52,59,87,92,99,136],"industry":[11],"in":[12,36,101,135],"recent":[13],"years.":[14],"Highly":[15],"tuned":[16],"and":[17,75,96],"performant":[18],"evolved":[21],"that":[22,124],"provide":[23],"users":[24],"with":[25,65],"possibility":[27],"of":[28,51,55,61,86],"answering":[29],"ad":[30],"hoc":[31],"queries":[32],"over":[33],"large":[34,111],"datasets":[35],"an":[37],"interactive":[38,117],"manner.":[39],"In":[40,106],"this":[41,107],"paper":[42],"we":[43,109],"present":[44],"column-oriented":[46],"datastore":[47],"developed":[48],"as":[49,70],"one":[50],"central":[53],"components":[54],"PowerDrill.":[56],"It":[57],"combines":[58],"advantages":[60],"columnar":[62],"data":[63,81],"layout":[64],"other":[66],"known":[67],"techniques":[68],"(such":[69],"using":[71],"composite":[72],"range":[73],"partitions)":[74],"extensive":[76],"algorithmic":[77],"engineering":[78],"on":[79],"key":[80],"structures.":[82],"The":[83],"main":[84,93],"goal":[85],"latter":[88],"being":[89],"to":[90,97,130],"reduce":[91],"memory":[94],"footprint":[95],"increase":[98],"efficiency":[100],"processing":[102,131],"typical":[103],"user":[104],"queries.":[105],"combination":[108],"achieve":[110],"speed-ups.":[112],"These":[113],"enable":[114],"highly":[116],"Web":[118],"UI":[119],"where":[120],"it":[121],"is":[122],"common":[123],"single":[126],"mouse":[127],"click":[128],"leads":[129],"trillion":[133],"values":[134],"underlying":[137],"dataset.":[138]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":6},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":8},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":9},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":9},{"year":2015,"cited_by_count":6},{"year":2014,"cited_by_count":15},{"year":2013,"cited_by_count":13},{"year":2012,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}