Study on Business Intelligence Applied in the Lottery Management

体育彩票经过十多年的发展，积累了大量的业务数据，彩票管理部门亟需从这些庞大的数据中获知其隐含的信息和知识，制定相适应的政策，增强竞争力。随着电脑彩票的发行，全国体育彩票销售数量大幅度上升，从1994年的5亿元猛增到2010年的694亿元，显示出了强大的发展势头。但是，和逐年不断增加的销量形成鲜明对比的是彩票管理信息化方面的滞后，只是在核心的数据领域达到了比较高的信息化水平。 如何有效的利用各种数据为决策服务，商务智能技术提供了很好的解决途径，特别是数据仓库技术，联机处理技术和数据挖掘等技术的应用，可以有效的提高彩票管理的信息化水平和行政效率，使决策部门及时针对市场动态制定相应的策略，从而在激...With more than 10 years’developing, China Sports Lottery has accumulated a large number of business data, from which the Sports Lottery Administration Section urgently need to get the connotative information and knowledge, formulate corresponding policy and enhance competitiveness. With the assurances of computer lottery, the national sports lottery’s sale volume increased substantially, from 500 ...学位：工程硕士院系专业：软件学院_工程硕士(软件工程)学号：X200923044

血清一阶导数荧光光谱诊断早期恶性肿瘤

利用Wistar大鼠接种恶性肉瘤模拟人患上癌症。取Wistar大鼠眼静脉血制备血清,并用乙醇简单处理得上层清液,扫描获得其一阶导数荧光光谱,确定上层清液原卟啉发射带(630 nm附近)的峰高,观察到健康Wistar大鼠与癌变大鼠的血清样存在明显差异,10例癌变样假阳性率为0,而20例正常样中仅有1例假阳性达到了恶性肿瘤早期诊断的目的

Maroteaux-Lamy综合征的ARSB基因分析及新突变的致病性鉴定

