OLTP

IBM Db2

IBM Db2 is a family of relational database management systems from IBM, historically rooted in mainframe computing, that supports transactional and analytical…

SAP HANA

SAP HANA is an in-memory, column-oriented relational database platform developed by SAP that combines transactional and analytical processing to power SAP's en…

Google Bigtable

Google Bigtable is a fully managed, wide-column NoSQL database service designed for very large analytical and operational workloads, built on the same underlyi…

ACID Properties

ACID is an acronym describing four guarantees — Atomicity, Consistency, Isolation, and Durability — that traditional relational database transactions provide t…

CAP Theorem

The CAP theorem states that a distributed data system can provide at most two of three guarantees simultaneously during a network partition: Consistency, Avail…

OLTP

OLTP (Online Transaction Processing) refers to database systems and workloads optimized for large numbers of short, concurrent read/write transactions, such as…

OLAP

OLAP (Online Analytical Processing) refers to database systems and workloads optimized for complex, read-heavy analytical queries — aggregations, trends, and m…

ETL

ETL (Extract, Transform, Load) is a data integration process that pulls data from source systems, transforms it into a clean, structured format outside the tar…

LSM Tree

A Log-Structured Merge-tree (LSM tree) is a write-optimized data structure that batches writes in memory and flushes them sequentially to disk as immutable sor…

OLTP (Online Transaction Processing)

OLTP (Online Transaction Processing) refers to database systems and workloads optimized for fast, high-volume execution of short, discrete transactions — typic…

OLAP (Online Analytical Processing)

OLAP (Online Analytical Processing) refers to database systems and workloads optimized for complex analytical queries — aggregations, multidimensional analysis…

Slowly Changing Dimension

A Slowly Changing Dimension (SCD) is a data warehousing technique for tracking and managing changes to dimension table attributes over time — such as a custome…

Database Sharding Key

A database sharding key (or partition key) is the attribute, or combination of attributes, used to determine which shard (physical partition) of a distributed…

Row-Level Security

Row-Level Security (RLS) is a database access-control mechanism that restricts which rows of a table a given user or query is allowed to see or modify, enforci…

OLAP vs OLTP: What is the Difference?

OLTP (Online Transaction Processing) is optimized for many short, concurrent read/write transactions on individual rows, while OLAP (Online Analytical Processi…

Columnar vs Row Storage: Which Should You Choose?

Row storage keeps all fields of one record physically together on disk, making it fast to read or write a whole record at once, while columnar storage groups t…