Member Stickness on Hot Page in Shared Resource System
Publication Date: 2014-Jun-25
The IP.com Prior Art Database
In a resource shared system, several members share disk - pages are shared between multiple members. Sharing also means contention, those pages those are modified by multiple members frequently become "hot". For example, in the high concurrent OLAP workload, new rows are added to a table, then the last page becomes very hot since rows will be inserted into this page. this article will give a idea that, to allocate new page for each member by storing the member id in the page header. Then each member has its own/private page for INSERT - adding new records, INSERT contention is avoided. But the pages/rows are still shared by all the members for read and update.