FOUNDATIONS OF BUSINESS INTELLIGENCE:
Management Information Systems
MANAGING THE DIGITAL FIRM, 12TH EDITION
Chapter 6
FOUNDATIONS OF BUSINESS
INTELLIGENCE: DATABASES AND
INFORMATION MANAGEMENT
Management Information Systems
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. 2
© Prentice Hall 2011
1
Management Information Systems
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
3
© Prentice Hall 2011
Management Information Systems
CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE:
DATABASES AND INFORMATION MANAGEMENT
Organizing Data in a Traditional File Environment
THE DATA
HIERARCHY
A computer system organizes data in a hierarchy that starts with the bit, which represents either a 0 or a 1. Bits can be grouped to form a byte to represent one character, number, or symbol. Bytes can be grouped to form a field, and related fields can be grouped to form a record.
Related records can be collected to form a file, and related files can be
MANAGING THE DIGITAL FIRM, 12TH EDITION
Chapter 6
FOUNDATIONS OF BUSINESS
INTELLIGENCE: DATABASES AND
INFORMATION MANAGEMENT
Management Information Systems
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. 2
© Prentice Hall 2011
1
Management Information Systems
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
3
© Prentice Hall 2011
Management Information Systems
CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE:
DATABASES AND INFORMATION MANAGEMENT
Organizing Data in a Traditional File Environment
THE DATA
HIERARCHY
A computer system organizes data in a hierarchy that starts with the bit, which represents either a 0 or a 1. Bits can be grouped to form a byte to represent one character, number, or symbol. Bytes can be grouped to form a field, and related fields can be grouped to form a record.
Related records can be collected to form a file, and related files can be