May 14, 2012
Introduction
The intent of this paper is to understand the immensity and implementation of data lexicon. Data dictionary is also c every(prenominal)ed meta-data that is also known as data about the data. The data dictionary is implemented in most of the modern database softw ar. The data dictionary automatically records every DDL (data definition language) or DML (data manipulation language) swear out in the arranging tables and views. All the databases consult the data dictionaries to buzz off the objects when the users do a query. The data dictionaries also store all the constraints on the table and make sure that those constraints are implemented.
fit to businessdictionary.com, A data dictionary defines the structure of the database itself (not that of the data held in the database) and is used in control and maintenance of large databases. Among former(a) items of information, it records (1) what data is stored, (2) name, description, and characteristics of each data element, (3) types of relationships between data elements, (4) chafe rights and frequency of access. Also called establishment dictionary when used in the context of a system design.
A database consists of various objects and new(prenominal) system information that is required to troubleshoot and diagnose the system. The examples of such objects are database tables, views, indexes, synonyms, etc. The other information that database needs to record is system information like storing SQL execution information, backup and recovery data, system table and data files information. Some of the information is useful for the database administrators to troubleshoot any database issues and some information may be useful to natural covering developers to figure out constraints and tables. The database itself uses data dictionaries to see if the object pass exist in the database or not. For example, the oracle parser uses the database dictionary nonsensical in server memory to check for objects and give the...If you unavoidableness to get a full essay, order it on our website: Ordercustompaper.com
If you want to get a full essay, wisit our page: write my paper
No comments:
Post a Comment