DBMSs On A Modern Processor: Where Does Time Go?

Summary: Framework to study DBMS query time on modern CPUs with a memory-resident DBMS; tests four commercial DBMSs on Intel Xeon to isolate CPU/memory effects from I/O. Findings: optimize L2 data-cache placement and reduce L1 I-cache stalls via instruction scheduling; however overall time reductions are limited without addressing subtle issues like branch prediction. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 8573
Venue: VLDB
Year: 1999
Pagerank: 0.0004501099
Overall Rank: 124 | 99.15%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 15 of 65 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
8,101	Micro-architectural Analysis of OLAP: Limitations and Opportunities	2020	VLDB	4.581825e-05
8,779	EaseDB: A Cache-Oblivious In-Memory Query Processor	2007	SIGMOD	4.4485572e-05
8,858	Automatic Contention Detection and Amelioration for Data-Intensive Operations	2010	SIGMOD	4.4302008e-05
8,973	Planting Trees for scalable and efficient Canonical Hub Labeling	2020	VLDB	4.4148296e-05
9,289	MCC-DB: Minimizing Cache Conflicts in Multi-core Processors for Databases	2009	VLDB	4.3585828e-05
9,448	Lachesis: Robust Database Storage Management Based on Device-specific Performance Characteristics	2003	VLDB	4.3368058e-05
9,742	Databases in the Era of Memory-Centric Computing	2025	CIDR	4.2856385e-05
9,822	Thriving in the No Man’s Land between Compilers and Databases	2019	CIDR	4.2713516e-05
9,840	BTrim – Hybrid In-Memory Database Architecture for Extreme Transaction Processing in VLDBs	2018	VLDB	4.2692221e-05
10,190	P-MOSS: Scheduling Main-Memory Indexes Over NUMA Servers Using Next Token Prediction	2026	SIGMOD	4.1905499e-05
10,992	High-Performance Query Processing with NVMe Arrays: Spilling without Killing Performance	2024	SIGMOD	4.1905499e-05
12,064	DBMS Metrology: Measuring Query Time	2013	SIGMOD	4.1905499e-05
12,207	A Demonstration of HYRISE—A Main Memory Hybrid Storage Engine	2011	VLDB	4.1905499e-05
12,420	Towards Efficient Main-Memory Use For Optimum Tree Index Update	2008	VLDB	4.1905499e-05
12,681	Analyzing Energy Behavior of Spatial Access Methods for Memory-Resident Data	2001	VLDB	4.1905499e-05

Outgoing Citations (Sorted by Pagerank)

Showing 4 of 4 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
81	Cache Conscious Algorithms for Relational Query Processing	1994	VLDB	0.00055253195
85	AlphaSort: A RISC Machine Sort	1994	SIGMOD	0.00053652634
236	High-Performance Sorting on Networks of Workstations	1997	SIGMOD	0.00031790391
1,289	Memory Management during Run Generation in External Sorting	1998	SIGMOD	0.00012779036

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
12,436	Managing Query Compilation Memory Consumption to Improve DBMS Throughput	2007	CIDR	4.1905499e-05
1,046	Buffering Database Operations for Enhanced Instruction Cache Performance	2004	SIGMOD	0.00014446882
9,742	Databases in the Era of Memory-Centric Computing	2025	CIDR	4.2856385e-05
1,077	What happens during a Join? Dissecting CPU and Memory Optimization Effects	2000	VLDB	0.00014224986
81	Cache Conscious Algorithms for Relational Query Processing	1994	VLDB	0.00055253195
11,958	Databases and Hardware: The Beginning and Sequel of a Beautiful Friendship	2015	VLDB	4.1905499e-05
6,116	Database Processing-in-Memory: An Experimental Study	2020	VLDB	5.1995375e-05
52	Database Architecture Optimized for the new Bottleneck: Memory Access	1999	VLDB	0.00066322421
2,782	Database Servers on Chip Multiprocessors: Limitations and Opportunities	2007	CIDR	8.1278531e-05
2,582	Database Architectures for New Hardware	2004	VLDB	8.4982366e-05