BaseX-Talk

basex-talk@mailman.uni-konstanz.de

1 participants
5252 discussions

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

Xquery for noobs : the HashSet problem
by jean-marc Mercier 12 Nov '13

12 Nov '13

Hi, Following a recent discussion with BaseX team, here is a description of a problem that I don't know how to solve efficiently from within Xquery or BaseX Xquery extensions like map:module. Thus, any suggestion are welcomed ! The problem is the following : I want to write an XQUERY module called HashSet, implementing the XQUERY version of HashSet (I mean the JAVA object HashSet, or std::set in C++). An HashSet is indeed a map specialization. Thus a suggestion is to use the BaseX map:module. However, I don't know how to use it efficiently. The reasons are the following : This HashSet module 1) must expose a method "hashset:new()" to allocate memory dynamically. The map:module provides the function map:new, this point is ok, I can wrap that. 2) This module must expose a method "hashset:clear($hashset)" to de-allocate memory dynamically. The map:module provides the function map:remove, and I could remove all elements. However this point is ko for me, as, AFAIU (as far as I understand), map:remove copy an the references from a map object into a smaller map object. It does not dealllocate memory, leading to poor overall performances. 3) must expose a method "hashset:add($hashset,$element)" to add memory dynamically. Through map:module, the only possibility that I see is to wrap it as map:new($hashset, map:entry($element,$dummyboolean)). Here too, a in-memory copy is done, leading to poor overall performances. XQUERY is a very attractive langage to me. However, its very nature is to be a functional langage. The main inconvenients to working with XQUERY for me are : - first : its dynamic memory management (the in-memory printfoot of my XQUERY executables are usually tremendous). - second : it lacks powerful libraries, as complete math modules. However, I might miss something ? Do not hesitate to teach me some XQUERY basic ! Cheers JohnLeM

3 9

Replace node attribute value
by Thomas Knight 12 Nov '13

12 Nov '13

Hi everyone, I have a problem trying to replace the attribute value. For example, using factbook.xml: replace value of node attribute /mondial/country[@name='Austria']/@car_code with 'B' fails with: [XUDY0027] Replace target must not be empty. How should I be doing this? Thanks Tom

2 1

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk