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: 8572
Venue: VLDB
Year: 1999
Pagerank: 0.00045103515
Overall Rank: 124 | 99.14%
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,096	Micro-architectural Analysis of OLAP: Limitations and Opportunities	2020	VLDB	4.5860565e-05
8,782	EaseDB: A Cache-Oblivious In-Memory Query Processor	2007	SIGMOD	4.452826e-05
8,858	Automatic Contention Detection and Amelioration for Data-Intensive Operations	2010	SIGMOD	4.4344518e-05
8,967	Planting Trees for scalable and efficient Canonical Hub Labeling	2020	VLDB	4.4190656e-05
9,284	MCC-DB: Minimizing Cache Conflicts in Multi-core Processors for Databases	2009	VLDB	4.362769e-05
9,442	Lachesis: Robust Database Storage Management Based on Device-specific Performance Characteristics	2003	VLDB	4.3410889e-05
9,743	Databases in the Era of Memory-Centric Computing	2025	CIDR	4.2897489e-05
9,823	Thriving in the No Man’s Land between Compilers and Databases	2019	CIDR	4.2754485e-05
9,841	BTrim – Hybrid In-Memory Database Architecture for Extreme Transaction Processing in VLDBs	2018	VLDB	4.2732806e-05
10,190	P-MOSS: Scheduling Main-Memory Indexes Over NUMA Servers Using Next Token Prediction	2026	SIGMOD	4.1945683e-05
10,989	High-Performance Query Processing with NVMe Arrays: Spilling without Killing Performance	2024	SIGMOD	4.1945683e-05
12,056	DBMS Metrology: Measuring Query Time	2013	SIGMOD	4.1945683e-05
12,199	A Demonstration of HYRISE—A Main Memory Hybrid Storage Engine	2011	VLDB	4.1945683e-05
12,411	Towards Efficient Main-Memory Use For Optimum Tree Index Update	2008	VLDB	4.1945683e-05
12,672	Analyzing Energy Behavior of Spatial Access Methods for Memory-Resident Data	2001	VLDB	4.1945683e-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.00055548574
84	AlphaSort: A RISC Machine Sort	1994	SIGMOD	0.00053866006
236	High-Performance Sorting on Networks of Workstations	1997	SIGMOD	0.00031779642
1,290	Memory Management during Run Generation in External Sorting	1998	SIGMOD	0.00012795586

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
12,427	Managing Query Compilation Memory Consumption to Improve DBMS Throughput	2007	CIDR	4.1945683e-05
1,050	Buffering Database Operations for Enhanced Instruction Cache Performance	2004	SIGMOD	0.00014453896
9,743	Databases in the Era of Memory-Centric Computing	2025	CIDR	4.2897489e-05
1,079	What happens during a Join? Dissecting CPU and Memory Optimization Effects	2000	VLDB	0.00014233415
81	Cache Conscious Algorithms for Relational Query Processing	1994	VLDB	0.00055548574
11,950	Databases and Hardware: The Beginning and Sequel of a Beautiful Friendship	2015	VLDB	4.1945683e-05
6,114	Database Processing-in-Memory: An Experimental Study	2020	VLDB	5.204248e-05
52	Database Architecture Optimized for the new Bottleneck: Memory Access	1999	VLDB	0.00066474881
2,778	Database Servers on Chip Multiprocessors: Limitations and Opportunities	2007	CIDR	8.1321802e-05
2,582	Database Architectures for New Hardware	2004	VLDB	8.5007371e-05