Canonical Data Model for Data warehouse
3 posters
Page 1 of 1
Canonical Data Model for Data warehouse
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 ?
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
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Canonical Data Model for Data warehouse
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.
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.
Similar topics
» canonical and non canonical data in DW design
» How to model Customer in data warehouse
» A data warehouse model for loans
» Model available time per day in timesheet data warehouse: fact or dimension or neither?
» Ebook The Data Warehouse Lifecycle Toolkit, 2nd Edition: Practical Techniques for Building Data Warehouse and Business Intelligence Systems
» How to model Customer in data warehouse
» A data warehouse model for loans
» Model available time per day in timesheet data warehouse: fact or dimension or neither?
» Ebook The Data Warehouse Lifecycle Toolkit, 2nd Edition: Practical Techniques for Building Data Warehouse and Business Intelligence Systems
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|