Sunday 29 July 2012

What is DBMS? Explain its features

In a typical file processing system, permanent records are stored in various files. A
number of different application programs are written to extract records from and add records
to the appropriate files. But this method has a number of disadvantages, such as Data
Redundancy, Difficulty in access, Data Isolation, Concurrent Access, Security Problems, and
Integrity Problems.
A Database Management System (DBMS) consists of a collection of interrelated data
and a set of programs to access this data. This collection of Data is called Database. The
Primary goal of a DBMS is to provide a convenient environment to retrieve and store
database information.


Features of DBMS:-

1. The integration and sharing of data files minimizes the duplication and redundancy of
data to a great extent.
2. Integration of data files also results in a considerable saving of storage space and in
data entry and data storage costs.
3. Fewer application programs need to be developed for obtaining various reports due to
independence of programs and data.
4. The query language facility helps non-programming persons to access the database
for information as needed without the help of any programmer.
5. Faster preparation of information to support non-recurring tasks and changing
conditions is possible.
6. Updation of data becomes easier due to integration of data file. Fewer errors may
when several records may be updated simultaneously.
7. Large database maintenance.

6 comments: