A computer system comprises hardware and software components, aiming to offer a powerful computational tool. These systems play a crucial role across diverse domains, aiding us in numerous tasks. The prevalence of the internet has significantly bolstered the utilization of computers for information sharing and communication. Computer systems empower us to store, process, display, and transmit information. Even in a basic modern computer system, multiple programs are typically required to carry out various functions effectively.

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



The Most Popular Posts

  • The history of breakfast cereal in America is a tale of innovation, health consciousness, and marketing prowess that has left an indelible mark on the nati...
  • Food ingredients constitute the fundamental building blocks of culinary creations, forming the essence of every recipe. In essence, an ingredient is any co...