In this presentation we will look at storing complex data in a single field. Many noSQL solutions are created around this (such as Redis’ lists, sets and hashes; MongoDB’s records), and many relational database now also support storing complex data in a single field through specific data types (such as PostGreSQL’s JSONB or hstore). Each of the different database engines support different things, and handle these data types in different ways. In this session we compare the different approaches to storage, indexing and interactions with these data types in different databases


Please login to leave a comment

Rated 4

Erik Bogaerts at 13:11 on 22 Feb 2019

Great overview on JSONB and similar data types. Well delivered.

Really interesting overview to storing different data types. Immediately started thinking what we could (should) be doing different, so it did its job!

Rated 5

Donald Tyler at 18:46 on 22 Feb 2019

The talk was very interesting. I really liked the comparison of the various storage methods and the discussions of the pros and cons of each. It was way more helpful than the fanatical presentations about one particular product that claims it's a silver bullet.

I learned a broad range about different data types in the different "databases", and how to query them.