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
folding method and mid square method using visual basic

Which product produces the relation that has attributes of R1 and R2 ? Cartesian product produce the relation which has attributes of R1 and R2

Example: RELATIONAL SCHEMA for PERSON: PERSON (PERSON_ID: integer, NAME: string, AGE: integer, ADDRESS: String) RELATION INSTANCE In this instance, m = 3 and n = 4

The aims of the project are: 1. To enable the students to undertake the detailed design of a specific plant or process 2. The design projects includes: process selection; und

The natural join is equal to which product? The natural join is equal to Combination of projection and Cartesian product

Home based assignment Consider an ORDER table with the following attributes: • Order Number (ONo),Customer Number (CNo),Customer Name (CNa),Item Number (INo),Unit Price (UP), Quant

For every n-ary relationship type R where n>2, we make a new table S to represent R. We contain as foreign key attributes in s the primary keys of the relations that show the parti

What is a SELECT operation? The select operation selects tuples that please a given predicate. We use the lowercase letter σ to denote selection.

Write short notes on data ware housing? Data ware housing applications needs the transformation of data from many sources into a cohesive reliable step set of data configured a

Unrepeatable reads : Assume T7 reads X twice during its implementation. If it did not update X itself it could be very disturbing to see a dissimilar value of X in its next read. B