Data Resource Management

1. 5 DataResourceManagement

2. 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.

3. 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.

4. Personnel Database Benefits File Payroll File Employee Record 1 Employee Record 2 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 Logical Data Elements

5. Operating System Database Management System Application Programs Database Management Databases • Database Development • Database Interrogation • Database Maintenance • Application Development Data Dictionary Database Management Systems

6. External Databases on the Internet & Online Services Network Server Client PC or NC Distributed Databases on Intranets & Other Networks Operational Databases of the Organization End User Databases Data Warehouse Data Mart Major Types of Databases

7. Operational Databases Analytical Data Store Enterprise Warehouse Data Mart Data Management Subsystem Client PC or NC Data Acquisition Subsystem Data Access and Delivery Subsystem Metadata Directory Metadata Management Subsystem Warehouse Design Subsystem Metadata Repository Web Information System Data Warehouse and Data Mining

8. Network Server The Internet Intranets Extranets Web Server Software Web Browser Web Objects HTML pages GIF image files Video files Client PCs or NCs Web-Based Systems

9. Data Administration Data Planning Database Administration Data Resource Management

10. Network Structure Hierarchical Structure Dept A Dept Dept B Employee 2 Employee 3 Employee 1 Project A Project B Employee 2 Project B Project A Employee 1 Relational Structure Dept Dname Dloc Dmgr Empno Ename Etitle Dept A 1 A B 2 B C 3 C Database Structures

11. Bank Account Object • Attributes • Customer • Balance • Operations • Deposit • Withdraw Denver West Feb Actual Budget Checking Account Object Savings Account Object East Sales TV • Attributes • Credit Line • Mthly Statement • Operations • Calculate Interest • Print Mthly • Statement • Attributes • Credit Line • Mthly Statement • Operations • Calculate Interest • Print Mthly • Statement VCR TV Margin VCR Multidimensional Database Structure Object-Oriented Database Structure Database Structures (cont)

12. Key Transformation Sequential Organization Key Fields URLs Sequential Access Indexed Sequential Access Method Direct Access Accessing Files and Databases

13. 1. Data Planning Physical Models Enterprise Model 5. Physical Design 2. Requirements Specifications Logical Models User Needs Description 4. Logical Design 3. Conceptual Design Data Models Database Development

14. Chapter Summary • Data resource management is a critical management activity. Management roles include database administration, data planning, and data administration. • Under the database management approach, data records are consolidated into databases that can be accessed by many different application programs, serving multiple users.

15. Chapter Summary (cont) • Database management systems are software packages that simplify the creation, use, and maintenance of databases. • Several types of databases are used by organizations including operational, distributed, external, data warehouses and data marts. • Database development for large corporate databases requires a top-down planning effort involving planning, requirements specification and logical and physical design.