BaseX-Talk

basex-talk@mailman.uni-konstanz.de

6 participants
5269 discussions

Re: [basex-talk] error importing one million documents using console
by Patrick Schäfer 09 Jul '10

09 Jul '10

Hi Christian, > * Console: > open tuscreen > xquery //*:molecule[@*:id="11178"] Wow, thank you. That gave a huge boost in performance: for $i in //*:molecule[@*:id="298038"]/*:identifier[@*:convention="iupac:smile"] return <smile>{$i/@value}</smile> Takes 80ms now. But unfortunately it doesn't work for a query like: let $ids := (1 to 10) for $i in //*:molecule[@*:id = $ids]/*:identifier[@*:convention="iupac:smile"] return <smile>{$i/@value}</smile> Query executed in 3688.12 ms. So it still takes >3500 ms The Query execution plan is quite different I noticed: First Query: Result: element { "smiles" } { for $i in IndexAccess("298038", ATV)/self::*:id/parent::*:molecule/*:identifier[@*:convention = "iupac:smile"] return element { "smile" } { $i/@value } } Second Query: Result: for $i in IndexAccess("iupac:smile", ATV)/self::*:convention/parent::*:identifier[parent::*:molecule[@*:id = (1, 2, 3, 4, 5, 6, 7, 8, 9, 10)]] return element { "smile" } { $i/@value } So the second plan doesn't make use of the attribute index for locating the id-attributes. > Sorry, zu spät gesehen… Jederzeit ;) Je mehr Mails allerdings an die > Liste gehen, desto besser; dann bleiben auch die anderen auf dem > Laufenden. Dann antworte ich besser an die Liste ;) Patrick

2 2

full-text index available for attributes (is 'contains' applicable to attributes)?
by Patrick Schäfer 09 Jul '10

09 Jul '10

Hi, I wonder if the full-text index is also available to attribute nodes: XQuery-Expression: for $i in //*:identifier[contains(@*:value,'nc1n2[C@H]')] return $i Query executed in 4106.57 ms. I also tried: for $i in //*:identifier[@*:value contains text 'nc1n2[C@H]'] return $i Query executed in 22350.34 ms. The full-test was activated using the console: > create index fulltext Index created in 562.23 ms. > OPTIMIZE Database optimized in 27349.05 ms. > SET FTINDEX Full-Text Index: ON Thank you Patrick

2 1

Adding xml to an embedded database collection
by Charles F. Munat 08 Jul '10

08 Jul '10

Note: I am working in Scala. I want to be able to create new XML documents based on input from a Web-based form, then add them to a Collection in an embedded instance of BaseX programmatically. So if I have a collection called "Persons" and XML in memory thus: <person id="df802f63-f5b9-4b28-951e-aa2c8d7220dd"> <name>Chas</name> <gender>Male</gender> </person> (or as a String, if that's necessary -- Scala allows inline XML). I want this db stored not in my home directory, but in WEB-INF/db. So how do I use CreateDB(input, name) to create the db where I want it? What do I provide for the input? Must I have an XML file already? What is the relationship between that file and the DB, and how does this differ from a collection? Can anyone point me to a spot in the documentation where this is covered? All I can find are examples and they are confusing to me. Once I have a DB open (and maybe a collection), I want to add an XML document directly from code, thus: val xml = <person><name>Chas</name></person> or maybe val xml = "<person><name>Chas</name></person>" then Add(xml).execute(context) I've tried this but the XML disappears. How do I put this in the correct DB and collection? It seems pretty straightforward to use the console or the GUI, but the documentation on embedded use is pretty sparse. Is anyone else using BaseX in embedded mode? Is there documentation somewhere (or more examples) that I've missed? Thanks. I am thinking about using BaseX for persistence by converting objects to/from XML using XStream: http://xstream.codehaus.org/index.html Should be interesting. TIA, Chas.

2 5

Re: [basex-talk] BaseX-Talk Digest, Vol 7, Issue 6
by Patrick Schäfer 08 Jul '10

08 Jul '10

Hi Christian, thank you for the response. The error occurs every time I try to import the folder when using version 6.1. Using version 6.1.9 it doesn't throw an error but it just quits. INFO DB gives me: Database Properties Name: tu Size: 4546 Bytes Nodes: 1 Height: 0 Database Creation Source Path: /home/tuscreen/cml Time Stamp: 29.05.2010 08:02:54 Input Size: 0 Bytes Encoding: UTF-8 Documents: 1 Whitespace Chopping: ON Entity Parsing: OFF Indexes Path Summary: ON Text Index: ON Attribute Index: ON Full-Text Index: OFF Patrick > Patrick, > > thanks for your report. Have you managed to reproduce the bug (i.e., > has it occurred a second time?) As a shorthand, I'd suggest to try the > latest, stable version of BaseX, which you find at: > > http://www.inf.uni-konstanz.de/dbis/basex/maven/org/basex/basex/6.1.9/ > > Looking forward to your feedback, > Christian

2 1

error importing one million documents using console
by Patrick Schäfer 07 Jul '10

07 Jul '10

Hi, I am trying to import one million documents within a directory to basex using the console as described on the faq-page. The command I am using is: java -cp BaseX61.jar org.basex.BaseXClient -vc "create DB /home/tuscreen/cml tuscreen " Immediately after execution the server throws an exception: Exception in thread "Thread-6" java.lang.NullPointerException at org.basex.build.DiskBuilder.close(DiskBuilder.java:102) at org.basex.build.DiskBuilder.abort(DiskBuilder.java:88) at org.basex.core.Progress.abort(Progress.java:98) at org.basex.core.Proc.run(Proc.java:146) at org.basex.core.Proc.exec(Proc.java:109) at org.basex.server.ServerProcess.run(ServerProcess.java:128) When importing a small fraction of the data, everything works fine. Is there any way to import all documents? Thank you Patrick

2 1

Feature Requests
by Swaminathan S 06 Jul '10

06 Jul '10

Hi Christian, Please find below my feature requests: 1) Support constraints (xsd validation and user defined constraints (like support for database triggers)) 2) Transaction support - a rollback feature 3) CData declarations to be retained Thanks Swaminathan Sahiram

