CHAPTER 8 :Accessing Organizational Information-Data Warehouse

  CHAPTER 8 :Accessing Organizational Information-Data Warehouse

• Data warehouse- a logical collection of information-gathered from many different operational databases-that supports business analysis activities and decision-making tasks.
• The primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository for decision-making purpose.

Data Warehouse Fundamental

• Extraction, transformation, and loading (ETL)- a process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse.
• Data mart-contains a subsets of data warehouse information.
  

                                                 Data Warehouse Model

Multidimensional Analysis and Data Mining

• Databases contain information in a series of two-dimensional tables.
• In a data warehouse and data mart, information is multidimensional, it contains layers of columns and rows -dimension-a particular attribute of information.
• Cube- common term for the representation of multidimensional information.
• Data mining- the process of analyzing data to extract information not offered by the raw data alone.
• Data mining tool-uses a variety of techniques to find patterns and relationship in large volumes of information and infers rules that predict future behavior and guide decision making.
• Information cleansing or scrubbing- a process that weeds out and fixes or discards inconsistent, incorrect or incomplete information.
• Business intelligence-information that people use to support their decision-making effort.This principle enablers-technology, people, culture.