1 / 35

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

kirima
Download Presentation

Columnar Database Experiences

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. Columnar Database Experiences Unlocking the Value of Big Healthcare Data Enterprise Informatics, BCBSA Nasir Khan Bob Kero

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

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

  4. Agenda

  5. Living Big In Interesting Times

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

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

  8. The Challenge:We Must Analyze Exponentially Growing Healthcare Data Assets

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

  10. The Objective:Big Data Solutions Facilitate Healthcare Transformation

  11. Our Own Big Data Challenge

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

  13. ADaM:Key Functionality Centered Around Business Flexibility

  14. ADaM: An Encounter with the Challenges of Big Data

  15. Our Search For Effective Solutions

  16. Assessment:Emerging Trends in Big Data DBMS Technology

  17. Initial Choice: HP VerticaAn Advanced Columnar Database

  18. What is a Columnar Database?Imagine an Excel Spreadsheet to Load into a Database Customer Purchases

  19. What is a Columnar Database? Let’s First Load it Into a Standard Database, Oracle or IBM DB2

  20. What is a Columnar Database? Now Let’s Load it Into a Columnar Database: HP Vertica

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

  22. Columnar Databases Are Mostly Plug Compatible with Standard Databases Like IBM DB2

  23. Compatibility Enablesa ManageableReplacement Strategy IBM DB2 Oracle MS SQL Server Columnar Database

  24. Compatibility Enablesa ManageableReplacement Strategy IBM DB2 Oracle MS SQL Server Columnar Database

  25. What We Were Able to Achieve

  26. ADaM:Performance Issue Root Cause Assessment

  27. HP Vertica Offered Savings for Hardware and License Costs

  28. HP Vertica ADaM POC Findings

  29. How Our Experiences Can Help

  30. Help Clarify Your Business Vision For Big Data Support

  31. Help Understand and Clarify Your Specific Requirements

  32. BCBSA Enterprise Informatics:A Big Data Projects Accelerator

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

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

  35. Questions?

More Related