How will you choose between Relational DB and NoSQL DB during system design?
Some of the main points to consider while choosing between Relational DB and NoSQL DB are as follows:
OLTP vs. OLAP: Relational DBs are a popular choice for implementing online transaction processing (OLTP) systems. Whereas NoSQL DBs are a popular choice for handling online analytical processing (OLAP) use cases.
ACID properties: One primary key reason for selecting Relational DB is the support for ACID properties of database transactions. If our application and business context requires Atomic, Consistent, Isolated and Durable transactions, then we use Relational DB in our system.
Want to learn more, then watch more Playlists:
System Design Interview Questions: • System Design Interview Questions
Software Architect Questions: • Software Architect Interview Questions
Microservices Questions: • Microservices Interview Questions
Devops Interview Questions: • DevOps Interview Questions
Connect with us:
Facebook: / knowledgepowerhouse
Twitter: / knowledgepowe10
Amazon: https://www.amazon.com/Knowledge-Powe...
Site: www.knowledgepowerhouse.com