Understanding NoSQL for Product Owners
If the product you manage requires content aggregation you may have heard your dev team say “we need to go with a NoSQL storage solution”. Below is a summery of key points about NoSQL I found through some basic research.
How does NoSQL differ from SQL?
“Not only SQL”
NoSQL is a database movement which promotes non-relational data stores that do not need a fixed schema.
There are several primary storage techniques or “implementations” used by the NoSQL approach:
- Document store – MongoDB, CouchDB
- Eventually‐consistent key‐value store (“ColumnFamily”) – Cassandra
- Graph – Neo4j
- Key/value store on disk – Amazon’s SimpleDB
- Key/value cache in RAM – Redis, memcached
Taken from this Wikipedia article on NoSQL databases
An introduction to NoSQL on Hacker News
A 10 minute talk from Brian Aker bashing NoSQL
What is MapReduce?
MapReduce is a framework for processing huge datasets on certain kinds of distributable problems using a large number of computers (nodes), collectively referred to as a cluster.
“Map” step: The master node takes the input, chops it up into smaller sub-problems, and distributes those to worker nodes. A worker node may do this again in turn, leading to a multi-level tree structure. The worker node processes that smaller problem, and passes the answer back to its master node.
“Reduce” step: The master node then takes the answers to all the sub-problems and combines them in a way to get the output – the answer to the problem it was originally trying to solve.
“GROUP BY” in SQL is very similar to “Map Reduce” in NoSQL.
Taken from this Wikipedia article on MapReduce
What is a Graph db?
A graph database is a database that uses graph structures with nodes, edges and properties to represent and store information.
Example:
Node firstNode = graphDb.createNode();
Node secondNode = graphDb.createNode();
Relationship relationship = firstNode.createRelationshipTo( secondNode, MyRelationshipTypes.KNOWS );
firstNode.setProperty( “message”, “Hello, ” );
secondNode.setProperty( “message”, “world!” );
relationship.setProperty( “message”, “brave Neo4j ” );
We now have a graph that looks like this:
(firstNode )—KNOWS—>(secondNode)
A popular vendor is Neo4j
Taken from this Wikipedia article on Graph Databases
What is a Document db?
As opposed to relational databases, document-based databases do not store data in tables with uniform sized fields for each record. Instead, each record is stored as a document that has certain characteristics. There is no real hierarchy of data; just a collection of documents which may contain virtually any kind of data. The documents may not necessarily be the same length, as some documents may contain details of fields that other documents do not need to store. In other words, you are not constrained by a database schema.
Example:
FirstName=”Bob”, Address=”5 Oak St.”, Hobby=”sailing”.
Another document could be:
FirstName=”Jonathan”, Address=”15 Wanamassa Point Road”, Children=(“Michael,10″, “Jennifer,8″, “Samantha,5″, “Elena,2″).
Notice that both documents have some similar information and some different – but unlike a relational database where each record would have the same set of fields and unused fields might be kept empty, there are no empty ‘fields’ in either document (record) in this case. This system allows information to be added any time without using storage space for “empty fields” as in relational databases.
A popular vendor is MongoDB.
MongoDB manages collections of JSON-like documents. This allows many applications to model data in a more natural way, as data can be nested in complex hierarchies and still be query-able and indexable.
{
“username” : “bob”,
“address” : {
“street” : “123 Main Street”,
“city” : “Springfield”,
“state” : “NY”
}
}
Another popular vendor is CouchDB (Apache) as it works well with Rails.
Taken from this Wikipedia article on Document-Oriented Databases
I thought your post was cool and will visit often.
This really answered my downside, thanks!
A interesting post right there mate ! Cheers for that !
Came clueless, quit worried. Thanks for your post. – Bisexuality immediately doubles your chances for a date on Saturday night. – Woody Allen Born 1935
Really a great site! Just came across this today and will going to check for updates.
I’d be inclined to acquiesce with you here. Which is not something I typically do! I enjoy reading a post that will make people think. Also, thanks for allowing me to speak my mind!
nice! i can tell this was important! good job!
Howdy, I just hopped over for your website online via StumbleUpon. No longer one thing I’d usually learn, but I liked your thoughts none the less. Thanks for making something price reading.
Thanks for this great website. I am trying to read some more posts but I cant get your website to display properly in my Opera Browser. Thanks again.
Spot on with this write-up, I truly assume this website needs much more consideration. I’ll most likely be again to learn way more, thanks for that info.
I do consider all of the ideas you have introduced to your post. They are really convincing and can certainly work. Nonetheless, the posts are very short for starters. May you please lengthen them a bit from subsequent time? Thanks for the post.
I Am Going To have to return again when my course load lets up – nevertheless I am getting your Rss feed so i can read your internet site offline. Cheers.
Quite thankful am I simply because I’ve discovered this practical content material. I’ll check this out and see if it will perform on my weblog as well.
I image this could be various upon the written content? nevertheless I still believe that it may be suitable for virtually any form of matter subject matter, because it will continuously be satisfying to decide a warm and pleasant face or perhaps pay attention a voice whilst initial landing.
This is really interesting, You’re a very skilled blogger. I have joined your rss feed and look forward to seeking more of your wonderful post. Also, I have shared your site in my social networks!
If you don
Interesting. Will defintely be back
wicked blog, this is going on my twitter.
The guidelines you shared here are really useful. Rrt had been such a fun surprise to have that waiting for me after i woke up this very day. They are constantly to the point and straightforward to learn. Thanks a ton for the valuable ideas you have shared right here.
Intimately, the article is in reality the sweetest on this worthw hile topic. I concur with your conclusions and will eagerly look forward to your forthcoming updates. Just saying thanks will not just be enough, for the tremendous lucidity in your writing. I will immediately grab your rss feed to stay abreast of any updates. Solid work and much success in your business efforts!
Lots of would not be acquainted together with the phrase payday mortgage, but people who are, realize that it’s a colleague in want. Sure, it is a mortgage that can help you to overcome all of your emergency personal demands ahead of your real payday arrives. This mortgage will help you to obvious some of your little fiscal desires that crop up while in the middle of your month. This mortgage guarantees that you are not left large and dry if you really need to purchase your son’s summer months project or our wife’s sudden need for more dollars. But what in fact is usually a payday loan? Nicely, a payday loan is often a compact loan which is disbursed through the banks as well as financial institutions to get a short period of time i.e. till your up coming payday.
Really interesting idea for me . Will you post some more ? coz i want to follow ur twitter or facebook
OMG, How did I ever survive without your blog posts? Bye,
Thanks for the post I actually learned something from it. Very good content on this site Always looking forward to new post.
Bizarre this post is totaly unrelated to what I was looking out google for, however it used to be indexed at the first page. I assume your doing one thing right if Google likes you sufficient to put you on the first page of a non related search.
I am really impressed with your writing skills and also with the layout on your blog. Is this a paid theme or did you modify it yourself? Anyway keep up the nice quality writing, it’s rare to see a nice blog like this one nowadays..
Thanks for taking the time to discuss this, I really feel can discover any facts in posting and discus forum
Just wanted to give you a shout from the valley of the sun, great information. Much appreciated.
Hi! I thought your post was cool and will visit often.
inordinate logbook you get hands on
This is the correct blog for anybody who desires to search out out about this topic. You understand so much its almost laborious to argue with you (not that I really would need…HaHa). You definitely put a brand new spin on a subject thats been written about for years. Nice stuff, just nice!
Just wanted to say this is in my best blog list on #34, Cheers
Great blog here! Also your web site loads up very fast! What web host are you using? Can I get your affiliate link to your host? I wish my website loaded up as quickly as yours lol
Interesting. Will defintely be back
More of this please
This does infact pave the way for such circumstances, keep ‘em coming.
This is definitely nice notion dude.iam really proud of you . Do u have twitter?? i would like to adhere to you .thx
Genuinely interesting content articles. I enjoyed examining it.
Exactly where do these bloggers come up with this stuff?
Hello there, You have done a great job. I’ll certainly digg it and personally suggest to my friends. I am confident they will be benefited from this site.
Great post. Very refreshing given all the duplicate content out there. Thanks for doing something original.
I admire the precious data you offer on your articles. I will bookmark your weblog and have my children take a look at up right here generally. I am moderately sure they’re going to be informed lots of new stuff here than anybody else!
Thank you for another informative web site. Where else could I get that kind of information written in such a perfect way? I have a project that I am just now working on, and I’ve been on the look out for such info.
Good post. I learn something more difficult on completely different blogs everyday. It is going to always be stimulating to learn content from other writers and observe a bit something from their store. I’d favor to make use of some with the content material on my blog whether or not you don’t mind. Natually I’ll offer you a link in your internet blog. Thanks for sharing.
Maintain the excellent job mate. This web blog publish shows how well you comprehend and know this subject.
gilborn cassette snailshel macginnis betrayal fraulein domestic blixen dorita
This blog is awesome I always send mates here
I don’t even know how I ended up here, but I thought this post was good. I don’t know who you are but certainly you are going to a famous blogger if you are not already
Cheers!
The blog given to us has some exciting features. It realy increase my knowledge about the topic.
It’s rare for me to find something on the web that’s as entertaining and intriguing as what you have got here. Your page is sweet, your graphics are great, and what’s more, you use source that are relevant to what you’re saying. You are certainly one in a million, well done!