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

Comments

Popular posts from this blog

Lancement de ProductTank Lyon

Mise à jour 05/05/2023 : Le COVID aura tué ma motivation d’essayer de relancer ce meetup. Peut-être que d’autres le feront.  ---- Tout d’abord, bonne année 2020. Je me suis investi ces dernières années dans les communautés/événements CARA Lyon, MiXiTConf, LyonDataScience et CaféDevOps sur Lyon, France. Ces activités m’ont permis de comprendre les experts de ces domaines, d’apprendre quelques notions fondamentales à travers leurs exposés et d’améliorer mes capacités d’échange avec eux. Product Manager depuis plus de 5 ans, je désire améliorer mes réflexes et compétences dans mon domaine. Le faire à travers des rencontres/meetup est ce que je préfère et j’aimerais retrouver la stimulation des communautés dans cette discipline. En cette année 2020, quelques Product Manager lyonnais, lançons, le meetup ProductTankLyon à Lyon, France. Le réseau ProductTank compte plus de 150 meetups dans le monde et profite des conférences, blog et podcast MindTheProduct. Ins...

20 Years of Product Management in 25 Minutes

Mind the Product has been doing an awesome job these years. Follow them, watch their contents, the best Product Management ideas are there. Each time someone new in our PM field ask me about where to start, I have too many things in my mind to propose a simple answer. Each time, I tell me, if I tell them the truth, they may say: this is a too difficult position. So, the best way, may be to show them a funny video with the PM core principles: 20 Years of Product Management in 25 Minutes by Dave Wascha. Enjoy Thanks Dave, Thanks Mind the Product.

Music: From Monoculture to Silots

  I recently watched a video titled " What’s a Monoculture? How Artists Are Bigger and Smaller Than Ever " on YouTube, which got me thinking about the shift from music monoculture to silos. This change has significantly impacted how we consume and experience music today. Monoculture and Silos: - Monoculture: This refers to a shared cultural experience where a few artists or pieces of content dominate the global scene. This was more prevalent during the MTV era when music videos and a few popular artists shaped the music landscape. - Silos: In contrast, silos represent the fragmented nature of modern media consumption. Different groups of people are exposed to different content based on their preferences, leading to a more personalized but less universally shared experience.   How Did This Happen? Here is a timeline of the last 70 years of modern music to illustrate this shift: Pre-MTV Era (1950s-1980s): - Music was primarily consumed through radio, records, and live...