IS chap 5

Card Set Information

IS chap 5
2011-10-16 02:10:14

IS chap 5
Show Answers:

  1. characterisitcs of high quality info
    • accurate
    • complete
    • relevant
    • timely
  2. effects from poor quality
    • inability to accurately track customers
    • inable to identify selling opps
    • difficult tracking revenue to inaccurate voices
    • difficult to build strong cuter relationshps
  3. high quality info
    change of making decisions
  4. good decisions
    directly impact organizations bottom line
  5. data hiearchy
    structure and organizatin of data (involves bits, character/bytes, fields, records, files, databases)
  6. bit
    binary digit 0 or 1 data format of computer
  7. Byte
    group of relaed bits,
  8. field
    group of related bytes/characters rep on attitude(characteristic) about entity(subject)
  9. record
    group of related fields
  10. fiel
    • group of related records
    • ex:benefits file, enlarge payroll file
  11. database
    collection of related files containing records on people
  12. entity
    generalized category rep prson ,place, thing, ehich we store info
  13. attributes
    specific characteristics of each entity
  14. relational database
    organize data into two-dimensional tables with columns/rows
  15. primary key-uniquely identify a given record in the table
    foreign key-"lookup field" field in database allows users to find related info
  16. establishing relationships
    entity-relationship diagram
    • RD
    • to one
    • to many
    • 3. many to many
  17. Normalization
    process streamling complex groups
  18. referential integrity row
    used by relational databases to ensure that relationships between couples tables remain consistent
  19. DBMS
    Database Management System
    • specific type of software for creating, storing, orgnazing, accessing data from a database
    • LV- how end uses view data more than one logical view
    • PV-data actually structured and orgnaized one physical view
  20. Operations of Related DBMS
    • Select- creates a subet of all records meeting stated criteria
    • Join-combines relational tables present more info
    • project- subset of consisting of columns into a table
  21. data defintion capabilities
    • stores definition of data elements and their characterisitcs
    • 1.Name of data item, description , size, format, others
  22. querying and reporting
    • data manipulation language-used to add, delete, change, retrieve data from database
    • SQL -structured query language
    • Microsoft access query-building tools
    • QBE- Query by Example-users manipulate a drag to drop GUI
    • Report Generation-users can define report formats
  23. OODBMS
    • traditional programming- seperates the data from the operations or actions act on them
    • object oriended programming and database-together in objects then manipulate the objects to create a program
  24. Tools for analyzing , accessing vast quantites of data
    • data warehousing
    • multidemsional data analysis
    • data mining
    • utilizing web interfaces to db
  25. DW
    • stores 3-10 years of historical data (logical collection of info-gathered from operational database)
    • Data Mart- smaller version of dw
  26. Business Intelligence
    tools for consildating , analyzing , providing access to large amounts of data to improve decision making
  27. Online Analytical/ processing OLAP
    supports multidimensional data analyze , enabling users to view same data in different ways using multiple dimensions
  28. data mining
    • finds hidden patterns and relationships in large db
    • to predict future behavior
    • associations-ocurrencces linked to single events
    • sequences-events linked over time
    • classifications-patterns describing group
    • clusters-discovery as yet unclassified groupings
    • forecasting-users series of values to forecast future values
  29. text mining
    unstructured data allows business to extract key elemtns from discover patterns
  30. Web Mining
    patterns/info from web content, structure , usage mining
  31. Firms use Web
    make info from internal db available to customers /partners
  32. Webs Interfaces
    rebuilding /redesigning legacy systems
  33. data- driven website
    • retrieves data
    • allows users to enter data
    • interface to db
    • improves access to updates to info
  34. Info Policy
    rules for organizing and managing
  35. Data Admin
    Data management as a resource
  36. database admin
    data design to management group responsible organizing content of db
  37. ensuring data quality
    • dq audit-survey accuracy and completeness of data
    • data cleansing- detects/corrects
    • poor dq-major obstacle to successful relationship management
    • dq problems- errors