Saturday, October 23, 2010

Data Dictionary /Language

Data Dictionary
Provides detailed accounting of all tables found within the user/designer-created database
-contains (at least) all the attribute names and characteristics for each table in the system
-contains metadata—data about data
-sometimes described as “the database designer’s database” because it records the design decisions about tables and their structures

Data Definition Language (DDL)
Used to built data, define data types and data structure in a database.
-describes the records, fields, and "sets" making up the user Data Model

Data Manipulation Language (DML)
Is that of SQL, which is used to retrieve and manipulate data in a Relational database. Comprises the 'SQL-data change' statements, which modify stored data but not the schema or database objects
-have their functional capability organized by the initial word in a statement, which is almost always a verb. In the case of SQL, these verbs are:
SELECT 
INSERT 
UPDATE 
DELETE

No comments:

Post a Comment