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