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

Reusing connections to BaseX
by Godmar Back 16 Feb '12

16 Feb '12

Hi, I have a question about the BaseX server. We're using it from a J2EE application (which is the client), and so we've implemented a connection pool in the style done by many other database drivers. We are getting Broken Pipe errors, indicating that a connection has been disconnected. My question: when does BaseX disconnect, and is there a way for a client to learn this? For instance, if there's a syntax error in a XQUERY, should BaseX disconnect? If a BaseXException is thrown by the Java driver? Currently, we mark the connection as dead when an IOException or EOF occurs during the handling of one request, but we keep it alive when a BaseXException occurs, such as when we submit an ill-formed XQUERY. We could avoid pooling, connecting and disconnecting for every query, but obviously that would be expensive. Or we could "ping" the server before issueing the actual query, but that's awkward, too. How do others handle this problem? - Godmar

4 4

XML could not be parsed - DOCTYPE
by Johann LEGAYE 15 Feb '12

15 Feb '12

Hello everyone ! Can someone tell me why BaseX could not parse my xml ? "ICN-A350-A-291157-A-FAPE3-00015-A-001-01.CGM" in the doctype could not be parsed.... <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE dmodule [ <!NOTATION cgm PUBLIC "-//USA-DOD//NOTATION Computer Graphics Metafile//EN"> <!ENTITY ICN-A350-A-291157-A-FAPE3-00015-A-001-01 SYSTEM "ICN-A350-A-291157-A-FAPE3-00015-A-001-01.CGM" NDATA cgm> ]> <xmlContent> .... </xmlContent> Thank you !

3 2

(Tip) Saxon-CE, Presentation of XML data
by Eric Murphy 15 Feb '12

15 Feb '12

Hello all, I wanted to pass on a tip about using XML data client-side (in a web browser) with Saxon-CE as it could be quite exciting to pair up with BaseX. Saxon-CE is a game-changer in my opinion when it comes to how to display XML data. http://www.ibm.com/developerworks/library/x-healthcaresaxon/ http://www.xmlprague.cz/2011/files/xmlprague-2011-proceedings.pdf (Page 125) http://saxonica.com/ce/doc/samples/intro.xml (Sample applications) I found the sample applications quite shocking in their elegance and simplicity. It would be worth your time to check them out. Regards, Eric

2 1

BaseX@Debian Processing of basex_7.1-1_amd64.changes
by Alexander Holupirek 15 Feb '12

15 Feb '12

BaseX 7.1 is now available in Debian's unstable branch. In 10 days it'll will move to testing. Ubuntu has an automated process and will fetch the package from Debian. Cheers, Alex Begin forwarded message: > From: Debian FTP Masters <ftpmaster(a)ftp-master.debian.org> > Subject: Processing of basex_7.1-1_amd64.changes > Date: 15. Februar 2012 00:39:41 MEZ > To: alex(a)holupirek.de > > basex_7.1-1_amd64.changes uploaded successfully to localhost > along with the files: > basex_7.1-1.dsc > basex_7.1.orig.tar.gz > basex_7.1-1.debian.tar.gz > basex_7.1-1_all.deb > > Greetings, > > Your Debian queue daemon (running on host franck.debian.org)

1 0

Recursive query performance
by Charles Duffy 15 Feb '12

15 Feb '12

Howdy, all -- First, a note that bears saying -- I'm very, *very* excited by BaseX; this is my first use of the database, and I'm already extremely impressed. My immediate use case centers around the following pair of functions: declare function local:immediate_requirements($e as element(project)) as element(project)* { doc("inventory.xml")/report/project[ ./classifiers/ivy/publications/artifact/@name = $e/classifiers/ivy/dependencies/dependency/@name ] }; declare function local:requirements($e as element(project)) as element(project)* { let $direct := local:immediate_requirements($e) return $direct | $direct/local:requirements(.) }; However -- while evaluating immediate_requirements() is very fast (on the scale of 72ms for one of the larger project elements in my sample corpus, and a total under 1600ms ms to evaluate for _every_ project element in said corpus), evaluating the recursive requirements() function for even a single top-level project can require as much as two minutes to execute. Should I be writing this function differently? My expectation was that, due to XQuery's functional nature, the database should be able to avoid needing to evaluate local:immediate_requirements more than once for a single input element, capping the worst-case execution time not far over the cost of evaluating that single-stage evaluation once over every possible project element in the document; however, true worst-case execution time is obviously far worse. Thank you very much for any guidance on offer, and for this excellent tool.

2 1

index features
by Cerstin Mahlow 14 Feb '12

14 Feb '12

