xml-dev - RE: DTD-to-DB SCHEMA

["Matthew Sergeant (EML)" <Matthew.Sergeant@eml.ericsson.se>]

> -----Original Message-----
> From:	Shawn Lauzon [SMTP:lauzon@us.ibm.com]
> 
> FF,
> 
> I work on database persistence with schema mapping on the IBM San
> Francisco project (reusable components -- see
> www.ibm.com/Java/Sanfrancisco/).  Anyway, we're currently working on
> developing an XML interface to our schema mapping tool that allows
> users
> to update their mappings via XML documents.  It's currently in a
> somewhat-early development phase right now.
> 
> What is it specifically that you need to do?  Are there any features
> that would be useful for you?  One of the things we're looking for is
> a
> standard DTD that can describe a database table (with, for example,
> <TABLE> tags and <COLUMN> tags that would describe the tables and
> columns).  Is there anything that you know of that does this.  Thanks
> 
	It depends how complex you want to go. There are a few options
available to you. A couple of the simpler ones are WDDX, which can
describe a recordset (which you could use as a table), and RDB, which
describes tables from relational databases.

	Personally I don't like WDDX's representation of a recordset
because it's by-column, instead of by-row, so in order to get at a
particular row you have to parse the entire file. RDB is by-row, but
it's a little more verbose because of this and doesn't support data
typing.

	I have a simple perl module that creates RDB XML from a DBI data
source if you're interested, it's on CPAN called DBIx::XML_RDB, and
contains a utility for dumping complete tables to XML.

	http://www.allaire.com/developer/wddx
	http://www.w3.org/XML/RDB

	Matt.

	http://come.to/fastnet

xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev@ic.ac.uk
Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/
To (un)subscribe, mailto:majordomo@ic.ac.uk the following message;
(un)subscribe xml-dev
To subscribe to the digests, mailto:majordomo@ic.ac.uk the following message;
subscribe xml-dev-digest
List coordinator, Henry Rzepa (mailto:rzepa@ic.ac.uk)