question

Katie 1 avatar image
Katie 1 asked

Cannonical data model

Guys,

Did anyone has ever designed a cannonical data model? how is it related to XML? Is it like any other database supported by SQL SERVER 2008? Any light shed on this topic will help me a a lot to understand this model.

Thanks in advance!

sql-server-2008database-designdata-modelling
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
David 1 avatar image
David 1 answered

A canonical data model is any standardised, application-independent view of data - typically one used for enterprise data intergration (moving data around between systems).

It may be used in conjunction with XML just because XML is a useful format for information interchange.

A canonical data model is much like any other data model in SQL Server. Only the way you design it is potentially different because you may have to take account of many different data consumers and data providers.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.