Introduction to VINCI da

services

HSR&D Cyber Seminar

October 11, 2011

VA Informaticsand C ti ompu ng

Infrastructure
Agenda

 What is VINCI (review) Available data VINCI data services VINCI data access/analysis tools Planned enhancements/new featur Q ti ? uestions?
What is VINCI?

 Secure analytical workspace Protect PHI/PII Regulated data access for research Access to data analysis software to Access to high performance servers L hi h d d t t Large hi

gh speed d

a

t

a

storage

 Custom software

 RDP connection – Cloud computing Staff to assist you
VINCI Organization

Veterans Affairs

VHA OI&TORD

BISL/CDW

HSR&D

VINCI
What is VINCI

 Data Center in AITC (Austin Texas

Data Center in AITC (Austin, Texas

 Staff mostly in Salt Lake City field  VINCI works closely with NDS for da

access approval

 Serving both research and operatio CDW as data provider VINCI provid

CDW as data provider, VINCI providanalysis service – working in partne

 VINCI includes custom software 

development work for research use
Poll Question

 Have you already used VINCI 

data/services?

 Yes No Did not know about VINCI
Available Data

 CDW Production Data CDW Raw Data SAS Datasets
CDW Production Data

 Data warehouse modeled data Hosted in SQL Server 2008-R2 Fact and dimension tables Extracted through CDW Extracted through CDW s journalin

’s journalin

process from shadow servers

 Unique CDW identifiers Indexed for fast queries Updated nightly
CDW Production Data

 Patient Demographics Vital Signs Outpatient Pharmacy Consults Health Factors O t ti t E t O

u

tpatient Encoun

ters

 Immunization

 Lab Chemistry PCMM
CDW Production Data

 Orders Appointments More domains coming soon
CDW Production Data

 For updated production domain 

information see:

http://vaww.vinci.med.va.gov/vincicentral/dahttp://vaww.dwh.cdw.portal.va.gov/Pages/welco
CDW Raw Data

 Extracted directly from Vista Cach

databases

 S h t d t Snapsh

ot d

a

t

a

 Same structure as source, not mod Data types and column names 

standardized by VINCI 

– indexes ad

 Updated weekly, monthly, as need Can be joined with prod. and othe Additional data domains can be re

q
CDW Raw Data

 Bill Claims Fee Basis Non-VA Meds MyHealtheVet Patient Treatment File P th ti S Prosth

eti

c Surgery

 Inventor

y

 Travel
CDW Raw Data

 Intravenous Meds TIU Allergies/Adverse Events Radiology
Text Integration Utilities (

 Medical document information suc

clinical notes and nurses notes

 A il bl f ll i ( ki 

Avail

abl

e for

all regions (working o

stations)

 Full Text Indexed – Very fast searc Contains real SSN

–access regulated 

 Updated as needed Does not include radiology and pat

report
Allergies/Adverse Event (R

 Contains patient allergies records a

adverse reaction events

 I l d ll i d d d t Inclu

des:

allergies recor

d

ed d

a

tes,

locations, allergy reactant, such as d dh rug, an

d ot

hers

 Includes all stations

 Update monthly
Radiology (Raw)

 Include epo t otes, p ess o te 

repo

rt 

notes, im

p

ressio

n te

additional clinical history

 Radiology procedures includes: MRI 

Radiology procedures includes: MRIscan, bone scan, ultrasound, ech di g ocardi

o

gram

 Includes all stations

 Updated monthly
SAS Datasets

 Uploaded from AITC mainframe Regularly updated with mainframe  Available in both SAS and SQL Serv

format

 Combined in VINCI for faster & eas

access
DSS NDE (SAS)

 All NDEs include LAB LAR OUT D

All NDEs, include LAB, LAR, OUT, DPHA, and RAD

 FY 2005-current bi d d 

t combined and pro

by DSS team

 Data prior to FY 2005 was transform

combined and loaded to SQ 

L Serve

VINCI staff 

 Monthly or quarterly update
MedSAS (SAS)

 Available in VINCI in both SAS and 

Server table format

 Transformed & loaded to SQL Server  FY 2000 – 2010 Combined over multiple years in SQL 

 Includes:

 Outpatient SE/SF files Inpatient Encounter (SE) Inpatient datasets Inpatient census datasets
Vital Status

 includes date of death Medicare y

includes date of death, Medicare yenrollment indicators, date of last activity and Veteran status flags activity, and Veteran status flags, 

 Transformed and loaded from SAS 

Server tabl b esy VINCI

 Upq y dated quarterly
Other Research Data

 PBM CMS HERC Active duty personnel data Registry data Bi th/d th tifi t d t 

Bi

rth/death certifica

t

e d

a

ta, or ca

death.
Poll Question

 Which data analysis tools do you us SQL Server SAS STATA PASW (SPSS) R Others
VINCI Data Services

 Data description documents Preparatory consulting Cohort selection Data extraction Data formats D t d it D

a

t

a access and securit

y

 External data
Data Description Docume

http://vaww.vinci.med.va.gov/vincicentral/dat
Preparatory Consulting

 Data needs assessment Work with VINCI prior to NDS appro

solidif i t lidify requiremen

t

s

 Contact: vinci@va.gov
Cohort Selection

 If the study does not have a cohort 

If the study does not have a cohortwill help to create one

 Research Study Team provides spe

criteria

 VINCI pro ides data necessar for VINCI provides data necessar

y for 

calculations (if any)

 R h St d T l t 

Research St

u

d

y Team comple

tes c

calculations (if any)
Data Extraction

 Research Study Team receives proj

approval from NDS

 D t A G C t d i l di D

a

t

a Access Group Crea

t

ed includi

Research Study Team participants

 Used for granting access to data & w

 Research Stud

y Team receives aler

the Correspondence Site has been 

 All communication takes place on the  Correspondence Site is easy to use
Correspondence Site
Data Extraction

 Research Study Team uploads coho

secure site or VINCI creates cohort requirements

 Research Study Team completes th

Sel d ection Forms on correspon

dence 

 NDS approved data domains are ex

and provided

 Analysis performed by research pro

team staff
Data Formats

 SQL Server database SAS files PASW (SPSS) STATA Excel Fl t fil Flat files

 Others

 Tools available for data conversion
Data Access & Security

 Access groups created based on IRB 

NDS approved research team

 O l h t b h O

nly research team mem

bers have 

to the data

 Data stored on secure VINCI server Regular data backup and archiving Workspace vs. collaboration site Project work can be performed in  Ex

p p ort final result & 

publication
External Data

 Research Study Team may upload o

data for analysis into project databworkspace

 Secure data upload process Optional direct database upload VINCI data managers work on beha

research team to upload data from data providers
Data Processing/Analysis t

 SQL Server as primary data store Multiple high performance servers Most data queries performed in SQ Accessible by all analysis software SSIS, SSRS, SSAS Hi h d i t Hi

gh speed i

n

tra-server t k 

ne

twork 

w

distributed queries
SAS

 High performance SAS server

 2 TB of RAM, 64 cores, 2 TB SSD L h g id j b Launch grid jobs

 SAS grid – very large data analysis w

 10 high performance servers Most advanced SAS implementation in  Dedicated SAN Additional SAS modules SAS knowledge base SharePoint site

 D di t d SAS d i i t t Dedicated SAS administrator
Other Data Analysis Too

 STATA SPSS

R

 Annotation & NLP tools Terminology databases Oth ft b h d Other software can b

e purc

hased a

needed
Enhancements/New Featu

 New CDW data domains Additional Raw data & standardiza Metadata & data profile reports Cubes Aggregate reports K ld b Knowle

dge base

 DOD research data sharin

g

 Cohort selection tools I2B2 pilot project
Poll Question

 Do you plan on using VINCI data/se

in the next:

 6 months Year Not sure Not planning on using VINCI
Questions?

Contact Information:vinci@va.govhttp g ://vaww.vinci.med.va.gov/vincicen