This construction phase includes the development, testing,
and deployment of a first version of the data warehouse. This process has to
be guided through specific metrics for the maintenance and monitoring of the
data warehouse.
A Roadmap for a Data Warehouse Designer/Administrator
We summarize the previously mentioned issues in Table 1, where we present a
set of steps for the data warehouse designers towards constructing the backstage
of the data warehouse. We organize the tasks of the designers in four phases (requirements,
design, tuning, and implementation) of the software project. For each
Extract Transform Load Deliverable
Phase.1a:.
Reverse
Engineering
of Sources &
Requirements
Collection
?⤠collection of
requirements from
the part of the users
?⤠analysis of the
structure and content
of the existing data
sources and their
intentional mapping
to the common data
warehouse model
?⤠mapping of the
attributes of the
data sources to the
attributes of the
data warehouse
tables through
the appropriate
intermediate
transformations
?⤠identification of
data targets
?⤠conceptual
schema
Phase 1b:
Define
Sources and
Processes
?⤠concepts map to
logical recordsets
?⤠transformations map
to logical activities
?⤠definition of a proper
execution order
?⤠concepts map
to logical
recordsets
?⤠ETL constraints
map to logical
activities
?⤠a set of
steps
for the
transition
of
conceptual
to logical
schemas
Phase.
Pages:
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258