CIS 2200 Lecture Notes - Lecture 3: Data Warehouse, Business Process, Html
Document Summary
History of data warehousing: 1990s organizations began to need more timely information about their business. Realized operational systems were too cumbersome to provide relevant data data efficiently and quickly. Information from other operational applications is not included. Operational systems are not integrated, or not available in one place. Operational information is mainly current, does not include the history that is required to make good decisions. Operational information frequently has quality issues (errors), the information needs to be cleansed. Without information history, it is difficult to tell how and why things change over time. Operational systems are not designed for analysis and decisions support. Data warehouse was created, a place where relevant information could be held for completing strategic reports for management. Data warehouse: a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.