Query By Example in DBMS

Query By Example in DBMS

Query By Example in DBMS

The query language processor is responsible for receiving query language statements and changing them from the English-like syntax of the query language to a form the DBMS can understand. The query language processor usually consists of two separate parts: the parser and the query optimizer.

 

The parser receives query language statements from application programs or command-line utilities and examines the syntax of the statements to ensure they are correct. To do this, the parser breaks a statement down into basic units of syntax and examines them to make sure each statement consists of the proper component parts. If the statements follow the syntax rules, the tokens are passed to the query optimizer.

Query By Example in DBMS
Query By Example in DBMS

 

The query optimiser examines the query language statement, and tries to choose the best and most efficient way of executing the query. To do this, the query optimizer will generate several query plans in which operations are performed in different orders, and then try to estimate which plan will execute most efficiently. When making this estimate, the query optimizer may examine factors such as: CPU time, disk time, network time, sorting methods, and scanning methods.

Also Read 

Deadlock in DBMS

Deadlock in DBMS

Architecture Of DBMA

Architecture Of DBMA

DBMS Full Form

DBMS Full Form

Also Read :-  Networking 

 

Leave a Comment

Your email address will not be published. Required fields are marked *