Database Paper Browser

Back to papers

Processing a Trillion Cells per Mouse Click

Summary: PowerDrill's columnar datastore blends columnar layout with composite range partitions and optimized data structures to shrink main-memory footprint. This yields large speedups enabling an interactive Web UI where a single mouse click processes trillions of values. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
10380
Venue
VLDB
Year
2012
Pagerank
0.00011827274
Overall Rank
1,470 | 89.79%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 21 of 21 citing papers.

Rank Citing Paper Year Venue Pagerank
539 Shark: SQL and Rich Analytics at Scale 2013 SIGMOD 0.00020615453
1,473 Fine-grained Partitioning for Aggressive Data Skipping 2014 SIGMOD 0.00011786148
1,488 Scuba: Diving into Data at Facebook 2013 VLDB 0.00011690191
1,588 Druid: A Real-time Analytical Data Store 2014 SIGMOD 0.00011232949
1,939 Procella: Unifying serving and analytical data at YouTube 2019 VLDB 0.00010019433
2,060 Dremel: A Decade of Interactive SQL Analysis at Web Scale 2020 VLDB 9.6585115e-05
3,344 F1 Query: Declarative Querying at Scale 2018 VLDB 7.1944106e-05
3,731 Skipping-oriented Partitioning for Columnar Layouts 2017 VLDB 6.8074069e-05
4,766 Pinot: Realtime OLAP for 530 Million Users 2018 SIGMOD 5.933206e-05
4,912 Randomized Error Removal for Online Spread Estimation in Data Streaming 2021 VLDB 5.8342232e-05
5,121 Fast Database Restarts at Facebook 2014 SIGMOD 5.675304e-05
5,316 Cuckoo Index: A Lightweight Secondary Index Structure 2020 VLDB 5.5688295e-05
6,100 Scalable Progressive Analytics on Big Data in the Cloud 2013 VLDB 5.2064148e-05
6,302 Hillview: A trillion-cell spreadsheet for big data 2019 VLDB 5.1166201e-05
6,397 BigLake: BigQuery’s Evolution toward a Multi-Cloud Lakehouse 2024 SIGMOD 5.0749432e-05
6,875 Stat! - An Interactive Analytics Environment for Big Data 2013 SIGMOD 4.8957561e-05
8,189 Cohort Query Processing 2017 VLDB 4.5598377e-05
8,353 Cubrick: Indexing Millions of Records per Second for Interactive Analytics 2016 VLDB 4.5331059e-05
8,410 Pruning in Snowflake: Working Smarter, Not Harder 2025 SIGMOD 4.5154358e-05
11,058 Enhancing Accuracy for Super Spreader Identification in High-Speed Data Streams 2024 VLDB 4.1905499e-05
12,001 A Partitioning Framework for Aggressive Data Skipping 2014 VLDB 4.1905499e-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
20 C-Store: A Column-oriented DBMS 2005 VLDB 0.00086163998
35 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.00076209479
109 Dremel: Interactive Analysis of Web-Scale Datasets 2010 VLDB 0.00048217028
132 Integrating Compression and Execution in Column-Oriented Database Systems 2006 SIGMOD 0.00043697853
367 Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing 1998 VLDB 0.00025518228
421 Non First Normal Form Relations To Represent Hierarchically Organized Data 1984 PODS 0.00023654912
496 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00021705611
693 2Q: A Low Overhead High Performance Buffer Management Replacement Algorithm 1994 VLDB 0.00018045505
1,590 Column-oriented Database Systems 2009 VLDB 0.00011230525
1,844 The Researcher’s Guide to the Data Deluge: Querying a Scientific Database in Just a Few Seconds 2011 VLDB 0.00010339715
2,231 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.2367968e-05
2,442 Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries 2008 VLDB 8.8067249e-05
2,530 The CompleteSearch Engine: Interactive, Efficient, and Towards IR & DB Integration 2007 CIDR 8.5942205e-05
3,918 Compressing Large Boolean Matrices Using Reordering Techniques 2004 VLDB 6.6267457e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
5,612 Design and Evaluation of Storage Organizations for Read-Optimized Main Memory Databases 2013 VLDB 5.4104818e-05
1,050 A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database 2009 SIGMOD 0.00014425459
11,576 Workload-Aware Column Imprints 2020 SIGMOD 4.1905499e-05
4,017 Columnar Storage and List-based Processing for Graph Database Management Systems 2021 VLDB 6.5276062e-05
20 C-Store: A Column-oriented DBMS 2005 VLDB 0.00086163998
132 Integrating Compression and Execution in Column-Oriented Database Systems 2006 SIGMOD 0.00043697853
496 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00021705611
4,445 The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates 2014 VLDB 6.1754623e-05
708 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00017753572
1,590 Column-oriented Database Systems 2009 VLDB 0.00011230525