SQL NYC, The NoSQL & NewSQL Database Meetup - May 3, 2016

Document created by aalvarez on Mar 28, 2016Last modified by aalvarez on May 4, 2016
Version 2Show Document
  • View in full screen mode


Date:May 3, 2016


99 Madison Ave., 15th Floor, New York, NY

Registration Link:http://www.meetup.com/mysqlnyc/events/229490792/



The NYC NoSQL & NewSQL Group (formerly known as The NYC MySQL Group) is a large community in NYC Area that promotes deep-tech talks, most geared for a general-audience. Join MapR's speaker, Jim Scott, who will be presenting his talk on Evolving from RDBMS to SQL + NoSQL.  



  • How To Update Your RDBMS-Data Into A Modern SQL + NoSQL Environment - Jim Scott -  Director of Enterprise Strategy & Architecture

For the past 25 years, applications have been getting built using an RDBMS with a predefined schema which forces data to conform with a schema on-write. Many people still think that they must use an RDBMS for applications even though records in their datasets have no relation to one another. Additionally, RDBMS databases are typically optimized for transactional use, and data must be exported for analytics purposes. NoSQL technologies have turned that model on its side to deliver groundbreaking performance improvements.

In this presentation, we will walk through a music database with over 100 tables in the schema and show how to convert that model over for use with a NoSQL database.

You will learn how to handle creating, updating and deleting records, using column families for different types of data (and why).

You will also learn how to leverage Apache Drill's ANSI-SQL capabilities on the NoSQL database to use the exact same data without moving or transforming it to perform analytics.