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.

58 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

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

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.

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. 토토사이트

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...

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.

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.

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.one said...

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

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.

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...

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

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.

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/

CRM software in india said...

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

FizaTech said...

Nice Post thanks. You can also visit my Blog... WinRAR 6.11 Crack

Hi Every One said...

Extremely gorgeous composed article. it'll be in settlement to all individuals who uses it, like me. hold achieve what you're placed it on canr stand by to acknowledgment additional posts. Gilisoft Secure Disk Creator Crack

Valentines Day Wishes 2021 said...

I have a troublesome come to be past depicting my brain going a propos for content, but I practically felt I want to here. Your article is totally ubiquitous. I later the eccentricity you composed this spread. Download Visio Free

Turkey evisa said...

I read your blog and found many interesting metrics in this material. Thanks for sharing it on the Internet. Person who is willing to visit Turkey can apply for a Turkey evisa which is a totally online process. Fill the application form, make payment & receive it in email. As simple as that.

Mahil mithu said...

It is very interesting! Really useful for me and thank you for this amazing blog.
Virginia Military Divorce

Sruthi Karan said...

It is very useful for me and thank you so much for your sharing this post. Keep updating...
Separation Before Divorce
Cost of Legal Separation VS Divorce
Online Solicitation Of A Minor

Unknown said...

https://www.fadedfungi.com/dosed-the-movie

Unknown said...

Portraiture Crack

Unknown said...

getflv-crack
Matt johnson

Unknown said...

MHAPHILIAS
minecraft-pocket-edition-android

Unknown said...


iphone-backup-extractor-crack
GCracks

Unknown said...

NoorCracks
Norton Security Crack

Sruthi Karan said...

Nice article! It was very innovative thing with unique title and keep it up...
divorce lawyer in virginia
va divorce lawyers

Crack Voice said...

Download All Premium Software From Boom 3D 1.4.2 Crack Plus Registration Key

Files Mama (filesmama.com) said...

If you want to benchmark your pc for Xbox games then try 3DMark Crack.

Maria3400 said...

Hi there, I am thoroughly enjoying reading your posts. Your content is engaging and informative, and I find myself coming back for more. Navigating the Portuguese Healthcare System can be a helpful guide for residents and visitors seeking medical assistance in Portugal.

Turkey Tourism Statistics 2019 VS 2020 The Goal for 2021 said...

Thank you for the positive feedback! Your encouragement motivates me to continue creating innovative articles with unique titles. I'll strive to maintain the same standard and keep up the good work. A comparative analysis of Turkey's tourism statistics for 2019 and 2020 reveals the impact of the global pandemic. This article aims to explore the anticipated goals and prospects for the sector in 2021.

Nationalities Need a Visa for Turkey? said...

Hello everyone, "Nationalities Need a Visa for Turkey?" Exploring the eVisa Requirements. Discover the essential information about which nationalities require an electronic visa (eVisa) to visit Turkey, streamlining the entry process for travelers.

joshjo27 said...

NoSQL databases are popular because they offer flexibility and scalability for handling diverse data types and large volumes of data. They are well-suited for modern applications that require real-time data processing and can adapt to changing data structures. Additionally, NoSQL databases often provide horizontal scaling, which is crucial for high-performance applications and can be cost-effective compared to traditional relational databases. Overall, NoSQL's ability to meet the demands of today's dynamic and data-intensive environments makes it a fashionable choice among developers and businesses.
Speeding in Virginia Reckless Driving

Saudi visa application said...

Hello! I'd like to extend my heartfelt appreciation for the invaluable information shared on your blog. Discover the essential steps and documents needed for your Saudi visa application. Ensure a smooth journey to the Kingdom of Saudi Arabia with our concise guide.

Maria3400 said...

Hi! Your blog post was informative and engaging. I appreciate the valuable insights you've shared. Thank you! Applying for a Saudi Arabia tourist visa for Indian citizens is a streamlined process. With the necessary documents prepared, the entire application typically takes less than 20 minutes to complete.

jofra archer said...

Keep illuminating our digital world with your exceptional content, and thank you for your invaluable contributions. India Ganges River Holiest Journey. Embark on a spiritual odyssey along the holiest journey of India, the Ganges River. This sacred river is deeply revered by millions and holds immense cultural significance. From the ghats of Varanasi to the Himalayan source in Gangotri, it's a pilgrimage like no other. Witness ancient rituals, immerse in spirituality, and experience the mystique of the Ganges on this transformative journey.

Edison hope said...

Hello everyone, For UK citizens seeking a hassle-free way to monitor their Indian passport's progress, the "Indian passport tracking UK" service offers transparency and peace of mind throughout the application and renewal process.

jofra archer said...

Your generosity in sharing your knowledge is a gift to those seeking to expand their horizons. How to Apply for Indian e Visa from USA- To apply for an Indian e-Visa from the USA, visit the our Indian e-Visa website and select the "Regular Visa Application '' option. Fill out the online application form with your personal details, passport information, and travel plans. Upload a scanned copy of your passport's bio page and a passport-size photo following the specified guidelines. Pay the applicable visa fee using a credit or debit card. After processing and approval, you will receive the e-Visa via email.

Maria3400 said...

This blog is great! It's easy to understand and has helpful information. Keep up the good work! Book your VFS Riyadh appointment effortlessly for various visa and document services. Secure your appointment and streamline your visa application process today.

2023 Tourist Turkey Stats: Visitor Trends said...

Hi there! I stumbled upon your blog online, and I must say, this article is exceptionally well-crafted. I've saved it for later reading and eagerly anticipate more of your valuable insights. Also Check the 2024 Tourist Turkey Stats: Visitor Trends reveal a significant surge in international arrivals.

Henry Evelyn said...

I cannot overstate how truly outstanding this post is. My heart is brimming with gratitude, and I want to convey my sincere thanks for the exceptional content you've shared. Ethiopia Tourism Recovery. Ethiopia's tourism sector is on a path to recovery after facing challenges due to the global pandemic. The country's rich cultural heritage, stunning landscapes, and historical sites continue to attract travelers.

maryjames said...

Your website is a treasure trove of information. I must say, it's truly remarkable. I eagerly anticipate more posts of this caliber from you. Your website's design is also quite appealing. Kudos for your hard work. Please take a moment to visit the link for the information I'd like to share. Egypt Visa-on-Arrival Suspended. Travelers, please note that Egypt has temporarily suspended the visa-on-arrival service.

Ahsanullah khan said...

Great Job
Mountain Duck Crack
Windows Loader

tech2 said...

Good Morning Wishes
The morning breeze is so gentle and sweet today that it reminds me of you. Good morning! Wishing you a morning as cheerful as your smile.