Database sometimes called as data bank is the storage of the data where every kind of data is kept. Data procurement, searching out, preservation and proper usage of the data is a quite tough job if data is stored in files. It is now impossible to find any organisation without a database. Although there is some problem with having data bank the modern need makes it compulsory to have a data bank. Even some institution has more than one database.
Advantages of database
- Controlled data redundancy:throughout database plan, a variety of files is incorporated and each rational data article is stored at the central position. This helps eliminate duplicating the information item in diverse files, and makes certain constancy and saves the storage space. It is notable that the redundancy in the data bank system is ineradicable there may be some presentation and methodological reasons for having a number of redundancies. Though, the DBMS ought to be competent of controlling these unnecessary items in order to shun data inconsistencies.
- Enforcing data reliability:In database method, enforcing information integrity is much easier. A range of integrity impediments is recognised by the database designer during database plan. Some of these data veracity constraints can be imposed mechanically by the DBMS, and others may need to be checked by the use of programs.
- Sharing data:The data kept in the database can be shared among numerous users or application programs. Furthermore, new applications can be built to use the similar stored data. Because of shared data, it is doable to convince the data requirements of the fresh applications exclusive of having to craft any extra data or with minimum alteration.
- The application development becomes easier:The application builders need to build up the application programs consistent with the users’ wants. The other issues like simultaneous access, safety, data uprightness, etc., are managed by the DBMS itself which makes the applications development an easier job.
- Security of data:Because the data is stored in a single store, enforcing safety impediments is a much easy task to implement. The DBMS assures that the only ways of an entrance to the database are via an endorsed channel. Therefore, data security confirms the entrance. It can be done when the access is tried to thin-skinned data. To make sure safety, a DBMS grants safety measures such as user codes. Different checking points can be set for each sort of entrance to the data bank of every part of data stored.
- Different user interface:With the intention of meeting the requirements of different users with different nominal understanding, DBMS offers different sorts of interfaces such as question mark languages, application program interfaces. A form-style interface shows a shape to each user and users cooperate using these forms
- Backup and recuperation:The DBMS gives the support of backup and recovery subsystem that is accountable for revitalization from hardware and software downfalls. For instance, if the breakdown occurs in amid the transaction, the DBMS revival subsystem either relapses back the data store to the state which was prior to the initiation of the transaction or starts again the transaction from the end. It was broken up so that its total outcome can be traced in the database.
- Independence of program data: It is a significant characteristic of DBMS as it permits altering the construction of the database without doing any alterations in the application programs that are being used the database. To grant a high degree of data self-determination, the explanation of the database construction. Plus various constraints on the data are kept discretely in DBMS catalogue. The data enclosed in the catalogue is known as the metadata. This independence is offered by a three-level DBMS structural design.
- Abstraction of data:The characteristics of DBMS that permit program-data freedom is called as data generalisation. Data abstraction permits the database arrangement to provide a conceptual vision of the data to its users with no giving the material storage and execution details.
- Supports manifold visions of the data:A database can be visited by many users and all of them may have a different viewpoint or vision of the data. A database system offers a flair to characterise different outlooks of the data for different users. A vision is a subset of the database that has a virtual data resulting from the database records, but it does not subsist in material form. That is, no material file is generated for storing the data values of the outlook; rather, merely the definition of the outlook is kept in the databases.