In this chapter, the following content will be discussed: Describe basic file organization concepts and the problems of managing data resources in a traditional file environment, describe how a database management system organizes information and compare the principal database models, apply important database design principles,. | Managing Data Resources Lecture 5 Describe basic file organization concepts and the problems of managing data resources in a traditional file environment Describe how a database management system organizes information and compare the principal database models Apply important database design principles Managing Data Resources OBJECTIVES Evaluate new database trends Identify the challenges posed by data resource management and management solutions OBJECTIVES (Continued) Managing Data Resources Challenge: Fragmented and isolated corporate systems creating a single integrated view of customers and operations Solution: single integrated corporate data warehouse, using a single data model. Oracle 9i database provides near real-time access to customer activity, customer profitability, and customer reactions Illustrates the importance of managing data resources for achieving profitability Managing Data Resources Virgin Mobile Australia Case File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1) Byte: Group of bits that represents a single character Field: Group of words or a complete number Record: Group of related fields File: Group of records of same type ORGANIZING DATA IN A TRADITIONAL FILE ENVIRONMENT Managing Data Resources Database: Group of related files Entity: Person, place, thing, event about which information is maintained Attribute: Description of a particular entity Key field: Identifier field used to retrieve, update, sort a record ORGANIZING DATA IN A TRADITIONAL FILE ENVIRONMENT Managing Data Resources File Organization Terms and Concepts (Continued) ORGANIZING DATA IN A TRADITIONAL FILE ENVIRONMENT The Data Hierarchy Managing Data Resources ORGANIZING DATA IN A TRADITIONAL FILE ENVIRONMENT Entities and Attributes Managing Data Resources Problems with the Traditional File Environment Data Redundancy and Inconsistency: Data redundancy: The presence of duplicate data in multiple data files so that the same data are stored in | Managing Data Resources Lecture 5 Describe basic file organization concepts and the problems of managing data resources in a traditional file environment Describe how a database management system organizes information and compare the principal database models Apply important database design principles Managing Data Resources OBJECTIVES Evaluate new database trends Identify the challenges posed by data resource management and management solutions OBJECTIVES (Continued) Managing Data Resources Challenge: Fragmented and isolated corporate systems creating a single integrated view of customers and operations Solution: single integrated corporate data warehouse, using a single data model. Oracle 9i database provides near real-time access to customer activity, customer profitability, and customer reactions Illustrates the importance of managing data resources for achieving profitability Managing Data Resources Virgin Mobile Australia Case File Organization Terms and Concepts Bit: Smallest .
