6.4. DATA STORAGE SPECIFICATIONS
If your company is adopting the top-down approach of developing the data warehouse, then you have to define the storage specifications for
The data staging area
The overall corporate data warehouse
Each of the dependent data marts, beginning with the first
Any multidimensional databases for OLAP
Alternatively, if your company opts for the bottom-up approach, you need specifications for
The data staging area
Each of the conformed data marts, beginning with the first
Any multidimensional databases for OLAP
Typically, the overall corporate data warehouse will be based on the relational model supported by a relational database management system (RDBMS). The data marts are usually structured on the dimensional model implemented using an RDBMS. Many vendors offer proprietary multidimensional database systems (MDDBs). Specification for your MDDB will be based on your choice of vendor. The extent and sophistication of the staging area depends on the complexity and breadth of data transformation, cleansing, and conversion. The staging area may just be a bunch of flat files or, at the other extreme, a fully developed relational database.
Whatever your choice of the database management system may be, that system will have to interact with back-end and front-end tools. The back-end tools are the products for data transformation, data cleansing, and data loading. The front-end tools relate to information delivery to the users. If you are trying to find the best ...
Get DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.