SQL Query Engine
Data Manipulation Operation is called Query that Request for Information from Database or Update Data in the Database. DML Compiler internally translates Query into Relational Algebra Formula and then converts High Level Statements into Machine Level Code. SQL Query Engine is helps to executes compiled code to Create, Rewrite, Optimize Query and Database Operation.
Data Definition Language
DDL, Data Definition Language is a SQL Application that helps to Create and Maintain Database Structure in the arbitrary formats by using DDL Statements. Database Structure is stores in the Metadata Database. The compiled form of the Database Structure is called Data Dictionary or System Catalog Files.
DDL Interpreter is interacting between System Catalog Files and Physical System Database that helps to read or write data in the Physical System Database.
Data Manipulation Language
DML, Data Manipulation Language is a SQL Application that helps to access or manipulate data with organized Database Structure from Physical System Database by using DML Statements.
DML Compiler is interacting between Database Management Application and SQL Engine that helps to convert High Level DML Query Statements into Machine Level Code and execute through SQL Query Engine.
Embedded DML Compiler
DML Statements can define in the Conventional Programming Language like COBOL, FORTRAN,.NET and JAVA. Directly, Data Manipulation Language Functions imports Application Program Query is called Preprocessor Statements that replaced by appropriate procedure statements through Preprocessor or Embedded DML Compiler.
Embedded DML Compiler is interacting between Application Program and SQL Engine that helps to convert Application Program High Level Query Statements into Machine Level Code and execute through SQL Query Engine.
|Your Comment To AUTHOR