[
Lists Home |
Date Index |
Thread Index
]
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@ecb.co.uk>
To: <xml-dev@lists.xml.org>
Sent: Thursday, March 27, 2003 16:17
Subject: [xml-dev] 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
|
|
|
|
|
