Ddl compiler-database management system, Database Management System

DDL Compiler

The DDL compiler changes the data definition statements (such as CREATE TABLE .... in SQL) into a set of tables having metadata tables. These tables have information concerning the database and are in a form that can be used by other parts of the DBMS. These tables are then stored in a system catalog or data dictionary.

 

Posted Date: 3/5/2013 5:10:50 AM | Location : United States







Related Discussions:- Ddl compiler-database management system, Assignment Help, Ask Question on Ddl compiler-database management system, Get Answer, Expert's Help, Ddl compiler-database management system Discussions

Write discussion on Ddl compiler-database management system
Your posts are moderated
Related Questions
What is NULL? Give an example to described testing for NULL in SQL? The NULL SQL keyword is used to represent either a missing value or a value which is not applicable in a re

What are the advantages of object ID? The main advantages of Object IDs are as below: i) IDs are not changing  ii) IDs are completely independent of the changes in data v

can you please explain with the help of suitable example the difference between conflict equivalence and conflict serializability?

Describe the difference between a one-to-many and a many-to-many relationship. Which logical data structures comprise one-to-many and which comprise many-to-many relationship?

What are three components of the schema architecture proposed by ANSI/SPARC? The three component schema architecture proposed by ANSI/SPARC is as given below: External sche

Define the terms entity, attribute, role and relationship between the entities, giving examples for each of them.         Ans: Entity:   An entity is a "thing" or "object" in th

Hot Backup: Some sites cannot terminate the database while creating a backup copy of the files. The cold backup is not a reliable option. So different kinds of backing up database

Horizontal Fragmentation- Horizontal fragmentation groups together the tuples in a relation that are collectively used by the main transactions. A horizontal fragment is produced b

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

Dependency Preservation It is obvious that the decomposition must be lossless so that we do not lose any information from the relation that is decomposed. Dependency preservati