Part 9 Business Intelligence (or Decision Support)
The final part of the book deals with data warehousing, Online Analytical Processing
(OLAP), and data mining.
Chapter 31 discusses data warehousing, what it is, how it has evolved, and describes
the potential benefits and problems associated with this system. The chapter examines
the architecture, the main components, and the associated tools and technologies of a
data warehouse. The chapter also discusses data marts and the issues associated with the
development and management of data marts. The chapter concludes by describing the data
warehousing facilities of the Oracle DBMS.
Chapter 32 provides an approach to the design of the database of a data warehouse/
data mart built to support decision-making. The chapter describes the basic concepts
associated with dimensionality modeling and compares this technique with traditional
Entity–Relationship (ER) modeling. It also describes and demonstrates a step-by-step
methodology for designing a data warehouse using worked examples taken from an
extended version of the DreamHome case study. The chapter concludes by describing how
to design a data warehouse using the Oracle Warehouse Builder.
Chapter 33 describes Online Analytical Processing (OLAP). It discusses what OLAP is
and the main features of OLAP applications. The chapter discusses how multi-dimensional
data can be represented and the main categories of OLAP tools. It also discusses the OLAP
extensions to the SQL standard and how Oracle supports OLAP.
Chapter 34 describes Data Mining (DM). It discusses what DM is and the main features
of DM applications. The chapter describes the main characteristics of data mining operations
and associated techniques. It describes the process of DM and the main features of
DM tools with particular coverage of Oracle DM.
The final part of the book deals with data warehousing, Online Analytical Processing
(OLAP), and data mining.
Chapter 31 discusses data warehousing, what it is, how it has evolved, and describes
the potential benefits and problems associated with this system. The chapter examines
the architecture, the main components, and the associated tools and technologies of a
data warehouse. The chapter also discusses data marts and the issues associated with the
development and management of data marts. The chapter concludes by describing the data
warehousing facilities of the Oracle DBMS.
Chapter 32 provides an approach to the design of the database of a data warehouse/
data mart built to support decision-making. The chapter describes the basic concepts
associated with dimensionality modeling and compares this technique with traditional
Entity–Relationship (ER) modeling. It also describes and demonstrates a step-by-step
methodology for designing a data warehouse using worked examples taken from an
extended version of the DreamHome case study. The chapter concludes by describing how
to design a data warehouse using the Oracle Warehouse Builder.
Chapter 33 describes Online Analytical Processing (OLAP). It discusses what OLAP is
and the main features of OLAP applications. The chapter discusses how multi-dimensional
data can be represented and the main categories of OLAP tools. It also discusses the OLAP
extensions to the SQL standard and how Oracle supports OLAP.
Chapter 34 describes Data Mining (DM). It discusses what DM is and the main features
of DM applications. The chapter describes the main characteristics of data mining operations
and associated techniques. It describes the process of DM and the main features of
DM tools with particular coverage of Oracle DM.
No comments: