Published on in Vol 24 , No 11 (2022) :November

Preprints (earlier versions) of this paper are available at, first published .
The Generation of a Lung Cancer Health Factor Distribution Using Patient Graphs Constructed From Electronic Medical Records: Retrospective Study

The Generation of a Lung Cancer Health Factor Distribution Using Patient Graphs Constructed From Electronic Medical Records: Retrospective Study

The Generation of a Lung Cancer Health Factor Distribution Using Patient Graphs Constructed From Electronic Medical Records: Retrospective Study

Original Paper

1Institutes for System Genetics, West China Hospital, Chengdu, China

2iHealthd Shanghai Inc, Shanghai, China

3Guilin Medical University Affiliateted Hospital, Guilin, China

4Guilin Medical University, Guilin, China

Corresponding Author:

Bairong Shen, PhD

Institutes for System Genetics

West China Hospital

2222 Xingchuan Road

Chengdu, 610212


Phone: 86 15995854635


Background: Electronic medical records (EMRs) of patients with lung cancer (LC) capture a variety of health factors. Understanding the distribution of these factors will help identify key factors for risk prediction in preventive screening for LC.

Objective: We aimed to generate an integrated biomedical graph from EMR data and Unified Medical Language System (UMLS) ontology for LC, and to generate an LC health factor distribution from a hospital EMR of approximately 1 million patients.

Methods: The data were collected from 2 sets of 1397 patients with and those without LC. A patient-centered health factor graph was plotted with 108,000 standardized data, and a graph database was generated to integrate the graphs of patient health factors and the UMLS ontology. With the patient graph, we calculated the connection delta ratio (CDR) for each of the health factors to measure the relative strength of the factor’s relationship to LC.

Results: The patient graph had 93,000 relations between the 2794 patient nodes and 650 factor nodes. An LC graph with 187 related biomedical concepts and 188 horizontal biomedical relations was plotted and linked to the patient graph. Searching the integrated biomedical graph with any number or category of health factors resulted in graphical representations of relationships between patients and factors, while searches using any patient presented the patient’s health factors from the EMR and the LC knowledge graph (KG) from the UMLS in the same graph. Sorting the health factors by CDR in descending order generated a distribution of health factors for LC. The top 70 CDR-ranked factors of disease, symptom, medical history, observation, and laboratory test categories were verified to be concordant with those found in the literature.

Conclusions: By collecting standardized data of thousands of patients with and those without LC from the EMR, it was possible to generate a hospital-wide patient-centered health factor graph for graph search and presentation. The patient graph could be integrated with the UMLS KG for LC and thus enable hospitals to bring continuously updated international standard biomedical KGs from the UMLS for clinical use in hospitals. CDR analysis of the graph of patients with LC generated a CDR-sorted distribution of health factors, in which the top CDR-ranked health factors were concordant with the literature. The resulting distribution of LC health factors can be used to help personalize risk evaluation and preventive screening recommendations.

J Med Internet Res 2022;24(11):e40361



Early lung cancer (LC) detection is a key strategy to combat this deadly disease worldwide [1]. The National Lung Screening Trial in the United States and similar clinical trials around the world have shown an approximately 20% reduction in mortality from LC as a result of screening with low-dose computed tomography [2]. Based on these studies, LC screening medical guidelines as well as statistical risk prediction models including PLCOM2012 have been implemented to recommend screening for smokers [3]. However, screening is not commonly recommended for nonsmokers even though they represent a significant percentage of patients with LC worldwide, 15%-20% among male patients and over 50% among female patients [4]. In addition, adoption of LC screening is still very low. For example, only approximately 5% of the at-risk population received their annual screening in the United States [5].

Risk-based or personalized screening approaches are being studied to overcome these challenges [6]. We believe that a deeper understanding of the spectrum of risk factors for LC and applying technologies such as machine learning and knowledge graphs (KGs) will generate more cost-effective screening solutions.

KGs have been widely applied in biomedical research. For interpreting proteomics data, a large-scale clinical KG has been plotted from biomedical data using the Neo4j tool [7]. Open-source graph databases and tools including Neo4j have made it easier to build and analyze KGs [8]. Studies have also demonstrated that construction of high-quality patient KGs from electronic medical records (EMRs) using rudimentary concept extraction is feasible and that the KGs can be used to predict diagnosis on the basis of symptoms [9]. Even though graphical representation of patient data holds the promise to illuminate insights in health care and to transform such insights gleaned from EMR data into actionable knowledge, the application of EMR-wide graphs for studying individual disease diagnosis journeys or treatment processes is still limited [10]. A graphical data model has been constructed, integrating clinical and molecular data of patients with non–small cell LC in the Cancer Genome Atlas LC data sets [11]. Another recent study of synthetic patients proposed a new graphical method to identify any particular disease’s potential risk factor distribution from EMR (personal communication by A Chen, March 1, 2022).

