Dml precompiler in database management system, Database Management System

DML Precompiler

All the DBMS have two basic sets of Languages - Data Definition Language (DDL) that have the set of commands needed to define the format of the data that is being stored and Data Manipulation Language (DML) which tells the set of commands that modify, process data to make user definable output. The DML statements can as well be written in an application program. The DML precompiler changes DML statements (such as SELECT...FROM in Structured Query Language (SQL) covered in Block 2) embedded in an application program to normal procedural calls in the host language. The precompiler relate with the query processor in order to produce the appropriate code.

 

Posted Date: 3/5/2013 5:09:38 AM | Location : United States







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

Write discussion on Dml precompiler in database management system
Your posts are moderated
Related Questions
Creating views with Replace option : This option is used to alter the definition of the view without recreating and dropping it or regranting object privileges previously granted o

Explain the conventions for displaying an ER schema as an ER diagram? An E-R Diagram scheme might describe certain constraints to that the contents of a database must conform.

While sorting, if the main storage available is not enough, the system writes data to an external help file.  The SAP profile parameter, which determines DIR_SORTTMP


With the help of an example display how records can be deleted and updated in QBE. (i) Increase Pay_Rate of employees along with the skill of ‘cook' by 10%. (ii) Delete employee

1. Determine the set of minimal functional dependencies for the following data. The local bakery, Happy Cakes, needs your help designing a database that will support a kiosk in

Submit SQL INSERT Statements that will populate the database with sample data.  You must insert at least 5 records into each table in your database.Submit your SQL INSERT Statement

a.  Construct a query around any one of the functional divisions you made in 4a such that if executed in the distributed design of 4 would require reconstruction of at least two ho

What are the benefits of prepared statements and place holders? Parameter binding operations automatically handle escaping of characters Encourage Statement reuse

This project will involve designing and creating a database for an organization.  In the design of a database, there is no single "perfect" design.  So your database design may not