I recently saw an Information Management To-Be Architecture Overview diagram at a client. It has clearly depicted the current landscape for the Relational Database side. Then came the surprise, a single belittled square box called “NoSQL”.
What does that mean?
Most people, including data professionals, don’t know that NoSQL is a collective name for several database technologies. Each solve very different data problems.
NoSQL databases fall into 4 main categories (some examples added):
- Key value store
- Graph store
- Document store
- Column store
James Serra wrote a very informative article explaining it. Read it here.
In a followup post I will provide some information to assist you in understanding the strengths and weaknesses of SQL and NoSQL databases. This will help understand the impact of your database technology choices.
Tip: Be very clear on what problem you want to solve and then choose the correct database technology to assist.