Data Warehouse--Data modeling (not finished) __dw

Ho, August

See a colleague on the desktop there is a Data Warehouse Toolbox Third edition, this blog simply discusses the Data Warehouse modeling general process and modeling methods (mainly practical experience and network data integration)

First describe the application of the current project on the model:

The current business does not have a treasure of an East Nanjing and other Internet companies so complex, but somehow there is a point of reference.

Now do is a decision support system, mainly for product sales data on the dimension of the data display, for such a large company in an important dimension than the region.

When it comes to the concept of data warehousing, it is generally not included in the ODS system, but DW obviously relies on the former and cannot be fragmented, and if so understood the ODS should have its own data model, and the model might be more 3NF compliant, which is similar to the detail data in DW. Our current project does not have a specialized data model for this part, and only multidimensional models are used to make Cognos.

1. General process

2. Modeling method