Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Data Warehouse performance test

Data Warehouse performance test

Data Warehouse performance test


First of all, sorry for my poor English.
I'm doing an internship as part of my Bussiness Information Systems study. My Job is to exermine the possibilities of using open source Data Warehouse Systems for Data Warehousing as a Service solutions. The main focus is on the performance aspects.
Is there any best practice for Data Warehouse performance testing (benchmarking)? And are there any tools for Data Warehouse performance testing?

Thanks in advance!

RE: Data Warehouse performance test

First of all, a Data Warehouse should be specific to the enterprise, so I don't know what you mean by "open source Data Warehouse Systems."  Every data warehouse should be proprietary.  Maybe you mean using an Open Source database or query tool.  But those are just components of the data warehouse, and not the data warehouse itself.

And when a data warehouse is modeled, it is modeled specifically to the enterprise, so there is no substitute for testing performance than trying out different analysis the enterprise would like to use.

RE: Data Warehouse performance test

As RiverGuy noted, performance tuning of systems (all systems, not just DW) are dependent on the applications being run.  Indexing, redundant columns, denormalization, and other performance techniques should be based on the frequency and volume of user access.

The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close