1 / 7

Designing the data warehouse / data marts

Designing the data warehouse / data marts. Part 2. Creating the Physical Model. Phase 4: Creating the Physical Model . Translate the dimensional design to a physical model for implementation Define storage strategy for tables and indexes Perform database sizing

arty
Download Presentation

Designing the data warehouse / data marts

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Designing the data warehouse/ data marts Part 2

  2. Creating the Physical Model Phase 4: Creating the Physical Model Translate the dimensional design to a physical model for implementation Define storage strategy for tables and indexes Perform database sizing Define initial indexing strategy Define partitioning strategy

  3. Physical Model Design Tasks • Define naming and database standards • Perform database sizing • Design tablespaces • Develop initial indexing strategy • Develop data partition strategy • Define storage parameters

  4. Datastagingarea Operationalsystem Warehouse Data Staging Area • The construction site for the warehouse • Required by most implementations • Composed of ODS, flat files, or relational server tables • Frequently configured as multitier staging Extract Transport(Load) Transform

  5. Datastagingarea Operationalsystem Warehouse Datastagingarea Operationalsystem Warehouse Remote Staging Model Data staging area within the warehouse environment Warehouse environment Oper. envt. Extract,transform,transport Transport(Load) Transform Data staging area in its own environment, avoiding negative impact on the warehouse environment Warehouse envt. Staging envt. Oper. envt. Transport(Load) Extract,transform,transport Transform

  6. Datastagingarea Operationalsystem Onsite Staging Model Data staging area within the operational environment, possibly affecting the operational system WH envt. Operational environment Warehouse Extract Transport(Load) Transform

  7. Browser: http:// Customers: + Hollywood X a recorof Browser: Browser: http:// http:// Customers: + as X + Hollywood Hollywood X Extracting Data Data mapping • Routines developed to select fields from source • Various data formats • Rules, audit trails, error correction facilities Transform Operational databases Warehouse database Data stagingarea

More Related