Query processor in database management system, Database Management System

Query Processor

The query language processor is responsible for taking query language statements or shifting them from the English-like syntax of the query language to a form the DBMS can know. The query language processor commonly consists of two separate elements: the parser or the query optimizer.

The parsers receive query language statements to the command-line utilities or application programs and study the syntax of the statements to make sure they are right. To do this, the parsers splits a statement down into primary units of syntax and study them to make sure each statement consists of the proper component elements. If the statements follow the syntax rules, the tokens are approved to the query optimizer.

The query optimiser displays the query language statement, and tries to selected the best and most efficient way of implementing the query. To do this, the query optimizer will make various query plans in that operations are performed in dissimilar orders, and then try to compute taht plan will implement most efficiently. While making this estimation, the query optimizer might show factors like as: disk time, network time, CPU time, scanning methods or sorting methods.

 

Posted Date: 3/5/2013 5:20:55 AM | Location : United States







Related Discussions:- Query processor in database management system, Assignment Help, Ask Question on Query processor in database management system, Get Answer, Expert's Help, Query processor in database management system Discussions

Write discussion on Query processor in database management system
Your posts are moderated
Related Questions
In the first unit of this block, you have been given with the details of the Database Management System, its structure, advantages etc. This unit is an attempt to give you informat

In which relational modes, cardinality is termed? Answer : Cardinality is termed in a number of tuples relational modes.

Give the general form of SQL query? Select  A1, A2............., An From  R1, R2..............., Rm Where  P


Events4Fun is an event management company in Europe with branches in South America as well. The company is well-known for its efficiency, good-quality services, and affordable char

Determine object representation As a designer, we must choose properly that when to use primitive types in representing objects and when to combine groups of related objects,

You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR managem

A file of employee have 10,000 blocks on a cylinder of a disk with characteristics r=8ms and btt=0.6ms I want to know the cost of read inthe file under following conditions for a q

Partial Key : It is a group of attributes that can uniquely identify small entities and that are related to same base entity. It is sometime named as Discriminator.  Altern

What is the main advantage of the object model? What are its different components? The object model focuses on the logical data structures. Each object model comprises of many