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"); o Exception in thread "main" java.sql.SQLException: ?Z {TP?[ P?Z P?[ ?Z ?Z P?[ 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