[MonetDB-users] Newbie question about XML / SQL capabilities
Greetings all, I just became aware of MonetDB via a post to the Ruby on Rails list about a new connection adapter for MonetDB (thanks Michalis). I'm intrigued by what looks like a very impressive capability. If I'm reading the site right, MonetDB can import an XML file using the XQuery client and then query that same data using the SQL client. Is that a correct reading? TIA, Bill
Hi Bill, thank you very much for being interested in MonetDB --- it is indeed "very impressive" ;-) However, MonetDB does not yet(?) provide a seamless integration of SQL (i.e., relational) and XML data models. Currently, MonetDB/SQL and MonetDB/XQuery should rather be seen as two separate "products" that share the same MonetDB back-end engine, and hence the same performance advantages of their respective competitors. What MonetDB/SQL does already provide is some (limited) initial support for SQL/XML, mainly importing XML data into (relational) MonetDB/SQL and publishing (relational) MonetDB/SQL results as XML. Details can be found at http://monetdb.cwi.nl/SQL/Documentation/SQL_002fXML.html . A tighter integration of MonetDB/SQL and MonetDB/XQuery is on our agenda, in particular since we strongly believe in using relational database technology to process XML and XQuery (cf., http://monetdb.cwi.nl/XQuery/ & http://www.pathfinder-xquery.org/), however, limited resource and man-power did not yet allow us to attack this challenge. Since MonetDB is open source, any (serious) help and contributions are more than welcome ... ;-) Stefan On Tue, Aug 12, 2008 at 07:47:43AM -0500, Bill Walton wrote:
Greetings all,
I just became aware of MonetDB via a post to the Ruby on Rails list about a new connection adapter for MonetDB (thanks Michalis). I'm intrigued by what looks like a very impressive capability. If I'm reading the site right, MonetDB can import an XML file using the XQuery client and then query that same data using the SQL client. Is that a correct reading?
TIA, Bill ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
participants (2)
-
Bill Walton
-
Stefan Manegold