Description:
Column-store database
|
|
Type: Formula
|
Latest Version: 11.55.1@0
|
Tracked Since: Dec 16, 2025
|
|
Links:
Homepage |
@MonetDB |
formulae.brew.sh
|
|
Category: Databases
|
|
Tags:
database
column-store
analytics
sql
data-warehouse
|
|
Install:
brew install monetdb
|
About:
MonetDB is an open-source column-store database management system designed for high-performance analytical queries. It excels at handling large datasets and complex analytical workloads by storing data in columns rather than rows. This architecture enables efficient data compression and rapid aggregation, making it ideal for business intelligence and data science applications.
|
Key Features:
- Columnar storage architecture
- Automatic indexing and self-optimizing
- High-performance analytical queries
- Support for SQL and Python/R integration
- ACID compliance with MVCC
|
Use Cases:
- Business intelligence and data warehousing
- Scientific data analysis and research
- Big data analytics and reporting
- Data science and machine learning pipelines
|
Alternatives:
-
PostgreSQL
– Row-oriented vs column-oriented storage; MonetDB better for analytics, PostgreSQL better for transactional workloads
-
ClickHouse
– Both columnar, but ClickHouse focuses on real-time analytics while MonetDB emphasizes self-optimization and ease of use
-
Apache Druid
– Druid is designed for real-time ingestion, MonetDB excels at batch analytical processing
|
| Detected |
Version |
Rev |
Change |
Commit |
| Dec 16, 2025 11:02am |
|
0 |
VERSION_BUMP |
91b599f1 |
| Nov 10, 2025 9:56am |
|
0 |
VERSION_BUMP |
fa1ecd31 |
| Nov 10, 2025 9:39am |
|
0 |
VERSION_BUMP |
6e33a120 |
| Sep 15, 2025 11:51pm |
|
0 |
VERSION_BUMP |
a8ca7177 |
| Sep 14, 2024 4:40am |
|
0 |
VERSION_BUMP |
f35b72fb |
| Aug 26, 2024 2:01pm |
|
0 |
VERSION_BUMP |
3fe298fb |
| Aug 26, 2024 12:42pm |
|
0 |
VERSION_BUMP |
41d6e396 |
| Oct 3, 2023 4:37pm |
|
0 |
VERSION_BUMP |
784087c4 |
| Sep 30, 2023 12:50am |
|
0 |
VERSION_BUMP |
cfd2717d |
| Jan 31, 2023 3:06pm |
|
0 |
VERSION_BUMP |
957cf41d |
| Jan 31, 2023 3:06pm |
|
0 |
VERSION_BUMP |
c50c78c8 |
| Dec 26, 2022 1:05pm |
|
0 |
VERSION_BUMP |
95ae5282 |
| Dec 9, 2022 2:04pm |
|
0 |
VERSION_BUMP |
4a2b131e |
| Dec 9, 2022 2:04pm |
|
0 |
VERSION_BUMP |
259fdcfb |
|