The flashcards below were created by user Anonymous on FreezingBlue Flashcards.

  1. Master data management
    • •enables
    • companies like R.R. Donnelley to eliminate outdated, incomplete or incorrectly
    • formatted data.
    • •Demonstrates IT’s role in
    • successful data management.
    • •Illustrates digital
    • technology’s role in storing and organizing data.
  2. Database
    • •Collection of related files containing
    • records on people, places, or things.

    • •Prior to digital databases, business
    • used file cabinets with paper files.
  3. Entity
    • •Generalized category representing
    • person, place, thing on which we store and maintain information

  4. Attributes
    • •Specific characteristics of each
    • entity:

    •SUPPLIER name, address

    • PART
    • description, unit price, supplier
  5. Relational database
    • •Organize data into two-dimensional
    • tables (relations) with columns and rows.
  6. Fields
    (columns) store data representing an attribute.
  7. Rows
    store data for separate records, or tuples
  8. Key field
    uniquely identifies each record
  9. Primary key
    •One field in each table

    •Cannot be duplicated

    • •Provides unique identifier for all
    • information in any row
  10. Entity relationship diagram
    • •Used to clarify table relationships in a relational
    • database
  11. Normalization
    •Process of streamlining complex groups of data to:

    •Minimize redundant data elements.

    •Minimize awkward many-to-many relationships.

    •Increase stability and flexibility.
  12. •Referential integrity
    • •Used by relational databases to ensure
    • that relationships between coupled tables remain consistent.

    • •E.g., when one table has a foreign key that points to another
    • table, you may not add a record to the table with foreign key unless there is a
    • corresponding record in the linked table.
  13. Data definition capabilities
    Specify structure of content of database
  14. Data dictionary
    • •Automated or manual file storing
    • definitions of data elements and their characteristics.
  15. Querying and reporting
    • •Data manipulation
    • language

    •Structured query language (SQL)

    •Microsoft Access query-building tools

    • •Report generation,
    • e.g., Crystal Reports
  16. Data warehouse:
    • •Database that stores current and
    • historical data that may be of interest to decision makers

    • •Consolidates and standardizes data from
    • many systems, operational and transactional databases

    •Data can be accessed but not altered
  17. Data mart:
    • •Subset of data warehouses that is
    • highly focused and isolated for a specific population of users
  18. Business intelligence
    • tools
    • for consolidating, analyzing, and providing access to large amounts of data to
    • improve decision making
  19. Online Analytical Process (OLAP)
    • •Supports multidimensional data
    • analysis, enabling users to view the same data in different ways using multiple
    • dimensions

    • •Enables users to obtain online answers
    • to ad hoc questions such as these in a fairly rapid amount of time
  20. Data Mining
    • •Finds hidden patterns and relationships in large databases
    • and infers rules from them to predict future behavior
  21. Associations
    • occurrences
    • linked to single event
  22. Sequences
    Events linked over time
  23. Classifications
    patterns describing a group an item belongs to
  24. Clusters
    discovering as yet unclassified groupings
  25. Forecasting
    • uses
    • series of values to forecast future values
  26. One popular use of data mining?
    • analyzing
    • patterns in customer data for one-to-one marketing campaigns or for identifying
    • profitable customers
  27. Predictive Analysis
    • •Uses data mining techniques, historical data, and
    • assumptions about future conditions to predict outcomes of events, such as the
    • probability a customer will respond to an offer or purchase a specific product
  28. Text Mining
    • •Unstructured data (mostly text files) accounts for 80
    • percent of an organization’s useful information.

    • •Text mining allows businesses to extract key elements
    • from, discover patterns in, and summarize large unstructured data sets.
  29. Web Mining
    • •Discovery and analysis of useful patterns and
    • information from the Web

    •Content mining, structure mining, usage mining
  30. Information policy
    • •States organization’s rules for
    • organizing, managing, storing, sharing information
  31. Data administration
    • Responsible for specific policies and
    • procedures through which data can be managed as a resource
  32. Poor data quality
    major obstacle to successful customer relationship management
  33. Data quality problems
    • Redudant and inconsistent data produced by multiple systems
    • Data input errors
  34. Data quality audit
    structured survey of the accuracy and completeness of data
  35. Data cleansing
    detects and corrects incorrect imcomplete, improperely formatted and redundant data
Card Set:
2011-09-27 00:56:54

my cards for class
Show Answers: