Identifying Hot and Cold Data in Main-Memory Databases

Download Now
Provided by: Microsoft
Topic: Storage
Format: PDF
Main memories are becoming sufficiently large that most OLTP databases can be stored entirely in main memory, but this may not be the best solution. OLTP workloads typically exhibit skewed access patterns where some records are hot (frequently accessed) but many records are cold (infrequently or never accessed). It is more economical to store the coldest records on secondary storage such as flash. As a first step towards managing cold data in databases optimized for main-memory the authors investigate how to efficiently identify hot and cold data. They propose to log record accesses - possibly only a sample to reduce overhead - and perform offline analysis to estimate record access frequencies.
Download Now

Find By Topic