BaseX-Talk

basex-talk@mailman.uni-konstanz.de

9 participants
5256 discussions

progress of query execution
by Ветошкин Владимир 29 May '18

29 May '18

Hi, everybody! My core has written in php and php-script execute xquery-scripts to get needed data. To get the progress of one large query I have to divide it into some small ones. Isn't it? Are there any more options? Maybe it is possible to get number of seconds, which needed to complete execution of query? -- С уважением, Ветошкин Владимир Владимирович

2 1

Controlling json serialization of JSON-XML
by Hondros, Constantine (ELS-AMS) 29 May '18

29 May '18

Hello all, I'm expecting the answer to be no, but is it possible to influence the JSON serialization of <number> elements at all? xml-to-json( <map xmlns="http://www.w3.org/2005/xpath-functions"> <number key="number">10111234</number> </map> ) Results in {"number":1.0111234E7} I read this in the spec, so it looks like the number is always being cast as a double: xs:string(xs:double(fn:string($E))) TIA, Constantine ________________________________ Elsevier B.V. Registered Office: Radarweg 29, 1043 NX Amsterdam, The Netherlands, Registration No. 33156677, Registered in The Netherlands.

2 1

Fwd: BaseX performance improvements
by Christian Grün 28 May '18

28 May '18

Hi Martin (cc to the list), > 1. each XML node => 500 bytes > 2. total size of XML DB => 10million nodes(which will grow continuously as > new files are added). So one node is one document, right? I’m just asking because, in the XML terminology, each XML document has nodes itself: element nodes, attributes nodes, text nodes, etc. If you are working with millions of documents, it can be helpful to work with a "daily" database, which contains auxiliary references on documents that have been deleted or updated. If there is a time interval in which no people access your database (e.g. each night), you can merge these databases and recreate your index structures. If you query your database, you can a few more lines of XQuery: first check your daily database, and (if it doesn’t contain the required document) look up the document in your fully indexed database. > I have to do a update of the nodes as I need to replace them. I chose delete > + insert instead of replace Please note that a replace operation can be much faster: If the structure of the updated document is similar to the old document, the document can be replace in-place. > Also, I am thinking of indexing on the node id, as that is like the primary > key on which I base my operations, any suggestions might also be helpful, Here it may also be interesting to know if you will only address documents or arbitrary nodes of your document. In the first case, addressing the document path via db:open should be sufficient [1]. In the latter case, you could possibly use the existing function db:node-id [2]. Hope this helps, Christian [1] http://docs.basex.org/wiki/Databases [2] http://docs.basex.org/wiki/Database_Module#db:node-id > Thanks again, > Regards > Martin Lourduswamy > > On Sun, May 20, 2018 at 9:28 AM, Christian Grün <christian.gruen(a)gmail.com> > wrote: >> >> Hi Martin, >> >> > I am new to BaseX, I would like ot speed up XQuery of insert and delete >> > and >> > replace through options. >> >> Welcome to the list. As there are numerous ways to do updates in >> BaseX, feel free to give us more information on your insert and delete >> operations. Do you work with large single documents or many small >> documents? How large is your database? >> >> > While I query basex through perl, and try to >> > connect through GUI, the perl connection aborts. Is there a parameters >> > for >> > parallel connections, please let me know. >> >> I can’t tell why your perl connection is interrupted by opening the >> GUI (because they should be completely independent from each other). A >> step-by-step description on how you proceeded might be helpful. >> >> Because there is no coupling between GUI and the client/server >> architecture, however, you should avoid running updates outside the >> GUI. Please check out [1] for more information. >> >> Best, >> Christian >> >> [1] http://docs.basex.org/wiki/Startup#Concurrent_Operations >> >> >> >> > >> > Thanks, >> > Regards >> > Martin Lourduswamy > >

2 2

-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

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk