1 / 40

Technology in Action

Technology in Action. Technology in Action. Chapter 11 Behind the Scenes: Databases and Information Systems. Chapter Topics. Databases and their uses Database components Types of databases Database management systems Relational databases Data warehouses and data marts

trudy
Download Presentation

Technology in Action

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. Technology in Action

  2. Technology in Action Chapter 11 Behind the Scenes: Databases and Information Systems

  3. Chapter Topics • Databases and their uses • Database components • Types of databases • Database management systems • Relational databases • Data warehouses and data marts • Information systems • Data mining

  4. Databases • Electronic collections of related data • Help us organize data • Turn data into information

  5. Recording grades Financial Aid Student Registration Student Information Database Student housing Parents Advantages of Using Databases • Store and retrieve large quantities of information • Enable information sharing • Provide data centralization • Promote data integrity • Allow for flexible use of data

  6. Database Terminology Field Name • Field • Category of information displayed in columns • Each field has a field name

  7. Database Terminology • Data types • Text • Numeric • Computational • Date • Memo • Object • Hyperlink

  8. Database Terminology • Record • A group of related fields Record

  9. Database Terminology • Table • A group of related records Table

  10. Database Terminology • Primary key • A field value unique to a record Primary Key

  11. Database Types • Relational databases • Organize data in a table • Link tables to each other through their primary keys • Object-oriented databases • Stores data in objects • Handles unstructured data • Object-relational databases • A hybrid of a relational and object-oriented database

  12. Database Management Systems (DBMS) • Application software designed to capture and analyze data • Four main operations of a DBMS are: • Creating databases and entering data • Viewing and sorting data • Extracting data • Outputting data

  13. 1. Creating Databases and Entering Data • Create field names: • Identify each type of data • Data dictionary

  14. 12345 Jason Alexander 123 Elm St. Anywhere US Creating Databases and Entering Data (cont) • Create individual records: • Key-in • Import

  15. Data Validation • Validation • Process of ensuring data entered into the database is correct (or at least reasonable) and complete • Validation rules • Range check • Completeness check • Consistency check • Alphabetic/numeric checks

  16. 2. Viewing and Sorting Data • Browse through records • Sort records by field name Before sort After sort

  17. Results 3. Extracting or Querying Data • Query • A question or inquiry • Provides records based on criteria • Structured query language (SQL) SQL

  18. 4. Outputting Data • Reports: • Printed • Summary data reports • Export data

  19. Relational Database Operations • Relational databases organize data into tables based on logical groupings • Relationships are links between tables with related data • Common fields between tables need to exist • Normalization of data (recording data once) reduces data redundancy

  20. Data Storage • Data warehouses • A large scale repository of data • Organizes all the data related to an organization • Data is organized by subject

  21. Source data Internal sources Company databases, etc. External sources Suppliers, vendors, etc. Customers or Web site visitors Clickstream data Populating Data Warehouses

  22. Data staging Extract data from source Reformat the data Store the data Software programs/procedures created to extract the data and to reformat it for storage Data Staging

  23. Small slices of data Data of a single department Data Marts

  24. Data Warehouse

  25. Managing Data: Information Systems • Information systems • Software-based solutions used to gather and analyze information • Functions performed by information systems include • Acquiring data • Processing data into information • Storing data • Providing output options

  26. Information Systems Categories • Office support • Transaction processing • Management • Decision support

  27. Office Support Systems (OSS) • Assist employees in day-to-day tasks • Improve communications • Microsoft Office

  28. Transaction Processing Systems (TPS) • Keeps track of everyday business activities • Batch processing • Real-time processing

  29. Provides timely and accurate information for managers to make business decisions Detail report: Transactions that occur during a period of time Summary report: Consolidate detailed data Exception report: Show unusual conditions Management Information Systems (MIS)

  30. Decision Support Systems (DSS) • Help managers develop solutions for specific problems

  31. Data Mining • Process by which data are analyzed and investigated • Objective is to spot patterns or trends within the data

  32. Data Mining Methods • Classification • Define data classes • Estimation • Assign a value to data • Affinity grouping or association rules • Determine which data goes together • Clustering • Organize data into subgroups • Description and visualization • Provides a clear picture of what is happening

  33. Chapter 11 Summary Questions • What is a database and why is it beneficial to use databases?

  34. Chapter 11 Summary Questions • What components make up a database?

  35. Chapter 11 Summary Questions • What types of databases are there?

  36. Chapter 11 Summary Questions • What do database management systems do?

  37. Chapter 11 Summary Questions • How do relational databases organize and manipulate data?

  38. Chapter 11 Summary Questions • What are data warehouses and data marts and how are they used?

  39. Chapter 11 Summary Questions • What is an information system and what types of information systems are used in business?

  40. Chapter 11 Summary Questions • What is data mining and how does it work?

More Related