Describe the components of the query processor. DBMS

Query Processor: As query is very much necessary to find out only the data user need from tons of data of the database, query processor is very important to process these query requests. Query processors come with the following components,

  1. DDL Interpreter: It interprets the DDL statements and records the definitions in data dictionary. 
  2. DML Compiler: It translates the DML statements in a query language into an evaluation plan consisting of low-level instructions that the query evaluation understands. It also performs query optimization which actually picks up the lowest cost evaluation plan from various alternatives.
  3. Query Evaluation Engine: It executes the low level instruction compiled by the DML compiler. 
Briefly describe the two-tier and three-tier architecture. DBMS

Author: Tanmay Chakrabarty

Tanmay Chakrabarty is a former CSE student, currently working as a Senior Software Engineer with 5+ years of experience in the field of Web Application development in PHP+MySQL platform with strong skills in Javascript, JQuery, JQuery UI and CSS. He tries to write notes every week but fails due to heavy loads of duty.

Recommended Recommends


Contact Us