- BaseX-Talk - mailman.uni-konstanz.de

how to get BaseXClient console speak unicode under Windows ?
by Fabrice Etanchaud 27 Jan '11

27 Jan '11

Dear all, under Windows, I would like to see correct unicode results when running Xqueries under BaseXClient application (xml content is in russian). Could you please help me ? best regards, Fabrice Etanchaud

3 7

BaseX is 100% trusted !
by Vera Zubor - DownloadAtlas.com 27 Jan '11

27 Jan '11

January 27, 2011 BaseX, we have done your NEW complete security tests. To assure our users that BaseX is clean and safe to install, we awarded your software with our DownloadAtlas.com *100% Safe Award*. If you want to notify your users about this certification, you can display this award on your website. You can visit now the awards section within our website and pick your award banner from there: http://www.downloadatlas.com/freeware-52cba7a6.html Please, login for instructions. http://user.downloadatlas.com/?account=support@basex.org That's all for today. Cheers, Vera Zubor - webmaster e-mail: editor(a)downloadatlas.com ----------------------------------------------------------------------------------------------------------------------- To unsubscribe or change options please login to your account using email address support(a)basex.org or click here : http://user.downloadatlas.com/

1 0

Granted Editor's Pick to BaseX
by DownloadRoute.com 27 Jan '11

27 Jan '11

Hello Sir/Madam, this is not a spam. In the year 2010 your software "BaseX" has been chosen by our visitors and was selected as an editorial pick. We are impressed by the quality and cleanliness of the program. Read here: http://www.downloadroute.com/BaseX-DBIS-Group-University-of-Konstanz/awards… Sincerely, George DownloadRoute.com team Note: Click to unsubscribe from our future mailings: http://www.downloadroute.com/no-mailing/BaseX-DBIS-Group-University-of-Kons…

1 0

BaseX in Cocoon?
by Joachim Wackerow 26 Jan '11

26 Jan '11

Hello, Does anybody has experience in using BaseX in the Cocoon framework? Currently I'm using eXist with Cocoon (by the XML:DB protocol). I would be interested to use BaseX with Cocoon. Now I'm wondering if anybody tried this and can give me some hints. Cheers, Achim -- GESIS - Leibniz Institute for the Social Sciences Department: Monitoring Society and Social Change Unit: Social Science Metadata Standards Visiting address: B2 1, 68159 Mannheim, Germany Postal address: P.O. Box 122155, 68072 Mannheim, Germany Phone: +49 (0)621 1246 262 Fax: +49 (0)621 1246 100 E-mail: joachim.wackerow(a)gesis.org www.gesis.org/en/institute/

4 6

Options to convert coordinates from S-JTSK to WGS84 by XQuery
by Jan Vlčinský (CAD) 26 Jan '11

26 Jan '11

