Wednesday, September 07, 2011

Why NoSQL is in fashion?

Couple of years back NoSQL was relatively unheard term. It has become a new buzzword in town, catching people's imagination. Almost all big daddies of Internet (Google, Facebook, Yahoo, Twitter, Amazon, Linked-in etc.) are using NoSQL at massive scale and many of them have their own NoSQL products. Every month there is a launch of new NoSQL product catering to some specific use cases / requirements. So what are the reasons behind NoSQL's rise to popularity?

Background

RDBMS and SQL has ruled the world for last 3 decades. They were (are) the defacto standard for storing business data. In fact there was no alternative to RDBMS and SQL combination. When RDBMS were developed the disk space was scarce, hence a lot of thought has gone around saving precious disk space. Development in hardware technologies have made available literally unlimited storage space at lower prices. Evolution of Internet in last decade has paved way for altogether different kind of applications and use cases, which were never thought earlier. Web2 applications (say social networking) have entirely different requirements than typical enterprise applications. Other than that Internet has changed the way application developers think about the data and its usage & storage.

Requirement

Nowadays enormous amount of data is being produced everyday and the rate at which data is produced is also increasing. Data size is so huge that organizations spread it across data center as it does not fit in a single rack or data center. Though data availability is also an equally important factor in using multiple data centers for storage. Applications have to available 24x7 no matter what. Data has to survive the data center failure as well, forget about failure of a disk. Instead of archiving data, Facebook type of applications keep it online forever.

Social networking sites are coming up with new features quite frequently and sometimes rolling back them. At times their new features were never thought about earlier. They don't want to be confined by the schema constraints of RDBMS which is quite difficult (though not impossible) to change. Support for evolving schema has become a necessity and NoSQL solutions are a right fit there instead of RDBMS.

Data size, flexible schema and availability are the 3 key factors where traditional RDBMS do not perform well after a certain limit.

Thought Process

Web2 applications has changed how people think about application architecture. It is an altogether different thought process then what it was few years back.

While designing an enterprise application we used to think about "how to store the data" but today the primary thought is "how we will use the data". This is a paradigm shift. Data storage is designed based on how that is going to be used, leading to optimized performance for a given requirement at times at the cost of flexibility.

"Referencing" entities was a wonderful feature in RDBMS but for large scale web 2 application that does not matter at all. For them instead of referencing "embedding" is the killer feature. Storing related data (say personal detail and address) together makes sense as they don't have any meaning independently. This is similar to denormalization in RDBMS.

For many features of web 2 applications ACID transactions are also not a primary requirement. Say if a tweet does not gets published many users won't mind to type that again and hit the enter button as long as that does not happen frequently. If avoiding ACID transactions increases the throughput many fold for not so critical features, what else you want :-). It is similar to old MySQL though with much larger data-set than what MySQL can support.

Conclusion

There are several use cases where NoSQL perform much better and it makes perfect sense to use NoSQL instead of trying to scale the RDBMS by using expensive methods. RDBMS’s are really good at doing what they do, which is storing flat, relational, tabular data in a consistent manner and getting wonderful reports out of that data. They still remain the best solution for storing relational data.While NoSQL databases are good at performance, availability, schema-less persistent etc., which has become a basic requirement for today's applications. Support for these features is the main reason for meteoric rise to fame of the NoSQL.

105 Comments:

Anonymous said...

Sorry, but your logic is flawed. 99% of the actual businesses will absolutely need a good level of ACID-ness. Saying things like "so what if my data gets lost" is nonsense in almost every case. As that famous "Mongo is web scale" cartoon said, if you don't care about your data, just send it to /dev/null.

Vinod Singh said...

@veggen,

What you are saying is correct. If ACID is must for the use case then NoSQL is not the right tool.

RDBMS and NoSQL are complimentary technologies. It is about picking right tool and using the right technology for the task at hand. One size does not fit all.

Oliveira said...

That is partially the reason, the other is that Nosql is simpler.

Programming in an object oriented way and then persisting your data in relational databases introduces huge complexity.

Nowadays as problems are scaling massively in abstraction, simpler is king as we can't introduct complexity such as rdbms freely in out lifes without some overwhelming evidence of its benefits compared simpler more direct approaches.

Luca Garulli said...

What about a NoSQL product that supports ACID Transactions and SQL? http://www.orientechnologies.com

DanyelLawson said...

hogwash! Learn a little SQL before you talk about the simpler NoSQL solutions. They are not simpler. They are much more complex and have no standardization. The name NoSQL says it all. People who are scared of learning SQL are jumping through hoops to learn these fads when it is much easier to learn a little SQL.
This all started with the memcache fad. An APE for people afraid to learn how to how to program a simple cache with the ability to communicate across processes.
Personally I use sqlite memory and file databases to solve this problem using SQL. Avoiding the sucker bet of learning a product instead of a skill.
Just my two cents.

rachel said...

thanks, it is a formative article

Ramya said...

Nice blog, it’s so knowledgeable, informative, and good looking site. I appreciate your hard work. Good job. Thank you for this wonderful sharing with us. Keep Sharing.
DevOps Training in Chennai

DevOps Online Training in Chennai

DevOps Training in Bangalore

DevOps Training in Hyderabad

DevOps Training in Coimbatore

DevOps Training

DevOps Online Training

Priyanka said...

Attend The Data Analytics Courses From ExcelR. Practical Data Analytics Courses Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Data Analytics Courses.
Data Analytics Courses

Anonymous said...

Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
Correlation vs Covariance
Simple Linear Regression
data science interview questions
KNN Algorithm
Logistic Regression explained

arshiya said...

Great information, nice to read your blog. Keep updating.
keyword stuffing seo
how to make career in artificial intelligence
angular js plugins
what is rpa technology
rpa applications
angularjs interview questions and answers

Unknown said...

Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.Data Analytics Course

data scientist london said...

Highly appreciable regarding the uniqueness of the content. This perhaps makes the readers feels excited to get stick to the subject. Certainly, the learners would thank the blogger to come up with the innovative content which keeps the readers to be up to date to stand by the competition. Once again nice blog keep it up and keep sharing the content as always.
Data Science training

Deekshitha said...

Informative blog
Data Science Course

donaldrsimonn said...

Online football betting i99club, one of the world's leading online gambling sites, เว็บแทงบอล provides the best prices in football betting.


Ufabet1688 online betting website ufabet is a 100% legal website with all licenses.


ufa football betting, casino, slots, lottery, direct website 1688, stable financial, 100% UFABET168.


Fan wreath shop with free delivery, พวงหรีด with pictures before-after sending with receipt.


Sticking to the COVID-19 situation: โควิด Arekorenavi.info.


Online Baccarat FOXZ24 Easy to apply, fast, บาคาร่า deposit-withdraw 10 seconds with the system.

donaldrsimonn said...

FOXZ88.NET online casino website คาสิโนออนไลน์ Global standard 2020-2021.


Ufabet betting online gambling reminiscent of UFASCR.COM Baccarat.


UFABET football betting website, the big brother of all ufa networks, UFADNA, with an update The first modern system in 2021.


Web football i99PRO online lottery เว็บบอล casino apply today for free 5000 bonus.


Kardinal Stick Siam - relx a great promotion. Express delivery in 3 hours.


Online Marketing Company By the way we can make your website. SEO Reach more customers directly to your business group. Grow your sales.

Priya Rathod said...

I am happy to visit here. Thanks to my friend who told me about this webpage, this blog is really awesome
Data Science Training in Hyderabad
Data Science Course in Hyderabad

Priya Rathod said...

This is a great inspiring article. I am pretty much pleased with your good work. You put really very helpful information.
Python Training in Hyderabad
Python Course in Hyderabad

Priya Rathod said...

This is a great inspiring article. I am pretty much pleased with your good work. You put really very helpful information.
Python Training in Hyderabad
Python Course in Hyderabad

data science said...

