BaseX-Talk

basex-talk@mailman.uni-konstanz.de

1 participants
5252 discussions

xquery help
by Cerstin Elisabeth Mahlow 26 Mar '13

26 Mar '13

Hi, I got stuck with an XQuery, could you please help? I have data like this: <collection> <entry> <q>[text() contains text ('Johann' ftand 'Ballhorn') distance at most 5 words ordered][self::*:p or self::*:q]</q> <id>12345</id> bey welchen die Verbesserungen durch Johann Ballhorn öfter vorkommen als man glauben sollte. </entry> <entry>… </collection> All I want to get back is the node with the content of the <q> node applied to using ft:mark, i.e., the node with highlighting like this: bey welchen die Verbesserungen durch Johann Ballhorn öfter vorkommen als man glauben sollte. But I don't manage to call ft:mark with the correct parameters. I tried variants of this: for $i at $p in //entry let $q := $i/q return ft:mark($i $q) But this gives Expecting closing bracket for 'ft:mark(…' I think I have to use concat() in some way, but how? Thanks in advance Cerstin -- Dr. phil. Cerstin Mahlow Universität Basel Departement Sprach- und Literaturwissenschaften Fachbereich Deutsche Sprach- und Literaturwissenschaft Nadelberg 4 4051 Basel Schweiz Tel: +41 61 267 07 65 Fax: +41 61 267 34 40 Mail: cerstin.mahlow(a)unibas.ch Web: http://www.oldphras.net

2 2

[GUI] Properties window is frozen for a DB with a lot of documents
by Fabrice Etanchaud 26 Mar '13

26 Mar '13

Dear all, When dealing with collections containing more than a million documents, The Properties window freezes the entire GUI while trying to display the documents' list. How could I disable the treeview for such collections ? I have to deal with such collections because XQuery Update on many many nodes takes a long long time to complete, So add/replace/delete is a good alternative. Thank you for your continuous help and your great XNDB. Last : is the new ADDCACHE option the way to add data near the node count limit without corrupting the collection ? Best regards, Fabrice Questel-Orbit

3 4

Ask about AlterDB
by truc.cam＠emotive.de 26 Mar '13

26 Mar '13

Dear BaseX team, I want to ask you how to use the class AlterDB to change a database name. It always throws the exception DB_PINNED_X although I use "unpin" before using AlterDB. I found the problem is that the method TableDiskAccess.locked(db, this) always returns "true". Please see the attachment and help me solve the problem. Thanks in advance.

2 10

Re: [basex-talk] BaseX start up questions
by Christian Grün 25 Mar '13

25 Mar '13

> Time to open: 2288 ms > Used memory: 206 MB That’s quite unusual. Here is what I get for an exemplary database with 700 MB of input data and 85.000 documents: Time needed: 18.48 ms Used Memory: 11 MB Maybe it’s due to the updatable index? What do you get if you set UPDINDEX to false? Best, Christian

1 0

Config file and data dir (with BaseXServer in Java)
by Florent Georges 25 Mar '13

25 Mar '13

Hi, When I start a BaseXServer in Java, it creates a config file ~/.basex and a data directory ~/BaseXData. Is there any way to ask BaseX not to create the config file, and to use a specific another data directory? Or at least to tell it where to look for the config file (instead of going to ~/.basex)? I couldn't find either in the documentation. Regards, -- Florent Georges http://fgeorges.org/ http://h2oconsulting.be/

4 8

Re: [basex-talk] BaseX start up questions
by Christian Grün 25 Mar '13

25 Mar '13

Hi Erik, > For testing I created a single database with only 1000 documents > (about 800 KB each) and noticed that memory consumption was around 250 > MB in the GUI tool as soon as I opened the database. to get the real memory consumption, please click on the memory indicator in the lower right corner of the GUI. Next, you can deactivate the visualizations to save some additional memory. > I also noticed that it will take around 1 second to open the database > which could become a problem because I want to use BaseX as the > backend database for a RESTless service where state is not preserved > between HTTP requests. Do you refer to the time that’s required by the GUI, or more low-level calls? Best, Christian

1 0

BaseX Server RestXQ total beginners example
by zanzinger＠alice-dsl.de 25 Mar '13

25 Mar '13

Dear BaseX-Community, I try to access my BaseX-Database or Collection over the Web-Interface. This is what I´ve done so far: 1) Installed Jetty und started it. 2) Downloaded the BaseX76.war, extracted it to the folder BaseX76 and placed the folder in the Directory "<user>/jetty/webapps". 3) Now I started my Browser (Safari) and went to "http://localhost:8080" => Ok, the jetty-Startpage on my local web server is shown. 4) Now on the Browser, I navigate to "http://localhost:8080/BaseX76/" => OK, the Welcome-Page of baseX-Http-Services is shown. On this page, I click on the link "RestXQ and I get the Page "Welcome to the RestXQ-Service" which has the path "<user>/jetty/webapps/BaseX76/restxq/restxq.xqm". The examples HelloWorld and HelloUniverse give the right responses. 5) I modified the response of the POST-Handler (form) to find out, if this is the right place to do such things: (This is the modified content:) -------------- declare %restxq:path("form/") %restxq:POST %restxq:form-param("message","{$message}", "'no message delivered'") function page:hello-postman($message as xs:string) { let $ZaVar := 'Dies ist Dieter' let $ZaVar2 := ' und dies ist Anne' return <response> <title>Hello!</title> <info>It seems you posted a message: { $message }</info> <Za> Dies ist mein Text in Zrestxq und { $ZaVar } { $ZaVar2 } </Za> </response> ---------------- => my changes are given as response when I click on the Button of the "Welcome to the RestXQ-Service" page. So far, everything works. 6) My question is now: a) How do I access my local BaseX-Database (named "ZaTest", which I created and queried successfully by use of the BaseX-Gui? b) Are there examples or does anybody give me an advice, which settings in the jetty-preferences-files I do have to change, or what text I do have to put into the file "<user>/jetty/webapps/BaseX76/restxq/restxq.xqm". c) Where (which Filepath) do I have to place the Database-Folder "ZaTest", which I created with the Gui? d) If I have to connect or open or close the database - how is this done with the restxq-Interface (please example(s)). ------- Thanks in advance. I think, this is a real beginner´s example for people like me, which are very new to jetty and baseX, as well to restxq. I searched all documentation, but didn´t find, what I needed. Sincerely Dieter Zanzinger zanzinger(a)alice-dsl.de

