Yet, are they the right solutions for your project?
Are You Eligible for Big Data?
As a rule of thumb, if your database is smaller than 100GB and your biggest table is less than 100M rows, you should avoid seeking Big Data solutions. In that case, make sure you well utilize your current RDBMS investments.
When Should You Choose RDBMS?
There are several other reasons to stick with RDBMS (yes, we are talking about MySQL, SQL Server, Oracle and other):
- You must meet compliance and security procedures (cases: PCI compliance).
- You need complex reporting based on joins between several tables.
- You need transactions (cases: financial transactions).
- You have established data analysts group that cannot be trained to other syntax.
There are several high reasons to select NoSQL solution. Check if your case is eligible for it:
- You are a full stack developer and just look for a persistence storage (cases: blogging system, multi choice exams).
- You need a quick response from your storage solution based on a key value store (cases: algo trading and online stock exchanges bidding: DSP).
- You must always return an answer, even if it's not the most updated one (cases: social networks, content management).
- You need to provide a good enough answer rather the most accurate (cases: search engine).
- Your data size is too big to be transferred over network (even over a 80Gbps Infiniband). In this cases a better approach is distributing the computation (cases: analytics, statistics).
Bottom Line
NoSQL solutions have expanded your toolbox. Now, you need to focus on selecting the right tool for your business case.
Keep Performing,
Moshe Kaplan
