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

BUG# Multiple Thread try to execute some Query
by Samuel Lacmene 24 Sep '12

24 Sep '12

2 1

Configuration for locking files with Oxygen/webDAV
by France Baril 21 Sep '12

21 Sep '12

Hi, we are trying to move from a single author environment to a multiple authors environment. The team doing the configuration is having some issues. Here is their question… can you provide some guidance? --- What is the proper BaseX configuration to allow multiple users to concurrently update a database from Oxygen? Environment: - BaseX latest (August build) - Windows 7 server and clients - basexhttp.bat starting db as admin, admin - Users A and B with "write" permissions - Users open webdav folder in Oxygen 14 using unique usernames and passwords - Oxygen is configured to "Lock WebDAV files on open" Issues - Webdav in Oxygen project does not prevent users from changing files that are currently open by other users, nor does Oxygen indicates when other users have opened or changed files. Users need to close and re-open files to see changes made by other others, with no way of preventing other users from overwriting their changes. Questions 1. According to http://docs.basex.org/wiki/Startup#BaseX_Server the basexserver script should also start the http server, but according to the log is does not. Do we need to run both basexserver and basexhttp? Is there any difference between starting Server from basexhttp and starting Server from basexserver? It appears that basexhttp starts both the http and BaseX servers, which is the opposite behavior described by the documentation. 2. Should file locking work in Oxygen using WebDAV? Everything works fine with one user working with localhost, as described at http://docs.basex.org/wiki/Integrating_oXygen#Access_Database_Resources, but we are unable to find a configuration that supports file locking with multiple users accessing a remote server over webdav. Would an example configuration be available? -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com (514) 572-0341

2 2

FileGuru: Important Note About Submission Of BaseX 7.3
by FileGuru 20 Sep '12

20 Sep '12

Hi,Thanks for submitting your software BaseX 7.3 We will review your software within 2 weeks and you will be notified via email if your software has been accepted. To speed up your submission please place a link to us on any page of your website and let us know. By linking to our site you can greatly improve the position of your listing in our archive. Linking back to us will also ensure a speedy review of your software. Here is linking code which you can use to link back to our site. FileGuru - Software Downloads If you prefer image, you can find nice buttons here Best Regards, FileGuru http://www.fileguru.com © 2000-2011, FileGuru.

1 0

date field ordering
by Hariprasad 20 Sep '12

20 Sep '12

Dear Basex, Could you please help us in writing xquery for ordering xml based on date field(bDate).For example I have a xml with following nodes <Results> <GROUPBYVAL> <bDate>01-JUN-12</bDate> </GROUPBYVAL> <GROUPBYVAL> <bDate>10-AUG-12</bDate> </GROUPBYVAL> <GROUPBYVAL> <bDate>21-FEB-12</bDate> </GROUPBYVAL> </Results> query should take input as the above xml and should return output in the below format <Results> <GROUPBYVAL> <bDate>10-AUG-12</bDate> </GROUPBYVAL> <GROUPBYVAL> <bDate>21-JUL-12</bDate> </GROUPBYVAL> <GROUPBYVAL> <bDate>01-FEB-12</bDate> </GROUPBYVAL> </Results> Thanks & Regards Hariprasad.d

2 1

Indexes update
by basex＠phpexpert.net 20 Sep '12

20 Sep '12

Is it necessary to update indexes and fulltext on every insert for the complete Database, or is there a flag to update changes automaticly Regards Marcus

2 1

(no subject)
by John Best 20 Sep '12

20 Sep '12

Hi there, Below is my XML Structure – <Docs> <Doc> <DocTitle C=”1”></DocTitle> <MainDesc></MainDesc> <FullDesc></FullDesc> </Doc> <Doc> <DocTitle C=”2”></DocTitle> <MainDesc></MainDesc> <FullDesc></FullDesc> </Doc> …………………. …………………. …………………. </Docs> There are at least 6000 Doc (more to be added soon). I have created a FT Index of the same. To search a particular word, which might be either in <MainDesc> or in <FullDesc>, below are my queries – Query No -1 (Time taken is 21-22 Secs) data(doc('sample')/Docs/Doc[MainDesc[. contains text {'unfavorable'}] or FullDesc[. contains text {'unfavorable'}]]/DocTitle/@C) Query No -2 (Time taken is 25-26 Secs) for $x in doc('sample')/Docs/Doc where $x[MainDesc[. contains text {'unfavorable'}] or FullDesc[. contains text {'unfavorable'}]] return $x/DocTitle/@C The time taken is too much. How can I lower this…? I tried ft:search(), but it doesn’t fits in here as ft:search wont return Nodes. * * Have a nice day Regards, JBest

2 1

How to lower the Full-Text search time??
by John Best 20 Sep '12

20 Sep '12

