A Case Study of Object-Oriented Repository using the Principles of Caching and Pre-Computation

Abstract

We looked at the query result cache and how it may be utilized to optimize commonly used searches in this
paper. When the amount of I/O and CPU effort required to repeat the results is substantial, the cache can
provide significant performance advantages. We provide significant strategies for query optimization on
object- oriented databases utilizing the concepts of caching and no-caching in this study. Using indexing hint
for no-cache and result cache hint for cache, we created various query plans. We demonstrate how caching
is effective for query optimization in an object-oriented database system in the experimental results.