The Common Warehouse Metamodel (CWM™)

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

Leave a Reply