iSchool Capstone

EZ-ETL: OKDoctor

Project tags:

data science & visualization

knowledge organization

Project poster

Today’s Extract, Load and Transform (ETL) tools focus on graphical design and representation of the process, leaving the required mapping and transformation identification to be done manually. This is extremely difficult when faced with multiple, varied data sources. EZ-ETL uses ontology-driven mechanisms to translate data from multiple sources into concepts specific to the customer knowledge domain. OKDoctor uses the EZ-ETL frame work to evaluate medical research in terms of validity and relevance, providing the Validity Potential Rating as a novel way to support practitioners of Evidence Based Medicine. These evaluation techniques are equally applicable to other industry verticals such as finance, national security & intelligence, and legal.

Project participants:

Vijay Gaikwad

MSIM

Tom Vandermolen

MSIM