The Unified Medical Language System (UMLS) ontology, freely available from the National Library of Medicine, is a KG consisting of millions of nodes and relationships [12]. It forms the foundation of interoperable biomedical information systems and services, including electronic health records. Connecting the UMLS KG to patient graphs may enable semantic search of patient data and support clinical decision-making [13].

This study aimed to construct a patient health factor graph for LC from a hospital EMR and integrate it with the UMLS KG for graph search and risk factor analysis. Through graph search, the study also aimed to generate a distribution of LC health factors, which was expected to help implement personalized LC risk evaluation for preventive screening.

EMR Health Factor Data Collection

We deidentified the patient records from January 2018 to June 2021 and saved them on a secured data server controlled by the hospital’s informatics department. The data set had approximately 1 million patients and 7 million encounters including both outpatients and inpatients, in which patient names, dates of birth, contacts, and addresses were removed. The original identifiers of patients and encounters were replaced by irrelevant random numbers. Before using the data, our research team members were trained in the hospital’s patient data security and privacy policy.

Because the EMR data had no usable codes associated with the diagnoses, synonyms of LC in Chinese were used to search for patients with LC. A total of 1397 patients with LC aged ≥30 years were included in the target data set. The same number (n=1397) of patients without LC and aged ≥30 years were randomly selected as control (or background) patients for comparison purposes.

Deidentified records of outpatient and inpatient visits, diagnoses, laboratory tests, and procedures were imported into a custom data collection tool on the secured data server. The data tool automatically extracted laboratory test data and saved them in the database. Researchers manually selected data from text records and entered them into the database. Because the records were not coded, practical rules were developed to improve consistency in the data collection process. Synonyms were automatically converted to “local standard terms” and the resulting data were called “local standard data.” For each patient, only data from before the final diagnosis of LC were collected for studying disease risk factors, and a patient diagnosis journey (PDJ) object was created in the data tool to contain 1 or multiple encounters leading to the final diagnosis. When exporting PDJ data to a CSV file for analysis, only the latest data for each health factor in PDJ were selected. The final raw data set contained near 50,000 data from patients with LC and over 58,000 data from background patients. There were over 3000 different health factors identified in these data.

Patient Graph Construction

To simplify the patient graph, continuous numerical data were converted to categorical data. For example, values of age were converted to categories (ranges), including 30-50, 50-70, and >70 years; the value of drinking was “true” if the patient consumed >1 drink per day; the value of smoking was “true” if the patient smoked >1 cigarette per day. Laboratory findings from the EMR were already recorded as categorical variables: normal or abnormal; true or false; positive or negative; high, medium, or low; and up, down, or normal. After value conversion, approximately 93,000 standard data for about 550 factors (ie, codes) that appeared in at least 10 patients with LC were selected and saved into a factor import CSV file. The format of the factor import file was as follows: virtual-id, category, code, term, value, unit, converted-value, and date. Patients with LC and background patients (N=2794) were both saved in a patient import file, one patient per line, with the following format: virtual-id, LC-label (1 for LC, 0 for background), and factor-count.

We used the Neo4j Desktop tool (version 4.4) available freely from Neo4j Inc, which is a graph database with a graphical user interface (Neo4j Browser) to query with Cypher language and view graphs. It provides an application programming interface through a Python driver. It can load data from CSV files to construct graphs. In our patient-centered graph model, each patient was represented by a “Patient” node (total of 2794 patient nodes), while health factor and value pairs were represented by 650 factor nodes. Because all values were categorical and some health factors had more than 1 piece of categorical data, the number of factor-value pair nodes increased from 550 to 650. The health factors were further subdivided into the following categories: Condition, Symptom, Observation, History, RiskFactor, Labtest, Procedure, Medication, and Treatment. The graph drew over 93,000 connections from patients to factors. Constraints were created on each label to ensure uniqueness. Patient nodes required virtual-id while all factor nodes required category, code, and converted-value as node key.

UMLS Disease Subgraph Construction

