BaseX-Talk

basex-talk@mailman.uni-konstanz.de

5 participants
5249 discussions

Performance problem
by Nuria Garcia 20 Feb '13

20 Feb '13

We are testing basex to use with a huge database, and we have a performance problem. At the moment we have two small databases with thousands of documents to test: · Authors, 2.000 documents, 2MBs aprox. · Books (3 per author) with 6.000 documents, 5MBs aprox. We need join and group results, and this takes a long time: Query: <result>{for $Author in (db:open('Authors')//businessEvent), $Book in (db:open('Books')//businessEvent) for $income in distinct-values($Author//author/country) where $Author//author/idauthor=$Book//book/idauthor group by $income return <line><label>{ $income }</label><data>count($Book )</data></line>}</result> Compiling: - rewriting where clause to predicate(s) - pre-evaluating db:open("Authors") - simplifying descendant-or-self step(s) - pre-evaluating db:open("Books") - simplifying descendant-or-self step(s) - simplifying descendant-or-self step(s) - swapping operands: descendant::*:book/*:idauthor = $Author/descendant::author/idauthor - simplifying descendant-or-self step(s) - simplifying descendant-or-self step(s) Result: element result { for $Author in (document-node { "1" }, document-node { "2" }, ...)/descendant::*:businessEvent for $Book in (document-node { "1-1" }, document-node { "1-2" }, ...)/descendant::*:businessEvent[descendant::*:book/*:idauthor = $Author/descendant::author/idauthor] for $income in fn:distinct-values($Author/descendant::author/country) group by $income := $income return element line { element label { $income }, element data { "count($Book )" } } } Timing: - Parsing: 1.01 ms - Compiling: 3.99 ms - Evaluating: 100725.38 ms - Printing: 0.37 ms - Total Time: 100730.77 ms We have no idea why it’s taking so long time to show the results. If we don’t group results it takes a long time too. Regards, Nuria

2 3

basex docs - bulk export?
by Colin McEnearney 20 Feb '13

20 Feb '13

Hi, Is there a way to bulk export the basex docs wiki? Or, if it is backed by a db, get a dump of it? Travelling offline and would love to have access (the built-in pdf creator seems nice but not for getting *everything*) Many thanks, Colin

4 7

can't change password in basex web app
by marco fregonese 18 Feb '13

18 Feb '13

Hello everybody, I'm trying to change the default user name and password in basex web app. I changed the param-value in WEB-INF/web.xml but when deployed in Tomcat or using as standalone application by running BaseX HTTP Server, the web app is still requiring as user name and password "admin", "admin". What am I doing wrong? <context-param> <param-name>org.basex.user</param-name> <param-value>myusername</param-value> </context-param> <context-param> <param-name>org.basex.password</param-name> <param-value>mypassword</param-value> </context-param> Thanks.

2 3

problem keeping basexserver as an alive service
by Richard Alexander Castro Mamani 18 Feb '13

18 Feb '13

Hello, I am having problems keeping the basexserver service alive, you see every time I active the service it works for a couple of hours and then it just stops and I the application cannot connect to the database. It is very inconvenient to keep on typing the following command every time to active the service. richard@0113:~$ basexserver BaseX 7.0.2 [Server] Server was started. Could you tell me what I am doing wrong?. I installed it without any inconvenient but now I don't know how to solve this issue. Thanks in advance for any answer. Greetings Richard -- Br. Richard Castro http://unsaac.academia.edu/RichardAlexanderCastroMamani Grupo de Investigación Hinantin UNSAAC skype: richardtk_1 rcastro(a)hinantin.com http://hinantin.unsaac.edu.pe

3 3

WebDAV Locking of BaseX Source on Tomcat
by Sean Healy 17 Feb '13

17 Feb '13

BaseX 7.6 Tomcat 7 Oxygen Editor 14 Ubuntu 12.10 We would like writers to edit BaseX source via WebDAV and require level 2 WebDAV conformance (locking). We have uncommented: ... <servlet> <servlet-name>WebDAV</servlet-name> <servlet-class>org.basex.http.webdav.WebDAVServlet</servlet-class> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>WebDAV</servlet-name> <url-pattern>/webdav/*</url-pattern> </servlet-mapping> … within .../tomcat7/webapps/bxApp/WEB-INF/web.xml. The class org.basex.http.webdav.WebDAVServlet does not seem to implement low-level, server-side methods such as LOCK. To verify that locking is possible with our toolset, we followed this generic Tomcat/WebDAV tutorial (http://www.mulesoft.com/tomcat-webdav). Tutorial's web.xml: <?xml version="1.0" encoding="UTF-8"?> <web-app ... <display-name>Tomcat webDAV TEST 1</display-name> <description>webDAV HTTP Services</description> <servlet> <servlet-name>webdav</servlet-name> <servlet-class>org.apache.catalina.servlets.WebdavServlet</servlet-class> <init-param> <param-name>debug</param-name> <param-value>0</param-value> </init-param> <init-param> <param-name>listings</param-name> <param-value>true</param-value> </init-param> <init-param> <param-name>readonly</param-name> <param-value>false</param-value> </init-param> </servlet> <servlet-mapping> <servlet-name>webdav</servlet-name> <url-pattern>/webdav/*</url-pattern> </servlet-mapping> <security-constraint> <web-resource-collection> <web-resource-name>myApp</web-resource-name> <url-pattern>/*</url-pattern> <http-method>PROPFIND</http-method> <http-method>PROPPATCH</http-method> <http-method>COPY</http-method> <http-method>MOVE</http-method> <http-method>LOCK</http-method> <http-method>UNLOCK</http-method> </web-resource-collection> </security-constraint> <security-role> <description>WebDAV User</description> <role-name>webdav</role-name> </security-role> </web-app> The tutorial demonstrated for us that locking is possible. What is the relationship/interaction between org.apache.catalina.servlets.WebdavServlet, with its full compliment of methods, and org.basex.http.webdav.WebDAVServlet? Or more to the point, how should web.xml within our BaseX servlet be configured within for webDAV on Tomcat? Does org.basex.http.webdav.WebDAVServlet even enter into the equation for our use (e.g., locking). An example web.xml would be much appreciated. Also, is authentication for WebDAV using credentials from .../tomcat/config/tomcat-users.xml (as in the tutorial), from .basexperm, or from some other source? Thank you in advance for your help. Sean

2 1

Call for papers, XML London 2013
by Charles Foster 16 Feb '13

16 Feb '13

Calling all BaseX and XML aficionados. The XML London 2013 conference takes place on 15/16th June 2013 at University College London. We are looking for speakers for this event. Speakers go for free. Call for papers is open and closes 15th March. Submissions do not HAVE to be final papers by that date, extended abstracts which succinctly describe the contents of a final paper will suffice. If successful, final / polished papers will need to be completed by 15th May. The conference has themed topics. However, papers of outstanding quality or novelty are ALWAYS welcome at XML London, regardless of whether they fit into any of the conference theme topics. The conference theme topics are as follows: Applied XML Real life use cases of where XML technologies have been beneficial. Document Databases The future of search across structured and unstructured data. Financial Markup The role of XML in finance and trading. Semantic Web XML working with Linked Data, Ontologies, Topologies, Graphs. Teaching XML XML tech is cool, why so? what can it do for people who are not using it? XML Elephant Coping with and processing huge volumes of XML and Big Data effectively. XML Librarian Publishing content to books, the web and a world of gadgets. For more information, please visit the XML London website: http://xmllondon.com Regards, Charles XML London

1 0

Lassen Sie uns Suche nach der Wahrheit für ein besseres Leben.
by Administrator 15 Feb '13

15 Feb '13

1 0

path index does not seem to be used
by Fabrice Etanchaud 14 Feb '13

14 Feb '13

Dear all at BaseX, In a indexed database, Query info shows that a request like Count(/a/b/c) does not use the statistics data available with index:facets(). Could you please tell me if this is really the case, and if there is a way to tell BaseX to use it ? Best regards, And thank you for your great XNDB ! Fabrice Here is the query : Query: declare namespace exch = 'http://www.epo.org/exchange'; count(/exch:exchange-documents/exch:exchange-document) Query plan: <QueryPlan> <FNAggr name="count(item)"> <IterPath> <DBNodeSeq size="38"> <DBNode name="DOCDB_RU" pre="0"/> <DBNode name="DOCDB_RU" pre="4198620"/> <DBNode name="DOCDB_RU" pre="7369614"/> <DBNode name="DOCDB_RU" pre="11083006"/> <DBNode name="DOCDB_RU" pre="15423603"/> </DBNodeSeq> <IterStep axis="child" test="exch:exchange-documents"/> <IterStep axis="child" test="exch:exchange-document"/> </IterPath> </FNAggr> </QueryPlan> Here is the db:info() : <database> <databaseproperties> <name>DOCDB_RU</name> <size>3391 MB</size> <nodes>135589551</nodes> <documents>38</documents> <binaries>0</binaries> <timestamp>2013-01-29-23-16-31</timestamp> </databaseproperties> <resourceproperties> <inputpath>C:/data/work/docdb/RU</inputpath> <timestamp>2012-12-28-06-53-45</timestamp> <encoding>UTF-8</encoding> <whitespacechopping>ON</whitespacechopping> </resourceproperties> <indexes> <uptodate>true</uptodate> <textindex>ON</textindex> <attributeindex>ON</attributeindex> <fulltextindex>OFF</fulltextindex> <updindex>ON</updindex> <maxcats>10000</maxcats> <maxlen>96</maxlen> </indexes> </database>

3 4

XMLPrague: Talks and Slides
by Christian Grün 13 Feb '13

13 Feb '13

Dear subscribers, it was great to see and talk to many of you at the XMLPrague conference! The slides of most talks are now available online: http://files.basex.org/xmlprague2013/ Video clips of the presentations are in process and will be added soon. Have fun, Christian

1 0

access to dom representation of result in server mode or with xqj
by Fabrice Etanchaud 13 Feb '13

13 Feb '13

Dear all at BaseX, Is there a way to gain access the dom representation of a query result in server mode, or with xqj ? (in simple words, could a client side parser work directly on the internal server representation, for example by returning a 'eventified' serialization of the result ?) Thank you for your wonderful NXDB ! Best regards, Fabrice

2 1

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk