Data management is the way an organisation collects, stores, organises, protects and retrieves its data. Two main approaches exist: the traditional file-based approach and the database approach. Understanding their differences explains why almost every modern organisation, from banks to schools, uses databases.
Key terms
- Database
- organised, shared collection of related data
- DBMS
- software that creates, manages and controls access to a database
- Data redundancy
- unnecessary repetition of the same data
- Data inconsistency
- different copies of the same data that do not agree
- Data integrity
- accuracy and consistency of stored data
- Data independence
- ability to change data storage without changing programs
Summary
- File-based systems keep separate files per department.
- They cause redundancy, inconsistency, poor sharing and weak security.
- A database managed by a DBMS stores data once and shares it securely.
- Databases cost more and need backups and skilled staff.
In everyday life: Ethiopian banks moved from paper ledgers in each branch to central core-banking databases, so you can now withdraw money from any branch.
Check yourself
- What is a DBMS? Name two examples.
- Explain data redundancy with an example.
- Give three advantages of the database approach.
- Why is a spreadsheet not a full database?
Practice questions
1. Which problem is typical of the traditional file-based approach to data management?
- A. Data redundancy and inconsistency
- B. Too much data security
- C. Automatic backup
- D. Central control
Show answer
Answer: Data redundancy and inconsistency
When each department keeps its own files, the same data is stored many times and copies drift apart; a DBMS reduces this.
On WeLearn
The full lesson: reading notes, worked examples, class activities and the Unit 3 quiz
Study Data Management Approaches on WeLearnTeach Data Management Approaches with WeLearn
We will bring a demo to your school: a lesson on your interactive TV, a virtual lab and a classroom game, with your own teachers.
