1 Reply Latest reply: Dec 5, 2012 11:23 PM by 589360 RSS

    BI Performance with data warehouse or without data warehouse.

    948682
      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
          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.