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






Parsing and translation


Translate the query into its internal form. This is then translated into relational algebra. Parser checks syntax, verifies relations.




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 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 98 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

​Read Or Refer


Recent New Topics :