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

Timezone and job start time
by Kendall Shaw 28 Jul '17

28 Jul '17

declare namespace tz = "java:java.time.ZonedDateTime"; tz:now() returns 2017-07-28T14:23:08.334-07:00[America/Los_Angeles] Logs in dba seem to use the local time zone to display the date. The timestamp on resources is in UTC time, which is good. modified-date=”2017-07-28T21:17:53.347Z” But, do I have to use UTC time for scheduling jobs? For example: job:eval(‘…’, map {}, map {‘start’: ‘20:00:00’}) schedules the job for 5AM instead of 10PM, I think. If I can assume the time is UTC then I can figure out how to schedule the correct time. But, can I assume that it is UTC, or can I specify a Zoned time without a date? Kendall

1 0

BaseX 8.6.5
by Christian Grün 28 Jul '17

28 Jul '17

Hi all, We have just released another version of our XML DBMS. The XQuery compiler of BaseX 8.6.5 provides some performance tweaks to improve typing of pre-evaluation expressions and, as usual, minor bug fixes. Visit basex.org to get the latest update. Your feedback is welcome. Have fun and a nice weekend, Christian

1 0

org.basex.http source code and client-server mode
by Ignacio Hernandez-Ros 27 Jul '17

27 Jul '17

Hello, As this is my first post on the list I’ll introduce myself first. My name is Ignacio Hernandez-Ros (if you google my name there is only me and my son with that name…) and I’m from Madrid - Spain. About 15 years ago I learned about XQuery using “tamino” form Software-AG and now I’ve discovered baseX that looks amazing to me. I’ve been trying to configure the web administration portal to be used with a remote server with no success. It looks like it is not possible to take advantage of the client-server architecture from the Web Application http://docs.basex.org/wiki/Web_Application <http://docs.basex.org/wiki/Web_Application> I would like to know more about how the org.basex.http.restxq.RestXqServlet works and looking at the source code on GitHub I’m missing the org.basex.http package so I cannot see how can I improve it to allow it to connect to an existing server. I will appreciate any hint on how can I continue, either about where the source code is and how to contribute to it or how to set the WebApplication to run under client-server mode Best regards Ignacio

3 5

Re: [basex-talk] Join operation and the database
by Christian Grün 27 Jul '17

27 Jul '17

