Transcript O'Brien - Intro. to Information Systems

Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Data Resource
Management
Real World Cases
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-1
Learning Objectives
1.
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Explain the importance of implementing data
resource management processes and
technologies in an organization.
2. Outline the advantages of the database
management approach to managing the data
resources of a business.
3. Explain how database management software
helps business professionals and supports the
operations and management of a business.
4. Provide examples to illustrate each of the
following concepts:
a.
b.
c.
d.
e.
Major types of databases
Data warehouses and data mining
Logical data elements
Fundamental database structure
Database development
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-2
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
Managing Data
Resources
Data Resource Management
Data – A Vital Business Asset
Data Warehousing
Real World Case 1…
Argosy Gaming Co.:
Challenges in Building a
Click to go to
Data Warehouse
Case 1
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-3
Foundation Data Concepts
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Data Organization Structure
• Character
• Field
• Record
• File
• Database
Graphically…
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-4
Foundation Data Concepts
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Data Organization Structure
Human Resource
Database
Payroll File Benefit File
Employee
Record 1
Employee
Record 2
Name SS No. Salary Name SS No. Salary
Field Field Field Field Field Field
Employee
Record 3
Employee
Record 4
Name SS No. Salary Name SS No. Salary
Field Field Field Field Field Field
Real World Cases
Jones T.A.
275-32-3874
20,000
Klugman J.L. 349-88-7913
28,000
Alverez, J.S. 542-40-3718
100,000
Porter, M.L. 617-87-7915
50,000
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-5
Foundation Data Concepts
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
Example: An Electric Utility Database
Electric Utility Database
Billing
Meter
Reading
Entities:
Customers, Meters, Bills,
Payments, Meter Readings
Relationships:
Bills Sent to Customers
Customers Make Payments
Customers Use Meters
Payment
Processing
Service
Start/Stop
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-6
Types of Databases
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
• Operational Databases
• Distributed Databases
• External Databases
• Hypermedia Databases
Real World Cases
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-7
Types of Databases
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
Distributed Database Model
External
Databases
on the
Internet and
Online
Services
Client PC
Network
Server
Distributed
Databases
on Intranets
and Other
Networks
Operational
Databases
of the
Organization
End User
Databases
Data
Warehouse
Data
Marts
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-8
Types of Databases
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Operational Databases
Real World Cases
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-9
Types of Databases
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Web-Based Information System
Web
Browser
The Internet
Intranets
Extranets
Web
Server
Software
Client PCs
Network
Server
Real World Cases
KEY TERMS
BACK NEXT
HTML
XML
Web Pages
Image Files
Video Files
Audio Files
Hypermedia
Database
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-10
Data Warehouses
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
Components of a Complete Data
Warehouse
Operational, External,
and Other Databases
Analytical
Data Store
Data
Management
Data
Marts
Data Acquisition
(Capture, clean,
transform,
transport,
load/apply)
Warehouse
Design
Enterprise
Warehouse
Metadata
Management
Metadata
Directory
Metadata
Repository
Data Analysis
(Query, report,
analyze, mine,
deliver)
Web
Information
System
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-11
Data Warehouses
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Shell Exploration: The Business
Value of a Data Warehouse
• ERP or SCM Software
Installation
• Combining Databases
• 27 Sources Become 1 Huge
Data Warehouse
• More Powerful Data Source
in One Warehouse
Graphically…
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-12
Data Warehouses
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Applications
ERP
Inveentory
Control
Data Marts
Finance
Marketing
Logistics
Sales
Shipping
Purchasing
Accounting
Real World Cases
KEY TERMS
BACK NEXT
CRM
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
Management
Reporting
5-13
Data Mining
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
• Identify New Product
Bundles
• Find Root Causes to Quality
or Manufacturing Problems
• Prevent Customer Attrition
• Cross-Sell to Existing
Customers
• Profile Customers with More
Accuracy
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-14
Data Mining
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Using Data Mining to Develop
Business Knowledge
Data Transformation
Selection
Database
Target
Data
Data
Mining
Target
Warehouse
Implementation/
Evaluation
Patterns
Business
Knowledge
Real World Cases
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-15
Data Mining
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Bank of America: Benefits
of Data Mining
• Sought to Profile Customers
• Wanted to Identify More
Accurate, Specific Target
Markets
• Extremely Accurate and
Effective Results
• Customer Patterns Revealed
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-16
File Processing Programs
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
• Traditional File Processing
• Information Wanted is in
Different Files
• Each File Used by a
Different Application
Program
• No Application Program Can
Get the Information from
these Files
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-17
File Processing Programs
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Example – Bank File Processing Systems
Real World Cases
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-18
File Processing Programs
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Problems of File Processing
• Data Redundancy
• Lack of Data Integration
• Data Dependence
• Other Problems
–Accuracy
–Integrity
–Completeness
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-19
Database Management System
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
The Software Interface
Between Users and the
Databases
Controls How Databases
are:
–Created
–Interrogated
–Maintained
–Provide Needed
Information
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-20
Database Management System
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Alberta Central: Converting
to Database Management
• Administrative Services
Organization for 38 Credit
Unions
• Making Switch to DBMS
• Sought Demographic, Account,
and Product Information
• New DB2 System Provided
Superior Results and Faster
Reports
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-21
Database Management System
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Inquiry
Customer Transaction Processing
Checking
Account
Program
Installment
Loan
Program
Database Management System
Real World Cases
Customer
Database
KEY TERMS
BACK NEXT
Savings
Account
Program
Checking Account Data
Savings Account Data
Installment Loan Data
Other Customer Data
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-22
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
Database Management System
Common Software Components
Common DBMS Software
Components
•Database Definition
•Nonprocedural Access
•Application Development
•Procedural Language
Interface
•Transaction Processing
•Database Tuning
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-23
Database Management System
mySQL DBMS Application
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-24
Database Management System
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Three Major Uses of DBMS Software
Operating
System
Database
Management
Database
Management
System
Databases
Application
Programs
•Create: Database and Application Development
•Maintain: Database Maintenance
•Use: Database Interrogation
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-25
Database Management System
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
Database Interrogation
• SQL Queries
• Graphical and Natural
Queries
Database Maintenance
Database Application
Development
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-26
Database Management System
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Example Application
Microsoft Access
Report Generator
Real World Cases
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-27
Database Management System
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
WH Smith PLC: Transaction
Processing and Database
Interrogation
• Sought Customer Buying
Trends
• Improved Inventory
Management
• Sought to Cut Paper Usage
• Wanted POS System for
Data Capture
• Successful Management Tool
Created
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-28
Database Management System
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Example Application
Query Wizard of
Microsoft Access
Real World Cases
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-29
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Technical
Foundations
of Database Management
• Need for Organization
• Use Logical Structure
• Processed Efficiently
• Retrieved Quickly
Real World Case 2Owens & Minor and NBC
Click to go to
Case 2
Universal
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-30
Database Structures
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Three Major Database Structures
Real World Cases
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-31
Database Structures
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Three Major Database Structures
•Hierarchical Structure
•Network Structure
•Relational Model
•Multidimensional Structure
Employee Table
Department Table
Deptno Dname
Dept A
Dept B
Dept C
Dloc
Dmgr
Empno Ename
Emp 1
Emp 2
Emp 3
Emp 4
Emp 5
Emp 6
Etitle
Esalary
Deptno
Dept A
Dept A
Dept B
Dept B
Dept C
Dept B
Real World Cases
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-32
Database Structures
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
The Multidimensional Structure
Real World Cases
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-33
Database Structures
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
The Object-Oriented Structure
Bank Account Object
Attributes
•Customer
•Balance
•Interest
Operations
•Deposit (Amount)
•Withdraw (Amount)
•Get Owner
Inheritance
Checking Account Object
Attributes
•Credit Line
•Monthly Statements
Operations
•Calculate Interest
•Print Monthly Statement
Inheritance
Savings Account Object
Attributes
•Number of Withdrawals
•Quarterly Statement
Operations
•Calculate Interest Paid
•Print Quarterly Statement
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-34
Database Structures
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Object-Oriented Graphical Display
Real World Cases
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-35
Database Structures
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Evaluation of Database Structures
•Hierarchical – Natural for Many
Applications
•Network Structures – Handles
Many-to-Many Relationships Well
•Neither Handles Ad Hoc Inquiries
Well
•Relational Structures – Easily
Retrieves Ad Hoc Requests
•Relational is Not as Efficient
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-36
Database Structures
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Experian Automotive: The
Business Value of Relational
Database Management
•Vehicle Data Collection Unit of
Credit Reporting Company
•Data Collected to be Sold
•50 Different DMV Systems
•Database Processes 175 Million
Records per Month
•Provided New Revenue Streams
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-37
Database Development
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
•Database
Administrators (DBAs)
•Data Definition
Language (DDL)
•Data Dictionary
•Metadata
•Metadata Repository
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-38
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Database Development
Example Application
Table Wizard of
Microsoft Access
Real World Cases
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-39
Database Development
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
1- Data Planning
Develops a model of
business processes
Physical Data Models
Storage representations and
access methods
Enterprise model of
business processes
with documentation
5- Physical Design
Determines the data storage
structures and access methods
2- Requirements Specification
Define information needs of
End users in a business processes
Logical Data Models
e.g., relational, network,
hierarchical, multidimensional,
Or object-oriented models
Description of users needs may
be represented in natural
language or using the tools of a
particular design technology
4- Logical Design
Translates the conceptual
models into the data model of a
DBMS
Real World Cases
KEY TERMS
BACK NEXT
END
3- Conceptual Design
Expresses all information
requirements in the form of a
High-level model
Copyright 2005, McGraw-Hill/Irwin, Inc.
Conceptual Data Models
Often expressed as entity
relationship models
5-40
Data Planning
Purchase
Order Item
Ordered on
Purchase
Order
Product
Supplies
Supplier
Stocked as
Real World Cases
• Data Planning Process
• Enterprise Model
• Entity Relationship Diagram
Contains
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Product
Stock
Holds
Warehouse
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-41
Data Planning
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Aetna and Shop at Home Network:
Development Solutions
• 15,000 Database Table
Definitions
• Many Problems Without
Definition Organization
• Use of Oracle DBMS
• Importance of Proper
Installation and Maintenance
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-42
Data
Planning
Logical and Physical Database Views
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Checking
Application
Savings
Application
Installment
Loan
Application
Logical User Views
Checking and
Savings
Data Model
Installment
Loan
Data Model
Banking Services Data Model
Database Management System
Data elements and
relationships (the subschemas)
needed for checking, savings,
or installment loan processing
Data elements and
relationships (the schema)
needed for the support of all
bank services
Software Interface
The DBMS provides access
to the bank’s databases
Real World Cases
KEY TERMS
BACK NEXT
Bank
Databases
Physical Data Views
Organization and location of
data on the storage of media
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-43
Summary
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
1. Data Resource
Management
2. Database Management
3. Database Software
4. Types of Databases
5. Data Access
6. Database Development
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-44
KEY TERMS
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Data Dictionary
Data Mining
Data Modeling
Data Resource Management
Database Administrator
Database Management
Approach
Database Management System
(DBMS)
Database Structure
a.
b.
c.
d.
Hierarchical Multidimensional
Network
Object-Oriented
Relational
DBMS uses
Real World Cases
KEY TERMS
BACK NEXT
END
a.
b.
c.
d.
Application Development
Database Development
Database Interrogation
Database Maintenance
Copyright 2005, McGraw-Hill/Irwin, Inc.
File Processing
Logical Data Elements
a.
b.
c.
d.
e.
Character
Field
Record
File
Database
Metadata
Query Language
Report Generator
Types of Databases
- Data Warehouse
- Distributed
- External
- Hypermedia
- Operational
5-45
Optional Case Studies
Real World Case 1
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Argosy Gaming Co.: Challenges
of Building a Data Warehouse
Click to go to
Case 1
Real World Case 2
Owens & Minor and NBC
Universal: Protecting Strategic
Data Resources
Real World Case 3
Henry Schein Inc.: The Business
Value of a Data Warehouse
Click to go to
Case 2
Click to go to
Case 3
Real World Case 4
Anadarko Petroleum and Prudential
Financial: Challenges of Data
Resource Management
Copyright 2005, McGraw-Hill/Irwin, Inc.
Click to go to
Case 4
5-46
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Telecommunications
and Networks
Real World Cases
Chapter 6
KEY TERMS
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-47
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
Argosy Gaming Co.:
Challenges of Building
a Data Warehouse
1- What is the business value of a data
warehouse? Use Argosy Gaming as an
example.
Business values would include:
• Forced to Map and Analyze the Data
• Data Warehouse Brings Customer
Data Together
• Corporate Management Analyzes Data
Return to
• Finds Conflicting Definitions Chapter
5
• Limits Effective Decisions
Return to
Cases Page
BACK NEXT
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-48
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
Argosy Gaming Co.:
Challenges of Building
a Data Warehouse
2- Why did Argosy use an ETL software
tool? What benefits and problems arose?
How were they solved?
Benefits would include:
• Coordinates Source Data Extracting
Process
• Developed Consistent Categories of
Data
• Better Planning for Future Activities
• Storing Data Values and Structures
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-49
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
Argosy Gaming Co.:
Challenges of Building
a Data Warehouse
2- Why did Argosy use an ETL software
tool? What benefits and problems arose?
How were they solved?
Problems would include:
•Preparing ETL Process
•Conflicting Data Definitions
•Warehouse Data not
Dependable/Usable
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-50
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Argosy Gaming Co.:
Challenges of Building
a Data Warehouse
3- What are some of the major
responsibilities that business
professionals and managers
have in data warehouse
development? Use Argosy
Gaming as an example.
Return to
Chapter 5
Real World Cases
KEY TERMS
BACK NEXT
Return to
Cases Page
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-51
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
Argosy Gaming Co.:
Challenges of Building
a Data Warehouse
Responsibilities would include:
• Planning-Data Warehouse/Data
Mining
• Must have Quality Data
• Achievements from Data
• Architecture-Centralized/Distributed
• ETL Foundation-Future
Return to
Growth
Chapter 5
KEY TERMS
BACK NEXT
Return to
Cases Page
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-52
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Argosy Gaming Co.:
Challenges of Building
a Data Warehouse
Responsibilities would include:
• Planning-Data Warehouse/Data
Mining
• Must have Quality Data
• Achievements from Data
• Architecture-Centralized/Distributed
• ETL Foundation-Future
Return to
Growth
Chapter 5
• Identify problems/Achieve
Return to
Cases Page
Consensus
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-53
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Owens & Minor and NBC
Universal: Protecting Strategic
Data Resources
1- Why have developments in IT
helped to increase the value of the
data resources of many companies?
Developments would include:
• Storage of Detailed Data
• Access Information-External
Databases
• Increased Use of Internet
Databases
• Data Warehousing/
Mining Adds Value
Return to
Chapter 5
Return to
Cases Page
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-54
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Owens & Minor and NBC
Universal: Protecting Strategic
Data Resources
2- How have these IT capabilities
increased the security challenges
for a company’s data resources?
Increased Challenges would include:
• Protect Business-Intelligence Data
• Restricting Access to Data
• Acquire Web-Intelligent Software
• Challenges of System
Administration
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-55
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
Owens & Minor and NBC
Universal: Protecting Strategic
Data Resources
3- How can companies use IT to
meet the challenges of data
resource security?
Ways to Meet Challenges would include:
• Establish Role-Level Security
• Store Security Role-Levels
• Restrict Use of Business-Intelligence
• Authentication/Authorization
Return to
Encryption
Chapter 5
KEY TERMS
BACK NEXT
Return to
Cases Page
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-56
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Owens & Minor and NBC
Universal: Protecting Strategic
Data Resources
3- How can companies use IT to
meet the challenges of data
resource security?
Ways to Meet Challenges would include:
• Establish Role-Level Security
• Store Security Role-Levels
• Restrict Use of Business-Intelligence
• Authentication/Authorization
Return to
Encryption
Chapter 5
• Create Web Portals and
Return to
Cases Page
User Roles
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-57
Henry Schein Inc.: The
Business Value of a Data
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
1- What are some of the
key requirements for
building a good data
warehouse? Use Henry
Schein Inc. as an
example.
Real World Cases
KEY TERMS
BACK NEXT
Return to
Cases Page
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-58
Henry Schein Inc.: The
Business Value of a Data
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Requirements would include:
• Right Skills-Build Data
Warehouse
• Ensure Data Quality
• Plan-Needed Information and
Reports
• Analyze-Old Reports/Data
• Standardize Transactional Codes
• Develop/Test Summary Tables
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-59
Henry Schein Inc.: The
Business Value of a Data
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
2- What are the key software
tools needed to construct and
use a data warehouse?
Key software tools would include:
•Data Extraction Software
•Query/Reporting Software
•Data Transformation/Loading
Software
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-60
Henry Schein Inc.: The
Business Value of a Data
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
3- What is the business value of a
data warehouse to a company?
The business value would include:
•Most Profitable Customers
•Customers To Target
•Analyze Business by Areas
•Use Specific Direct
Marketing
KEY TERMS
BACK NEXT
Return to
Cases Page
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-61
Henry Schein Inc.: The
Business Value of a Data
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
3- What is the business value of a
data warehouse to a company?
The business value would include:
•Most Profitable Customers
•Customers To Target
•Analyze Business by Areas
•Use Specific Direct
Marketing
•Add More Fields to
Reports
Return to
Cases Page
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-62
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
Anadarko Petroleum
and Prudential Financial:
Challenges of Data Resource
Management
1- How did Anadarko
Petroleum meet its data
resource management
challenges? What is the
business value of their
approach?
KEY TERMS
BACK NEXT
Return to
Cases Page
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-63
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Anadarko Petroleum
and Prudential Financial:
Challenges of Data Resource
Management
Anadarko met its challenges by:
•IT Team Worked on:
– Communication
– Planning
– Change Management
•Technology Wedded to
Business Strategy
•Effective Overall Leadership
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-64
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Anadarko Petroleum
and Prudential Financial:
Challenges of Data Resource
Management
The business value would include:
•Improved Performance
•Lower Costs
•Anadarko Ahead of
Competitors
•Standard Networked
Storage Model
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-65
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
Anadarko Petroleum
and Prudential Financial:
Challenges of Data Resource
Management
2- What are the business
benefits of the data
resource management
processes that Patricia
Graham is selling to
business users at
Prudential Financial?
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-66
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Anadarko Petroleum
and Prudential Financial:
Challenges of Data Resource
Management
Business benefits would include:
•Time Savings
•Quality Improvement
•Foster Communication
•More Time for Running
Business
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-67
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Anadarko Petroleum
and Prudential Financial:
Challenges of Data Resource
Management
3- How does effective data
resource management
contribute to the strategic
business goals of companies?
Use Anadarko and Prudential
Financial as examples.
Real World Cases
KEY TERMS
BACK NEXT
Return to
Cases Page
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-68
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Anadarko Petroleum
and Prudential Financial:
Challenges of Data Resource
Management
Contributions would include:
•Improved
Performance/Time Savings
•Reduced Costs
•Serve Customers Better
Real World Cases
KEY TERMS
BACK NEXT
Return to
Cases Page
END
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-69
Managing Data
Resources
Types of
Databases
Data Warehouses
The Database
Management
Approach
Section II
Technical
Foundations of
Database
Management
Database
Structures
Database
Development
Real World Cases
KEY TERMS
BACK NEXT
END
Anadarko Petroleum
and Prudential Financial:
Challenges of Data Resource
Management
Contributions would include:
•Improved
Performance/Time Savings
•Reduced Costs
•Serve Customers Better
•Improved Data
Quality
Return to
Cases Page
Copyright 2005, McGraw-Hill/Irwin, Inc.
5-70