Continue in 2 seconds

Are there any articles, books, or papers on maintenance issues for data warehousing systems?

Published
  • June 04 2003, 1:00am EDT

Q:

Are there any articles, books, or papers on maintenance issues for data warehousing systems? I'm looking for the following:

  • A focus on theory
  • Looking to the future
  • Limitations of commercial RDBMS products
  • Best practices

A:

Clay Rehm's Answer: I would have to say there are more articles and books written on the development of a data warehouse as compared to maintaining one. I believe the maintenance of a data warehouse is where the work begins!

To begin, a software development methodology (SDM)/software development life cycle (SDLC) is required. However it must be tweaked to be more specific to maintenance, enhancements and support, and it will become your software maintenance methodology (SMM). Try to locate the SDM/SDLC that your organization already has and start making your changes there.

As far as a theory, the mission and vision of your data warehouse maintenance team is to support your clients, keep them happy and keep them coming back for more! As stated before, you will have a methodology in place so you will be more efficient and organized when dealing with change requests, which you will deal with quite often.

You need a member or members of your support team to stay ahead of your customer requests by being proactive, attending client meetings and trying to understand where the business is going.

Your DBA support team must be constantly looking how to store and partition, data, reindex data and improving existing SQL so it is more efficient.

Looking to the future requires a team lead who can communicate with the business partners and understand business cycles to see what is coming down the road that will impact the data warehouse.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access