BaseX-Talk

basex-talk@mailman.uni-konstanz.de

5 participants
5247 discussions

store results of a query in a new database
by Cerstin Elisabeth Mahlow 21 Mar '13

21 Mar '13

Hi, I would like to store the results of an xquery extracting some nodes from an existing database into a new database. So I have the DB 'collect' open and then do: db:create('annotate-abcdef') and then for $i at $p in //entry[phraseme[text() = "abcdef"] and selected[text() = "yes"]] let $query := $i/query let $nodeid := $i/node let $node := db:open-id('TG-DTA-GerManC-stemming-ws', $nodeid) let $nodename := name($node) let $nodecontent := string($node) return insert node <div>{$nodeid} {$query} {element {$nodename} {$nodecontent}} </div> as last into db:open('annotate-abcdef') However, the error message is [XUDY0027] Insert target must not be empty. How would I add a root element to the new DB, as I don't wan't to link it to an existing document? All nodes added to the DB are only results from queries over an existing DB. All I can see from the Wiki is using a document as initial data for the DB. How do I set UPDINDEX ON for the new DB? I will later update the information added in the first place by other queries. To be able to use ft:mark, I would have to optimize the DB with db:optimize() after having added nodes, is this correct? 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 7

[UPDINDEX] db:add bug
by Fabrice Etanchaud 21 Mar '13

21 Mar '13

Dear all, The following list of commands/queries lead to a bug report : Set updindex true Create db mydb db:add('mydb',<root/>,'mydb.xml') Error: Improper use? Potential bug? Your feedback is welcome: Contact: basex-talk(a)mailman.uni-konstanz.de Version: BaseX 7.7 beta Java: Oracle Corporation, 1.7.0_15 OS: Windows 7, amd64 Stack Trace: java.lang.NullPointerException org.basex.data.Data.insert(Data.java:840) org.basex.query.up.primitives.DBNew.addDocs(DBNew.java:57) org.basex.query.up.primitives.DBAdd.prepare(DBAdd.java:49) org.basex.query.up.DatabaseUpdates.check(DatabaseUpdates.java:109) org.basex.query.up.ContextModifier.apply(ContextModifier.java:89) org.basex.query.up.Updates.apply(Updates.java:120) org.basex.query.QueryContext.update(QueryContext.java:281) org.basex.query.QueryContext.value(QueryContext.java:265) org.basex.query.QueryContext.iter(QueryContext.java:250) org.basex.query.QueryContext.execute(QueryContext.java:499) org.basex.query.QueryProcessor.execute(QueryProcessor.java:96) org.basex.core.cmd.AQuery.query(AQuery.java:77) org.basex.core.cmd.XQuery.run(XQuery.java:22) org.basex.core.Command.run(Command.java:342) org.basex.core.Command.exec(Command.java:321) org.basex.core.Command.execute(Command.java:78) org.basex.gui.GUI.exec(GUI.java:397) org.basex.gui.GUI$7.run(GUI.java:349) Query plan: <QueryPlan> <FNDb name="add(database,input[,path])"> <Str value="mydb" type="xs:string"/> <CElem> <QNm value="root" type="xs:QName"/> </CElem> <Str value="mydb.xml" type="xs:string"/> </FNDb> </QueryPlan> Have a nice week-end. Fabrice

2 1

some stackrelated questions
by Rob Stapper 18 Mar '13

18 Mar '13

Hi, My recursive query gives a stackoverflow: [XQDY0054] Stack Overflow: circular variable declaration? I use the standard, standalone BaseX-software. I'm almost certain it isn't a circular variable declaration because this recursive query can go pretty deep, probably more than a hundred levels and maybe even more. It works on smaller files but it gives this message on the biggest files with the deepest nestinglevel. How deep is the nestinglevel of recursive-queries in BaseX? How can the the max. nestinglevel be increased? Thnx in advance for your reply. Sincerely Rob Stapper

2 1

Re: [basex-talk] seeking for a document in a collection with a million documents is very slow
by Fabrice Etanchaud 18 Mar '13

18 Mar '13

Dear all, >From what I read in the documentation, My problem seems to be related to the update of the resource index. Is this index updated after each add/replace/delete command, Or at the end of the commands' list ? Last, could you please tell me if replace is equivalent to delete+add ? Best, Fabrice De : Fabrice Etanchaud Envoyé : vendredi 15 mars 2013 14:18 À : 'basex-talk(a)mailman.uni-konstanz.de' Objet : seeking for a document in a collection with a million documents is very slow Dear all, Does the document index rely on text or attribute index ? One can experiment very slow response time when looking for a specific document name in an optimized collection of a million documents (in dynamic execution, without optimizations, for example within a loop with a name being the concatenation of string values). Is there a way to speed things up ? Best regards, Fabrice Etanchaud Questel-orbit

2 3

Copy Command
by John Best 18 Mar '13

18 Mar '13