2 1

BaseX start up questions
by Erik F. Andersen 25 Mar '13

25 Mar '13

Hello all, I'm considering BaseX for a project of mine but before I go any further I have a few questions. First some facts: - I need to store up to perhaps 50.000 documents in each database (collection) at about 1MB in average size. - One database will be queried of up to 5 users at a time on average, each one issuing 50 times more reads than writes. I would say perhaps 50 rather simple reads (queries) a minute (most queries will be done against a single document at a time). - Ideally each server should host up to 50 such databases. Now to my questions: 1) Will the number of databases have a performance hit (degredation) on the system as a whole other than that caused be the extra number of concurrent users? 2) Can I expect a performance hit on a given database related to the number of concurrent users on that database, even if those users are mostly quering different documents? 3) Will the number of documents in a given database have a performance hit on queries done against that database? 4) Are there any limitations in BaseX that I should possibly be aware of? I would also like to know what my options are for backing up the databases (preferably while in use), and what I can do to repair a database if a document somehow become corrupted due to a software malfunction? Finally I would like to hear if BaseX is being used for other critical applications other than mine where stability and fast response times is essential? Thank you for your time, Regards Erik

2 1

Old EQName syntax
by Florent Georges 24 Mar '13

24 Mar '13

Hi, The wiki page at http://docs.basex.org/wiki/Java_Bindings contains the following example: Q{java:java.lang.Math}cos(xs:double(0)) which if I am right is the old syntax for EQNames, which should be now: "java:java.lang.Math":cos(xs:double(0)) Just in case. Regards, -- Florent Georges http://fgeorges.org/ http://h2oconsulting.be/

2 2

replace value vs. insert node
by Cerstin Elisabeth Mahlow 24 Mar '13

24 Mar '13

Hi, in terms of performance, is it cheaper to update the value of an existing node or to insert a node with that value? I'm not sure if I should create empty nodes or nodes with a default-value in the first place and when users specify values these nodes will be updated. Or if I insert nodes with these values when users specify them in the web interface. Values are short texts like "yes" or "no". The value of the one node I have to update in any case is a longer text with some markup in it (for highlighting purposes of single tokens). UPDINDEX for the DB is set and I will have to optimize the index after each user interaction, because I need the fulltext index in the next interaction. So the options are actually these: - insert 6 nodes, replace value of 1 node, optimize - replace values of 7 nodes, optimize Thanks in advance and best regards Cerstin -- Dr. phil. Cerstin Mahlow Universität Basel Departement Sprach- und Literaturwissenschaften Fachbereich Deutsche Sprach- und Literaturwissenschaft Nadelberg 4 4051 Basel Schweiz Tel: +41 61 267 07 65 Fax: +41 61 267 34 40 Mail: cerstin.mahlow(a)unibas.ch Web: http://www.oldphras.net

2 1

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk