CH 6 - Terms Definitions OLAP is a tool for enabling Users...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Terms Definitions OLAP is a tool for enabling 1) Users to obtain online answers to ad-hoc questions in a rapid amount of time. 2) Users to view both logical and physical views of data 3) programmers to quickly diagram data relationships. 4) programmers to normalize data Users to obtain online answers to ad-hoc questions in a rapid amount of time. The most prominent data manipulation language today is - Access - DB2 - SQL - Crystal Reports SQL Many applications today require databases that can store and retrieve multimedia. - True - False True __________ tools are used to analyze large unstructured data sets, such as e-mail, memos, survey responses, etc., to discover patterns and relationships. - OLAP - Text Mining - Web mining - Web content mining Text mining Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource - True - False True Common Gateway Interface is a specification for processing data on a Web server - True - False True Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are know as - DSS - Business intelligence - OLAP - data mining Business intelligence A DBMS separates the logical and physical views of the data True
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
- True - False Which common database challenge is illustrated by the text's discussion of receiving multiple pieces of the same direct mail advertising - data normalization - data accuracy - data redundancy - data inconsistency data inconsistency DSMSs typically report-generating tools in order to - retrieve and display data - display data in an easier-to-read format - display data in graphs - perform predictive analysis display data in an easier to read format Data mining is a tool for allowing users to - quickly compare transaction data gathered over many years - find hidden relationships in data - obtain online answers to ad hoc questions in a rapid amount of time summarize massive amounts of data into much smaller, traditional reports find hidden relationships in data A DBMS reduces data redundancy and inconsistency by - enforcing referential integrity - uncoupling program and data - utilizing a data dictionary - minimizing isolated files with repeated data minimizing isolated files with repeated data The select operation - combines relational tables to provide the user with
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

CH 6 - Terms Definitions OLAP is a tool for enabling Users...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online