Home > Preview

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

  1. transactional info vs analytical info
  2. packingslip, sales receipt and/or airline ticket
    • vs
    • product statistics, sales projections, future growth, and/or trends
  3. transactional information
  4. encompasses all the info contained within a single bus process or unit of workprimary
    purpose to support performing of daily operational tasks
  5. scalability
    refers to how well a system can adapt to increased demands
  6. relational integrity constraint
    rules that enforce basic and fundamental information-based constraints
  7. relational database advantages
  8. Increased flexibility
    • Increased scalability and performance
    • Reduced information redundancy
    • Increased information integrity (quality)
    • Increased information security
  9. relational database model
    stores information in the form of logically related two-dimensional tables
  10. redundancy
    duplication of info or storing the same info in multiple places
  11. real-time system
    provides real-time information in response to query requests
  12. real-time information
    immediate, up-to-date information
  13. primary key
    a field that uniquely identifies a given entity in a table
  14. physical view
    physical storage of info on a storage device such as a hard disk
  15. performance
    measures how quickly a system performs a certain process or transaction
  16. network database model
    a flexible way of representing objects and their relationships
  17. logical view
    focuses on how users logically access info to meet their particular bus needs
  18. integrity constraint
    rules that help ensure the quality of info
  19. integration
    allows seperate systems to communicate directly with ea other
  20. information integrity
    measure of quality of info
  21. information granularity
    refers to extent of detail within the info
  22. information cleansing or scrubbing
    process that weeds out and fixes or discards inconsistent, incorrect or incomplete info
  23. hierarchical database model
    information is organized into a tree-like structure (using parent/child relationships) in such a way that it cannot have too many relationships
  24. forward integration
    takes info entered into a given system and sends it automatically to all downstream systems and processes
  25. foreign key
    primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables
  26. extraction transformation and loading
    a process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse
  27. entity
  28. a person, place, thing, transaction, or event about which information is stored
    • –The rows in each table contain the entities
    • –In Figure 7.1 CUSTOMER includes Dave’s Sub Shop and Pizza Palace entities
  29. data warehouse
  30. •a logical collection of information – gathered from many different operational databases – that supports business analysis activities and decision-making tasks
    •primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository for decision-making purposes
  31. data-mining tools
    uses a variety of techniques to find patterns and relationships in large volumes of information and infers rules that predict future behavior and guide decision making
  32. data mining
    the process of analyzing data to extract information not offered by the raw data alone
  33. data mart
    contains a subset of data warehouse information
  34. data-driven website
    interactive website kept constantly updated and relevent to the needs of its customers through the use of a database
  35. database management system
    software through which users and application programs interact with a database
  36. database
    maintains info about various types of obj (inventory), events (transactions), people (employees), and places (warehouses).
  37. cube
    common term for representation of multidimensional info
  38. business-critical integrity constraint
    enforces bus rules vital to an org success and often requires more insight and knowledge than relational integrity constraints
  39. business intelligence
    refers to applications and technologies that are used to gather, provide access to and analyze data and info to support decision-making efforts
  40. backward integration
    takes info entered into a given system and sends it automatically to all upstream systems and processes
  41. attribute
  42. •characteristics or properties of an entity class
    • –The columns in each table contain the attributes
    • –In Figure 7.1 attributes for CUSTOMER include Customer ID, Customer Name, Contact Name
  43. analytical information
    encompasses all organizational info primary purpose to support the performing of managerial analysis tasks

Card Set Information

2012-02-15 21:42:23

midterm ch 6-8
Show Answers:

What would you like to do?

Home > Flashcards > Print Preview