Data files indices and data dictionary, Database Management System

Assignment Help:

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.


Related Discussions:- Data files indices and data dictionary

What is relational algebra, What is Relational Algebra? Relational algebr...

What is Relational Algebra? Relational algebra is a Procedural query Language?

Design of distributed databases, Design Of Distributed Databases: The dist...

Design Of Distributed Databases: The distributed databases are mainly relational at local level. So a local database schema is the similar as that of a centralised database design

Data fragmentation in distributed database system, brief history,definition...

brief history,definition,current trends and future trends if any of data fragmentation

Cartisian product, Explain the cartesian product in Database Management Sys...

Explain the cartesian product in Database Management System

Determine the two special events, What are two special events? The two ...

What are two special events? The two special events are as "entry" and "exit". Any action which is marked as linked to entry event is executed whenever given state is entered v

What are the uses of the information in the data dictionary, What are the u...

What are the uses of the information in the Data dictionary? The following information is directly taken from the Data dictionary: Information on fields displayed with

Define an operator that a relational algebra does not have, Define an opera...

Define an operator that a Relational Algebra does not have Ans: Relational Algebra does not have Aggregation operators.

.DBMS, please describe the data base management with the easy example &giv...

please describe the data base management with the easy example &give the application?

Explain about database system structure, Explain about database system stru...

Explain about database system structure? Storage manager Authorization and integrity manager Transaction manager File manager Buffer manager Storage manager

Management information system, management information system based on funct...

management information system based on functional organisation

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd