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.00012964695
Overall Rank
939 | 93.70%
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.00064013679
331 Column-Stores vs. Row-Stores: How Different Are They Really? 2008 SIGMOD 0.0002076806
390 QPipe: A Simultaneously Pipelined Relational Query Engine 2005 SIGMOD 0.00019265472
634 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00015367822
702 Database Architecture Evolution: Mammals Flourished long before Dinosaurs became Extinct 2009 VLDB 0.00014668058
2,689 Major Technical Advancements in Apache Hive 2014 SIGMOD 8.1227087e-05
3,095 Lazy Evaluation of Transactions in Database Systems 2014 SIGMOD 7.6523803e-05
4,012 Deployment of Query Plans on Multicores 2015 VLDB 6.8540959e-05
4,579 To Share or Not to Share? 2007 VLDB 6.5205268e-05
4,873 Improving Database Performance on Simultaneous Multithreading Processors 2005 VLDB 6.370725e-05
4,989 Indexing for Interactive Exploration of Big Data Series 2014 SIGMOD 6.3234684e-05
5,331 BriskStream: Scaling Data Stream Processing on Shared-Memory Multicore Architectures 2019 SIGMOD 6.1770377e-05
5,735 Cache-Efficient Fork-Processing Patterns on Large Graphs 2021 SIGMOD 6.0109463e-05
6,026 Near-Data Processing in Database Systems on Native Computational Storage under HTAP Workloads 2022 VLDB 5.9091528e-05
6,790 STEPS Towards Cache-Resident Transaction Processing 2004 VLDB 5.6801599e-05
6,971 Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning 2021 SIGMOD 5.628441e-05
8,788 QPPT: Query Processing on Prefix Trees 2013 CIDR 5.2751075e-05
9,624 MCC-DB: Minimizing Cache Conflicts in Multi-core Processors for Databases 2009 VLDB 5.1483437e-05
13,038 Bridging the Gap between OLAP and SQL 2005 VLDB 4.9769913e-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.0023943337
27 Database Architecture Optimized for the New Bottleneck: Memory Access 1999 VLDB 0.00051576613
48 Weaving Relations for Cache Performance 2001 VLDB 0.00043795812
68 Making B+-Trees Cache Conscious in Main Memory 2000 SIGMOD 0.00037957995
76 Cache Conscious Algorithms for Relational Query Processing 1994 VLDB 0.00036891569
110 DBMSs On A Modern Processor: Where Does Time Go? 1999 VLDB 0.00032696785
206 Cache Conscious Indexing for Decision-Support in Main Memory 1999 VLDB 0.00024981343
547 Improving Index Performance through Prefetching 2001 SIGMOD 0.00016575635
1,105 Buffering Accesses to Memory-Resident Index Structures 2003 VLDB 0.00011991167
1,586 Fractal Prefetching B+-Trees: Optimizing Both Cache and Disk Performance 2002 SIGMOD 0.00010143882
2,019 Optimizing Multidimensional Index Trees for Main Memory Access 2001 SIGMOD 9.1749414e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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