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

-math:log10(1)
by Giuseppe Celano 28 May '18

28 May '18

- math:log10(1) returns -0 but -0 returns 0: is there a reason for that? Thanks! Giuseppe Universität Leipzig Institute of Computer Science, NLP Augustusplatz 10 04109 Leipzig Deutschland E-mail: celano(a)informatik.uni-leipzig.de E-mail: giuseppegacelano(a)gmail.com Web site 1: http://www.dh.uni-leipzig.de/wo/team/ Web site 2: https://sites.google.com/site/giuseppegacelano/

3 2

Data analysis
by Tim Clement 26 May '18

26 May '18

Hello, I’m new to basex and really like the functionality. I have very complex XML files with deep nesting. Each file is like a document with test output values and parameters. Basex ingested the files easily and I’m able to write queries to pull out data. My end goal is to plot, graph trend data. I can do basic plotting within Basex. Do you have any suggestions for tools to visualize the data trending ? I have Power BI , but its’ not great with XML input. Thanks in advance Tim

2 1

How to pass a document as context to QueryProcessor
by wd＠creativosdigitales.co 25 May '18

25 May '18

Hi, Im writing a Java program to execute an XQuery using the BaseX QueryProcessor class, and need to pass an XML document as context node. As far Ive found in the documentation and java examples, this is done with the context() method of QueryProcessor, which receives an instance of the Value class as parameter. But the examples available are about passing simple types (strings o numbers) but nothing about passing an XML node. My question is: Where can I find examples or documentation on how to pass XML nodes as parameters to QueryProcessor.context() ? Thanks for all your help, William David Velásquez Creativo de Software Creativos Digitales S.A.S. Calle 30A # 83 - 53 Local 1033 Tel: 322 1730 - 311 709 8421 Medellín, Colombia ¿Necesita Integrar Sistemas? Conozca nuestra solución de Integración no Invasiva: <http://creativosdigitales.co> http://creativosdigitales.co ¿Preguntas sobre Facturación Electrónica? Visite: <http://facturasyrespuestas.com/> http://facturasyrespuestas.com

2 2

Deploying BaseX + data + client
by Jonathan Robie 25 May '18

25 May '18

I have written a Python package for querying Greek syntax from Jupyter Notebook. It relies on BaseX and one or more open data resources found in GitHub repositories. I want to make it available to the public in a way that is easy to install. One possibility is to write a Python script that uses Docker to install BaseX, retrieves the data and installs it in the desired directory structure - perhaps in the container, then loads it into the database. I assume that would work cleanly cross-platform? Are there better approaches that I should consider? Are there security considerations that I should consider? Jonathan

1 0

Duplicate files when using webDAV and batch processes
by France Baril 25 May '18

25 May '18

Hi, We've been having this issue for a while and we think resolving it may be the key to resolving an intermittent server 500 error that we've been having. When a user tries to save a file while a batch process is running, BaseX saves duplicates of the file. How to reproduce: 1) Take a fresh BaseX 9.0.1 installation 2) Copy the attached .xqm in webapp 3) Create an empty DB called mydb 4) Access localhost:port-num/test/create-update-a-lot-of-files to populate your db. 5) In OxygenXML, set a webdav connection to the db and open a file, add a character in one of the elements, but don't save the file. 6) From the browser, access 'localhost:port-num/test/update-something' 7) While the process in the browser is still running, save the file in Oxygen. You'll get a message saying that read timed out. Click ok and do not try saving the file again. 8) When the update-something process is done running, don't resave the file in Oxygen, instead go to localhost:port-num/test/oups-duplicates. You'll get a message saying that some files are duplicated. If you don't try again from step #4 a few times. You'll only get duplicates if you get the time out message before the update-something process is still running. If you try to save the file many times, you'll get more duplicates, 4 or 6. We're not sure if it's a BaseX bug or if we are setting our user management and/or locking rules incorrectly. Do you have any suggestions? -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

2 10

Re: [basex-talk] basex trouble
by Christian Grün 24 May '18

24 May '18

