1 / 11

Building Enterprise & Business Intelligence Systems: The Data Warehouse Lifecycle

This comprehensive guide explores the essential elements of a data warehouse system, focusing on its lifecycle and architecture. It covers the roles of data marts, user access, and ad-hoc query tools, illustrating how data is sourced, cleaned, and transformed for analytical purposes. Key components include dimensional modeling, physical design, and the use of tools like Oracle Data Mart Designer. By understanding the business requirements and the technical infrastructure, organizations can successfully implement and manage data warehouses to drive decision-making and enhance business intelligence.

triage
Télécharger la présentation

Building Enterprise & Business Intelligence Systems: The Data Warehouse Lifecycle

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. ACCTG 6910Building Enterprise & Business Intelligence Systems(e.bis) The Data Warehouse Lifecycle Olivia R. Liu Sheng, Ph.D.Emma Eccles Jones Presidential Chair of Business

  2. Basic Elements of a Data Warehouse System The Data Warehouse Presentation Servers Source System (Legacy) Data Staging Area End User Data Access Data Mart #1: OLAP ( ROLAP and/or MOLAP) query services; dimensional! Subject oriented; locally implemented; user group driven; may store atomic data; may be frequently refreshed; conform to DW Bus Populate, replicate, recover Ad Hoc Query Tools Storage: Flat files (fastest); RDBMS; Other Processing: Clean; Prune; Combine; Remove duplicates; households; standardize; conform dimensions; store awaiting replications; archive; export to data marts No user query services feed Relational extract Report Writers feed Flat files Spreadsheets extract Populate, replicate, recover End User Applications Conformed dimensions and facts feed DW BUS Data Mart #2 Populate, replicate, recover feed Models: forecasting; scoring; allocating; data mining; other downstream Systems; other parameters; special UI DW BUS Conformed dimensions and facts ERP Legacy extract Data Mart #3 Uploaded cleaned dimensions Uploaded model results

  3. TechnicalArchitectureDesign ProductSelection &Installation End-UserApplicationSpecification End-UserApplicationDevelopment The Business Dimensional Lifecycle Business Requirement Definition DimensionalModeling PhysicalDesign Data StagingDesign &Development ProjectPlanning Deployment Maintenance, Monitoring,Evaluation & Growth Project Management

  4. Dimensional Modeling • Logical Design (Design appropriate table structures and relationships) • Tool: Oracle Data Mart Designer

  5. Physical Design • Storage Structure • Performance Tuning • Indexes and aggregation • Tool: Data Mart Designer

  6. Data Staging • Extraction • (Cleansing and ) Transformation • Loading (Transportation) • Tool: Oracle Data Mart Builder

  7. Data Staging Extraction Transformation Transportation

  8. End User Application Specification and Development • On-Line Analytic Processing (OLAP) • Reporting • Ad-hoc query • Graphical Analysis • Tool: Oracle Data Mart Discoverer

  9. OLAP Reporting

  10. OLAP Drill-up&Drill-down Query

  11. OLAP Graphical Analysis

More Related