The UMLS 2020AB release was downloaded from the National Library of Medicine’s UMLS website and installed locally by following the provided instructions. The local UMLS ontology had 2.8 million concepts, 8.3 million terms, and 39.1 million relationships. For generating an LC UMLS subgraph, we directly used the concept file MRCONSO.RRF and relation file MRREL.RRF in rich release format to generate Neo4j graph import files. The LC codes were first expanded to a more complete set of LC codes using the UMLS hierarchy (Table 1). We then used the expanded concept unique identifiers to find all horizontal relations (approximately 1100) between these LC target concepts and other biomedical concepts from over 39 million relations in UMLS ontology. The relations discovered were filtered by a selected set of UMLS relationship attributes for biological or medical concepts (Textbox 1); these were categorized into either biological concept relationships (called “biorel”) or medical concept relationships (called “medrel”). To visualize this simple categorization of biomedical knowledge, we added RelCat nodes between TargetConcept nodes and related Concept nodes in the UMLS subgraph as shown in Figure 1. We then introduced a single AbstractPatient node to connect with all LC TargetConcept nodes. Connecting the patient nodes in EMR graph to the single AbstractPatient node resulted in an integrated biomedical graph that can present any patient’s health factors together with biomedical knowledge from UMLS ontology for LC.

Table 1. Expanded lung cancer concepts in the Unified Medical Language System (UMLS) hierarchy.
UMLS concept unique identifiersTermSNOMEDCT code
C0581834Suspected lung cancer162573006
C0242379Malignant neoplasm of lung363358000
C0149925Small cell carcinoma of lung254632001
C0007131Non-Small Cell Lung Carcinoma254637007
C0152013Adenocarcinoma of lung (disorder)254626006
C0149782Squamous cell carcinoma of lung254634000
C1306460Primary malignant neoplasm of lung93880001
C0153676Secondary malignant neoplasm of lung94391008
List of Unified Medical Language System (UMLS) relationship attributes and categories.

Biological concept relationships:

  • gene_associated_with_disease
  • gene_involved_in_pathogenesis_of_disease
  • gene_mapped_to_disease
  • gene_product_malfunction_associated_with_disease
  • gene_product_is_biomarker_of
  • may_be_cytogenetic_abnormality_of_disease
  • may_be_molecular_abnormality_of_disease

Medical concept relationships:

  • may_treat
  • regimen_has_accepted_use_for_disease
  • has_associated_finding
  • associated_finding_of
  • associated_disease
  • is_finding_of_disease
  • related_to
  • clinically_associated_with
  • co-occurs_with
  • may_be_associated_disease_of_disease
  • may_be_finding_of_disease
Textbox 1. List of Unified Medical Language System (UMLS) relationship attributes and categories.
Figure 1. Biomedical graph model for the integration of the electronic medical record patient graph with the Unified Medical Language System knowledge graph of lung cancer. Numbered relationship labels are listed in Table 2.
View this figure
Table 2. Node and relationship labels in the integrated biomedical graph model (shown in Figure 1).
NumberFrom node labelRelationship labelsTo node label

Patient Health Factor Distribution

We developed a Python script to automatically query the patient graph with each of the health factors. The number of connections from each factor to LC target patients (depicted as “TPC” in equation 1) and background patients (depicted as “BPC” in equation 1) in the search results were counted separately. For each factor, the delta of patient connection counts was calculated by subtracting the number of background patient connections from that of the target patient connections. Division of the delta by the total number of patient connections yielded the “connection delta ratio” (CDR), a relative measure of the strength of connections from a factor to the target patient. Sorting factors by CDR and plotting a graph of CDR versus the sorted factors yielded a distribution of LC health factors from high to low strength.

CDR = (TPC – BPC) / (TPC + BPC) (1)

A CDR between 1 and 0 implied that the factor was more related to the target patient, 1 being most related. A CDR below 0 implied that the factor was more related to the background patient.

In this study, factors with a CDR of >0.5 and having connections with at least 10 patients with LC were selected for literature verification. The local standard terms were first translated to English and the corresponding UMLS concepts as well as standard codes from SNOMEDCT_US, LOINC, or RxNORM if possible. We then searched the research literature on Google, Google Scholar, PubMed for each health factor and reviewed the published studies to verify whether the health factors were confirmed risk factors, correlated with LC, were unrelated to LC, or had an unsure relationship with LC. If a factor’s relationship with LC was inconclusive in existing research reports, the factor was tagged as “unsure.” For example, to look up the factor “Hypocalcemia,” search terms included “Lung cancer risk factor Hypocalcemia” and other variations if necessary.

Ethical Considerations

