Data Warehousing Flashcards

1
Q

Data Warehouse

A
  • Support database maintained separately from the operational database
  • Consolidated, historical data for analysis
  • Requires only data loading and data access
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Characteristics of a Data Warehouse

A
  • Subject-oriented
  • Integrated
  • Time-variant
  • Nonvolatile
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Populating a Data Warehouse

A
  • Select data important for analysis
  • Clear incomplete or inconsistent tuples
  • Summarize values as necessary
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

OLAP vs OLTP

A
  • OLAP: on-line analytical processing
  • OLTP: on-line transactional processing
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Applications of Data Warehouses

A
  • Information processing
  • Analytical processing
  • Data mining
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Data Cube

A
  • Multidimensional data model that provides summarizations for all subsets of dimensions
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Cuboids

A
  • Summarizations along different dimensions of the data cube
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Base Cuboid

A
  • The most detailed part of the data cube
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Apex Cuboid

A
  • The highest level of summarization in the data cube
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Star Schema

A
  • Consists of a central fact table connected to a set of dimension tables
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Snowflake Schema

A
  • A refinement of star schema where some dimensional hierarchy is normalized
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Constellation Schema

A
  • A collection of star schemas (multiple fact tables)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Lattice

A
  • A graph showing relationships between cuboids
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

OLAP Slice

A
  • Perform a selection on one dimension
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

OLAP Dice

A
  • Perform a selection on two or more dimensions
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Data Cube Summarization

A
  • Remove a dimension
  • Climb within a concept hierarchy
  • Roll up (summarize)
  • Drill down (generalize)
17
Q

Cuboids vs SQL GROUP BY

A
  • Cuboids are equivalent to the results of GROUP BY operations