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