Indexing Research Papers & Articles
Leading International Journals
Complete List of Indexed Journal will be published on January 2014

The Institute of Electrical and Electronics Engineers is a professional association headquartered in New York City that is dedicated to advancing technological innovation and excellence.

Springer is a global publishing company that publishes books, e-books and peer-reviewed journals in science, technical and medical publishing.

Elsevier B.V. is a publishing company which publishes medical and scientific literature.

Australian Journal of Educational & Developmental Psychology.

Australian Journal of Teacher Education.

Home » A Role of Query Optimization in Relational Database

  1. A Role of Query Optimization in Relational Database

    Author Name: Prof.M.A.Pund, S.R.Jadhao, P.D.Thakare

    Nowadays, we are flooded with information through and from the Databases. We have to deal with a constantly increasing amount of facts, figures and dates. Therefore, it is necessary to somehow store this information in an adequate way. This is what database systems were developed for. One particular approach is the relational databases. In a relational database all information can be found in a series of tables in which data is stored in rows and columns. The problem with SQL query, its declarative ? does not specify a query execution plan and also we have to deal with as a consequence is the question as how to find the specific facts that might interest us amongst all the information stored in the described tables. And as one might put it, ?Time is Money? in our society, it is not only important to find the required information, but also with proper execution plan so that it takes less time. The solution is to convert SQL query to an equivalent relational algebra and evaluates it using the associated query execution plan. This paper will introduce the reader to the basic concepts of query processing and query optimization in the relational database domain. How a database processes a query as well as some of the algorithms and rule-sets utilized to produce more efficient queries will also be presented. I will discuss the implementation plan using join orderingto extend the capabilities of Database Engine program through the use of randomized algorithms iterative improvement method in the database area in the context of query optimization. More specifically, large combinatorial problems such as the multi-join optimization problem have been the most actively applied areas [9]

    Date of published:

    Journal Name: SQL Query optimization, relational database, Query Processing,IJSER


    Keywords: IJSER, International Journal of Scientific & Engineering Research

    Rate This article:
    please wait...

    Average rating: 0