Design and Implementation of Customer Management and Analysis System for a Commercial Bank Based on OLAP

随着经济全球化步伐的加速和中国金融业面向外资银行的开放，某商业银行作为一家新兴的、发展中的银行要想在激烈的市场竞争中取胜，工作重心就必须转到以客户为中心，为客户提供优质服务上来。但在海量客户数据面前，一般传统的统计技术已经跟不上时代的步伐，数据挖掘技术能够从大型数据仓库中挖掘有价值的信息，能够有效解决银行客户关系中处理客户信息的难题。提高银行业在客户关系管理的水平，达到了提高银行竞争力的目的。 本系统的设计和开发依据软件工程理论，完成了系统的需求分析、系统的设计、系统的实现和系统的测试工作。系统采用目前广泛使用的J2EE开发平台和B/S开发架构，前台页面通过HTML5技术进行布局设计，使用J...With the pace of economic globalization accelerating and China's financial industry opening up for foreign banks, China's banking industry is facing huge pressures and challenges. In order to win in the fierce market competition, the bank must focus on the customers, providing customers with high quality service. Faced with large quantities of statistics of customers, traditional technology of sta...学位：工程硕士院系专业：软件学院_软件工程学号：X201323130

Material and Energy Conversion of Integrated 100,t/a-Scale Bio-Jet Fuel-Range Hydrocarbon Production System via Aqueous Conversion of Biomass

以农业废弃物生物质为原料，利用水相转化技术，进行了百吨/年规模生物航油类烃(C8~C15)合成试运行.过程中采用两步酸解法分别将玉米秸秆中半纤维素和纤维素转化为糠醛和乙酰丙酸，作为生物质基平台化合物.在碱性条件下糠醛与乙酰丙酸经Aldol缩合反应实现碳链增长，生成的长链含氧中间体经过低温预加氢、高温加氢脱氧及精制，生成C8~C15范围内液态烃，可作为生物航油组分.以试运行实验结果为基础，进行了过程的物质与能量转化分析.结果表明，该路线获得液态烃类的基本性质满足合成航油ASTM-7566标准要求，并充分利用了原料中纤维素和半纤维素组分，是一条基于生物质的长链液态烃合成路线，1t航油约需10~12t干基玉米秸秆

Preparation and permeation characteristics of PVA/PEG/TEOS hybrid membranes

