CS614 Final Term Subjective with References

 MUHAMMAD FAISAL  · MIT 4th Semester · Al-Barq Campus (VGJW01) Gujranwala · Reference Short Questions for Final TERM EXAMS · CS614 – Data Warehousing · Data Quality Management Process: (Page#180)

1. Establish Data Quality Management Environment
2. Scope Data Quality Projects & Develop Implementation Plan
3. Implement Data Quality Projects (Define, Measure, Analyze, Improve)
4. Evaluate Data Quality Management Methods

How to improve Data Quality? (Page#183)

The four categories of Data Quality Improvement

1. Process
2. System
3. Policy & Procedure
4. Data Design

Quality Management Maturity Grid: (Page#184)

There are five stages and these are:

Stage 1: Uncertainty Stage 2: Awakening Stage 3: Enlightenment Stage 4: Wisdom Stage 5: Certainty

Parallelize: (Page#188)

Parallel execution improves processing for:

•  Large table scans and joins
•  Creation of large indexes
•  Partitioned index scans
•  Bulk inserts, updates, and deletes
•  Aggregations and copying

Speed -Up & Amdahl’s Law: (Page#192)

Reveals maximum expected speedup from parallel algorithms given the proportion of task that must be computed sequentially. It gives the speedup S as

Parallelization OLTP Vs. DSS (Page#193)

There is a big difference.

DSS:

•  Parallelization of a SINGLE query

OLTP:

•  Parallelization of MULTIPLE queries
•  Or Batch updates in parallel

Parallel Processing · (Page#194) · Parallel Hardware Architectures:

Parallel Hardware Architectures consists of:

 Symmetric Multi-Processing (SMP)  Distributed Memory or Massively Parallel Processing (MPP)  Non-uniform Memory Access (NUMA)

Parallel Software Architectures:

Parallel Software Architectures consists of:

 Shared Memory  Shard Disk  Shared Nothing