×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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!

*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

How do I design the db when anticipating OLAP use?

How do I design the db when anticipating OLAP use?

How do I design the db when anticipating OLAP use?

(OP)
I am familiar with Data Wahrehousing/Marts and OLAP and a few tools used to work with it - I want to make sure I understand what needs to be done when designing the original database.

I really can't see anything that needs to be done differently. The Data Warehouse or Mart will incorporate all of the needed fields and formulas that will allow for successful OLAP use as far as I can see.

I may be missing the forest for the trees - but what would the dba do differently with the design of the database when anticipating OLAP use?

Thanks!

Cody ford
codyford@yahoo.com

VB, VBS, Seagate Info/Crystal Reports

RE: How do I design the db when anticipating OLAP use?

Cody, you are right that the OLAP tools will be running on top of a data mart. You might find that some OLAP tools like using pure star schemas and your warehouse/mart may have a more complex design. There may also be considerations with how to store hierarchy information.



my home

RE: How do I design the db when anticipating OLAP use?

(OP)
Thank you very much for the reply. Just wanted to know that I was on track.

Your web site is excellent. I have never visited a site that gave me such a mixture of powerful information for my career and entertained me as well. I encourage everyone to visit.

Kudos my U.K. friend! Well done!

Cody

Cody ford
codyford@yahoo.com

VB, VBS, Seagate Info/Crystal Reports

RE: How do I design the db when anticipating OLAP use?

Cody, I tried to email you but it bounced.



my home

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