DBScholar

Back to papers

Processing a Trillion Cells per Mouse Click

Summary: PowerDrill combines columnar storage, composite range partitioning, and memory-efficient, heavily engineered structures for interactive ad hoc analytics. Its 10–100× speedups enable a Web UI click to process up to a trillion cells, complementing distributed systems such as Dremel. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
10567
Venue
VLDB
Year
2012
Pagerank
0.00011590013
Overall Rank
1,225 | 91.60%
DOI
10.14778/2350229.2350259

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{hall_vldb12,
        title = {{Processing a Trillion Cells per Mouse Click}},
        author = {Hall, Alexander and Bachmann, Olaf and Büssow, Robert and Gănceanu, Silviu and Nunkesser, Marc},
        journal = {PVLDB},
        series = {{VLDB} '12},
        volume = {5},
        number = {11},
        pages = {1436--1447},
        doi = {10.14778/2350229.2350259},
        url = {https://doi.org/10.14778/2350229.2350259},
        year = {2012}
}

Incoming Citations (Sorted by Pagerank)

Showing 21 of 21 citing papers.

Rank Citing Paper Year Venue Pagerank
425 Shark: SQL and Rich Analytics at Scale 2013 SIGMOD 0.00018704491
1,044 Fine-grained Partitioning for Aggressive Data Skipping 2014 SIGMOD 0.0001244236
1,242 Druid: A Real-time Analytical Data Store 2014 SIGMOD 0.00011516162
1,352 Scuba: Diving into Data at Facebook 2013 VLDB 0.00011064595
1,453 Dremel: A Decade of Interactive SQL Analysis at Web Scale 2020 VLDB 0.00010742227
1,494 Procella: Unifying serving and analytical data at YouTube 2019 VLDB 0.00010577585
2,889 F1 Query: Declarative Querying at Scale 2018 VLDB 7.9935046e-05
3,106 Skipping-oriented Partitioning for Columnar Layouts 2017 VLDB 7.7515666e-05
4,231 Pinot: Realtime OLAP for 530 Million Users 2018 SIGMOD 6.8177976e-05
4,649 BigLake: BigQuery’s Evolution toward a Multi-Cloud Lakehouse 2024 SIGMOD 6.586622e-05
4,782 Cuckoo Index: A Lightweight Secondary Index Structure 2020 VLDB 6.5115802e-05
5,019 Fast Database Restarts at Facebook 2014 SIGMOD 6.3987706e-05
5,385 Randomized Error Removal for Online Spread Estimation in Data Streaming 2021 VLDB 6.2369655e-05
5,676 Scalable Progressive Analytics on Big Data in the Cloud 2013 VLDB 6.1251441e-05
6,028 Hillview: A trillion-cell spreadsheet for big data 2019 VLDB 6.0019322e-05
7,197 Stat! - An Interactive Analytics Environment for Big Data 2013 SIGMOD 5.6763539e-05
7,660 Pruning in Snowflake: Working Smarter, Not Harder 2025 SIGMOD 5.5736132e-05
8,176 Cohort Query Processing 2017 VLDB 5.4736785e-05
8,202 Cubrick: Indexing Millions of Records per Second for Interactive Analytics 2016 VLDB 5.4672903e-05
11,263 Enhancing Accuracy for Super Spreader Identification in High-Speed Data Streams 2024 VLDB 5.093636e-05
12,191 A Partitioning Framework for Aggressive Data Skipping 2014 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
12 C-Store: A Column-oriented DBMS 2005 VLDB 0.00069513174
14 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.0006312782
51 Dremel: Interactive Analysis of Web-Scale Datasets 2010 VLDB 0.0004291425
60 Integrating Compression and Execution in Column-Oriented Database Systems 2006 SIGMOD 0.0003955489
227 Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing 1998 VLDB 0.00023958508
345 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00020656723
538 Non First Normal Form Relations To Represent Hierarchically Organized Data 1984 PODS 0.00016919845
637 2Q: A Low Overhead High Performance Buffer Management Replacement Algorithm 1994 VLDB 0.0001547341
1,395 Column-oriented Database Systems 2009 VLDB 0.00010928358
1,679 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 0.00010029136
1,924 The Researcher's Guide to the Data Deluge: Querying a Scientific Database in Just a Few Seconds 2011 VLDB 9.4775501e-05
2,150 Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries 2008 VLDB 9.081101e-05
3,064 The CompleteSearch Engine: Interactive, Efficient, and Towards IR & DB Integration 2007 CIDR 7.8008109e-05
3,912 Compressing Large Boolean Matrices Using Reordering Techniques 2004 VLDB 7.0231849e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 5,715 Design and Evaluation of Storage Organizations for Read-Optimized Main Memory Databases 2013 VLDB
2 966 A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database 2009 SIGMOD
3 11,768 Workload-Aware Column Imprints 2020 SIGMOD
4 3,357 Columnar Storage and List-based Processing for Graph Database Management Systems 2021 VLDB
5 12 C-Store: A Column-oriented DBMS 2005 VLDB
6 60 Integrating Compression and Execution in Column-Oriented Database Systems 2006 SIGMOD
7 345 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD
8 3,902 The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates 2014 VLDB
9 630 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB
10 1,395 Column-oriented Database Systems 2009 VLDB