Improving Database Performance on Simultaneous Multithreading Processors

Summary: Explores SMT-aware DB design on memory-resident data. Proposes three techniques: independent ops in separate threads; multithreaded operators; a work-ahead set for aggressive cache preloading; reports 30–70% throughput gains vs single-threaded in-memory workloads. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 9329
Venue: VLDB
Year: 2005
Pagerank: 5.6217069e-05
Overall Rank: 5,219 | 63.70%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 8 of 8 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,175	Asynchronous Memory Access Chaining	2016	VLDB	7.438501e-05
3,219	Interleaving with Coroutines: A Practical Approach for Robust Index Joins	2018	VLDB	7.3550716e-05
4,085	In-Cache Query Co-Processing on Coupled CPU-GPU Architectures	2015	VLDB	6.4620277e-05
6,648	Grizzly: Efficient Stream Processing Through Adaptive Query Compilation	2020	SIGMOD	4.9771723e-05
8,788	FishStore: Faster Ingestion with Subset Hashing	2019	SIGMOD	4.451039e-05
8,858	Automatic Contention Detection and Amelioration for Data-Intensive Operations	2010	SIGMOD	4.4344518e-05
9,284	MCC-DB: Minimizing Cache Conflicts in Multi-core Processors for Databases	2009	VLDB	4.362769e-05
12,462	Optimization of Frequent Itemset Mining on Multiple-Core Processor	2007	VLDB	4.1945683e-05

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
52	Database Architecture Optimized for the new Bottleneck: Memory Access	1999	VLDB	0.00066474881
103	Making B+-Trees Cache Conscious in Main Memory	2000	SIGMOD	0.00049150032
124	DBMSs On A Modern Processor: Where Does Time Go?	1999	VLDB	0.00045103515
238	Cache Conscious Indexing for Decision-Support in Main Memory	1999	VLDB	0.00031642425
531	Improving Index Performance through Prefetching	2001	SIGMOD	0.00020790058
1,050	Buffering Database Operations for Enhanced Instruction Cache Performance	2004	SIGMOD	0.00014453896
1,195	Buffering Accesses to Memory-Resident Index Structures	2003	VLDB	0.00013406526
1,659	Fractal Prefetching B+-Trees: Optimizing Both Cache and Disk Performance	2002	SIGMOD	0.00010980701
1,809	Main-Memory Index Structures with Fixed-Size Partial Keys	2001	SIGMOD	0.00010483957
1,983	Optimizing Multidimensional Index Trees for Main Memory Access	2001	SIGMOD	9.8638201e-05
6,447	STEPS Towards Cache-Resident Transaction Processing	2004	VLDB	5.0588602e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
8,172	The Power of Methods With Parallel Semantics	1991	VLDB	4.5684406e-05
2,328	A Case for Staged Database Systems	2003	CIDR	9.0225171e-05
7,839	Effective Resource Utilization for Multiprocessor Join Execution	1989	VLDB	4.637294e-05
6,341	An Almost-Serial Protocol for Transaction Execution in Main-Memory Database Systems	2002	VLDB	5.1037155e-05
958	Rethinking SIMD Vectorization for In-Memory Databases	2015	SIGMOD	0.00015045316
124	DBMSs On A Modern Processor: Where Does Time Go?	1999	VLDB	0.00045103515
8,858	Automatic Contention Detection and Amelioration for Data-Intensive Operations	2010	SIGMOD	4.4344518e-05
5,559	Rethinking MIMD-SIMD Interplay for Analytical Query Processing in In-Memory Database Engines	2025	CIDR	5.4340893e-05
12,566	Optimistic Intra-Transaction Parallelism on Chip Multiprocessors	2005	VLDB	4.1945683e-05
343	Implementing Database Operations Using SIMD Instructions	2002	SIGMOD	0.00026768139