Scribd
Upload
5 views14 pages

Databases and Data Warehouses Explained

Chapter 3 discusses the role of databases and data warehouses in supporting analytics-driven organizations, emphasizing the importance of business intelligence (BI) and analytics for strategic decision-making. It explains the relational database model, including concepts like primary and foreign keys, and outlines the components of a database management system (DBMS). Additionally, it covers data warehouses, data marts, and the need for effective information management to achieve organizational goals.

Uploaded by

Hans Galang
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
5 views14 pages

Databases and Data Warehouses Explained

Chapter 3 discusses the role of databases and data warehouses in supporting analytics-driven organizations, emphasizing the importance of business intelligence (BI) and analytics for strategic decision-making. It explains the relational database model, including concepts like primary and foreign keys, and outlines the components of a database management system (DBMS). Additionally, it covers data warehouses, data marts, and the need for effective information management to achieve organizational goals.

Uploaded by

Hans Galang
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

CHAPTER 3

Databases and
Data
Warehouses:
Supporting the
Analytics-Driven
Organization

McGraw-Hill/Irwin Copyright © 2013 by The McGraw-Hill Companies, Inc. All rights reserved.
INTRODUCTION

 Business intelligence (BI) –


collective information that gives
you the ability to make effective,
important, and strategic business
decisions
 Analytics – the science of fact-
based decision making
 Both are huge in today’s business
world
3-2
OLTP, OLAP, and Business
Intelligence

3-3
RELATIONAL DATABASE
MODEL
 Database – collection of
information that you organize
and access according to the
logical structure of the
information
 Relational database – series of
logically related two-dimensional
tables or files for storing
information
 Relation = table = file 3-4
Database – Collection of
Information

3-5
Database – Logical Ties within
the Information

 Primary key – field (or group of


fields) that uniquely describes each
record
 Foreign key – primary key of one file
that appears in another file
Customer Number
is the primary key
for Customer and
appears in Order as
a foreign key
3-6
DATABASE MANAGEMENT
SYSTEM TOOLS
 Database
management
system (DBMS)
– helps you
specify the logical
requirements for a
database and
access and use
the information in
a database
3-7
5 Components of a DBMS

1. DBMS engine
2. Data definition subsystem
3. Data manipulation subsystem
4. Application generation
subsystem
5. Data administration subsystem

3-8
DATA WAREHOUSES AND DATA
MINING

 Help you build and


work with BI and some
forms of knowledge
 Data warehouse –
collection of
information (from
many places) that
supports business
analysis activities and
3-9
The Tool Set of the
Analytics Professional

3-10
Digital Dashboard

3-11
The Analytics Life Cycle

3-12
Data Marts
 Data mart – subset of a data
warehouse in which only a focused
portion of the data warehouse
information is kept

3-13
INFORMATION OWNERSHIP

 Information is a resource you


must manage and organize to
help the organization meet its
goals and objectives
 You need to consider
 Strategic management support
 Sharing information with
responsibility
 Information cleanliness
3-14

You might also like