Subject: Re: [xsl] XML to Database Inserts via XSLT|
From: Barry Lay <blay@xxxxxxxxxxxxxxxxxxx>
Date: Wed, 09 Mar 2005 17:28:24 -0500
Oracle lets you create an "Object-Relational" view on top of a relational database that pretty much does what you describe. It also allows direct manipulation of the underlying table data with XML. It looked like a very nice fit for a web application - XML both ways with XSL to convert the results to HTML for presentation. Unfortunately we discovered that for more than trivial data volumes the approach was just too slow to be practical. I'll admit that this was not using Oracle 10g so maybe things have improved, but they would have to improve a lot to be superior than the old fashion way of dealing with databases.I was wondering if such a thing could be done using an RDBMs. Obviously they're pretty different beasts, considering that XML has a hierarchical structure by default while the relationships between objects in an RDBMS look more like a graph or some such...
But I was thinking that perhaps placing a 'temporary hierarchy' (which I guess would be somewhat like a 'view'), over the relational structure of the database, would allow the database to look like
an XML/hierarchical structure?