Skip to main content

Posts

Showing posts with the label Key-value pair

Difference between SQL and NoSQL database

Key Difference SQL NoSQL Known As SQL Based database Management System is majorly known as RDBMS or DBMS Systems Whereas NoSQL database are primarily non-relational database or distributed database Architecture SQL Database mainly   architecture surrounded to the Tables       In Case of NoSQL database there are major four categorization Document base   Key-value pair base     Graph database   Wide-column Store Schema SQL database has its own predefine schema to store structure data In NoSQL database, there is no predefine schema, here schema is most dynamic element based on the data elements Scalability SQL Databases are vertically scalable, means if we want to scale SQL base database, we need to give hardware boost on which the DBMS System is installed. This is where it sometimes goes for the limitation of scalability...