Mo

MonetDB on Ubuntu 24.04 LTS

Azure Databases

a column store database built for analytics, where queries read only the columns they name

Base
Hardened build
minimal ports, security patches applied at build time
Access
Unique credentials
generated on first boot, readable only by root
Verified
Boots working
services pass a health gate before release
Support
24/7, 365 days
by email and live chat, 24 hour response SLA

Overview

MonetDB is an open source relational database that stores each column separately instead of each row. A query that mentions two columns touches only those two, so aggregations, grouping and window functions over large tables run far faster than on a row store using the same hardware. It speaks standard SQL and ships with an interactive terminal, a dump utility and client libraries for Python, Java, R, PHP, Ruby, ODBC and JDBC.

Why the cloudimg image

MonetDB documents that every newly created database gets a well known default login, and the cloudimg image never creates it: no database exists in the image at all, and a password unique to your instance is set at the moment the database is created on first boot, into a root only file. MonetDB implements no encryption of its own, so the image terminates TLS in front of it with a certificate minted for your instance, keeps the database itself on the loopback interface, and leaves the administrative control channel disabled. Paired deployment guide and 24/7 cloudimg support.

Common uses

  • Interactive analytics and reporting over large tables
  • A fast SQL warehouse for dashboards and business intelligence
  • Ad hoc data science and exploratory queries on columnar data