SQL vs No SQL

-

SQL or Structured Query Language is pronounced  “see-quel” is a standard language to access and query Relational Databases.

It enables users with queries such INSERT, DELETE, UPDATE, SEARCH, ALTER, and to do a lot more with the Database. It is a very powerful language and is preferred by lots of developers as it can handle very complex queries as well.

Most Popular databases which uses SQL are :
  1. Oracle
  2. MySQL
  3. SQLite
  4. PostgreSQL
  5. MS-SQL


NoSQL is a non-relational database and is unstructured. Due to its unstructured nature, it is sometimes called as UnQL

It mainly consists of key-value pairs, graphs, documents, etc. It is especially used to store large sets of distributed data.

Most popular NoSQL databases are :

  1. MongoDB
  2. Cassandra
  3. Bigtable
Most commonly method used to store the in
formation is in json format , although there are other methods used as well such as graphs etc .

It can store all sorts of data models with large distributed data in the form of key-value pairs, graph databases, documents etc .






Comments

Post a Comment

Please comment

Popular posts from this blog

Israel - Hamas Conflict in 2023

-
Image
An ongoing armed conflict between Palestinian militant groups led by Hamas and Israel began on 7 October 2023, with a coordinated surprise offensive on Israel. The attack began in the morning with a barrage of at least 3,000 rockets launched from the Hamas-controlled Gaza Strip against Israel. When did the first Israel - Palestine war start? The Arab-Israeli War of 1948 broke out when five Arab nations invaded territory in the former Palestinian mandate immediately following the announcement of the independence of the state of Israel on May 14, 1948. What is the story between Israel and Palestine? The conflict at its core is about the self-determination of two peoples living in the same place: Jews and Palestinians both want to control their own futures and both seek the ability to live in peace, freedom, and security. Why is Israel at war with Palestine 2023? There were increases in settler attacks that displaced hundreds of Palestinians; and there were violent clashes around the Al-A...
Read more

ICC 2023 World Cup India Schedule

-
Image
  Group Stage Matches of Indian Team Team India Squad Rohit Sharma (c)                                                                                  Hardik Pandya (vc)                                                  Shubman Gill Virat Kohli Shreyas Iyer KL Rahul Ravindra Jadeja                                                                                    Ravichandran Ashwin Shardul Thakur Jasprit Bumrah Mohammed Siraj Kuldeep Yadav Mohammed Sh...
Read more