Hi Giuseppe, > If I compare values just using one indexed string (the one in @v), this is the fastest way (about one second on my machine). It depends on the value you are looking for. If it only occurs once in your database, the lookup will be very fast (in database terms, this is called a “high selectivity”). > If I compare against two distinct indexed values, their order matters, in that -if I understand correctly- the database uses the index only(?) for the first values. Exactly. You can enforce index access by directly using db:text(). > I see that [p = $t/@o and f = $t] is much slower than [f = $t and p = $t/@o]. I calculated that on average f contains about 8 characters while p always contains 9. However, (Ancient Greek) characters in f are heavier ( 2 or 3 bytes each) than the (Latin) ones in p (1 byte each). Can this be the reason why [f = $t and p = $t/@o] is evaluated faster? This doesn’t matter (as long as the string length does not exceed MAXLEN [1]). The critical question is how many index results you will get for a single lookup. See the following example: declare variable $txts := doc("tlg0001.tlg001.perseus-grc2.xml"); for $t in ($txts//t)[position() = 1 to 10] return ( "* " || $t/@o || ": " || count(db:text("splitted-db", $t/@o)), "* " || $t || ": " || count(db:text("splitted-db", $t)) ) The first lookup will return much more hits than the second one. You can call the following function to get a complete list of all index entries: index:texts('splitted-db') Cheers, Christian [1] http://docs.basex.org/wiki/Options#MAXLEN

1 0

Join operation and the database
by Giuseppe Celano 27 Jul '17

27 Jul '17

Hi, I performed join operations between many files and a dictionary. The files contain tokenized texts, where one finds word forms + fine-grained POS tags. Look at the following file: https://raw.githubusercontent.com/gcelano/POStaggedAncientGreekXML/master/t… <https://raw.githubusercontent.com/gcelano/POStaggedAncientGreekXML/master/t…> The dictionary, which contains word forms + fine-grained POS tags + lemmas, can be found here: https://github.com/gcelano/LemmatizedAncientGreekXML/tree/master/uniqueToke… <https://github.com/gcelano/LemmatizedAncientGreekXML/tree/master/uniqueToke…> I created a database for the dictionary and wrote a query (here simplified) like the following: for $t in $s/t (: t are the tokens in the file containing the tokens :) let $match := $lemm//d[./p = $t/@o and ./f = $t/text()] (: $lemm//d are the single entries in the dictionary :) return $match I see that if I use this query, it is slow, as if the processor cannot use the database indexes (./p and ./f). The situation does not seem to improve with ./p/text() and ./f/text(), which I would assume to be equivalent to the former because of atomization. On the contrary, if the same information contained in ./p and ./f are merged together and put in an attribute (see @v in the dictionary files) and this is compared against the values in the text (after concatenating them properly), the join operation is super fast (i.e., the index for the values in the attributes are used by BaseX). Does anyone know why? I have been able to get my results via the above (slow) comparison, but I would like to know what the cause of the problem was, if possible. Thanks. Best, Giuseppe Universität Leipzig Institute of Computer Science, Digital Humanities 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 4

Access output:media-type value from QueryProcessor
by Andrew Tsui 27 Jul '17

27 Jul '17

Hi, Is it possible to get the value of "output:media-type" through QueryProcessor? I am currently trying to use BaseX as a view renderer for a Spring MVC application. The view is rendering fine using embedded BaseX. However, I can't figure out how to get the "output:media-type" value from the XQuery so that I can set the response header during runtime. I can set the content-type through the controller in Spring. But I would rather not have to do it in two separate places. Below is the relevant code snippet from the view renderer. try(QueryProcessor proc = new QueryProcessor(query, context)) { Iter iter = proc.iter(); //response is HTTPServletResponse response.setContentType(????); try(Serializer ser = proc.getSerializer(response.getOutputStream())) { for(Item item; (item = iter.next()) != null;) { ser.serialize(item); } } } Any suggestion? Thanks Andrew

2 2

JSON to map
by Florian Wagner 19 Jul '17

19 Jul '17

Hey there, I'm probably missing something but please bear with my as I'm new to XML databases and XQuery. So what I've done is put JSON documents into BaseX using the REST interface and PUT requests. Now I want to use them in a RESTXQ handler. Loading the document using "db:open" will return me a document-node() but I'd like a map instead for simpler use and automatic types (I'll be outputing JSON again). The only thing I could come up with and that works is using "Content-Type: application/json;format=basic" when uploading and then: parse-json(xml-to-json(db:open(...))) But that seems very complicated and wasteful. Is there no other way? Regards Florian Wagner --- Universitaetsbibliothek Tuebingen Wilhelmstr. 32, 72074 Tuebingen IT-Abteilung, Raum B109 +49(0)7071/29-77860 http://www.ub.uni-tuebingen.de

2 1

Local permissions / REST / write permission needed
by Florian Wagner 19 Jul '17

19 Jul '17

Hi everyone! Trying out BaseX I'm having problems getting a very simple setup to work correctly. > list Name Resources Size Input Path ------------------------------------- test 2 33470 ~webdav 1 6004 2 database(s). > show users Username Permission -------------------- admin admin test none 2 user(s). > show users on test Username Permission -------------------- test write 1 user(s). $ curl -u test -i -X PUT -T file.xml http://host:8080/basex/rest/test/file.xml Enter host password for user 'test': HTTP/1.1 100 Continue HTTP/1.1 400 Bad Request Content-Type: text/plain;charset=utf-8 Content-Length: 24 Server: Jetty(9.3.9.v20160517) write permission needed. Using the "admin" user instead, works! Giving the test user global writer permissions makes it also work... So what am I doing wrong here? Regards Florian Wagner --- Universitaetsbibliothek Tuebingen Wilhelmstr. 32, 72074 Tuebingen IT-Abteilung, Raum B109 +49(0)7071/29-77860 http://www.ub.uni-tuebingen.de

2 4

Embedded BaseX
by George Sofianos 14 Jul '17

14 Jul '17

Hello, I'm building a web service that along with some other things (XML Validation, Saxon XQuery, etc) includes a BaseX processor for running XQuery scripts. I'm wondering what is the best way to use an embedded BaseX processor. Can some objects be shared (e.g Context, QueryProcessor), or are they very lightweight and there is no need to share / reuse ? Can I get the number of the jobs running and the job status like in the client / server mode? My intention is to make sure I can limit the amount of the jobs running in parallel, and have more control over the execution (maybe cancel jobs if necessary) Thanks, George

3 4

Re: [basex-talk] How could I get the current database name in xquery?
by Christian Grün 14 Jul '17

14 Jul '17

Hi Donald, Did you try db:name()? See our documentation for more information [1]. Christian [1] http://docs.basex.org/wiki/Database_Module Am 14.07.2017 8:12 vorm. schrieb "donaldjohn" <donaldjohn(a)qq.com>: > Hi, > How could I get the current database name in xquery? I need extract the > database input path and then concate it with the relative XML path, I want > to get the current opened database name rather than specify it. How could I > archive this? >

1 0