Advantages Of Database

Database is the collection of interrelated data, means it is composed of a collection of file that are linked In such a way that information from one of the files may be combined with information from other files so that a user may receive exact information needed.
Now the various advantages of the database:
1. Minimal Redundancy: in a file system, each application has its own private files. This can often lead to considerable redundancy in stored data, with resultant waste in storage space. For example: A personnel application and an education records application may each own file containing department information for employees. These are two files can be integrated, and the redundancy can be removed.
2. Inconsistency Can Be Avoided: In case, the system is not aware of the duplication , there will be a occasion which the two entries will not agree. At such times , the database is said to be inconsistent. A data base that is an inconsistent state is capable of of supplying incorrect or conflicting information. So the data in the database must be accurate.
3. Sharing Of The Data: It means not only that existing application can share the data in the database, but also that the new application can be developed to operate against that same stored data. In other words, the data requirements of new application may be satisfied without having to create any new stored files.
4.Standard Can Be Enforced: With the central control of the database, the DBA can ensure that all applicable standards are followed in the representation of data such as format of data items, conventions of data names, documentation standard etc. which will result in uniformity of the entire database as well as its usage.
5. Search Capability: The user of database may ask a wide variety of the questions about the data. If a quick answer is needed at a terminal, the search will have to be fast and the capability to search a database quickly with different search criteria is highly dependent on the physical data organization.
6. Integrity: By integrity, we mean unification of the several file into one file. When a database contains data employed by a number of different users, it is important that the data items and associations between the data items may not be destroyed.
7. Privacy and Security: The data in the database is completely secure. Data security refers to the protection of data against accidents or intentional disclosure to unauthorized persons. Privacy refers to the right of individual and organizations to determine for themselves, when, how and what extent information about them is to be transmitted to other.

Click here to learn more Pc Tips and Tricks so that you can amaze your friends with your knowlege and also learn some of the great Nokia mmc Tricks