1 / 11

i2b2 Temporal Queries

i2b2 Temporal Queries. i2b2 Proposal Aims. Implement sets of time points that can be queried by iterative use of simple time-based and Boolean operations Implement temporal abstraction mechanisms to aggregate time points into intervals

manon
Download Presentation

i2b2 Temporal Queries

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. i2b2 Temporal Queries

  2. i2b2 Proposal Aims • Implement sets of time points that can be queried by iterative use of simple time-based and Boolean operations • Implement temporal abstraction mechanisms to aggregate time points into intervals • Evaluate performance. Compare to temporal relations found by DBPs and previous pharmacovigilance work. Compare codified but incomplete EHR data to NLP from notes.

  3. Ways to Extend i2b2 Server Side Client Side Web Browser PM WORK Plugin Viewers CRC Core Cell Viewers Plugin ONT Cell Client Framework

  4. Data Tables New Query Result Tables patient_dimension patient_num birth_date death_date sex_cd race_cd ethnicity_cd zip_cd encounter_dimension encounter_num patient_num inout_cd location_cd location_path start_date end_date observation_fact patient_num encounter_num provider_id concept_cd start_date end_date value_num temporal_datetime_collection temporal_datetime_coll_id result_instance_id patient_num concept_cd start_date end_date value_num provider_dimension provider_id provider_path name_char concept_dimension concept_cd concept_path name_char temporal_interval_collection temporal_interval_coll_id result_instance_id patient_num concept_cd concept2_cd interval_type_cd interval_size_num sequence_num start_date end_date observation_count_num min_value_num max_value_num avg_value_num stdev_value_num median_value_num upper_percentile_num upper_value_num lower_percentile_num lower_value_num Query History Tables query_master query_master_id name request_xml user_id delete_flag query_instance query_instance_id query_master_id status_type_id start_date end_date query_result_instance result_instance_id query_instance_id status_type_id result_type_id set_size Query Result Tables patient_set_collection patient_set_coll_id result_instance_id patient_num patient_enc_collection patient_enc_coll_id result_instance_id patient_num encounter_num

  5. User Interface Graphical representation of a query subpopulation (Nigrin, 2000) A Boolean combination between two retrieved patient subpopulations (Nigrin, 2000)

  6. Types of Temporal Intervals A1c 9.5 9.2 8.4 8.2 8.1 7.0 6.8 7.6 2006 2007 2008 2009 Based on Data (first-to-last) N = 8 Avg = 8.1 Based on Data (3 months after) N = 2 Avg = 9.4 Based on Dates (1/1/07 – 12/31/07) N = 4 Avg = 7.9 Based on Bin (Seasons) N = 2 Avg = 8.3 N = 2 Avg = 7.5 N = 0 Avg = N/A N = 4 Avg = 8.3 Winter Spring Summer Fall

More Related