unit Data Base systems Explain the importance of

unit- Data Base systems �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 �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.

Logical Data Elements Personnel Database Employee Record 1 Name Data Payroll File Benefits File Employee Record 2 Employee Record 3 SS Salary Name Data Data Employee Record 4 SS Salary Name Data SS Salary Data

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

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

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

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

Data Resource Management Data Administration Data Planning Database Administration

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

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

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

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

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.

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.