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 and CouchDB'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, MySQL's JSON). 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.

Comments

Comments are closed.

Ben Mallinson at 12:00 on 30 Sep 2017

A nice baseline talk on the different technologies you can use to store and manipulate non scalar data. I feel including more advantages and disadvantages of the technologies and scenarios to use them in would add interest personally.

Kat Zien at 13:37 on 30 Sep 2017

It was a nice run through all the different technologies to store non-scalar data and a nice refresher about all the different solutions out there. Nothing "revolutionary" for me personally.

Kudos to Derick for staying cool and composed despite the mic problems!

Jeroen v.d. Gulik at 14:20 on 30 Sep 2017

Good comparison of all the different databases. Would have liked a bit more (opinionated) examples of when to use which database to show some of the strengths

Nathan Dunn at 15:36 on 30 Sep 2017

Great look at some ways of storing non-scalar data. I enjoyed the talk and thought there was some great details, including how to query JSON columns in MySQL and Postgres. I would've structured the talk a little bit differently, and would have possibly gone through each database technology separately, rather than looking at all of the technologies for each topic at once.

Good overview of different ways of storing non-scalar data. More of a focus on the advantages and disadvantages of the different databases instead of examples of the syntax for doing similar things would have improved the talk.

It was great to see a talk looking at how different products implement this type of storage.

I liked the structure of the talk comparing each of ways of interacting with each storage type. I think it could have benefitted from so examples that highlight the strengths and weaknesses of each.

Simon R Jones at 11:07 on 1 Oct 2017

Enjoyable overview of different databases and how well they deal with non-scalar data. Feel a lot more informed about the different options out there now, and the movements MySQL is making into this territory.

Katy Ereira at 13:27 on 1 Oct 2017

Explored lots of different types of data storage for non-scalar data. Very informative, but as people have said, it would be nice to hear more opinions on which is best when and why.

Ben Plummer at 21:11 on 1 Oct 2017

A nice overview of the different databases that can be used to store non-scalar data with useful advantages and disadvantages of each. It would have been good to have heard why one solution would be preferred to another in different scenarios though.

Informative recapitulation of what are the differences between db engines.

Tom Walder at 21:49 on 1 Oct 2017

Good overview of basic CRUD operations in a range of relational and non-relational DBs and Search Engines. I'd like to know more about the underlying storage and index mechanisms in each type.

Good talk, very well structured. To improve the talk I would reduce the number of datastores that were compared, maybe dropping MySQL and CouchDB as they are too similar to the other solutions mentioned and make it clearer when to use which solution.

Dave Liddament at 20:08 on 2 Oct 2017

I've not ventured too far into the world of noSQL data stores, so it was interesting to get an overview of them and to get an idea of where they might be useful.

The only thing I would suggest changing is the abstract. I think the amount of material, the pace of the talk and depth was right for the length of talk. I don't see how any more could have successfully been added. However judging by some of the feedback you received, people seem to expect more. Perhaps add something like "high level overview of various noSQL solutions" or words to that effect. Just to make sure attendees' expectations are aligned with what's possible in a 45min talk.

Martin Price at 20:20 on 2 Oct 2017

Good as a high level and objective look at the different technologies out there and how they can handle storing/querying complex data. I did find myself wanting to know more of the in depth pros/cons of the technologies' approaches, but I understand that that wasn't the point of the talk, so that's fair enough.

Ronald D. at 12:17 on 3 Oct 2017

Decent overview of the different solutions.

Onit Siew at 06:45 on 4 Oct 2017

good overview about different common techs for storing non-scalar data.

AlwinD at 13:29 on 5 Oct 2017

Great examples, but a little bit to much detail.

Erik Smit at 16:51 on 8 Oct 2017

A nice basic talk about non scalar data. Because of all the database comparisons it went from a structured talk to a somewhat spaghetti look and feel. A little bit too much of everything caused this flaw. Otherwise it would have been a good basic talk.