Databases

Extract, Transform, Load: a data integration process that extracts data from source systems, transforms it into a suitable format (cleaning, aggregating, enriching), and loads it into a target databas...

A column or set of columns in a relational database table that establishes a link between data in two tables. Foreign keys enforce referential integrity by ensuring that a value in one table matches a...

A database that uses graph structures with nodes, edges, and properties to represent and store data. Graph databases excel at querying highly connected data such as social networks, recommendation eng...

An open-source time-series database designed for high-write and high-read throughput of timestamped data. InfluxDB is widely used for infrastructure monitoring, IoT sensor data, and real-time analytic...

An open-source relational database management system created as a community-developed fork of MySQL. MariaDB maintains compatibility with MySQL while adding new storage engines, security features, and...

A database object that stores the precomputed results of a query physically on disk, unlike a regular view which re-executes the query each time. Materialized views improve performance for complex agg...

A high-performance, distributed in-memory caching system designed to speed up dynamic web applications by reducing database load. Memcached stores key-value pairs in RAM and is used by major platforms...

A popular open-source NoSQL document database that stores data in flexible, JSON-like BSON documents. MongoDB is designed for scalability and developer productivity, supporting horizontal scaling thro...

An open-source relational database management system that uses SQL for data manipulation. MySQL is one of the most widely deployed databases in the world, known for its reliability, ease of use, and s...

The most popular open-source graph database that stores data as nodes and relationships rather than tables or documents. Neo4j uses the Cypher query language and excels at traversing connected data fo...

A broad category of database management systems that diverge from the traditional relational model. NoSQL databases include document stores (MongoDB), key-value stores (Redis), column-family stores (C...

A powerful, open-source object-relational database system with over 35 years of active development. PostgreSQL is known for its robustness, extensibility, ACID compliance, and support for advanced dat...

A column or set of columns in a database table that uniquely identifies each row. Primary keys enforce entity integrity by ensuring that no two rows have the same key value and that the key value is n...

A database engine component that analyzes SQL queries and determines the most efficient execution plan. The query optimizer evaluates factors like available indexes, table statistics, and join strateg...

An open-source, in-memory data structure store used as a database, cache, message broker, and streaming engine. Redis supports data structures such as strings, hashes, lists, sets, and sorted sets wit...

Structured Query Language: a standard programming language for managing and manipulating relational databases. SQL enables querying, inserting, updating, and deleting data, as well as creating and mod...

A self-contained, serverless, file-based relational database engine. SQLite requires no configuration or server process and stores the entire database in a single file, making it ideal for embedded sy...

A precompiled set of SQL statements stored in the database that can be executed as a single unit. Stored procedures improve performance through precompilation, enhance security by controlling data acc...

A database optimized for storing and querying time-stamped data points, such as metrics, events, and measurements. Time-series databases like InfluxDB and TimescaleDB provide efficient compression, fa...