【目的】对7家拟诊为Maroteaux_Lamy综合征(MPSⅥ)的患儿及其父母进行ARSB基因的突变检测和新突变的致病性鉴定,以揭示其分子发病机制,为将来的产前/植入前基因诊断等创造前提条件。【方法】在临床初诊及GAG尿检和MPS酶检的基础上,抽取患儿及其父母EDTA抗凝血,进行ARSB基因的PCR扩增和Sanger测序。对所发现的新突变,在经HGMD、1000G和ExAC等数据库核实排查后,首先用SWISS-MODEL软件分析、比对突变蛋白和正常蛋白的空间构象,然后用Clustal X软件分析跨物种氨基酸的保守性,用PROVEAN、SIFT、PolyPhen-2软件预测新突变的致病性,最后用ACMG标准对新突变的致病性进行综合分析鉴定。【结果】1)7个家系先证者的基因检测结果分别为:No1:c.574T> C,p.C192R纯合错义突变;No2:c.160G> A/p.D54N(来自其母)和c.1197C> G/p.F399L(来自其父)的复合杂合子;No3:仅检出c.1072G> A/p.V358M和IVS5 as(-27)A>C变异,但酶检和临床表型符合Ⅵ型;No4:为c.281C> T,p.S94L(新突变,来自其母)和IVS5 as(-27)A> C(来自其父)的复合杂合子;No5:为c.1197 C> G,p.F399L纯合错义突变;No6:为c.1197 C> G,p.F399L(来自其母)和c.1379 C> T,p.S460F(新突变,来自其父)的复合杂合子;No7:为c.499 G> A,p.G167R(来自其父)和c.1325C>T,p.T442M(来自其母)的复合杂合子。2)新突变鉴定结果:对正常ARSB酶蛋白和p.S94L突变酶蛋白的空间构象的预测比对结果显示,两者有明显区别;跨物种保守性分析结果显示,p.94突变点所在氨基酸(S)在物种进化过程中具有高度保守性;PROVEAN、SIFT和PolyPhen-2软件对p.S94L预测结果分别为:Deleterious、Damaging和Probably damaging。用上述方法对p.S460F的预测结果及ACMG的综合分析结果也显示该突变可能是致病性的。【结论】1)家系4的p.S94L和家系6的p.S460F新突变可能都是新的致病性突变,有可能都是引起患儿发病的内在原因之一。2)家系1,2,5,6,7可以确诊为MPS Ⅵ型,其基因型和表现型具有显著的相关性,家系3虽经酶检确诊,临床症状和尿检结果也都与MPS Ⅵ型符合,但却未能在DNA水平查到明确的突变类型,其表现型与基因型的相关性还有待进一步证实。国家自然科学基金(30772069);;闽粤合作科研基金(71010025和71020010

Fast detection of thanatophoric dysplasia type I p.R248C mutation hot spots and rapid prenatal diagnosis of three TD type I high-risk fetuses

目的针对致死性侏儒症I型（thanatophoric dysplasia typeⅠ,TD-Ⅰ）FGFR3基因的突变热点＂p.R248C＂,建立快速特异的酶切鉴定法（restriction endonuelease testing,RE）和扩增受阻突变系统（amplification refractory mutation system,ARMS）/RE法,并应用于后续3例疑似TD-I高危胎儿的快速产前诊断,以及时防止患胎出生,同时为今后的胚胎植入前遗传学诊断（preimplantation genetic diagnosis,PGD）打下良好基础。方法首先,针对突变热点p.R248C突变前后的序列特点,选择合适的内切酶＂Afe I＂,建立酶切鉴定法。其次,设计双错配碱基特异引物结合Apa LI酶切,建立ARMS/RE双重特异鉴定法。对阴性和阳性结果均再用普通引物扩、测的结果进行验证。结果用Afe I酶切FGFR3基因exons（6-7）普通引物的PCR产物（535 bp）,正常对照及非p.R248C突变的TD病例均能被切成255 bp和280 bp 2个片段,而胎1~胎3均切出255 bp、280 bp和535 bp 3个片段。用特异引物E7（p.R248C）扩增,正常对照和非p.R248C突变的TD病例均扩增阴性,无法进一步做酶切鉴定;而p.R248C突变均扩增阳性,当再用Apa LI酶切PCR产物（365 bp）时,胎1~胎3均切出22 bp和343 bp 2个片段。通过引物扩、测结果显示：胎1~胎3均是p.R248C杂合突变。结论该法快速特异、准确可靠,可用于p.R248C突变热点的快速检测及含该突变高危胎儿的快速产前诊断。该法还可用于含p.R248C突变TD-I型家系的PGD。胎1~胎3都是TD-I患胎,建议尽早终止妊娠。Objective To build up the specific rapid methods of RE and ARMS/RE for mutation hotspot＂p.R248C＂in the FGFR3 gene of thanatophoric dysplasia type I（TD-I）,then use the method for rapid prenatal diagnosis of 3 follow-up high-risk fetuses of TD-I to stop the birth of suffering fetuses,at the same time,lay a good foundation of preimplantation genetic diagnosis（PGD） for the future.Methods First,according to the characteristics of the sequence of the mutation hot spot p.248 C before and after mutation,the appropriate enzyme＂Afe I＂was selected to establish the identification method of enzyme digestion.After that,specific primers of double mismatch bases were devised,combining the method of digestion of Apa LI（ARMS/RE） to achieve the double identification.In the end,the sequences obtained by common primers were used to verify the negative and positive results through DNA sequencing.Results For the normal control and the patient without p.R248 C mutation of TD-I,PCR products（535 bp） of exons（6-7） of FGFR3 gene,amplified by common primers,could be digested into 2 fragments（255 bp and 280 bp） by Afe I.However,for fetuses 1~3,the PCR products could be digested into 3 fragments（255 bp,280 bp and 535 bp）.The normal control and the patient without p.R248 C mutation of TD-I were negative using the specific primers E7（p.R248C）,which could not be further identified by enzyme digestion.For the fetuses with p.R248 C mutation of TD-I,PCR products（365 bp） of exon 7 of FGFR3 gene,amplified by specific primers,could be digested by Apa LI and all the digested products were 22 bp and 343 bp.Sequencing results of common primers＇ products indicated：fetuses 1~3 were p.R248 C heterozygous mutation.Conclusions The method is fast,accurate and reliable,which can be available for the fast detection of mutation hot spot p.R248 C and the rapid prenatal diagnosis of high-risk fetus with p.R248 C mutation.This method can also be applied to PGD of high-risk fetus of TD-I with the mutation＂p.R248C＂.Fo闽粤合作科研基金（71010025

An Analysis of the Interaction between River Water, Groundwater and Seawater in Minjiang River Estuary Region, Fujian Province, Based on Stable Isotopes D and ~(18)O

为了揭示闽江河口两岸的地下水形成演化规律以及河口区河水、地下水和海水的相互作用,分别于2009年枯水期(10至11月)和2010年丰水期(7至8月),在闽江河口区采集了河水、地下水和海水样品,测定了水样的氢氧稳定同位素组成和盐度。研究结果表明:(1)闽江河口两岸的浅层地下水主要接受降水补给,北岸地下水还接受山区基岩裂隙水补给,南岸浅层地下水在枯水期还接受经过蒸发作用的灌溉水补给;(2)闽江河口区,枯、丰水期河水与地下水的补排关系始终表现为地下水补给河水,枯水期南岸地下水在河口混合中的贡献明显增大;(3)海岸带含水层基本上不存在海水入侵,仅局部含水层有微弱的海水入侵迹象;(4)丰水期和枯水期的淡咸水混合带在河口中的位置和混合类型存在明显差异。The aim of this study is to reveal the origin and evolution of groundwater as well as the interaction between groundwater, river water and seawater.During both the dry season (October and November) and the wet season (July and August) of 2009, the authors collected fresh river water and brackish water samples in Minjiang River estuary, groundwater samples near Minjiang River estuary, and seawater samples in Taiwan Strait, then measured salinity, D and 18 O isotopic composition for the water samples.Some conclusions have been reached: (1) the unconfined groundwater on both sides of Minjiang River estuary is mainly recharged by rainfall, the groundwater on the northern side is also recharged by the bedrock fissure groundwater, and the groundwater on the southern side is also recharged by the irrigation water in the dry season, which has somewhat experienced evaporation before discharging; (2) the interaction between river water and groundwater always shows that the groundwater recharges to the river water occur in both dry season and wet season, and the mixing ratio of groundwater from the southern side of Min River estuary significantly increases in the dry season; (3) the seawater intrusion in the costal aquifer doesn’t exist on the whole, and this kind of phenomenon just occurs locally in a small part of the costal aquifer; (4) the site and mixture type of the mixed zone between fresh and brackish water in the estuary in the dry season is clearly different from those in the wet season.福建省重点基金项目(编号:2009I0025); 国家自然科学基金项目(编号:41072174)联合资

Application of Radon and Radium Isotopes in Estimating Submarine Groundwater Discharge in Coastal Areas

海底地下水排泄(Sgd)是海岸带陆海相互作用的一个重要的过程,其重要意义体现在它对海岸带水循环和地球化学循环的影响,以及它对沿岸海域生态环境的影响。国际上自从20世纪90年代中期开始系统研究海底地下水排泄以来,已经研究和开发出一整套较为完善的理论和方法,但Sgd的研究在我国才刚刚起步,相关报道极少见且缺乏不同方法的对比研究。目前,评价Sgd常用的方法有:渗流仪法、数值模拟法和地球化学示踪法。其中以氡和镭为代表的地球化学示踪法成为最具影响力的评价方法。该文详细介绍用氡和镭同位素评价Sgd的理论和方法及其适用条件。Submarine groundwater discharge(SGD) is recognized as an important land-sea interaction in the coastal zone,for it is volumetrically and chemically significant to coastal water and chemical budgets,and it may have an influence on coastal ecological environment.Since the mid 90′s,a set of relatively complete theories and methods has been developed and established due to the systematic researches on SGD internationally.However the study on SGD has just begun in China,its relevant report is rarely available and short of comparison experiments of different methods.The current methods for SGD estimation mainly include: seepage meter measurement,numerical simulation,geochemical tracing method.Among those methods,geochemical tracing method has become one of the most powerful methods,and radium and radon as the representative of geochemical tracers has been extensively used.The methods and applicable conditions of SGD estimation using radon and radium isotopes are introduced in detail.近岸海域的海底地下水排泄及其海洋生态环境效应研究(编号40672166);多种方法研究胶州湾的海底地下水排泄(编号41072174

玉米芯热解催化转化制备呋喃类化合物工艺优化

为探索木质生物质气固非均相催化热解制备呋喃类化合物新途径,该文以玉米芯为原料,采用MCM-41、活性炭（AC）、Al2O3、HZSM-5（Si/Al=38,46,80）、TiO2和ZrO2为催化剂,在玉米芯催化热解催化剂筛选的基础上,采用响应曲面法对MCM-41、AC和TiO2催化热解玉米芯工艺条件进行优化,研究催化剂对热解产物组成和呋喃产率的影响。结果表明,较高比表面积的MCM-41、AC和TiO2催化剂可明显促进呋喃类化合物的生成,呋喃类产率可分别达到31.43%、28.78%和30.44%,而HZSM-5系列催化剂最低;单个因素影响顺序为催化剂>催化热解温度>原料与催化剂质量比;催化剂类型和催化热解温度具有明显的交互作用;当催化热解温度为550℃、玉米芯与催化剂质量比为1∶1,采用活性炭为催化剂时,呋喃类化合物产率最高可达35.30%。研究结果可以为基于气固催化反应的木质生物质催化热解制呋喃类化学品提供依据。国家自然科学基金面上项目(31670599)资助云南省新能源重大科技专项(2015ZB001)厦门大学闽江学者特聘教授科研启动基

木质生物质催化热解制备富烃生物油研究进展

生物油是木质生物质等原料经过热解获得的绿色产物,富含多种化学和生物活性物质,在石油替代方面具有发展潜力。生物质催化热解技术是制备高品质生物油的主要途径,但由于生物油含氧量比较高、目标产物选择性比较低、催化剂易结焦失活,限制了其应用。笔者从木质生物质热解机理及其反应途径、催化剂(金属氧化物、金属盐类、微孔催化剂、介孔催化剂)及其催化热解转化机理与产物调控机制、供氢试剂(四氢化萘、甲醇、废旧塑料、废弃油脂及其他供氢试剂)及其共催化热解转化机理等方面综述了木质生物质催化热解制备高品质生物油的进展,概述了催化热解过程中生物油的热解特性、产物组成以及转化机理,并对存在的问题及其解决方案进行了分析,展望了未来的发展方向,以期为木质生物质的高效转化利用提供依据和参考。国家自然科学基金(31670599,31870570);;厦门大学闽江学者特聘教授科研启动项目;;国家林业局“948”项目(2013-4-08);;云南省教育厅项目(ZD2014012,2018JS325

铟硼磷酸盐结构中的交叠生长规律研究

Several indium borophosphates have been reported recently, including KIn[BP2O8(OH)](I) and NaIn[BP2O8(OH)](H). The latter two compounds were synthesized under mild hydrothermal conditions, and have the same molar ratio (M-I:In:B:P:O:H) in molecular formula but with different structure types. Compound I crystallizes in the triclinic system with space group P (1) over bar (No.2), a=0.52638(4) nm, b=0.84791(5) nm, c=0.81469(9) nm, alpha=91.1741(7)degrees, beta=93.061(7)degrees, gamma=79.823(5)degrees, V=0.3573 nm(3), Z=2; while compound II possesses a monoclinic structure with space group P2(1)/n (No.14) with a=0.5177(1) nm, b=1.6815(3) nm, c=0.7684(2) nm, beta=94.10(3)degrees, V=0.6672(2) nm(3), Z=4. Eight- membered-ring and six-membered-ring are formed by alternating borate, phosphate tetrahedra and In-coordination octahedron sharing corners via common oxygen atoms in compound I and H respectively. The polyhedra in the structure are oriented along certain direction to form alternating layered fragments. These two structure types can be considered as intergrowth structures, which consist of the same layered fragments growing in different orientations. Other structure intergrowth possibilities are also expected in similar systems

无偿献血者中隐匿性乙型肝炎病毒感染及表面抗原突变分析

采用多种免疫学检测和核酸检测相结合的方法调查了我国南方某城市无偿献血者中隐匿性乙型肝炎病毒(HBV)感染的存在情况。结果在9023例乙肝表面抗原(HBsAg)阴性的无偿献血者中,共发现17例HBV DNA阳性,隐匿性HBV感染者的发生率为0.19%(95%CI:0.11～0.30%)。序列分析显示其中6例在HBsAg"a"表位(aa124～aa147)存在不同程度氨基酸突变,突变发生率为42.9%(6/14,有3例未扩增出"a"表位片段序列),G145R突变是该地区隐匿性HBV携带者中发生频率最高的突变(4/6,66.7%)。隐匿性HBV感染者中基因型C的比例(10/17)显著高于HBsAg阳性的HBV感染者(0/15,P<0.01)