BaseX-Talk September 2013

basex-talk@mailman.uni-konstanz.de

28 participants
39 discussions

Fwd: Announcing XQS: XQuery for Scala
by Erol Akarsu 06 Sep '13

06 Sep '13

---------- Forwarded message ---------- From: Marklogic User Community Group Members <group-digest(a)linkedin.com> Date: Fri, Sep 6, 2013 at 5:36 AM Subject: Announcing XQS: XQuery for Scala To: "Erol Akarsu, PhD" <eakarsu(a)gmail.com> Marklogic User Community [image: LinkedIn] [image: Marklogic User Community] <http://www.linkedin.com/e/-8wgh2l-hl97lwne-4x/vgq/1772706/eml-anet_dig-h_gn…> September 6, 2013 New Discussions *Announcing XQS: XQuery for Scala *<http://www.linkedin.com/e/-8wgh2l-hl97lwne-4x/vai/1772706/270089160/member/…> Started by Dino Fancellu, Polyglot Developer at Barclays Corporate Banking Like<http://www.linkedin.com/e/csrff6zr/-8wgh2l-hl97lwne-4x/lvi/1772706/27008916…>· Flag<http://www.linkedin.com/e/csrfFCE-/-8wgh2l-hl97lwne-4x/fav/1772706/27008916…> Stop inappropriate content the moment it is posted. Send me an email for each new discussion »<http://www.linkedin.com/e/-8wgh2l-hl97lwne-4x/snp/1772706/true/eml-anet_dig…> Do you know anybody that might like this group? Invite others to join » <http://www.linkedin.com/e/-8wgh2l-hl97lwne-4x/sgi/1772706/im-invite/cs-conn…> You are receiving Group Digest emails. Unsubscribe<https://www.linkedin.com/e/-8wgh2l-hl97lwne-4x/ihSC_2-eH7i_lIDOPydFgividrhu…>. This email was intended for Erol Akarsu, PhD (Software Architect). Learn why we included this<http://www.linkedin.com/e/-8wgh2l-hl97lwne-4x/plh/http%3A%2F%2Flinkedin%2Ec…>. © 2013, LinkedIn Corporation. 2029 Stierlin Ct. Mountain View, CA 94043, USA

1 0

WebDAV document retrieval
by Víctor Villamayor Callejo 05 Sep '13

05 Sep '13

