When your database grows into millions of records spread over many tables and business intelligence/ science becomes the prevalent application domain, a column-store database management system is called for. Unlike traditional row-stores, such as MySQL and PostgreSQL, a column-store provides a modern and scalable solution without calling for substantial hardware investments.
MonetDB makes a difference, with pioneering column-store data base systems, enabling high-performance data warehouses in business intelligence and machine learning since 1993. It achieves it's goal by innovating across all layers of a DBMS, e.g. a storage model based on vertical fragmentation; a modern CPU-tuned query execution architecture; automatic and adaptive indices; run-time query optimization, and modular software architecture. It is based on the SQL 2003 standard with full support for foreign keys, joins, views, triggers and stored procedures. It is fully ACID compliant and supports a rich spectrum of programming interfaces (JDBC, ODBC, PHP, Python, RoR, C/C++, Perl).