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
10379
Venue
VLDB
Year
2012
Pagerank
0.00011833779
Overall Rank
1,470 | 89.78%
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
542 Shark: SQL and Rich Analytics at Scale 2013 SIGMOD 0.00020595648
1,477 Fine-grained Partitioning for Aggressive Data Skipping 2014 SIGMOD 0.00011770865
1,487 Scuba: Diving into Data at Facebook 2013 VLDB 0.00011701099
1,588 Druid: A Real-time Analytical Data Store 2014 SIGMOD 0.00011239313
1,943 Procella: Unifying serving and analytical data at YouTube 2019 VLDB 0.00010012569
2,062 Dremel: A Decade of Interactive SQL Analysis at Web Scale 2020 VLDB 9.6481955e-05
3,355 F1 Query: Declarative Querying at Scale 2018 VLDB 7.1829142e-05
3,737 Skipping-oriented Partitioning for Columnar Layouts 2017 VLDB 6.8033227e-05
4,767 Pinot: Realtime OLAP for 530 Million Users 2018 SIGMOD 5.9364731e-05
4,905 Randomized Error Removal for Online Spread Estimation in Data Streaming 2021 VLDB 5.8398332e-05
5,120 Fast Database Restarts at Facebook 2014 SIGMOD 5.6803959e-05
5,315 Cuckoo Index: A Lightweight Secondary Index Structure 2020 VLDB 5.5723424e-05
6,136 Scalable Progressive Analytics on Big Data in the Cloud 2013 VLDB 5.1928748e-05
6,298 Hillview: A trillion-cell spreadsheet for big data 2019 VLDB 5.1226987e-05
6,402 BigLake: BigQuery’s Evolution toward a Multi-Cloud Lakehouse 2024 SIGMOD 5.079818e-05
6,870 Stat! - An Interactive Analytics Environment for Big Data 2013 SIGMOD 4.9004414e-05
8,189 Cohort Query Processing 2017 VLDB 4.5642142e-05
8,357 Cubrick: Indexing Millions of Records per Second for Interactive Analytics 2016 VLDB 4.5373339e-05
8,415 Pruning in Snowflake: Working Smarter, Not Harder 2025 SIGMOD 4.5197687e-05
11,055 Enhancing Accuracy for Super Spreader Identification in High-Speed Data Streams 2024 VLDB 4.1945683e-05
11,993 A Partitioning Framework for Aggressive Data Skipping 2014 VLDB 4.1945683e-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
21 C-Store: A Column-oriented DBMS 2005 VLDB 0.00086087497
35 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.00076197749
109 Dremel: Interactive Analysis of Web-Scale Datasets 2010 VLDB 0.00048186983
131 Integrating Compression and Execution in Column-Oriented Database Systems 2006 SIGMOD 0.0004370331
368 Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing 1998 VLDB 0.000254931
422 Non First Normal Form Relations To Represent Hierarchically Organized Data 1984 PODS 0.00023677809
497 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00021716559
695 2Q: A Low Overhead High Performance Buffer Management Replacement Algorithm 1994 VLDB 0.00018061376
1,590 Column-oriented Database Systems 2009 VLDB 0.00011233838
2,017 The Researcher’s Guide to the Data Deluge: Querying a Scientific Database in Just a Few Seconds 2011 VLDB 9.7810458e-05
2,229 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.2350274e-05
2,444 Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries 2008 VLDB 8.8076551e-05
2,531 The CompleteSearch Engine: Interactive, Efficient, and Towards IR & DB Integration 2007 CIDR 8.5911728e-05
3,916 Compressing Large Boolean Matrices Using Reordering Techniques 2004 VLDB 6.6328898e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
5,604 Design and Evaluation of Storage Organizations for Read-Optimized Main Memory Databases 2013 VLDB 5.4147933e-05
1,053 A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database 2009 SIGMOD 0.00014429683
11,572 Workload-Aware Column Imprints 2020 SIGMOD 4.1945683e-05
4,012 Columnar Storage and List-based Processing for Graph Database Management Systems 2021 VLDB 6.5335884e-05
21 C-Store: A Column-oriented DBMS 2005 VLDB 0.00086087497
131 Integrating Compression and Execution in Column-Oriented Database Systems 2006 SIGMOD 0.0004370331
497 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00021716559
4,445 The Impact of Columnar In-Memory Databases on Enterprise Systems: Implications of Eliminating Transaction-Maintained Aggregates 2014 VLDB 6.1808093e-05
710 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00017765454
1,590 Column-oriented Database Systems 2009 VLDB 0.00011233838