BaseX-Talk

basex-talk@mailman.uni-konstanz.de

1 participants
5252 discussions

Recursive query performance
by Charles Duffy 14 Feb '12

14 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

Problem with XMLDB in BaseX 7.0.2 and 7.1.1
by Isidre Guixà 11 Feb '12

11 Feb '12

Hello I'm trying examples XMLDB to access BaseX and none of the 3 (XMLDBCreate, XMLDBInsert, XMLDBQuery) work ok. All have the same error: Exception in thread "main" java.lang.AbstractMethodError: org.basex.api.xmldb.BXDatabase.getNames()[Ljava/lang/String; at org.xmldb.api.DatabaseManager.registerDatabase(Unknown Source) at proves.XMLDBCreate.main(XMLDBCreate.java:31) I tried it in 7.0.2 and 7.1.1 versions. Is there any solution? I found the same error reported on March 2011 for BaseX users and the response of Michael Seiferlein https://mailman.uni-konstanz.de/pipermail/basex-talk/2011-March/001395.html I am a Catalan teacher of computer science and I am writing a book on native XML DB access, among other products, and I intend to submit the BaseX local API and also XMLDB and XQJ. For the moment, it seems XMLDB is not possible? Kind Regards, Isidre Guixà

2 2

letting you wait
by Christian Grün 11 Feb '12

11 Feb '12

Hi everyone, thanks for all the great feedback reg. BaseX 7.1 - and sorry for the pending questions in the list, which will be answered as soon as we're back from XMLPrague. All the best, Christian

1 0

Collections and Documents
by J Gager 08 Feb '12

08 Feb '12

Hello BaseX Team, In reading the documentation and mail archives, it seems to me that BaseX does not support documents in terms of having a single URI referring to a single document node. For example, if I add a document using the db:add function: db:add("DB", document { <a/> }, "doc.xml") And subsequently attempt to retrieve it using the doc function: fn:doc("doc.xml") I get a FODC0002 error. This is discussed in the mail archives, and so far as I can tell this is because BaseX only works with collections. It does not really address the concept of a documents (excuse me if I am over simplifying the issue here). In other words, I am free to add more document nodes under the name "doc.xml" therefore it is technically a collection as opposed to a document. Is this correct? A fairly early mailing list thread from 2010-07 addresses a similar and suggests an alternative approach where one might retrieve a document in a collection as follows: for $doc in collection('DB') where matches(document-uri($doc), 'doc.xml') return $doc But, doesn't this run afoul of the W3C recommendation which states for the fn:docucument-uri function that: "In the case of a document node $D returned by the fn:doc function, or a document node at the root of a tree containing a node returned by the fn:collection function, it will always be true that either fn:document-uri($D) returns the empty sequence, or that the following expression is true: fn:doc(fn:document-uri($D)) is $D. It is implementation-defined whether this guarantee also holds for document nodes obtained by other means, for example a document node passed as the initial context node of a query or transformation." In other words, if document-uri is returning 'doc.xml' for a node in collection('DB') then I should be able to get that same document node using the doc function. I ask these questions because we are interested in being able to maintain XML artifacts as singular documents, and using the collection hierarchy to do things such as storing temporary and archived version of these artifacts. The approach we are taking right now assumes that there is only one document-node under each 'document'. I want to understand the limitations of the collection and document implementation in BaseX so that I don't make any wrong assumptions (as I think I already have). Finally, assuming the interpretations are correct, are there plans to make any changes in the implementation to support something more in line with the hierarchy of db->collection->document? I have seen in previous threads that you were seeking feedback on this, and I am curious to know if you still are. Is there a major drawback you see to this model that perhaps I have not considered? Any feedback is appreciated. Thanks, Jack Gager Metadata Technology

2 4

BaseX has been updated on Filecluster.com
by FileCluster Support 08 Feb '12

08 Feb '12

Dear Developer, You have received this email because we have updated BaseX and this was the contact email for the application. Your application update status BaseX has been updated on FileCluster.com to the 7.1 version. You can check out your application on our site at: http://www.filecluster.com/Business-Office/Database-Management/Download-Bas… If you want to let your users know about your software page on FileCluster.com, to rate it and review it, you can also use this banner to link it: Promote your software As a software website, it`s our duty to help the developers promote their software. Fortunatelly, our software promotions are cost free, for more informations please visit our promotion page. Submit your press releases We are also accepting press releases from software developers. All you have to do is to submit your press release and we will take care of the rest. Useful developer links All the essential links you need as a developer on FileCluster.com: Link to us - download banners or text links for linking to FileCluster.com Submit your software - Submit your software via PAD or manually Submit your press release - submit your press releases using our online form Contact Us - contact our editors Promote your software - our promotions page If you do not wish to receive any further notifications or confirmations from FileCluster.com, please send us an email and request a contact removal (email removal). Keep in mind that this means you will not receive ANY contact from us, including: software promotions, update confirmations or security alerts (antivirus and spyware test results). Regards, Renta Cezar - Senior Editor FileCluster Labs www.filecluster.com

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk