Dr. Michael Stonebraker, one of the leading researchers and technology entrepreneurs in the database space, joins Robert for a discussion of database architecture and the emerging NewSQL family of databases. Dr. Stonebraker opens with his take on how the database market is segmented around a small number of use cases: OLTP, data warehouses, and event stream processing. He discusses the origins of the standard architecture for OLTP, which is row-based, and says it’s no longer optimal for any of the use cases that it is applied to. He proceeds to describe some research he has done, showing that row-based databases spend about 90 percent of their time acquiring and releasing locks, buffer management, and other activities that could be characterized as overhead in comparison to main task of reading and writing data. These results, which in Stonebraker’s view are intrinsic to the row-based architecture, require a new architecture to overcome. The discussion proceeds to a new database architecture, known as “NewSQL” or “NewOLTP,” which is single-threaded, lock-free, doesn’t require disk I/O in the critical path, and can scale out to a large multiple node cluster. Stonebraker criticizes the eventual consistency model that some NoSQL distributed systems employ and he defends the ACID guarantees as a superior model. The interview closes with a discussion about database education in university curricula and Stonebraker’s thoughts on the place of Hadoop in the data storage space.
Thanks everyone, for the great response to our first episode of the Plex Podcast released along with the new Plex Web Client; that gave us the (foolish) idea to do another episode!
In this episode, Tobias is joined by Plex Ninjas Mark “Ziggimon” Walker and Paul “Trudge” Trudgian to discuss what hardware you might want to get for that ultimate Plex setup. It’s quite a long discussion about different setups and all the different factors that you need to consider (a LOT of them). A special thanks to Milos Radosavac for editing this episode.
You can subscribe to the Plex Podcast in iTunes, or directly. You can also get a direct link to episode #2 here.
Thanks to Mike Meier, we also have a Plex Podcast channel available in the channel directory if you want to listen to the podcast via Plex.
Enjoy, and please let us know in the comments what sort of topics you’d like to see in the future!
Creating the Plex Software Ecosystem with Elan Feingold on the Hanselminutes Technology Podcast: Fresh Air for Developers
The Hanselminutes Podcast by Scott Hanselman
Plex is a powerful media ecosystem with a server component available on almost every platform and NAS, and clients for every tablet, laptop, phone and device you can imagine. How does it all fit together and get you your media your way, today?