Centralized versus Distributed Index Schemes in OODBMS - A Performance Analysis

Recent work on client-server data-shipping OODBs has demonstratedthe usefulnessof localdatacachingat clientsites. In addition to data caching, index caching can provide substantial benets through associative access to cached objects. Indexes usually have high contention,and databaseperformanceis quite sensitive totheindexmanagementscheme. This paperexaminesthee ects of two index caching schemes, one centralized and the other distributed, for index page managementin a page server OODB. In the centralized scheme, index pages are not allowed to be cached at client sites and are managed by the server. The distributed index management scheme supports inter-transaction caching of index pages at client sites, and enforces a distributed index consistency control protocol similar to that of data pages. We study via simulation the performance of these two index management schemesunderseveraldi erentworkloadsand contentionpro les, and identify scenarios where each of the two schemes performs bet...

• Type: Conference
• Year: 1997
• Where: ADBIS
• Authors: Julie Basu, Arthur M. Keller, Meikel Pöss
• Keywords: ADBIS 1997, Database, Distributed Index, Index Caching Schemes, Index Pages