Difference between SQL and NoSQL

Difference between SQL and NoSQL

- NoSQL databases, or non-relational databases, can be document based, graph databases, key-value pairs, or wide-column stores. SQL databases are known as relational databases, and have a table-based data structure, with a strict, predefined schema required.

- NoSQL (“non SQL” or “not only SQL”) databases were developed in the late 2000s with a focus on scaling, fast queries, allowing for frequent application changes, and making programming simpler for developers. Relational databases accessed with SQL (Structured Query Language) were developed in the 1970s with a focus on reducing data duplication as storage was much more costly than developer time. SQL databases tend to have rigid, complex, tabular schemas and typically require expensive vertical scaling.

286 views0 comments

Recent Posts

See All

Sort ArrayList We have a sort() method in the Collections class. This class is is a part of java.util package. This method can be used to sort an ArrayList. In the following example we have sorted a l

The Java Collections Framework is a collection of Interfaces and Classes which helps in storing and processing that data efficiently This framework has several useful classes which have tons of usefu