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

  • Pepsi-Cola, one of the world’s most recognized soft drink brands, has a history marked by struggle, innovation, and resilience. Founded in the late 19th ce...
  • An international team of researchers from Switzerland, the United Kingdom, and Canada has identified the gene responsible for a rare but life-threatening...
  • Adenosine diphosphate (ADP) is a key molecule in cellular energy regulation, consisting of adenosine and two phosphate groups. It is central to the cell's ...