• Cite Icon52
  • https://doi.org/10.14778/1687627.1687670Copy DOI Icon

MCC-DB

Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
Abstract

In a typical commercial multi-core processor, the last level cache (LLC) is shared by two or more cores. Existing studies have shown that the shared LLC is beneficial to concurrent query processes with commonly shared data sets. However, the shared LLC can also be a performance bottleneck to concurrent queries, each of which has private data structures, such as a hash table for the widely used hash join operator, causing serious cache conflicts. We show that cache conflicts on multi-core processors can significantly degrade overall database performance. In this paper, we propose a hybrid system method called MCC-DB for accelerating executions of warehouse-style queries, which relies on the DBMS knowledge of data access patterns to minimize LLC conflicts in multi-core systems through an enhanced OS facility of cache partitioning. MCC-DB consists of three components: (1) a cacheaware query optimizer carefully selects query plans in order to balance the numbers of cache-sensitive and cache-insensitive plans; (2) a query execution scheduler makes decisions to co-run queries with an objective of minimizing LLC conflicts; and (3) an enhanced OS kernel facility partitions the shared LLC according to each query's cache capacity need and locality strength. We have implemented MCC-DB by patching the three components in PostgreSQL and Linux kernel. Our intensive measurements on an Intel multi-core system with warehouse-style queries show that MCC-DB can reduce query execution times by up to 33%.

Similar Papers
  • Research Article
  • Citations5

Efficient Cache Resizing policy for DRAM-based LLCs in ChipMultiprocessors

  • Sep 17, 2020
  • Journal of Systems Architecture
  • Bindu Agarwalla +2
  • PDF
  • Preprint Article

Performance analysis of coalesce private or spill shared (CPOSS) replacement strategy overLRU to handle directory entry evictions from the slice last level cache (LLC) using a scalable coherent sparse directory in Multicore processor

  • May 06, 2024
  • Research Square
  • Narottam Sahu +3
  • Conference Article
  • Citations1

LLC Buffer for Arbitrary Data Sharing in Heterogeneous Systems

  • Dec 01, 2016
  • Yu Licheng +5
  • Research Article
  • Citations2

Energy-Efficient Cache Partitioning Using Machine Learning for Embedded Systems

  • Jan 01, 2023
  • Jordan Journal of Electrical Engineering
  • Samar Nour +2
  • Conference Article
  • Citations6

Exploiting Secrets by Leveraging Dynamic Cache Partitioning of Last Level Cache

  • Feb 01, 2021
  • Anurag Agarwal +2
  • Research Article
  • Citations9

RESTRAIN: A dynamic and cost-efficient resource management scheme for addressing performance interference in NFV-based systems

  • Jan 07, 2022
  • Journal of Network and Computer Applications
  • Venkatarami Reddy Chintapalli +3
  • Conference Article
  • Citations11

Reducing Shared Cache Contention by Scheduling Order Adjustment on Commodity Multi-cores

  • May 01, 2011
  • Yingxin Wang +5
  • Conference Article
  • Citations18

Parity++: Lightweight Error Correction for Last Level Caches

  • Jun 01, 2018
  • Irina Alam +3
  • Conference Article
  • Citations4

Energy Efficient Last Level Caches via Last Read/Write Prediction

  • Oct 01, 2013
  • Marco A.Z Alves +3
  • Conference Article
  • Citations2

PV-aware Replacement Policy for Two-level Shared Cache

  • Dec 01, 2022
  • Bindu Agarwalla +2
  • Conference Article

A Novel Prefetch Technique for High Performance Embedded System

  • Oct 01, 2014
  • Hong Jun Choi +3
  • Conference Article
  • Citations9

Improving energy efficiency of embedded DRAM caches for high-end computing systems

  • Jun 23, 2014
  • Sparsh Mittal +2
  • Book Chapter

Towards Efficient Dynamic LLC Home Bank Mapping with NoC-Level Support

  • Jan 01, 2013
  • Mario Lodde +2
  • Book Chapter
  • Citations3

A Survey of Low Power Design Techniques for Last Level Caches

  • Jan 01, 2018
  • Emmanuel Ofori-Attah +2
  • Book Chapter
  • Citations2

PLSS: A Scheduler for Multi-core Embedded Systems

  • Jan 01, 2017
  • Solomon Abera +2
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.