Physical Data Warehouse Advantages with UML

by Ermie C
This article is about how there are several approaches on how to create a data warehouse.  The specifics on which parts of a data warehouse is approached are the logical and conceptual modeling, the use  of something they call ETL(Extraction, Transformation, Loading), and unique customization of the schema of the database.  They conclude that when creating a DW, it needs many decisions to create a more efficient database.  So they started to used the design and implementation tools from UML.  UML stands for Unified Modeling Language and with this language it would “reduce the overall development time of a DW, such as replicating dimension tables, vertical and horizontal partitioning of a fact table, and the use of particular servers for certain ETL processes. (Mora)”

UML is a very interesting language for developers to use.  Since it’s unified it can be used and understood with several types of models that need to be created.  So if a business needs to use it and present it to another company, it could be easily understood and implemented.  As CIS students, we learned this during one of our core classes in Cal Poly Pomona and that class is CIS 235 or in this recent change of curriculum CIS  315.  I chose this article because it shows how UML will continue to be used to present business ideas and how databases and warehouse are implemented.

This is part of our class because we are dealing many business rules and requirements.  We must find a way to think outside of the box on how the workflow of processes occur.  We create that design and then we implement that database that we are creating for a client.  Instead of using many different types of SDLC’s, we can focus on something that is more efficient.  I’ve read many articles and every thing that these authors are talking about are how to make database development and implementation more and more efficient.  I understand it thought because if we’re creating a a business model that runs smoothly, then our customer will be happy and their business performance will increase.  UML is one of those tools that need to be part of our careers because as CIS students there will be many variables thrown at us and this article shows that there are certain tools that will our careers a little bit easier.

Luján-Mora, S. , & Trujillo, J. (2006). Physical modeling of data warehouses using uml component and deployment diagrams: Design and implementation issues. Journal of Database Management, 17(2), 12-42.