Sheetal S. Dhande¹ & G. R. Bamnote², ¹Sipna's College of Engg & Tech, India and ²Prof. Ram Meghe.Institute of Research, India

This paper is based on relatively newer approach for query optimization in object databases, which uses query decomposition and cached query results to improve execution a query. Issues that are focused here is fast retrieval and high reuse of cached queries, Decompose Query into Sub query, Decomposition of complex queries into smaller for fast retrieval of result. Here we try to address another open area of query caching like handling wider queries. By using some parts of cached results helpful for answering other queries (wider Queries) and combining many cached queries while producing the result. Multiple experiments were performed to prove the productivity of this newer way of optimizing a query. The limitation of this technique is that it’s useful especially in scenarios where data manipulation rate is very low as compared to data retrieval rate.

Query Caching, Query Decomposition, Query Optimization, Stack Based Approach (SBA), Stack-Based Query Language (SBQL), Object Databases.