This is a continuation of the discussion question from Unit 4 (we all know that

Question

This is a continuation of the discussion question from Unit 4 (we all know that databases supply the fuel for the productivity engine in the information age, but at what cost). Now that you have considered the building cost, and the DBA activities needed to maintain an actual database, consider the additional effort needed to input data into the database by users to keep the contents of the database current and error free (these are users tasked with inputting data, not regular users who only want to get and use the data) in your corporate (where you work now or have worked in the past) and personal databases (resources – dollars or people hours and other input? Getting this quantitative information may be difficult, but I want you to provide at least an estimate if historical records are not available)? This discussion question is the other part of database maintenance picture which is often overlooked when estimating the resources actually used to maintain a database (the remaining part of the discussion that we have been considering the last couple of units). Provide this information for either one example of a personal database, or one example of a corporate database that you are familiar with.

Explanation / Answer

Database Maintenance involves a set of tasks that are all run with the intention to improve your database. There are routines meant to help performance, free up disk space usage, check for data errors or hardware faults, update internal statistics, and many other things. This may include: Defragmentation , Maintenances of log files, File compaction or Integrity check.
Admin tasks many include:
Elimination of index fragmentation.
Developing a backup and restore strategy as per dyanmic workload.
Always ensure statistics are up-to-date.
Confirming that the database is structurally sound
Managing the size of actual data and log files. Elimination of old logs as and when needed to free up the space.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.