Research Article

Using Distributed Data over HBase in Big Data Analytics Platform for Clinical Services

Table 3

Use cases and patient encounter scenarios related to metadata of patient visits and its database placement related to query output.

Case Clinical Database

Uncontrolled type 2 diabetes & complex comorbidities(i) DAD with diagnosis codes, HBase for IDs

TB of the lung & uncontrolled DM 2(i) DAD and ADT columns with HBase for patient IDs

A on C renal failure, fracture, heart failure to CCU, and stable DM 2(i) DAD and ADT columns with HBase for patient IDs

Multilocation cancer patient on Palliative(i) DAD and ADT columns with HBase integrating data together

1 cardiac with complications(i) DAD and ADT columns with HBase integrating data together

1 ER to surgical, fracture, readmitted category for 7 days and some complication after(i) DAD and ADT columns with HBase integrating data together

1 simple day-surg. with complication, admitted to inpatient (allergy to medication)(i) DAD and ADT columns with HBase for patient IDs

1 cardiac with complications and death(i) DAD and ADT columns with HBase integrating data together

1 normal birth with postpartum hemorrhage complication(i) DAD and ADT columns with HBase integrating data together

1 HIV/AIDS patient treated for an infection(i) DAD and ADT columns with HBase for patient IDs

Strep A infection(i) DAD and ADT columns with HBase integrating data together

Cold but negative Strep A. Child(i) DAD and ADT columns with HBase integrating data together

Adult patient with Strep A. positive(i) DAD and ADT columns with HBase for patient IDs

Severe pharyngitis(i) DAD and ADT columns with HBase integrating data together

Child, moderate pharyngitis, throat culture negative, physical exam(i) DAD and ADT columns with HBase for patient IDs

Adult, history of heart disease, positive culture for Strep A.(i) DAD and ADT columns with HBase integrating data together

Adult, physical exam, moderate pharyngitis, positive for strep A. culture and positive second time, readmitted(i) DAD and ADT columns with HBase for patient IDs