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

RE: XML from java


java xml two level index

We are developping an application that access various databases using the correspondng JDBC drivers. We actually would like to actually extend this fonctionality to XML files. In fact we would like to view our XML files as tables and perform all kind of SQL statments on them. We do not wish to make specific programming for that but use standard JDBC interfacing. Does anyone know of any JDBC driver for accessing XML files preferably a type 4 driver ? 

 

In general, creating a relational view of an XML infoset is possible but difficult, and the result is likely to be fairly unusable because of the number of joins needed. In special cases, where you are using XML to represent a two-level hierarchy, it can be done quite nicely (as is shown by some of the Microsoft and Oracle products). The problem is (a) that the solution for the special case is likely to be very different from the solution for the general case, and (b) restricting yourself to two-level hierarchies is hardly a very effective way of exploiting XML.

Michael Kay
Software AG
home: Michael.H.Kay@n...
work: Michael.Kay@s...


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.