[Building Sakai] Why use XML in database?

[Gregory Guthrie]

What is the reason that some entries in the database are encoded in XML, instead of basic fields in another table?

As one example; in the ASSIGNMENT_ASSIGNMENT table, to find by dates one has to do an SQL lookup, and then decode into the XML entry with the date encoded as strings in one of the XML fields.

The ASSIGNMENT_ID and CONTEXT fields are then replicated in the <assignment> field of the XML as values.

-------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20141121/f2b86841/attachment.html