Chapter 1: Data Warehousing presents about Basic Concepts of data warehousing; Data warehouse architectures, Some characteristics of data warehouse data, The reconciled data layer, Data transformation, The derived data layer, The user interface. | HCMC UT, 2008 Chapter 1: Data Warehousing Concepts of data warehousing warehouse architectures characteristics of data warehouse data reconciled data layer transformation derived data layer 7. The user interface Motivation “Modern organization is drowning in data but starving for information”. Operational processing (transaction processing) captures, stores and manipulates data to support daily operations. Information processing is the analysis of data or other forms of information to support decision making. Data warehouse can consolidate and integrate information from many internal and external sources and arrange it in a meaningful format for making business decisions. Definition Data Warehouse: (. Immon) A subject-oriented, integrated, time-variant, non-updatable collection of data used in support of management decision-making processes Subject-oriented: . customers, patients, students, products Integrated: Consistent . | HCMC UT, 2008 Chapter 1: Data Warehousing Concepts of data warehousing warehouse architectures characteristics of data warehouse data reconciled data layer transformation derived data layer 7. The user interface Motivation “Modern organization is drowning in data but starving for information”. Operational processing (transaction processing) captures, stores and manipulates data to support daily operations. Information processing is the analysis of data or other forms of information to support decision making. Data warehouse can consolidate and integrate information from many internal and external sources and arrange it in a meaningful format for making business decisions. Definition Data Warehouse: (. Immon) A subject-oriented, integrated, time-variant, non-updatable collection of data used in support of management decision-making processes Subject-oriented: . customers, patients, students, products Integrated: Consistent naming conventions, formats, encoding structures; from multiple data sources Time-variant: Can study trends and changes Nonupdatable: Read-only, periodically refreshed Data Warehousing: The process of constructing and using a data warehouse Data Warehouse—Subject-Oriented Organized around major subjects, such as customer, product, sales. Focusing on the modeling and analysis of data for decision makers, not on daily operations or transaction processing. Provide a simple and concise view around particular subject issues by excluding data that are not useful in the decision support process. Data Warehouse - Integrated Constructed by integrating multiple, heterogeneous data sources relational databases, flat files, on-line transaction records Data cleaning and data integration techniques are applied. Ensure consistency in naming conventions, encoding structures, attribute measures, etc. among different data sources ., Hotel price: currency, tax, breakfast covered, etc. When data is
