Differences of SQL Vs No SQL ( RDBMS Vs No SQL )
RDBMS(Relational database management system) is also called as SQL engine is the basic traditional system which is used for Application development.Data is stored in form of rows and columns in a table .
RDBMS include Oracle , mysql , postgres
No sql engine is used to deal with both structured and unstructured data . This kind of system is used for application development ( Application development ) where the developer has no view of how the application is received by the users across the world where we cannot predict the traffic across the network which will help in scalable as per the need .
NoSql Engines include Hbase , BigTable , Couch DB
Below are the comparisons :
Parameter
RDBMS
No SQL
Cost
Freeware
Free ware
Parallelism
No Enabled
Enabled
IO Read and Writes
More
Less
Scalability
Vertical Scalable
Hortizontal scalable
Maintanance
More
less
Schema Driven
Yes
No Schema
Join Mechanism ( Normalisation)
Normalised
Denormalised
Ease of Use & UI
Easy
Hard , No UI
Type of processing
Table
Key Value Pai
RDBMS(Relational database management system) is also called as SQL engine is the basic traditional system which is used for Application development.Data is stored in form of rows and columns in a table .
RDBMS include Oracle , mysql , postgres
No sql engine is used to deal with both structured and unstructured data . This kind of system is used for application development ( Application development ) where the developer has no view of how the application is received by the users across the world where we cannot predict the traffic across the network which will help in scalable as per the need .
NoSql Engines include Hbase , BigTable , Couch DB
Below are the comparisons :
Parameter
RDBMS
No SQL
Cost
Freeware
Free ware
Parallelism
No Enabled
Enabled
IO Read and Writes
More
Less
Scalability
Vertical Scalable
Hortizontal scalable
Maintanance
More
less
Schema Driven
Yes
No Schema
Join Mechanism ( Normalisation)
Normalised
Denormalised
Ease of Use & UI
Easy
Hard , No UI
Type of processing
Table
Key Value Pai
0 Comments