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.00012970078
Overall Rank
939 | 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.00064031282
331 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.0002077683
389 QPipe: A Simultaneously Pipelined Relational Query Engine 2005 SIGMOD 0.00019269777
634 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00015373122
702 Database Architecture Evolution: Mammals Flourished long before Dinosaurs became Extinct 2009 VLDB 0.00014673738
2,689 Major Technical Advancements in Apache Hive 2014 SIGMOD 8.1264718e-05
3,093 Lazy Evaluation of Transactions in Database Systems 2014 SIGMOD 7.6559585e-05
4,011 Deployment of Query Plans on Multicores 2015 VLDB 6.8573269e-05
4,577 To Share or Not to Share? 2007 VLDB 6.523408e-05
4,871 Improving Database Performance on Simultaneous Multithreading Processors 2005 VLDB 6.3737342e-05
4,986 Indexing for Interactive Exploration of Big Data Series 2014 SIGMOD 6.3264608e-05
5,325 BriskStream: Scaling Data Stream Processing on Shared-Memory Multicore Architectures 2019 SIGMOD 6.1799622e-05
5,734 Cache-Efficient Fork-Processing Patterns on Large Graphs 2021 SIGMOD 6.0137932e-05
6,025 Near-Data Processing in Database Systems on Native Computational Storage under HTAP Workloads 2022 VLDB 5.9119514e-05
6,784 STEPS Towards Cache-Resident Transaction Processing 2004 VLDB 5.6828195e-05
6,970 Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning 2021 SIGMOD 5.6311067e-05
8,780 QPPT: Query Processing on Prefix Trees 2013 CIDR 5.2776055e-05
9,617 MCC-DB: Minimizing Cache Conflicts in Multi-core Processors for Databases 2009 VLDB 5.1507816e-05
13,032 Bridging the Gap between OLAP and SQL 2005 VLDB 4.9793485e-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.0023947656
27 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB 0.0005158963
48 Weaving Relations for Cache Performance 2001 VLDB 0.00043805923
69 Making B+-Trees Cache Conscious in Main Memory 2000 SIGMOD 0.00037950385
76 Cache Conscious Algorithms for Relational Query Processing 1994 VLDB 0.00036898845
110 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB 0.00032700879
207 Cache Conscious Indexing for Decision-Support in Main Memory 1999 VLDB 0.00024970987
548 Improving Index Performance through Prefetching 2001 SIGMOD 0.00016569534
1,107 Buffering Accesses to Memory-Resident Index Structures 2003 VLDB 0.00011993663
1,586 Fractal Prefetching B+-Trees: Optimizing Both Cache and Disk Performance 2002 SIGMOD 0.00010146135
2,016 Optimizing Multidimensional Index Trees for Main Memory Access 2001 SIGMOD 9.1771614e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 4,899 Micro-architectural Analysis of In-memory OLTP 2016 SIGMOD
2 2,918 Database Architectures for New Hardware 2004 VLDB
3 110 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB
4 8,983 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,267 Buffer Pool Aware Query Optimization 2005 CIDR
7 11,429 Sampling-based Predictive Database Buffer Management 2025 VLDB
8 2,295 In-Memory Performance for Big Data 2015 VLDB
9 76 Cache Conscious Algorithms for Relational Query Processing 1994 VLDB
10 1,107 Buffering Accesses to Memory-Resident Index Structures 2003 VLDB