Presented By O'Reilly and Cloudera
December 5-6, 2016: Training
December 6–8, 2016: Tutorials & Conference

Evolving from RDBMS to NoSQL + SQL

Jim Scott (NVIDIA)
4:15pm–4:55pm Wednesday, December 7, 2016
Becoming a data-centric company
Location: Summit 1
Average rating: *****
(5.00, 2 ratings)

For the past 25 years applications have been getting built using an RDBMS with a predefined schema that 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 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.

Photo of Jim Scott

Jim Scott


Jim Scott is the head of developer relations, data science, at NVIDIA. He’s passionate about building combined big data and blockchain solutions. Over his career, Jim has held positions running operations, engineering, architecture, and QA teams in the financial services, regulatory, digital advertising, IoT, manufacturing, healthcare, chemicals, and geographical management systems industries. Jim has built systems that handle more than 50 billion transactions per day, and his work with high-throughput computing at Dow was a precursor to more standardized big data concepts like Hadoop. Jim is also the cofounder of the Chicago Hadoop Users Group (CHUG).

Comments on this page are now closed.


Kathy Yu
12/09/2016 1:06am +08

Hi Manish – we’ll be posting slides on as we receive them from speakers.

Manish Kumar
12/08/2016 6:56pm +08

Where I can find the presentation slide of this session.