I was just examining through the web looking for certain information and ran over your blog.It shows how well you understand this subject. Bookmarked this page, will return for extra. data science course in vadodara

Data Scientist Course in Dombivli said...

Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing. data science institute in delhi

Data Science Course in Bhilai - 360DigiTMG said...

Impressive blog to be honest definitely this post will inspire many more upcoming aspirants. Eventually, this makes the participants to experience and innovate themselves through knowledge wise by visiting this kind of a blog. Once again excellent job keep inspiring with your cool stuff.

Data Science Training in Bhilai

Data Science Course in Bhilai - 360DigiTMG said...

Wonderful blog found to be very impressive to come across such an awesome blog. I should really appreciate the blogger for the efforts they have put in to develop such an amazing content for all the curious readers who are very keen of being updated across every corner. Ultimately, this is an awesome experience for the readers. Anyways, thanks a lot and keep sharing the content in future too.

Data Science Course in Bhilai

Unknown said...

marsbahis
betboo
sultanbet
marsbahis
betboo
sultanbet

Unknown said...

ucuz takipçi
ucuz takipçi
tiktok izlenme satın al
binance güvenilir mi
okex güvenilir mi
paribu güvenilir mi
bitexen güvenilir mi
coinbase güvenilir mi

Majortotosite Pro said...

It’s awesome to pay a visit this web page and reading the views of all colleagues concerning
this piece of writing, while I am also zealous of getting knowledge. 토토

Racesite Pro said...

Very nice post. I just stumbled upon your weblog and wanted to say that I have really enjoyed browsing your blog posts. In any case I will be subscribing to your feed and I hope you write again very soon!
온라인경마
경마사이트

Oncasinosite Net said...

I need to to thank you for this fantastic read!! I definitely loved every little bit of it. I’ve got you saved as a favorite to look at new stuff you post… 카지노사이트

Totopick Pro said...

You completed a number of fine points there. I did a search on the subject and found mainly people will agree with your blog. 토토사이트

yadongbiz said...

I blog often and I truly appreciate your content.
야설

Feel free to visit my blog :
야설

yahanvideonet said...


This great article has truly peaked my interest.
일본야동
Feel free to visit my blog : 일본야동

koreayadongcom said...

I’m going to bookmark your site and keep checking for new details about once per week.
국산야동
Feel free to visit my blog : 국산야동

chinayadongnet said...


I subscribed to your Feed too.
일본야동
Feel free to visit my blog : 일본야동

japanyadongcom said...

Hi there! This article could not be written much better!
야설
Feel free to visit my blog : 야설

dataanalytics said...

I have bookmarked your website because this site contains valuable information in it. I am really happy with articles quality and presentation. Thanks a lot for keeping great stuff. I am very much thankful for this site.
data scientist course in hyderabad

dataanalytics said...

You actually make it look so easy with your performance but I find this matter to be actually something which I think I would never comprehend. It seems too complicated and extremely broad for me. I'm looking forward for your next post, I’ll try to get the hang of it!
data scientist training in hyderabad

visa cost Turkey said...

Great post I would like to thank you for the effort you put into writing this interesting and informative article, no matter what is the purpose of your trip to Turkey, you need to pay the visa cost Turkey before submitting the visa application .Depending on your desired option, the e Visa Turkey cost are calculated.

Maneesha said...

This is a great article thanks for sharing this informative information. I will visit your blog regularly for some latest posts. I will visit your blog regularly for Some latest posts.
data scientist course in hyderabad

Maneesha said...

I recently found a lot of useful information on your website, especially this blog page. Among the lots of comments on your articles. Thanks for sharing.
data scientist training and placement

Maneesha said...

Thanks for sharing this information. I really like your blog post very much. You have really shared a informative and interesting blog post .
data scientist training in hyderabad

dmProITacademy said...

I recently came across your article and have been reading along. I want to express my admiration of your writing skill and ability to make readers read from the beginning to the end.
Data Analytics Courses In Pune

Maneesha said...

I recently found a lot of useful information on your website, especially this blog page. Among the lots of comments on your articles. Thanks for sharing.
best aws training in hyderabad


