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
The participation Constraints shows whether the existence of an entity depends on its being associated to another entity by the relationship type. There are two kinds of participat

Accessing information about permissions to all users- Object level permissions: With the use of data dictionary you can see the permissions to user. Let us get the table name fro

The Transactions- A transaction is definite as the unit of work in a database system. Database systems that deal with a huge number of transactions are also termed as transaction p

Consider the relation PERSON. If you want to display details of persons having age less than or equal to 30 than the select operation will be used as follows: σ AGE The resu

Question : (a) Database Management Systems (DBMS) is the foundation of business intelligence. Explain the following concepts related to DBMS: (i) Entity Relationship Diagr

Define the term Domain. For each n every attribute there is a set of permitted values known as the domain of that attribute.

Explain the Recoverable Schedule A recoverable schedule is one in which for each pair of transactions Ti and Tj such that Tj reads a data item formerly written by Ti, the comm

Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim

Consider employee (e_no, e_name, e_salary, d_code), dept (d_code, d_name) and dependent (depndt_name, e_no, relation). Show the names of employees in purchase and accounts departm

Question 1 Draw a Data Flow Diagram for a University scenario Question 2 Discuss the following with suitable examples Relational Algebra Operators Database Pla