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 莫愁前路无知己，天下谁人不识君。