Explore BrainMass
Share

Cost of Database Maintenance

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

What effort is required to maintain the data current and error free in a corporate database (where you work now or have worked in the past)(resources - staff hours, or staff number and type, or dollars spent for data inputting and DBA activities)?

This question in not concerned with the effort to initially build/develop and populate a database, but instead the ongoing/long term effort to keep the data and DBMS current (up to date and accurate).

© BrainMass Inc. brainmass.com October 25, 2018, 2:22 am ad1c9bdddf
https://brainmass.com/computer-science/hardware/cost-of-database-maintenance-296728

Solution Preview

Although it is difficult to provide an actual estimate of maintaining the DBMS or database management system as it depends on a wide range of factors, I will provide some facts about database maintenance.

Total cost of ownership of a DBMS Software, as per a study is broken down into these components:

Software: 15%
Hardware: 17%
Downtime: 28%
Staffing: 21%
Training: 19%

Reference: http://www.pafis.shh.fi/graduates/sohkha02.pdf

In order to maintain data current and error free, an organization not only need to spend on annual maintenance and support costs from the vendor along with licensing fee, it also needs to regularly spend on employee training to make sure that employees handle database currently. Further, it also needs to spend on hardware for supporting the database.

A major portion of the total costs is staffing. Companies need to deploy DBMS administrators, programmers and other software professionals ...

Solution Summary

What effort is required to maintain the data current and error free in a corporate database (where you work now or have worked in the past)(resources - staff hours, or staff number and type, or dollars spent for data inputting and DBA activities)?

$2.19
See Also This Related BrainMass Solution

Database Maintenance Tools

Please discuss what you believe to be a good backup and crisis management strategy considering the following scenario. Provide a detailed explanation of your choices. Be sure to cite your sources.

You work for a small consulting firm with a sterling reputation for high-quality work and outstanding technical aptitude. You've been assigned as the SQL Server 2000 DBA for an e-commerce project based in coastal Florida. Your client is a well-financed, Internet startup firm focusing on creating an online billing system for large hospitals. As a startup firm, they have limited financial resources and must stringently manage their budget.

There are three database environments for your project: development, staging, and production. The development environment is for the web development to create and test their modules and code. The staging environment is where the various components are assembled and tested as a whole. The production environment is the environment that will eventually be your deliverable to the client and will migrate to become the live web presence for the start up.

The client has approached you in the database server room. She's heard there is severe weather coming to the area that may escalate to hurricane status. She would like you to describe in the detail the backup strategies you've developed for each database environment. She'd really like to know how you can save the company money by applying differing backup and crisis management systems to the varying database environments.

View Full Posting Details