Relational Data Base Management System
Why do we need I database
- · A Database is a place where you can store information related to a specific topic .
- · Data security and integrity.
- · Concurrent access, recovery
 |
| Integrator Database |
File System
·
File system was an early attempt to
computerize the manual filing system.
·
A file system is a method for storing and
organizing computer files and the data to make it easy to find and access.
·
File Systems may use a storage device such as
a hard disk or CD-ROM.
Characteristics of File
Processing System
·
It is group of files storing data of an
organization.
·
Each file is independent from one another.
·
Each file is called flat file.
·
Each file contained and processed information
for one specific function like accounting or inventory.
·
Files are designed by using application
programs written in programming languages such as COBOL, C, C++, etc….
Traditional Approach
·
Data Security
·
Data Redundancy
·
Data Isolation
·
Program/ Data Dependence
·
Concurrent Access Anomalies
Data Security
The data as maintained in flat files is easily accessible and therefore
not secure. Example: the Customer Transaction file has details about the total
available balance of all customers.
Data Redundancy
·
Often the same information is duplicated in
two or more files.
·
It may lead to inconsistency Assume the same
data is repeated in two or more files.
Data Isolation
·
Data isolation means that all the related
data is not available in one file.
·
Generally, the data scattered in various
files, and the files may be in different formats, therefore writing new
application programs to retrieve the appropriate data is difficult.
Advantages Of DBMS
- · Controlling redundancy
- · Enforces integrity constraints
- · Better security
- · Better flexibility
- · Effective data sharing
- · Enables backup and recovery
Comments
Post a Comment