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.
Although the book contains 205 pages, it is designed in a large 30 × 50 cm format, allowing each page to deliver far more content than a standard-sized book. This means you are getting a significantly greater amount of material—comparable to several hundred pages in a traditional format—packed with practical examples, detailed explanations, and hands-on guidance. The large format makes it easier to follow complex topics, ensuring a clearer and more immersive learning experience while maximizing the value of every page.
Every section in this book is paired with a YouTube video that walks through the same material in a practical, hands-on demonstration. Altogether, the video content spans approximately 18 hours, giving you a complete learning experience that goes far beyond a traditional book. You are not just reading—you are watching, following, and applying the concepts step by step. For best results, start with the video to see the workflow in action, and then use the book as a structured guide to reinforce and deepen your understanding.
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
For subtitles and additional material please visit this GitHub page:
github
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.
MonetDB on Ubuntu
Publication date : March 17, 2026
Edition : 1st
Format : PDF
Language : English
Print length : 205 pages
ISBN : 978-86-908978-0-3
Dimensions : 30 x 50 cm
Table of Contents
0000 MonetDB Introduction.......................................6
0005 MonetDB Benchmark..........................................9
0010 Install MonetDB Server on Ubuntu Linux....................13
0020 SystemD, Monetdbd, Mserver5: Clarification ...............17
0030 Systemd Unit File, MonetDB Sample Database ...............20
0040 Connect to MonetDB from Python............................24
0050 MonetDB – Identifiers and Constants.......................26
0060 MonetDB – Data Types .....................................28
0070 Working With Temporal Data Types in MonetDB ..............30
0080 MonetDB – Serial Data Type and Sequences .................33
0090 JSON and UUID Data Type in MonetDB .......................36
0100 MonetDB – URL and Network Data Types .....................38
0110 CREATE TABLE in MonetDB ..................................41
0120 SELECT Statement in MonetDB...............................43
0130 MonetDB – SQL Joins ......................................46
0140 MonetDB – SET operators...................................49
0150 Having, Insert, Update, Delete and Built-in Variables.....52
0160 Subqueries in MonetDB.....................................55
0170 Sampling, Analyze, Prepare in MonetDB ....................58
0180 SQL Merge in MonetDB......................................60
0190 Common Table Expressions (CTE) in MonetDB ................62
0200 MonetDB: Window Functions Theory .........................64
0210 Aggregate Functions and Logical Functions.................67
0220 Window Functions Syntax ..................................70
0230 Aggregate Window Functions................................73
0240 Ranking Window Functions in MonetDB ......................75
0250 Offset Window Functions in MonetDB .......................78
0260 Mathematical Functions in MonetDB ........................81
0270 String Functions in MonetDB...............................84
0280 Comparison Functions in MonetDB ..........................88
0290 Transactions in MonetDB ..................................90
0300 Indexes and Views in MonetDB..............................94
0310 Schemas in MonetDB........................................97
0320 Constraints and Altering of Tables in MonetDB............100
0330 Loading Data Using SQL in MonetDB and Timing ............104
0340 Loading from CSV files into MonetDB .....................107
0350 Exporting Data and Binary Files in MonetDB ..............110
0360 Loader Functions in MonetDB .............................112
0370 Temporary Tables in MonetDB..............................114
0380 Merge Tables in MonetDB..................................117
0390 Unlogged tables in MonetDB...............................121
0400 Custom Functions in MonetDB part 1.......................123
0410 Custom Functions in MonetDB part 2.......................126
0420 Custom Functions in MonetDB part 3.......................129
0430 Python UDFs in MonetDB...................................132
0440 Procedures in MonetDB....................................135
0450 Triggers in MonetDB......................................138
0460 Users and Privileges in MonetDB part1....................142
0470 Users and Privileges in MonetDB part2....................146
0480 Distributed Queries in MonetDB ..........................150
0490 Grouping Sets and Comments in MonetDB....................154
0500 Proto_loaders, ODBC and COPY in MonetDB .................158
0510 JDBC, Recursive CTEs, New Functions in MonetDB...........163
0520 CHECK, RETURNING and Other in MonetDB ...................167
0530 Self Signed TLS with Stunnel for MonetDB ................170
0540 Backing up the MonetDB Database..........................175
0550 File and Hot Backup in MonetDB...........................179
0560 Monetdbd for Monetdb.....................................181
0570 Monetdb – Database Administration Tool...................185
0580 Mclient for MonetDB .....................................190
0590 System, Session Procedures and Queries Que ..............195
0600 Running MonetDB in Docker Container......................199
Videos
Number of videos : the same as sections in the book
Total duration : 18 hours
Video resolution : 1080p
Platforms : YouTube, Odysee
Subtitles : Available on YouTube and via GitHub
Downloads : Videos available for download on Odysee
