Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Query processing-What are the essential features of Query processing?

user-image
Question added by VENKITARAMAN KRISHNA MOORTHY VRINDAVAN , Project Execution Manager & Accounts Manager , ALI INTERNATIONAL TRADING EST.
Date Posted: 2014/10/06
Vinod Jetley
by Vinod Jetley , Assistant General Manager , State Bank of India

 

Basic Steps in Query Processing

1. Parsing & translation

2. Optimization

3. Evaluation

 

Parsing and translation

 

Translate the query into its internal form.

 

This is then translated into relational algebra.

 

Parser checks syntax, verifies relations

 

 Evaluation

 

  The query-execution engine takes a query-evaluation plan, executes that plan, and returns the answers to the query.

 

 Optimization

 

 Finding the cheapest evaluation plan for a query.

 

 

hossam azzam
by hossam azzam , Fast food restaurant,s manager. , alexandria-egypt

Thanks for the invitation

The essential features of query processing :

 Parsing and translation

 Optimization

Evaluation

Agreed with both descriptions given

by the excellent answers of

Mr.:Jayyousi & Mr.:Jetley

as well too

amer jayyousi
by amer jayyousi , Business Development Consultant , freelance

I believe they are :

1.Query parsing and translation where we verify that the mention relation does exist and work on replacing the views,then we have to transform the SQL query to a query plan represented by a relational algebra expression.

2.Query optimization through which we should be able to transform the initial quey plan to its optimimal stage.

3.Query evaluation through which we execute the query plan and return optimal results.

More Questions Like This