Skip to main content

CAP ACID noSQL


Probably due to the predominant position of a few actors (Google, Amazon, Facebook, etc.), I often feel that all I used to learn about small size systems will soon be obsolete.

The current fashionable IT word is noSQL. If you don't have a minimum of IT culture and only read the buzzy articles you could think the SQL thing is dead.
After a short analysis, I collected a few answers and mainly understood, both old and new technologies will have a long life, but their opposition really makes us step back and reconsider.

First, there is ACID for atomicity, consistency, isolation and durability, the properties implemented by the Database management system (DBMS) to make sure the transactions proceed reliably.

Most of the time we use databases of this type in our indoor computing system. But when it comes to distributed ones (many nodes) you've got to understand that a choice has to be made. In 2000, Eric Brewer made a keynote speech at the ACM Symposium on the Principles of Distributed Computing (PODC) about key principles in the name of CAP:
  • Consistency (all nodes see the same data at the same time)
  • Availability (node failures do not prevent survivors from continuing to operate)
  • Partition Tolerance (the system continues to operate despite arbitrary message loss)
I'm not going to explain what others have done greatly before so read
Sources:
Wikipedia : ACID
Wikipedia : Database management system
Nahurst : Visual Guide to NoSQL Systems
Kennygorman : Dropping ACID
Julianbrowne : Brewer's CAP Theorem
Highscalability : Drop ACID and Think About Data
Blip : Drop ACID and think about data
Labels:

Comments

Post a Comment

Popular posts from this blog

Learning about Data Science?

This is the end of a beautiful summer, and also one of the warmer recorded in France. I’m continuing my journey in the product management world and today I’m living in the product marketing one too. I will blog about this later. During this first half of this year, I read several articles on big data and started to understand how important the data science discipline is. Being able to define a direction/goal to search, collecting the proper data, then using a collection of techniques to extract something others can’t see - it sounds like magic. Also, when I listened to the Udacity Linear Disgression podcast episode “Hunting the Higgs”, I understood people with these skills can be better at solving a problem than the domain experts themselves. Katie Malone explained that in a competition to solve a particle physics problem, the best results came from machine learning people. Then I read the article about Zenefit on the vision mobile website : “Zenefits is an insurance compan...
5 comments
Read more

What I’m learning about AI agents

My learning journey in the world of AI, updated for 2026 Originally published in March 2025. Updated in August 2026. I started this list because I kept seeing the same terms used in different ways. I needed a simple map to understand what each technology actually does, and where it may be useful when bringing AI into a product. AI changes so quickly that a learning journey can become dated in a few months. My first version of this article was an attempt to map the technologies around AI agents and to make sense of the growing number of tools. Since then, the topic has moved from interesting experiments to real business systems. This updated version keeps the original intention: learn in public, organise the landscape, and focus on what is useful in practice. What changed since 2025 In early 2025, most conversations were still about chatbots, prompt engineering and early agent frameworks. In 2026, the more useful question is no longer "which model is the best?" but ...
Post a Comment
Read more

Embracing Bluesky: A search for authentic dialogue beyond professional networks

LinkedIn is great for professional networking, but where can you have conversations with different people on a wider range of topics? I joined Twitter in 2008, later than many of my peers. Initially, it served as a platform for personal intellectual growth, offering pleasant exchanges focused primarily on computer science, human organisation, design and product management. But the growing awareness of climate issues changed everything. Anger became the dominant tone, and I found myself missing a more constructive environment. I don't want to spend my days in a world full of anger. In search of a new wave of self-improvement and more balanced discussions, I've made the move to: https://bsky.app/profile/lookingforanswers.me  I look forward to connecting with you there for more diverse and enriching conversations.
Post a Comment
Read more