Mumbai University > Information Technology > Sem 3 > Database Management System

Marks: 10M

Year: Dec 2015

• A given SQL query is translated by the query processor into a low level program called an execution plan
• An execution plan is a program in a functional language
• The physical relational algebra extends the relational algebra with primitives to search through the internal storage structure of DBMS.

Basic Steps in Query Processing

1. Parsing and translation
2. Optimization
3. Evaluation

1. Parsing and translation
2. Translate the query into its internal form. This is then translated into relational algebra.
3. Parser checks syntax, verifies relation.
4. Optimization
5. SQL is a very high level language:
6. The users specify what to search for- not how the search is actually done
7. The algorithms are chosen automatically by the DBMS.

• For a given SQL query there may be many possible execution plans.
• Amongst all equivalent plans choose the one with lowest cost.
• Cost is estimated using statistical information from the database catalog.
• Evaluation
• The query evaluation engine takes a query evaluation plan, executes that plan and returns the answer to that query.