Canonical Data Model for Data warehouse

View previous topic View next topic Go down

Canonical Data Model for Data warehouse

Post  Nandha Kumar on Wed Dec 22, 2010 1:57 pm

Would like to get your views on suitability of canonical data model for data warehouses. Most of my experience is with star schemas where the ETL is tightly coupled with the source and target data structures. I am seeing articles around canonical model that promises to be loosely coupled . One of the articles I read was referring to a design with common minimal attributes in the dimensional model and extended by XML schema for the extended attributes.

I am finding it difficult to convince myself canonical will work for enterprise data warehouse. Any thoughts ?


Last edited by Nandha Kumar on Thu Dec 23, 2010 12:53 am; edited 1 time in total

Nandha Kumar

Posts : 1
Join date : 2010-12-22

View user profile

Back to top Go down

Re: Canonical Data Model for Data warehouse

Post  BoxesAndLines on Wed Dec 22, 2010 2:21 pm

Good luck.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Canonical Data Model for Data warehouse

Post  ngalemmo on Thu Dec 23, 2010 12:41 pm

You typically find such models in applications where data is collected from many different sources, the contents vary widely and there is a need to integrate it. An example would be reference data in the securities/financial industry.

Such models require a software layer to integrate and present the data in more traditional forms. It is not particularly well suited for an end-user accessible DW becuase of this complexity. However, it can be used in a hub arrangement that publishes more traditional views of the data for consumption.

But 99% of the time, a DW is fed from structured, known, well-defined sources. Creating a canonical model of such data is simply not necessary or desireable.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Canonical Data Model for Data warehouse

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum