D. Choy, C. Mohan. Locking Protocols for Two-Tier Indexing of Partitioned Data. Proc. International Workshop on Advanced Transaction Models and Architectures, 1996.  Home/Search   Document Details and Download   Summary   Related Articles   Check

....view maintenance in a parallel RDBMS. By global index we mean an index that maps from each value x in a non partitioning attribute c of a relation to the global row ids of all the tuples that have value x in attribute c. Global indices are well known in practice and in the research literature [2]. Like auxiliary relations, to our knowledge the use of global indices for join view maintenance has not been discussed in the literature. We investigate the performance of the three materialized join view maintenance methods with an analytical model. Also, we validate the analytical model for ....

D. Choy, C. Mohan. Locking Protocols for Two-Tier Indexing of Partitioned Data. Proc. International Workshop on Advanced Transaction Models and Architectures, 1996.

....the scheduler is asked to fetch only the index tree(s) In the second phase, the index tree(s) are scanned and only fragments found to contain qualifying tuples are scheduled for fetching. Another solution to the unclustered index scan problem is to maintain two tier indexing as suggested in [3]. 5.2 Evaluating alternative approaches So far we have assumed that the database system has full control of the tertiary memory and is the only application using it. This may not be true in many existing systems. Managing massive storage systems is expensive; hence these systems are usually ....

D. Choy and C. Mohan. Locking protocols for two-tier indexing for partitioned data. Technical Report IBM Research Report, IBM Almaden Research Center, Jun 1993.

Online articles have much greater impact   More about CiteSeer.IST   Add search form to your site   Submit documents   Feedback  

CiteSeer.IST - Copyright Penn State and NEC