DB2 Cube Models

Posted in Data Warehousing, Model Driven Development with tags on June 12, 2008 by Patricio

DB2 cube models are an interesting representation of OLAP Cubes and metadata objects:  A cube model contains:

·         Cube facts objects

·         Cube dimensions

·         Cube hierarchies

·         Cube levels

Cube Model:

Dimension Detail:

The Cube:

The model is very close to the OLAP implementation, as expected… but the way they model cube dimension hierarchies is very interesting and helps the business analyst to focus on the business needs.

  You can find more from: http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.db2_olap.doc/cmdcubemodel.htm

MDD Applied to Data Warehousing Systems: Cube Model

Posted in Data Warehousing, Model Driven Development with tags on May 13, 2008 by Patricio

Cube Model (http://www.cubemodel.com) is an interesting example of MDD applied to data warehousing systems. They build models using the CWM specification and they use the model to assist in developing many of the necessary artifacts in data warehouse systems.

 “Therefore, the model is far more useful than just fancy documentation. Also, our models contain nothing like application code, so there is no translation of procedural code between languages. What the models do contain is a description of which objects have what kind of relationships to which other objects. Developers can write the code for a particular kind of relationship once and then use the model to generate an application to call their code in all the right places.”

You can find in Cube Model site interesting articles, papers and presentations:

The Common Warehouse Metamodel (CWM™)

Posted in Data Warehousing, Model Driven Development with tags on April 16, 2008 by Patricio

We are now studying the CWM specification from OMG (Object Management Group) and we think this specification will help us to define the ontology and the meta-model of our language. This specification defines Standard interfaces that can be used to enable easy interchange of warehouse and business intelligence metadata between warehouse tools, warehouse platforms and warehouse metadata repositories in distributed heterogeneous environments.

With CWM model and code generation we expect to automatically generate the following artifacts:

  • Create ETL applications,
  • Build the database tables for the warehouse,
  • Create the OLAP layer,
  • Create documentation for the system, and
  • Reports

Announcing project Megiddo מגידו

Posted in Data Warehousing, Model Driven Development, Software Engineering on April 1, 2008 by Patricio

I’m please to announce the project Megiddo מגידו. The objective of this project is the design and implementation of a model driven approach to data warehousing systems. How to build languages and models to design and implement data warehousing systems for different industries (retail, manufacturing, insurance, healthcare, government, banking, etc…) are the main scope of Megiddo.

armageddon.jpgMegiddo is a hill in Israel near the modern settlement of Megiddo. In ancient times Megiddo was an important city state. It is also known alternatively as Tel Megiddo (Hebrew) and Tell al-Mutesellim (Arabic). According to some interpretations of the Christian Bible, this place will be the venue for or the final battle between the forces of light led by Jesus Christ and the forces of darkness led by Satan or the Anti-Christ after the End of Days.

Megiddo will be designed by me in the PRIMAVERA BSS Innovation and New Technologies group in the software factory department.

A new beginning

Posted in Architecture, Data Warehousing, Software Engineering on March 14, 2008 by Patricio

I’m starting a new blog. I will be blogging about Software Architecture, Software Engineering and Data Warehousing Systems.