1 / 12

Finding Information

Finding Information. A337/A523. What are some of the possible problems with finding information?. What are some of the possible problems with finding information?. Information is often lacks STRUCTURE

natara
Download Presentation

Finding 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. Finding Information A337/A523

  2. What are some of the possible problems with finding information?

  3. What are some of the possible problems with finding information? • Information is often lacks STRUCTURE • ASSOCIATION between the identifying information (i.e., labels and the actual information is not always obvious) and the data • CONSISTENCY is not always present. E.g., • 317-274-0185 • (317)274-0185 • 3172740185 • May later need to MANIPULATE data (filter, sorting, etc.)

  4. Typical “Office” Applications • Word Processing • Spreadsheet • Database Management System (DBMS)

  5. Spreadsheets and DBMSes • Information often lacks STRUCTURE • ASSOCIATION between the identifying information (i.e., labels and the actual information) is not always obvious • CONSISTENCY is not always present. E.g., • 317-274-0185 • (317)274-0185 • 3172740185 • May later need to MANIPULATE data (deeper search, sorting, etc.) • Columns (labels) • Rows (“instance” or record) • Intersection (value)

  6. Spreadsheets • Information often lacks STRUCTURE • ASSOCIATION between the identifying information (i.e., labels and the actual information) is not always obvious • CONSISTENCY is not always present. E.g., • 317-274-0185 • (317)274-0185 • 3172740185 • May later need to MANIPULATE data (deeper search, sorting, etc.) Tables in MS Excel

  7. DBMSes • Information often lacks STRUCTURE • ASSOCIATION between the identifying information (i.e., labels and the actual information) is not always obvious • CONSISTENCY is not always present. E.g., • 317-274-0185 • (317)274-0185 • 3172740185 • May later need to MANIPULATE data (deeper search, sorting, etc.) Tables in MS Access • Table is one of many objects in a database • Easier to associate tables than in a spreadsheet (i.e., vlookup) • Tables have several unique properties we’ll discuss later

  8. ERP Systems • Information often lacks STRUCTURE • ASSOCIATION between the identifying information (i.e., labels and the actual information) is not always obvious • CONSISTENCY is not always present. E.g., • 317-274-0185 • (317)274-0185 • 3172740185 • May later need to MANIPULATE data (deeper search, sorting, etc.) Centralized database eliminates the need to associated data located on separate systems

  9. Data Quality: What is Dirty Data? • It happens when the UPC code on a package doesn't match the item. • Causes? Vendor-Unique product code and cost Retailer-Unique product code and price

  10. Data Quality: What is Dirty Data? Potential Problems? • Inventory Reorder • Profit per unit  Net profit • Customer Satisfaction • Repeat Business • Angry Bloggers Solution: Same code for vendor and retailer Data Integrity: Wal-Mart's Dirty Secret

  11. Extract, Transform, Load (ETL) From Computerworld QuickStudy

More Related