1 / 46

Organizing Data and Information

Organizing Data and Information. Chapter 5. Chapter 5 Outline. Data Management Traditional vs. Database Approach to Data Management Data Modeling and Database Models Database Management Systems (DBMS) Database Applications. Data Management. The Hierarchy of Data.

johnnyw
Download Presentation

Organizing Data and Information

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Organizing Data and Information Chapter 5 Principles of Information Systems, Sixth Edition

  2. Chapter 5 Outline • Data Management • Traditional vs. Database Approach to Data Management • Data Modeling and Database Models • Database Management Systems (DBMS) • Database Applications Principles of Information Systems, Sixth Edition

  3. Data Management Principles of Information Systems, Sixth Edition

  4. The Hierarchy of Data Principles of Information Systems, Sixth Edition

  5. Data Entities, Attributes, and Keys Principles of Information Systems, Sixth Edition

  6. The Traditional Approach Principles of Information Systems, Sixth Edition

  7. Traditional Approach • Data redundancy • Program-data dependence • Data integrity Principles of Information Systems, Sixth Edition

  8. Database Approach Principles of Information Systems, Sixth Edition

  9. Advantages of the Database Approach Principles of Information Systems, Sixth Edition

  10. Advantages of the Database Approach Principles of Information Systems, Sixth Edition

  11. Disadvantages of the Database Approach Principles of Information Systems, Sixth Edition

  12. Data Modeling & Database Models Principles of Information Systems, Sixth Edition

  13. Data Modeling and Database Models • Content - What data should be collected? • Access - What data should be given to what users? • Logical structure - How will the data be organized to make sense to a particular user? • Physical organization - Where will the data actually be located? Principles of Information Systems, Sixth Edition

  14. Data Modeling • Enterprise data modeling • Planned data redundancy • Data model • Entity-relationship diagrams Principles of Information Systems, Sixth Edition

  15. Entity-Relationship (ER) Diagrams Principles of Information Systems, Sixth Edition

  16. Data Models • Hierarchical models • Network models • Relational models Principles of Information Systems, Sixth Edition

  17. Hierarchical (Tree) Models Principles of Information Systems, Sixth Edition

  18. Network Models Principles of Information Systems, Sixth Edition

  19. Relational Models Principles of Information Systems, Sixth Edition

  20. Relational Models Principles of Information Systems, Sixth Edition

  21. Data Cleanup Principles of Information Systems, Sixth Edition

  22. Database Management Systems Principles of Information Systems, Sixth Edition

  23. Creating and Modifying the Database Principles of Information Systems, Sixth Edition

  24. Data Definition Language Principles of Information Systems, Sixth Edition

  25. Creating and Modifying the Database Principles of Information Systems, Sixth Edition

  26. Data Dictionary Benefits • Reduced data redundancy • Faster program development • Easier data & information modification • Increased data reliability Principles of Information Systems, Sixth Edition

  27. Storing and Retrieving Data Principles of Information Systems, Sixth Edition

  28. Structured Query Language Principles of Information Systems, Sixth Edition

  29. Database Output Principles of Information Systems, Sixth Edition

  30. Provide a user view Create and modify the database Store and retrieve data Manipulate data Produce reports Database Management Systems (DBMSs) Principles of Information Systems, Sixth Edition

  31. Popular Database Management Systems Principles of Information Systems, Sixth Edition

  32. Selecting a DBMS • Database size • Number of concurrent users • Performance • Integration • Features • Vendor • Cost Principles of Information Systems, Sixth Edition

  33. Database Applications Principles of Information Systems, Sixth Edition

  34. Data Warehouses Principles of Information Systems, Sixth Edition

  35. Comparison of OLTP and Data Warehousing Principles of Information Systems, Sixth Edition

  36. Database Developments • Data warehouses • Data marts • Data mining Principles of Information Systems, Sixth Edition

  37. Data Mining Principles of Information Systems, Sixth Edition

  38. Distributed Databases Principles of Information Systems, Sixth Edition

  39. On-Line Analytical Processing Principles of Information Systems, Sixth Edition

  40. Open Database Connectivity (ODBC) Principles of Information Systems, Sixth Edition

  41. Object-Relational Database Management Systems • Stores objects • Hypermedia • Spatial data technology Principles of Information Systems, Sixth Edition

  42. Summary • Data - one of the most valuable resources a firm possesses • Entity - a generalized class of objects for which data is collected, stored, and maintained • DBMS - a group of programs used as an interface between a database and application programs • Traditional on-line transaction processing (OLTP) - do not support the types of data analysis needed today Principles of Information Systems, Sixth Edition

  43. Principles and Learning Objectives • The database approach to data management provides significant advantages over the traditional file-based approach. • Define general data management concepts and terms, highlighting the advantages and disadvantages of the database approach to data management. • Name three database models and outline their basic features, advantages, and disadvantages. Principles of Information Systems, Sixth Edition

  44. Principles and Learning Objectives • A well-designed and well-managed database is an extremely valuable tool in supporting decision making. • Identify the common functions performed by all database management systems and identify three popular end-user database management systems. Principles of Information Systems, Sixth Edition

  45. Principles and Learning Objectives • The number and types of database applications will continue to evolve and yield real business benefits • Identify and briefly discuss current database applications. Principles of Information Systems, Sixth Edition

  46. End of Chapter 5 Principles of Information Systems, Sixth Edition

More Related