This retrospective study of EMR patient data has been approved by the institutional review board of Guilin Medical University Associated Hospital in China (QTLL202139).

Integrated Graph Model of the EMR Patient Graph and the UMLS KG

To study the spectrum of health factors related to LC in the hospital EMR, we applied a new graph method that we recently developed using synthetic patient data. Figure 1 shows the graph model integrating the EMR patient graph and UMLS knowledge subgraph for LC. The patient graph is patient-centered with patient nodes connecting to different categories of health factor nodes. Table 2 lists the relationships between nodes, as generated in the graph database. The UMLS subgraph in this model is focused on the horizontal biomedical relationships between LC nodes and related concept nodes. Such an integration model enables the presentation of a patient’s actual health factors together with the UMLS KG’s related biomedical factors in the same graph.

Patient Health Factor Graph Based on EMR Data

From the hospital EMR, 1397 patients with LC were selected along with the same number of background patients without LC. After deidentified data of laboratory tests and procedures were integrated into the corresponding encounters, a total of 108,000 standard data for various categories of health factors were extracted from patient encounters. Although over 3000 different factors were collected, only approximately 550 factors shared by at least 10 patients with LC were used for building the patient health factor graph.

The patient health factor graph was constructed by importing patient properties for the patient nodes and factor properties for the corresponding health factor nodes. The resulting patient graph had 93,000 relations between the 2794 patient nodes and 650 factor-value pair nodes. Table 3 lists several examples of Cypher queries for searching patients with various factors. For example, clinicians can easily search for patients with LC with 1 or more co-occurring diseases (Figure 2), with 1 or more nonlaboratory factors (symptoms, medical histories, and observations; Figure 3), or laboratory tests (Figure 4). One can also easily search for any number of health factors shared by patients among patients with LC.

Table 3. Examples of graph search tasks and queries using Cypher language.
NumberGraph search taskCypher querya,b
  • Search for patients with LC with 1-6 co-occurring diseases and present the topology.
  • C-389764: Hypocalcemia
  • C-172569: Bacterial Infection
  • C-765209: Obstructive pneumonia
  • C-305976: Pneumothorax
  • C-352894: Leukopenia
  • C-654730: Pneumonia
match (p:Patient {label:'1'})-->(f {cat: 'dac'})where f.code = 'C-389764' or f.code = 'C-172569' or f.code = 'C-765209' or f.code = 'C-305976' or f.code = 'C-352894' or f.code = 'C-654730'return p, f;
  • Search for patients with LC with 1-5 nonlaboratory factors and present the topology
  • C-549780: Pain
  • C-289547: Bloodstained sputum
  • C-127089: Hoarseness
  • C-029761: Productive Cough
  • C-294680: Swollen Lymph Node in head and neck
match (p:Patient {label:'1'})-->(f) where (f.code = 'C-549780' and f.valcvt = 'true')or (f.code = 'C-289547' and f.valcvt='true')or (f.code = 'C-127089' and f.valcvt='true')or (f.code = 'C-029761' and f.valcvt='true')or (f.code = 'C-294680' and f.valcvt='true')return p, f;
  • Search for patients with LC with 1-5 laboratory test values and present the topology.
  • C-659218: Hepatitis B virus
  • C-493765: Squamous cell carcinoma antigen
  • C-573086: Neuron-specific enolase measurement
  • C-120948: Gastrin-releasing peptide precursor increased
  • C-814793: Mycoplasma pneumoniae antibody
