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