1,611
views
0
recommends
+1 Recommend
1 collections
    0
    shares

      Celebrating 65 years of The Computer Journal - free-to-read perspectives - bcs.org/tcj65

      scite_
       
      • Record: found
      • Abstract: found
      • Conference Proceedings: found
      Is Open Access

      Centralized versus Distributed Index Schemes in OODBMS-A Performance Analysis

      proceedings-article
      , ,
      Proceedings of the First East-European Symposium on Advances in Databases and Information Systems (ADBIS)
      Advances in Databases and Information Systems
      2-5 September 1997
      Bookmark

            Abstract

            Recent work on client-server data-shipping OODBs has demonstrated the usefulness of local data caching at client sites. In addition to data caching, index caching can provide substantial benefits through associative access to cached objects. Indexes usually have high contention, and database performance is quite sensitive to the index management scheme. This paper examines the effects of two index caching schemes, one centralized and the other distributed, for index page management in 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 schemes under several different workloads and contention profiles, and identify scenarios where each of the two schemes performs better than the other.

            Content

            Author and article information

            Contributors
            Conference
            September 1997
            September 1997
            : 1-14
            Affiliations
            [0001]Stanford University

            Computer Science Department

            and Oracle Corporation
            [0002]Stanford University

            Computer Science Department

            Stanford, CA 94305-9020, USA
            [0003]Technical University of Berlin

            Computer Science Department

            D-10587 Berlin, Germany
            Article
            10.14236/ewic/ADBIS1997.4
            59bc3990-f93e-4c1b-b4cf-b14a20a3734d
            © Julie Basu et al. Published by BCS Learning and Development Ltd. Proceedings of the First East-European Symposium on Advances in Databases and Information Systems, (ADBIS'97), St Petersburg

            This work is licensed under a Creative Commons Attribution 4.0 Unported License. To view a copy of this license, visit http://creativecommons.org/licenses/by/4.0/

            Proceedings of the First East-European Symposium on Advances in Databases and Information Systems
            ADBIS
            1
            St Petersburg
            2-5 September 1997
            Electronic Workshops in Computing (eWiC)
            Advances in Databases and Information Systems
            History
            Product

            1477-9358 BCS Learning & Development

            Self URI (article page): https://www.scienceopen.com/hosted-document?doi=10.14236/ewic/ADBIS1997.4
            Self URI (journal page): https://ewic.bcs.org/
            Categories
            Electronic Workshops in Computing

            Applied computer science,Computer science,Security & Cryptology,Graphics & Multimedia design,General computer science,Human-computer-interaction

            Comments

            Comment on this article