Object Query Optimization through Detecting Independent Subqueries
نویسندگان
چکیده
Database Switching includes execution of queries on same or different machines connected in LAN with different backend without rewriting any queries. Switching between the databases reduces the work of rewriting the queries for each of the database thus saving time. User just has to select the Source DBMS and Table from that DBMS and a switch file is created on a click of a button. Now this switch file can be used in any machine (can be a remote machine) to switch data in any of the DBMS. Database GUI helps a user to do all database operations through a GUI provided with minimal knowledge of the database. Here user can do all database activities like Creating Table, Inserting Data, Joining two tables etc with minimal knowledge of queries without having the knowledge of whole database can access through GUI.
منابع مشابه
Query Optimization in Object Oriented Databases through Detecting Independent Subqueries
Query optimization is the refining process in database administration and it helps to bring down speed of execution. Some object-oriented languages allows to express queries explicitly in the code, which are optimized using the query optimization techniques from the database domain. With respect to this, a formalized object query language (OQL) has been developed that performs optimization of q...
متن کاملImplementation of Optimization in Object-Oriented Queries
Query optimization techniques are dependent upon the query model and language. The query model, in turn, is based on the data (or object) model since it defines the access primitives which are used by the query model. These primitives determine the power of the query model. Object-oriented languages allow expressing queries explicitly in the code, which are optimized using the query optimizatio...
متن کاملOptimization of Object-Oriented Queries through Rewriting Compound Weakly Dependent Subqueries
A new static optimization method for object-oriented queries is presented. We deal with a special class of subqueries of a given query called “compound weakly dependent subqueries”. The dependency is considered in the context of SBQL non-algebraic query operators like selection, projection, join, etc. A subquery is weakly dependent from its nearest non-algebraic operator if it depends only on e...
متن کاملNested Queries in Object Bases
Many declarative query languages for object oriented oo databases allow nested subqueries This paper contains the rst algebra which is capable of handling arbitrary nested queries and the rst complete classi cation of oo nested queries and the according unnesting strategies For unnesting a two phase approach is used The rst phase called dependency based optimization transforms queries at the qu...
متن کاملClassification And Optimization of Nested Queries in Object Bases
Many declarative query languages for object-oriented (oo) databases allow nested subqueries. This paper contains a complete classiication of oo nested queries and appropriate unnesting optimization strategies based on algebraic rewriting. We adapt some known relational techniques and introduce new ones that use and are concerned with features speciic to object-oriented queries. In particular, w...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید
ثبت ناماگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید
ورودعنوان ژورنال:
- Inf. Syst.
دوره 25 شماره
صفحات -
تاریخ انتشار 2000