kenyan evisa said...

Nicely written article. Thank you for this. The international tourist who wish to travel to Kenya should apply for Kenya visa application online. Applying online saves time and provide you the best services where you can check the Kenya visa documents requirement and other information very easily.

Unknown said...

Great to become visiting your weblog once more, it has been a very long time for me. Pleasantly this article i've been sat tight for such a long time. I will require this post to add up to my task in the school, and it has identical subject along with your review. Much appreciated, great offer.artificial intelligence course in gurgaon

sòng bạc said...

Hello, I am one of the most impressed people in your article. sòng bạc I'm very curious about how you write such a good article. Are you an expert on this subject? I think so. Thank you again for allowing me to read these posts, and have a nice day today. Thank you.


먹튀검증 said...

Thank you so much for such a well-written article. It’s full of insightful information. Your point of view is the best among many without fail.For certain, It is one of the best blogs in my opinion. 먹튀검증


안전토토사이트 said...

When I read your article on this topic, the first thought seems profound and difficult. There is also a bulletin board for discussion of articles and photos similar to this topic on my site, but I would like to visit once when I have time to discuss this topic. 안전토토사이트

India business visa cost said...

Greetings! Very useful advice in this particular post! Thanks for sharing! keep sharing such useful information. You can get info about India business visa cost through the Online Indian evisa website.

우리카지노 said...

Are you the one who studies this subject?? I have a headache with this subject.우리카지노Looking at your writing was very helpful.

메이저사이트 said...

Excellent read, I just passed this onto a friend who was doing a little research on that. And he actually bought me lunch as I found it for him smile Therefore let me rephrase that: Thank you for lunch. 메이저사이트

sportstotohot.com said...

Wonderful website. Plenty of helpful information here. 토토사이트

racesite.pro said...

Great information, thanks for sharing it with us 경마사이트

reelgame.site said...

Appreciate it for this post, I am a big fan of this internet site would like to keep updated.
파친코사이트

totosite365.info said...

You have mentioned very interesting points! 스포츠토토

카지노사이트 said...

I have been looking for articles on these topics for a long time. 카지노사이트 I don't know how grateful you are for posting on this topic. Thank you for the numerous articles on this site, I will subscribe to those links in my bookmarks and visit them often. Have a nice day.

안전놀이터 said...

What a post I've been looking for! I'm very happy to finally read this post. 안전놀이터 Thank you very much. Can I refer to your post on my website? Your post touched me a lot and helped me a lot. If you have any questions, please visit my site and read what kind of posts I am posting. I am sure it will be interesting.

casinositewikicom said...

Your blog gave us significant data to work with. Each and each tip of your post are amazing. You're the best for sharing 바카라사이트

casinosite.zone said...

Fairly certain he will have a good read. Thank you for sharing! 카지노사이트존

casinosite.one said...

This is very interesting, You’re a very skilled blogger. 카지노사이트

baccaratsite.info said...

I have joined your feed and look forward to seeking more of your great post. 온라인카지노

Unknown said...

Pretty nice post. I just stumbled upon your weblog and wanted to say that I have really enjoyed browsing your blog posts. After all I’ll be subscribing to your feed and I hope you write again soon 먹튀검증업체 I would like to write an article based on your article. When can I ask for a review?!

메리트카지노 said...

Hello! Nice to meet you, I say . The name of the community I run is 메리트카지노, and the community I run contains articles similar to your blog. If you have time, I would be very grateful if you visit my site .

카지노사이트 said...

Don't go past my writing! Please read my article only once. Come here and read it once 카지노사이트


바카라사이트 said...

First of all, thank you for letting me see this information. I think this article can give me a lot of inspiration. I would appreciate 바카라사이트 if you could post more good contents in the future.

casino said...

I'm so happy to finally find a post with what I want. casino You have inspired me a lot. If you are satisfied, please visit my website and leave your feedback.


eligible countries for South Africa visa said...

