Hello, First of all your team has done a great job of creating BaseX, pretty impressed with it. Now to the point for writing this mail.
We into Healthcare solutions for past 25 years, myself technical leader has got a task of finding tool for our xml data fetching. We have got xml data (in sqlserver and Oracle also), Which can contain plain text, Image, RTF also. in sql server or oracle we write queries it is fine but when it comes for analysis kind of thing it tumbles down. So we were planning to have an XML server which will contain the code and the xml data and that can be queried.
Couple of questions. 1] Can i directly import data to BaseX from queries or does it require to be in xml file or can it be a string also. 2] Is relational query possible, in xml we got a sort of table structure (if required can send the dataxml file for reference)
3] How much load can BaseX take because the xml file content will be say 1 to 2 mb max, but there will be millions of records.
4] Is there any .Net api too (not a constraint but just curious).
Hope i made sense.
Awaiting your quick response.
Thanks Ganesh K
Dear Ganesh K,
thanks for your interest in BaseX; some quick feedback:
1] Can i directly import data to BaseX from queries or does it require to be in xml file or can it be a string also.
There are various ways to do so – depending on how deep you want to get into the code. The most popular alternatives are...
– using XQuery Update to insert XML nodes into a database – specifying a string as an argument to the CreateDB or Add classes.
2] Is relational query possible, in xml we got a sort of table structure (if required can send the dataxml file for reference)
– XQuery is a powerful language for both querying relational and hierarchical data. We don't offer support interfaces to relational databases, however, as proposed e.g. by the latest SQL standard.
3] How much load can BaseX take because the xml file content will be say 1 to 2 mb max, but there will be millions of records.
– many of our users work with XML data in the range of gigabytes. Can you guess how much space your documents will need in total?
4] Is there any .Net api too (not a constraint but just curious).
– for simple client/server queries, we've just written some basic language bindings, mostly for script languages..
https://svn.uni-konstanz.de/dbis/basex/trunk/api/etc/
..and bindings for C#, Vis.Basic etc. will follow. For more serious work, or if you want to stay in the XML world as long as possible, I suggest to follow a more elaborate approach like the one Dave Glick has pointed out (thanks...).
Hope this helps, Christian
___________________________
Christian Gruen Universitaet Konstanz Department of Computer & Information Science D-78457 Konstanz, Germany Tel: +49 (0)7531/88-4449, Fax: +49 (0)7531/88-3577 http://www.inf.uni-konstanz.de/~gruen
basex-talk@mailman.uni-konstanz.de
-
Christian Grün -
ganeshk＠21chms.com