58同城数据库架构设计思路(下)
...即3和11步骤三、通过min和max二次查询:ORDERBYxWHERExBETWEEN3AND11[3,4,7,9,10]<=1库返回,4在1库offset是3333,于是3在1库的offset是3332[3,5,6,7,11]<=2库返回,3在2库offset是3333[3,5,6,8,9,11]<=3库返回,6在3库offset是3333,于是3在3库的offset是3331...
- http://bbs.hc3i.cn/thread-146026-1-1.html
- 时间: 2015/04/23
- 作者: gkg1166
【原创】Dicomdir文档提取程序,用perl写的
...到@NULLCS,那么删除CRLF#foreach$lines(@lines){#if($lines=~/PATIENT/and$lines!~/\@\x00CS/){#print"$lines\n";#$lines=~s/\x0d\x0a//;#}#print"$lines\n";#printFileout$lines;#}##closeFilein;#closeFileout;#用于处理没有诊断的数据,加上^foreach$lines(@lines){if($lines=...
- http://bbs.hc3i.cn/thread-117998-1-1.html
- 时间: 2013/05/30
- 作者: liangjj
Oracle SQL性能优化常用方法
...)或NOTEXISTS.例子:(高效)SELECT*FROMEMP(基础表)WHEREEMPNO>0ANDEXISTS(SELECT‘X'FROMDEPTWHEREDEPT.DEPTNO=EMP.DEPTNOANDLOC=‘MELB')(低效)SELECT*FROMEMP(基础表)WHEREEMPNO>0ANDDEPTNOIN(SELECTDEPTNOFROMDEPTWHERELOC=‘MELB')(16)识别'低效执行'的SQL语句:虽然目前...
- http://bbs.hc3i.cn/thread-114702-1-1.html
- 时间: 2013/04/10
- 作者: 雨晨663525
病案首页数据核查系统的设计思路
...ion_dictwhereoperation_codenotin(selectexcept_codefromHWS_OPER_EXCEPT_DICT)AND(OPERATION_CODE<'72')OR(OPERATION_CODE>'76'ANDOPERATION_CODE<'87'));/*创建手术视图(除治疗性操作外),此视图基于COMM.OPERATION_DICT和INFO.HWS_OPER_EXCEPT_DICT*/createorreplaceviewhws_oper_dictass...
- http://bbs.hc3i.cn/thread-35914-1-1.html
- 时间: 2011/06/20
- 作者: fox
CTrach气管插管型喉罩在面颈瘢痕挛缩患者应用
...ing-xin,XUKun-linDepartmentofAnesthesiology,PlasticSurgeryHospital,CAMSandPUMC,Beijing100144,ChinaCorrespondingauthor:DENGXiao-mingTel:010-88703937,E-mail:ABSTRACT:ObjectiveToevaluatethefeasibilityofthefibreopticintubatingLMACTrachTM(CTrach)inanticipateddifficultairwaycausedbyfaciocervicalsc...
- http://bbs.hc3i.cn/thread-31994-1-1.html
- 时间: 2011/04/21
- 作者: imb3469
IL-8与TNF-α动态变化规律与急性脑出血的相关性分析
...识码]A[文章编号]1674-4721(2010)11(b)-040-02 IL-8andTNF-αdynamicsandcorrelationanalysisofacutecerebralhemorrhage HEHuifen (ThePeople′sHospitalofRuchengCounty,HunanProvince,Rucheng424100,China) [Abstract]Objective:ToinvestigatetheTNF-αandIL-8andacutecerebral...
- http://bbs.hc3i.cn/thread-29035-1-1.html
- 时间: 2011/02/13
- 作者: hxy
医院数据库系统SQL语句优化
...heddatabasesystems.However,alongwiththedeepeningofthelevelofinformatizationandincreasingdata,resultingdatabasebusinessprocessingratehasbeenreduced.Therefore,aneffectivedatabasemonitoringandperformanceanalysisofthedatabasebecomesthecriticalstep.Thispaperexpoundsthemainparameteraffectingthedatabasecap...
- http://bbs.hc3i.cn/thread-22489-1-1.html
- 时间: 2010/10/25
- 作者: 林路
基于影像数据系统的人工神经网络模型的研究
...onofbreastcancer.Nowtherearemanydifferentwaysformedicalimagesinthedetectionandclassificationofabnormalities,suchaswavelets,fractaltheory,statisticalmethods,whichextractsimagefeaturesbyimageprocessing.Artificialneuralnetworkisakindofalgorithmwhichisdevelopedbytheprocessofunderstandingbasedonhuman.Bec...
- http://bbs.hc3i.cn/thread-22484-1-1.html
- 时间: 2010/10/25
- 作者: 林路
超声造影定量分析技术评估大鼠肝纤维化程度的初步研究
...esultsThefibrosisstageonpathologywasasthefollowing:S0=11,S1=14,S2=30,S3=27,andS4=10.Therewerestatisticalcorrelationsbetweenfibrosisstageanda1(r=-0.508,P<0.001),PI(r=-0.663,P<0.001),AUC(r=-0.773,P<0.001),andtransittime(r=-0.642,P<0.001)fromROIofhepaticparenchyma.ConclusionThequantitat...
- http://bbs.hc3i.cn/thread-20276-1-1.html
- 时间: 2010/09/27
- 作者: shenweilin0304
4种不同类型颌间牵引对颞下颌关节应力分布影响三维有限元
...0.3969/j.issn.1000-1182.2010.02.008 Thestressdistributionofthetemporomandibularjointunderfourtypesofinter-archelastics-athree-dimentionalfiniteelementmodelanalysisHUMin1,XIANGYa-ning1,LIHong2,GUOKe-feng2,WANGFang1.(1.Dept.ofOrthodontics,HospitalofStomatology,JilinUniversity,Changchun13002...
- http://bbs.hc3i.cn/thread-20254-1-1.html
- 时间: 2010/09/27
- 作者: jiayism
DICOM图像处理与网络传输方法探讨
...M;网络;传输;图像处理;PreliminarystudyonDICOMimageprocessingandnetworkcommunicationsHouQing-feng1,Liuji-Dong2,XueWei-jing1,LiuWei1,ZhaiXiao-juan1(1.Dept.ofRadiology,TaishanMedicalCollege,2.InstrumentalDept.ofTaishanCoalMiningHospital,Taian271000,China)AbstractObjective:T...
- http://bbs.hc3i.cn/thread-20236-1-1.html
- 时间: 2010/09/27
- 作者: iamzouming
CT树芽征的病因病理和影像特点及其诊断价值
...不同于其他肺部感染性疾病的形态及分布特点。PathogenesisandValueofTreeinbudatDiagnosisofPulmonaryInfectionsZHAOXin,LIPeng,LongJian,etalAbstract:ObjectiveToreviewthepathogenesisandanalyzethevalueofthephotographiccharacteroftreeinbudatdiagnosisofpulmonaryinfections.MethodsTocheck99p...
- http://bbs.hc3i.cn/thread-18482-1-1.html
- 时间: 2010/09/05
- 作者: paulye
头晕或眩晕患者TCD检测血管狭窄率分析
...。TCDDetectingtheStenosisIncidenceoftheCerebralArteries inDizzinessandVertigoPatientsLiuJunyan,WangBo,GaoShan,etal Dept.Neurology,PekingUnionMedicalCollegeHospital,Beijing 100730 ABSTRACT Objective:Todetecttheincidenceoftheextra-andintra-cerebralarterystenosisin2159dizzinessandve...
- http://bbs.hc3i.cn/thread-11211-1-1.html
- 时间: 2010/06/07
- 作者: owo
数据挖掘技术及其在内镜中心护理管理中的应用
...该规律的规则集如下: 规则1:if(内镜3检查手术时间=2)and(间隔时间4数量=1)and(清洁方法5酶处理=1)and(消毒方法7时间=2)then消毒效果差和监测结果不合格 规则2:if(内镜3检查手术时间=2)and(间隔时间4数量=1)and(清洁方法5酶处理=2)and...
- http://bbs.hc3i.cn/thread-10624-1-1.html
- 时间: 2010/05/31
- 作者: sky001