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
h8a87b49acc7013c6
Venue
SIGMOD
Year
2004
Pagerank
0.0001293608
Overall Rank
943 | 93.69%
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.00063972112
332 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.00020739447
390 QPipe: A Simultaneously Pipelined Relational Query Engine 2005 SIGMOD 0.00019232929
635 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00015334073
702 Database Architecture Evolution: Mammals Flourished long before Dinosaurs became Extinct 2009 VLDB 0.0001464107
2,700 Major Technical Advancements in Apache Hive 2014 SIGMOD 8.096888e-05
3,097 Lazy Evaluation of Transactions in Database Systems 2014 SIGMOD 7.6354651e-05
3,860 Deployment of Query Plans on Multicores 2015 VLDB 6.9512283e-05
4,594 To Share or Not to Share? 2007 VLDB 6.4994689e-05
4,893 Improving Database Performance on Simultaneous Multithreading Processors 2005 VLDB 6.3500196e-05
5,013 Indexing for Interactive Exploration of Big Data Series 2014 SIGMOD 6.30259e-05
5,347 BriskStream: Scaling Data Stream Processing on Shared-Memory Multicore Architectures 2019 SIGMOD 6.1566135e-05
5,735 Cache-Efficient Fork-Processing Patterns on Large Graphs 2021 SIGMOD 5.9957538e-05
6,031 Near-Data Processing in Database Systems on Native Computational Storage under HTAP Workloads 2022 VLDB 5.8909681e-05
6,804 STEPS Towards Cache-Resident Transaction Processing 2004 VLDB 5.66191e-05
6,977 Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning 2021 SIGMOD 5.6135617e-05
8,806 QPPT: Query Processing on Prefix Trees 2013 CIDR 5.257679e-05
9,640 MCC-DB: Minimizing Cache Conflicts in Multi-core Processors for Databases 2009 VLDB 5.134315e-05
13,080 Bridging the Gap between OLAP and SQL 2005 VLDB 4.9605343e-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.0023948467
27 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB 0.0005146739
48 Weaving Relations for Cache Performance 2001 VLDB 0.00043770511
68 Making B+-Trees Cache Conscious in Main Memory 2000 SIGMOD 0.00037861537
77 Cache Conscious Algorithms for Relational Query Processing 1994 VLDB 0.00036821827
111 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB 0.00032621499
209 Cache Conscious Indexing for Decision-Support in Main Memory 1999 VLDB 0.00024915373
548 Improving Index Performance through Prefetching 2001 SIGMOD 0.00016534019
1,106 Buffering Accesses to Memory-Resident Index Structures 2003 VLDB 0.00011960288
1,588 Fractal Prefetching B+-Trees: Optimizing Both Cache and Disk Performance 2002 SIGMOD 0.00010115044
2,029 Optimizing Multidimensional Index Trees for Main Memory Access 2001 SIGMOD 9.1470713e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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