XML schema for metadata: best practices ?
I'm developing an metadata information architecture for "record management
system" running on SQL database. Records (documents) are stored in commercial
database (www.ringtailsolutions.com) using fixed data model, which is however
ok, since allows extensions using generalized approach (extra table contains
columuns for: label , value, datatype).
We have committed to use XML for data transfer from "data collecting devices/
service providers) to database. In the first phase we are using DTD for schema
but as soon as tools are mature enough will move to using W3C Shcema (strong
datatype validation etc.)
Metada records are not going to be created by hand, probably as export from
service provider's own database or using easy to use GUI tool capturing data
eventually in XML. So, it's a kind of machine to machine communication transactions.
Finally the question, does anybody has recommendations for DTD/schema design
considering creating "a SQL database friendly and maintainable metadata model"
? <item> element is used to provide a extendable
container for arbitrary needs.
Current approach has been using a unified method stroring data. All the data
is stored in attributes. Elements used as logical containers.
Thanks, Heimo Hanninen
Following is a fictional snippet based on the current DTD:
<!DOCTYPE meta SYSTEM "nested-model.dtd">
<fileName value="back up tape, all users June 23 2001"/>
<person title="Mr." givenName="Peter" initials="G" surname="Pan" position="It
support guy" email="peter@Xcompany.ca" postalCity="City" streetAddress="223
<type other="backup tape"/>
<description value="30 GB of user's back up files"/>
<item label="trueCopy" type="boolean" value="no"/>
<item label="work-note" value="this will take 200 man hours to examine"
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center