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

order nodes by dateTime
by Sony Vijay 08 Feb '11

08 Feb '11

Hi, I am using BaseX 6.5 database. Say I have the documents : doc1, doc2 in my database and the first child node of these documents is "updatedTime". Say the "updatedTime" node of doc1 and doc2 have the values : 2011-02-07T14:40:00.78-05:00 and 2011-02-07T14:41:02.133-05:00 respectively. I am trying to return a sorted list of document names in the descending order of the updatedTime node. I tried the following xquery: for $doc_name in db:list() order by xs:dateTime(doc($doc_name)/updatedTime) descending return $doc_name The output I receive is [doc1, doc2]. But, the expected output is [doc2, doc1]. I tried both ascending and descending in the order by statement but I get the same output. I am not sure how the ordering of elements by dateTime works. Could you help? Thanks, Sony PS: This is a simplified version of my code. The actual nodes have namespace prefixes. I hope the solution would be consistent when namespaces are used.

1 1

Retrieving the parent nodes of full-text search results
by Sony Vijay 07 Feb '11

07 Feb '11

Hi, Is there a way to retrieve the parent/ancestor nodes of the full-text search results of a basex database ? For instance, consider I have a document named 'feed1', 'feed2', 'feed3' in my database. A sample document ('feed1') looks as follows: <feed> <id>1</id> <updated>2011-02-07T07:10:49.588Z</updated> <title>feed1</title> <entry> <id>59</id> <title>Feed1 Root Package</title> <updated>2011-02-07T07:11:01.324Z</updated> </entry> </feed> The following xquery: for $doc_name in db:list() return (ft:extract(doc($doc_name)/feed/entry/*[text() contains text 'Root Package'])) outputs the following result as expected : <title>Feed1 Root Package</title> But, is there a way to retrieve the parent and ancestor nodes of the resulting <title> node, meaning is there a way I can output the 'id' of the entry and 'id' of the feed as well. The desired output could be: [<title>Feed1 Root Package</title>, <id>59</id>, <id>1</id>]. Thanks, Sony

2 1

Re: [basex-talk] Uncaught bounce notification
by Christian Grün 07 Feb '11

07 Feb '11

Hi don't know why, but your mails seem to be rejected by our mail server.. Anyway, regarding OWL is a large topic, so I doubt this will be completely covered in near future. Do you have some scenarios in mind that are already supported by other XML databases? Best, Christian 2011/2/7 <mailman-bounces(a)mailman.uni-konstanz.de>: > The attached message was received as a bounce, but either the bounce > format was not recognized, or no member addresses could be extracted > from it. This mailing list has been configured to send all > unrecognized bounce messages to the list administrator(s). > > For more information see: > https://mailman.uni-konstanz.de/mailman/admin/basex-talk/bounce > > > > ---------- Forwarded message ---------- > From: "Burkert, Michael" <Michael.Burkert(a)gigatronik.com> > To: <basex-talk-bounces(a)mailman.uni-konstanz.de> > Date: Mon, 7 Feb 2011 17:41:43 +0100 > Subject: Semantische IT-Verarbeitung ? > > Hallo ! > > > > > > Gibt es spezielle Entwicklungen Richtung OWL (semantische Daten) seitens BaseX ? > > > > Da es sich bei OWL & Co um XML-Strukturen handelt, würde sich BaseX grundsätzlich dafür anbieten. > > Die offenen Schnittstellen von BaseX 6.5 zu Java (Java Bindings) leisten hier sicherlich einige Möglichkeiten. > > > > Ist es mittelfristig vorgesehen diesen recht dynamischen Bereich der IT direkter zu unterstützen ? > > > > Viele Grüße > > Michael > > >

1 0

Re: [basex-talk] Uncaught bounce notification
by Christian Grün 07 Feb '11

07 Feb '11

Hallo Michael, XML-Files werden direkt in BaseX gespeichert, wenn man sie in eine DB importiert. Die Funktion file:read() hingegen greift direkt auf eine Datei im Filesystem zu. Grüße, Christian > ---------- Forwarded message ---------- > Hallo ! > > Sind die XML-Files direkt in BaseX gespeichert, oder nur Referenzen auf die Files ? > Kann man den Inhalt eines Files aus BaseX extrahieren, z.B. um es manuell zu bearbeiten ? > Ein letzter Versuch sieht so aus: > > file:read('D:\Path\File.xml') > > Das Ergebnis > > <CreationDate> > <Day>19 > > Konnte mit den eingesetzen encodings nicht beeinflusst warden. > > Viele Grüße > Michael

1 0

Search interface for Mailing Lists
by Christian Grün 05 Feb '11

05 Feb '11

Dear all, as has been discussed some days ago, the search for postings in our mailing lists is a tedious job: Mailman does not offer any search features, and the search engines seem to be too phlegmatic to browse the archives more frequently. To fix this, I've created the following page… http://basex.org/open-source/search/ …which allows you to search through all contents of our mailing lists. Full-text indexing, searching and result creation is all done by the BaseX engine, and the database and index is updated every hour. Feedback is welcome, Christian

3 4

Re: [basex-talk] Including the "doc" information in the RETURN clause
by David leigh 03 Feb '11

03 Feb '11

Ok, I got it figured out from this page: http://docs.basex.org/wiki/Database_%26_Collection. So, in my return concat, I need to use the "base-uri" of $song to get the actual file path. So, my query will look something like: for $song in collection("OpenSongSearch") where $song/song/lyrics[ . contains text "baloche"] or $song/song/title[ . contains text "baloche"] or $song/song/author[ . contains text "baloche"] order by $song/song/title return concat(base-uri($song),string('|'), $song/song/title,string('|'),$song/song/author,string('|'),replace(replace($ song/song/lyrics,'\n','^line^'),'\[\w+\]',''),string('
')) Yep, that works! Sorry to bug you all with a question that's documented! Are there other options than base-uri? For instance, base-uri has the file name. Is there a function like that with just the path but not the file name? If not, I can certainly work with base-uri. (I couldn't find any, but thought I'd ask) Thanks!

2 3

XML validation with BaseX
by Vishwas 03 Feb '11

03 Feb '11

Hi, Does BaseX support XML Validation (like http://exist-db.org/validation.html) ? If so, could you please point me to the relevant documentation. -- Thanks& Regards, Vishwas 9986077286

2 2

this mailing list's Google search index: last (only) update around Jan 26?
by Imsieke, Gerrit, le-tex 03 Feb '11

03 Feb '11

Michael, I was wondering why the most recent posts don't seem to be indexed. If you pick examples from the January list , you'll probably notice that the most recent posts are from Jan. 25: [1] indexed, [2] not indexed. Maybe this is because the bot (if it ever returned after initial indexing) looked at [3] and didn't notice any change, so it didn't descend further. If this is the case and the bot returns daily or so, we should see some change soon because February is new on [3]. But I doubt that the bot ever came back after Jan 26. You could try to submit a changed sitemap.xml each month, pointing to that month's message overview page and specifying a changefreq of 'daily' [4] for that page. Don't know whether Googlebot will take this into account though. But other ways such as the infamous revisit-after meta tag won't work at all, I was told. -Gerrit [1] https://mailman.uni-konstanz.de/pipermail/basex-talk/2011-January/001072.ht… [2] https://mailman.uni-konstanz.de/pipermail/basex-talk/2011-January/001073.ht… [3] https://mailman.uni-konstanz.de/pipermail/basex-talk/ [4] http://www.google.com/support/webmasters/bin/answer.py?answer=183668

2 1

Including the "doc" information in the RETURN clause
by David leigh 02 Feb '11

02 Feb '11

I may be doing this completely wrong to begin with, so try not to be too shocked at my examples! ;c) My BaseX database consists of songs. They were loaded from individual XML files that are stored in a directory structure. I'm searching for songs that contain given lyrics. So far so good. I'm NOT returning XML format data, but tabular data. I'm using the "return" clause with the concat() function of XQuery to formulate each results row. For instance "song title", "author", "lyrics", etc. One row per song that is found from my search. What I'd like to be able to do is to have that results row also contain the information in the "doc" node so that in addition to selected contents of the XML file, the results row would also contain the file name and the relative directory path (which I see are in the "doc" node when I use the BaseX GUI). Here's a real-life example of a query that works well for me to return rows of elements found WITHIN the XML file: for $song in collection("OpenSongSearch") where $song/song/lyrics[ . contains text "baloche"] or $song/song/title[ . contains text "baloche"] or $song/song/author[ . contains text "baloche"] order by $song/song/title return concat($song/song/title,string('|'),$song/song/author,string('|'),replace(re place($song/song/lyrics,'\n','^line^'),'\[\w+\]',''),string('
')) The program that invokes the BaseX call parses these results to put into a listbox in a dialog. The only thing that I knew to try to add the "doc" node was: return concat($song/doc,string('|'), $song/song/title,string('|'),$song/song/author,string('|'),replace(replace($ song/song/lyrics,'\n','^line^'),'\[\w+\]',''),string('
')) This did not give me an error but simply added the additional vertical bar at the beginning and no "doc" node info. I know this is more of a XQuery question than a BaseX question per se, but any hints for novice would be greatly appreciated. Thanks! <mailto:david@leighweb.com> DavidEmailSig

1 0

Force default file type to XML during "add to" command?
by Chad Lancour 02 Feb '11

02 Feb '11

Hello- Just want to start out with KUDOS on the project, contributors, and technology. Amazing. We are importing 300K+ xml & binary files from a file system with 30k in nested hierarchical folder structures into basex. The auto-magical capabilities of basex to suck in this data (and the speed at which is does it) is kick-a%$. Question: All of the 300k+ xml files do NOT have a file extension. Is there a way to have BaseX default to xml if there is no file type? Is there perhaps some other way to handle this other than recursively renaming all the files? Fyi -Here is the simple batch file I am using to import the data: java -Xmx1024m -cp %devbase%\basex65\BaseX.jar org.basex.BaseX -Vc "drop db metadata" java -Xmx1024m -cp %devbase%\basex65\BaseX.jar org.basex.BaseX -Vc "create db metadata; alter user admin xxxxxxx" java -Xmx1024m -cp %devbase%\basex65\BaseX.jar org.basex.BaseX -Vc "open metadata; SET INTPARSE ON; add to \set1 %devbase%\code\basex\import\webcat" java -Xmx1024m -cp %devbase%\basex65\BaseX.jar org.basex.BaseX -Vc "open metadata; SET INTPARSE ON; add to \set2 %devbase%\code\basex\import\rpd" java -Xmx1024m -cp %devbase%\basex65\BaseX.jar org.basex.BaseX -Vc "open metadata; create index text; create index attribute; create index fulltext; create index path" Regards, Chad chad(a)helmetcameracentral.com

3 5