Certainly, here are 100 terms each for SQL (Structured Query Language) and MongoDB (a NoSQL database). These terms cover a range of concepts, commands, and features associated with both types of databases.
SQL Terms:
- Database: A structured set of data organized for easy retrieval.
- Table: A collection of data stored in rows and columns.
- Column: Represents a single attribute of a record in a table.
- Row: A record in a table containing data values.
- Schema: A blueprint that defines the structure of a database.
- Primary Key: A unique identifier for each record in a table.
- Foreign Key: A field linking to the primary key in another table.
- Index: Improves the speed of data retrieval operations on a database table.
- Query: A request for data or information from a database.
- SQL Statement: A command to perform operations on a database.
- Select: Retrieves data from one or more tables.
- Insert: Adds new records to a table.
- Update: Modifies existing records in a table.
- Delete: Removes records from a table.
- Join: Combines rows from two or more tables based on a related column.
- Inner Join: Retrieves records that have matching values in both tables.
- Outer Join: Retrieves all records when there is a match in one of the tables.
- Left Join: Retrieves all records from the left table and the matched records from the right table.
- Right Join: Retrieves all records from the right table and the matched records from the left table.
- Group By: Groups rows based on the values in specified columns.
- Aggregate Functions: Functions like SUM, AVG, MIN, MAX, COUNT for summarizing data.
- Having: Filters results based on aggregate function conditions.
- Subquery: A query nested within another query.
- Transaction: A sequence of one or more SQL operations treated as a single unit.
- View: A virtual table based on the result of a SELECT query.
- Stored Procedure: A precompiled collection of one or more SQL statements.
- Trigger: A set of instructions that are automatically executed in response to certain events.
- Normalization: Organizing data to reduce redundancy and dependency.
- Denormalization: Intentionally introducing redundancy to improve query performance.
- ACID Properties: Atomicity, Consistency, Isolation, Durability - properties ensuring reliable database transactions.
- Data Definition Language (DDL): Statements for defining and managing database structures.
- Data Manipulation Language (DML): Statements for manipulating data.
- Transaction Isolation Levels: Defines the degree to which one transaction must be isolated from the effects of other concurrent transactions.
- Constraint: Rules to enforce data integrity.
- Unique Constraint: Ensures that a column contains unique values.
- Check Constraint: Ensures that values in a column meet specific conditions.
- Foreign Key Constraint: Enforces referential integrity between tables.
- Indexing: Improves the speed of data retrieval operations.
- Database View: A virtual table based on the result of a SELECT query.
- SQL Injection: A type of attack where malicious SQL statements are inserted into user input.
- Database Index: A data structure to improve the speed of data retrieval operations on a database table.
- Relational Database Management System (RDBMS): A type of DBMS that stores data in tables and enforces relationships between them.
- Non-relational Database: A database that does not use the traditional table-based relational database structure.
- NoSQL: A category of databases that do not strictly adhere to the traditional SQL relational database management system.
- Stored Procedure: A set of SQL statements that can be stored in the database.
- Commit: Permanently saves changes made during a transaction.
- Rollback: Undoes the changes made during a transaction.
- Data Warehouse: A centralized repository for storing large volumes of data from various sources.
- OLAP (Online Analytical Processing): A category of software tools that enable users to interactively analyze multidimensional data.
- OLTP (Online Transaction Processing): A category of software tools that support transaction-oriented applications.
MongoDB Terms:
- Document: A JSON-like data structure used in MongoDB.
- Collection: A group of MongoDB documents.
- Database: A container for collections in MongoDB.
- Field: A key-value pair in a MongoDB document.
- Document ID: A unique identifier for each document in a collection.
- Embedded Document: A document nested within another document.
- Index: Improves the speed of data retrieval operations in MongoDB.
- Query: A request for data or information from a MongoDB database.
- Insert: Adds new documents to a MongoDB collection.
- Update: Modifies existing documents in a MongoDB collection.
- Delete: Removes documents from a MongoDB collection.
- Projection: Limits the fields returned in the result set.
- Cursor: A pointer to the result set of a query.
- Aggregation Pipeline: A framework for performing data transformations in MongoDB.
- Aggregation Stage: An operation in the aggregation pipeline.
- $match: Filters documents in the aggregation pipeline.
- $group: Groups documents by a specified expression.
- $sort: Orders documents in the aggregation pipeline.
- $limit: Limits the number of documents passed to the next stage.
- $skip: Skips a specified number of documents.
- $lookup: Performs a left outer join to another collection.
- $unwind: Deconstructs an array field from the input documents.
- Sharding: Distributing data across multiple machines.
- Replica Set: A group of MongoDB servers that maintain the same data.
- Journaling: A feature that ensures data consistency in case of a failure.
- Mongo Shell: A command-line interface for interacting with MongoDB.
- GridFS: A specification for storing large files in MongoDB.
- Text Index: Enables text search on string content.
Geospatial Index: Enables efficient querying of geospatial data.
TTL Index: Deletes documents from a collection after a specified amount of time.
Connection Pooling: Managing a pool of database connections to reduce connection overhead.
Write Concern: Specifies the level of acknowledgment requested from MongoDB for write operations.
Read Concern: Specifies the consistency guarantee for read operations.
Read Preference: Specifies from which members of a replica set to read.
Aggregation Framework: A data processing pipeline used for transforming and filtering documents.
Document Validation: Enforces data integrity by validating documents.
Database User: A user account with specific privileges in a MongoDB database.
Role: Defines a set of permissions for database operations.
Connection String: A string that specifies how to connect to a MongoDB database.
Change Streams: Provides a way to listen for changes in a MongoDB collection.
Document Versioning: Managing different versions of a document.
MongoDB Atlas: A cloud-based database service for MongoDB.
MongoDB Compass: An official graphical user interface for MongoDB.
MongoDB Stitch: A serverless platform for building applications with MongoDB.
Read-Write Concern: Specifies the acknowledgment level for both read and write operations.
MongoDB Capped Collections: Fixed-size collections that automatically overwrite old data.
MongoDB Enterprise: The commercial version of MongoDB with additional features.
Map-Reduce: A method for processing and reducing large datasets in MongoDB.
Transaction: A set of one or more operations that must be performed as a single, indivisible unit.
MongoDB Community: The free, open-source version of MongoDB.
ObjectId: A 12-byte identifier typically employed as the document ID in MongoDB.
Replica Set Arbiter: A member in a MongoDB replica set that helps in achieving consensus.
Document Locking: The mechanism that MongoDB uses to prevent multiple clients from modifying the same document simultaneously.
Data Migration: The process of transferring data from one database to another.
Data Modeling: The process of defining the structure and organization of data in a database.
Shard Key: The field used to determine how data is distributed across shards in a sharded MongoDB cluster.
MongoDB Driver: A client library or software component that facilitates communication between an application and a MongoDB database.
MongoDB Realm: A serverless application development platform for MongoDB.
MongoDB Inc.: The company that develops and maintains MongoDB.
MongoDB GUI: Graphical User Interface tools designed to interact with MongoDB databases.
These terms cover a wide range of concepts and features for both SQL and MongoDB databases, offering insights into the unique aspects of each type of database system.
Top comments (0)