Databases

Databases

1. Fast to access data

2. Fast to update data

3. Fast to search for data

4. Convenient to present data in a useful way

5. Databases are persistent as the data lasts as long as it's required

6. A structured store of data, organised so that it can easily be accessed, managed and updated

7. Data is stored in a logical way to facilitate processing

8. Provide security

   • Prevents accidental or deliberate loss
   • Prevents malicious access

9. Provide automatic backup

10. They enforce data integrity rules

    • State of data being
      • As intended
      • Accurate
    • Integrity is enhanced by
      • Designing the database sensibly in the first place
      • Using validation rules to ensure the accuracy of data input

11. Control data redundancy

12. Provides users with controlled access to data they need