Abstract:Objective The treatment and overall management of breast cancer is a longterm process, and the use of a computer database system to manage patients can help improve work efficiency. Based on the breast cancer database from the cloud platform, this article discussed its design and application experience. Methods The system adopted browser/server architecture, the server adopted one cloud server from Alibaba cloud and one cloud server from Tencent cloud, the database software adopted MySQL, and the server-side scripting language adopted PHP. The coders established a variety of tables in the database to store relevant data, and wrote dynamic webpage code to achieve functions like data entry, modification, and database management. Results A breast cancer database management system based on cloud platform was successfully established (computer software copyright registration No.: 2021SR0484007). The main database was run by the Alibaba cloud server and the backup database was run by the Tencent cloud server. The two databases were synchronized in real-time via the Internet. Thirteen patient-related data tables, 1 user permission data table, 6 database log tables, and 4 scientific research data tables were established. And 118 software code files were created, with a total of more than 20000 lines of code. By February 24, 2021, data of 2 763 breast cancer patients were stored. The database runs stably and meets the design requirements. Conclusion The breast cancer database management system based on cloud platform meets the design requirements, and the system runs stably with high security.
薛丽,陈彩萍,韩超,邢丹,陆翔. 基于云平台构建乳腺癌数据库及应用[J]. 中国医院统计, 2021, 28(5): 472-476.
Xue Li, Chen Caiping, Han Chao, Xing Dan, Lu Xiang. Construction and application of breast cancer database based on cloud platform. journal1, 2021, 28(5): 472-476.
[1]SUNG H, FERLAY J, SIEGEL R L, et al. Global Cancer Statistics 2020: GLOBOCAN Estimates of Incidence and Mortality Worldwide for 36 Cancers in 185 Countries[J]. CA Cancer J Clin, 2021,71(3):209-249.
[2]SCHLEICHER S M, DICKLER M N. Extended Adjuvant Aromatase Inhibitor Therapy in Post-Menopausal Women[J]. Curr Breast Cancer Rep, 2017,9(4):236-241.
[3]GOSS P E, INGLE J N, PRITCHARD K I, et al. Extending Aromatase-Inhibitor Adjuvant Therapy to 10 Years[J]. N Engl J Med, 2016,375(3):209-219.
[4]陆翔,韩文兰,喻其霞,等.乳腺癌ACCESS数据库的建立及应用体会[J].肿瘤学杂志,2011,17(5):343-345.
[5]沈坤炜,李宏为.真实世界研究与乳腺癌网络数据库建设[J].外科理论与实践,2017,22(5):369-370.
[6]高旭,王海峰,王燕,等.基于浏览器/服务器架构的前列腺癌数据库的构建和临床应用[J].中华泌尿外科杂志,2015,36(9):694-698.
[7]魏玉哲,薛英威.基于浏览器和服务器架构的胃癌信息管理系统在临床中的应用[J].消化肿瘤杂志,2015,7(3):161-164.
[8]王翔,陆琴.基于SQL语句的医院临时性数据统计[J].中国医院统计, 2021, 28(3): 282-285.
[9]田琪.基于数据库管理结构的医疗卫生统计工作模式探讨[J]. 中国医院统计, 2020, 27(3): 242-245.
[10]田洪亮,张勇,李超,等.云环境下数据库机密性保护技术研究综述[J].计算机学报,2017,40(10):2245-2270.