基于浏览器和服务器架构的胃癌信息管理系统在临床中的应用

The clinical application of gastric cancer database based on Browser/Server

目的构建基于浏览器和服务器(Browser/Server,B/S)架构的胃癌专业数据库,并应用此数据库初步分析胃癌临床病理资料。方法应用Microsoft SQL Server 2000数据库管理系统构建B/S架构的胃癌数据库,应用此数据库,对胃癌病理学特征及治疗效果予以分析。结果到目前为止,共录入7 499例胃癌患者病历资料,准确率在95%以上。该系统检索、随访提醒和资料输出等方面功能方便快捷。2010年上半年数据显示,未手术患者的5年生存率为2.4%(3/125),手术患者为49.8%(142/285),其中R0切除患者为62.4%(133/213)。2014年数据显示患者术后TNM分期比例如下:Ⅰ期为27.5%(243/885),Ⅱ期为28.9%(256/885),Ⅲ期为39.9%(353/885),Ⅳ期为3.7%(33/885)。结论 B/S架构的胃癌数据库可准确存储临床病理资料,快捷查询统计大宗数据结果 ,可更准确地探讨胃癌发病特性,指导基础研究,进而提高胃癌的诊治水平。

Objective To discuss the creation of gastric cancer information database based on Browser/Server structure, and clinical application of such database to analyze recent data in our gastric center. Methods Microsoft SQL Server 2000 database management system was used to create our gastric cancer data base with Browser/Server as architecture. Using such database, clinicopathological characterritics and therapeutic outcomes of the gastric cancer patients in recent years were retrospectively analyzed. Results Untill now, clinicopathological and follow-up data of nearly 7500 gastric cancer patients were input in our database, the data input accuracy was above 95%. The functions of data retrieval, follow-up reminders and data output were convenient and efficient. According to the database of first half 2010, the 5- year survival rate of non-operation patients and surgical patients were 2.4% （3/125）and 49.8% （142/285） respectively, of which radical resection patients reached 62.4% （133/213）. According to the database of 2014, stage Ⅰpatients accounted for 27.5% （243/885）, stage Ⅱ 28.9% （256/885）, stage Ⅲ 39.9% （353/885）, stage Ⅳ3.7%（33/885） among the all surgical patients. Conclusions The gastric cancer database combined with standardized electronic medical records is accurate to record and store medical records. Through such database, we can analyze big data conveniently and efficiently in order to investigate the clinicopathologieal characteristics and prognosis of gastric cancer patients, and conduct our clinic and research.