Columnar database experiences
Download
1 / 35

Columnar Database Experiences - PowerPoint PPT Presentation


  • 128 Views
  • Uploaded on

Columnar Database Experiences. Unlocking the Value of Big Healthcare Data. Enterprise Informatics, BCBSA. Nasir Khan. Bob Kero. Nasir Khan Executive Director of Enterprise Informatics BCBSA

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Columnar Database Experiences' - kirima


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Columnar database experiences

Columnar Database Experiences

Unlocking the Value of Big Healthcare Data

Enterprise Informatics, BCBSA

Nasir Khan

Bob Kero


Nasir Khan

Executive Director of Enterprise Informatics

BCBSA

Nasir has been with BCBSA for over 12 years and has over 25 years of leadership experience in the Healthcare Insurance, Biomedical, Banking and Pharmaceutical industries. Recently he was named “One to Watch” by CIO magazine.


Bob Kero

Managing Director of Enterprise Informatics

BCBSA

Bob has been with BCBSA for over four years and has over 25 years of professional leadership experience in the Healthcare and P&C Insurance, Consulting, Healthcare Provider, and Federal R&D industries. Additionally, he has been a guest lecturer in the Graduate Department of Health Systems Management, RUSH University.




What is big data
What is Big Data?

Data whose size or structure is

beyond the ability

of an organization's existing technology or processes

to use to full business advantage


2014 the big data inflection point for healthcare
2014:The Big Data Inflection PointFor Healthcare?

Medical Loss Ratio

Disease mgmt/predictive modeling

Consolidation

Evidence-Based Medicine

Meaningful Use

ICD-10/HIPAA 5010

Accountable Care Organizations

Payer M&As

Value-Based Reimbursement / Shared Risk

Health Insurance Exchanges

Personalized Medicine

2011

2012

2013

2014

2015

Health Info Exchanges

Medical Home

Medicare Advantage Cuts

Individual Insurance Growth

Provider Collaboration

Diversification

HC Reform Coverage Mandates

Social Media

Medicaid Expansion

Genetic Testing

International Expansion


The challenge we must analyze exponentially growing healthcare data assets
The Challenge:We Must Analyze Exponentially Growing Healthcare Data Assets


The opportunity big data processing offers 300b potential annual savings to healthcare

Personalized medicine & clinical trial design

The Opportunity:Big Data Processing Offers $300B Potential Annual Savings to Healthcare

Transparency in clinical data & clinical decision support

$165B

Clinical

Aggregation of patient records & online communities

$9B

Public Health

$108B

R&D

$5B

Business Model

Public health surveillance & response systems

$47B

Accounts

Advanced fraud detection & performance based drug pricing

Source: McKinsey Global Institute, May 2011


The objective big data solutions facilitate healthcare transformation
The Objective:Big Data Solutions Facilitate Healthcare Transformation



Bcbsa fep bhi healthcare data repositories
BCBSA, FEP & BHI Healthcare Data Repositories

Federal Employee

Program Claims

CCTI

Members & Claims

Extract

Files

FEP

Systems

Daily

Claims

Enrollment

Provider IDs

Plans

Surveys

CCTI

Marts

Ad-hoc Queries & Reports

PDR

Providers

Standard Reports

ADaM

Members & Claims

National

Account

Claims

NDW

Members & Claims

BDR

BHI Data Repository

BHI Member Plan

Claims

Monthly

Claims Membership

Contracts Products

Provider IDs

Extract

Files

Third Party Data

Plans


Adam key functionality centered around business flexibility
ADaM:Key Functionality Centered Around Business Flexibility


Adam an encounter with the challenges of big data
ADaM: An Encounter with the Challenges of Big Data



Assessment emerging trends in big data dbms technology
Assessment:Emerging Trends in Big Data DBMS Technology


Initial choice hp vertica an advanced columnar database
Initial Choice: HP VerticaAn Advanced Columnar Database


What is a columnar database imagine an excel spreadsheet to load into a database
What is a Columnar Database?Imagine an Excel Spreadsheet to Load into a Database

Customer Purchases


What is a columnar database let s first load it into a standard database oracle or ibm db2
What is a Columnar Database? Let’s First Load it Into a Standard Database, Oracle or IBM DB2



Columnar storage allows options for data compression of repeating values
Columnar Storage Allows Options for Data Compression of Repeating Values

Compress ~60%

Requires much less disk I/O

time to retrieve

Trades faster CPU time for

slower disk I/O time



Compatibility enables a manageable replacement strategy
Compatibility Enables Databases Like IBM DB2a ManageableReplacement Strategy

IBM

DB2

Oracle

MS SQL Server

Columnar

Database


Compatibility enables a manageable replacement strategy1
Compatibility Enables Databases Like IBM DB2a ManageableReplacement Strategy

IBM

DB2

Oracle

MS SQL Server

Columnar

Database


What We Were Able to Achieve Databases Like IBM DB2


Adam performance issue root cause assessment
ADaM: Databases Like IBM DB2Performance Issue Root Cause Assessment



Hp vertica adam poc findings
HP Vertica ADaM Databases Like IBM DB2POC Findings


How Our Experiences Can Help Databases Like IBM DB2




Bcbsa enterprise informatics a big data projects accelerator
BCBSA Enterprise Informatics: Databases Like IBM DB2A Big Data Projects Accelerator


Informatics service bus enables lower risk faster deployment of big data apps
Informatics Databases Like IBM DB2Service Bus Enables Lower Risk & Faster Deployment of Big Data Apps

Portal

Web Services

Client Access

LDAP

SiteMinder

Plan

Connexion

Plan Custom Apps

BHI & Partner Apps

S-FTP

App Hosting

Monitoring

Administration

SAML (Certificates)

Plan Custom Tools

SAS

COGNOS

DataStage

Other Standard Tools

Tools Layer

Data Layer

Plan Data (Vertica)

Plan Data (DB2)

NDW

IPDS

Etc.

Plan Direct Extracts

Plan Direct Access


Summary
Summary Databases Like IBM DB2

  • Healthcare is undergoing radical & historic changes

    • Regulatory, business, research and clinical

  • Use of big data will be mandatory to adapt and succeed

  • Columnar databases enable efficient use of big data

    • Cost effectiveness, high performance, fault tolerance

  • We are ready to support entry into the big data area

    • Database, healthcare, analytics, and business expertise

    • Available tools & infrastructure for POCs and deployment


Questions
Questions? Databases Like IBM DB2


ad