MISMO 3.1 should be open for public review some time this week. I want to use is as the model for my paper at MISMO Trimester on "How to deliver a Million Loans". I want the paper to be a working example not just theory. SO I need a place to keep a million loans.
I am using MS SQL 2008 as a Database server. There is a way to create either typed or untyped XML data. I am going to used Typed data so I need to create a SCHEMA COLLECTION that holds the MISMO definition.
The command is CREATE XML SCHEMA COLLECTION MISMO_3_1 AS ' insert schema here '
It is called a collection because it can hold multiple schema in different name spaces. All we need to do is cut and paste the xlink and MISMO schema between the single quotes.
At first the command fails. The schema as published has un-escaped characters in the xs:annotation sections. In the case of the MISMO_3_1 schema there are ' symbols in contexts like "borrower's". These should be replace by the equivalent entity reference. '. I have added an item to the 3.1 public comment period log to straiten that out. In the case of xlink the offending characters are "|". I have added a log item to address these as well. For this test I made the the changes before cutting and pasting into the CREATE SCHEMA COLLECTION command.
The next blog will describe how to load DEAL data into the DB.
I tried Loading MISMO 3.1 into a MS SQL database as your post describes, but it didn't quite go as planned. I fixed the issues with inproper symbols, but it is giving me the error
ReplyDeleteReference to an undefined name 'resourceLink' within namespace 'http://www.w3.org/1999/xlink'
Therefore, I don't quite understand what you mean by "All we need to do is cut and paste the xlink and MISMO schema between the single quotes."
Do we run the CREATE twice? Once for the XLink XSD and monce for the MISMO XSD? Do we have to merge the files?
Sorry for the confusion. The CREATE XML SCHEMA COLLECTION command should be executed once per namespace schema you are loading.
ReplyDeleteDo it once with the MISMO schema between the quotes (after you have cleaned up the single quote issues in the published schema). Then again for the XLink Schema.