Hi Ветошкин (cc to the list), Maybe we find a way to speed up your queries; you can attach them to your next mail. I guess that the parallel query execution leads to "random access patterns" on disk. You can enforce one query at a time by setting the PARALLEL option to 1 (see [1]). Hope this helps, Christian [1] http://docs.basex.org/wiki/Options#PARALLEL On Wed, May 23, 2018 at 9:40 PM, Ветошкин Владимир <en-trance(a)yandex.ru> wrote: > Hi, Christian! > > Thank you. > > I have two scripts, which make queries to one database. > If I run these queries at different times, each of them completes in about 5 > sec. > But if I run both scripts at one time, it takes about 40 sec. > > If the scripts make queries to different databases - it's ok, it takes about > 5 sec. > > Is it possible to improve this situation? > > I tried to use this code to load database in main-memory: > db:open('db1') update {} > But it didn't help. > > I hope, you understand me :) > > > 23.05.2018, 20:15, "Christian Grün" <christian.gruen(a)gmail.com>: > > Привет Ветошкин, > > Welcome to the list. Just send your question to this address. > > Best, > Christian > > > > Ветошкин Владимир <en-trance(a)yandex.ru> schrieb am Mi., 23. Mai 2018, 19:10: > > Hello! > > Sorry for my English. > May I ask you some questions here or I have to write them on github? > > -- > С уважением, > Ветошкин Владимир Владимирович > > > > -- > С уважением, > Ветошкин Владимир Владимирович >

2 5

Atomization
by Giuseppe Celano 24 May '18

24 May '18

I think I have identified a problem with atomization of attribute content (no database involved). I have a simple query: for $s in doc("doc1")//s//t for $d in doc("doc2")//case where $d/verb_lemma = $s/@l and $d//verb_form/@value = $s/@f and $d/aspect-values/@sign = "yes" return $s In order to get a result, I (necessarily) need to use the data() function in data($d/aspect-values/@sign) = "yes", otherwise the query never returns a result. Is this a bug? I would expect that the value of @sign is automatically atomized and compared to "yes", but this does not seem the case. Thanks. Ciao, Giuseppe Universität Leipzig Institute of Computer Science, NLP Augustusplatz 10 04109 Leipzig Deutschland E-mail: celano(a)informatik.uni-leipzig.de E-mail: giuseppegacelano(a)gmail.com Web site 1: http://www.dh.uni-leipzig.de/wo/team/ Web site 2: https://sites.google.com/site/giuseppegacelano/

2 3

basex trouble
by Ветошкин Владимир 23 May '18

23 May '18

Hello! Sorry for my English. May I ask you some questions here or I have to write them on github? -- С уважением, Ветошкин Владимир Владимирович

2 1

New BaseX setup
by France Baril 23 May '18

23 May '18

Hi, In one of my projects, we are trying to refactor our code so it uses a node.js client. We have extensive functions that do more than just get data in our .xqm. They were implemented around the http server and our web application was calling the REST functions we implemented using jquery AJAX request. All the examples we looked at in the documentation that don't use the http server pass entire queries as a string to the server. We were wondering if we can call functions from our .xqm modules directly (ex. namespace:do-this(param0, param1)) or if any request that uses functions from our .xqm files need to pass through the rest API. If we can call our .xqm functions more directly, could you point us to an example to help us understand how it would work? Thanks! -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

4 4

(no subject)
by Kirsten, Dirk 23 May '18

23 May '18

Dear list, I tried to insert a huge XML document (english wikipedia). When doing so and using the default parser I got the following warning: "/my/path/enwiki-latest-pages-articles.xml" (Line 61696838): JAXP00010004: The accumulated size of entities is "50,000,001" that exceeded the "50,000,000" limit set by "FEATURE_SECURE_PROCESSING". I solved this by setting the environment variables: -DentityExpansionLimit=2147480000 -DtotalEntitySizeLimit=2147480000 -Djdk.xml.totalEntitySizeLimit=2147480000 So it seems this is a security measure from JXB. Would it be possible to set these values by default or at least be able to change the limit with the GUI or BaseX options? Cheers Dirk Dirk Kirsten ______________________________ Senacor Technologies AG D?sseldorfer Stra?e 13 65760 Eschborn M +49 (151) 4435 1967 Dirk.Kirsten(a)senacor.com www.senacor.com Senacor Technologies Aktiengesellschaft - Sitz: Eschborn - Amtsgericht Frankfurt am Main - Reg.-Nr.: HRB 105546 Vorstand: Matthias Tomann, Marcus Purzer - Aufsichtsratsvorsitzender: Daniel Gr?zinger Diese E-Mail inklusive Anlagen enth?lt vertrauliche und/oder rechtlich gesch?tzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrt?mlich erhalten, informieren Sie bitte den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet. This e-mail including any attachments may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the materials in this e-mail is strictly forbidden.

2 1