Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par VENKITARAMAN KRISHNA MOORTHY VRINDAVAN , Project Execution Manager & Accounts Manager , ALI INTERNATIONAL TRADING EST.
Date de publication: 2014/10/06
Vinod Jetley
par 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
par 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
par 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