users@jaxb.java.net

Relational Data in XML?

From: Robert Mark Bram <relaxedrob_at_optushome.com.au>
Date: Sun, 09 Feb 2003 13:33:13 +1100

Howdy all!

I am about to start building an order entry system (re my earlier post "JAXB
or XML DB?"). I have a question about storing the data as XML..

I know how a set of tables for a basic database might look:

[customer] 1 - x [order] 1 - x [line-order] x - 1 [part]

Customer makes many orders, each order is for one customer.
An order may contain many line-orders, each line-order is part of one order
only.
Each line order is for one part only, each part may be included in many
line-orders.

But how do I go about designing an xml document for this? Am I going to
repeat part data inside every line order? Can I link xml documents in the
same way relational tables can be linked?

Thanks for any advice!

Rob
:)
:->
:-}