《管理信息系统》课程电子教案（PPT教学课件，英文版）Chapter 05 Data Resource Management

Introduction to Information Systems Essentials for the Internetworked E-Business Enterprise Chapter Data Resource Management

1 Introduction to Information Systems Essentials for the Internetworked E-Business Enterprise C h a p t e r 5 Data Resource Management

James A.O'Brien Introduction to Information Systems Eleventh Edition Chapter Objectives Explain the importance of implementing data resource management processes and technologies in an organization. Outline the advantages of a database management approach to managing the data resources of a business. Explain how database management software helps business professionals and supports the operations and management of a business

James A. O’Brien Introduction to Information Systems Eleventh Edition 2 • Explain the importance of implementing data resource management processes and technologies in an organization. • Outline the advantages of a database management approach to managing the data resources of a business. • Explain how database management software helps business professionals and supports the operations and management of a business. Chapter Objectives

James A.O'Brien Introduction to Information Systems Eleventh Edition Chapter Objectives Provide examples to illustrate each of the following concepts: Major types of databases Data warehouses and data mining Logical data elements Fundamental database structures Database access methods -Database development

James A. O’Brien Introduction to Information Systems Eleventh Edition 3 • Provide examples to illustrate each of the following concepts: – Major types of databases – Data warehouses and data mining – Logical data elements – Fundamental database structures – Database access methods – Database development. Chapter Objectives

James A.O'Brien Introduction to Information Systems Eleventh Edition 4 Logical Data Elements Personnel Database Payroll Benefits File File Employee Employee Employee Employee Record 1 Record 2 Record 3 Record 4 Name SS Salary Name SS Salary Name SS Salary Name SS Salary Data Data Data Data Data Data Data Data Data Data Data Data

James A. O’Brien Introduction to Information Systems Eleventh Edition 4 Logical Data Elements Employee Record 2 Employee Record 1 Employee Record 3 Employee Record 4 Name SS Salary Name SS Salary Name SS Salary Name SS Salary Data Data Data Data Data Data Data Data Data Data Data Data Personnel Database Payroll File Benefits File

James A.O'Brien Introduction to Information Systems Eleventh Edition Database Management Systems Operating System Database Management Database Databases Management System ■■■■ ■服■■■厦 国■面■■■ Application Data .Database Development Programs Dictionary .Database Interrogation .Database Maintenance .Application Development

James A. O’Brien Introduction to Information Systems Eleventh Edition 5 Operating System Database Management System Application Programs Databases Data Dictionary Database Management •Database Development •Database Interrogation •Database Maintenance •Application Development Database Management Systems

James A O'Brien Introduction to Information Systems Eleventh Edition 6 Major Types of Databases External Databases on the Internet Online Services Client PCor Distributed Databases on NC Network Intranets Operational Databases of Other Networks Server the Organization End User Databases Data Data Warehouse Mart

James A. O’Brien Introduction to Information Systems Eleventh Edition 6 Network Server External Databases on the Internet & Online Services Client PC or NC Operational Databases of the Organization Data Mart End User Databases Data Warehouse Distributed Databases on Intranets & Other Networks Major Types of Databases

James A.O'Brien Introduction to Information Systems Eleventh Edition 7 Data Warehouse and Data Mining Client Operational PCor Databases Analytical NC Data Data Store Management Enterprise R■■■ 益面量■了 Subsystem 面■面■ Warehouse Data Data Mart Acquisition Data Access Subsystem and Delivery Metadata Subsystem Metadata Directory Management Warehouse Subsystem Metadata Design Repository Web Subsystem Information System

James A. O’Brien Introduction to Information Systems Eleventh Edition 7 Data Warehouse and Data Mining Client PC or Analytical NC Data Store Enterprise Warehouse Data Mart Data Acquisition Subsystem Warehouse Design Subsystem Data Management Subsystem Data Access and Delivery Subsystem Web Information System Operational Databases Metadata Directory Metadata Repository Metadata Management Subsystem

James A.O'Brien Introduction to Information Systems Eleventh Edition 8 Web-Based Systems Network The Internet Server Intranets Extranets Web Browser Web Server Web Objects Software ■■■0 ■■■■■ D0000 HTML pages Client PCs GIF image files or NCs Video files

James A. O’Brien Introduction to Information Systems Eleventh Edition 8 Web-Based Systems Web Browser Web Server Software Network Server The Internet Intranets Extranets Client PCs or NCs HTML pages GIF image files Video files Web Objects

James A.O'Brien Introduction to Information Systems Eleventh Edition 9 Data Resource Management Data Administration Data Planning Database Administration

James A. O’Brien Introduction to Information Systems Eleventh Edition 9 Data Resource Management Data Administration Data Planning Database Administration

James A.O'Brien Introduction to Information Systems Eleventh Edition 10 Database Structures Hierarchical Structure Network Structure Dept Dept A Dept B Employee Project A Employee Project B Employee 1 2 3 Employee Employee Project A Project B 1 Relational Structure Dept Dname Dloc Dmgr Empno Ename Etitle Dept A 7 A B 2 B c 3 C

James A. O’Brien Introduction to Information Systems Eleventh Edition 10 Database Structures Employee 2 A Empno Ename Etitle Dept 1 2 B 3 C Relational Structure Hierarchical Structure Network Structure Employee 3 Project A Project B Dept Dname Dloc Dmgr A B C Employee 2 Employee 1 Project A Employee 1 Dept Dept A Dept B Project B