In order to overcome the limitations of the file-based approach, the concept of database and the Database Management System (DBMS) was introduced in 1960's.
FILE BASED APROACH
File: A file is a collection of records or documents dealing with an organization, person, area or subject . A file, in the computer world, is a self-contained piece of information available to the operating system or any number of individual programs .
File system: In a computer, a file system is the collection of files, where the files are placed logically for storage and retrieval.
File-based systems: It was the first method to store data in computers. The data was stored and retrieved sequentially from the disk.
Drawbacks of File Based system
1. Data redundancy and inconsistency.
2. Difficult in accessing data.
3. Data isolation.
4. Data integrity.
5. Concurrent access is not possible.
6. Security Problems.
7. Recovery Issues
DATABASE APPROACH
Database: It is a collection of related data that is organized in such a way so that it can be easily accessed, managed and updated.
DBMS (Database Management System)
It is a collection of programs (or software) that enables user to create and maintain a database in an easy and effective manner.
Database System
The database and DBMS software together is called as Database system.
Database System = Database + DBMS
Advantages of DBMS
1. Redundancy is controlled.
2. Unauthorized access is restricted.
3. Providing multiple user interfaces.
4. Enforcing integrity constraints.
5. Providing backup and recovery.
RELATION BETWEEN DATA AND INFORMATION
Data: Any facts and figures that can be recorded is data.
Information: It is knowledge derived from data.
A database stores data in such a way that information can be created.
0 Comments