Re: MDB2 and XML databases
| From: | Michael Jackson | Date: | Fri, 03 Aug 2007 16:08:16 +0000 |
| Subject: | Re: MDB2 and XML databases | ||
| References: | 1 2 3 4 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-47756@lists.php.net to get a copy of this message | ||
On Aug 3, 2007, at 9:40 AM, Chuck Burgess wrote:
Attachment: [application/pkcs7-signature] smime.p7s
Just speaking to the feasibility of SQL-to-XML, I'm thinking that Oracle in 9i added the ability to create XML tables and still use SQL to get data from them... so I think this avenue has been tackled before.I did a little reading up on it and I think that Oracle is just xml-enabled as opposed to being native xml [1]. All this means is they take an xml document, convert it to their own XMLType format (which is just a database table), and then they run SQL queries on that table. Once the query is executed, the data is returned in XML format. This avenue makes sense for them because they need to be super fast and it would take too long to read in the XML documents. But I'm not sure that they're actually converting the SQL statements into XQuery statements. Michael [1] http://en.wikipedia.org/wiki/XML_database
Attachment: [application/pkcs7-signature] smime.p7s