|Date:||May 3, 2016|
99 Madison Ave., 15th Floor, New York, NY
ABOUT THE EVENT
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.
- Link to complete agenda and details: http://www.meetup.com/mysqlnyc/events/229490792/
- Jim Scott Slides: Evolving From RDBMS to NoSQL and SQL