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

Re: [basex-talk] Query corrupts my database - we shall be happy namespaces are there
by Jan Vlčinský (CAD) 21 Jan '11

21 Jan '11

2011/1/21 Mark Boon <mboon(a)blueplanetsoftware.com> > ...It looks like I got it working using *:Ontology. I must say I never > understood why namespaces must make things so complicated and > counterintuitive. > Hi Mark. Namespaces are a mean, which let you live in quite complex universe, where more spaces are intersecting. You may think of writting XQuery for $x from my_universe return the-thing-I-am-thinking-of($x) (Un)Fortunately, this function was not implemented yet :-) (Are you really sure, what would your thoughts return to you?) But back to intersecting space - if you think of it, you realize, it is very easy to pick up something wrong, or to miss something. And we shall be happy, that in our XML space those separate spaces have names, so we can be enough explicit in telling what we really want. OK, apart from philosophical thoughts, I have simple rules, which helped me using namespaces 1. prefixes are just temporary abbreviations for real namespaces (fully qualified) and the prefixes can change during single XML document 2. imagine, that all prefixes (including the empty one) are replaced by fully qualified namespace name (and you may get rid of xmlns: attribues as they become useless) So for <Traffic xmlns="myone" xmlns:openlr="http://www.openlr.org/openlr" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <openlr:OpenLR> <openlr:LocationID>defg123</openlr:LocationID> ...... </openlr:OpenLR> <OpenLR xmlns="http://www.openlr.org/openlr"> <LocationID>defg123</LocationID> </OpenLR> </Traffic> you get <myone:Traffic> <http://www.openlr.org/openlr:OpenLR> <http://www.openlr.org/openlr:LocationID>defg123</ http://www.openlr.org/openlr:LocationID> ...... </http://www.openlr.org/openlr:OpenLR> <http://www.openlr.org/openlr:OpenLR> <http://www.openlr.org/openlr:LocationID>defg123</ http://www.openlr.org/openlr:LocationID> </http://www.openlr.org/openlr:OpenLR> </myone:Traffic> This way it is perfectly clear, what namespaces are effective. I agree, namespaces are not easy to start with, but my feeling is, the complexity of namespace apparatus is balanced with complexity of the problem it should resolve. And once you get it - it will be clear and easy. Wish you the best. Jan

1 0

XQuery Globaler Zähler
by Burkert, Michael 21 Jan '11

21 Jan '11

Hallo ! Will man allen XML-Elementen eine eindeutige Zahl zuordnen, würde man das über einen globalen Zähler lösen. Die globalen Variablen in XQuery lassen sich offenbar nicht hochzählen. Hat XBase eine Lösung für dieses Problem ? Eine Art eigenen Namespace mit eigener Funktionalität ? Es wird zwar eine Funktion angeboten die ähnliches leistet functx:index-of-node( ... ) Nur bremst diese die Bearbeitung beträchtlich. Viele Grüße Michael

2 1

Re: [basex-talk] Query corrupts my database
by Christian Grün 21 Jan '11

21 Jan '11

