Episode 47: Where should I put my data?

Episode 47: Where should I put my data?

Episode 47: Where should I put my data? 150 150 Carlos L Chacon

As data size expands and the way we interact with data changes, in many cases we will need more than one way to store and access that data.  Numerous products have entered the data storage market to solve particular pain points and in this episode we discuss several of the data storage technologies currently available on the market.

The expansion of data and increased expectations the businesses has for analysis and modeling of data we may need more than one storage type to meet those expectations. As data professionals, it is incumbent upon us to understand how these tools work and put them to their best use–before somebody else puts them to sub-optimal use and we are stuck supporting them.  I am joined by Kevin Feasel, a previous guest on the show, who walks us through some of the technologies available and sorts out under what circumstances we want to consider using each one.

Episode Quote:
“We have this great expansion of data requirements and data storage mechanisms . . . but there are some major difficulties with a relational database.”

This episode is sponsored by

In this episode, Kevin gives us his definitions for big and small data and looking to get the right technology for our needs. Let us know if you agree in the comments below!

We touch upon the following technologies in the episode

Relational Database
Multidimensional Database
Hadoop Cluster
Columnstore Database
In-Memory Cache
Key-Value Database
Document Database

Kevin On Twitter
Episode 13 – The Apply Operator

About Kevin Feasel

Kevin is a database administrator for ChannelAdvisor and the leader of the PASS Chapter in the Raleigh NC area.  He also enjoys old German films.

  • I really enjoyed Carlos putting this episode together. We had to stay high-level due to time constraints, but I hope this helped shed a bit of light on some of the pros and cons of various data sources.

    I specifically called out Aphyr (https://aphyr.com/) and want to do so again here. Kyle is a great writer and extremely sharp guy. Even if you have no background in distributed computing, his Jepsen series will make you a smarter person.

  • SQL Data Partners Podcast: The Wide World Of Data – Curated SQL June 9, 2016 at 9:03 am

    […] notes are on the SQL Data Partners podcast site.  My presentation slides are available online.  And if I get just a few more people to dig Aphyr […]

  • Dew Drop – June 9, 2016 (#2268) | Morning Dew June 9, 2016 at 7:51 am

    […] SQL Data Partners Podcast Episode 47: Where should I put my data? (Carlos Chacon, Jr.) […]

Leave a Reply

Back to top