Performance Gains Using Subpages for Cache Ceherency Control

• Authors: Andreas Listl;Giannis Bozas
• Venue: DEXA '97 Proceedings of the 8th International Workshop on Database and Expert Systems Applications
• Year: 1997

When implementing a shared disk database management system one of the major problems is how to realize an efficient cache coherency mechanism. Most of the solutions proposed use pages as the granularity for concurrency and coherency control. Under high data contention this granularity is not capable of achieving the scalability goal. In this paper we describe a new approach called Virtual DataBase Cache, that maintains concurrency control and cache coherency at subpage-level in order to reduce data contention. VDBC allows multiple readers and multiple writers concurrently on a page. It also supports different subpage sizes for different tables resp. segments. Our extensive performance analysis, presented here, clearly shows that our approach is superior to a page-based method.