Advantages Of DBMS Over To File System - TCCI

To understand advantages of DBMS first of all we have to find out problems in traditional file system.

Problems in traditional File System:

What is file system?

Before DBMS was invented, data were stored using File Processing System. In this System, data is stored in permanent system files (secondary Storage). Different application programs are written to extract data from these files and to add record to these files. But, there are lot of problems in using File Processing System, to store the data.

The file system method of organizing and managing data was a definite improvement over the manual system. However, there exist different problems in the Traditional File System Data Processing.

Lack of Storage and Access Standards

Development Times more.

Limited to store a small database.

Time-consuming in analysis of data.

Traditional File Processing system need more queries and extensive programming to get result of any analysis.

Administration is also Complex In old traditional file system administration becomes also difficult

Limited functionality

File systems usually do not support access for multiple users.

Lack of security and Limited Data Sharing

Data redundancy

Poor data security

So, to overcome these problems,

The Database Management System was introduced.

“A Database Management System (DBMS) is a combination of computer software, hardware, and information designed to electronically manipulate data via computer processing”.

The DBMS serves as interface between the user and the database. The database structure itself is stored as a collection of files, So, we can access the data in those files through the DBMS. The DBMS receives all application requests and translates them into the complex operations required to fulfill those requests. The DBMS hides much of the database’s internal complexity from the application programs and users.

The Different Advantages of DBMS

Improved data sharing

In DBMS, data can be shared by authorized users of the organization. The DBA manages the data and gives rights to users to access the data.Improved data security

Only the authorized persons are allowed to access the database. The DBA or head of department can access all the data in the database. Some users may be permitted only to retrieve data, whereas others are allowed to retrieve as well as to update data. The database access is controlled by the DBA.

Better data integration

Integrity constraints or consistency rules can be applied to database so that the correct data can be entered into database.

Minimized data inconsistency

By controlling the data redundancy, the data consistency is obtained. If a data item appears only once, any update to its value has to be performed only once and the updated value (new value of item) is immediately available to all users.Improved data access

Improved decision making

Following constraints are provided:

Constraint Name	Description
PRIMARY KEY	Designates a column or combination of columns as Primary Key and therefore, values of columns cannot be repeated or left blank.
FOREIGN KEY	Relates one table with another table.
UNIQUE	Specifies that values of a column or combination of columns cannot be repeated.
NOT NULL	Specifies that a column cannot contain empty values.
CHECK	Specifies a condition which each row of a table must satisfy.

Backup and Recovery Procedures

To learn more Database management system at TCCI, TCCI

Visit @ tccicomputercoaching.com

Call us @ 98256 18292.