Home | SCIENCE | Query Processing

Business Science - Information Management - Database Management Systems

Query Processing

   Posted On :  15.12.2016 07:33 am

Upper levels of the data integration problem, Basic Steps in Query Processing.

Query Processing

 

            Upper levels of the data integration problem

 

     How to construct mappings from sources to a single mediated schema

 

     How queries posed over the mediated schema are reformulated over the sources

 

 

            Basic Steps in Query Processing

 

            Parsing and translation

 

            Optimization

 

            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.A relational algebra expression may have many equivalent expressions. Each relational algebra operation can be evaluated using one of several different algorithms. Correspondingly, a relational-algebra expression can be evaluated in many ways. Annotated expression specifying detailed evaluation strategy is called an evaluation-plan.

 

Query Optimization

 

Amongst all equivalent evaluation plans choose the one with lowest cost. Cost is estimated using statistical information from the database catalog.

 



SQL

 

SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in relational database.

 

SQL is the standard language for Relation Database System. All relational database management systems like MySQL, MS Access, and Oracle, Sybase, Informix, postgres and SQL Server use SQL as standard database language.

 

Tags : Business Science - Information Management - Database Management Systems
Last 30 days 19 views
Related words :

What is Query Processing Define Query Processing Definition of Query Processing where how meaning of Query Processing lecturing notes for Query Processing lecture notes question and answer for Query Processing answer Query Processing study material Query Processing assignment Query Processing reference description of Query Processing explanation of Query Processing brief detail of Query Processing easy explanation solution Query Processing wiki Query Processing wikipedia how why is who were when is when did where did Query Processing list of Query Processing school assignment college assignment Query Processing college notes school notes kids with diagram or figure or image difference between Query Processing www.readorrefer.in - Read Or Refer

​TOP MENU

OTHER SUGEST TOPIC