Databases and Data Warehouses

1
3

• Databasesand Data Warehouses

2
YOUR FOCUS IN THIS CHAPTER

• The Difference Between Logical and Physical Views
  of Information
• Databases and Database Management Systems
• Data Warehouses Data Mining

3
What do Organizations do with Information?

• Process Transactions
• OLTP
• Make Decisions
• OLAP
• Manage the Information
• logical vs. physical

4
PROCESSING INFORMATION IN THE FORM OF TRANSACTIONS

• On-Line Transaction Processing (OLTP)
• Gathering information
• Processing information
• Updating existing information
• Operational databases support OLTP.

5
USING INFORMATION TO MAKE A DECISION

• On-Line Analytical Processing (OLAP)
• Data warehouses support OLAP.

6
MANAGING INFORMATION WHILE ITS USED

• Determining who can view or use information
• Specifying how to back up information
• Identifying what storage technologies to use

7
MANAGING INFORMATION WHILE ITS USED

• Physical
• Logical

8
LOGICAL INFORMATION

• Character
• Field
• Record
• File
• Database
• Data Warehouse

9
DATABASE

• The Information Itself
• the files that are logically associated
• The Logical Structure of the Information
• data dictionary

10
DATABASE

• Logical Ties Among the Information
• PRIMARY KEY
• FOREIGN KEY
• Integrity Constraint

11
A DataBase Management System

• contains 5 critical components
• DBMS engine
• data definition subsystem
• data manipulation subsystem
• application generation subsystem
• data administration subsystem

12
DATA MANIPULATION TOOLS

• View
• Report Generator
• Query-by-example (QBE) Tool
• Structured Query Language (SQL)

13
Data Administration Subsystem

• backup and recovery
• security management
• query optimization
• reorganization facilities
• concurrency control
• change management

14
DATA WAREHOUSE

• Logical Extension of Databases
• Combine Information From Different Databases
• Multi-dimensional
• Support Decision Making

15
Data Mining Tools

• query-and-reporting tools
• intelligent agents
• multidimensional analysis tools

16
OVERSEEING YOUR ORGANIZATIONS INFORMATION

• Chief Information Officer (CIO)
• Data Administration
• Database Administration

17
(No Transcript)