Articles → MONGODB → SQL Vs Nosql TerminologiesSQL Vs Nosql TerminologiesIn 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
Query/Feedback