Is a process by which existing data infrastructure is periodically examined and critiqued to ensure that the data integrity is enforced and business processes followed. Database maintenance is also essential to ensure that data is optimized for OLTP or OLAP applications and that necessary backups and disaster recovery plans (DRPs) are being followed.
Database maintenance consists of:
- Creating backup scenarios and DRPs
- Optimizing data for indexing, search and retrieval based on the database type (OLAP vs. OLTP)
- Examining server logging facilities and media to ensure correct operation of the database
Verifying that data in the data store is compliant with data integrity rules, setup by the company at design time
No comments:
Post a Comment