220 likes | 373 Views
Internal caGrid Pilot Project. Driving Causes caGrid Pilot Project caB2B Query Tool Project Details Project Outcomes What’s Next. Topics. Located – Buffalo, New York Founded – 1898, nation’s first cancer research, treatment and education center Comprehensive cancer center, member NCCN
E N D
Driving Causes caGrid Pilot Project caB2B Query Tool Project Details Project Outcomes What’s Next Topics
Located – Buffalo, New York Founded – 1898, nation’s first cancer research, treatment and education center Comprehensive cancer center, member NCCN 4,600 admissions, 170,000 outpatient visits / year 3,300 Employees, 150 physicians, 500 nurses Major Research Programs – Biophysical Therapies, Cancer Prevention, Genetics, Therapeutics and Tumor Immunology Vital Stats
Information silos Decentralized clinical systems Inability to query across databases Challenging and sometimes impossible data integration Lack of common data dictionaries and use of vocabularies Core Issues
Implement caGrid infrastructure “Grid enable” disparate data sources (LIMS, Tumor Registry, DBBR) Implement an instance of caB2B Successfully run federated queries caGrid Pilot Objectives
Link and extract data from disparate data sources Creation of a virtual data warehouse RPCI technical knowledge assets Promote standards based infrastructure (caDSR) Create a caBIG core foundation Projected Benefits
Federated Query caGrid / caB2B DBBR Query LIMS Result TR Information Model
Windows VM caGRID 1.3 Data Service Creation: Prerequisite Software Enterprise Architect 8.0 OpenMDR Components caAdapter4.4 MMS caCORE SDK Toolkit 4.3 Installation
Identified target data elements Performed UML modeling & annotations Generated caCore like application using caCore SDK tool Created and deployed data service using Introduce Data Services Creation of caGrid compatible Data Services:
Multiple JBoss Instances Data services hosted on single Windows VM Created multiple instances of JBoss and deploy the services in them caCore SDK with MS SQL Server 2 databases using MS SQL Server (not supported by caCore SDK 4.3) Generated Introduce artifacts as we would for an Oracle database, then modified the hibernate configuration to point to the MS SQL Server Implementation behind firewall caB2B negated need for an internal FQP instance and indexing service Customizations
Decided to keep the data behind our firewall Did not have the constraint of having to map all the attributes to caDSR CDE’s. Used OpenMDR - flexibility to use either the caDSR CDE’s or custom CDE’s CDE’s OpenMDR for Mapping CDE’s
caGrid and caB2B Issue: caGrid Portal query tool did not meet our needs Fix: cancer Bench-to-Bedside (caB2B) • Query tool for searching caBIG data models • RPCI first to use for an internal grid project • Ongoing development driven by use cases
Problem: Our custom data models were not registered with the caDSR Resolution: Load models through the backend Configure the data service’s URL caB2B Changes
caB2B - Results LIMS Tumor Registry DBBR
Project Timeline Nov, 2010 Dec, 2010 July, 2010 Sept, 2010 • caB2B Installation • Load Data Models caB2B • Trouble Shooting • Query Execution • caGrid Installation • UML Modeling • Data Service Creation • Trouble Shooting • Successful Query
Successfully demonstrated federated queries (though issues remain with caB2B) Technical expertise has been acquired (federated query processing) Valuable assets have been gained (knowledge and resource) Collaborative relationship with the caBIG community (excellent support from KC’s) Pilot Project Results
Continue testing… Resolve remaining issues with caB2B (new version scheduled for release March, 2011) Full validation of query results Present final results to steering committee If approved, then implement as a tool to support our Clinical Data Network Office What’s Next
Questions ----------------------------------------------------------------------- Contacts: Ken Quinn – caBIG Deployment Lead Ken.Quinn@RoswellPark.org 716-845-1735 Mayur Sakthivel – Programmer / Analyst Mayurapriyan.Sakthivel@RoswellPark.org 716-845-8805