|
|
|
| Construction and application of breast cancer database based on cloud platform |
| Xue Li, Chen Caiping, Han Chao, Xing Dan, Lu Xiang |
| The First Hospital of Jiaxing, Jiaxing 314001, China |
|
|
|
|
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.
|
|
Received: 23 August 2021
|
|
|
|
［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．
|
| [1] |
Zhou Lifang, Li Qiong, Que Qiaoyan. Mediating effect of resilience on the relationship between coping style and self-regulatory fatigue in young and middle-aged breast cancer survivors[J]. journal1, 2021, 28(4): 315-320. |
| [2] |
Liu Mengyang, Tian Yuan, An Ning, Zhang Liyuan, Wei Li, Liu Meina. . Analysis of influencing factors of postoperative complications of breast cancer based on two-level logistic random effects model[J]. journal1, 2021, 28(3): 200-205. |
| [3] |
Li Xi, Liu Meina, Zhang Qiuju. Study on the influencing factors of breast conserving surgery for early breast cancer based on multiple correspondence analysis[J]. journal1, 2020, 27(6): 490-493. |
| [4] |
Bao Xiaoqiang, Liu Meina, Wang Yupeng. . Analysis of influence factors of breast cancer treatment quality based on evaluation indicators
[J]. journal1, 2020, 27(5): 397-402. |
| [5] |
Bao Xiaoqiang,Li Jingkun,Tian Yuan,Liu Mengyang,Liu Meina.. Evaluation on treatment quality of breast cancer based on intervention studies [J]. journal1, 2020, 27(3): 246-250. |
| [6] |
Tian Qi.. Work mode of medical and health statistics based on database management structure [J]. journal1, 2020, 27(3): 242-245. |
|
|
|
|