Hi, I have three questions concerning working with the full-text index: The first question is about "distance" information. Given this query: (1) 'contains text "Kopf Sand Stecken" all words using stemming using language "de"' There is no difference to: (2) 'contains text ("Nase" ftand "Sand" ftand "stecken") using stemming using language "de"' both queries deliver 4 nodes. If I would like to find the query terms within a certain distance, adding 'distance at most 10 words' for (1) I get 2 nodes (a subset of the 4 from the first run), but for (2) I still get all 4 nodes. The information concerning distance doesn't seem to be considered. For my application this is no problem, since I have to go for the "ftand"-variant to get proper marking, but in general this looks strange. The second question is about "ftand" and "ftor". If I try these queries: (3) 'contains text ("Nase" ftand "Sand" ftand "stecken") using stemming using language "de" distance at most 10 words' (4) 'contains text ("Kopf" ftand "Sand" ftand "stecken") using stemming using language "de" distance at most 10 words I get 2 hits for (3) and 11 for (4). So I assumed I would get 13 hits (the ones from (3) and the ones from (4) when changing the query to: (5) 'contains text (("Nase" ftor "Kopf") ftand "Sand" ftand "stecken") using stemming using language "de" distance at most 10 words' However, I get 6 hits -- none of them containing "Nase" (there is no difference, if the query starts with '"Nase" ftor "Kopf"' or with '"Kopf" ftor "Nase"'). Did I mess something up? The third question is about the full-text index itself. When applying fuzzy search or using wildcards, the full-text index is not applied -- resulting in a time out on my website, I need 341859.09 ms in the GUI for applying 'ft:mark (//*[text() contains text ("Korb" ftand "geben") using fuzzy][self::*:p or self::*:l])' to my 3 GB collection. The information at the "Full-Text" tab says: - Structure: Trie - Stemming: ON - Case Sensitivity: ON - Diacritics: ON - Language: German - Size: 1 GB - Entries: 1743744 I created the full-text index with the option "Support Wildcards", too, but this information is not shown in the Database properties. When creating the index, "SET WILDCARDS true" is shown. I used stemming, casesensitivity, diacritics, and wildcards -- is this an unrecommended combination? Thank you very much in advance Cerstin -- Dr. phil. Cerstin Mahlow Universität Basel Deutsches Seminar 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 ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.

2 6

Back to work
by Christian Grün 14 Feb '12

14 Feb '12

Dear all, we've just returned from the XMLPrague conference, and it has been a great experience to talk to some of you live! Michael has written a blog entry, which summarizes some of the impressions: http://micheee.github.com/blog/2012/02/13/basex-xml-prague/ For those of you who were wondering about our slow feedback.. Be prepared to get your feedback soon, Christian PS: Similar to last year, there will be a minor 7.1.1 stability update, resulting from the feedback we've got so far. ___________________________ BaseX Team Christian Grün Uni KN, Box 188 D-78457 Konstanz http://www.basex.org

1 0

Problem with "create database"?
by Isidre Guixà 14 Feb '12

14 Feb '12

Hello! I see the command "create database" creates a database although there is another with the same name, destroying the existing one. I think that this is not normal... I've tested using the option in the GUI and also using Java client (method create in BaseXClient.java) Thanks, Isidre

2 1

gui vs. server
by Cerstin Mahlow 13 Feb '12

13 Feb '12

Hi, when displaying search results, I would like to show more or less following and preceding nodes depending on the fond node name. This works fine in the GUI using this XQuery: for $i at $p in //*[text() contains text ('Kopf' ftand 'Sand' ftand 'stecken')][self::*:p or self::*:l] let $pre := $i/preceding-sibling::*[position()<8] let $suc := $i/following-sibling::*[position()<8] return <div> {if (string(fn:node-name($i)) = "l") then $pre else "P"} {ft:mark($i [text() contains text ('Kopf' ftand 'Sand' ftand 'stecken')]) } {if (string(fn:node-name($i)) = "l") then $suc else "P"} </div> For "l"-nodes I get preceding and following nodes, for "p" nodes the "P" will be printed. However, when running the same on the server using a perl client (applying quoting for variables), I get the "P" for p-nodes but nothing for "l"-nodes. The conditional expression is correct, if I replace then $pre with then <p>LLL</p> everything works fine, "<p>LLL</p>" will be printed. If I skip the condition and allow preceding and following nodes for every $i, I get preceding and following nodes for "p"-nodes only, but not for "l"-nodes -- there is simple nothing. Is there any difference between GUI and Server? I use BaseX 7.1 beta, but I got the same effect with the BaseX 7.1 stable. Best regards Cerstin -- Dr. phil. Cerstin Mahlow Universität Basel Deutsches Seminar 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

1 1

Problem in GUI BaseX 7.1
by Isidre Guixà 13 Feb '12

13 Feb '12

Hello I see the GUI 7.1 does not allow add and remove documents!!! I attach images clearer Thanks! Isidre

2 1