SQL NYC, The NoSQL & NewSQL Database Meetup May 2016
New York City, NY
Tuesday, May 3, 2016
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.


Evolving from RDBMS to SQL + NoSQL

Jim Scott View Bio

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, those databases are 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. I 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. I will show how to handle creating, updating and deleting records, using column families for different types of data (and why). I will then show how to use the exact same data without moving or transforming it to perform analytics, by leveraging Apache Drill's ANSI-SQL capabilities on the NoSQL database.


Jim Scott

Jim drives enterprise architecture and strategy at MapR. Jim Scott is the cofounder of the Chicago Hadoop Users Group. As cofounder, Jim helped build the Hadoop community in Chicago for the past four years. He has implemented Hadoop at three different companies, supporting a variety of enterprise use cases from managing Points of Interest for mapping applications, to Online Transactional Processing in advertising, as well as full data center monitoring and general data processing. Prior to MapR, Jim was SVP of Information Technology and Operations at SPINS, the leading provider of retail consumer insights, analytics reporting and consulting services for the Natural, Organic and Specialty Products industry. Additionally, he served as Lead Engineer/Architect for dotomi, one of the world’s largest and most diversified digital marketing companies. Prior to dotomi, Jim held several architect positions with companies such as aircell, NAVTEQ, Classified Ventures, Innobean, Imagitek, and Dow Chemical, where his work with high-throughput computing was a precursor to more standardized big data concepts like Hadoop.