A Case Study of Object-Oriented Repository using the Principles of Caching and Pre-Computation
Main Article Content
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.
Downloads
Download data is not yet available.
Article Details
How to Cite
Banubakde, A., & Baranwala, M. M. (2023). A Case Study of Object-Oriented Repository using the Principles of Caching and Pre-Computation. SAMRIDDHI : A Journal of Physical Sciences, Engineering and Technology, 14(Spl-3), 421-427. Retrieved from https://smsjournals.com/index.php/SAMRIDDHI/article/view/3041
Section
Research Article
References
[1] Sam R. Alapati and Charles Kim,” Oracle Database 11g New Features for DBAs and Developers”.
[2] Surajit Chaudhuri,” An Overview of Query Optimization in Relational Systems”, In Proc.of ACM SIGMOD, San Francisco, 1987.
[3] Cluet, S. and Delobel, C., “A General Framework for the Optimization of Object-Oriented Queries”. Proceedings of the ACM SIGMOD Conference, pp.383- 392, 1992.
[4] Laura M. Haas, Donald Kossmann, Ioana Ursu,” Loading a Cache with Query Results”IBM Almaden, University of Passau,IBM Almaden.
[5] Goetz Graefe,” Executing Nested Queries, Microsoft Corporation Redmond, WA 98052-6399.
[6] Chungmin Melvin Chen and Nicholas Roussopoulos,” The Implementation and Performance Evaluation of the ADMS Query Optimizer: Integrating Query Result Caching and Matching” Department of Computer Science University of Maryland, College Park MD 20742, USA.
[7] Kjetil Nørvag," The Persistent Cache: Improving OID Indexing in Temporal Object-Oriented Database Systems" Department of Computer and Information Science Norwegian University of Science and Technology, Norway.
8] Joseph M. Hellerstein,Jeffrey F. Naughton ,” Query Execution Techniques for Caching Expensive Methods”, University of Wisconsin , Department of Computer Sciences,1210 W. Dayton St., Madison, I 53706.
[9] Nalluri, S. K., Parasaram, V. K. B., & Bathini, V. T. (2021). Autonomous Manufacturing Operations Using Intelligent MES and Cloud-Native Analytics. Journal of Multidisciplinary Knowledge, 1(1), 45–55. Retrieved from https://jmk.datatablets.com/index.php/j/article/view/127 [10] Minyar Sassi, and Amel Grissa-Touzi “Contribution to the Query Optimization in the Object-oriented Databases” Proceedings of world academy of Science, Engineering and Technology Volume 6 ISSN June 2005 1307-6884.
[11] Haridasa Acharya and Abhijit Banubakode , “Query Optimization in the Object-Oriented Database Using Views”, Proc. International Conference On Computing ICC 2010,NewDelhi 27-28 December 2010.
[12] Haridasa Acharya and Abhijit Banubakode “Query Optimization In The Object-oriented Database
Using Equi-join” Advances in Computational Sciences and Technology Print: ISSN 0973-6107, Online ISSN 0974- 4738 Volume 4 Number 1 (2011) pp. 83–94 © Research India Publications.
[13] Haridasa Acharya and Abhijit Banubakode “Query Optimization on Compressed and Decompressed Object- Oriented Database Using Operators” International Journal on Computer Science and Engineering (IJCSE) e-ISSN: 0975–3397 (online version); Print ISSN:2229- 5631 (Print version); [14] Journal of Object Technology - Achievements and Weaknesses of Object-Oriented.htm BY Sikha Bagui, Department of Computer Science, University of West Florida, U.S.A.
[15] Journal of Object Technology - Achievements and Weaknesses of Object-Oriented.htm BY Sikha Bagui, Department of Computer Science, University of West Florida, U.S.A.
[2] Surajit Chaudhuri,” An Overview of Query Optimization in Relational Systems”, In Proc.of ACM SIGMOD, San Francisco, 1987.
[3] Cluet, S. and Delobel, C., “A General Framework for the Optimization of Object-Oriented Queries”. Proceedings of the ACM SIGMOD Conference, pp.383- 392, 1992.
[4] Laura M. Haas, Donald Kossmann, Ioana Ursu,” Loading a Cache with Query Results”IBM Almaden, University of Passau,IBM Almaden.
[5] Goetz Graefe,” Executing Nested Queries, Microsoft Corporation Redmond, WA 98052-6399.
[6] Chungmin Melvin Chen and Nicholas Roussopoulos,” The Implementation and Performance Evaluation of the ADMS Query Optimizer: Integrating Query Result Caching and Matching” Department of Computer Science University of Maryland, College Park MD 20742, USA.
[7] Kjetil Nørvag," The Persistent Cache: Improving OID Indexing in Temporal Object-Oriented Database Systems" Department of Computer and Information Science Norwegian University of Science and Technology, Norway.
8] Joseph M. Hellerstein,Jeffrey F. Naughton ,” Query Execution Techniques for Caching Expensive Methods”, University of Wisconsin , Department of Computer Sciences,1210 W. Dayton St., Madison, I 53706.
[9] Nalluri, S. K., Parasaram, V. K. B., & Bathini, V. T. (2021). Autonomous Manufacturing Operations Using Intelligent MES and Cloud-Native Analytics. Journal of Multidisciplinary Knowledge, 1(1), 45–55. Retrieved from https://jmk.datatablets.com/index.php/j/article/view/127 [10] Minyar Sassi, and Amel Grissa-Touzi “Contribution to the Query Optimization in the Object-oriented Databases” Proceedings of world academy of Science, Engineering and Technology Volume 6 ISSN June 2005 1307-6884.
[11] Haridasa Acharya and Abhijit Banubakode , “Query Optimization in the Object-Oriented Database Using Views”, Proc. International Conference On Computing ICC 2010,NewDelhi 27-28 December 2010.
[12] Haridasa Acharya and Abhijit Banubakode “Query Optimization In The Object-oriented Database
Using Equi-join” Advances in Computational Sciences and Technology Print: ISSN 0973-6107, Online ISSN 0974- 4738 Volume 4 Number 1 (2011) pp. 83–94 © Research India Publications.
[13] Haridasa Acharya and Abhijit Banubakode “Query Optimization on Compressed and Decompressed Object- Oriented Database Using Operators” International Journal on Computer Science and Engineering (IJCSE) e-ISSN: 0975–3397 (online version); Print ISSN:2229- 5631 (Print version); [14] Journal of Object Technology - Achievements and Weaknesses of Object-Oriented.htm BY Sikha Bagui, Department of Computer Science, University of West Florida, U.S.A.
[15] Journal of Object Technology - Achievements and Weaknesses of Object-Oriented.htm BY Sikha Bagui, Department of Computer Science, University of West Florida, U.S.A.