Post reply

Cubes from transacting database

  • February 6, 2008 at 3:36 am

    #181642

    Hi

    If I currently have a transactional database that is being used via a web based system. Would it be wise to have olap and data mining tools running from the same database or would it be better to have a separate “data warehouse” just for the cubes. Please advise with reasons.

    All efforts greatly appreciated

    Thanks

  • February 6, 2008 at 6:18 am

    #775548

    I would tend to separate them for a couple of reasons.

    First, your OLTP system is probably inserting and updating records pretty regularly. If you have a high transaction rate on your database, constantly trying to query it will likely cause performance problems.

    To add to that, your OLTP system is likely built very differently from a normal data mart. You may be able to use the UDM to make it look like a star or snowflake schema, but this can be problematic.

  • February 6, 2008 at 6:35 am

    #775554

    Thanks

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply