Before the Advent of Database Systems
Data was stored in file-based systems before the advent of database systems which were developed/created because of the disadvantages of the file-based system. This included integrity problems, isolation of data, and security issues. How might a small agricultural business use a database system to gain a competitive advantage in the marketplace? Think about in what areas and how a database system would be used. For example, how could a homeowner implement a database to finesse their home management?
Key Terms
concurrency: the ability of the database to allow multiple users access to the same record without adversely affecting transaction processing
data element: a single fact or piece of information
data inconsistency: a situation where various copies of the same data are conflicting
data isolation: a property that determines when and how changes made by one operation become visible to other concurrent users and systems
data integrity: refers to the maintenance and assurance that the data in a database are correct and consistent
data redundancy: a situation that occurs in a database when a field needs to be updated in more than one table
database approach: allows the management of large amounts of organizational information
database management software: a powerful software tool that allows you to store, manipulate and retrieve data in a variety of ways
file-based system: an application program designed to manipulate data files