蛋塔賣你 (Data Mining)

Data Warehouse stores the huge historical data from diverse data sources, you can analyze the data completely by using the data warehouse. However, if the data size is too big, and/ or the access user is many, you should consider the system loading and the security issue. Now, what you can do is develop the data warehouse for different department for differnt analysis use purpose, the we call it Data Mart.

From the Data Mart, you can create the pre-caculated result and stored as the multi-deminion Data Cube.

So, the Data Warehouse, Data Mart, Data Cube are all functioned to store data but in different space size. The smaller space size the higher anlysis efficiency it is.