match (p:Patient {label:\'1\'})-->(f {cat: \'lab\'}) where
(f.code = \'C-659218\' and f.valcvt = \'true\')
or (f.code = \'C-493765\' and f.valcvt = \'up\')
or (f.code = \'C-573086\' and f.valcvt = \'up\')
or (f.code = \'C-120948\' and f.valcvt = \'abnormal\')
or (f.code = \'C-814793\' and f.valcvt = \'abnormal\')
return p, f;
  • Search for 1 patient, show the electronic medical record health factor graph and the Unified Medical Language System knowledge graph together
match (p:Patient {label:\'1\', vpid:\'_8908085766\'})-->(f)
match (p)-->(ap:AbstractPatient)-->(tc:TargetConcept)-->(cr:RelCat)-->(c:Concept)
return p, f, ap, tc, cr, c;

aUsing Neo4j Cypher query language.

bPatient with LC: label=1; background patient: label=0. Factor property f.code: unique local code. Factor property f.valcvt: converted value.

Figure 2. Topology of an example patient graph searched with 6 disease factors. Search query 1 in Table 3 was used. Patient nodes are shown in blue and factor nodes are shown in red. Lines represent relationships between a patient and factors.
View this figure
Figure 3. Topology of an example patient graph searched with 5 nonlaboratory factors. Search query 2 in Table 3 was used. Patient nodes are shown in blue and factor nodes are shown in pink. Lines represent relationships between a patient and factors.
View this figure
Figure 4. Topology of an example patient graph searched with 5 laboratory factors. Search query 3 in Table 3 was used. Patient nodes are shown in blue and factor nodes are shown in orange. Lines represent relationships between a patient and factors.
View this figure

Integration of the EMR Patient Graph With the UMLS Subgraph

As the largest integrated biomedical ontology, the UMLS graph contains hierarchies of diseases and horizontal relationships with other entities. Within a disease family such as LC, the various types of LCs are horizontally connected to a myriad of related biomedical concepts including genes, proteins, symptoms, observations, medication, and treatments. This study is focused on the UMLS knowledge subgraph containing horizontal relationships for LC. Using the UMLS LC hierarchy, the target LC codes found in EMRs were expanded to 8 main LC concepts (Table 1). From these concepts, approximately 1100 relations were identified in the UMLS ontology. Most of the relations were hierarchical—for example, a parent-child relationship—and thus the relations were further filtered by the biomedical relationships that we were interested in (Textbox 1). The resulting UMLS LC biomedical subgraph had 8 LC concept nodes, 187 related biomedical concepts, and 188 horizontal biomedical relations (Figure 5).

Through a single AbstractPatient node, the EMR patient graph was connected to the UMLS subgraph for LC. Search query 4 in Table 3 and its search result in Figure 5 show an example presentation of both actual patient’s health factors in the EMR and relevant biomedical knowledge in the UMLS in the same graph.

Figure 5. Example search result of the integrated biomedical graph. Search query 4 in Table 3 was used to search 1 specific ID of a patient with lung cancer. Left side: health factors from the electronic medical record of one patient with lung cancer. Right side: lung cancer biomedical knowledge from the Unified Medical Language System. Middle: single AbstractPatient as the connection. BioRel: biological concept relationship; MedRel: medical concept relationship.
View this figure

Generation of the Distribution of LC Health Factors From the EMR

With the patient health factor graph, we searched for patients with LC and background patients with each of the health factors and its value. The connection delta ratios were calculated for each factor from the number of connections to patients with LC and the number of connections to background patients. Sorting factors by CDR in descending order generated a distribution of health factors for LC found in the EMR. The complete distribution of top-ranked factors over a CDR cutoff of 0.5 are shown in Table A1 in Multimedia Appendix 1 and plotted in Figure 6. As examples, up to 5 top health factors in each category are shown in Table 4. For understanding LC risk factors, this distribution excluded the various cancers, all procedures and medications related to cancers, and treatments.

Figure 6. Distribution curve of lung cancer health factors sorted by the connection delta ratio (CDR; cutoff=0.5). Only partial codes are visible on the x-axis. The full spectrum of lung cancer health factors can be found in Table A1 in Multimedia Appendix 1.
View this figure
Table 4. Partial distribution of lung cancer health factors sorted by category and connection delta ratio (cutoff=0.5) as examples. The full distribution of lung cancer health factors is provided in Table A1 in Multimedia Appendix 1.
CategoryaLocal codeTermValueConnection delta ratioTag
dacC-182460Left lung pulmonary obstructive pneumoniaTRUE1.00confirmed
dacC-248056Right lung pulmonary obstructive pneumoniaTRUE1.00confirmed
dacC-765209Obstructive pneumoniaTRUE1.00confirmed
dacC-172569Bacterial InfectionTRUE0.88correlated
labC-659218Hepatitis B virusTRUE1.00correlated
labC-493765Squamous cell carcinoma antigenup0.90confirmed
labC-573086Neuron-specific enolase measurementup0.82correlated
labC-952408Non-small cell lung cancer associated-antigenup0.82confirmed
labC-103698Superoxide dismutase measurementdown0.82correlated
obsC-039824Mediastinal massTRUE1.00confirmed
obsC-706432Lung massTRUE1.00confirmed
obsC-748932Lung mass found in checkupTRUE1.00confirmed
obsC-134276Lung shadowTRUE0.91confirmed
obsC-706281Bronchial stenosisTRUE0.89correlated
smpC-289547Bloodstained sputumTRUE0.96confirmed
smpC-152064Hemoptysis (cough up blood)TRUE0.83correlated
smpC-243071Shoulder PainTRUE0.82confirmed

aCategories include condition (dac), laboratory test (lab), observation (obs), risk factor (rf), and symptom (smp).

We checked the medical literature for any associations between these top CDR-ranked health factors and LC [14-26]. This literature review confirmed that 70 out of the 71 factors (Table A1 in Multimedia Appendix 1) were LC risk factors or were correlated with LC. The relationship between 1 factor, laboratory test for immunoglobulin E levels, and LC was unsure according to the literature [27]. This high degree of concordance between the results of our CDR analysis and the literature suggests that the patient graph CDR method was effective in generating a reliable distribution of LC health factors from EMR patient data.

Using hospital EMR patient data and applying the new patient graph CDR method recently developed from synthetic patient data, this study was able to construct an integrated biomedical graph for LC. From searching the graph, the study created a distribution of health factors for LC, which were verified through literature review. Our results show that the new strategy of first using synthetic patients for method development and then applying the methods with real patient data is valid and effective.

This study has implications for hospitals with regard to harnessing KG databases and technologies. First, generating an integrated biomedical graph with hospital EMR data may enable medical professionals to view individual patient’s health factor graphs along with the related UMLS KGs for comprehensive comparisons. Current medical concept nodes horizontally related to the LC nodes are mostly genes and gene-related biological information, as well as drugs and treatment-related information from the UMLS ontology (see Figure 5). Since the UMLS is updated quarterly, the LC integrated biomedical graph will grow as the UMLS grows. Thus, this KG integration offers a new way for hospitals to bring continuously updated international standard biomedical knowledge to patient care. The current graph model is designed specifically for searching risk factors; however, it can be modified for other clinical information tasks. It may also be integrated with cancer-associated lifestyle KGs for disease management information [28].

The second implication of this study may be applying the CDR-ranked distribution of health factors to build more effective or practical machine learning models for LC risk prediction. Because the distribution ranks factors from higher to lower relative strength, they may be used to help select more health factors to build prediction models; that is, feature engineering. For example, we have an ongoing project experimenting with the factor distribution in building LC risk prediction machine learning models. Knowing the risk factors actually found in the EMR data, we could focus on these risk factors and reduce the variables from over 100 to less than 30 in the machine learning models that were generated from EMR-wide data. To increase the LC screening rate in larger populations, machine learning models with a small number of variables for which data can be readily available in community and rural clinics are necessary.

In addition, the patient health factor graphs generated from EMR data may enable hospitals to study the effect of various types of factors in diagnosis, medication, treatment, and disease management. Such graph analysis complements existing statistical analysis. Traditionally, studies on individual risk factors are hypothesis driven and use a clinical trial or case-control study design [29]. The literature found in this study for verification of the health factor distribution collectively indicate the use of this approach [14-27]. Because this study’s patient graph method is EMR data driven, it can reveal potential new risk factors or inconclusive risk factors that deserve additional research. For example, the factor “laboratory test for immunoglobulin E levels” was tagged as “unsure” in the distribution because prior studies were inclusive. Our CDR analysis suggests that this immunoglobulin E factor requires further clinical validation [30].

Because EMR data sometimes have biases and missing data, the EMR data–driven patient graph CDR method has limitations. CDR is a simple measurement of a factor’s relative strength, but caution should be taken when considering factors with a high CDR but a small number of connections. The higher the number of connections, the more reliable the CDR. Hence, studies should set a cutoff for the CDR as well as the minimal number of connections to ensure that the study uses enough data. It is also important to recognize factors that might be affected by data biases and to exclude them from CDR analysis [31]. For EMRs lacking standardized and structured data, collecting standardized data is crucial but challenging. If a data collection pipeline is not fully automated, collecting enough unbiased standardized patient profile data will be a very time-consuming process.

In conclusion, by collecting standardized data of thousands of patients with and those without LC from EMRs, it was possible to generate a hospital-wide patient-centered health factor graph for graph search and presentation. It was also practical to integrate the patient graph with the UMLS KG for LC, enabling hospitals to bring continuously updated international standard biomedical KGs from the UMLS to clinical care. Applying CDR analysis to the graph of patients with LC yielded a CDR-sorted distribution of health factors, where top CDR-ranked health factors showed a high degree of concordance with the literature. The resulting distribution of LC health factors can be used to help personalize risk evaluation and preventive screening recommendations.


This work was supported by the Sichuan Science and Technology Program (grant2020YFQ0019) and the Guilin Municipal Science and Technology Bureau, China (grant 20190219-2).

Authors' Contributions

AC designed the study and drafted the manuscript. R Huang wrote programs and analyzed data. EW and R Han collected the data. JW supervised the study. ZZ, QL, and BS proposed the study, obtained funding, and directed the study.

Conflicts of Interest

None declared.

Multimedia Appendix 1

Complete lung cancer health factor distribution sorted by category (Cat) and connection delta ratio (CDR).

PDF File (Adobe PDF File), 159 KB

  1. Pinsky PF. Lung cancer screening with low-dose CT: a world-wide view. Transl Lung Cancer Res 2018 Jun;7(3):234-242 [FREE Full text] [CrossRef] [Medline]
  2. National Lung Screening Trial Research Team, Aberle DR, Adams AM, Berg CD, Black WC, Clapp JD, et al. Reduced lung-cancer mortality with low-dose computed tomographic screening. N Engl J Med 2011 Aug 04;365(5):395-409 [FREE Full text] [CrossRef] [Medline]
  3. Tammemägi MC, Katki HA, Hocking WG, Church TR, Caporaso N, Kvale PA, et al. Selection criteria for lung-cancer screening. N Engl J Med 2013 Feb 21;368(8):728-736 [FREE Full text] [CrossRef] [Medline]
  4. Dubin S, Griffin D. Lung Cancer in Non-Smokers. Mo Med 2020;117(4):375-379 [FREE Full text] [Medline]
  5. Lung Cancer Screening. National Cancer Institute. Cancer Trends Progress Report.   URL: [accessed 2022-11-14]
  6. Wang Z, Wang Y, Huang Y, Xue F, Han W, Hu Y, et al. Challenges and research opportunities for lung cancer screening in China. Cancer Commun (Lond) 2018 Jun 07;38(1):34 [FREE Full text] [CrossRef] [Medline]
  7. Santos A, Colaço AR, Nielsen AB, Niu L, Strauss M, Geyer PE, et al. A knowledge graph to interpret clinical proteomics data. Nat Biotechnol 2022 May;40(5):692-702 [FREE Full text] [CrossRef] [Medline]
  8. Neo4j Desktop User Interface Guide. Neo4j, Inc.   URL: [accessed 2022-11-14]
  9. Rotmensch M, Halpern Y, Tlimat A, Horng S, Sontag D. Learning a Health Knowledge Graph from Electronic Medical Records. Sci Rep 2017 Jul 20;7(1):5994 [FREE Full text] [CrossRef] [Medline]
  10. Schrodt J, Dudchenko A, Knaup-Gregori P, Ganzinger M. Graph-Representation of Patient Data: a Systematic Literature Review. J Med Syst 2020 Mar 12;44(4):86 [FREE Full text] [CrossRef] [Medline]
  11. Tuck D. A cancer graph: a lung cancer property graph database in Neo4j. BMC Res Notes 2022 Feb 14;15(1):45 [FREE Full text] [CrossRef] [Medline]
  12. Bodenreider O. The Unified Medical Language System (UMLS): integrating biomedical terminology. Nucleic Acids Res 2004 Jan 01;32(Database issue):D267-D270 [FREE Full text] [CrossRef] [Medline]
  13. Martinez D, Otegi A, Soroa A, Agirre E. Improving search over Electronic Health Records using UMLS-based query expansion through random walks. J Biomed Inform 2014 Oct;51:100-106 [FREE Full text] [CrossRef] [Medline]
  14. Signs and symptoms of lung cancer. American Cancer Society.   URL: [accessed 2022-11-14]
  15. What are the risk factors for lung cancer? Centers for Disease Control and Prevention.   URL: [accessed 2022-11-14]
  16. Song C, Lv J, Liu Y, Chen JG, Ge Z, Zhu J, China Kadoorie Biobank Collaborative Group. Associations Between Hepatitis B Virus Infection and Risk of All Cancer Types. JAMA Netw Open 2019 Jun 05;2(6):e195718 [FREE Full text] [CrossRef] [Medline]
  17. Gridelli C, Rossi A, Carbone DP, Guarize J, Karachaliou N, Mok T, et al. Non-small-cell lung cancer. Nat Rev Dis Primers 2015 May 21;1:15009. [CrossRef] [Medline]
  18. Ferraz Gonçalves JA, Costa T, Rema J, Pinto C, Magalhães M, Esperança A, et al. Hypocalcemia in cancer patients: An exploratory study. Porto Biomed J 2019;4(4):e45 [FREE Full text] [CrossRef] [Medline]
  19. You D, Zhang M, He W, Wang D, Yu Y, Yu Z, et al. Association between dietary sodium, potassium intake and lung cancer risk: evidence from the prostate, lung, colorectal and ovarian cancer screening trial and the Women's Health Initiative. Transl Lung Cancer Res 2021 Jan;10(1):45-56 [FREE Full text] [CrossRef] [Medline]
  20. Dreyer L, Prescott E, Gyntelberg F. Association between atherosclerosis and female lung cancer--a Danish cohort study. Lung Cancer 2003 Dec;42(3):247-254. [CrossRef] [Medline]
  21. Kang SW. Superoxide dismutase 2 gene and cancer risk: evidence from an updated meta-analysis. Int J Clin Exp Med 2015;8(9):14647-14655 [FREE Full text] [Medline]
  22. Unsal E, Atalay F, Atikcan S, Yilmaz A. Prognostic significance of hemostatic parameters in patients with lung cancer. Respir Med 2004 Feb;98(2):93-98 [FREE Full text] [CrossRef] [Medline]
  23. Ercan H, Mauracher L, Grilz E, Hell L, Hellinger R, Schmid J, et al. Alterations of the Platelet Proteome in Lung Cancer: Accelerated F13A1 and ER Processing as New Actors in Hypercoagulability. Cancers (Basel) 2021 May 08;13(9):2260 [FREE Full text] [CrossRef] [Medline]
  24. Cui M, Li N, Liu X, Yun Z, Niu Y, Zhang Y, et al. Platelet distribution width correlates with prognosis of non-small cell lung cancer. Sci Rep 2017 Jun 14;7(1):3456 [FREE Full text] [CrossRef] [Medline]
  25. Yan L, Hu Z. Diagnostic accuracy of human epididymis secretory protein 4 for lung cancer: a systematic review and meta-analysis. J Thorac Dis 2019 Jul;11(7):2737-2744 [FREE Full text] [CrossRef] [Medline]
  26. Schmidt-Hansen M, Berendse S, Hamilton W, Baldwin DR. Lung cancer in symptomatic patients presenting in primary care: a systematic review of risk prediction tools. Br J Gen Pract 2017 Jun;67(659):e396-e404 [FREE Full text] [CrossRef] [Medline]
  27. Helby J, Bojesen S, Nielsen S, Nordestgaard B. IgE and risk of cancer in 37 747 individuals from the general population. Ann Oncol 2015 Aug;26(8):1784-1790 [FREE Full text] [CrossRef] [Medline]
  28. Chen Y, Sinha B, Ye F, Tang T, Wu R, He M, et al. Prostate cancer management with lifestyle intervention: From knowledge graph to Chatbot. Clinical and Translational Dis 2022 Feb 20;2(1). [CrossRef]
  29. Stampfer MJ, Ridker PM, Dzau VJ. Risk factor criteria. Circulation 2004 Jun 29;109(25 Suppl 1):IV3-IV5. [CrossRef] [Medline]
  30. Kantor E, Hsu M, Du M, Signorello L. Allergies and Asthma in Relation to Cancer Risk. Cancer Epidemiol Biomarkers Prev 2019 Aug;28(8):1395-1403 [FREE Full text] [CrossRef] [Medline]
  31. Verheij RA, Curcin V, Delaney BC, McGilchrist MM. Possible Sources of Bias in Primary Care Electronic Health Record Data Use and Reuse. J Med Internet Res 2018 May 29;20(5):e185 [FREE Full text] [CrossRef] [Medline]

CDR: connection delta ratio
EMR: electronic medical record
KG: knowledge graph
LC: lung cancer
PDJ: patient diagnosis journey
UMLS: Unified Medical Language System

Edited by R Kukafka; submitted 21.06.22; peer-reviewed by Z Wang, I Mircheva; comments to author 30.08.22; revised version received 09.09.22; accepted 25.10.22; published 25.11.22


©Anjun Chen, Ran Huang, Erman Wu, Ruobing Han, Jian Wen, Qinghua Li, Zhiyong Zhang, Bairong Shen. Originally published in the Journal of Medical Internet Research (, 25.11.2022.

This is an open-access article distributed under the terms of the Creative Commons Attribution License (, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work, first published in the Journal of Medical Internet Research, is properly cited. The complete bibliographic information, a link to the original publication on, as well as this copyright and license information must be included.