Dear all, I would like to access my BaseX database through WebDAV, in order to be able to open, edit and save xml documents with custom made software that only works with files in the filesystem. I tried with WinXP Web Folders, NetDrive and WebDrive clients. I also tried with BaseX 7.7 and 7.6. My problem is that whenever I save a XML document, after a few seconds it is added (or replaced) to the database, and then it shows 0 bytes on the WebDAV client. Then I can access the document with the BaseX GUI for example, but I cannot double-click it in the client because it opens as an empty file. The exceptions are raw or incorrect xml documents, which are correctly retrieved. So WebDAV allows me to add, replace, rename, and delete xml documents, but not retrieve them. Is this the expected behaviour, a bug, or a locking matter? Thank you in advance, Víctor Villamayor Callejo Electronics Department NEW INFRARED TECHNOLOGIES ( +34 91 632 43 63 * vvillamayor(a)niteurope.com : www.niteurope.com [1] ¸ www.youtube.com/niteurope DISCLAIMER: This message and any attached files transmitted with it, is confidential, especially as regards personal data. It is intended solely for the use of the individual or entity to whom it is addressed. If you are not the intended recipient and have received this information in error or have accessed it for any reason, please notify us of this fact by email reply and then destroy or delete the message, refraining from any reproduction, use, alteration, filing or communication to third parties of this message and attached files on penalty of incurring legal responsibities. The sender does not guarantee the integrity, the accuracy, the swift delivery or the security of this email transmission, and assumes no responsibillity for any possible damage incurred through data capture, virus incorporation or any manipulation carried out by third parties. Links: ------ [1] http://www.niteurope.com/

2 1

external parameters with basexgui?
by Graydon Saunders 05 Sep '13

05 Sep '13

Hi! I've been failing to find this for awhile now. I've got some queries which I need to run from both a command line, using Saxon, for production purposes, and from the BaseX GUI, for development and testing and "that looks weird..." purposes. Saxon requires that I pass in content as parameters. That's easy enough. Is there a way to do this -- pass an external parameter value to a query -- with the BaseX GUI? Thanks! Graydon

2 1

Xquery on 2 DBs taking more execution time !!
by John Best 05 Sep '13

05 Sep '13

As the data is quite huge around 2GB, which creates problems while creating FT Index, I have divided it into 2 parts. For a better picture of what I have done, I am explaining it with a suitable example. Lets say I have articles on Physics in one single DB. So, I divided them into 2 DBs, viz; short description and long description. So, now I have 2 DBs - PhysicsSD PhysicsLD By doing so, I am not getting OOM now while creating FT Index. (Wow!!). But now, I am facing another issue... Say, I want to search for words "emf" and "waves" into the Physics DBs, I would do this - for $dbname in ('physicsSD', 'physicsLD') for $x in doc($dbname)//Doc[SD/Info/ text() contains text {"emf waves"} all words or LD/Info/Para/text() contains text {"emf waves"} all words] order by xs:integer($x/Details/Year) descending return $x/Doc This query retrieves data in approx. 83000 ms (83 Sec) But when executed on INDIVIDUAL DBs, the total time is very very less compared to the above. Its only 4500 ms (4.5 sec) for BOTH !!! -- Have a nice day JBest

3 2

Too many opened files error
by Alexander Shpack 05 Sep '13

05 Sep '13

Hello! for $i in (1 to 1000) let $name := 'user_' || $i return ( db:create( $name ) ) Is it bug, or normal behavior? I would like to create little benchmark with multiple databases, multiple writtings and readings to it. -- s0rr0w

2 1

Re: [basex-talk] Xquery on 2 DBs taking more execution time !!
by John Best 04 Sep '13

04 Sep '13

Dear Dirk, "Sounds to me like the FT index isn't hit in the long-running query. Could you please check for both queries if the index is actually used? You can do so by looking at the query plan in the info view." Both the DBs are Text, Attribute and FT Indexed. Please find the Timing and Query Plan output after running the query - *Timing:* - Parsing: 0.0 ms - Compiling: 11.08 ms - Evaluating: 48729.01 ms - Printing: 16.38 ms - Total Time: 48756.49 ms *Query plan: * <QueryPlan> <FLWR> <Let var="$items"> <List> <IterPath> <DBNode name="physicsSD" pre="0"/> <IterStep axis="child" test="*:Docs"/> <IterStep axis="child" test="*:Doc"/> </IterPath> <IterPath> <DBNode name="physicsLD" pre="0"/> <IterStep axis="child" test="*:Docs"/> <IterStep axis="child" test="*:Doc"/> </IterPath> </List> </Let> <For var="$x"> <IterFilter> <VarRef> <Var name="$items" id="0"/> </VarRef> <FTContains> <AxisPath> <IterStep axis="child" test="Info"/> <IterStep axis="child" test="Para"/> <IterStep axis="child" test="text()"/> </AxisPath> <FTWords> <Str value="emf waves" type="xs:string"/> </FTWords> </FTContains> </IterFilter> </For> <Return> <AxisPath> <VarRef> <Var name="$x" id="1"/> </VarRef> <IterStep axis="child" test="Doc"/> </AxisPath> </Return> </FLWR> </QueryPlan> "Also it would be best to have at least some of your data, so that we can reproduce the problem. You can send the data to us directly, so we don't spam the list and if the data should not be public." I can't provide the data publicly. I do have Christian's personal mail id. But I think he is enjoying vacations... -- Have a nice day JBest

2 1

JSON serialisation for results
by Bell, Darren S 03 Sep '13

03 Sep '13

Hi, I'm new to BaseX. We are running a simple XQuery: declare variable $documentguid as xs:string external; <utterances> { for $targetelements in /*:TEI/*:text/*:body/*:u[/*:TEI/*:teiHeader/*:fileDesc/*:publicationStmt/*:idno[@type='qudexdocument']=$documentguid] return <utterance> <guid>{data($targetelements/@xml:id)}</guid> <speaker>{data($targetelements/@who)}</speaker> <text>{data($targetelements/text())}</text> </utterance> } </utterances> by calling http://dahdsst2:8984/rest/DF?run=interviewutterances.xq&documentguid=q-25d5… All works well but our UI developers are not happy with the JSONML as a serialization format. I changed the output method to 'json' and this returns "[BXJS0002] JSON serialization: <json> expected as root node." So then I changed the <utterances> root element to <json> and then I get: [BXJS0002] JSON serialization: Element <json> must be typed as "object" or "array". I'm a bit lost at this point. I've consulted the documentation but there is not very much detail about the specific steps to go about serialising an XQuery output as JSON. The standard JSON format I'm trying to output is like so: { "utterances": { "utterance": [ { "guid": "q-2f0de4c5-7dfb-e211-b501-000bdb5cc6d5", "speaker": "interviewer", "text": "I'd like to start, if I may, by asking you your birth date." }, { "guid": "q-300de4c5-7dfb-e211-b501-000bdb5cc6d5", "speaker": "subject", "text": "November 9th, 1902." }, { "guid": "q-310de4c5-7dfb-e211-b501-000bdb5cc6d5", "speaker": "interviewer", "text": "Could you tell me how many children there were in your family?" } ] } } Any tips on how to go about this in BaseX would be much appreciated, Regards, ___________________________________ DARREN BELL Data and Services Developer ___________________________________ T +44(0) 1226 272144 E dbell(a)essex.ac.uk W ukdataservice.ac.uk ___________________________________ UK Data Service UK Data Archive University of Essex ___________________________________ Legal Disclaimer: Any views expressed by the sender of this message are not necessarily those of the UK Data Service or the UK Data Archive. This email and any files with it are confidential and intended solely for the use of the individual(s) or entity to whom they are addressed.

2 1

Re: [basex-talk] Mistaken order?
by Wendell Piez 02 Sep '13

02 Sep '13

Dear Arve, Ouch! The behavior is indeed as expected in 7.7. It is unexpected (and non-conformant) in 7.7 beta. The saddest thing is that I have 7.7 installed and could have tried it there before posting. :-( Cheers, Wendell Wendell Piez | http://www.wendellpiez.com XML | XSLT | electronic publishing Eat Your Vegetables _____oo_________o_o___ooooo____ooooooo_^ On Mon, Sep 2, 2013 at 2:05 AM, Arve Gengelbach <ag(a)basex.org> wrote: > Hi Wendell, > > running your query on any database with BaseX version 7.7, everything > works as expected. Using the latter version? > > cheers, > Arve > > > Am 01.09.13 18:21, schrieb Wendell Piez: >> Dear BaseX, >> >> Running in the GUI, I execute: >> >> let $source := (/)[1] >> >> let $wrapped := <wrapper> >> { $source/*/* } >> <new/> >> </wrapper> >> >> return $wrapped/*/name() >> >> I expect to get a sequence of the names of element children of the >> document (root) element of the first entry in the currently open >> database, with a 'new' element named at the end. >> >> Instead, I get 'new' followed by the names of the elements in the >> document, with 'new' first. (And I see 'new' for ($insert/*/name())[1] >> and not for ($insert/*/name())[last()].) >> >> When I look at $insert itself, the document itself looks like what I expect. >> >> Where am I going wrong, or is this a bug? >> >> Cheers, Wendell >> >> >> Wendell Piez | http://www.wendellpiez.com >> XML | XSLT | electronic publishing >> Eat Your Vegetables >> _____oo_________o_o___ooooo____ooooooo_^ >> _______________________________________________ >> BaseX-Talk mailing list >> BaseX-Talk(a)mailman.uni-konstanz.de >> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >>

1 0

Mistaken order?
by Wendell Piez 01 Sep '13

01 Sep '13

Dear BaseX, Running in the GUI, I execute: let $source := (/)[1] let $wrapped := <wrapper> { $source/*/* } <new/> </wrapper> return $wrapped/*/name() I expect to get a sequence of the names of element children of the document (root) element of the first entry in the currently open database, with a 'new' element named at the end. Instead, I get 'new' followed by the names of the elements in the document, with 'new' first. (And I see 'new' for ($insert/*/name())[1] and not for ($insert/*/name())[last()].) When I look at $insert itself, the document itself looks like what I expect. Where am I going wrong, or is this a bug? Cheers, Wendell Wendell Piez | http://www.wendellpiez.com XML | XSLT | electronic publishing Eat Your Vegetables _____oo_________o_o___ooooo____ooooooo_^

1 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk September 2013