a column store database built for analytics, where queries read only the columns they name
This product is available in the build below. Open it for the operating system, cloud and version detail, or read its deployment guide.
| Product | Cloud | Operating system | Version | |
|---|---|---|---|---|
| MonetDB on Ubuntu 24.04 LTS | Azure | Ubuntu 24.04 | Standard | View · Guide |
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.
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.