Chapter 6
FOUNDATIONS OF BUSINESS
INTELLIGENCE: DATABASES AND
INFORMATION MANAGEMENT
VIDEO CASES
Case 1: Maruti Suzuki Business Intelligence and Enterprise Databases
Case 2: Data Warehousing at REI: Understanding the Customer
, CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE:
DATABASES AND INFORMATION MANAGEMENT
Learning Objectives
• Describe how the problems of managing data resources in a
traditional file environment are solved by a database
management system
• Describe the capabilities and value of a database
management system
• Apply important database design principles
• Evaluate tools and technologies for accessing information
from databases to improve business performance and
decision making
• Assess the role of information policy, data administration,
and data quality assurance in the management of a firm’s
data resources
2 © Prentice Hall 2011
, CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE:
DATABASES AND INFORMATION MANAGEMENT
RR Donnelley Tries to Master Its Data
• Problem: Explosive growth created information
management challenges.
• Solutions: Use MDM to create an enterprise-wide set of
data, preventing unnecessary data duplication.
• Master data management (MDM) enables companies like
R.R. Donnelley to eliminate outdated, incomplete or
incorrectly formatted data.
• Demonstrates IT’s role in successful data management.
• Illustrates digital technology’s role in storing and organizing
data.
3 © Prentice Hall 2011
, CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE:
DATABASES AND INFORMATION MANAGEMENT
Organizing Data in a Traditional File Environment
• File organization concepts
– Database: Group of related files
– File: Group of records of same type
– Record: Group of related fields
– Field: Group of characters as word(s) or number
• Describes an entity (person, place, thing on which we
store information)
• Attribute: Each characteristic, or quality, describing
entity
– E.g., Attributes Date or Grade belong to entity COURSE
4 © Prentice Hall 2011
FOUNDATIONS OF BUSINESS
INTELLIGENCE: DATABASES AND
INFORMATION MANAGEMENT
VIDEO CASES
Case 1: Maruti Suzuki Business Intelligence and Enterprise Databases
Case 2: Data Warehousing at REI: Understanding the Customer
, CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE:
DATABASES AND INFORMATION MANAGEMENT
Learning Objectives
• Describe how the problems of managing data resources in a
traditional file environment are solved by a database
management system
• Describe the capabilities and value of a database
management system
• Apply important database design principles
• Evaluate tools and technologies for accessing information
from databases to improve business performance and
decision making
• Assess the role of information policy, data administration,
and data quality assurance in the management of a firm’s
data resources
2 © Prentice Hall 2011
, CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE:
DATABASES AND INFORMATION MANAGEMENT
RR Donnelley Tries to Master Its Data
• Problem: Explosive growth created information
management challenges.
• Solutions: Use MDM to create an enterprise-wide set of
data, preventing unnecessary data duplication.
• Master data management (MDM) enables companies like
R.R. Donnelley to eliminate outdated, incomplete or
incorrectly formatted data.
• Demonstrates IT’s role in successful data management.
• Illustrates digital technology’s role in storing and organizing
data.
3 © Prentice Hall 2011
, CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE:
DATABASES AND INFORMATION MANAGEMENT
Organizing Data in a Traditional File Environment
• File organization concepts
– Database: Group of related files
– File: Group of records of same type
– Record: Group of related fields
– Field: Group of characters as word(s) or number
• Describes an entity (person, place, thing on which we
store information)
• Attribute: Each characteristic, or quality, describing
entity
– E.g., Attributes Date or Grade belong to entity COURSE
4 © Prentice Hall 2011
