Part <b>Ⅱ</b> of database building: tag and structure of hospitalization process management of colorectal cancer_CHINESE JOURNAL OF BASES AND CLINICS IN GENERAL SURGERY

Authors：

WANG Xiaodong ¹ , LÜ Xinyi ^1,2 , HUANG Mingjun ³ , LI Ka ⁴ ,  LI Li ¹

1. Department of Gastrointestinal Surgery, West China Hospital, Sichuan University, Chengdu 610041, P. R. China;
2. West China School of Medicine, Sichuan University, Chengdu 610041, P. R. China;
3. Day Surgery Center, West China Hospital, Sichuan University, Chengdu 610041, P. R. China;
4. West China School of Nursing, Sichuan University, Chengdu 610041, P. R. China;

Corresponding author：

LI Li, Email: drlilli116@126.com

Keywords：

colorectal cancer; database; bigdata; process management; length of hospital; tag; structure

DOI：

10.7507/1007-9424.201905058

Video：

Export PDF Favorites Scan Get Citation

Abstract Full text Figures/Tables Video References Cited by

Objective To explain in detail hospitalization process management of colorectal cancer as well as its tag and structure of Database from Colorectal Cancer (DACCA) in the West China Hospital.Method The article was described in the words.Results The definition and setting of 8 classification items involved in the hospitalization process management from DACCA in the West China Hospital were set. The items were included the date of first out-patient meeting, admitted date, operative date, discharged date, waiting time before the admission, preoperative staying days, total hospital staying days, and manage protocol. The relevant data tag of each item and the structured way needed at the big data application stage were elaborated and the corrective precautions of classification items were described.Conclusions Based on description about hospitalization process management from DACCA in West China Hospital, it is provided a clinical standard and guidance for analyzing of DACCA in West China Hospital in future. It also could provide enough experiences for construction of colorectal cancer database by staff from same occupation.

Citation： WANG Xiaodong, LÜ Xinyi, HUANG Mingjun, LI Ka, LI Li. Part Ⅱ of database building: tag and structure of hospitalization process management of colorectal cancer. CHINESE JOURNAL OF BASES AND CLINICS IN GENERAL SURGERY, 2019, 26(7): 852-855. doi: 10.7507/1007-9424.201905058 Copy

1.	汪晓东, 李立. 真实场景与大数据下的整体微创理念, 大幅提高结直肠癌远期生存率. 中国普外基础与临床杂志, 2019, 26(1): 92-95.
2.	汪晓东, 李希, 何欣林, 等. 数据库研究第一部分: 区域性医疗中心的结直肠癌与人群特征. 中国普外基础与临床杂志, 2019, 26(2): 212-220.
3.	汪晓东, 安丽珉, 李立. 数据库研究第二部分: 结直肠癌的住院流程管理. 中国普外基础与临床杂志, 2019, 26(4): 469-475.
4.	汪晓东, 李立. 数据库建设第一部分: 个人数据的标签与结构化. 中国普外基础与临床杂志, 2019, 26(3): 335-342.
5.	Wang L, Wang X, Lo A, et al. Effects of radiation and surgery on function and quality of life (QOL) in rectal cancer patients. Am J Surg, 2018, 215(5): 863-866.
6.	Phang PT, Wang X. Current controversies in neoadjuvant chemoradiation of rectal cancer. Surg Oncol Clin N Am, 2014, 23(1): 79-92.
7.	汪晓东, 甘志明, 熊先泽, 等. Liver-first Approach治疗直肠癌伴肝转移患者术后疗效研究. 四川大学学报(医学版), 2015, 46(4): 654-656.
8.	Yeo H, Mao J, Abelson JS, et al. Development of a nonparametric predictive model for readmission risk in elderly adults after colon and rectal cancer surgery. J Am Geriatr Soc, 2016, 64(11): e125-e130.
9.	Doumouras AG, Tsao MW, Saleh F, et al. A population-based comparison of 30-day readmission after surgery for colon and rectal cancer: How are they different? J Surg Oncol, 2016, 114(3): 354-360.
10.	Microsoft. 表格制作和数据分析软件—Microsoft Excel. <https://products.office.com/zh-cn/excel>. 2019-05-15.
11.	Microsoft. 数据库管理系统软件—Microsoft Access. <https://products.office.com/zh-cn/access>. 2019-05-15.
12.	IBM. IBM Db2—Data Management Software. <https://www.ibm.com/analytics/db2>. 2019-05-15.
13.	Tableau. Business Intelligence and Analytics Software. <https://www.tableau.com/>. 2019-05-15.
14.	冯金华, 李立, 汪晓东, 等. 加速康复外科对结直肠癌患者术后炎性反应及细胞免疫功能影响的随机对照研究. 四川大学学报(医学版), 2016, 47(1): 131-134.
15.	刘展, 汪晓东, 李立. 结直肠外科快速流程内容及依据. 中国普外基础与临床杂志, 2007, 14(4): 469-473.
16.	肖凌, 王浩洋, 余曦, 等. 术后限制补液策略对不同体重指数结直肠癌患者的临床效果研究. 中国普外基础与临床杂志, 2010, 17(3): 289-293.
17.	肖凌, 李蔚, 李维, 等. 大肠癌限制补液策略对术后并发症的影响. 腹部外科, 2010, 23(2): 103-105.
18.	Bohl CJ, Parks A. A mnemonic for pharmacists to ensure optimal monitoring and safety of total parenteral nutrition: I am full. Ann Pharmacother, 2017, 51(7): 603-613.

