Datamart vs OLAP cubes?
Date: Mon, 29 Mar 2010 06:12:40 -0700 (PDT)
In some of the other posts that I have posted, I have mentioned the business usecase that I'm dealing with.
Anyway, here is a brief overview of what we are working on:
Our Dataware house contains the data retrieved from many data sources, and all the data are somehow related to the information specific to our Customers.
We have a marketing application running, and this requires summary information on each of the Customer, like whether he is a ''Heavy Buyer; Frequent buyer; Chocolate lover; Smoker'. To calculate the above characteristics, we have to keep evaluating the specific attributes in the Datawarehouse. Also, due to the high performance requirements from the Marketing application, we have planned to have a dedicated server to store the pre-calculated characteristics information for all the subscribers. This server should get periodically updated based on the latest evaluation based on the data stored in the Data warehouse.
What do you suggest, for this dedicated server?
- Maintaining a 'Data mart' of all the characteristics, for all the Subscribers
- Maintaining OLAP cubes, to represent all the characteristics, for all the Subscribers
Which one do you suggest among the above-mentioned approaches? Do you have any other alternative suggestions? Why?
I humbly agree that I'm not a database architect. But, I promise to go into the details, once I get a clear picture on what way I should go ahead with. Received on Mon Mar 29 2010 - 08:12:40 CDT