Thanks for sharing this information. Keep it up.... eligible countries for South Africa visa you can check online via South Africa website, The Government of South Africa has confirmed that South Africa's new e-Visa system will be implemented for 15 countries by March 2022.

Unknown said...

I truly appreciate just perusing the entirety of your weblogs. Just needed to educate you that you have individuals like me who value your work. Unquestionably an extraordinary post. Caps off to you! The data that you have given is exceptionally useful.data science course in bhopal

메리트카지노 said...

What an interesting story! I'm glad I finally found what I was looking for 메리트카지노.

온카지노 said...

I always think about what is. It seems to be a perfect article that seems to blow away such worries. 온카지노 seems to be the best way to show something. When you have time, please write an article about what means!!

바카라사이트 said...

Hello. I'm subscribed to your posts. You inspire me a lot.바카라사이트I am so grateful.

슬롯사이트 said...

Of course, your article is good enough, 슬롯사이트 but I thought it would be much better to see professional photos and videos together. There are articles and photos on these topics on my homepage, so please visit and share your opinions.

Indian tourist visa said...

What an outstanding post! “I'll be back” (to read more of your content). Thanks…. Foriegn travelers whose sole purpose of visiting India is for leisure, sightseeing, religious work or casual travel to visit their friends or relatives can apply for Indian tourist visa through online India visa application system.

Unknown said...

I am so happy to read this. This is the kind of manual that needs to be given and not the random misinformation that’s at the other blogs. Appreciate your sharing this greatest doc. 메이저토토

룰렛사이트 said...

My curiosity was solved by looking at your writing. Your writing was helpful to me.룰렛사이트I want to help you too.

casinoapi said...

There are also articles on these topics on my blog and I hope you visit once and have a deep discussion!casino api

DataBank said...

Nice to be seeing your site once again, it's been weeks for me. This article which ive been waited for so long. I need this guide to complete my mission inside the school, and it's same issue together along with your essay. Thanks, pleasant share.
Data Science training in Bangalore

Diksha Gupta said...

I like your post. I appreciate your blogs because they are really good. Please go to this website for the Data Science Course: For Data Science Course Data Science course in Bangalore. These courses are wonderful for professionalism.

Unknown said...

Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.business analytics course in bhubaneswar

DataScienceEXPO said...

Thank you quite much for discussing this type of helpful informative article. Will certainly stored and reevaluate your Website.
Data Analytics Course in Bangalore

토토사이트모음 said...

While looking for articles on these topics, I came across this article on the site here. As I read your article, I felt like an expert in this field. I have several articles on these topics posted on my site. Could you please visit my homepage? 토토사이트모음

Data Science said...

Amazingly by and large very interesting post. I was looking for such an information and thoroughly enjoyed examining this one.
Keep posting. An obligation of appreciation is all together for sharing.
data science training in gwalior

Data Science said...

Amazingly by and large very interesting post. I was looking for such an information and thoroughly enjoyed examining this one.
Keep posting. An obligation of appreciation is all together for sharing.
data science course in gwalior

Unknown said...

Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing.data science course in bhubaneswar

Indian tourist visa said...

It looks like I have been to this site before, but after reading some of the post I realized it is new to me. Regardless, I'm glad I found it and I will be returning soon. Foreign nationals intending to visit India for Tourism are allowed to enter into India on e-tourist visa Inde/ Indian tourist visa through online Indian visa website. Apply for India travel visa via online visa India website.

Indian tourist visa said...

After checking through a few posts, I realized this was a new site for me. I'm definitely glad I found it and I will be bookmarking and checking back often. Travelers intending to visit India for tourism are permitted entry into India on an e-tourist visa Inde/Indian tourist visa through an online Indian visa website. Apply online for an India travel visa via the Indian visa website.

Unknown said...

Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!best data science course in bhubaneswar

casinosite777.info said...

This article is very helpful and interesting too. Keep doing this in future. I will support you.
바카라사이트

360DigiTMG said...

Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one.
data analytics course in hyderabad

Unknown said...

