1.Research of Database Upgrade Method Based on Oracle
Zhizhong HUANG ; Zhanwei DU ; Wansong ZHENG
Chinese Medical Equipment Journal 1989;0(04):-
Objective To discuss the ideas and specific implementation steps of Oracle database upgrading.Methods By using the EXP and IMP which are provided by the Oracle database,import and export of entire database are implemented and complete database upgrading.Results The database is upgraded form Oracle 8i to Oracle 10g,which is the foundation of our hospital follow-up implementation of PACS and RAC technology.Conclusion Because the environment of practical application is different and complex,the Oracle database must test before the upgrading;the appropriate parameters are set according to different front-end application environment,and then enhance server performance significantly.
2.Design and Research of Decision Support System for Hospital Managers Based on HIS
Wansong ZHENG ; Zhizhong HUANG ; Zhanwei DU ; Haixia LIU
Chinese Medical Equipment Journal 2004;0(09):-
Objective To design a support system based on HIS for enhancing hospital managers' ability in making decision. Methods Through modeling and programming for the system,we integrate,classify and analyze the date from outside and inside. Results Managers can analyze the outcome using multi-dimensions online tools. This system brings the convenience to managers,and enhances scientific and timely decision. Conclusion We put forward the basic method for hospital support system,which is the foundation for future research.
3.Association of microsatellite polymorphism of MICA gene with susceptibility to esophageal cancer
Qingfeng ZHENG ; Zhifeng ZHOU ; Shuoyan LIU ; Wansong LIN ; Saiyun CHEN ; Yunbin YE
Chinese Journal of Immunology 2017;33(5):738-741,745
Objective:To explore the association of microsatellite polymorphism of MICA gene with susceptibility to esophageal cancer.Methods: PCR-STR microsatellite genotyped technique was used to detect the polymorphism of MICA in Exon 5 in 103 cases of esophageal cancer and 84 cases of normal controls.Constructed of eukaryotic expression vector in esophageal carcinoma with high frequency of occurrence of the MICA allele.NK cells killing effect to 293T cells after alleles MICA transfected were assayed by LDH and the effect on target was 20∶1.ELISA was used to test supernatants sMICA of 293T cell after transfected.Results: Identified five allelic genes in MICA Exon 5 with esophageal cancer.Each allele and its frequency respectively were:MICA-A4(9.71%),MICA-A5(22.3%),MICA-A5.1(40.8%),MICA-A6(15.5%),MICA-A9(11.7%).MICA-A5.1 showed significant difference comparison with the control group.After 293T cell line was transfected MICA allele,MICA-A5.1 group was less sensitive to NK cytotoxicity compared to other groups[(30.4±6.3)%,P<0.05].The secretion of soluble MICA increased(135.7±6.2)pg/ml.Conclusion: Esophageal cancer was relevent with the MICA-A5.1 polymorphism of MICA Exon 5 alleles.Its risk is higher than other alleles.