ObjectiveScreening the Database from Colorectal Cancer (DACCA) based on West China Hospial data by " Operation Date”, we purposed to analyze the population characteristics of colorectal cancer patients in regional medical center within recent Database Version.MethodsThe DACCA Version was updated in December 12th, 2018. Personal data (including sex, age, blood type, height, weight, and BMI), location data (including provinces, cities, and subordinate areas in Chengdu), occupation and education data, and main diagnosis data were included in the items. Characteristic analysis was performed on each selected data item.ResultsAccording to screening, 9 633 analytical data rows were obtained. Based on the database information, there were 24 consecutive years from 1995 to 2018 into every year. We set 2005 to 2006 as the time node for the database construction. The contribution to database before 2005 (including) was 1 358, while after 2005 (not including) were 8 275. The contribution rate (contribution numbers/years) after 2005 was higher than before 2005 ［1 358/11 vs. 8 275/13, 95% CI was (–625.337, –400.831), P<0.001］. According to gender distribution, total male data were 4 669, female were 3 340, non-checked were 1 624. According to age distribution, age were from 13 to 104 ［(59±13) years］. Linear prediction was used to predict the age distribution with the " year” as the time axis. The results showed the stable linear prediction (\begin{document}$\hat y$\end{document}=0.016 1x+26.54, R2=3.42×105, P=0.601 108). According to height, height were from 138 cm to 192 cm ［(161±7)cm］, linear prediction results showed that the linear variation with height changes by value (\begin{document}$\hat y$\end{document}=0.110 5 x–60.911, R2=0.002 6, P=0.000 272). According to weight, weight were from 27.5 kg to 80.5 kg ［(59.38±10.27) kg］, linear prediction results showed that the linear variation with height changes by value (\begin{document}$\hat y$\end{document}=0.296 5x–537.24, R2=0.010 625, P=2.37×1014). Available 6 884 data showed the difference between serving areas by West China Hospital and official definition of western region. A total of 9 209 data obtained by analyzing main diagnosis, showed that the main site of disease was rectum (68.64%). Sigmoid was the main location of colon cancer (68.64%), and anal-rectal cancer was main of rectal cancer (27.06%).ConclusionPopulation characteristics from DACCA database could initially reflect the trend of increasing weight and BMI of colorectal cancer patients, and also reflect the regional distribution characteristics based on geographic information. They would be the clues for further database research.
ObjectiveTo analyze the characteristics of colorectal cancer surgery in the current version of Database from Colorectal Cancer (DACCA).MethodsThe DACCA version selected for this data analysis was the updated version on April 16th, 2020. The data items included timing of operation, types of operative procedure, radical resection level of operation, patient’s wish of anus-reserving, types of stomy, date of stoma closure, surgical approaches, extended resection, and type of intersphincteric resection (ISR). The data item interval of stoma closure was added, and the selected data items were statistically analyzed.ResultsThe total number of medical records (data rows) that met the criteria was 11 757, including 2 729 valid data on the timing of operation (23.2%), 11 389 valid data on the types of operative procedure (96.9%), 4 255 valid data on the radical resection level of operation (36.2%), 3 803 valid data on patient’s wish of anus-reserving (32.3%), 4 377 valid data on types of stomy (37.2%), 989 valid data on date of stoma closure (8.4%), 4 418 valid data on surgical approaches (37.6%), 3 941 valid data on extended resection (33.5%), and 1 156 valid data on type of ISR (9.8%). In the timing of operation, the most cases were performed immediately after discovery or neoadjuvant completion (915, 33.5%). In types of operative procedure, ultra low anterior resection (ULAR), right hemicolectomy (RHC), and low anterior resection (LAR) were the most, including 1 986 (17.4%), 1 412 (12.4%), and 1 041 (9.1%) lines. Respectively in the colon and rectal cancer surgery, the proportion of RHC (50.0%) and ULAR (26.0%) was the highest, with 172 (26.1%) and 815 (27.9%) extended resection. In ISR surgery the majority was ISR-2 (741, 64.1%). In radical resection level of operation, the number of R0 was the largest with 2 575 (60.5%) lines. In patient’s wish of anus-reserving, positive and rational were the most with 1 811 (47.6%) and 1 440 (37.9%) lines, respectively. And in types of stomy, there were 2 628 lines (60.0%) without stoma and 1 749 cases (40.0%) with stoma, among which the most lines were right lower ileum stoma (612, 35.0%). The minimum value, maximum value, and median value of interval of stoma closure were 0 d, 2 678 d and 112 d. The linear regression prediction of date of stoma closure by year was \begin{document}${\hat {y}} $\end{document}=9.234 3x+22.394 (R2=0.2928, P=0.07). In the surgical approaches, the majority was standard with 3 182 (72.0%) lines.ConclusionsIn the DACCA, rectal cancer surgery is still the majority, and ULAR is the most type. The application of extended resection in both colon and rectal cancer has important significance. The data related to stoma are diversified and need to be further studied.
ObjectiveTo describe the constructive process of neoadjuvant therapy for colorectal cancer part in the West China Colorectal Cancer Database (DACCA).MethodWe used the form of text description.ResultsThe specific concept of neoadjuvant therapy for colorectal cancer including neoadjuvant treatment therapies, compliance of patients with neoadjuvant therapy, neoadjuvant therapy intensity scheme, the CEA value of patients during neoadjuvant therapy, changes of symptoms, changes of primary tumor size in colorectal cancer, and TRG grading of the DACCA in the West China Hospital were defined. Then the neoadjuvant therapies were detailed for their definition, label, structure, error correction, and update.ConclusionThrough detailed description and specification of neoadjuvant therapy for colorectal cancer in DACCA in West China Hospital, it can provide a reference for the standardized treatment of colorectal cancer and also provide experiences for the peers who wish to build a colorectal cancer database.
ObjectiveTo elaborate constitute, definition, and interpretation of stage module of colorectal cancer in the Database from Colorectal Cancer (DACCA) in the West China Hospital.MethodThe article was described in the words.ResultsIn the DACCA, the columns were selected by the colorectal cancer staging module. The overall stages included: the stage during surgery, cpi comprehensive stage, and TNM stage. The classified stages included: the T, N, and M stages of pathology, clinical, and imaging; The risk factors included the cancerous contamination and high-risk factors. Then these items were subdivided and detailed for their definition, form, label and structure, error correction and update, and how to be used in the analysis of data in the DACCA.ConclusionsThrough detailed description and specification of current stage module of colorectal cancer in DACCA in West China Hospital, it can provide a reference for standardized treatment of colorectal cancer and also provide experiences for the peers who wish to build a colorectal cancer database.
ObjectiveTo 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.MethodThe article was described in the words.ResultsThe 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.ConclusionsBased 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.
ObjectiveTo analyze the characteristics of colorectal cancer surgery in the current version of Database from Colorectal Cancer (DACCA).MethodsThe DACCA version selected for this data analysis was the updated version on July 16th, 2020. The data items included operative duration, anatomy (anatomical difficulty), pelvis (pelvic stenosis), obesity (abdominal obesity), adhesion (adhesion in surgical area), mesentery (abnormal mesenteric status), hypertrophy (tissue hypertrophy or organ hypertrophy), intestinal quality, death (risk of death), injury (risk of tissue injury), recurrence (tumor recurrence), metastasis (tumor metastasis), anastomotic leakage (risk of anastomotic leakage), difficulty of operation, prognosis, quality of operation. The selected data items were statistically analyzed.ResultsThetotal number of medical records (data rows) that met the criteria was 6 116. Spearman correlation text showed a negative correlation between operative duration and years (rs=–0.433, P<0.001). In anatomy, pelvis, obesity, adhesion, mesentery, and hypertrophy, the most cases were “normal or basically normal”, and the percentages were 32.55%, 44.52%, 48.68%, 55.79%, 53.36%, and 57.72%, respectively. In quality of intestinal, the highest proportion was “bad” (43.25%). In risk of death, risk of tissue injury, and tumor recurrence, the most cases were “very small”, and the percentages were 69.00%, 94.41%, and 68.21%, respectively. In tumor metastasis, risk of anastomotic leakage, difficulty of operation, prognosis, and quality of operation, the highest proportion were “small” (48.58%), “average” (49.25%), “average” (32.96%), “uncertain” (45.65%), and “very good” (39.85%).ConclusionsIn the DACCA, the intestinal quality is characteristic of difficulty in operation, and in the evaluation of operation quality, the judgment of anastomotic leakage deserves much more attention. However, the relationship between the difficulty of operation and postoperative effects, and the relationship between the quality of operation and the prognosis still need to be further studied.
ObjectiveTo elaborate constitute, definition, and interpretation of operative characteristics of colorectal cancer in the Database from Colorectal Cancer (DACCA) in the West China Hospital.MethodThe article was described in the words.ResultsIn the DACCA, the operative characteristics module of colorectal cancer mainly included five parts: surgical characteristics, surgical methods, operative skills in details, surgical difficulties, and surgical quality evaluation. Then the surgical characteristics were detailed for their definition, form, label and structure, error correction and update, and how to be used in the analysis of data in the DACCA.ConclusionsThrough detailed description and speci-fication of surgical characteristics of colorectal cancer in DACCA in West China Hospital, it can provide a reference for standar-dized treatment of colorectal cancer and also provide experiences for the peers who wish to build a colorectal cancer database.
ObjectiveTo explore the methods of data management and statistical analysis for longitudinal big data collected from mobile health management applications (APP). MethodsThe data management process and statistical analysis method were proposed by summarizing the characteristics of the data from mobile health management APPs. The methods would be clarified by a practical case: an APP recording female menstruation. ResultsThe data from health management APPs belong to longitudinal big data and the original record of the APP should be reprocessed or computed before conducting statistical analysis. A two-step data cleaning procedure was suggested for data management of the original records and reprocessed data, and longitudinal models such as mixed models was recommended for statistical analysis. ConclusionsThe data from health management APPs could be used for medical research via specific data management and statistical analysis after removing suspicious data. Cloud computing could be a viable method to improve efficiency of the big data analysis of health management APPs.
ObjectiveTo analyze the tumor characteristics of colorectal cancer in the current version of Database from Colorectal Cancer (DACCA).MethodsThe DACCA version was the updated version on April 16, 2020. The data items including: procedure of anastomosis, shape of anastomosis, enhanced suture for anastomosis, stuffing, drainage, coverage of major omentum, anti-adhesion material, reconstruction of pelvic peritoneum, contaminate, and drug implants were analyzed for the characteristics of each selected data item.ResultsA total of 6 338 analyzable data rows were obtained by screening the DACCA database. Among the 6 338 pieces of data, the most common one was the double staple technique (58.1%), end-to-end anastomosis (69.4%), one-total-circle of enhancement (33.2%), and without stuffing (54.1%) in the items of procedure of anastomosis, shape of anastomosis, enhanced suture for anastomosis, stuffing, respectively; the ratio with drainage was higher (79.2%) in the term of drainage, the drainage time was (3.74±2.89) d and median drainage time was 3.00 d; the ratio with covering part of major omentum, without anti-adhesion material, with unilateral partial closure, without contaminate, and without drug implants were more higher, which was 41.1%, 79.8%, 58.7%, 73.9%, and 53.9% in the items of coverage of major omentum, anti-adhesion material, reconstruction of pelvic peritoneum, contaminate, and drug implants, respectively.ConclusionIt might better explain the outcome of surgery associated with intraoperative operation by studying the features of surgery of DACCA and guide the operation in the future for better outcomes.
ObjectiveTo describe the characteristics of colorectal cancer surgical procedures in the West China Colorectal Cancer Database (Database from Colorectal Cancer, DACCA).MethodWe used the form of text description.ResultsThe related content modules of DACCA operation in West China, included operative type, radical resection level, anus preservation, stoma type, the date of closure, surgical approach, expansive resection, intersphincteric resection (ISR), etc. were elaborated. The data label related method corresponding to each item in the database and the structured method required in the corresponding big data application stage were elaborated, and the error correction precautions of all classified items were described.ConclusionsIn the DACCA database, there are more detailed classification for the radical treatment of colorectal cancer. The application of expanded surgery is of great significance for both colon cancer and rectal cancer; stoma-related data has diversified data characteristics, which will provides standards and basis for clinical application of DACCA, and also provides experience reference for other colleagues who want to build colorectal cancer database.