Transcript wallace_iso1_inppt04..

Chapter 4:
Managing Information Resources
with Databases
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 1
Learning objectives
1.
2.
3.
4.
5.
6.
Information resources
Database advantages
Relational database
Master data management
Data warehouse
Information management
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 2
YouTube
•
•
•
•
Founded in 2005
Goal to create worldwide community
Database of videos
Within one year, 100 million videos per day
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 3
Information resources
•
•
•
•
Structured information
Unstructured information
Semi-structured information
Metadata
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 4
Quality of information
•
•
•
•
•
•
•
Accuracy
Precision
Completeness
Consistency
Timeliness
Bias
Duplication
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 5
Managing information
• Record
• Field
• Table
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 6
File processing systems
•
•
•
•
Redundancy and inconsistency
Lack of integration
Inconsistent definitions
Dependence
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 7
Databases
•
•
•
•
•
Reduced redundancy
Integrity and accuracy
Ability to adapt to changes
Performance and scalability
Security
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 8
Database architecture
• One to one (1:1)
• One to many (1:M)
• Many to many (M:M)
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 9
Relational database
• Tables of records
• Link field in one
table to field in
another table
• Separates data from
paths to retrieve
data
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 10
Data model (1:2)
• Entities and
attributes
• Primary key
• Normalization
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 11
Data model (2:2)
• Relationships and foreign keys
• Complex relationships
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 12
Retrieving information
• Structured query language (SQL)
• Interactive voice response (IVR)
• Natural language interfaces
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 13
Managing the database
• Performance tuning
and scalability
• Integrity, security,
and recovery
• Documentation
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 14
Multiple databases
• Integration
challenges
• Shadow systems
• Master data
management
• Data stewards
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 15
Data warehouses
• Building data warehouses
• Extract, transform, and load (ETL)
• Data mining
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 16
Human element
• Ownership issues
• Databases without boundaries
• Stakeholders
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 17
Summary
1.
2.
3.
4.
5.
6.
Information resources
Database advantages
Relational database
Master data management
Data warehouse
Information management
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 18
UK police case
• Video surveillance
• Automatic plate
number recognition
• Database
• Queries and data
mining
• Privacy
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 19
Colgate Palmolive case
• $15 billion sales, 70 countries
• Consistency in products and data
• Colgate Business Planning (CBP)—profit,
loss and ROI by product, region, and retailer
• Reinvested $100 million in most profitable
promotions, goal $300 million
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 20
Copyright © 2013 Pearson Education, Inc. publishing as Prentice Hall
Chapter 4 - 21