Chapter 4: Databases And Information Management

Question 1

Data Warehouse

Answer 1

A database that stores current and historical data of potential interest to decision makers throughout the company

Question 2

Data Mart

Answer 2

A subset of a data warehouse in which a summarized or highly focused portion of the organization’s data is placed in a separate database for a specific population of users

Question 3

Online Analytical Processing (OLAP)

Answer 3

Supports the multidimensional data analysis, enabling users to view the same data different ways using multiple dimensions

Question 4

Data Mining

Answer 4

Provides insights into corporate data that cannot be obtained with OLAP by finding hidden patterns and relationships in large databases and inferring rules from them to predict future behavior

Question 5

Types of Information Obtainable from Data Mining

Answer 5

1. Associations: occurrences linked to a single event
2. Sequences: events linked over time
3. Classification: recognizes patterns that describe the group to which a item belongs by examining existing items that have been classified and by inferring a set of rules
4. Clustering: similar to classification when no groups have yet been defined

Question 6

Predictive Analytics

Answer 6

Uses data mining techniques, historical data, and assumptions about future conditions to predicts outcomes of events, such as the probability a customer will respond to an offer or purchase a specific product

Question 7

Text Mining

Answer 7

These tools are able to extract key elements from large unstructured data sets, discover patterns and relationships, and summarize the information

Question 8

Web Mining

Answer 8

The discovery and analysis of useful patterns and information from the World Wide Web i.e. Google Trends and Google Insights

Question 9

Database Server

Answer 9

In a client/server environment, the DBMS resides on a dedicated computer called a database server. The DBMS receives the SQL requests and provides the required data

Question 10

Information Policy

Answer 10

Specifies the organization’s rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information

Question 11

Data Administration

Answer 11

Responsible of rather specific policies and producers through which data can be managed as an organizational resource

Question 12

Data Governance

Answer 12

Promoted by IMB, deals with the policies and processes for managing the availability, usability, integrity, and security of the data employed in an enterprise, with special emphasis on promoting privacy, security, data quality, and compliance with government regulations

Question 13

Database Administration

Answer 13

Division that is responsible for defining and organizing the structure and content of the database, and maintaining the database. In close cooperation with users, the design group establishes the physical database, the logical relations among elements, and the access rules and security procedures

Question 14

Data Quality Audit

Answer 14

A structured survey of the accuracy and level of completeness of the data in an information systems

Question 15

Data Cleansing

Answer 15

Also known as data scrubbing, consists of activities for detecting and correcting data in a database that are incorrect, incomplete, improperly formatted, or redundant