MCC-DB: Minimizing Cache Conflicts in Multi-core Processors for Databases

Summary: MCC-DB tackles LLC contention among concurrent warehouse queries with private structures by combining cache-aware plan selection, conflict-minimizing co-scheduling, and OS-level cache partitioning. PostgreSQL/Linux implementation cuts execution time by up to 33%. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 10055
Venue: VLDB
Year: 2009
Pagerank: 5.2665098e-05
Overall Rank: 9,449 | 35.18%
DOI: 10.14778/1687627.1687670

Incoming Non-self Citations Over Time

Authors

1. Rubao Lee (Chinese Academy of Sciences; Ohio State University)
2. Xiaoning Ding (Ohio State University)
3. Feng Chen (Ohio State University)
4. Qingda Lu (Ohio State University)
5. Xiaodong Zhang (Ohio State University)

BibTeX Citation

@article{lee_vldb09,
        title = {{MCC-DB: Minimizing Cache Conflicts in Multi-core Processors for Databases}},
        author = {Lee, Rubao and Ding, Xiaoning and Chen, Feng and Lu, Qingda and Zhang, Xiaodong},
        journal = {PVLDB},
        series = {{VLDB} '09},
        doi = {10.14778/1687627.1687670},
        url = {https://doi.org/10.14778/1687627.1687670},
        year = {2009}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
4,085	Deployment of Query Plans on Multicores	2015	VLDB	6.9149518e-05
4,603	The Art of Balance: A RateupDB Experience of Building a CPU/GPU Hybrid Database Product	2021	VLDB	6.6105578e-05

Outgoing Citations (Sorted by Pagerank)

Showing 16 of 16 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
29	Database Architecture Optimized for the New Bottleneck: Memory Access	1999	VLDB	0.00052093615
67	Making B+-Trees Cache Conscious in Main Memory	2000	SIGMOD	0.00038461275
109	DBMSs On A Modern Processor: Where Does Time Go?	1999	VLDB	0.000331207
135	An Evaluation of Buffer Management Strategies for Relational Database Systems	1985	VLDB	0.00030209257
151	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD	0.00029161879
632	Adaptive Aggregation on Chip Multiprocessors	2007	VLDB	0.00015575286
637	2Q: A Low Overhead High Performance Buffer Management Replacement Algorithm	1994	VLDB	0.0001547341
696	Main-Memory Scan Sharing For Multi-Core CPUs	2008	VLDB	0.00014891322
932	Buffering Database Operations for Enhanced Instruction Cache Performance	2004	SIGMOD	0.00013119305
1,028	Generic Database Cost Models for Hierarchical Memory Systems	2002	VLDB	0.00012557617
1,110	Buffering Accesses to Memory-Resident Index Structures	2003	VLDB	0.00012140661
1,143	Toward a Progress Indicator for Database Queries	2004	SIGMOD	0.00011999403
2,451	One Size Fits All? – Part 2: Benchmarking Results	2007	CIDR	8.560157e-05
2,679	Database Servers on Chip Multiprocessors: Limitations and Opportunities	2007	CIDR	8.2675008e-05
4,197	Buffer Pool Aware Query Optimization	2005	CIDR	6.8406917e-05
4,772	Improving Database Performance on Simultaneous Multithreading Processors	2005	VLDB	6.5154736e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	9,903	Recovery Protocols for Shared Memory Database Systems	1995	SIGMOD
2	2,870	Database Architectures for New Hardware	2004	VLDB
3	8,962	Automatic Contention Detection and Amelioration for Data-Intensive Operations	2010	SIGMOD
4	3,198	Scaling Multicore Databases via Constrained Parallel Execution	2016	SIGMOD
5	12,087	A Multicore Database Is Not a Distributed System	2015	CIDR
6	109	DBMSs On A Modern Processor: Where Does Time Go?	1999	VLDB
7	3,013	Opportunities for Optimism in Contended Main-Memory Multicore Transactions	2020	VLDB
8	696	Main-Memory Scan Sharing For Multi-Core CPUs	2008	VLDB
9	932	Buffering Database Operations for Enhanced Instruction Cache Performance	2004	SIGMOD
10	2,713	Robust Query Processing in Co-Processor-accelerated Databases	2016	SIGMOD