1 / 21

Internal caGrid Pilot Project

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

Download Presentation

Internal caGrid Pilot Project

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. Internal caGrid Pilot Project

  2. Driving Causes caGrid Pilot Project caB2B Query Tool Project Details Project Outcomes What’s Next Topics

  3. 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

  4. 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

  5. Implement caGrid infrastructure “Grid enable” disparate data sources (LIMS, Tumor Registry, DBBR) Implement an instance of caB2B Successfully run federated queries caGrid Pilot Objectives

  6. 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

  7. Federated Query caGrid / caB2B DBBR Query LIMS Result TR Information Model

  8. 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

  9. 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:

  10. 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

  11. 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

  12. 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

  13. 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

  14. Client Interface

  15. Web Interface

  16. caB2B - Results LIMS Tumor Registry DBBR

  17. caB2B Issues

  18. 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

  19. 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

  20. 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

  21. 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

More Related