Data warehouse
a large store of data accumulated from a wide
range of sources within a company and used to guide management decisions.
Purpose : to
aggregate information throughout an organization into a single repository for decision making purpose
Extraction , transformation and loading (ETL)
-Extracts data from homogeneous
or heterogeneous data sources
-Transforms the data for
storing it in the proper format or structure for the purposes of querying and
analysis
-Loads it into the final target (database, more specifically, operational data store, data mart,
or data
warehouse)
Data mart
A subset of data warehouses information
Data warehouse model
Multidimensional analysis and data mining
·
In
data warehouse and data mart , information is multidimensional , it contains
layers of columns and rows
·
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
techniques to find patterns and relationships in large volumes of information
and infers rules that predict future behavior and guide decision making
Information cleansing and scrubbing
A process that weeds out and fixes or discards
inconsistent,incorrect or incomplete information.
contact information in an operational system
standardizing customer name from operational system
information cleansing activities
accurate and complete information
Business intelligence
Information that people use to support their
decision making efforts
