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

Re: XML into SQL and out again


xml in sql out
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
| 
|  
| 
| 

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
 

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.


Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.