Data warehouse design

Multidimensional data warehouse design

Download Data warehouse design with UML

What is the goal?

The aim of this proposal is to define a method that allows the designer to tackle the different phases and steps in the design of a data warehouse. Our approach is based on three complementary parts

• The visual modeling language we use is an extension of the Unified Modeling Language (UML), an object oriented modeling language that has been widely accepted.
• The method we propose is based on the Unified Process (UP), that guides the designer to perform object oriented analysis and design.
• The use of standards in the development of a data warehouse, such as UML, Extensible Markup Language (XML), object oriented databases and object-relational databases.

Moreover, one important requirement of our work is to define a method with a set of models that can be used by the data warehouse designer to communicate the design to the end user.

Why UML?

Instead of defining a new modeling language, we propose the use of UML, a widely accepted object oriented modeling that unifies the methods most used around the world. UML combines elements from the three major object oriented design methods: Rumbaugh's OMT modeling, Booch's OO Analysis and Design, and Jacobson's Objectory.

The UML defines a rich set of graphical diagrams:

• Use case diagram.
• Class diagram.
• Behavior diagrams: statechart diagram, activity diagram, interaction diagrams (sequence diagram, collaboration diagram).
• Implementation diagrams: component diagram, deployment diagram.

Download Data warehouse design with UML