370 likes | 618 Views
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
E N D
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? 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 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
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
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
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? Now Let’s Load it Into a Columnar Database: HP Vertica
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
Columnar Databases Are Mostly Plug Compatible with Standard Databases Like IBM DB2
Compatibility Enablesa ManageableReplacement Strategy IBM DB2 Oracle MS SQL Server Columnar Database
Compatibility Enablesa ManageableReplacement Strategy IBM DB2 Oracle MS SQL Server Columnar Database
BCBSA Enterprise Informatics:A Big Data Projects Accelerator
Informatics Service 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 • 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