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

Re: XML into SQL and out again

• To: "Neile Bermudes" <Neile.Bermudes@e...>, <xml-dev@l...>
• Subject: Re: XML into SQL and out again
• From: "Steve Muench" <Steve.Muench@o...>
• Date: Fri, 28 Mar 2003 19:42:04 +0100
• References: <4542E40F749CD4118CDC0002B30A07F709FABFE1@ECB-DELL03>

Neile,

Here's a powerpoint presentation and a number of example SQL
scripts that illustrates our XML, XSLT, XPath, SQL/XML,
XML Schema, Relational views of XML, XML views of relational data,
XPath-query-rewrite-to-use-existing indexes, ability to index
XPath expressions, and other things...

It was the talk I gave on this at XML Europe 2002

http://www.geocities.com/smuench/ann-xdb-demo.zip

Here's the homepage for more info on the XML Database features
built-in to current production Oracle9i database, downloadable today:

http://otn.oracle.com/tech/xml/xmldb/content.html

This technology has been production for almost a year now.

XQuery support coming in the future. We have a prototype up on
our OTN site for now...

__________________________________________________________________
Steve Muench - Developer, Product Mgr, Java/XML Evangelist, Author
Simplify J2EE Development with the Oracle BC4J Framework
http://otn.oracle.com/products/jdev/htdocs/j2ee_bc4j.html
Dive into BC4J at http://radio.weblogs.com/0118231/
Building Oracle XML Apps, http://www.oreilly.com/catalog/orxmlapp

----- Original Message ----- 
From: "Neile Bermudes" <Neile.Bermudes@e...>
To: <xml-dev@l...>
Sent: Thursday, March 27, 2003 16:17
Subject:  XML into SQL and out again


| Hello all
| 
|  
| 
| I have been asked to undertake a project at work: we have a Directory
| booklet with all the contact details for staff in our organization, which we
| create in Quark. I would now like to create a SQL database with the same
| information, and which can be searchable using ASP scripts from our company
| Intranet. Obviously it would be absolutely crazy to update both Quark and
| SQL separately every time contact details change. 
| 
|  
| 
| What I would like to do: first, export all the information in Quark into a
| SQL database, having exactly the same information in both. Then, as details
| change, just update the database. Once a year, when we print out the Staff
| Directory booklet, I would like to then like to get the updated information
| into Quark so it can be printed. 
| 
|  
| 
| The way to export info from Quark into a useable format is by using their
| product, Avenue, which exports to XML. From XML, I can get the info into
| SQL. Then, when I need to update Quark, I export from SQL into XML and then
| back into Quark. 
| 
|  
| 
| My main question is can I get the XML data into SQL columns and fields, like
| regular SQL data? And once it's in their, can I query it/mess with it like
| normal data for other purposes, like accessing it on my Intranet via ASP?
| How is this XML data treated once in SQL??
| 
|  
| 
| Any info would be appreciated, even is just a pointer to some good
| resources/site/books etc
| 
|  
| 
| Thanks
| 
|  
| 
| Neile
| 
| --
| 
|  
| 
| Neile Bermudes
| 
| Network Support Analyst
| 
| England & Wales Cricket Board
| 
| 020 74321241
| 
|  
| 
| 

• References:
  • XML into SQL and out again
    • From: Neile Bermudes <Neile.Bermudes@e...>

• Prev by Date: Re: If XML is too hard for a programmer, perhaps he'd be better off as a crossing guard
• Next by Date: Re: If XML is too hard for a programmer, perhaps he'd be better off as a crossing guard
• Previous by thread: Re: XML into SQL and out again
• Next by thread: Re: Oh those XML Viruses
• Index(es):
  • Date
  • Thread