MonetDB on Ubuntu
From Installation to Full Power
This book is a practical guide to installing and working with MonetDB, a high-performance open-source column-store database designed for analytical workloads.
The book focuses on running MonetDB on Ubuntu Linux, covering installation, configuration, database management, and practical SQL usage. All examples are designed to be reproducible on a standard Ubuntu system.
Every section in this book is paired with a YouTube video that walks through the same material in a practical demonstration. Readers are encouraged to watch the video first and then follow the written explanation in the book.
youtube playlist
In addition to YouTube, all videos are also available on Odysee for those who prefer an alternative platform. Odysee provides the same content, with the added benefit that videos can be downloaded for offline viewing. This can be especially useful if you want to study without an internet connection or keep a local copy of the material for future reference.
odysee playlist
Topics covered include:
- Installing MonetDB on Ubuntu
- MonetDB server and database management
- Using the MonetDB command-line tools
- SQL queries for analytical workloads
- Understanding MonetDB's columnar architecture
- Loading and querying datasets
- Working with MonetDB clients
- Basic benchmarking and performance exploration
The goal of this book is to provide a clear, practical introduction to MonetDB while also helping readers understand how the system works internally.
The book is intended for:
- developers
- data engineers
- database administrators
- analysts interested in analytical databases
No prior experience with MonetDB is required, although basic familiarity with SQL and Linux is helpful.
The examples and explanations focus on practical usage rather than theory, making the book suitable for both learning and experimentation.
