Re: XML into SQL and out again
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!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format