Hi,

I'm a totally newbie and try to implements an LDAP-application over
MonetDB/XQuery due to efficient search performance of column-store.
Like the example XQueryLoad.java does i have succeed to import a XML-file
and now come my questions:

How can i manipulate  my  XML-files  with  JAVA? Like doing searches and
changes over XML-files.


If I understood correct, you load your xml documents in monet. So the
next step is to send the relevant xquery queries to monet using the
jdbc drivers and wait for the result:) If you are talking about
manipulating some xml data inside java then you would use the main
memory representation DOM provided by the standard java library.

That really turns me a light through the darkness, thanks a lot 8-)
Have never thought that xquery works through jdbc. I tried lots of xqueries, it works nice.
One thing to mention, if i try query which means not a search activity, will cause an Exception.
But it works...anyway, the insert action has been done.
For examples:

rs = st.executeQuery("do insert <end/> as last into doc(\"greetings.xml\")/doc");

Exception in thread "main" java.sql.SQLException: ?Z{TP?[P?ZP?[?Z?ZP?[V ( Mars language... )
    at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:2048)
    at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:1798)
    at nl.cwi.monetdb.jdbc.MonetStatement.internalExecute(MonetStatement.java:371)
    at nl.cwi.monetdb.jdbc.MonetStatement.execute(MonetStatement.java:340)
    at nl.cwi.monetdb.jdbc.MonetStatement.executeQuery(MonetStatement.java:404)
    at test.monetdb.XQuerySearch.main(XQuerySearch.java:46)

Now i'm wondering, if jdbc also support prepared query, which means to execute query like this:

rs = st.executeQuery("prepared.xq" , "var1" , "var2" ... );

How is the performance of Subtree-search? Like doing searchs over the whole
tree or any subtrees.


I think you will be satisfied by the response time of Monetdb:)
However, it has to do with what you will be searching and what your
queries will be doing. I would suggest to test some queries with the
monet client (command: mclient -lxq) to see for your self.

run: mclient -lx -t q.xq

I get Error: Can't find zlib1.dll
Reinstall didn't solve the problem.

As once discussed in
http://comments.gmane.org/gmane.comp.db.monetdb.user/1027,
i'm in the same situation.


This thread is about monetdb5 and mal, while you will be using monetdb
4 (using mil) and xquery (I dont believe you have to get "dirty" with
mil though).

That's the best news of this week and thank lefteris, u words do helped me a lot.

Best regards,
Chaojing Yang