October 06, 2003
I'm quite intrigued by XML Résumé Library (found courtesy of Jeremy Zawodny) . I'm always frustrated when I have to write my cv in Microsoft Word and then literally cut and paste it if I want to, for instance, turn it into a web page. Hopefully this will speed the process up somewhat, whilst allowing me to play with XML.
It also nicely intersects with a problem I've been thinking about, if not actually doing much with. I'm trying to come up with a decent XML format to describe the structure of a relational database. Google for database and XML and you'll get lots of references to storing XML documents in relational databases, or XML databases. Ask for metadata and XML and the subject matter is DTDs and XML-schema references.
All I require is a simple, standard way of describing my schema - specifying that it contains a number of tables, each made of a number of columns, stored in tablespaces and related to each other in specific but interesting ways. I'd like to have a vendor neutral format that I can turn into DDL statements for any number of varieties of relational database, starting with the usual suspects of MySQL, DB2, Oracle and SQL Server.
The closest things I can find are the XML metadata interchange specification and the relational section of the common warehouse metamodel. I'll have a look at these two and report back. In the meantime please feel free to let me know via the comments of other standards that I may have overlooked.
Posted by Andy Todd at October 06, 2003 09:41 PM