Great to become visiting your weblog once more, it has been a very long time for me. Pleasantly this article i've been sat tight for such a long time. I will require this post to add up to my task in the school, and it has identical subject along with your review. Much appreciated, great offer.business analytics course in ghaziabad

Unknown said...

You know your projects stand out of the herd. There is something special about them. It seems to me all of them are really brilliant! data science training in kanpur

Unknown said...

Sports Betting at Safest Betting Sites in Israel - Airjordan10 RetroOutlet
Safest air jordan 18 retro men blue cheap Betting Sites in Israel · The Best show to buy air jordan 18 retro men and Best Betting Sites in 토토 사이트 모음 the UK · The UK's Hottest jordan 18 white royal blue to us Bookmakers · Betfair Sports Betting Authority · 샤오 미 토토 Betfair

Project Management Course said...

It is perfect chance to make a couple of game plans for the future and the opportunity has arrived to be sprightly. I've scrutinized this post and if I may I have the option to need to suggest you some interesting things or recommendations. Perhaps you could create next articles insinuating this article. I have to examine more things about it! https://360digitmg.com/course/project-management-professional-pmp

메이저사이트추천 said...

Traditional bookstores have always existed on high streets, but in the digital age, the internet is proving to become a serious competitor to traditional brick and mortar stores. This article examines both sides of the coin and provides an appropriate insight into the phenomenon of shopping of books online. 메이저사이트추천

PMP Training in Malaysia said...

360DigiTMG, the top-rated organisation among the most prestigious industries around the world, is an educational destination for those looking to pursue their dreams around the globe. The company is changing careers of many people through constant improvement, 360DigiTMG provides an outstanding learning experience and distinguishes itself from the pack. 360DigiTMG is a prominent global presence by offering world-class training. Its main office is in India and subsidiaries across Malaysia, USA, East Asia, Australia, Uk, Netherlands, and the Middle East.

Albert said...

Good morning everyone.. Your post more useful for all person. Thank you sir.. Many people query What is visa fee for Indian e-business? Indian e-business fee depends on your nationality and your visa duration. You can read all other information about the Indian e-business visa on our India eVisa page.

werwer said...

WinRAR 5.ninety Crack is a RAR Archive program that can use for backup your data, decompress RAR ZIP, and other files downloaded and decrease the dimensions of email attachments, create new archives in RAR and ZIP file format. This program consists of safety attributes, https://freeprosoftz.com/winrar-crack-2022/

메이저토토사이트모음 said...

Your ideas inspired me very much. 메이저토토사이트모음 It's amazing. I want to learn your writing skills. In fact, I also have a website. If you are okay, please visit once and leave your opinion. Thank you.

슬롯커뮤니티 said...

슬롯커뮤니티

메이저놀이터추천 said...

I accidentally searched and visited your site. I still saw several posts during my visit, but the text was neat and readable. I will quote this post and post it on my blog. Would you like to visit my blog later? 메이저놀이터추천

스포츠토토사이트 said...

Please keep on posting such quality articles as this is a rare thing to find these days. I am always searching online for posts that can help me. watching forward to another great blog. Good luck to the author! all the best! 스포츠토토사이트

Dtat science Course said...

Two full thumbs up for this magneficent article of yours. I've really enjoyed reading this article today and I think this might be one of the best article that I've read yet. Please, keep this work going on in the same quality. data science course

sowmya said...


You re in point of fact a just right webmaster. The website loading speed is amazing. It kind of feels that you're doing any distinctive trick. Moreover, The contents are masterpiece. you have done a fantastic activity on this subject! data scientist course

CasinoMecca said...

CasinoMecca

토토사이트 said...

Decent data, profitable and phenomenal outline, as offer well done with smart thoughts and ideas, bunches of extraordinary data and motivation, both of which I require, on account of offer such an accommodating data here 토토사이트

CRM software in india said...

Very informative Blog! There is so much information here that can help thank you for sharing.

sivakumar said...

360DigiTMG offers the best training program for Data Science with real-time projects and assignments that will aid you in bagging a high-paying job. Join today.data science course in rohtak