Brandon Herrington – Intro to Using Spatial Data in Open Source Databases (Introductory)
An introduction to the geospatial data formats you might typically find for importing into a database, and some demos of spatial operations within some popular open source databases (MongoDB, PostgreSQL, SQLite, etc.).
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.