ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل VENKITARAMAN KRISHNA MOORTHY VRINDAVAN , Project Execution Manager & Accounts Manager , ALI INTERNATIONAL TRADING EST.
تاريخ النشر: 2014/10/06
Vinod Jetley
من قبل 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
من قبل 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
من قبل 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.

المزيد من الأسئلة المماثلة