Articles → MONGODB → SQL Vs Nosql Terminologies

SQL Vs Nosql Terminologies

In this article, we will discuss the difference between SQL and NoSQL (MongoDB) terminology.

Database

In SQL, the database is the structured collection of data organized into tables with a predefined schema.

In NoSQL, the database is the distributed or non-relational data store that stores the data in various formats (documents, key-value pairs, graphs, etc.).

Table And Collection

In SQL, a table is a collection of rows (records) with predefined columns (fields) and data types.

In NoSQL, a collection is a container for storing documents or records.

Rows And Document

In SQL, a single record within a table, consisting of values corresponding to each column.

In NoSQL, a document is a unit of data, often stored in formats like JSON or BSON (binary JSON).

Column And Key-Value Pair

In SQL, a column is a field within a table that holds a specific type of data.

In NoSQL, a key-value pair is the basic data model where each item is stored as a key and its associated value, often used in simple key-value stores.

Schema

In SQL, a schema is the blueprint that defines the structure of tables, their columns, data types, constraints, and relationships.

In NoSQL, no fixed schema is enforced allowing flexibility in the structure of stored data.

Primary Key

In SQL, a primary key is a unique identifier for each row in a table, used for indexing and ensuring data integrity.

In NoSQL, each document is identified as an Object ID (often represented by the field _id).

Foreign Keys

In SQL, a foreign key is used to establish a relation between 2 tables.

In NoSQL, you can establish a relationship as an embedded document or a referenced document.

Posted By -	Karan Gupta

Posted On -	Tuesday, August 29, 2023

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**