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

Grégoire Colbert vous invite à rejoindre Viadeo
by Grégoire Colbert 18 Nov '13

18 Nov '13

Rejoignez des millions de professionnels. Grégoire Colbert Ingénieur système d'information, Université européenne de Bretagne Voir son profil Bonjour, Je vous invite à rejoindre mon réseau de contacts sur Viadeo. Cordialement, Grégoire Confirmer que vous connaissez Grégoire Viadeo, le réseau de tous les professionnels. Retrouver vos collègues et camarades de classe. Echanger avec les professionnels de votre secteur Soigner votre image auprès des recruteurs. Inscrivez-vous Si vous ne souhaitez plus recevoir d'invitations de membres Viadeo, cliquez ici

1 0

Technical and commercial support informations about BaseX
by jean-marc Mercier 18 Nov '13

18 Nov '13

Hi, I'd like to start a thread regarding some technical and commercial support aspects of BaseX. The preliminary question is : is this mailing list the correct container for this topic ? regards, Jean-Marc

2 4

db:open(), xquery:eval(), and path()
by Imsieke, Gerrit, le-tex 17 Nov '13

17 Nov '13

I think that under certain conditions, the path() function does not return the proper paths. Here’s an example that works ok: for $doc in <doc><a/><b><c/></b></doc> let $nodes as element(*)* := xquery:eval("$doc//*", map{"doc":=$doc}) return for $node in $nodes return <result path="{path($node)}" name="{name($node)}"/> ⇒ <result path="Q{http://www.w3.org/2005/xpath-functions}root()/Q{}a[1]" name="a"/> <result path="Q{http://www.w3.org/2005/xpath-functions}root()/Q{}b[1]" name="b"/> <result path="Q{http://www.w3.org/2005/xpath-functions}root()/Q{}b[1]/Q{}c[1]" name="c"/> Now I create a database 'doc' with the document 'doc.xml' and invoke the slightly modified query: for $doc in db:open('doc', 'doc.xml')/* let $nodes as element(*)* := xquery:eval("$doc//*", map{"doc":=$doc}) return for $node in $nodes return <result path="{path($node)}" name="{name($node)}"/> ⇒ <result path="Q{http://www.w3.org/2005/xpath-functions}root()" name="a"/> <result path="Q{http://www.w3.org/2005/xpath-functions}root()" name="b"/> <result path="Q{http://www.w3.org/2005/xpath-functions}root()" name="c"/> The element names are still known, but not their paths. Is it a bug or am I missing something? Gerrit

2 5

how about use basex to manage the large quntity of personal health information files?
by easy 17 Nov '13

17 Nov '13

Hi, all I have a question consult with you, I want to plan using basex db to manage our cityizen EHR data( more than 500,0000 people),every people have more than 100 dataset xml file like: > ------------------ > <BasicDataset> > <DataSet code="HDSD00.01.01" codeSystem="WS365-2011" codeSystemName="城乡居民健康档案基本数据集"/> > <HDSN00.01.001 dataelementName="记录日期" value="20110411160000"/> > <HDSN00.01.002 dataelementName="记录者姓名" value="少华"/> > <HDSN00.01.003 dataelementName="记录人编号" value=""/> > <HDSN00.01.004 dataelementName="记录人联系电话" value="13518272323"/> > <HDSN00.01.005 dataelementName="记录人所属机构名称" value="卫生局"/> > <HDSN00.01.006 dataelementName="记录人所属机构代码" value="PDY87041051068311X1119"/> > <HDSN00.01.007 dataelementName="记录人所属机构地址" value="和路135号"/> > <HDSN00.01.008 dataelementName="文档保管机构名称" value="卫生局"/> > <HDSN00.01.009 dataelementName="文档保管机构代码" value="PDY87041051068311X1119"/> > <HDSN00.01.010 dataelementName="文档保管机构地址" value="路135号"/> > <HDSN00.01.011 dataelementName="文档保管机构联系电话" value="13518272323"/> > <HDSN00.01.012 dataelementName="" value=""/> > <HDSN00.01.013 dataelementName="文档编号" value="0000A28072174D28A92AC5716D39C544"/> > <HDSN00.01.014 dataelementName="文档生成日期" value="20131101195713"/> > <HDSN00.01.015 dataelementName="参与人电话" value="xxxxx"/> > <HDSN00.01.016 dataelementName="参与人姓名" value="华"/> > <HDSN00.01.032 dataelementName="源ID" value="0000A28072174D28A92AC5716D39C544"/> > <HDSD00.01.376 value=""/> > <HDSD00.01.377 value=""/> > <HDSD00.01.378 value=""/> > <HDSD00.01.379 value=""/> > <HDSD00.01.380 value=""/> > <HDSD00.01.381 value=""/> > <HDSD00.01.424 value=""/> > <HDSD00.01.008 value="18781045619"/> > <HDSD00.01.018 code="4" displayName="不详" codeSystem="CV07.10.003" codeSystemName="医疗费用来源类别代码表"/> > <HDSD00.01.041 code="1" displayName="卫生厕所" codeSystem="CV03.00.304" codeSystemName="厕所类别代码表"/> > <HDSD00.01.014 code="3" displayName="不详" codeSystem="" codeSystemName=""/> > <HDSD00.01.040 code="1" displayName="自来水" codeSystem="CV03.00.115" codeSystemName="饮水类别代码表"/> > <HDSD00.01.006 value="51062219500408121X"/> > <HDSD00.01.042 code="1" displayName="不详" codeSystem="" codeSystemName=""/> > <HDSD00.01.002 value="杨国安"/> > <HDSD00.01.013 code="5" displayName="不详" codeSystem="CV04.50.005" codeSystemName="ABO血型代码表"/> > <HDSD00.01.007 value="清泉村"/> > <HDSD00.01.019 value="true"/> > <HDSD00.01.009 value="唐公健"/> > <HDSD00.01.003 code="1" displayName="男" codeSystem="dicSex" codeSystemName="性别"/> > <HDSD00.01.017 code="2" displayName="已婚" codeSystem="dicMaritalStatus" codeSystemName="婚姻"/> > <HDSD00.01.001 value="51068310420305002501"/> > <HDSD00.01.010 value="13981093150"/> > <HDSD00.01.038 code="2" displayName="换气扇" codeSystem="CV03.00.302" codeSystemName="厨房排风设施类别代码表"/> > <HDSD00.01.030 value="false"/> > <HDSD00.01.024 value="false"/> > <HDSD00.01.015 code="1" displayName="研究生" codeSystem="dicEducational" codeSystemName="学历"/> > <HDSD00.01.027 value="false"/> > <HDSD00.01.039 code="1" displayName="液化气" codeSystem="CV03.00.303" codeSystemName="燃料类型类别代码表"/> > <HDSD00.01.016 code="5" displayName="农林牧渔水利业生产人员" codeSystem="Classifications" codeSystemName="职业"/> > <HDSD00.01.012 code="01" displayName="不详" codeSystem="dicNationality" codeSystemName="民族"/> > <HDSD00.0l.011 value="true"/> > <HDsD00.01.004 value="19500407160000"/> > <HDSD00.01.037 value="false"/> > <HDSD00.01.01.02> > <row/> > </HDSD00.01.01.02> > <HDSD00.01.01.03> > <row/> > </HDSD00.01.01.03> > <HDSD00.01.01.04> > <row/> > </HDSD00.01.01.04> > <HDSD00.01.01.06> > <row/> > </HDSD00.01.01.06> > <HDSD00.01.01.08> > <row/> > </HDSD00.01.01.08> > <HDSD00.01.01.09> > <row/> > </HDSD00.01.01.09> > <HDSD00.01.01.05> > <row/> > </HDSD00.01.01.05> > <HDSD00.01.01.07> > <row/> > </HDSD00.01.01.07> > </BasicDataset> > > ---------------------------- > > before, I used existdb to do this, but I found existdb is difficult ,query on large data often make system dead, so I want to know, the basex is better to do this, because I found basex can index much qucik, query response well, and do import data file quick, can you give me some advice? > > thanks. > -- 此致 easy 莫愁前路无知己，天下谁人不识君。

2 1

Collations and testing for attribute equality
by James Ball 15 Nov '13

15 Nov '13

Hello, I'm doing some work matching between XML documents - one set has no characters outside the basic ASCII range while the other has a mix of of Ø and Ö and lots of others. Some are in UPPER case and some in Mixed. I need to match a "James" in one file to "JAMES" in another and so on. To do the comparisons I've been looking at BaseX's support for collations. Following the example in the documentation like this works perfectly: declare default collation 'http://basex.org/collation?strength=primary'; "Straße" = "Strasse", "Jérome" = "Jerome", "James" = "JAMES" But it doesn't work when testing attribute (or node) values in a statement like this: declare default collation 'http://basex.org/collation?strength=primary'; let $doc := doc(' <root> <test name="Straße">Straße</test> <test name="Strasse">Strasse</test> </root> ') return count($doc/root/test[@name = "Strasse"]) I would expect that to return a count of 2 but it returns a count of 1. I can get round this by calling fn:compare() like this but it feels like a hack: declare default collation 'http://basex.org/collation?strength=primary'; let $doc := doc(' <root> <test name="Straße">Straße</test> <test name="Strasse">Strasse</test> </root> ') return count($doc/root/test[0=fn:compare(@name,"Strasse")]) Is this behaviour as intended? I can see that it might make query speed and indexes much better to ignore collation for = but I couldn't find it stated in the documentation. My quick read of the specification suggested that the operation of fn:compare would drive the behaviour of eq, gt, lt etc. I think that I'm probably doing this completely the wrong way and I should be using some of the other features of Full-Text but I'm not sure. If anyone can point me in the right direction I will be very grateful. Many thanks, James

3 3

how to get the data of a http post request?
by easy 15 Nov '13

15 Nov '13

hi,all, I can't find function in request module to get the request content. such as request:get-data(), any idea? -- 此致 easy 莫愁前路无知己，天下谁人不识君。

2 1

BaseX Scalability
by Martí Pàmies Solà 14 Nov '13

14 Nov '13

Hi, We are analysing BaseX as an option to store over 100 million xml documents, and one of our main concerns is, which scalability features it offers. We review at http://vschart.com/compare/basex/vs/exist-db that it is horizontal scalable but, on BaseX documentation portal we can not find it. Thanks, Martí.

2 1

XQUERY module for querying instance of XSD scheme ?
by jean-marc Mercier 14 Nov '13

14 Nov '13

Hi, I started to write an xquery module that performs basic operations over instances of XSD schemes. My needs are basics, I would like to list groups and abstract classes, or define automatic predicat like declare variable $XSD_scheme := doc("my_schem.xsd") declare function IsNodeOfGroup($node, $group as element(xsd:group)) as xs:boolean {..} declare function ListAbstractClassesOf($node as element()) as element(xsd:complexType)* {..} However, I guess that I am reinventing the wheel and such a module surely exists already. Has anybody heard about such a module ? Thanks, Jean-Marc

1 0

BaseX rest and PHP
by Lars Johnsen 13 Nov '13

13 Nov '13

Hi all This is a question for those with experience using PHP with BaseX and the rest interface. There is a peculiar case of lag for queries, and I wondered if it had to with how PHPdoes things, or if it is how BaseX does things (or if there is something else). This may be a long shot, but I still give it a try. The setup is fairly straight forward, with queries sent from a html-page via a PHPscript which places the call: file_get_contents(basex-rest-URL). The result is then sent back to the requesting html page. The problem is that this sometimes hangs: two or three queries then it stops or takes an awful lot of time. The peculiar thing is that the basex-rest-URL, when typed directly into browser address line, receives an immediate response, even while it is still being processed by the html-php-basex cycle. Sometimes the cycle gives an answer, sometimes not. The cycle do work when file_get_contents is directed towards an SQLite database, so it seems that there is something going on in the communication between PHP and BaseX. Any ideas? Regards Lars G Johnsen National Library of Norway

3 2

Multi threading doing slow process of Xquery Execution
by Pushpendra Singh Sengar 13 Nov '13

13 Nov '13

Hi All, I create a collection of 4.5 gb xml document. and process some Xquery in sequencial manner then it is taking adequate time to process all queries. But when I converting process to multi threading then it is taking more than 10 times of time. Please someone suggest what is the best way to process Xquey in multithreading model. MY code is following : Thread thread = new Thread(new XqueryProcessor( new Context(),"db1")); Thread thread1 = new Thread(new XqueryProcessor( new Context(),"db2")); Thread thread2 = new Thread(new XqueryProcessor( new Context(),"db3")); thread.start(); thread1.start(); thread2.start(); Xquery Processor has all queries which need to process. and db1, db2 ,db3 are basically same xml files three collection. -- Thanks & Regards , Pushpendra Singh

3 4