filmov
tv
How to choose RIGHT DATABASE ? | Type of Database | Code Decode | System Design Interview Question
Показать описание
In this video of code decode we have explained best database to choose from. This is very Important Interview questions with respect to System Design
Udemy Course of Code Decode on Microservice k8s AWS CICD link:
Course Description Video :
Scenarios where we need to choose between NOSQL DB and relational DBs ?
Scenario 1: READ Vs WRITE Intensive Application
When your application is read intensive the use NOSQL db .
If the application is Write Intensive then go for Relational DB.
Why ? If we have to read a lot and update less, then having multiple relational DBs and having join queries to read a lot of data base will decrease the performance. So better go with Non relational DBs. Now everything will be in one document and no joins, views complex queries wool be required which decreases the readability, performance , speed and other non functional parameters of aplication
Scenario 2: Unstructured VS Structured Data
When your application is going to persist the data which is not structured, there is no guarantee on how many fields we will get and we need to store then its unstructured data. Then go for No sql DB choice as there is no restriction on columns or fields in which data has to be inserted .
But If we are very sure the data structure wont change ever in whole life cycle of application then even relational DB is also a good choice
Scenario 3: Concurrency and atomicity is top priority
In applications like hotel / movie ticket booking - Several users simultaneously read and write the data.
To prevent data inconsistency, such as the double booking of hotel rooms, we must coordinate such transactions.
Transactional access to the data in a relational database manages concurrency.
A transaction is regarded as an atomic operation, making it possible to roll back or commit a transaction after a successful execution in error handling.
To facilitate this feature we need Relational Dbs .
Scenario 4: Cost associated
If we are allotted a very less budget for the project, go for open source NO Sql db as many NoSQL databases are open source and freely available..
While with Relational DBs, these are not open source usually n we need to purchase the License for it.
Hibernate Interview Questions and Answers:
Spring Boot Interview Questions and Answers:
Subscriber and Follow Code Decode
#dsa #leetcode #codedecode
Udemy Course of Code Decode on Microservice k8s AWS CICD link:
Course Description Video :
Scenarios where we need to choose between NOSQL DB and relational DBs ?
Scenario 1: READ Vs WRITE Intensive Application
When your application is read intensive the use NOSQL db .
If the application is Write Intensive then go for Relational DB.
Why ? If we have to read a lot and update less, then having multiple relational DBs and having join queries to read a lot of data base will decrease the performance. So better go with Non relational DBs. Now everything will be in one document and no joins, views complex queries wool be required which decreases the readability, performance , speed and other non functional parameters of aplication
Scenario 2: Unstructured VS Structured Data
When your application is going to persist the data which is not structured, there is no guarantee on how many fields we will get and we need to store then its unstructured data. Then go for No sql DB choice as there is no restriction on columns or fields in which data has to be inserted .
But If we are very sure the data structure wont change ever in whole life cycle of application then even relational DB is also a good choice
Scenario 3: Concurrency and atomicity is top priority
In applications like hotel / movie ticket booking - Several users simultaneously read and write the data.
To prevent data inconsistency, such as the double booking of hotel rooms, we must coordinate such transactions.
Transactional access to the data in a relational database manages concurrency.
A transaction is regarded as an atomic operation, making it possible to roll back or commit a transaction after a successful execution in error handling.
To facilitate this feature we need Relational Dbs .
Scenario 4: Cost associated
If we are allotted a very less budget for the project, go for open source NO Sql db as many NoSQL databases are open source and freely available..
While with Relational DBs, these are not open source usually n we need to purchase the License for it.
Hibernate Interview Questions and Answers:
Spring Boot Interview Questions and Answers:
Subscriber and Follow Code Decode
#dsa #leetcode #codedecode
0:06:58
How To Choose The Right Database?
0:23:28
Database Design Tips | Choosing the Best Database in a System Design Interview
0:09:53
7 Database Paradigms
0:23:58
Choosing a Database for Systems Design: All you need to know in one video
0:35:16
Types of Databases | Criteria to choose the best database in the System Design Interview
0:24:38
Which Database Model to Choose?
0:41:03
How to choose the right database for your application - Zoe Steinkamp - NDC Oslo 2023
0:07:46
How to Choose the Right Database for your Application
0:39:46
Anatomy of a DBaaS: Bringing self-serve databases to Kubernetes with open source
0:04:01
SQL vs. NoSQL Explained (in 4 Minutes)
0:05:02
How to choose the right database for application scalability
0:53:17
Choosing The Right Database
0:24:17
How to choose the right database for your workloads
0:09:43
Which Is Better? SQL vs NoSQL
0:24:45
How to choose RIGHT DATABASE ? | Type of Database | Code Decode | System Design Interview Question
0:25:25
Systems Design : Correct Database for an Application | Database to choose while designing a System
0:03:06
Selecting the right database
0:00:51
Choosing the Right Database for System Design
0:05:38
How to Choose Right Database For Your Service ?
0:53:21
How to Choose the right database for your workload (Hebrew)
1:04:05
How to choose right database for a product
0:25:50
AWS Summit ANZ 2022 - Choose the right database for modern applications (DEV3)
0:15:45
How To Choose a Database for your App
0:47:01
How to Choose a Right Database for Your Microservices? - Dr. Vamsi Mohan Vandrangi, Hub Technologies
Комментарии