SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Organizing Data and Information

scout avatar
scout
40 diapositives · 695 Views · Jun 07, 2012

Organizing Data and Information. Chapter 3. Principles and Learning Objectives. The database approach to data management provides significant advantages over the traditional file-based approach.

#data processing #information science #statistics #data warehouse #primary station #formatting #format #input
Organizing Data and Information - slide 1
01 / 40Organizing Data and Information
1 / 17

Télécharger la présentation

Organizing Data and Information
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. Organizing Data and Information Chapter 3 Fundamentals of Information Systems, Second Edition

  2. 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. Fundamentals of Information Systems, Second Edition

  3. 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. Fundamentals of Information Systems, Second Edition

  4. Principles and Learning Objectives • Further improvements in the use of database technology will continue to evolve and yield real business benefits. • Identify and briefly discuss recent database applications. Fundamentals of Information Systems, Second Edition

  5. The Hierarchy of Data Fundamentals of Information Systems, Second Edition

  6. Keys and Attributes Fundamentals of Information Systems, Second Edition

  7. The Traditional Approach To Data Management Fundamentals of Information Systems, Second Edition

  8. The Database Approach to Data Management Fundamentals of Information Systems, Second Edition

  9. Advantages of the Database Approach Fundamentals of Information Systems, Second Edition

  10. Disadvantages of the Database Approach Fundamentals of Information Systems, Second Edition

  11. Data Modeling • Planned data redundancy • Data model • Enterprise data modeling • Entity-relationship diagrams Fundamentals of Information Systems, Second Edition

  12. Entity-Relationship Diagram for a Customer Ordering Database Fundamentals of Information Systems, Second Edition

  13. Database Models • Hierarchical (tree) • Network • Relational Fundamentals of Information Systems, Second Edition

  14. Hierarchical Database Model Fundamentals of Information Systems, Second Edition

  15. Network Database Model Fundamentals of Information Systems, Second Edition

  16. Relational Database Model Fundamentals of Information Systems, Second Edition

  17. Relational Models Describe data using a standard tabular format with all data elements placed in two-dimensional tables, called relations, that are the logical equivalent of files. • Domain • Selecting • Projecting • Joining Fundamentals of Information Systems, Second Edition

  18. Linking Database Tables to Answer an Inquiry Fundamentals of Information Systems, Second Edition

  19. Building and Modifying a Relational Database Fundamentals of Information Systems, Second Edition

  20. Database Management Systems Fundamentals of Information Systems, Second Edition

  21. Providing a User View • Schema - a description of the entire database • Subschema - a file that contains a description of a subset of the database and identifies which users can modify the data items in that subset Fundamentals of Information Systems, Second Edition

  22. The Use of Schemas and Subschemas Fundamentals of Information Systems, Second Edition

  23. Creating and Modifying the Database • Data definition language (DDL) - a collection of instructions and commands used to define and describe data and data relationships in a specific database • Data dictionary – detailed description of data in a database Fundamentals of Information Systems, Second Edition

  24. Typical Uses of a Data Dictionary • Provide a standard definition of terms and data elements • Assist programmers in designing and writing programs • Simplify database modification • Reduce data redundancy • Increase data reliability • Speed program development • Ease modification of data and information Fundamentals of Information Systems, Second Edition

  25. Storing and Retrieving Data Fundamentals of Information Systems, Second Edition

  26. Structured Query Language Fundamentals of Information Systems, Second Edition

  27. Database Output Fundamentals of Information Systems, Second Edition

  28. Popular Database Management Systems • Paradox database • FileMaker Pro • Microsoft Access • Lotus 1-2-3 Spreadsheet Fundamentals of Information Systems, Second Edition

  29. Worldwide Database Market Share (2001) Fundamentals of Information Systems, Second Edition

  30. Selecting a Database Management System • Database size • Number of concurrent users • Performance • Integration • Features • Vendor • Cost Fundamentals of Information Systems, Second Edition

  31. Database Applications Fundamentals of Information Systems, Second Edition

  32. Data Warehouses, Data Marts, and Data Mining • Data Warehouse - a database that collects business information from many sources in the enterprise, covering all aspects of the company’s processes, products, and customers. • Data Mart – a subset of a data warehouse. • Data Mining - an information analysis tool that involves the automated discovery of patterns and relationships in a data warehouse. Fundamentals of Information Systems, Second Edition

  33. Elements of a Data Warehouse Fundamentals of Information Systems, Second Edition

  34. Common Data Mining Applications Fundamentals of Information Systems, Second Edition

  35. Business Intelligence Gathering enough of the right information in a timely manner and usable form. • Competitive intelligence • Counterintelligence • Knowledge management Fundamentals of Information Systems, Second Edition

  36. Comparison of OLAP and Data Mining Fundamentals of Information Systems, Second Edition

  37. Advantages of ODBC Fundamentals of Information Systems, Second Edition

  38. Object-Relational Database Management System • Stores the following types of data as objects: • audio • images • unstructured • text • spatial data Fundamentals of Information Systems, Second Edition

  39. Spatial Technology Fundamentals of Information Systems, Second Edition

  40. 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. • Attribute - a characteristic of an entity. • DBMS - a group of programs used as an interface between a database and application programs. • Data mining - the automated discovery of patterns and relationships in a data warehouse. Fundamentals of Information Systems, Second Edition