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

Re: XML Database Decision Tree?

• From: Tom Bradford <bradford@d...>
• To: "Champion, Mike" <Mike.Champion@S...>
• Date: Tue, 30 Oct 2001 17:37:58 -0700

On Tuesday, October 30, 2001, at 05:21 PM, Champion, Mike wrote:
> If by "efficiently" you mean human time rather than computer time, this 
> can
> be demonstrated by comparing what it takes to load something like the
> Shakespeare plays into various DBs of one flavor or another and 
> performing
> some XPath queries.  With Tamino (the only one I know how to do this in
> offhand) the steps are:
>
> 1 - load the DTD (or schema) into the Schema editor (tweak content 
> model to
> allow 	variations and evolution and define indexes if you must)
> 2 - Define a DB collection based on that schema  (2 mouse clicks or so)
> 3 - Use a simple HTML form or a loader script to load the XML data into 
> the
> DB
> 4 - Enter the URL of the database + "_xql=" + an XPath expression

You big companies and your silly GUI tools.

I'll follow this up with how it would be done in a dbXML scenario (all 
of these are typed from the shell):

1> dbxmladmin ac -c /db -n newcollection                       # Creates 
'newcollection'
2> dbxml addmultiple -c /db/newcollection -f ./                # Adds 
the documents
3> dbxml xpath -c /db/newcollection -q <some xpath>  # Queries the 
collection

 From a user/admin point of view, the process is brain-dead simple.   The 
only other steps you might want to take are to add indexes to the 
collection (best done after a load, just as with RDBSes)

dbxmladmin ai -c /db/newcollection -n index1 -p elementName
dbxmladmin ai -c /db/newcollection -n index2 -p elementName@attrName
dbxmladmin ai -c /db/newcollection -n index3 -p *@attrName
dbxmladmin ai -c /db/newcollection -n index4 -p elementName@*
etc...

-- Tom

• References:
  • RE: XML Database Decision Tree?
    • From: "Champion, Mike" <Mike.Champion@S...>

• Prev by Date: RE: XML Database Decision Tree?
• Next by Date: RE: XML Database Decision Tree?
• Previous by thread: RE: XML Database Decision Tree?
• Next by thread: RE: XML Database Decision Tree?
• Index(es):
  • Date
  • Thread