Transcript 5 Networks and Collaboration As Business Solutions

Turban and Volonino
Chapter 3
Managing Data to Improve Business Performance
Information Technology for Management
Improving Performance in the Digital Economy
7th edition
John Wiley & Sons, Inc.
Slides contributed by Dr. Sandra Reid
Chair, Graduate School of Business & Professor, Technology
Dallas Baptist University
Copyright 2010 John Wiley & Sons, Inc.
3-1
Chapter Outline
3.1 Data, Master Data, and Data Management
3.2 File Management Systems
3.3 Database Management Systems
3.4 Data Warehouses, Data Marts, and Data Centers
3.5 Enterprise Content Management
3.6 Managerial Issues
Copyright 2010 John Wiley & Sons, Inc.
3-2
Learning Objectives
1. Describe how data and document management
impact profits and performance.
2. Understand how managers are supported or
constrained by data quality.
3. Discuss the functions of databases and database
management systems.
4. Understand how logical views of data provide a
customized support and improve data security.
5. Describe the tactical and strategic benefits of data
warehouses, data marts, and data centers.
Copyright 2010 John Wiley & Sons, Inc.
3-3
Learning Objectives cont’d
6. Describe transaction and analytic processing
systems.
7. Explain how enterprise content management and
electronic records management reduce cost,
support business operations, and help companies
meet their regulatory and legal requirements.
Copyright 2010 John Wiley & Sons, Inc.
3-4
Applebee’s International Learns & Earns
Problem: Huge quantities of data in many
Databases.
Solution: Enterprise data warehouse
implemented.
Results: Improved profitability.
Copyright 2010 John Wiley & Sons, Inc.
3-5
Applebee’s enterprise data warehouse and
feedback loop
Copyright 2010 John Wiley & Sons, Inc.
3-6
3.1 Data, Master Data, and Document
Management
Copyright 2010 John Wiley & Sons, Inc.
3-7
Data life cycle
• Diminishing data value
• Need for (near) real-time operational data (90/90 data use)
• Data in context
Copyright 2010 John Wiley & Sons, Inc.
3-8
Data Visualization
Dow Jones industrial average (DJIA) for a single day in tabular
display and graphical display.
Copyright 2010 John Wiley & Sons, Inc.
3-9
Model of an enterprise data warehouse
(Source: From Syncsort, synchsort.com. Used with permission.)
Copyright 2010 John Wiley & Sons, Inc.
3-10
Data Quality
•
•
•
•
•
Accuracy
Accessibility
Relevance
Timeliness
Completeness
• Who is responsible for data quality?
– Data ownership
• Who is responsible for data security?
Copyright 2010 John Wiley & Sons, Inc.
3-11
Copyright 2010 John Wiley & Sons, Inc.
3-12
Document Management
• Document Management Systems manage and
archive electronic documents (and convert
paper ones) and then index and store them.
– Query and search capabilities
• Workflow systems, authoring tools databases
• Paperless office, green IT
• Business continuity, security, knowledge sharing,
collaboration, remote access
Hierarchy of data for a computer-based file
Copyright 2010 John Wiley & Sons, Inc.
3-14
Problems: redundancy, inconsistency, data isolation,
integrity, concurrency
Copyright 2010 John Wiley & Sons, Inc.
3-15
(a)Centralized database
(b)Distributed database
with complete or
partial copies of the
central database in
more than one
location.
Copyright 2010 John Wiley & Sons, Inc.
3-16
Database management system provides access to all data in the
database.
Copyright 2010 John Wiley & Sons, Inc.
3-17
Copyright 2010 John Wiley & Sons, Inc.
3-18
Data warehouse framework and views
Copyright 2010 John Wiley & Sons, Inc.
3-19
Teradata Corp.’s enterprise data warehouse.
(Source: Teradata Corporation [teradata.com], with permission.)
Copyright 2010 John Wiley & Sons, Inc.
3-20
Copyright 2010 John Wiley & Sons, Inc.
3-21
Copyright 2010 John Wiley & Sons, Inc.
3-22
3.5 Enterprise Content Management
Copyright 2010 John Wiley & Sons, Inc.
3-23
Electronic records management from creation to
retention or destruction
Copyright 2010 John Wiley & Sons, Inc.
3-24
Managerial Issues
•
•
•
•
•
•
•
•
•
•
Reducing uncertainty.
Cost-benefit issues & justification.
Where to store data physically.
Legal issues.
Internal or external collection, storage, maintenance, &
purging of databases of information?
Disaster recovery.
Data security & ethics.
Privacy.
Legacy systems.
Data delivery.
Copyright 2010 John Wiley & Sons, Inc.
3-25
Copyright 2010 John Wiley & Sons, Inc.
All rights reserved. Reproduction or translation of this
work beyond that permitted in section 117 of the 1976
United States Copyright Act without express permission
of the copyright owner is unlawful. Request for further
information should be addressed to the Permission
Department, John Wiley & Sons, Inc. The purchaser may
make back-up copies for his/her own use only and not
for distribution or resale. The Publisher assumes no
responsibility for errors, omissions, or damages caused
by the use of these programs or from the use of the
Information herein.
Copyright 2010 John Wiley & Sons, Inc.
3-26