Other DW Components Operational data stores(ODS a type of database often used as an interim area for a data warehouse Oper marts -an operational data mart Enterprise data warehouse(EDW) A data warehouse for the enterprise Metadata Data about data. In a data warehouse. metadata describe the contents of a data warehouse and the manner of its acquisition and use Copynight@ 2014 Pearson Education, Inc Slide 2-11
Copyright © 2014 Pearson Education, Inc. Slide 2- 11 Other DW Components ▪ Operational data stores (ODS) A type of database often used as an interim area for a data warehouse ▪ Oper marts - an operational data mart. ▪ Enterprise data warehouse (EDW) A data warehouse for the enterprise. ▪ Metadata Data about data. In a data warehouse, metadata describe the contents of a data warehouse and the manner of its acquisition and use
Application Case 2.1 a Better data plan Well-Established telcos Leverage Data Warehousing and Analytics to Stay on Top in a Competitive Industry Questions for Discussion 1. What are the main challenges for TELCOs? 2. How can data warehousing and data analytics help TELCOS in overcoming their challenges 3. Why do you think TELCos are well suited to take full advantage of data analytics Copynight@ 2014 Pearson Education, Inc Slide 2-12
Copyright © 2014 Pearson Education, Inc. Slide 2- 12 Application Case 2.1 A Better Data Plan: Well-Established TELCOs Leverage Data Warehousing and Analytics to Stay on Top in a Competitive Industry Questions for Discussion 1. What are the main challenges for TELCOs? 2. How can data warehousing and data analytics help TELCOs in overcoming their challenges? 3. Why do you think TELCOs are well suited to take full advantage of data analytics?
A Generic DW Framework No data marts option Data Applications ources /Visualization ccess Routine ERP Business ETL Process Data mart Reporting (Marketing) Select Legacy Metadata Data/text Transform Enterprise (Engineering) PO Data warehouse Integrate OLAP Data mart Dashboard (Finance) Web Load LOLTP/EB Replication Data mart Custom built Exte Copynight@ 2014 Pearson Education, Inc Slide 2-13
Copyright © 2014 Pearson Education, Inc. Slide 2- 13 A Generic DW Framework Data Sources ERP Legacy POS Other OLTP/wEB External data Select Transform Extract Integrate Load ETL Process Enterprise Data warehouse Metadata Replication A P I / Middleware Data/text mining Custom built applications OLAP, Dashboard, Web Routine Business Reporting Applications (Visualization) Data mart (Engineering) Data mart (Marketing) Data mart (Finance) Data mart (...) Access No data marts option
Application Case 2.2 Data Warehousing Helps Multicare Save more lives Questions for Discussion 1. What do you think is the role of data warehousing in healthcare systems? 2. How did Multicare use data warehousing to improve health outcomes? Copynight@ 2014 Pearson Education, Inc Slide 2-14
Copyright © 2014 Pearson Education, Inc. Slide 2- 14 Application Case 2.2 Data Warehousing Helps MultiCare Save More Lives Questions for Discussion 1. What do you think is the role of data warehousing in healthcare systems? 2. How did MultiCare use data warehousing to improve health outcomes?
DW Architecture Three-tier architecture 1. Data acquisition software(back-end 2. The data warehouse that contains the data software 3. Client(front-end)software that allows users to access and analyze data from the warehouse TWO-tier architecture First two tiers in three-tier architecture is combined into one sometimes there is only one tier? Copynight@ 2014 Pearson Education, Inc Slide 2-15
Copyright © 2014 Pearson Education, Inc. Slide 2- 15 DW Architecture ▪ Three-tier architecture 1. Data acquisition software (back-end) 2. The data warehouse that contains the data & software 3. Client (front-end) software that allows users to access and analyze data from the warehouse ▪ Two-tier architecture First two tiers in three-tier architecture is combined into one … sometimes there is only one tier?