Sign inSign in
ConceptSystems & CS

ETL

The process of extracting data from operational sources, transforming it to a standard format, and loading it into a data warehouse.
as Andy Pavlo defines itCarnegie Mellon UniversityThe wording closest to all 3 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.

Data warehouse1Data warehousing1OLAP1OLTP1OLTP databases1

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

    Extract, transform, and load process used to move and clean data from OLTP to OLAP databases.
    • 6:01Distributed Data Warehouse OLAP Databases
  • Ippokratis Pandis

    Carnegie Mellon University · Research

    The process of extracting data from various sources, transforming it into a suitable format, and loading it into a destination system for analysis.
    • 4:18Lakebases & LTAP: Unifying Transactions and Analytics on Open Object Storage

Lectures that assume it

1

Connections

9

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.