Sign inSign in
ConceptSystems & CS

OLTP

A database workload characterized by finding individual tuples using indexes and supporting frequent updates.
as Andy Pavlo defines itCarnegie Mellon UniversityThe wording closest to all 4 definitions
Watch it explained

Know first

Named as a prerequisite by the lectures that define this. The number is how many say so. A grey one has no page yet.

Opens up

Concepts that name this one as a prerequisite.

Lecturers

2

Each in their own terms, from the easiest level.

  • Andy Pavlo

    Carnegie Mellon University · Undergraduate

    Simple queries that read or update a small amount of data related to a single entity in the database.
    • 10:00OLTP vs. OLAP Storage Models & Database Compression
    • 5:01Distributed Transaction Processing Databases
  • Sai Srirampur

    Carnegie Mellon University · Graduate

    Transactional database systems designed to support fast CRUD operations, transactions, and ACID compliance.
    • 3:42Unifying Postgres and ClickHouse Natively: WalShadow and pg_clickhouse

Lectures that assume it

3

Connections

15

The lectures that define it or assume it, and the concepts next to it.

2 lecturers. Definitions are written by AI from each lecture’s transcript. A time with a play mark starts the lecture at the moment the lecturer says it.