DBScholar

Back to papers

Buffering Database Operations for Enhanced Instruction Cache Performance

Summary: Buffering DB operations to reduce instruction-cache thrash; introduces a lightweight buffer operator and plan refinement to insert buffers where beneficial. In memory-resident PostgreSQL, yields up to 80% fewer instruction-cache misses and up to 15% query speedup. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
3580
Venue
SIGMOD
Year
2004
Pagerank
0.00013119305
Overall Rank
932 | 93.61%
DOI
10.1145/1007568.1007592

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{zhou_sigmod04,
        title = {{Buffering Database Operations for Enhanced Instruction Cache Performance}},
        author = {Zhou, Jingren and Ross, Kenneth A.},
        series = {{SIGMOD} '04},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1007568.1007592},
        url = {https://dl.acm.org/doi/10.1145/1007568.1007592},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 19 of 19 citing papers.

Rank Citing Paper Year Venue Pagerank
14 MonetDB/X100: Hyper-Pipelining Query Execution 2005 CIDR 0.0006312782
345 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00020656723
383 QPipe: A Simultaneously Pipelined Relational Query Engine 2005 SIGMOD 0.00019520728
630 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00015591796
721 Database Architecture Evolution: Mammals Flourished long before Dinosaurs became Extinct 2009 VLDB 0.00014631814
2,706 Major Technical Advancements in Apache Hive 2014 SIGMOD 8.2287564e-05
3,053 Lazy Evaluation of Transactions in Database Systems 2014 SIGMOD 7.8098188e-05
4,085 Deployment of Query Plans on Multicores 2015 VLDB 6.9149518e-05
4,508 To Share or Not to Share? 2007 VLDB 6.6561159e-05
4,772 Improving Database Performance on Simultaneous Multithreading Processors 2005 VLDB 6.5154736e-05
4,883 Indexing for Interactive Exploration of Big Data Series 2014 SIGMOD 6.4648124e-05
5,206 BriskStream: Scaling Data Stream Processing on Shared-Memory Multicore Architectures 2019 SIGMOD 6.3180444e-05
5,612 Cache-Efficient Fork-Processing Patterns on Large Graphs 2021 SIGMOD 6.1501992e-05
5,917 Near-Data Processing in Database Systems on Native Computational Storage under HTAP Workloads 2022 VLDB 6.043185e-05
6,682 STEPS Towards Cache-Resident Transaction Processing 2004 VLDB 5.8039833e-05
6,848 Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning 2021 SIGMOD 5.7550624e-05
8,625 QPPT: Query Processing on Prefix Trees 2013 CIDR 5.3979222e-05
9,449 MCC-DB: Minimizing Cache Conflicts in Multi-core Processors for Databases 2009 VLDB 5.2665098e-05
12,742 Bridging the Gap between OLAP and SQL 2005 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 11 of 11 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.0024089429
29 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB 0.00052093615
49 Weaving Relations for Cache Performance 2001 VLDB 0.00043781096
67 Making B+-Trees Cache Conscious in Main Memory 2000 SIGMOD 0.00038461275
74 Cache Conscious Algorithms for Relational Query Processing 1994 VLDB 0.00037330605
109 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB 0.000331207
204 Cache Conscious Indexing for Decision-Support in Main Memory 1999 VLDB 0.00025342994
545 Improving Index Performance through Prefetching 2001 SIGMOD 0.00016766463
1,110 Buffering Accesses to Memory-Resident Index Structures 2003 VLDB 0.00012140661
1,567 Fractal Prefetching B+-Trees: Optimizing Both Cache and Disk Performance 2002 SIGMOD 0.00010343873
1,978 Optimizing Multidimensional Index Trees for Main Memory Access 2001 SIGMOD 9.3627341e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 4,866 Micro-architectural Analysis of In-memory OLTP 2016 SIGMOD
2 2,870 Database Architectures for New Hardware 2004 VLDB
3 109 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB
4 8,818 Resource-Adaptive Query Execution with Paged Memory Management 2025 CIDR
5 29 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB
6 4,197 Buffer Pool Aware Query Optimization 2005 CIDR
7 11,071 Sampling-based Predictive Database Buffer Management 2025 VLDB
8 2,267 In-Memory Performance for Big Data 2015 VLDB
9 74 Cache Conscious Algorithms for Relational Query Processing 1994 VLDB
10 1,110 Buffering Accesses to Memory-Resident Index Structures 2003 VLDB