1 / 39

Lead Black Slide

Lead Black Slide. Chapter 7. Information System Data Management. Our Agenda. File Processing Database Processing Database Organization Common Database Software Using Database Software Database Use in Information Systems. Our Agenda (cont’d.). Data Warehouses Multidimensional Databases

janice
Download Presentation

Lead Black Slide

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. Lead Black Slide Powered by DeSiaMore

  2. Chapter 7 Information System Data Management Powered by DeSiaMore

  3. Our Agenda • File Processing • Database Processing • Database Organization • Common Database Software • Using Database Software • Database Use in Information Systems Powered by DeSiaMore

  4. Our Agenda (cont’d.) • Data Warehouses • Multidimensional Databases • Database Administration Powered by DeSiaMore

  5. Learning Objectives • List advantages and disadvantages of file processing. • Explain what a database is and what a database management system does. • List advantages and disadvantages of database processing. • Identify the main types of relationships in database processing. Powered by DeSiaMore

  6. Learning Objectives (cont’d.) • Explain the organization of relational databases. • Describe the differences between database software for personal computers, multiple-user computers and networked computers. • Describe several ways of using database software. Powered by DeSiaMore

  7. Learning Objectives (cont’d.) • Describe the use of databases in different types of information systems. • Explain what a data warehouse is and what is meant by data mining. • Describe multidimensional databases and explain on-line analytical processing. Powered by DeSiaMore

  8. File Processing Information System Data Management Powered by DeSiaMore

  9. File Processing • Files consist of related records. • Records consist of related fields. • Fields consist of related characters. • Files must contain a key field – a field where each record’s occurrence is unique. Powered by DeSiaMore

  10. File Organization • A file can be organized in secondary storage as a: • Sequential file – records are organized one after the other and each record must be scanned to until the desired record is located. • Direct or Random file – records are not necessarily stored in sequence and can be accessed directly. Powered by DeSiaMore

  11. File Organization (cont’d.) • A file can be organized in secondary storage as a: • Indexed file – records are stored in one file and the organization of those records is stored in a second file. To use an indexed file both files, the data file and the index file, must be used together. Powered by DeSiaMore

  12. File Management • Managing data files requires that the data be kept up to date. To do so requires: • Modifying, or updating, records involves • Adding records • Deleting records • Changing records • Data Validation – ensuring the data is accurate and secure. Powered by DeSiaMore

  13. Advantages and Disadvantages of File Processing • Advantages • Simple to use. • Disadvantages • Processing data in more than one related file. • Difficult to access data from more than one file at a time. • Dependency between programs and data. Powered by DeSiaMore

  14. Database Processing Information System Data Management Powered by DeSiaMore

  15. Database Processing • To overcome some of the disadvantages of file processing, database processing is used instead. • The database software is called a DataBase Management System (DBMS). • A database is a collection of data and relationships between data stored in secondary storage. Powered by DeSiaMore

  16. Advantages and Disadvantages of Database Processing • Advantages • Duplication of data is reduced. • Easier to process different groups of data. • Not dependent on the organization of data in the database. • Disadvantages • Expensive. • More vulnerable than file processing. • Can be complex to develop. Powered by DeSiaMore

  17. Database Organization Information System Data Management Powered by DeSiaMore

  18. Data Relationships • One-to-one relationship • One group of data is related on only one other group of data. • One-to-many relationship • One group of data is related to one or more other groups of data. • Many-to-many relationship • One or more groups of data is related to one or more other groups of data. Powered by DeSiaMore

  19. Types of Databases • Hierarchical database • Network database • Relational database • Object-oriented database • Object-relational database Powered by DeSiaMore

  20. Common Database Software Information System Data Management Powered by DeSiaMore

  21. Personal Computer dBASE Access FoxPro Approach Fourth Dimension Oracle Networked Systems Oracle Sybase SQL Server Informix GemStone ObjectStore Versant ODBMS Common Database Software Powered by DeSiaMore

  22. Using Database Software Information System Data Management Powered by DeSiaMore

  23. Using Database Software • Query languages – allows a user to query a database. • SQL is a widely used query language. • Query-By-Example (QBE) – is a graphical approach to query languages. • A host language is a programming language for writing application programs containing commands from a query language. Powered by DeSiaMore

  24. Database Use in Information Systems Information System Data Management Powered by DeSiaMore

  25. Types of Databases • Personal databases are generally used by only one person. • Shared databases are used by many users at one time. • To prevent users from processing data they do not need, the database is divided into views. Powered by DeSiaMore

  26. Data Warehouses Information System Data Management Powered by DeSiaMore

  27. Data Warehouses • A data warehouse is a collection of data drawn from other databases used by the business. • A data mart represents the specific data from a data warehouse which a user needs. • Data mining is the technique of searching for patterns in the data. Powered by DeSiaMore

  28. Multidimensional Databases Information System Data Management Powered by DeSiaMore

  29. Multidimensional Databases • A multidimensional database presents the data to the user in several dimensions. A three dimensional database might present the information by • Sales Region • Season • Product Line Powered by DeSiaMore

  30. On-Line Analytical Processing • On-Line Analytical Processing (OLAP) permits users to “slice and dice” large amounts of data in databases, data warehouses, and multidimensional databases using a variety of techniques, including statistical techniques. Powered by DeSiaMore

  31. Database Administration Information System Data Management Powered by DeSiaMore

  32. Database Administration • An organization with large databases often has a Database Administrator (DBA) who is responsible for managing the organization’s database. • The DBA designs the databases based on the needs of the users. Powered by DeSiaMore

  33. Information Systems Data Management Key Terms Powered by DeSiaMore

  34. Application Generator Database Database Administrator (DBA) Database Management System (DBMS) Data Mart Data Mining Data Warehouse Data Validation Direct (Random) File Distributed Database Hierarchical Database Host Language Indexed File Key Field Many-to-Many Relationship Key Terms Powered by DeSiaMore

  35. Multidimensional Database Network Database Object-Oriented Database Object-Relational Database One-to-Many Relationship One-to-One Relationship On-line Analytical Processing (OLAP) Personal Database Primary Key Query-by-Example (QBE) Query Language Key Terms (cont’d.) Powered by DeSiaMore

  36. Relational Database Relationship Sequential File Shared Database SQL View Key Terms (cont’d.) Powered by DeSiaMore

  37. Summary • File Processing • Database Processing • Database Organization • Common Database Software • Using Database Software • Database Use in Information Systems Powered by DeSiaMore

  38. Summary (cont’d.) • Data Warehouses • Multidimensional Databases • Database Administration Powered by DeSiaMore

  39. Final Black Slide Powered by DeSiaMore

More Related