[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: DTD-to-DB SCHEMA

• From: "Matthew Sergeant (EML)" <Matthew.Sergeant@e...>
• To: "'Shawn Lauzon'" <lauzon@u...>, xml-dev@i..., ffarahbo@i...
• Date: Wed, 16 Dec 1998 10:23:04 +0100

> -----Original Message-----
> From:	Shawn Lauzon [SMTP:lauzon@u...]
> 
> 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@i...
Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/
To (un)subscribe, mailto:majordomo@i... the following message;
(un)subscribe xml-dev
To subscribe to the digests, mailto:majordomo@i... the following message;
subscribe xml-dev-digest
List coordinator, Henry Rzepa (mailto:rzepa@i...)

• Prev by Date: VRML DTD
• Next by Date: No Subject
• Previous by thread: FW: DTD-to-DB SCHEMA
• Next by thread: RE: DTD-to-DB SCHEMA
• Index(es):
  • Date
  • Thread