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: 9330
Venue: VLDB
Year: 2005
Pagerank: 5.6164816e-05
Overall Rank: 5,226 | 63.69%
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,179	Asynchronous Memory Access Chaining	2016	VLDB	7.4350144e-05
3,225	Interleaving with Coroutines: A Practical Approach for Robust Index Joins	2018	VLDB	7.3487507e-05
4,089	In-Cache Query Co-Processing on Coupled CPU-GPU Architectures	2015	VLDB	6.4559891e-05
6,649	Grizzly: Efficient Stream Processing Through Adaptive Query Compilation	2020	SIGMOD	4.9724735e-05
8,785	FishStore: Faster Ingestion with Subset Hashing	2019	SIGMOD	4.4467731e-05
8,858	Automatic Contention Detection and Amelioration for Data-Intensive Operations	2010	SIGMOD	4.4302008e-05
9,289	MCC-DB: Minimizing Cache Conflicts in Multi-core Processors for Databases	2009	VLDB	4.3585828e-05
12,471	Optimization of Frequent Itemset Mining on Multiple-Core Processor	2007	VLDB	4.1905499e-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.00066322421
104	Making B+-Trees Cache Conscious in Main Memory	2000	SIGMOD	0.00049475932
124	DBMSs On A Modern Processor: Where Does Time Go?	1999	VLDB	0.0004501099
240	Cache Conscious Indexing for Decision-Support in Main Memory	1999	VLDB	0.00031526134
622	Improving Index Performance through Prefetching	2001	SIGMOD	0.00018976783
1,046	Buffering Database Operations for Enhanced Instruction Cache Performance	2004	SIGMOD	0.00014446882
1,195	Buffering Accesses to Memory-Resident Index Structures	2003	VLDB	0.00013404419
1,659	Fractal Prefetching B+-Trees: Optimizing Both Cache and Disk Performance	2002	SIGMOD	0.00010970279
1,807	Main-Memory Index Structures with Fixed-Size Partial Keys	2001	SIGMOD	0.0001047644
1,987	Optimizing Multidimensional Index Trees for Main Memory Access	2001	SIGMOD	9.8561164e-05
6,439	STEPS Towards Cache-Resident Transaction Processing	2004	VLDB	5.0550138e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
8,173	The Power of Methods With Parallel Semantics	1991	VLDB	4.5640563e-05
2,329	A Case for Staged Database Systems	2003	CIDR	9.0237899e-05
7,832	Effective Resource Utilization for Multiprocessor Join Execution	1989	VLDB	4.636825e-05
6,338	An Almost-Serial Protocol for Transaction Execution in Main-Memory Database Systems	2002	VLDB	5.1000849e-05
959	Rethinking SIMD Vectorization for In-Memory Databases	2015	SIGMOD	0.00015034808
124	DBMSs On A Modern Processor: Where Does Time Go?	1999	VLDB	0.0004501099
8,858	Automatic Contention Detection and Amelioration for Data-Intensive Operations	2010	SIGMOD	4.4302008e-05
5,567	Rethinking MIMD-SIMD Interplay for Analytical Query Processing in In-Memory Database Engines	2025	CIDR	5.4288714e-05
12,575	Optimistic Intra-Transaction Parallelism on Chip Multiprocessors	2005	VLDB	4.1905499e-05
343	Implementing Database Operations Using SIMD Instructions	2002	SIGMOD	0.00026756534