|

Evolving from RDBMS to SQL + NoSQL

21 Sep 2016
1:15 pm - 1:40 pm

Evolving from RDBMS to SQL + NoSQL

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).