Knowing about the characteristics of a database system (unit Characteristics of the
Database Approach and unit Example Applications) we will have a look at file based systems. With a file based approach each user
defines and creates with a specific software the files he needs for a specific application.
In comparison to the database system approach this results in some limitations.
Move the mouse over the bold terms to the left and the limitations of the file based
approach in comparison to the database approach are explained in writing (right) and
graphics (below).
Using a file based system it is possible that, for example, the
administration of a school maintains information about the registration and fee
payment of the students (e.g. based on a spreadsheet software). Meanwhile the
lecturers manage data about the students and their grades. Even though both user
groups are interested in student data they both might have different files and
different software to update and change these. Such redundancy in the definition and storage of data wastes storage
space. Additionally, the work needed to update data in more than one system is
multiplied by the number of systems. In case above a change of basic student
data like the address might need an update in the system of the lecturer and
in
the system of the administration as well.