Hi there, I am trying to Copy the "Doc" DB using following piece of code - try{ ....... new Copy("Doc", "Doc1").execute(CONTEXT); ....... ....... } catch(........ .......................... I am expecting another copy of Doc db as Doc1 db... Am I right..? But can't see "Doc1" anywhere... No error mesg... !! -- Have a nice day JBest

2 1

How to update db online without closing application ?
by Pratik Kharwade 18 Mar '13

18 Mar '13

Hi, Our application will be a desktop application with data in XML fomrat. The data is nothing but articles stored as XML and will be displayed in HTML format with the help of XSLT. For this we are using BaseX as desktop DB. Just changed to 7.6. The front-end will have a ListBox displaying the names of the articles, when selected by user, will display the transformed (HTML) document. Along with this functionality, we have given a search tool, which have some common XQuery features like; Exact Phrase, Proximity Search, Word1 OR Word, Word1 NOT Word2... This is what we have done successfully. Now we are stucked at one point. We have to give an online update facility through which the user DB will get updated, if not, as soon as he goes online. This part is also done but... While updating, the our application doesnt response till the updates are done. The user can't interact with the application. What we have planned is updating should be done as a background process and the user can interact with the application while updating. Also after updating the DB should get optimize and the updates should get reflected at the front-end. I hope I have cleared our needs and now waiting for your answer/suggestions. Have a nice day Pratik

3 2

problem with parse-xml function
by Bartosz Marciniak 18 Mar '13

18 Mar '13

Hi, Let me show you a simple example that shows strange behaviour of parse-xml() function: ----------------------------------------------- declare function local:transform($nodes as node()*) as item()* { for $node in $nodes return typeswitch($node) case text() return parse-xml-fragment($node) case element(b) return element b {local:transform($node/node())} default return local:transform($node/node()) }; let $textdoc := <doc><a>content 1</a> <b><a>content 2</a></b> </doc> let $doc := <doc>{ for $node in $textdoc/node() return local:transform($node) }</doc> let $doc2 := <doc>{ for $node in $doc/node() return $node }</doc> return $doc ---------------------------------------------------- After running it on baseX 7.6 the result is: $doc = <doc> <a>content 1</a> <b> <a>content 2</a> </b> </doc> but it differs from doc2: $doc2 = <doc> <b> <a>content 2</a> </b> <a>content 1</a> </doc> Why does using parse-xml() function change the order of the elements? I ran this simple code on zorba and eXist (using util:parse() function) and $doc2 was the same as $doc. Regards Bartosz Marciniak

2 1

Home, DBPATH etc. when basexserver is started in service mode
by Subash Kalbarga 18 Mar '13

18 Mar '13

Hi a) I am a new user, so far love basex and I am on Win7. I use the zip file (rather than the setup program) and extract b) I specifically set -Dorg.basex.path=c:\blah" in basexserver.bat and basexclient.bat c) If I now start basexserver.bat from a command prompt and then from another command prompt start basexclient.bat and do an "info" I see DB_PATH, REPO_PATH etc. set correctly to "c:\blah" as it should be. d) However if I run basexserver.bat -S (start as service) and then connect via basexclient.bat ,and do a info, the DB_PATH_REPO_PATH etc. are completely confused and basexclient thinks they are in its current directory. Moreover, if I actually create a database and add a file to it and close and then check where the data is stored, it is stored in the place basexclient thinks the DBPATH is rather than where it should be as per the server e) I am sort of sure that the server is looking at the correct paths even when started in -S mode because I see .basexhistory and .logs being created in C:\blah Thanks in advance

2 1

Wie man gutes Einkommen mit dieser Methode wird
by Emily Parker 16 Mar '13

16 Mar '13

Hello Basex Talk Ich habe 12 Jahre lang in Casinos gearbeitet. Ich habe tausende Menschen gesehen, die versucht haben, an den Roulette-Tischen Geld zu verdienen. Wenn sie nur gewusst hätten, dass der richtige Ort, um beim Roulette Geld zu verdienen, nicht das Casino, sondern das Internet ist! Online Casinos basieren auf Computerprogrammen und wenn Sie die Funktionsweise des Systems verstehen, können Sie diese schlagen. „Ein seltsamer Trick“ machte mich und hunderte andere Menschen reich! Finden Sie heraus, wie SIE GLEICH JETZT dasselbe tun können! Klicken Sie auf den unten stehenden Link, um das Roulette-System kennenzulernen, mit dem ich mein Haus, meine Urlaube und die Ausbildung meiner Kinder finanziert habe! http://awhub.com/b/click/270/47403792/2c1a3.html mit beste Grüße, Emily Parker P.S. Diese Methode ist so einfach, dass sie sogar Kinder verstehen! Ich weiß das, da mein Tochter Julia SELBST Geld damit verdient! Um aus unserer Mailingliste austragen http://awhub.com/b/unsub/189/47403792/2c1a3.html

1 0

seeking for a document in a collection with a million documents is very slow
by Fabrice Etanchaud 15 Mar '13

15 Mar '13

Dear all, Does the document index rely on text or attribute index ? One can experiment very slow response time when looking for a specific document name in an optimized collection of a million documents (in dynamic execution, without optimizations, for example within a loop with a name being the concatenation of string values). Is there a way to speed things up ? Best regards, Fabrice Etanchaud Questel-orbit

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk