Purchase Solution

Cost of Database Maintenance

Not what you're looking for?

Ask Custom Question

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).

Purchase this Solution
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)?

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 provided by:
Sandeep Bardia, MBA
Education
  • BCom, SGTB Khalsa College, University of Delhi
  • MBA, Rochester Institute of Technology
Recent Feedback
  • "Thank you. "
  • "Thank you"
  • "Thank you. I got 20/20 last week for my discussion you help me out with."
  • "Thank you. Great Job. "
  • "Thank you. Great Job. "
Purchase this Solution
Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

Basic Networking Questions

This quiz consists of some basic networking questions.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Javscript Basics

Quiz on basics of javascript programming language.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

View More Free Quizzes
Related BrainMass Solutions

  • Keys and Relationships for Driver Log

    The descriptions provided are based on interviews with maintenance personnel who use the Fleet Truck Maintenance database. The creator of the database was not available.

  • Database Benefits and Drawbacks

    Less system Maintenance Cost: The system of DBMS is a combination of hardware and software and provides information at a single place. Hence, its centralized nature reduces the system maintenance cost of users.

  • What is Open Source Database and Why Use It?

    The most important things is low acquisition & licensing cost when compared to commercial softwares. 2. Lower support and maintenance costs. 3. Strong community support and help from lot of developers 4.

  • Data Reporting

    You will need to gain information about all overhead cost, Expenditure, Maintenance, Risk factors, Environmental effects (e.g., international financial markets) and the project return after a number of years.

  • Database Administration and Corporate Hierarchy

    A database administrator on the other hand handles more of the implementation and operation of the database, such as physical database design, database maintenance, data monitoring and verification, and fixing and providing solutions to problems encountered

  • E-Commerce costs, proposals and breakdowns - The Sharper Image

    As such, the cost of maintaining a digital library is much lower than that of a traditional library. A traditional library must spend large sums of money paying for staff, book maintenance, rent, and additional books.

  • Predicting Data Volumes and Number of Users

    of users as well as the data volumes allows the project of design, implementation, maintenance, and repair of the database easier on the entire IT team.

  • Data Fields and Tables: The Apartment Management Database System

    • Keep track of renters (Note: Renters have their address and phone numbers on file). • Keep track of the apartments and buildings. • Keep track of maintenance orders. Several maintenance workers can work on the same job.

  • Front-End Application to SQL Server

    High maintenance cost. b. Will not be easily upgrade-able. c. For a simple change in backend database the front end has to be updated; which will not be easy specially binary .exe front end application. d.

View More Related Solutions