Completed
Gabor demonstrates the pivot operation in DuckDB, which turns a long table into a wide table in just 28 milliseconds.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Introduction to DuckDB: An In-Process Analytical Database Management System
Automatically move to the next video in the Classroom when playback concludes
- 1 Overview of DuckDB: The motivation behind DuckDB's creation is the increasing power of end-user devices, such as laptops, which can now handle complex data processing tasks. Traditional database sys…
- 2 Gabor discusses DuckDB, a unique database system that targets analytical workloads and is designed for fast installation and deployment. DuckDB was inspired by popular databases like MySQL but diffe…
- 3 Gabor demonstrates the ease of importing and querying large CSV files. He also shows how to use DuckDB's "describe" command to confirm that the database correctly assumed the schema. DuckDB quickly …
- 4 Gabor demonstrates the pivot operation in DuckDB, which turns a long table into a wide table in just 28 milliseconds.
- 5 Gabor discusses the efficiency and fast processing of DuckDB. DuckDB is cache and pipelining friendly, allowing for skipping most random accesses, resulting in fast processing.
- 6 Gabor discusses the benefits and limitations of the database system. DuckDB is an easy-to-install system that is open standard compliant and does not require configuration or a DBA for maintenance. …