1. 汪晓东, 李立. 真实场景与大数据下的整体微创理念, 大幅提高结直肠癌远期生存率. 中国普外基础与临床杂志, 2019, 26(1): 92-95.
2. 汪晓东, 李希, 何欣林, 等. 数据库研究第一部分: 区域性医疗中心的结直肠癌与人群特征. 中国普外基础与临床杂志, 2019, 26(2): 212-220.
3. 汪晓东, 安丽珉, 李立. 数据库研究第二部分: 结直肠癌的住院流程管理. 中国普外基础与临床杂志, 2019, 26(4): 469-475.
4. 汪晓东, 李立. 数据库建设第一部分: 个人数据的标签与结构化. 中国普外基础与临床杂志, 2019, 26(3): 335-342.
5. Wang L, Wang X, Lo A, et al. Effects of radiation and surgery on function and quality of life (QOL) in rectal cancer patients. Am J Surg, 2018, 215(5): 863-866.
6. Phang PT, Wang X. Current controversies in neoadjuvant chemoradiation of rectal cancer. Surg Oncol Clin N Am, 2014, 23(1): 79-92.
7. 汪晓东, 甘志明, 熊先泽, 等. Liver-first Approach治疗直肠癌伴肝转移患者术后疗效研究. 四川大学学报(医学版), 2015, 46(4): 654-656.
8. Yeo H, Mao J, Abelson JS, et al. Development of a nonparametric predictive model for readmission risk in elderly adults after colon and rectal cancer surgery. J Am Geriatr Soc, 2016, 64(11): e125-e130.
9. Doumouras AG, Tsao MW, Saleh F, et al. A population-based comparison of 30-day readmission after surgery for colon and rectal cancer: How are they different? J Surg Oncol, 2016, 114(3): 354-360.
10. Microsoft. 表格制作和数据分析软件—Microsoft Excel. <https://products.office.com/zh-cn/excel>. 2019-05-15.
11. Microsoft. 数据库管理系统软件—Microsoft Access. <https://products.office.com/zh-cn/access>. 2019-05-15.
12. IBM. IBM Db2—Data Management Software. <https://www.ibm.com/analytics/db2>. 2019-05-15.
13. Tableau. Business Intelligence and Analytics Software. <https://www.tableau.com/>. 2019-05-15.
14. 冯金华, 李立, 汪晓东, 等. 加速康复外科对结直肠癌患者术后炎性反应及细胞免疫功能影响的随机对照研究. 四川大学学报(医学版), 2016, 47(1): 131-134.
15. 刘展, 汪晓东, 李立. 结直肠外科快速流程内容及依据. 中国普外基础与临床杂志, 2007, 14(4): 469-473.
16. 肖凌, 王浩洋, 余曦, 等. 术后限制补液策略对不同体重指数结直肠癌患者的临床效果研究. 中国普外基础与临床杂志, 2010, 17(3): 289-293.
17. 肖凌, 李蔚, 李维, 等. 大肠癌限制补液策略对术后并发症的影响. 腹部外科, 2010, 23(2): 103-105.
18. Bohl CJ, Parks A. A mnemonic for pharmacists to ensure optimal monitoring and safety of total parenteral nutrition: I am full. Ann Pharmacother, 2017, 51(7): 603-613.

CHINESE JOURNAL OF BASES AND CLINICS IN GENERAL SURGERY

Part Ⅱ of database building: tag and structure of hospitalization process management of colorectal cancer

Abstract Full text Figures/Tables Video References Cited by

Previous Article

Next Article

Format

Content