1 0

BaseX embedded
by Charles F. Munat 06 Jul '10

06 Jul '10

I'm working on a Maven web project and I'd like to use BaseX in embedded mode to store XML and XHTML documents. I've experimented with other databases in embedded mode, and generally I include a jar (hopefully via Maven, though not always), then I can use the API to create a session, create databases, collections, and documents, run queries, etc. I found the well-hidden Maven configuration to add Maven to the pom.xml file, but I am having a hard time finding any documentation or examples that show me how to use the API. The examples I have found use sockets to connect to a running instance of the database server. This is not what I had in mind. Is it the only way to use BaseX, or am I missing a more direct way? Thanks for clarification... Chas.

2 1

Reminder about your invitation from sayali Kulkarni
by sayali Kulkarni (LinkedIn Invitations) 06 Jul '10

06 Jul '10

LinkedIn ------------ This is a reminder that on June 21, sayali Kulkarni sent you an invitation to become part of his or her professional network at LinkedIn. Follow this link to accept sayali Kulkarni's invitation. https://www.linkedin.com/e/87foxj-gbacdcas-1u/doi/1401339739/ZCnLLJ4a/gir_8… Signing up is free and takes less than a minute. On June 21, sayali Kulkarni wrote: > To: [basex-talk(a)mailman.uni-konstanz.de] > From: sayali Kulkarni [sayalikulkarni7(a)gmail.com] > Subject: sayali Kulkarni wants to stay in touch on LinkedIn > > I'd like to add you to my professional network on LinkedIn. > > - sayali Kulkarni The only way to get access to sayali Kulkarni's professional network on LinkedIn is through the following link: https://www.linkedin.com/e/87foxj-gbacdcas-1u/doi/1401339739/ZCnLLJ4a/gir_8… You can remove yourself from sayali Kulkarni's network at any time. -------------- ------ (c) 2010, LinkedIn Corporation

1 0

Feature Requests?
by Christian Grün 05 Jul '10

05 Jul '10

Hi everyone, thanks for your continuous and diligent feedback on BaseX and its development. As we are currently rescheduling priorities for new features, we invite you to give us a summary, or list, of the features you'd want to have integrated most desperately in BaseX. There is always enough to do anyway. Don't hesitate to get visionary, or greedy, though; the more serious input we get, the better we'll be able to serve everyone's needs in future. All the best, Christian ___________________________ Christian Grün University of Konstanz Department of Computer & Information Science D-78457 Konstanz, Germany Tel: +49-7531-88-4449, Fax: +49-7531-88-3577 http://www.inf.uni-konstanz.de/~gruen

1 0

Passing java objects as XQuery parameters using XQJ
by Stefano Santoro 03 Jul '10

03 Jul '10

Hi, I am having trouble binding a java object to an XQuery external variable. Here is my simple java class: public class Provami { private int items; private String name; public Provami() { } public Provami(String name, int items) { this.items = items; this.name = name; } public String getName() { return this.name; } public void setName(String name) { this.name = name; } public int getItems() { return this.items; } public void setItems( int items) { this.items = items; } } and here is my XQuery sample declare namespace provami = "java:Provami"; declare variable $bar as xs:anyAtomicType external; let $foo := provami:new() return element a { element i {provami:setName($foo, 'nome'), provami:getName($foo)}, element i {provami:getName($bar)} } I have tried two approaches with XQJ: 1) to create an atomic type groovy:000> otype = conn.createAtomicType(XQItemType.XQBASETYPE_ANYATOMICTYPE, new QName("java:Provami"),null) groovy:000> ixpr.bindObject(new QName("bar"), new Provami("passato", 4), otype) ERROR org.basex.api.xqj.BXQException: No mapping known for 'Provami'. at org.basex.api.xqj.BXQAbstract.create (BXQAbstract.java:128) at org.basex.api.xqj.BXQDynamicContext.bindObject (BXQDynamicContext.java:147) at groovysh_evaluate.run (groovysh_evaluate:13) ... 2) I have also tried to create an item groovy:000> itm = conn.createItemFromObject(new Provami('roba',4), null) ERROR org.basex.api.xqj.BXQException: No mapping known for 'Provami'. at org.basex.api.xqj.BXQAbstract.create (BXQAbstract.java:128) at org.basex.api.xqj.BXQDataFactory.createItemFromObject (BXQDataFactory.java:231) at org.basex.api.xqj.BXQDataFactory.createItemFromObject (BXQDataFactory.java:39) at groovysh_evaluate.run (groovysh_evaluate:13) ... Could you please advice on how I may successfully bind the parameter. Thanks Stefano

2 3

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk