Lecture Business management information system - Lecture 23: Data warehouse. The contents of this chapter include all of the following: Database is application oriented, data warehouse is subject oriented, data warehouse helps in strategically planning and decision support systems. | Data Warehouse Lecture 23 Today’s Lecture Introduction to Data Warehousing Need of DWH Purpose Uses Architecture Introduction What is Data Warehouse? A data warehouse is a collection of integrated databases designed to support a DSS. According to Inmon’s (father of data warehousing) definition(Inmon,1992a,): It is a collection of integrated, subject-oriented databases designed to support the DSS function, where each unit of data is non-volatile and relevant to some moment in time. Introduction-Cont’d. Where is it used? It is used for evaluating future strategy. It needs a successful technician: Flexible. Team player. Good balance of business and technical understanding. Introduction-Cont’d. The ultimate use of data warehouse is Mass Customization. For example, it increased Capital One’s customers from 1 million to approximately 9 millions in 8 years. Just like a muscle: DW increases in strength with active use. With each new test and product, valuable information is added to . | Data Warehouse Lecture 23 Today’s Lecture Introduction to Data Warehousing Need of DWH Purpose Uses Architecture Introduction What is Data Warehouse? A data warehouse is a collection of integrated databases designed to support a DSS. According to Inmon’s (father of data warehousing) definition(Inmon,1992a,): It is a collection of integrated, subject-oriented databases designed to support the DSS function, where each unit of data is non-volatile and relevant to some moment in time. Introduction-Cont’d. Where is it used? It is used for evaluating future strategy. It needs a successful technician: Flexible. Team player. Good balance of business and technical understanding. Introduction-Cont’d. The ultimate use of data warehouse is Mass Customization. For example, it increased Capital One’s customers from 1 million to approximately 9 millions in 8 years. Just like a muscle: DW increases in strength with active use. With each new test and product, valuable information is added to the DW, allowing the analyst to learn from the success and failure of the past. The key to survival: Is the ability to analyze, plan, and react to changing business conditions in a much more rapid fashion. Data Warehouse In order for data to be effective, DW must be: Consistent. Well integrated. Well defined. Time stamped. DW environment: The data store, data mart & the metadata. The Data Store An operational data store (ODS) stores data for a specific application. It feeds the data warehouse a stream of desired raw data. Is the most common component of DW environment. Data store is generally subject oriented, volatile, current commonly focused on customers, products, orders, policies, claims, etc Data Store & Data Warehouse Data store & Data warehouse, table 10-1 page 296 The data store-Cont’d. Its day-to-day function is to store the data for a single specific set of operational application. Its function is to feed the data warehouse data for the purpose of analysis. The Data Mart It .
