Join 4,000+ technologists, decision makers and community members in Raleigh, NC

October 13 - 15

Register

Databases

2-for-1: TBA / Mapping the NoSQL Schema for a Nation-Scale Electronic Health Record System for SQL Access

Christopher Edwards   

TBA

Speaker and talk coming soon!

Christopher Edwards – Mapping the NoSQL Schema for a Nation-Scale Electronic Health Record System for SQL Access (Intermediate)

While NoSQL databases are often the preferred choice for large-scale transactional systems because of their performance and operational characteristics, they lack the wealth of analytics and reporting tools available to SQL databases. This is especially true in health care, where there is a need for both standard as well as ad hoc reports, and especially true for a NoSQL system that scales up to, and is deployed in, a nation-scale electronic health record system.

An ideal solution would use NoSQL for transactional processing and SQL for analytics and reporting. However you can’t just take a NoSQL database and make it SQL – there are differences in how the data is stored and what a valid column/field/table name is. Various transforms need to be applied to the field names, creation of “”new”” tables to get to data that is nested within a given data item (arrays of objects, etc.).

This talk will explore what is needed to map the NoSQL schema of an Electronic Health Record System that is used at nation-scale to SQL and show a working version of the software required.