The database approach represents a fundamental shift from traditional file-based data management systems to a more organized, efficient, and reliable method of handling data. In earlier systems, data was stored in separate files, leading to redundancy, inconsistency, and difficulty in data access. The database approach overcomes these limitations by providing a centralized and structured system for data storage and retrieval.
A Database Management System (DBMS) enables users to create, manage, and manipulate databases while ensuring data integrity, security, and consistency.
Before understanding the characteristics, it is important to distinguish between the traditional file system and the database approach.
| Feature | File System | Database Approach |
|---|---|---|
| Data Storage | Separate files | Centralized database |
| Redundancy | High | Controlled |
| Data Sharing | Limited | High |
| Security | Weak | Strong |
| Consistency | Difficult | Maintained |
The database approach addresses the shortcomings of file-based systems through several defining characteristics.
A database system is self-describing because it contains not only the data but also metadata (data about data).
Metadata is stored in the system catalog (data dictionary)
It defines:
Example: A table definition (like columns and data types in SQL) is stored in the system catalog, allowing the DBMS to understand how to process the data.
In traditional systems, programs are tightly coupled with data structures. In contrast, the database approach provides program-data independence.
Example: Adding a new column to a table does not require rewriting existing applications.
A DBMS allows different users to view the database in different ways according to their needs.
Example:
A database system allows multiple users to access and manipulate data simultaneously.
Example: Multiple users can book railway tickets at the same time without data conflicts.
The database approach reduces unnecessary duplication of data.
Example: Customer information stored once instead of repeated across multiple files.
DBMS enforces rules to maintain accuracy and consistency of data.
Example: A student ID must be unique and cannot be NULL.
A DBMS provides mechanisms to protect data from unauthorized access.
Example: Only authorized users can modify financial records.
DBMS ensures data safety in case of failures.
Example: If a system crashes during a transaction, the DBMS restores the database to a consistent state.
DBMS hides complex details of data storage and provides a simplified view to users.
Since data redundancy is minimized and constraints are enforced:
Consider a banking system:
This demonstrates the practical application of the database approach.
The database approach is a modern method of data management that ensures efficient storage, retrieval, and manipulation of data. Its key characteristics—such as self-describing nature, data independence, multiple views, and controlled redundancy—make it superior to traditional file systems.
These features collectively enable organizations to manage large volumes of data reliably, securely, and efficiently.