1
Chapter 11
The Data Warehouse
Database Systems:
Design, Implementation, and
Management, Seventh Edition, Rob
and Coronel
2
2
In this chapter, you will learn:
How operational data and decision support
data differ
What a data warehouse is, how data for it
are prepared, and how it is implemented
What star schemas are and how they are
constructed
What data mining is and what role it plays
in decision support
3
3
In this chapter, you will learn
(continued):
What online analytical processing (OLAP)
is
How SQL extensions are used to support
OLAP-type data manipulations
4
4
The Need for Data Analysis
Managers must be able to track daily
transactions to evaluate how the business
is performing
By tapping into operational database,
management can develop strategies to
meet organizational goals
Data analysis can provide information
about short-term tactical evaluations and
strategies
5
5
The Need for Data Analysis
(continued)
6
6
The Need for Data Analysis
(continued)
7
7
Decision Support Systems
Decision support is methodology (or series of
methodologies) designed to extract
information from data and to use such
information as a basis for decision making
Decision support system (DSS)
Arrangement of computerized tools used to assist
managerial decision making within business
Usually requires extensive data “massaging” to
produce information
Used at all levels within organization
Often tailored to focus on specific business areas
Provides ad hoc query tools to retrieve data and to
display data in different formats
8
8
Decision Support Systems
(continued)
Composed of following four main components:
Data store component
Basically a DSS database
Data extraction and data filtering component
Used to extract and validate data taken from operational
database and external data sources
End-user query tool
Used to create queries that access database
End-user presentation tool
Used to organize and present data
9
9
Decision Support Systems
(continued)
10