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