Lec 7

Question 1

Transaction Processing System that records__

ex. Customer Order, Purchase Order, Employee time

Answer 1

data on fundamental operations occurring within the company

Question 2

2. Types of Transaction Processing System

Answer 2

1. Batch Processing (money transfer)

2. Online Transaction Processing (airplane ticket)

Question 3

3 types of Enterprise systems - consolidate data collected

Answer 3

1. • Enterprise Resource Planning System (Core functions)
   Accounting HR
2. • Customer Relationship Management System
   Sales Marketing
3. • Supply Chain Management System
   Value Chain

Question 4

3 Data warehouses functions

Answer 4

Collect and Store Data
Consolidate and Standardize
Provide Tools for Querying, Analysis and Reporting

Question 5

Data marts

Answer 5

are subsets of the data stored in a data warehouse (highly focused)

Question 6

Business Intelligence

Answer 6

tools for consolidating, analyzing, and accessing

data to support organizational decision-making

Question 7

Online Analytical Processing results in

Answer 7

Data Cubes

Question 8

Data Mining

Answer 8

Identifying hidden patterns without pre-existing model in mind

Question 9

3 Basic types of patters uncovered by data mining

Answer 9

• Associations (buying x with y)
• Clusters (close proximity)
• Sequential Relationships (x before y)

Question 10

2 Association types

Answer 10

1. Support (% of x in total)

2. Confidence (% of x, given y)

Question 11

Big Data 4 V’s

Answer 11

1. Volume
2. Variety
3. Velocity
4. Veracity - reliability

Question 12

Neural Network

Answer 12

Form of big data, use existing data to predict new. ONLY OUTCOME, not how

Question 13

Neural networks are usually a __ box methods

Answer 13

Black Box Methods

Question 14

4 Advantages of Hadoop

Big data software that provides distributive computing

Answer 14

1. Flexibility (type of data)
2. Scalability (# computers)
3. Cost Effectiveness (open source)
4. Fault Tolerence