Register now or log in to join your professional community.
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.
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
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.