V
Data.Warehouse.
Refreshment
Alkis Simitisis
National Technical University of Athens, Greece
Panos Vassiliadis
University of Ioannina, Greece
Spiros Skiadopoulos
University of Peloponnese, Greece
Timos Sellis
National Technical University of Athens, Greece
Abstract
In the early stages of a data warehouse project, the designers/administrators have
to come up with a decision concerning the design and deployment of the backstage
architecture. The possible options are (a) the usage of a commercial ETL tool or
(b) the development of an in-house ETL prototype. Both cases have advantages and
disadvantages. However, in both cases the design and modeling of the ETL work-
flows have the same characteristics. The scope of this chapter is to indicate the main
challenges, issues, and problems concerning the manufacturing of ETL workflows,
in order to assist the designers/administrators to decide which solution suits their
data warehouse project better and to help them construct an efficient, robust, and
evolvable ETL workflow that implements the refreshment of their warehouse.
2 Simitsis, Vassiliadis, Skiadopoulos, & Sellis
Copyright ?© 2007, Idea Group Inc. Copying or distributing in print or electronic forms without written permission of
Idea Group Inc. is prohibited.
Introduction
In the past, research has treated data warehouses as collections of materialized
views.
Pages:
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230