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

[ANN]: Software to convert Relational Databases to XML documents

• To: <xml-dev@l...>
• Subject: [ANN]: Software to convert Relational Databases to XML documents
• From: Murali Mani <mani@C...>
• Date: Fri, 2 Aug 2002 16:07:44 -0700 (PDT)
• In-reply-to: <4.2.0.58.20020802180212.0133f6b8@p...>

Hi,

I would like to announce a small piece of software which we wrote to
convert relational databases to XML documents. This works on any database
that can be accessed via JDBC.

You can download the software from
http://www.cs.ucla.edu/~mani/net/vldb/code/

please download the cot.jar and check CotReadme.txt

Main features are:

(a) A database is converted into one document. This is our belief, and
this ensures that we do not need to define cross-document referencing.

(b) Relationships are represented in multiple ways:
	(i) parent child relationships represent 1:n relationships
	(ii) ID-IDREF represent 1:n relationships
	(iii) foreign key/key represent relationships like in relational
	databases

I would like to argue that these are excellent candidates for data
modeling using XML schemas.

Furthermore, I will do a poster presenation on the details of this at
Extreme. And there is a nocturne scheduled on Wednesday, this will cover
data modeling using xml schemas in general.

I would appreciate if you would be able to test the software and give any
comments you have on the approaches.

thanks and regards - murali.

• References:
  • Re: Keeping ISO 8879 Alive (was RE: Markup
    • From: "Simon St.Laurent" <simonstl@s...>

• Prev by Date: Re: Re: URIs, concrete (was Re: Un-ask the question)
• Next by Date: Re: Re: URIs, concrete (was Re: Un-ask the qu estion)
• Previous by thread: Re: Keeping ISO 8879 Alive (was RE: Markup
• Next by thread: RE: Keeping ISO 8879 Alive (was RE: Markup perspective not code)
• Index(es):
  • Date
  • Thread