Hi there, Below is my XML Structure – <Docs> <Doc> <DocTitle C=”1”></DocTitle> <MainDesc></MainDesc> <FullDesc></FullDesc> </Doc> <Doc> <DocTitle C=”2”></DocTitle> <MainDesc></MainDesc> <FullDesc></FullDesc> </Doc> …………………. …………………. …………………. </Docs> There are at least 6000 Doc (more to be added soon). I have created a FT Index of the same. To search a particular word, which might be either in <MainDesc> or in <FullDesc>, below are my queries – Query No -1 (Time taken is 21-22 Secs) data(doc('sample')/Docs/Doc[MainDesc[. contains text {'unfavorable'}] or FullDesc[. contains text {'unfavorable'}]]/DocTitle/@C) Query No -2 (Time taken is 25-26 Secs) for $x in doc('sample')/Docs/Doc where $x[MainDesc[. contains text {'unfavorable'}] or FullDesc[. contains text {'unfavorable'}]] return $x/DocTitle/@C The time taken is too much. How can I lower this…? I tried ft:search(), but it doesn’t fits in here as ft:search wont return Nodes. * * Have a nice day Regards, JBest

1 0

restxq..Does the extension .xqm is mandatory?
by Seenivasan Gunabalan 20 Sep '12

20 Sep '12

Hi, Was .xqm extension for the xquery module that handles RESTXQ calls are mandatory? We used to create a separate file("customrestxq.xq") to handle the restxq calls, which was imported by the main "restxq.xqm" module. It was working fine till the 7.4 beta version, but at the latest developer release, Basex7.5 (BaseX75-20120918.130850), the calls were not mapped and the status " No function found that matches the request." was returned. we found that by changing the extension from .xq to .xqm i.e. to "customrestxq.xqm" fixed the issue. was .xqm extension is enforced? Best regards, Seenivasan

2 2

Re: [basex-talk] Fulltext search
by Jens Erat 19 Sep '12

19 Sep '12

Hi Marcus, this is because `ft:search` can scan the index directly, `contains text` needs to construct some objects before. `ft:search` doesn't return strings but text nodes, so you can use a parent axis step to get the containing node: ft:search($x, 'double')/parent::node() Kind regards from Lake Constance, Germany, Jens -- Jens Erat [phone]: tel:+49-151-56961126 [mail]: mailto:email@jenserat.de [jabber]: xmpp:jabber@jenserat.de [web]: http://www.jenserat.de PGP: 350E D9B6 9ADC 2DED F5F2 8549 CBC2 613C D745 722B Am 19.09.2012 um 10:22 schrieb <basex(a)phpexpert.net>: > My searches are > > <no>{let $quasi := (for $x in /record where ft:search($x, 'double') and ($x/item[@name="STATUS"]/value/string() = "edited") return <quasi>{data($x/@id)}<content>{$x//value[text() contains text 'double']}</content></quasi>) return $quasi }</no> > > > <no>{let $quasi := (for $x in /record where ($x//value[text() contains text 'double']) and ($x/item[@name="STATUS"]/value/string() = "edited") return <quasi>{data($x/@id)}<content>{$x//value[text() contains text 'double']}</content></quasi>) return $quasi }</no> > > > These searches take a lot of time (about 300 seconds) cause of nearly 600.000 objects (about 4 GB data) to search through > > A Fulltext search wich only delivers the textnodes only takes 2 seconds to deliver text results > > > > On Wed, 19 Sep 2012 09:55:50 +0200, Jens Erat <jens.erat(a)uni-konstanz.de> wrote: >> Hi Marcus, >> >> `ft:search(…)` is built for returning text nodes, have a look at the >> [documentation]. If you want to get the nodes, you should use the more >> general [full text expressions]. >> >> If you need help transforming your query, would you please paste your >> query (or better: the full text search relevant part of it)? >> >> Regards, >> Jens >> >> [documentation]: http://docs.basex.org/wiki/Full-Text_Module#ft:search >> [full text expressions]: http://docs.basex.org/wiki/Full-Text >> >> -- >> Jens Erat >> >> [phone]: tel:+49-151-56961126 >> [mail]: mailto:email@jenserat.de >> [jabber]: xmpp:jabber@jenserat.de >> [web]: http://www.jenserat.de >> >> PGP: 350E D9B6 9ADC 2DED F5F2 8549 CBC2 613C D745 722B >> >> >> >> Am 19.09.2012 um 09:33 schrieb <basex(a)phpexpert.net>: >> >>> Hi @all, >>> >>> is there a way if i use ft:search on the database to get the nodes of results back instead of just the results? >>> >>> >>> Regards >>> >>> >>> Marcus >>> >>> _______________________________________________ >>> BaseX-Talk mailing list >>> BaseX-Talk(a)mailman.uni-konstanz.de >>> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >

1 0

Fulltext search
by basex＠phpexpert.net 19 Sep '12

19 Sep '12

Hi @all, is there a way if i use ft:search on the database to get the nodes of results back instead of just the results? Regards Marcus

2 1