Data files indices and data dictionary, Database Management System

The indices are accumulated in the index files. The data is accumulated in the data files. Indices give fast access to data items. For example, a book database may be managed in the order of Accession number, yet may be indexed on Book titles and Author name.

Data Dictionary: A Data Dictionary kept information about the structure of the database. It is used a lot. Therefore a good data dictionary should have a good design and efficient execution. It is seen that when a program becomes somewhat big in size, keeping track of all the available names that are used and the purpose for which they were used becomes more and more hard. After a significant time if the similar or another programmer has to change the program, it becomes extremely hard.

The problem becomes even more complex when the number of data types that an organisation has in its database enhancing. The data of an organisation is a valuable corporate resource and thus some kind of inventory and catalog of it must be maintained so as to assist in both the management of the resource and utilisation.

It is for this purpose that a data dictionary or directory / dictionary are emerging as a main tool. A dictionary gives definitions of things. A directory notifies you where to find them. A data directory / dictionary have information (or data) about the data.

A comprehensive data dictionary would give the definition of data items, how they adjust into the data structure and how they tell to other entities in the database. In DBMS, the data dictionary kept the information concerning the conceptual, external and internal levels of the databases. It would join the source of each data field value, that is from where the authenticate value is obtained. The audit trail regarding the updates and frequency of its use including user identification with the time of each update is also recorded in Data dictionary.

Posted Date: 3/6/2013 5:01:47 AM | Location : United States







Related Discussions:- Data files indices and data dictionary, Assignment Help, Ask Question on Data files indices and data dictionary, Get Answer, Expert's Help, Data files indices and data dictionary Discussions

Write discussion on Data files indices and data dictionary
Your posts are moderated
Related Questions
Explain Strict Two-Phase locking A transaction T does not release any type of its exclusive (X) locks until that transaction commits or aborts. In this method no other transact

What is Specialization? Specialization: Specialization permits you to describe new types of information (new structural types or latest domains of information), although reusin

#questiononsider the following relation: CAR_SALE =(CAR_ID,oPTION_TYPE, Option_listpreice, Sale_date, Option_discountedprice)..

Importance Of File Organisation In Database To execute a database efficiently, there are various design tradeoffs needed. One of the most vital ones is the file Organisation. F

Update or Modify operation alters the existing values. If these operations alter the value that is the foreign key also, the only check need is the similar as that of the Insert op

Using your cache simulator and using smalltex.din as your memory trace determine the total miss rate, compulsory miss rate, capacity miss rate, and conflict miss rate for the follo

Which sorting technique is used to sort databases, whose sizes are very big?  Give one such algorithm.  Why do sorting techniques like quicksort, insertion sort, etc.  not applied

What is Thread splitting A thread of control is a path by which a set of state diagrams on that a single object is active at a time. Objects are shared between threads

Define the concept of aggregation.  Give two examples where this concept is useful. Ans: Aggregation transforms a relationship among the objects into a higher-level object. A

Which two files are used during operation of the DBMS? Data dictionary and transaction log are two files used during operation of the DBMS.