Wednesday, January 27, 2021

Database maintenance: An ongoing process

Database operation and maintenance is an ongoing process and need to be updated continually to reflect new business transaction and other events.  It involves the following steps:
*Monitoring database performance
*Tuning and reorganizing the database whenever necessary
*Enforcing standards
*Supporting users

Database maintenance including add, delete, update, and correct the data in a database, including hyperlinked data on Web pages. Database maintenance sometimes involves changing a database design, e.g., adding new elements to existing records or adding new datasets to database, as the goals and requirements associated with applications change over time.

The database maintenance process is accomplished by transaction processing and other end user applications, with the support of the DBMS.

End users and information specialist can also employ various utilities provided by a DBMS for database maintenance.
Database maintenance: An ongoing process