Hi I am facing problem, that my XML data have coordinates in system S-JTSK (used a lot for area of Czech Republic) and resulting data must be in WGS84, as they will be used by Google Maps. Be sure, that the conversion is not trivial task (the other way is simpler, but S-JTSK to WGS84 is well known complexity) - so I am not sure, if writing complete conversion code by XQuery function itself is feasible. I can try do some conversion by other tools before I insert the XML or after I create resulting data - but elegant solution would accomplish this by XQuery. I know, that there are Java libs available for this (like GeoTools - http://geotools.org/) My question is: - is there any option to add more XQuery methods/functions written in Java to BaseX? Like the conversion function for coordinates? - It would go: add some JAR into class path - register it somehow and then be able to use it. - optionally writing some interface, which would make the jar available to BaseX XQuery processing. Any ideas what to do with my crazy wishes? With best regards Jan

2 2

Unique node identifier?
by NewIntellectual 25 Jan '11

25 Jan '11

Is there a function to retrieve a persistent unique node identifier from any given retrieved node? I thought it would be db:node-id($node) but that is returning '0'.

2 3

Re: [basex-talk] Strange query plan difference
by Christian Grün 25 Jan '11

25 Jan '11

Hi Philip (cc:mailing list), does the index still work if you reopen the GUI and run your query? Next, which full-text options have you set? Christian ___________________________ On Tue, Jan 25, 2011 at 10:15 AM, Philip Oliver <phil3(a)olivercomputing.com> wrote: > Christian - I've gotten around to trying BaseX 6.5.1 (generated from SVN) with some code changes, and I'm trying to figure out some strange behavior: a query executed in the GUI is using an index, whereas the same query executed in my program via client/server execution, does not (so is very slow.) > > (One thing I've noticed is that the fulltext indices are not used if the "English" language option is chosen. I figure this is the same principle as the indices not being used if the "contains text" query options don't match the database fulltext index properties - but I don't know what fulltext options to use in the query, then. I don't know if this is related to the problem I'm seeing.) > > ---------------------------------------- > This is the query: > > let $paras:=db:open('CIVWAR')//node()[text() contains text "ohio"] let $books:=$paras/ancestor::book return (for $book in $books where exists($book/@id) order by number($book/@id) return <book id="{$book/@id}" series="{$book/@series}" title="{$book/title}"/>) > > ---------------------------------------- > This is the result of session.info() with "set queryinfo on", after the query is executed in my program: > > Query: let $paras:=db:open('CIVWAR')//node()[text() contains text "zanesville"] let $books:=$paras/ancestor::book return (for $book in $books where exists($book/@id) order by number($book/@id) return <book id="{$book/@id}" series="{$book/@series}" title="{$book/title}"/>) > > Compiling: > - pre-evaluating open("CIVWAR") > - optimizing descendant-or-self step(s) > - binding static variable $paras > - merging axis paths > - binding static variable $books > - rewriting where clause to predicate(s) > - rewriting exists(@*:id) > - removing variable $paras > - removing variable $books > - simplifying flwor expression > > Result: for $book in (document-node { "DYERS_P1.xml" }, ...)/descendant::node()[text() contains text "zanesville"]/ancestor::*:book[@*:id] order by number($book/@id) return element { "book" } { attribute { "id" } { $book/@id }, attribute { "series" } { $book/@series }, attribute { "title" } { $book/title } } > > Parsing: 1.83 ms > Compiling: 8.73 ms > Evaluating: 36902.45 ms > Printing: 0.71 ms > Total Time: 36913.74 ms > Results: 15 Items > Updated: 0 Items > Printed: 964 Bytes > Memory: 11970 KB > > Query executed in 36914.08 ms. > > > ---------------------------------------- > And this is the query info from the GUI: > > Query: let $paras:=db:open('CIVWAR')//node()[text() contains text "ohio"] let $books:=$paras/ancestor::book return (for $book in $books where exists($book/@id) order by number($book/@id) return <book id="{$book/@id}" series="{$book/@series}" title="{$book/title}"/>) > Compiling: > - pre-evaluating open("CIVWAR") > - optimizing descendant-or-self step(s) > - applying full-text index > - binding static variable $paras > - merging axis paths > - binding static variable $books > - rewriting where clause to predicate(s) > - rewriting exists(@id) > - removing variable $paras > - removing variable $books > - simplifying flwor expression > Result: for $book in FTIndexAccess("CIVWAR", "ohio")/..[ancestor::document-node()]/ancestor::book[@id] order by number($book/@id) return element { "book" } { attribute { "id" } { $book/@id }, attribute { "series" } { $book/@series }, attribute { "title" } { $book/title } } > Query plan: > <GFLWOR> > <For var="$book"> > <AxisPath> > <FTIndexAccess data="CIVWAR"> > <FTWords>ohio</FTWords> > </FTIndexAccess> > <IterStep axis="parent" test="node()"> > <AxisPath> > <IterStep axis="ancestor" test="document-node()"/> > </AxisPath> > </IterStep> > <IterStep axis="ancestor" test="book"> > <AxisPath> > <IterStep axis="attribute" test="id"/> > </AxisPath> > </IterStep> > </AxisPath> > </For> > <Order> > <OrderByExpr dir="ascending" empty="least"> > <FNAcc name="number(item?)"> > <AxisPath> > <VarRef name="$book"/> > <IterStep axis="attribute" test="id"/> > </AxisPath> > </FNAcc> > </OrderByExpr> > </Order> > <Return> > <CElem> > <Item value="book" type="xs:QName"/> > <CAttr> > <Item value="id" type="xs:QName"/> > <AxisPath> > <VarRef name="$book"/> > <IterStep axis="attribute" test="id"/> > </AxisPath> > </CAttr> > <CAttr> > <Item value="series" type="xs:QName"/> > <AxisPath> > <VarRef name="$book"/> > <IterStep axis="attribute" test="series"/> > </AxisPath> > </CAttr> > <CAttr> > <Item value="title" type="xs:QName"/> > <AxisPath> > <VarRef name="$book"/> > <IterStep axis="child" test="title"/> > </AxisPath> > </CAttr> > </CElem> > </Return> > </GFLWOR> > Timing: > - Parsing: 0.99 ms > - Compiling: 0.59 ms > - Evaluating: 864.56 ms > - Printing: 1.09 ms > - Total Time: 867.25 ms > >

2 1

Software Submitted - BaseX 6.5
by SoftList 25 Jan '11

25 Jan '11

Dear BaseX, Thank you for your submission - "BaseX 6.5" to SoftList. Please allow a few days until we review and place it on our site. Sincerely, SoftList.Net http://www.softlist.net � 2000-2008, SoftList.Net

1 0

6.5 - org.basex.server : basex never returns
by Fabrice Etanchaud 25 Jan '11

25 Jan '11

Dear all, I get a very strange behaviour in client/server mode with the java binding (ckecked out from the repository). I wrote a little piece of code that never returns from the last command 'DROP DATABASE xxx' It ends up normally if you comment the query or if you change it to an iterative query. Please find the code below : Best regards import org.basex.server.*; import java.io.*; public class Test { public static final void main(String[] args) { try { ClientSession session = new ClientSession("localhost", 1984, "admin", "admin"); session.create("mydb", new ByteArrayInputStream("<Root1/>".getBytes("UTF-8"))); session.execute("OPEN mydb"); session.add("mydoc.xml", "/mypath", new ByteArrayInputStream("<Root2/>".getBytes("UTF-8"))); session.execute("DELETE /mypath/mydoc.xml"); String req = "for $i in collection() return base-uri($i)"; Query q = session.query(req); System.out.println(q.execute()); System.out.println(q.info()); q.close(); session.execute("CLOSE"); session.close(); session = new ClientSession("localhost", 1984, "admin", "admin"); session.execute("DROP DATABASE mydb"); session.close(); } catch (Exception e) { e.printStackTrace(); } } } Fabrice Etanchaud Senior Software Engineer CT Corsearch / Edital, a Wolters Kluwer business Berkenlaan 1 1831 Diegem Belgium <skype:fabrice.etanchaud?call> skype:fabrice.etanchaud Get Skype <http://www.skype.com/go/download> and call me for free. fetanchaud(a)edital.com <mailto:fetanchaud@edital.com> <http://www.edital.com/> www.edital.com (website) <http://www.ctcorsearch.com/> www.ctcorsearch.com (website) Confidentiality Notice: This email and its attachments (if any) contain confidential information of the sender. The information is intended only for the use by the direct addressees of the original sender of this email. If you are not an intended recipient of the original sender (or responsible for delivering the message to such person), you are hereby notified that any review, disclosure, copying, distribution or the taking of any action in reliance of the contents of and attachments to this email is strictly prohibited. If you have received this email in error, please immediately notify the sender at the address shown herein and permanently delete any copies of this email (digital or paper) in your possession.

3 3

fulltext score value
by KUSTER, Juan Pablo 24 Jan '11

24 Jan '11

Hello community, I have a question about score results. I create a DB with one XML document using TF/IDF text node strategy and when make query on it always obtain the same score for all results equal one. the query is: declare option output:omit-xml-declaration "no"; declare variable $w1 as xs:string external := 'roma'; declare variable $w2 as xs:string external := ''; <results> { for $hit score $score in /kdo/idf/idf/idf/idf/idf[text() contains text {$w1} all words using wildcards ] let $cap := $hit/idf[@ctx="20.1"]/text() let $continente := $hit/ancestor-or-self::idf[@ctx="20.9"]/text() order by $score descending return <result score="{$score}"> <continente>{$continente}</continente> <paese>{$hit/../../../text()}</paese> <regione>{$hit/../../text()}</regione> <provincia>{$hit/../text()}</provincia> <cap>{$cap}</cap> <nome>{$hit/text()}</nome> </result> } </results> executed through RESTFULL with the URL http://localhost:8984/basex/jax-rx/comuni?wrap=no&run=fulltext_wildcard… and follow the query results: <?xml version="1.0" encoding="UTF-8"?><results count="6"> <result score="1"> <continente>EUROPA</continente> <paese>ITALIA</paese> <regione>LAZIO</regione> <provincia>FROSINONE</provincia> <cap>03020</cap> <nome>GIULIANO DI ROMA</nome> </result> <result score="1"> <continente>EUROPA</continente> <paese>ITALIA</paese> <regione>LAZIO</regione> <provincia>VITERBO</provincia> <cap>01034</cap> <nome>FABRICA DI ROMA</nome> </result> <result score="1"> <continente>EUROPA</continente> <paese>ITALIA</paese> <regione>LAZIO</regione> <provincia>ROMA</provincia> <cap>00063</cap> <nome>CAMPAGNANO DI ROMA</nome> </result> <result score="1"> <continente>EUROPA</continente> <paese>ITALIA</paese> <regione>LAZIO</regione> <provincia>ROMA</provincia> <cap>00020</cap> <nome>CERVARA DI ROMA</nome> </result> <result score="1"> <continente>EUROPA</continente> <paese>ITALIA</paese> <regione>LAZIO</regione> <provincia>ROMA</provincia> <cap>00045</cap> <nome>GENZANO DI ROMA</nome> </result> <result score="1"> <continente>EUROPA</continente> <paese>ITALIA</paese> <regione>LAZIO</regione> <provincia>ROMA</provincia> <cap>001xx</cap> <nome>ROMA</nome> </result> </results>for each result node you can see the score node with the same value for deferents <nome> nodes strings.Sorry for my English, and thanks for any comment.

2 1