...Back to blog index

Finished reading "Seven Databases in Seven Weeks"


After a hiatus from reading the book “Seven Database in Seven Weeks”, I finished it over the summer. The book had some new concepts to me that were not as easy to keep readings the “Seven Languages…” book. However, once I got into the habit of digesting it a little at a time, I was very glad I did. It contains a lot of valuable information on the landscape of modern day databases.

The databases covered in the book were:

Postgresql This was the most familiar chapter to me because of my experience with MySQL, Postgres and relational databases in general. The book covered some advanced topics by “day3”.

Riak A REST based database. Having read this chapter after spending several months developing a REST API for a client, I found the chapter quite interesting. The concepts are quite foreign compared to the normal relational SQL that I am used to. Perhaps I’ll never use it, but it is a novel way to think of data. This chapter presented my first taste of a database clusters.

HBase This chapter started out ok, but by the end I was just pushing on to be done with it. From the chapter, it sounds like the database is only used on really huge sites and datasets, so I doubt I will make use of it.. I also do not think I fully understand the advantage of fetching data in columns instead of rows.

MongoDB Another database for large amounts of data, but I really liked the looks of this one. Structured with JSON and run on JavaScript, the functionality was very easy and intuitive to follow. The commands are also very familiar for someone coming in with a relational database background. I expect to try this DB soon in some of my projects. This chapter was the first part of the book to introducing data sharding.

CouchDB Like MongoDB, CouchDB stores it’s date in JSON format. Unlike Mongo, this database supposedly works well for small and large data sets. Instead of the more relational database type queries of Mongo, Couch uses REST calls over HTTP like Riak. It also keeps version information through revisions. One last note is that it is built in the Erlang language, which as I discussed in the “7 Languages in 7 Weeks” book is built for fault tolerance, and concurrency.

Neo4J Neo4J stores relationships as graphs - connected vertices with unidirectional or bidirectional edges. Along with HBase, this chapter had the most foreign concepts to me compared to my existing relational database experience. From my computer science background I know all about graph traversal; but to see the concepts being used as a database was new to me.

Redis A key-value store that can store complex objects such as lists, sets, maps and hashes. It can be used as a fast cache between program logic and a more persistent data model. I found this database intuitive and expect to integrate it into future web applications.

Conclusion

All in all, the book was informative and broadened my perspective on current databases. With the exception of the HBase chapter, I enjoyed reading about each database and learned many new things.

I found this book very useful to quickly be introduced to the modern database landscape and NoSQL paradigm. In general, it looks like databases are being built for the modern web - supporting a REST interface and JSON datastructure. As the author mentions, the REST interface also enables (programming) language-agnostic usage of each database.

Rating: 4/5

 
...Back to blog index
comments powered by Disqus