Objective To collect and store all interactions relating to medical information between our center and allied specialized hospitals by constructing a database system for thoracic surgery and pulmonary tuberculosis. Methods We collected all related medical records of patients who had been clinically diagnosed with pulmonary tuberculosis and tuberculous empyema using the CouchBase Database, including outpatient and inpatient system of the Department of Thoracic Surgery at the Public Health Clinical Center of Chengdu between January 2017 to June 2023. Then, we integrated all medical records derived from the radiology information system, hospital information system, image archiving and communication systems, and the laboratory information management system. Finally, we used artificial intelligence to generate a database system for the application of thoracic surgery on pulmonary tuberculosis, which stored structured medical data from different hospitals along with data collected from patients via WeChat users. The new database could share medical data between our center and allied hospitals by using a front-end processor. ResultsWe finally included 124 patients with 86 males and 38 females aged 43 (26, 56) years. A structured database for the application of thoracic surgery on patients with pulmonary tuberculosis was successfully constructed. A follow-up list created by the database can help outpatient doctors to complete follow-up tasks on time. All structured data can be downloaded in the form of Microsoft Excel files to meet the needs of different clinical researchers. Conclusion Our new database allows medical data to be structured, stored and shared between our center and allied hospitals. The database represents a powerful platform for interactions relating to regional information concerning pulmonary tuberculosis.
Objective To analyze the primary status of database in multi-disciplinary team （MDT） of colorectal cancer, and to explore the tendency in construction of database in the future. Methods Described the current status of different database respectively, and analyzed the data statistically, involving the patients’ general information, essential information of duration of hospital stay, therapy and MDT from the database of patients. Results The development of different database was uncoordinated. Among the total, the database of patients was advanced, the database of reference and the database of specialists were also developing in certain. Conclusion The primary reason, which results in the lag of construction of database currently, is the long span of database and the cost of much time in data acquisition. The direction of development of database involves consummation of database gradually, refreshment of it promptly, and expanding the research of informatics related clinical medicine.
ObjectiveTo analyze the impact of the residence of patients with colorectal cancer (CRC) on surgical characteristics in the current version Database from Colorectal Cancer (DACCA). MethodsAccording to the established screening conditions, the patients with CRC were collected from the updated version of DACCA on January 23, 2023. The analysis indicators enrolled in this study included: the grouping indicator was residence, the surgical characteristic indicators included the surgical timing, surgical nature, expanded resection, intersphincteric resection (ISR) type, patient’s willingness of preserving the anus, and whether preserving the anus. The patients were categorized into three groups based on the residence: inside Chengdu City, outside Chengdu City within Sichuan Province, and outside Sichuan Province. The surgical characteristic indicators of patients with CRC from different residences were comparatively analyzed. ResultsA total of 6 832 analyzable data rows were enrolled. The results of statistical analysis revealed the following findings: there were no statistical differences in the surgery timing and surgery nature among the patients with colon cancer or rectal cancer from the different residences (Surgery timing: H=1.665, P=0.435; H=4.153, P=0.125. Surgery nature: χ2=1.586, P=0.453; χ2=0.990, P=0.610); For the patients with rectal cancer from the different residences, the distributions of the ISR type (H=0.514, P=0.773), patients’ willingness of preserving the anus (χ2=1.437, P=0.487), and whether preserving the anus (χ2=5.513, P=0.064) had no statistical differences. In addition, although there was no statistical difference in the distribution of expanded resection or not among the patients with rectal cancer in different residences (χ2=2.363, P=0.307), it was found that there was statistical difference in the distribution of enlarged resection or not among the patients with colon cancer in different residences (χ2=17.324, P＜0.001). ConclusionsFrom the data analysis in DACCA, there are not statistical differences in surgical characteristic indicators such as surgical timing, surgical nature, ISR type, patients’ willingness of preserving the anus, and whether preserving the anus among patients with colon or rectal cancer from different residences. However, the proportion of underwent expanded surgery in the colon cancer patients who from outside Sichuan Province as compared with inside Sichuan Province is relatively higher, this suggests that surgical difficulty is more difficult for the patients from outside Sichuan Province.
Based on previous evidence-based researches and teaching experience, our team conducted literature and book review, and summarized 4 requirements, 1) effect measure calculation and conversion, 2) registration of evidence-based research, 3) evidence-based research database and 4) quality evaluation tools and reporting guidelines. We developed an online platform of evidence-based medicine research helper using the front-end and back-end technology, which can be accessed using www.ebm-helper.cn. Currently, the online tool has included 46 scenarios for effect measure calculation and conversion, introduction of 7 evidence-based research registration platforms, 26 commonly used databases for evidence-based research and 29 quality evaluation tools and reporting guidelines. This online tool can help researchers to solve specific problems encountered in different stages of evidence-based medicine research. Promoting the application of this platform in evidence-based medicine will help researchers to use the tool scientifically and improve research efficiency.
The systematic review/meta-analysis database of traditional Chinese medicine (SMD-TCM) was focused on incubation and application of the secondary research achievement. At present, the establishment of front and back websites, evidence input and evaluation have been completed. In the near future, the automation of overview and the visual presentation of evidence information will be realized, which provides the technical support for integration, analysis and application of evidence in the secondary research of TCM. This paper introduces the construction of SMD-TCM database which includes: requirements of construction, design principles, working process, evidence processing, ensuring quality of data input, data analysis and application, etc.
Objective To establish a predictive model for long-term tumor-specific survival after surgery for patients with intermediate to advanced medullary thyroid cancer (MTC) based on American Joint Committee on Cancer (AJCC) TNM staging, by using the Surveillance, Epidemiology, and End Results (SEER) Database. Methods The data of 692 patients with intermediate to advanced MTC who underwent total thyroidectomy and cervical lymph node dissection registered in the SEER database during 2004–2017 were extracted and screened, and were randomly divided into 484 cases in the modeling group and 208 cases in the validation group according to 7∶3. Cox proportional hazard regression was used to screen predictors of tumor-specific survival after surgery for intermediate to advanced stage MTC and to develop a Nomogram model. The accuracy and usefulness of the model were tested by using the consistency index (C-index), calibration curve, time-dependent ROC curve and decision curve analysis (DSA). Results In the modeling group, the multivariate Cox proportional hazard regression model indicated that the factors affecting tumor-specific survival after surgery in patients with intermediate to advanced MTC were AJCC TNM staging, age, lymph node ratio (LNR), and tumor diameter, and the Nomogram model was developed based on these results. The modeling group had a C-index of 0.827 and its area under the 5-year and 10-year time-dependent ROC curves were 0.865 [95%CI (0.817, 0.913)], 0.845 [95%CI (0.787, 0.904)], respectively, and the validation group had a C-index of 0.866 and its area under the 5-year and 10-year time-dependent ROC curves were 0.866 [95%CI (0.798, 0.935)] and 0.923 [95%CI (0.863, 0.983)], respectively. Good agreement between the model-predicted 5- and 10-year tumor-specific survival rates and the actual 5- and 10-year tumor-specific survival rates were showed in both the modeling and validation groups. Based on the DCA curve, the new model based on AJCC TNM staging was developed with a significant advantage over the former model containing only AJCC TNM staging in terms of net benefits obtained by patients at 5 years and 10 years after surgery. Conclusion The prognostic model based on AJCC TNM staging for predicting tumor-specific survival after surgery for intermediate to advanced MTC established in this study has good predictive effect and practicality, which can help guide personalized, precise and comprehensive treatment decisions and can be used in clinical practice.
Objective To summarize primary clinical data from Xiao Tang Shan Hospital (XTSH) Information System, to provide evidence for clinical data of emerging diseases. Method The primary data were extracted from XTSH information system, which related to demographic and background information, case history, prescriptions, laboratory tests, physical examination, vital sign, surgery, diagnostics and expenditures. The software for data verification was developed by Delphi language program. The information of SARS management was developed by Oracle Developer. Results XTSH information system for SARS management collected 1.09 million pieces of information covering 680 SARS cases. The database was functionally divided into inquiry window, conditional case list window and case details spread window, which provided information of SARS management and shaped a platform for further investigation. Quality control of clinical data was done by the software of SARS Information Real Control.Conclusions XTSH information system collected complete data of SARS management, which made healthcare, research and policy-making on SARS accessible, and made it possible to share resources and train the professionals.
ObjectiveTo analyze the relation between educational level of patients with colorectal cancer (CRC) and decision-making and curative effect of neoadjuvant therapy (NAT) in the current version of the Database from Colorectal Cancer (DACCA). MethodsThe eligible CRC patients were collected from June 29, 2022 updated DACCA according to the screening criteria and were assigned into 4 groups according to their educational level, namely, uneducated, primary educated, secondary educated, and tertiary educated. The differences in NAT decision-making, cancer marker change, symptomatic change, gross change, imaging change, and tumor regression grade (TRG) among the CRC patients with different educational levels were compared. ResultsA total of 2 816 data that met the screening criteria were collected, 138 of whom were uneducated, 777 of whom were primary educated, 1 414 of whom were secondary educated, and 487 of whom were tertiary educated. The analysis results revealed that the difference in the composition ratio of patients choosing NAT regimens by educational level was statistically significant (χ2=30.937, P<0.001), which was reflected that the composition ratio of choosing a simple chemotherapy regimen in the uneducated CRC patients was highest, while which of choosing combined targeted therapy regimen in the tertiary educated CRC patients was highest. In terms of treatment outcomes, the composition ratios of changes in cancer markers (H=4.795, P=0.187), symptoms (H=1.722, P=0.632), gross (H=2.524, P=0.471), imaging (H=2.843, P=0.416), and TRG (H=2.346, P=0.504) had no statistical differences. ConclusionsThrough data analysis in DACCA, it is found that the educational level of patients with CRC can affect the choice of NAT scheme. However, it is not found that the educational level is related to the changes in the curative effect of patients with CRC before and after NAT, and further analysis is needed to determine the reasons for this.
ObjectiveTo analyze the current version of the West China Database from Colorectal Cancer (DACCA) and explore how the occupational background of colorectal cancer patients affects the complexity of surgical difficulty and postoperative complications. MethodsWhen using the updated version of DACCA data on May 28, 2023 for analysis, the data items concerned covered occupation, operative duration, anatomical difficulty, pelvic stenosis, abdominal obesity, adhesion in surgical area, abnormal mesenteric status, tissue or organ hypertrophy, intestinal quality in surgical area, postoperative complications in hospital, short-term postoperative complications and long-term postoperative complications. According to the “Occupational Classification Code of the People’s Republic of China”, the occupations of patients were divided into professional and technical personnel, staff, service personal, production personnel, manufacturing personnel and retirees according to different occupations. The operative difficulty and postoperative complications of 6 groups were analyzed. ResultsAccording to the screening conditions, 5 734 valid data rows were obtained from DACCA. The results of occupation analysis showed that there were significant difference in operative duration (H=11.609, P=0.041), anatomical difficulty (H=29.166, P<0.001), pelvic stenosis (H=16.412, P=0.006), abdominal obesity (H=44.622, P<0.001), adhesion in surgical area (H=23.695, P<0.001), abnormal mesenteric status (χ2=39.252, P=0.035), tissue or organ hypertrophy (χ2=58.284, P<0.001) and intestinal quality in surgical area (H=21.041, P=0.001) between different groups. There were no significant differences in the occurrence of complications in hospital, near and short-term and long-term after operation among different occupations (P>0.05). Further subgroup analysis showed that only the difference of fever (χ2=10.969, P=0.041) and intestinal obstruction (χ2=12.025, P=0.021) were statistically significant among different occupations. ConclusionThe occupation of patients may affect the difficulty of colon cancer surgery, and the occurrence of postoperative complications is nothing to do with the occupation of patients, but the occurrence of postoperative fever and postoperative intestinal obstruction is related to occupations, and the possible causes need to be further explored.
ObjectiveTo analyze the distribution, prognostic differences, and characteristics of patients with colorectal cancer (CRC) from 2007 to 2022 based on the current version of the Database from Colorectal Cancer (DACCA), so as to provide a basis for clinical decision-making. MethodsThe eligible CRC patients based on the established screening criteria from the updated DACCA were collected. The distribution and survival status of CRC patients in different residence places were analyzed. The residence places included 21 cities (prefectures) within Sichuan Province. ResultsA total of 5 416 cases that met the screening criteria from 2007 to 2022 were collected. Among these, CRC patients were predominantly concentrated in Chengdu (44.77%), Meishan (5.78%), and Nanchong (4.56%) cities. A heatmap depicting the superimposed trend of CRC patients origins revealed the distribution of patients was basically divided into eastern and western regions along the axis of “Mianyang–Chengdu–Yaan cities”. The majority of patients (5 359 cases, 98.95%) was distributed in the eastern region, while a few in the western region (57 cases, 1.05%). The patients in the eastern region were more high clustered (especially Chengdu city), while those in the western region was sporadically dispersed, and the patients in the western region increased slowly without aggregation. The 1, 3, and 5-year cumulative overall survival rates of the CRC patients in the DACCA were 96.2%, 89.7%, and 85.1%, respectively. The multivariate Cox proportional hazards regression model showed that the male, age ≥35-year old, adenocarcinoma (mucinous adenocarcinoma as a reference), poorly differentiated degree, pTNM stages Ⅲ and Ⅳ, obstruction, and perforation were the risk factors for median overall survival shortening in the CRC patients (all P<0.05). The survival curve of patients with CRC drawn by Kaplan-Meier method showed that the overall survival of CRC patients in different cities (prefectures) had no statistical differences as compared with the integral CRC patients (P>0.05), except for Neijiang city (was worse than that of the integral CRC patients, P<0.05). ConclusionsBased on data analysis for the DACCA from 2007 to 2022, the majority of CRC patients clusters in the eastern region. Chengdu city exhibits a high clustering, while the western region shows a sporadic distribution without aggregation phenomena. It is found that the cumulative overall survival of CRC patients in Neijiang city is worse than that of the integral CRC patients, while which in the other cities (prefectures) was relatively close to that of the integral CRC patients in Sichuan Province.