Hi Mark, this is due to a missing namespace declaration. You can either explicitly specify your namespace... declare default element namespace "http://www.w3.org/2002/07/owl#"; doc('test')/Ontology ...or use a namespace wildcard to match the root element: doc('test')/*:Ontology Hope this helps, Christian On Thu, Jan 20, 2011 at 11:16 PM, Mark Boon <mboon(a)blueplanetsoftware.com> wrote: > OK, I enter the following commands in the BaseX UI. > create database test > insert node <Ontology/> into doc('test') > replace node collection('test')/Ontology with <Ontology > xmlns="http://www.w3.org/2002/07/owl#" > xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" > xmlns:xsd="http://www.w3.org/2001/XMLSchema#" > xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" > xml:base="http://www.w3.org/2002/07/owl#"> > <Prefix name="rdf" IRI="http://www.w3.org/1999/02/22-rdf-syntax-ns#"/> > <Prefix name="rdfs" IRI="http://www.w3.org/2000/01/rdf-schema#"/> > <Prefix name="xsd" IRI="http://www.w3.org/2001/XMLSchema#"/> > <Prefix name="owl" IRI="http://www.w3.org/2002/07/owl#"/> > <SubClassOf> > <Class IRI="http://ar#boat"/> > <Class IRI="http://ar#vehicle"/> > </SubClassOf> > </Ontology> > Now, if I do > collection('test') > it shows me that the element was in fact inserted as it prints: > <Ontology xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" > xmlns:xsd="http://www.w3.org/2001/XMLSchema#" > xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" > xmlns="http://www.w3.org/2002/07/owl#" > xml:base="http://www.w3.org/2002/07/owl#"> > <Prefix name="rdf" IRI="http://www.w3.org/1999/02/22-rdf-syntax-ns#"/> > <Prefix name="rdfs" IRI="http://www.w3.org/2000/01/rdf-schema#"/> > <Prefix name="xsd" IRI="http://www.w3.org/2001/XMLSchema#"/> > <Prefix name="owl" IRI="http://www.w3.org/2002/07/owl#"/> > <SubClassOf> > <Class IRI="http://ar#boat"/> > <Class IRI="http://ar#vehicle"/> > </SubClassOf> > </Ontology> > However, if I enter: > collection('test')/Ontology > it's empty. Isn't that unusual? I do note that in the "Query Info" panel it > prints: > - removing unknown tag/attribute "Ontology" > although it doesn't do so in my larger example. > When I try to execute the same 'replace...' command again, it tells me: > Error: [XUDY0027] Replace target must not be empty. > Mark Boon > > On Jan 20, 2011, at 11:39 AM, Christian Grün wrote: > > Hi Mark, > > I'm sorry, but I think I need some more information to find a helpful > answer. Do you have a little example (sscce) that allows us to > reproduce the issue? > > Christian > ___________________________ > > On Thu, Jan 20, 2011 at 10:27 PM, Mark Boon > <mboon(a)blueplanetsoftware.com> wrote: > > OK, I tried with BaseX 6.5. Now I don't get an error, but now my Ontology > > element remains empty. > > This is the output of the query: > > Query: replace node collection('bm_test_iam')/BOT-L/Ontology with <Ontology > > xmlns="http://www.w3.org/2002/07/owl#" > > xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" > > xmlns:xsd="http://www.w3.org/2001/XMLSchema#" > > xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" > > xml:base="http://www.w3.org/2002/07/owl#"> > > Compiling: > > - pre-evaluating collection("bm_test_iam") > > Result: replace node document-node { "bm_test_iam" }/*:BOT-L/*:Ontology with > > element { "Ontology" } { attribute { "xml:base" } { > > "http://www.w3.org/2002/07/owl#" }, element { "Prefix" } { attribute { > > "name" } { "rdf" }, attribute { "IRI" } { > > "http://www.w3.org/1999/02/22-rdf-syntax-ns#" } }, element { "Prefix" } { > > attribute { "name" } { "rdfs" }, attribute { "IRI" } { > > "http://www.w3.org/2000/01/rdf-schema#" } }, element { "Prefix" } { > > attribute { "name" } { "xsd" }, attribute { "IRI" } { > > "http://www.w3.org/2001/XMLSchema#" } }, element { "Prefix" } { attribute { > > "name" } { "owl" }, attribute { "IRI" } { "http://www.w3.org/2002/07/owl#" } > > }, element { "SubClassOf" } { element { "Class" } { attribute { "IRI" } { > > "http://ar#boat" } }, element { "Class" } { attribute { "IRI" } { > > "http://ar#vehicle" } } } } > > Query plan: > > <Replace> > > <IterPath> > > <document-node() name="bm_test_iam"/> > > <IterStep axis="child" test="*:BOT-L"/> > > <IterStep axis="child" test="*:Ontology"/> > > </IterPath> > > <CElem> > > <Item value="Ontology" type="xs:QName"/> > > <CAttr> > > <Item value="xml:base" type="xs:QName"/> > > <Item value="http://www.w3.org/2002/07/owl#" type="xs:string"/> > > </CAttr> > > <CElem> > > <Item value="Prefix" type="xs:QName"/> > > <CAttr> > > <Item value="name" type="xs:QName"/> > > <Item value="rdf" type="xs:string"/> > > </CAttr> > > <CAttr> > > <Item value="IRI" type="xs:QName"/> > > <Item value="http://www.w3.org/1999/02/22-rdf-syntax-ns#" > > type="xs:string"/> > > </CAttr> > > </CElem> > > <CElem> > > <Item value="Prefix" type="xs:QName"/> > > <CAttr> > > <Item value="name" type="xs:QName"/> > > <Item value="rdfs" type="xs:string"/> > > </CAttr> > > <CAttr> > > <Item value="IRI" type="xs:QName"/> > > <Item value="http://www.w3.org/2000/01/rdf-schema#" > > type="xs:string"/> > > </CAttr> > > </CElem> > > <CElem> > > <Item value="Prefix" type="xs:QName"/> > > <CAttr> > > <Item value="name" type="xs:QName"/> > > <Item value="xsd" type="xs:string"/> > > </CAttr> > > <CAttr> > > <Item value="IRI" type="xs:QName"/> > > <Item value="http://www.w3.org/2001/XMLSchema#" type="xs:string"/> > > </CAttr> > > </CElem> > > <CElem> > > <Item value="Prefix" type="xs:QName"/> > > <CAttr> > > <Item value="name" type="xs:QName"/> > > <Item value="owl" type="xs:string"/> > > </CAttr> > > <CAttr> > > <Item value="IRI" type="xs:QName"/> > > <Item value="http://www.w3.org/2002/07/owl#" type="xs:string"/> > > </CAttr> > > </CElem> > > <CElem> > > <Item value="SubClassOf" type="xs:QName"/> > > <CElem> > > <Item value="Class" type="xs:QName"/> > > <CAttr> > > <Item value="IRI" type="xs:QName"/> > > <Item value="http://ar#boat" type="xs:string"/> > > </CAttr> > > </CElem> > > <CElem> > > <Item value="Class" type="xs:QName"/> > > <CAttr> > > <Item value="IRI" type="xs:QName"/> > > <Item value="http://ar#vehicle" type="xs:string"/> > > </CAttr> > > </CElem> > > </CElem> > > </CElem> > > </Replace> > > Timing: > > - Parsing: 0.87 ms > > - Compiling: 1.21 ms > > - Evaluating: 2.33 ms > > - Printing: 0.14 ms > > - Total Time: 4.55 ms > > When I now do collection('bm_test_iam')/BOT-L/Ontology the "Text" panel just > > contains: > > <Ontology/> > > where I expected it to contain the XML I just inserted. > > Mark Boon > > > On Jan 20, 2011, at 11:13 AM, Mark Boon wrote: > > On Jan 20, 2011, at 11:09 AM, Christian Grün wrote: > > Mark, > > thanks for your mails. Just a short one.. Does the same error occur > > with the latest version of BaseX (6.5)? > > Christian > > Actually, I just picked up this work where I left it a few weeks ago. Some > > reorganization at work made me change e-mail so I hadn't followed this list > > either. So I missed that a new version came out. I'll try it immediately. > > I'll get back with the result. > > Mark > > _______________________________________________ > > BaseX-Talk mailing list > > BaseX-Talk(a)mailman.uni-konstanz.de > > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > > > >

2 2

Transform table to tree
by Erdal Karaca 21 Jan '11

21 Jan '11

I have a table that is to be transformed to a tree: <entry id="entry1" parentId="parentOfThisEntry" /> <entry id="entry2" parentId="parentOfThisEntry" /> <entry id="entry3" parentId="parentOfThisEntry" /> <entry id="entry4" parentId="parentOfThisEntry" /> The tree structure can be constructed by the id/parentId relation. I failed to achieve this... :-( I am using basex 6.5.

5 5

Query corrupts my database
by Mark Boon 20 Jan '11

20 Jan '11

I've been trying to keep an OWL ontology in the BaseX database. It's a little contrived but I thought it should work. But whenever I insert the ontology it corrupts my entire collection. I have a single Ontology node, that initially is just an empty element. Then I perform the following query: replace node collection('bm_test_iam')/BOT-L/Ontology with <Ontology xmlns="http://www.w3.org/2002/07/owl#" xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" xmlns:xsd="http://www.w3.org/2001/XMLSchema#" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xml:base="http://www.w3.org/2002/07/owl#"> <Prefix name="rdf" IRI="http://www.w3.org/1999/02/22-rdf-syntax-ns#"/> <Prefix name="rdfs" IRI="http://www.w3.org/2000/01/rdf-schema#"/> <Prefix name="xsd" IRI="http://www.w3.org/2001/XMLSchema#"/> <Prefix name="owl" IRI="http://www.w3.org/2002/07/owl#"/> <SubClassOf> <Class IRI="http://ar#boat"/> <Class IRI="http://ar#vehicle"/> </SubClassOf> </Ontology> I get an error. Same thing when I run this query from the BasX UI. This is what I see in the "Query Info" panel: Query: replace node collection('bm_test_iam')/BOT-L/Ontology with <Ontology xmlns="http://www.w3.org/2002/07/owl#" xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" xmlns:xsd="http://www.w3.org/2001/XMLSchema#" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xml:base="http://www.w3.org/2002/07/owl#"> <Prefix name="rdf" IRI="http://www.w3.org/1999/02/22-rdf-syntax-ns#"/> <Prefix name="rdfs" IRI="http://www.w3.org/2000/01/rdf-schema#"/> <Prefix name="xsd" IRI="http://www.w3.org/2001/XMLSchema#"/> <Prefix name="owl" IRI="http://www.w3.org/2002/07/owl#"/> <SubClassOf> <Class IRI="http://ar#boat"/> <Class IRI="http://ar#vehicle"/> </SubClassOf> </Ontology> Error: Possible bug? Feedback is welcome: basex-talk(a)mailman.uni-konstanz.de BaseX 6.3.2: java.lang.RuntimeException: Possible bug? Feedback is welcome: basex-talk(a)mailman.uni-konstanz.de BaseX 6.3.2: Data Access out of bounds [pre:699, indexSize:5, access:5 > 4] org.basex.util.Util.notexpected(Util.java:46) org.basex.io.TableDiskAccess.cursor(TableDiskAccess.java:323) org.basex.io.TableDiskAccess.read1(TableDiskAccess.java:92) org.basex.data.Data.kind(Data.java:324) org.basex.query.item.DBNode$4.next(DBNode.java:272) org.basex.query.path.IterStep$1.next(IterStep.java:45) org.basex.query.iter.NodeIter.next(NodeIter.java:1) org.basex.query.path.IterPath$1.next(IterPath.java:66) org.basex.query.path.IterPath$1.next(IterPath.java:1) org.basex.query.up.Replace.item(Replace.java:59) org.basex.query.expr.ParseExpr.iter(ParseExpr.java:47) org.basex.query.QueryContext.iter(QueryContext.java:360) org.basex.query.QueryContext.iter(QueryContext.java:324) org.basex.query.QueryContext.eval(QueryContext.java:282) org.basex.query.QueryProcessor.execute(QueryProcessor.java:104) org.basex.core.cmd.AQuery.query(AQuery.java:83) org.basex.core.cmd.XQuery.run(XQuery.java:22) org.basex.core.Command.run(Command.java:245) org.basex.core.Command.exec(Command.java:227) org.basex.core.Command.execute(Command.java:66) org.basex.gui.GUI.exec(GUI.java:383) org.basex.gui.GUI$5.run(GUI.java:346) Note: the XML I try to insert is created by Pellet, so I have little control over it. Not only does the query fail, but any subsequent query on the same collection now gives me a "Possible Bug?" message. Any ideas would be greatly appreciated. Mark Boon

2 4

Editorial change in wiki - XQuery 3.0 and GroupBy
by Jan Vlčinský (CAD) 19 Jan '11

19 Jan '11

Hi Reading http://docs.basex.org/wiki/XQuery_3.0 <http://docs.basex.org/wiki/XQuery_3.0>I found, that third code listing telling You can see this effect by changing the return statement to: return element {$income} {count($ppl)} is exactly the same return statement as in first code listing and shall be probably changed into return element {$income} {$ppl} I tried to tell that directly on wiki, but I got no permission to do that, so I use this mailing list for it. Jan PS: I did not test the sample, I only know, it shall differ from the first one and this is my estimation.

3 3

Importing CSV fles (BaseX 6.5)
by Jan Vlčinský (CAD) 18 Jan '11

18 Jan '11

Hi *BaseX 6.5 incl. rewritten web site is impressive*. Really. I go through it feature by feature and test it. Trying to import CSV file I have a problem 1. Creation of new database from xsv file or directory does not work (using default options, no changes) Reports "Line 1: Content is not allowed in prolog" 2. Adding document by Database - Add documents results in the same message 3. Trying to SET PARSER CSV did not change anything 4. Trying to add header with field names into imported file does not help Questions 1. How to import CSV fle 2. What CSV format is expected 1. tab, coma, semicolon? 2. header with field name allowed/expected? With best regards Jan

2 4

FileGuru: Important Note About Submission Of BaseX 6.5
by FileGuru 17 Jan '11

17 Jan '11

Hi,Thanks for submitting your software BaseX 6.5 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. Software Downloads at FileGuru If you prefer image, you can find nice buttons here Best Regards, FileGuru http://www.fileguru.com © 2000-2010, FileGuru.

1 0

Update BaseX - OK.
by basex-talk＠mailman.uni-konstanz.de 17 Jan '11

17 Jan '11

Dear Developer, Thank you for submitting BaseX to http://www.softviewer.com Submission details: Software: BaseX Version: 6.5 Author: BaseX Page: http://www.basex.org/ Download: http://files.basex.org/BaseX.jar URL: http://www.softviewer.com/download_detail.php?softid=221864 Submit: http://www.softviewer.com/submit_soft.php Submit type: Update Submit date: 2011-01-17 16:32:15 If you would like to provide a link to SoftViewer from your site, you can find a nice buttons at http://www.softviewer.com/link_to_us.html You can link to http://www.softviewer.com/download_detail.php?softid=221864 or our homepage: http://www.softviewer.com Best Regards, SoftViewer - http://www.softviewer.com

1 0

Release of BaseX 6.5, Homepage Relaunch
by Christian Grün 17 Jan '11

17 Jan '11

Dear all, We are excited to announce the relaunch of our homepage, which now includes commercial offerings such as professional support, individual software solutions, and training courses: http://basex.org/ Next, we have released Version 6.5 of BaseX, which offers the following new features: = Storage - Text compression, shrinking text nodes up to 50% - Enhanced collection support - Backup functionality - Built-in importers: HTML, Text, CSV = XQuery - XQuery 3.0 features, including GROUP BY and SWITCH statements - New file, HTTP, database and full-text functions - Built-in Lucene and Snowball Stemming for XQuery Full Text = GUI - New TreeView visualization - Improved database management = APIs - JAX-RX now supports hierarchical paths and external variables - Language Bindings extended with query iterators Thanks to your continuous feedback on BaseX! You can be sure that the project itself will remain Open Source, no matter what. We are looking forward to your responses, Christian BaseX Team 2011

1 0