Page History
...
Windows Run Command
%ANT_HOME%\bin\ant.bat -f data_build.xml create_crcdata_digitaltwin_tables_release_1-8
%ANT_HOME%\bin\ant.bat -f data_build.xml db_digitaltwin_load_data
This will create several new tables in your i2b2 CRC database:
| SQL Table | Tool | Description |
|---|---|---|
| dt_keser_concept_children | KESER | Stores hierarchical relationships between concepts identified by KESER. |
| dt_keser_concept_feature | KESER | Contains features associated with concepts identified by KESER. |
| dt_keser_embedding | KESER | Holds embedding vectors for various concepts used in KESER for phenotype analysis. |
| dt_keser_feature | KESER | Stores features extracted from EHR data for phenotype computation by KESER. |
| dt_keser_feature_cooccur | KESER | Contains data on the co-occurrence of features within patient records identified by KESER. |
| dt_keser_feature_cooccur_temp | KESER | Temporary table for storing intermediate co-occurrence data during KESER processing. |
| dt_keser_feature_count | KESER | Holds counts of various features across the patient cohort identified by KESER. |
| dt_keser_import_concept_feature | KESER | Stores imported features associated with concepts for use in KESER phenotype computation. |
| dt_keser_patient_partition | KESER | Contains partitions of patients for parallel processing of data in KESER. |
| dt_keser_patient_period_feature | KESER | Features extracted from specific periods of patient records by KESER. |
| dt_keser_phenotype | KESER | Contains phenotype definitions identified by KESER. |
| dt_keser_phenotype_feature | KESER | Links features to their corresponding phenotypes in KESER. |
| dt_komap_base_cohort | KOMAP | Base cohort of patients for the KOMAP program. |
| dt_komap_patient_feature | KOMAP | Features extracted from patient records for use in the KOMAP program. |
| dt_komap_phenotype | KOMAP | Phenotype definitions used in the KOMAP program. |
| dt_komap_phenotype_covar | KOMAP | Covariates used in the phenotype analysis for the KOMAP program. |
| dt_komap_phenotype_covar_inner | KOMAP | Intermediate covariate data used during KOMAP phenotype analysis. |
| dt_komap_phenotype_feature_coef | KOMAP | Coefficients for features used in KOMAP phenotype computation. |
| dt_komap_phenotype_feature_dict | KOMAP | Dictionary of features used in KOMAP phenotype analysis. |
| dt_komap_phenotype_gmm | KOMAP | Gaussian Mixture Model results used in KOMAP phenotype clustering. |
| dt_komap_phenotype_gold_standard | KOMAP | Gold standard phenotypes used for validating KOMAP computational phenotype models. |
| dt_komap_phenotype_patient | KOMAP | Links patients to their computed phenotypes in KOMAP. |
| dt_komap_phenotype_sample | KOMAP | Sampled patient data for KOMAP phenotype analysis. |
| dt_komap_phenotype_sample_feature | KOMAP | Features extracted from sampled patient data for KOMAP. |
| dt_komap_phenotype_sample_results | KOMAP | Results of KOMAP phenotype analysis on sampled data. |
| DT_LOYALTY_CHARLSON | LOYALTY | Charlson Comorbidity Index data for loyalty cohort analysis. |
| DT_LOYALTY_PATHS | LOYALTY | Pathways data for determining patient care paths in the loyalty cohort. |
| DT_LOYALTY_PSCOEFF | LOYALTY | Coefficients for propensity score calculation in the loyalty cohort analysis. |
| DT_LOYALTY_RESULT | LOYALTY | Results of loyalty cohort analysis. |
| DT_LOYALTY_RESULT_CHARLSON | LOYALTY | Results of Charlson Comorbidity Index analysis for the loyalty cohort. |
| DT_LOYALTY_RESULT_SUMMARY | LOYALTY | Summary results of the loyalty cohort analysis. |
