基于Oracle数据库海量数据的查询优化研究

系统数据库数据量大时,常常会遇到系统响应时间过长、占用系统资源过多等一系列问题。因此对海量数据查询技术的研究就很必要。文中基于Oracle数据库,采用各种措施和方法来提高响应速度：合理设计数据库结构、使用索引、分区、SQL语句优化等手段优化数据库。另外,分页显示查询结果也能很大地提高查询速度。实验证明,优化后速度明显提高了很多。因此可见,文中采用的优化方法对海量数据的查询优化是正确有效的。     

基于Flash Builder4.0＋ MyEclipse8.5的新病案首页系统设计与实现

采用Flash Builder4.0、MyEclipse8.5为开发工具,Oracle 10g为数据库,开发了新病案首页系统,详细阐述了系统的设计流程、功能分析和数据库设计与实现。     

基于互触发的Oracle细粒度数据保护和恢复的研究及实现

本系统的主要思路是利用Oracle的触发器、Flash Recovery Area等技术,结合J2EE技术,实现一套基于B/S架构的Oracle数据保护和恢复系统,包括权限管理、数据恢复、系统管理三大模块,旨在解决以下问题:(1)建立新的权限控制。Oracle自带的权限控制不够安全,本系统拟创建一套新的权限体系,作为对Oracle的权限的补充,使业务系统的数据使用起来更加安全;(2)建立新的数据恢复。用软件实现Oracle的数据实时恢复,在真正执行危险操作以后,对数据进行针对性地、迅速恢复;(3)实现互触发保护,避免"通过人为的方式直接去drop触发器"之类操作的实现。     

基于单片机的多功能充电器的设计与实现

本课题主要研究基于单片机的多功能充电器,解决对不同电池的快速充电。通过对ATmega8的深入研究,利用它的高性能,设计完全实现了电池充电器设计的功能。本设计可以通过按键切换,对的密封铅酸电池(SLA)和镍镉电池(NiCd)进行充电,并通过LCD清楚地看到其充电状态。同时利用放大电路和Atmega8本身的AD转换器显示对电池电压和电流的实时测量,以较好的控制充电过程,保护电池。     

The Effect of Hypoxia on the Expression of CXC Chemokines and CXC Chemokine Receptors—A Review of Literature

Hypoxia is an integral component of the tumor microenvironment. Either as chronic or cycling hypoxia, it exerts a similar effect on cancer processes by activating hypoxia-inducible factor-1 (HIF-1) and nuclear factor (NF-κB), with cycling hypoxia showing a stronger proinflammatory influence. One of the systems affected by hypoxia is the CXC chemokine system. This paper reviews all available information on hypoxia-induced changes in the expression of all CXC chemokines (CXCL1, CXCL2, CXCL3, CXCL4, CXCL5, CXCL6, CXCL7, CXCL8 (IL-8), CXCL9, CXCL10, CXCL11, CXCL12 (SDF-1), CXCL13, CXCL14, CXCL15, CXCL16, CXCL17) as well as CXC chemokine receptors—CXCR1, CXCR2, CXCR3, CXCR4, CXCR5, CXCR6, CXCR7 and CXCR8. First, we present basic information on the effect of these chemoattractant cytokines on cancer processes. We then discuss the effect of hypoxia-induced changes on CXC chemokine expression on the angiogenesis, lymphangiogenesis and recruitment of various cells to the tumor niche, including myeloid-derived suppressor cells (MDSCs), tumor-associated macrophages (TAMs), tumor-associated neutrophils (TANs), regulatory T cells (T_regs) and tumor-infiltrating lymphocytes (TILs). Finally, the review summarizes data on the use of drugs targeting the CXC chemokine system in cancer therapies.     

Investigating T Cell Immunity in Cancer: Achievements and Prospects

T cells play a key role in tumour surveillance, both identifying and eliminating transformed cells. However, as tumours become established they form their own suppressive microenvironments capable of shutting down T cell function, and allowing tumours to persist and grow. To further understand the tumour microenvironment, including the interplay between different immune cells and their role in anti-tumour immune responses, a number of studies from mouse models to clinical trials have been performed. In this review, we examine mechanisms utilized by tumour cells to reduce their visibility to CD8⁺ Cytotoxic T lymphocytes (CTL), as well as therapeutic strategies trialled to overcome these tumour-evasion mechanisms. Next, we summarize recent advances in approaches to enhance CAR T cell activity and persistence over the past 10 years, including bispecific CAR T cell design and early evidence of efficacy. Lastly, we examine mechanisms of T cell infiltration and tumour regression, and discuss the strengths and weaknesses of different strategies to investigate T cell function in murine tumour models.     

Subcellular Localization of Acyl-CoA: Lysophosphatidylethanolamine Acyltransferases (LPEATs) and the Effects of Knocking-Out and Overexpression of Their Genes on Autophagy Markers Level and Life Span of A. thaliana

Arabidopsis thaliana possesses two acyl-CoA:lysophosphatidylethanolamine acyltransferases, LPEAT1 and LPEAT2, which are encoded by At1g80950 and At2g45670 genes, respectively. Both single lpeat2 mutant and double lpeat1 lpeat2 mutant plants exhibit a variety of conspicuous phenotypes, including dwarfed growth. Confocal microscopic analysis of tobacco suspension-cultured cells transiently transformed with green fluorescent protein-tagged versions of LPEAT1 or LPEAT2 revealed that LPEAT1 is localized to the endoplasmic reticulum (ER), whereas LPEAT2 is localized to both Golgi and late endosomes. Considering that the primary product of the reaction catalyzed by LPEATs is phosphatidylethanolamine, which is known to be covalently conjugated with autophagy-related protein ATG8 during a key step of the formation of autophagosomes, we investigated the requirements for LPEATs to engage in autophagic activity in Arabidopsis. Knocking out of either or both LPEAT genes led to enhanced accumulation of the autophagic adaptor protein NBR1 and decreased levels of both ATG8a mRNA and total ATG8 protein. Moreover, we detected significantly fewer membrane objects in the vacuoles of lpeat1 lpeat2 double mutant mesophyll cells than in vacuoles of control plants. However, contrary to what has been reported on autophagy deficient plants, the lpeat mutants displayed a prolonged life span compared to wild type, including delayed senescence.     

3Cr2W8V钢强韧化处理研究

本文从强韧化机制方面，研究了用于铝合金型材挤压模具的３Ｃｒ２Ｗ８Ｖ钢在不同热处理工艺条件下的金相组织，显微结构与断口，常温与高温下的力学性能。结果表明，采用１２５０℃以上超高温淬火加４００－５００℃中温回火的强韧化处理工艺，可使该钢同时获得具有良好力学性能和较好韧性、热强性、热稳定性、热疲劳性、耐磨性等相结合的综合性能。     

高炉物料消耗计量数据自动认证系统的设计与实现*

以某钢铁企业为背景,针对手工认证方式实时性差、精确度低的特点,设计并实现了一套计量数据自动认证系统.该系统通过分析计量数据异常的类型,建立计量数据分析处理智能模型,实现了对计量数据按班进行差错分析和自动认证的功能,认证结果可以自动报送ERP系统.自动认证系统基于Oracle 9i数据库和PowerBuilder 8.0前台开发软件实现,具备自动认证和报表统计功能,是钢铁企业信息管理系统的重要组成部分.