以聚乙烯醇(PVA)与聚乙二醇(PEG)共混,并与正硅酸乙酯(TEOS)进行交联反应制备杂化膜。FTIR证实杂化溶胶液发生交联反应形成共价键Si—O—C,WXRD观察表明加入TEOS改变了膜结晶度,加入PEG提高了PVA膜对乙醇/水溶液的渗透通量,但分离因子下降,随着TEOS的加入,膜的分离因子提高。在TEOS质量分数为10%时,杂化膜的分离因子达到最大。提高退火温度可以提高膜的分离因子,但通量下降。在100℃下退火12 h的杂化膜对乙醇质量分数为85%的乙醇/水溶液的分离性能最佳。Poly(vinyl alcohol)(PVA) was mixed with poly(ethylene glycol)(PEG) and then cross-linked by tetraethoxysilane (TEOS) to prepare organic-inorganic hybrid membranes.Fourier transform infrared spectroscopy(FTIR) proved that covalent bond Si—O—C was formed in the hybrid membranes.Wide-angle X-ray diffraction(WAXD) was used to observe the effect of TEOS and annealing on crystallinity.The hybrid membranes were tested in separation ethanol/water mixture by pervaporation.The effect of PEG,TEOS content and annealing temperature on the PVA hybrid membrane performance was discussed.The addition of PEG increased the PVA membrane flux,but its selectivity decreased.Water permselectivity increased with the addition of TEOS into the PVA/PEG membrane.The hybrid membrane exhibited the highest water permselectivity when TEOS mass fraction was 10%.Water permselectivity increased by increasing the annealing temperature,but permeation flux decreased at the same time.The hybrid membrane separation performance was best for pervaporation of water/ethanol(85%mass fraction of ethanol) mixture when annealing at 100 ℃ for 12 h.国家自然科学基金资助项目(50573063);; 高等学校博士点专项基金资助项目(20050384013

Fabrication and bacterial adhesion of metal dry electrode with surface microstructure arrays

为开发出高性能生物医用干式电极,提出了利用激光微铣-重铸加工方法,实现了表面具有微结构阵列特征的新型金属干式电极的制造成形。在分析电极表面微观形; 貌的基础上,研究了电极表面的润湿性能,并重点研究了扫描间距、扫描速度和扫描次数等加工参数对大肠杆菌粘附性能的影响规律。研究结果表明:在一定工艺参; 数条件下所加工出具有微结构阵列特征的电极的接触角可达150°以上,表现出超疏水的特性。在不同扫描间隙和扫描次数条件下加工出的电极对大肠杆菌的粘附; 性能具有较大影响,在选择0.1; mm扫描间隙时,电极表面粘附的大肠杆菌数量最少,适当增加扫描次数,也能够有效地减少电极表面大肠杆菌的粘结,从而发挥较好的抗菌效果。通过改变扫描速; 度加工出的电极则对大肠杆菌的粘附性能影响不大。To develop a high performance biomedical dry electrode, the laser; micromilling-recasting technology is used to fabricate the metal dry; electrode with surface micostructure arrays. Based on the analysis of; the micro morphology of the electrode surface, the wettability of the; electrode surface is discussed, and then the influence of laser; processing parameters such as scanning spacing, scanning speed and scan; times on the adhesion performance of Escherichia coli is further; investigated. The results show that the contact angle of metal dry; electrode with surface microstructure arrays fabricated with reasonable; laser processing parameter can reach more than 150° and show the; superhydrophobic characteristics. The adhesion performance of; escherichia coli of electrode is changed greatly with different scanning; spacing and scan times. When the 0.1 mm scanning spacing is selected,; the least amount of escherichia coli is found on the surface of; electrode. With the increasing scan times, the adhesion amount of; escherichia coli can be reduced. However, the scanned speed has little; effect on the adhesion performance of escherichia coli for metal dry; electrode.国家自然科学基金面上项目; 厦门市科技计划项目; 厦门市科技惠民项

Optimization of Hydrometallurgical Purification for SiO_2 in the Process of Preparing Solar-grade Silicon

考察了Hf质量分数、H2C2O4质量分数、HnO3质量分数、酸浸时间、粒径、液体质量与固体质量的比值(简称液固比,下同)等因素对混酸法提纯SIO2工艺过程的影响,利用电感耦合等离子体发射光谱仪(ICP-OES)、场发射扫描电子显微镜(SEM)进行表征。结果表明,最佳工艺条件为:W(Hf)=2%、W(H2C2O4)=3%、W(HnO3)=30%、酸浸时间4 H、粒径100~120目、液固比4∶1、酸浸温度30℃。fE、Al、CA、P杂质的去除率分别达到99.99%、14.02%、73.27%、60.00%,经混酸法处理后SIO2中杂质总量的质量分数降至1.465x10-4。As a pre-treatment unit for preparing solar-grade silicon,hydrometallurgical route could remove most metallic impurities in silicon dioxide(SiO2) and raise the yield of the final product.Acid leaching of SiO2 could reduce the cost and energy consumption of industrialized development.Combined with high purity of reducing agent,the successor process of pyrometallurgy can also achieve "continuous casting".Factors such as the mass fraction of leaching agent,time,the particle size of SiO2,and the liquid-solid ratio were investigated,and the samples were characterized by means of ICP-OES,SEM,etc.The optimal reaction conditions were as follows:w(HF)=2%,w(H2C2O4)=3%,w(HNO3)=30%,reaction time 4 h,the average size of SiO2 powder particle 100～120 mesh,the liquid-solid ratio 4∶1,and room temperature 30 ℃.It was found that the final removal rates of impurities of Fe,Al,Ca,P could reach 99.99%,14.02%,73.27%,and 60.00% respectively and the mass fraction of total amount of impurities could be reduced to 1.465×10-4

产前滴滴涕或多氯联苯暴露与出生缺陷风险相关性的Meta分析

目的系统评价孕妇产前暴露于滴滴涕(DDT)或多氯联苯(PCBs)与新生儿出生缺陷风险之间的关系。方法计算机检索PubMed、EMbase、WanFang Data、VIP和CNKI数据库,搜集有关产前DDT或PCBs暴露与出生缺陷关系的病例-对照研究,检索时限均从建库至2017年2月。由2名研究者独立筛选文献、提取资料并评价纳入研究的偏倚风险后,采用Stata 13.0软件进行Meta分析。结果共纳入14个研究,包括2 238例出生缺陷新生儿和2 355例对照新生儿。Meta分析结果显示:产前暴露于高水平的DDT会导致新生儿隐睾发生率增加[OR=1.12,95%CI(1.09,1.15),P<0.001]。而DDT暴露与尿道下裂和神经管畸形发生没有相关性。产前暴露于高水平的PCBs与隐睾、尿道下裂、神经管畸形发生也没有相关性。结论孕妇产前暴露于高水平的DDT可能是隐睾发生的危险因素。受纳入研究数量和质量的限制,上述结论尚待更多高质量研究予以验证。厦门市科技计划项目(编号:3502Z20163006);;厦门市集美区科技计划项目(编号:20142C01

布鲁菌病44例临床特征分析

目的分析大庆地区44例布鲁菌病患者临床表现及实验室相关指标的变化,为临床诊治提供依据。方法回顾性分析大庆油田总医院2014年2月-2018年8月44例布鲁菌病患者的临床特征。结果大庆地区布鲁菌病患者以农牧民(25例,56.8%)和30岁以上患者(31～69岁,93.2%)为主,临床主要表现为贫血30例(68.2%)、发热23例(52.3%)、胆囊疾病9例(20.5%)、脾肿大9例(20.5%)、胃炎7例(15.9%)、关节炎关节痛6例(13.6%)、睾丸附睾炎4例(9.1%)、心包积液4例(9.1%)、全血细胞减少2例(4.5%)、胸壁脓肿1例(2.3%)。实验室相关指标中,降钙素原(PCT)升高31例(31/32,96.9%),C反应蛋白(CRP)升高33例(33/35,94.3%),红细胞沉降率(ESR)增快11例(11/13,84.6%),44患者中白蛋白减少37例(84.1%),肝功能异常27例(61.4%),单核细胞增多23例(52.3%),白细胞升高10例(22.7%),血小板减少7例(15.9%)。结论布鲁菌病随受累器官不同临床表现多样,除常见症状外,胆囊病变也是其可能出现的临床特征;在实验室相关指标中,可出现单核细胞增多及血小板减少,PCT普遍升高且以轻度升高为主。临床医师应加强对该病的认识,以做到早期诊断和治疗

环状RNA circ_0120051通过miR-144-3p/IDH2轴抑制心肌成纤维细胞的纤维化表型研究

目的研究环形 RNA circ_0120051对心肌成纤维细胞的纤维化表型的调控作用和机制。方法通过实时萤光定量PCR（RT-qPCR）检测健康器官捐献者（n=24）与心力衰竭（HF）病人（n=21）心肌标本中 circ_0120051及其宿主基因溶质载体家族8成员A1（SLC8A1）的表达水平。核糖核酸外切酶（RNase R）消化实验鉴定circ_0120051的RNA稳定性。RT-qPCR检测circ_0120051在人心肌细胞AC16中的核质分布情况。利用腺病毒在C57BL/6乳小鼠心肌成纤维细胞（mCFs）中过表达circ_0120051，通过RT-qPCR和Western blot检测过表达circ_0120051对mCFs中纤维化相关基因表达的影响，利用细胞划痕实验检测对mCFs迁移能力的影响。通过RNA免疫共沉淀技术（RIP）验证circ_0120051与miR-144-3p间的结合作用，利用双萤光素酶报告基因实验鉴定miR-144-3p与靶基因异柠檬酸脱氢酶2（Idh2） 3’-UTR的结合位点。结果Circ_0120051在心衰病人心肌中表达显著增加，而其宿主基因SLC8A1表达无显著差异。Circ_0120051主要定位于人心肌细胞的胞质中。RNase R消化实验证实circ_0120051相对于线性SLC8A1 mRNA具有典型的环状RNA稳定性。过表达circ_0120051可抑制mCFs中纤维化相关基因表达和mCFs的迁移能力。RIP实验证实circ_0120051与miR-144-3p之间具有明显结合作用。在mCFs中转染miR-144-3p可促进纤维化相关基因的表达，并有效逆转circ_0120051对mCFs纤维化表型的抑制作用。双萤光素酶报告基因实验证实miR-144-3p与Idh2的3’-UTR存在结合作用。miR-144-3p可在转录水平抑制mCFs中Idh2表达，而过表达circ_0120051可增加mCFs中IDH2表达。在mCFs中转染miR-144-3p和Idh2的小干扰RNA（siRNA），可一致性地逆转circ_0120051对纤维化相关基因表达和mCFs迁移的抑制作用。结论Circ_0120051通过特异结合miR-144-3p并增加其靶基因IDH2表达来发挥抑制mCFs纤维化表型的作用

Thermodynamic Analysis of the Efficiency Improvement of a Photovoltaic-thermoelectric Hybrid System

太阳能电池和热电模块组成的复合系统有望获得较高的太阳能到电能的转换效率。本文利用热力学方法分析了由商业化太阳能电池构成的复合系统,并根据一维模型下能流输运特性计算了系统内各模块温度及其对转换效率的影响,发现低温度系数和低效率的太阳能电池可以通过构建复合系统获得更大的性能提升。同时,由于太阳辐照的有限性导致流经热电模块的热流受到限制,因此热电模块效率无法达到理想条件下的最优值。这表明复合系统的优化并非各个模块优化后结果的简单线性叠加,而需要考虑构成复合系统的各个模块间的约束条件进行整体计算和优化,即复合系统效率不仅与材料本征特性(如电导率、热导率等)有关,也和其工作状态(如入射太阳辐照强度、热电模块构成及几何尺寸、模块之间热学特性等)有关。上述模型与结果对于类似复合系统的设计有着指导作用。A hybrid system formed by a photovoltaic module and a thermoelectric module has a great potential to enhance the solar-to-electricity efficiency.A mathematical model based on the first law of thermodynamics and the heat transfer analyses of the hybrid system is built, where the overall efficiency of the system is enhanced by optimizing the system as a whole.The model is used to study hybrid systems formed by commercially available photovoltaic modules and thermoelectric modules.It is found that, due to a limited incoming heat flux for the thermoelectric module, the overall performance of the hybrid system depends not only on the intrinsic properties of the materials forming such a hybrid system, but also on their working conditions, such as incoming solar radiation, geometry of each module, and interfacial properties.The results indicate that only photovoltaic modules with low temperature coefficient and low efficiency can truly benefit from forming such hybrid system, and the optimization of a hybrid system must be done as a whole.教育部高等学校博士学科点专项科研基金新教师项目(20090121120028);教育部高等学校博士学科点专项科研基金博导类项目(20120121110021); 国家自然科学基金项目(U1232110

CircSLC8A1_005通过编码蛋白抑制心肌成纤维细胞纤维化表型的作用

目的探究环形RNA circSLC8A1_005调控心肌成纤维细胞纤维化表型的作用及可能机制。方法利用腺病毒介导在小鼠心肌成纤维细胞（mCFs）中过表达circSLC8A1_005，并检测mCFs中纤维化相关因I型胶原α1链（Col1a1）、Ⅲ型胶原α1链（Col3a1）和平滑肌肌动蛋白α2（Acta2）基因表达，通过EdU和划痕实验检测不同干预对mCFs的增殖和迁移能力的影响。双萤光素酶报告基因实验检测circSLC8A1_005包含的潜在核糖体进入序列（IRES）的活性。通过Western blot实验检测circSLC8A1_005翻译蛋白SLC8A1-605aa及其在细胞内分布情况。双萤光素酶报告基因实验检测SLC8A1-605aa对超氧化物歧化酶2（Sod2）的转录激活作用。通过RNA结合蛋白免疫沉淀（RIP）实验检测SLC8A1-605aa与Sod2 mRNA的结合作用。放线菌素D实验检测SLC8A1-605aa对Sod2 mRNA稳定性的影响。结果利用腺病毒可在mCFs中有效介导过表达circSLC8A1_005，过表达circSLC8A1_005可显著抑制mCFs中纤维化相关基因表达，抑制mCFs的增殖和迁移能力。双萤光素酶报告基因实验结果提示circSLC8A1_005包含的2个IRES具有活性。Western blot检测结果显示circSLC8A1_005可翻译预期大小为70 ku的SLC8A1-605aa蛋白，并主要分布于细胞核内。过表达SLC8A1-605aa和circSLC8A1_005可一致地抑制mCFs的纤维化表型。SLC8A1-605aa可特异上调超氧化物歧化酶2（Sod2）表达，但并不能转录激活Sod2表达；RIP实验结果显示SLC8A1-605aa与Sod2 mRNA有特异结合作用，而放线菌素D实验结果显示SLC8A1-605aa能够增强Sod2 mRNA的稳定性。结论CircSLC8A1_005通过翻译蛋白SLC8A1-605aa发挥抑制心肌成纤维细胞纤维化表型的作用，SLC8A1-605aa可能是潜在的用于心肌纤维化治疗的靶点