Nowadays data modelers are not only working with stand alone (application) databases, but also with data integration, for example defining and using messages.
A very common format for these messages is XML. The structure of an XML message can be described in and validated by an XSD.
An XSD looks conceptually a lot like a system catalog of relational DBMS (Oracle, SQL Server, DB2 etc), with one main difference in the sense that XML messages are always hierarchal.
In de recent past I have worked to generate XSDs from an ERwin based datamodel several times: since the XSD describes attribtues and groups of attributes, their data types, optionality, cardinality, and possible constraints, the ERwin data model is by nature very suitable to manage all required properties. The only thing is - we cannot choose XSD as a target database.
I would appreciate that possibilty a lot, so that I can use forward engineering to generate XSD (instead of for example DDL for Oracle 11g).
IMHO this would give Erwin a great push into the data integration world.
Please sign in to leave a comment.