Tuesday, December 6, 2011

The Importance and use of data dictionaries

If you order your cheap custom paper from our custom writing service you will receive a perfectly written assignment on The Importance and use of data dictionaries. What we need from you is to provide us with your detailed paper instructions for our experienced writers to follow all of your specific writing requirements. Specify your order details, state the exact number of pages required and our custom writing professionals will deliver the best quality The Importance and use of data dictionaries paper right on time.

Out staff of freelance writers includes over 120 experts proficient in The Importance and use of data dictionaries, therefore you can rest assured that your assignment will be handled by only top rated specialists. Order your The Importance and use of data dictionaries paper at affordable prices with cheap custom writing service!



Introduction


A data dictionary is a collection of descriptions of the data objects or items in a database for the benefit of programmers and others who need to refer to them. This includes the names of all tables, the table schemas, location of tables, view definitions, details about indexes, access rights etc. Data dictionaries do not contain any actual data from the database, only bookkeeping information for managing it. Without a data dictionary, however, a database management system cannot access data from the database.


Types of Data Dictionaries


Data dictionaries are either passive or active. An active system is always consistent with the database structure, because it is maintained automatically by the system. Programs include an automated data dictionary as part of the program. In this way, all the information about a database is captured into a document as the database is created. Therefore, the database design (showing all the tables and their relationships, primary keys, foreign keys), and the properties of a database (fields, data types, validation rules, size of the fields) can be easily referenced by the developers and the users of a database system.


Write my Essay on The Importance and use of data dictionaries

essay writing service



Passive systems may not be consistent with the database, as users may change it. If the database is part of a database management system (DBMS) as in the case of EC, it is called an integrated data dictionary. Passive data dictionaries are useful, too. In the initial stages of a design a standalone dictionary is used to set up the table structures. However, ultimately this is integrated into the overall program.


The role of the data dictionary


As you may know, many different objects are stored in the database. First, we store tables, and we have users who own and/or access the data in those tables. There are indexes, views, stored procedures, functions and other objects as well. In order for the database to do its job, it needs to know about all of these objects. For instance, when you select data from a table, the database needs to determine if that table even exists! If it exists, do the columns you specified exist in that table? Do you have the requisite privileges to access data in that table? If you query a view, what is the underlying SQL text of that view? If you access a stored procedure, what code makes up that procedure?


So many questions go on behind the scenes. Where does the database turn to answer these questions? It goes to the Data Dictionary. The Data Dictionary holds information about the objects in the database. The database system manages the Data Dictionary for you. For example, when you create a new table, the Data Dictionary will be updated to reflect this change to the database.


Why we need a data dictionary


· To assist in the design of the database


· To assist in the maintenance of the data dictionary


· To allow a query language to retrieve data


· To inform application programs of the data format


· To enable the database administrator to monitor usage etc.


A data dictionary is therefore an essential aspect of any dbms system and hold a lot of indepth information about all objects in the system.








Please note that this sample paper on The Importance and use of data dictionaries is for your review only. In order to eliminate any of the plagiarism issues, it is highly recommended that you do not use it for you own writing purposes. In case you experience difficulties with writing a well structured and accurately composed paper on The Importance and use of data dictionaries, we are here to assist you. Your cheap college papers on The Importance and use of data dictionaries will be written from scratch, so you do not have to worry about its originality.

Order your authentic assignment from cheap custom writing service and you will be amazed at how easy it is to complete a quality custom paper within the shortest time possible!



No comments:

Post a Comment

Note: Only a member of this blog may post a comment.