Articles → MONGODB → SQL Vs Nosql Terminologies

SQL Vs Nosql Terminologies

This article explains the difference between SQL and NoSQL (MongoDB) terminology.

Database

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

In NoSQL, the database is a distributed or non-relational data store that stores 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 associated data types.

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

Rows And Document

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

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

Column And Key-Value Pair

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

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, including 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 uniquely identifies each row in a table and is used for indexing and ensuring data integrity.

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

Foreign Keys

In SQL, a foreign key is used to establish a relationship between two tables.

In NoSQL, you can establish a relationship using either 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	**