File Processing System vs DBMS
In this lesson: Disadvantages of file processing system and how DBMS solves them — comparison table with examples for exams. In Hindi & English.
Two ways to store data
Before databases, programs stored data in plain files — the file processing system. It works for tiny cases but causes serious problems as data grows. A DBMS was created to solve exactly those problems. Comparing the two shows why a DBMS is worth it.
The file processing system
In a file processing system, each program keeps its own files in its own format. The sales program has a sales file, the accounts program has its own customer file, and so on. There is no central structure, and programs cannot easily share data.
Problems with files
- Data redundancy — the same customer is stored in many files.
- Inconsistency — update one copy and the others disagree.
- Hard to share — each program's format is different.
- Weak security — no fine-grained access control.
- No easy queries — you must write code to search.
- Poor multi-user support — files clash when many use them.
How a DBMS solves them
- One central store — data lives once, linked by keys (no redundancy).
- Consistency — one update reflects everywhere.
- Easy sharing — all programs use the same database.
- Security — access control per user.
- SQL queries — fetch anything with a simple command.
- Multi-user — concurrency control keeps changes safe.
Side-by-side comparison
| Point | File system | DBMS |
|---|---|---|
| Data redundancy | High | Low |
| Consistency | Poor | Strong |
| Data sharing | Hard | Easy |
| Security | Weak | Strong |
| Querying | Write code | SQL |
| Multi-user | Poor | Supported |
When files are still fine
File storage is not always wrong. For a very small, single-user, simple task — a config file, a log, a one-off script — plain files are quick and need no database software. The DBMS pays off when data is shared, related, large, or important.
Common mistakes
- Using files for shared business data. That causes redundancy and inconsistency.
- Thinking files are always simpler. They get complex fast as data grows.
- Ignoring security in files. They lack per-user access control.
- Assuming a DBMS is overkill everywhere. For tiny local tasks, files can be fine.
Summary
- A file processing system stores data in separate program files.
- It suffers from redundancy, inconsistency, poor sharing and weak security.
- A DBMS stores data centrally, linked by keys, solving these issues.
- A DBMS adds SQL queries, security and multi-user support.
- Files still suit tiny, simple, single-user cases.
Next, see the DBMS features in characteristics of DBMS, or the trade-offs in DBMS advantages and limitations.
