PUBLICACIONES
Ver todos los resumenes/See all abstracts
Ver todas las publicaciones (sin resumenes)/See all publications (without abstracts) Claves:
BL | Blog | CI | Congreso internacional / International conference | CL | Capítulo de libro / Book chapter | CN | Congreso nacional / National conference | II | Informe interno / Internal report | LI | Libro / Book | RV | Revista / Journal |
URL Documento / Document Presentación / Slides
Año/Year 2003:
Clave: CI Ref: DMDW'2003 Sergio Luján-Mora, Juan Trujillo. A Comprehensive Method for Data Warehouse Design. 5th International Workshop on Design and Management of Data Warehouses (DMDW'03),
p. 1.1-1.14, Berlin (Germany), September 8 2003.
A data warehouse (DW) is a complex information system primarily
used in the decision making process by means of On-Line Analytical
Processing (OLAP) applications. Although various methods and
approaches have been presented for designing different parts of
DWs, such as the conceptual and logical schemas or the
Extraction-Transformation-Loading (ETL) processes, no general and
standard method exists to date for dealing with the whole design
of a DW. In this paper, we fill this gap by presenting a method
based on the Unified Modeling Language (UML) that allows the user
to tackle all DW design phases and steps, from the operational
data sources to the final implementation and including the
definition of the ETL processes. The main advantages of our
proposal are: the use of a standard modeling notation (UML) in the
models accomplished in the different design phases, the
integration of different design phases in a single and coherent
framework and the use of a grouping mechanism (UML packages) that
allows the designer to layer the models according to different
levels of detail. Finally, we also provide a set of steps that
guide the DW design. | |
|