Data Warehouse And Data Mining Flashcards

1
Q

What is a data warehouse?

A

A decision making system which integrates data from multiple sources, organises and stores it for an organisation’s use.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the key properties of a data warehouse?

A
  1. Integrated: brings together data from different sources.
  2. Non-volatile: data warehouses only store data, not alter; they are not updated constantly.
  3. Subject-oriented: data warehouse revolve around important subjects of an organisation like customers, employees, sales.
  4. Time variance: data warehouses store historic data; they stored data accurately in particular points in time.
  5. Time variance: data is st
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is OLTP?

A

Online Transaction Processing System (Databases)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is OLAP?

A

Online Analysis Processing System (Data warehouses)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Differences between Database (OLTP) and Warehouses (OLAP).

A

OLTP || OLAP
* Collection of interrelated data || Collection of information
* Contains data recently collected|| Contains historic data
* Transaction driven || Analysis driven
* Support day-to-day operations || Support strategic decisions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the main objective of data warehouses?

A

To integrate and store data from multiple sources

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Benefits of data warehouses

A
  1. Keeps historic information
  2. Analyzes data from multiple sources
  3. Offers data backup sources
  4. Has high potential return
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Types of data warehouses

A
  1. Centralised data warehouse
  2. Distributed data warehouse
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is a centralised data warehouse?

A

Data is stored in one place.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is a distributed data warehouse?

A

Data is physically spread across various data warehouses which still communicate with one another.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Types of distributed warehouses.

A
  1. Homogeneous: data warehouses share the same operating system or platform.
  2. Heterogeneous: data warehouses have different operating systems or platforms
How well did you know this?
1
Not at all
2
3
4
5
Perfectly