• Keine Ergebnisse gefunden

Exercises for DW & DM Sheet 2 (until 12.11.2010)

N/A
N/A
Protected

Academic year: 2021

Aktie "Exercises for DW & DM Sheet 2 (until 12.11.2010)"

Copied!
1
0
0

Wird geladen.... (Jetzt Volltext ansehen)

Volltext

(1)

Exercises for DW & DM

Technische Universität Braunschweig Institut für Informationssysteme http://www.ifis.cs.tu-bs.de Wolf-Tilo Balke, Silviu Homoceanu

Exercises for DW & DM Sheet 2 (until 12.11.2010)

Please send your solutions to silviu@ifis.cs.tu-bs.de until Friday, after the next lecture (date is also mentioned above). You may answer in either German or English. You are encour- aged to work in teams of 2 students (not more than 2), and send your solution as a team. Please mention in your email the name of both students together with the corres- ponding inmatriculation numbers.

Exercise 1 (6P)

1. Briefly present the basic architecture of DWs. (3P)

2. What is a MDB? (2P)

3. When are MDBs in-appropriate? (1P)

Exercise 2 (5P)

1. What is a thin client? (1P)

2. What is the “Generic Three-Tier Architecture” (3P) 3. What are “technologically distributed” DW? (1P)

Exercise 3 (4P)

1. Imagine a conceptual model, and represent it in mE/R for the Lufthansa sales de- partment, knowing that the department wants to be able to investigate ticket sales.

Please explain the dimensions and the granularities you have chosen. (4P)

Referenzen

ÄHNLICHE DOKUMENTE

cost algorithm and as heuristics, the least enlargement cri- Tree according to the obtained graphical representation of the Graphically represent (as in the lecture) the

Consider a star schema with a fact table for sales, and 3 dimensions, the Geo, Time and Product dimension.. (Express all the intermediate results in MB, GB, or TB

Technische Universität Braunschweig Institut für Informationssysteme http://www.ifis.cs.tu-bs.de Wolf-Tilo Balke, Silviu Homoceanu.. Exercises for DW & DM Sheet 8

a. Build a decision tree based on the training set data, using the algorithm pro- vided in the lecture, considering all attributes as possible classification attrib- utes, and

Technische Universität Braunschweig Institut für Informationssysteme http://www.ifis.cs.tu-bs.de Wolf-Tilo Balke, Silviu Homoceanu!. Exercises for DW & DM Sheet 1

Technische Universität Braunschweig Institut für Informationssysteme http://www.ifis.cs.tu-bs.de Wolf-Tilo Balke, Silviu Homoceanu!. Exercises for DW & DM Sheet 2

The Exchange Rates cube can be de- fined as follows: Exchange Rates((Day, Bank, Country),(Buy$_Opening, Buy$_Closing, Buy$_Average, Sell$_Opening, Sell$_Closing,

Technische Universität Braunschweig Institut für Informationssysteme http://www.ifis.cs.tu-bs.de Wolf-Tilo Balke, Silviu Homoceanu!. Exercises for DW & DM Sheet 4