This discussion is archived
1 Reply Latest reply: Dec 5, 2012 9:23 PM by 589360 RSS

BI Performance with data warehouse or without data warehouse.

948682 Newbie
Currently Being Moderated
Hi Gurus,

Does anyone here have a document or presentation for comparing a BI performance that is implemented with data warehouse or without data warehouse ?

Really appreciate your help :)
  • 1. Re: BI Performance with data warehouse or without data warehouse.
    589360 Newbie
    Currently Being Moderated
    You have to do performance tests to get to a conclusion.

    Also the query can have different views;

    1. Comparing performance on getting data directly from source systems against getting data accumulated into a single database.
    2. Comparing performance on getting data from a normalized model against getting data from a dimensional model.

    Most of the cases; getting data from data warehouses should give better performance since;
    Data warehouses allocate more resource towards BI systems.
    Source systems serve many more other purposes than BI systems; so resources are shared.
    In a data warehouse data sets are already at the same place lowering network latency.
    Data warehouse stores summarized information.
    Data warehouses are implemented with dimensional models that serves better for BI type queries.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points