Database Paper Browser

Back to papers

Weaving Relations for Cache Performance

Summary: Proposes PAX (Partition Attributes Across), a page-internal layout that co-locates attribute values to boost cache performance without changing I/O or storage. Empirical results show 75% less cache stall than NSM; 17–25% faster range and update ops; 11–48% faster I/O-heavy TPC-H queries. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
8742
Venue
VLDB
Year
2001
Pagerank
0.00055735291
Overall Rank
80 | 99.45%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 50 of 101 citing papers.

Rank Citing Paper Year Venue Pagerank
35 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.00076209479
132 Integrating Compression and Execution in Column-Oriented Database Systems 2006 SIGMOD 0.00043697853
167 The Snowflake Elastic Data Warehouse 2016 SIGMOD 0.00039408116
238 GPUTeraSort: High Performance Graphics Co-processor Sorting for Large Database Management 2006 SIGMOD 0.00031596093
241 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.00031314629
283 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00029024583
343 Implementing Database Operations Using SIMD Instructions 2002 SIGMOD 0.00026756534
407 Database Cracking 2007 CIDR 0.00023941779
466 A Case for Fractured Mirrors 2002 VLDB 0.00022455567
476 Impala: A Modern, Open-Source SQL Engine for Hadoop 2015 CIDR 0.00022216002
496 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00021705611
594 HYRISE—A Main Memory Hybrid Storage Engine 2011 VLDB 0.00019515008
708 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00017753572
729 Umbra: A Disk-Based System with In-Memory Performance 2020 CIDR 0.00017448059
754 Database Architecture Evolution: Mammals Flourished long before Dinosaurs became Extinct 2009 VLDB 0.00017093267
790 Conjunctive Selection Conditions in Main Memory 2002 PODS 0.0001659522
1,027 Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS 2007 VLDB 0.0001458537
1,046 Buffering Database Operations for Enhanced Instruction Cache Performance 2004 SIGMOD 0.00014446882
1,100 Generic Database Cost Models for Hierarchical Memory Systems 2002 VLDB 0.00014062265
1,260 Data Blocks: Hybrid OLTP and OLAP on Compressed Storage using both Vectorization and Compilation 2016 SIGMOD 0.00012990853
1,296 The DataPath System: A Data-Centric Analytic Processing Engine for Large Data Warehouses 2010 SIGMOD 0.00012742585
1,342 Query Processing on Smart SSDs: Opportunities and Challenges 2013 SIGMOD 0.00012482124
1,434 Fast Checkpoint Recovery Algorithms for Frequently Consistent Applications 2011 SIGMOD 0.00011988283
1,659 Fractal Prefetching B+-Trees: Optimizing Both Cache and Disk Performance 2002 SIGMOD 0.00010970279
1,685 Fast Computation of Database Operations using Graphics Processors 2004 SIGMOD 0.0001090924
1,697 Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads 2016 SIGMOD 0.00010859294
1,801 H2O: A Hands-free Adaptive Store 2014 SIGMOD 0.00010485628
1,945 Cheetah: A High Performance, Custom Data Warehouse on Top of MapReduce 2010 VLDB 0.0001000706
2,003 Data Morphing: An Adaptive, Cache-Conscious Storage Technique 2003 VLDB 9.8198787e-05
2,137 How to Wring a Table Dry: Entropy Compression of Relations and Querying of Compressed Relations 2006 VLDB 9.463768e-05
2,329 A Case for Staged Database Systems 2003 CIDR 9.0237899e-05
2,367 Here are my Data Files. Here are my Queries. Where are my Results? 2011 CIDR 8.9502761e-05
2,372 Predictable Performance for Unpredictable Workloads 2009 VLDB 8.940791e-05
2,390 ByteSlice: Pushing the Envelop of Main Memory Data Processing with a New Storage Layout 2015 SIGMOD 8.9006978e-05
2,414 Towards a One Size Fits All Database Architecture 2011 CIDR 8.8572378e-05
2,509 Path Queries on Compressed XML 2003 VLDB 8.6250598e-05
2,562 Rose: Compressed, log-structured replication 2008 VLDB 8.5373135e-05
2,658 Data Warehousing and Analytics Infrastructure at Facebook 2010 SIGMOD 8.3634079e-05
2,782 Database Servers on Chip Multiprocessors: Limitations and Opportunities 2007 CIDR 8.1278531e-05
2,998 Major Technical Advancements in Apache Hive 2014 SIGMOD 7.7477264e-05
3,070 HAWQ: A Massively Parallel Processing SQL Engine in Hadoop 2014 SIGMOD 7.6157391e-05
3,120 Llama: Leveraging Columnar Storage for Scalable Join Processing in the MapReduce Framework 2011 SIGMOD 7.533894e-05
3,193 Column-Oriented Storage Techniques for MapReduce 2011 VLDB 7.4073719e-05
3,279 The Case for RodentStore, an Adaptive, Declarative Storage System 2009 CIDR 7.2816693e-05
3,358 An Object Placement Advisor for DB2 Using Solid State Storage 2009 VLDB 7.1724434e-05
3,387 Analytics in Motion: High Performance Event-Processing AND Real-Time Analytics in the Same Database 2015 SIGMOD 7.1505623e-05
3,482 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.0514808e-05
3,707 iGraph: A Framework for Comparisons of Disk-Based Graph Indexing Techniques 2010 VLDB 6.8223857e-05
3,723 Cache-Conscious Radix-Decluster Projections 2004 VLDB 6.8132331e-05
3,761 Read-Optimized Databases, In Depth 2008 VLDB 6.7777865e-05
Previous Page 1 / 3 Next

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 cited papers.

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

Rank Cited Paper Year Venue Pagerank
1 Access Path Selection in a Relational Database Management System 1979 SIGMOD 0.0040465394
2 R-Trees: A Dynamic Index Structure For Spatial Searching 1984 SIGMOD 0.0032118946
52 Database Architecture Optimized for the new Bottleneck: Memory Access 1999 VLDB 0.00066322421
81 Cache Conscious Algorithms for Relational Query Processing 1994 VLDB 0.00055253195
121 Improved Query Performance with Variant Indexes 1997 SIGMOD 0.00045429472
123 A Decomposition Storage Model 1985 SIGMOD 0.00045235743
124 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB 0.0004501099
292 Shoring Up Persistent Applications 1994 SIGMOD 0.00028735468
479 Multi-Step Processing of Spatial Joins 1994 SIGMOD 0.00022182486
549 Hash-Partitioned Join Method Using Dynamic Destaging Strategy 1988 VLDB 0.00020348047
766 Client-Server Paradise 1994 VLDB 0.0001690298
923 Partition Based Spatial-Merge Join 1996 SIGMOD 0.00015254021
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
1,027 Cooperative Scans: Dynamic Bandwidth Sharing in a DBMS 2007 VLDB 0.0001458537
4,107 Cracking the Database Store 2005 CIDR 6.4384924e-05
708 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00017753572
2,741 Cache-Efficient Aggregation: Hashing Is Sorting 2015 SIGMOD 8.1977375e-05
52 Database Architecture Optimized for the new Bottleneck: Memory Access 1999 VLDB 0.00066322421
7,373 Cache-Oblivious Query Processing 2007 CIDR 4.744464e-05
7,039 Tabular Placement of Relational Data on MEMS-based Storage Devices 2003 VLDB 4.8495964e-05
3,723 Cache-Conscious Radix-Decluster Projections 2004 VLDB 6.8132331e-05
81 Cache Conscious Algorithms for Relational Query Processing 1994 VLDB 0.00055253195
2,003 Data Morphing: An Adaptive, Cache-Conscious Storage Technique 2003 VLDB 9.8198787e-05