Information Resources Management.ppt

Information Resources Management January 16, 2001 Agenda Administrivia Course Overview Database Management Systems (DBMSs) Homework #1 Administrivia Syllabus Book Homework Web Page Course Calendar Eleven Homeworks Approximately one per week Exams Midterm 1 - 2/20 Midterm 2 - 3/20 Final - TBA Quizzes Up to five Overview – Perspective Database Design and Implementation “Business” Perspective IT professional in an organization Database Design Relational Model Database Modeling Evaluation Tools Normalization Database Implementation SQL (Structured Query Language) Dependability, Reliability Architecture Distributed Databases Database Management Systems Traditional File Processing Systems Database Comparison Database Lifecycles Database Management System Functions Traditional File Processing System Separate Files Department Business Function Independent of Each Other High Level of Program Dependence Program contains file structure and location Example Data Abstraction (Views) Physical/Internal Logical/Conceptual View/External How data is stored What is stored What is used (subset) Three Views of Data What is Needed Physical Independence Logical Independence Physical Independence Physical layout and organization of data can be changed without changing either the overall logical structure of the data or the application programs Examples Move data location Move data to faster storage Change indexing Add a secondary key Physical Independence Logical Independence Non-loss changes to the logical structure can be made without changing application programs or end-user views Examples Change format of a field (zip from 5 to 9) Add a new data field Add a new table Divide a table into two Logical Independence Database organized collection of logically related data shared collection of interrelated data designed to meet the informational needs of multiple users data is independent of program and user views data is stored with physical and logical independence Database Management