MonetDB

MonetDB is an open-source relational database system that stores data by column, which suits analysis of large datasets. It offers a standard SQL interface and can handle both pure analytics and mixed transactional and analytical work.

The project grew from database research, and its first source release came in 2004. The community includes students, teachers, researchers, start-ups, small businesses and large enterprises in more than 130 countries.

What MonetDB offers

• SQL features — keys, joins, views, triggers and stored procedures, with full ACID transactions.
• Advanced SQL standards — ROLLUP, CUBE and grouping sets, merge statements and window functions.
• Parallel query execution — queries pass through many optimisers into plans that use multi-core processors.
• User-defined functions — written in SQL, Python, R or C and C++.
• Connectivity — JDBC and ODBC drivers plus several programming-language libraries.

Who it works with

Used in education, research and business, including medical and DNA analysis, financial analysis, astronomy and network monitoring.

Key facts

• First release: 2004
• Licence: Mozilla Public License