[Monetdb-announce] Official release of "MonetDB-4.4.0" & "MonetDB-SQL-2.4.0"

Stefan Manegold Stefan.Manegold at cwi.nl
Fri Oct 1 14:23:50 CEST 2004


TITLE: MonetDB 4.4.0 released

MonetDB is an open source high-performance database system developed by 
CWI, the Institute for Mathematics and Computer Science Research of The 
Netherlands. It was designed to provide high performance on complex 
queries against large databases, e.g. combining tables with hundreds of 
columns and multi-million rows. As such, MonetDB is able to be used in 
application areas that performance-wise are no-go areas for
traditional database technology in a real-time manner. MonetDB has been 
successfully applied in high performance applications for data mining, 
OLAP, GIS, XML Query, and text and multimedia retrieval.
MonetDB achieves this high performance using innovations at all layers of a DBMS: a 
storage model based on vertical fragmentation, a modern CPU-tuned 
vectorized query execution architecture that often gives MonetDB a more 
than 10-fold raw speed advantage on the same algorithm compared with a 
typical interpreter-based RDBMS. MonetDB is one of the first database 
systems to focus its query optimization effort on exploiting CPU caches. 
MonetDB also features automatic and self-tuning indexes, run-time query 
optimization, a modular software architecture, etc. In-depth 
information on the technical innovations in the design and 
implementation of MonetDB can be found in our digital library.

MonetDB is of particular interest to researchers, system developers
and students, interested in developing novel query-dominant applications
on a  flexible database engine. Database application developers find
a mature SQL implementation with common interfaces (JDBC,ODBC,php...)
to port their software.

MonetDB 4.4 marks the first official release of the MonetDB product
family, developed together with our partners around the world:
- Univ. of Massachusetts at Amherst develops PROXIMITY,
  an open source relational datamining solution on top of MonetDB.
- SPSS sells CRM solutions with data mining techogy based on MonetDB.
- Univ. Konstantz develops PATHFINDER, an open source XQuery processor
  on top of MonetDB (hosted in the MonetDB SourceForge Repository).
    Beta release scheduled for Dec 2004.
CWI keeps working on MonetDB and has a roadmap of significant
innovations to be introduced in future major relases.
These innovations encompass changes with respect to query execution
paradigms tuned for modern processors, pluggable optimizers, and
novel query languages and storage backends.

MonetDB is covered by the Mozilla license, giving unrestricted access to
the code base for inclusion in (commercial) products.

The MonetDB homepage     : http://monetdb.cwi.nl
The MonetDB repository   : http://sf.net/project/monetdb
The MonetDB technology   : http://monetdb.cwi.nl/Research/Articles
The MonetDB mailing lists: http://monetdb.cwi.nl/News/MailChannels/index.html

October 01, 2004  The MonetDB development team

Remaining Contents:

 - Release Notes
 - Change Logs
 - Downloads
 - CVS update
 - CVS checkins

Release Notes

The first "official" public release "MonetDB-4.4.0" plus "MonetDB-SQL-2.4.0"
is available on SourceForge:
http://sourceforge.net/projects/monetdb/ .
All users are highly advised (actually "requested" ;-)
to use the new release as of now
(see below for details concerning download and CVS checkout/update).
Please do not hesitate to ask for support and report bugs or problems,
preferably via the bug tracing system at SourceForge
(http://sourceforge.net/tracker/?group_id=56967&atid=482468) or via email to
monet at cwi.nl; however, please always state clearly, which version of
MonetDB/SQL you are using (as the Mserver tells you at startup)!

You are also welcome to subscribe to any (or all) of the MonetDB related
mailing lists on SF, cf.
Any support for the now obsolete release candidates "MonetDB-4.4.0_rc2" &
"MonetDB-SQL-2.4.0_rc2" (as well as any earlier versions) will stop as of

Change Logs

In MonetDB, the major change since the release candidate MonetDB-4.4.0_rc2
are mainly bug fixes.

In SQL, the coverage of SQL-92 & SQL-99 standard, and the functionality of
the JDBC & ODBC drivers have been extended.

For details, please check out the (coming) changelogs in the 
Monetdb-changelogs mailing list on SF:
http://lists.sourceforge.net/lists/listinfo/monetdb-changelogs .


These rpm's contain the binary distribution for Linux on i?86 (IA-32) systems.
The rpm's were built on a Fedora Core 2 system; however, they should work on
other Linux distributions as well (unless there are incompatibilities with
dynamically linked system libraries...).
While the MonetDB-client-4.4.0-1.i686.rpm can be installed stand-alone,
the MonetDB-server-4.4.0-1.i686.rpm requires the matching
MonetDB-client-4.4.0-1.i686.rpm to be installed as well.
To develop your own add-on modules, you additionally need to install the

These rpm's contain the binary distribution for Linux on i?86 (IA-32) systems.
The rpm's were built on a Fedora Core 2 system; however, they should work on
other Linux distributions as well (unless there are incompatibilities with
dynamically linked system libraries...).
To get a working MonetDB-SQL server, you need to install the
MonetDB-SQL-server-2.4.0-1.i686.rpm (which requires that
the MonetDB-server-4.4.0-1.i686.rpm is already installed).
MonetDB's "MapiClient" also serves as a textual SQL user interface:
simply start it with "MapiClient --language=sql".
The MonetDB-SQL-client-2.4.0-1.i686.rpm contains
(preliminary) ODBC & JDBC support for MonetDB-SQL.
The MonetDB-SQL-devel-2.4.0-1.i696.rpm contains header
files for further development.

This is a gzip'ed tar file containing the source code of MonetDB;
read HowToStart or HowToStart-Win32.txt for build instructions.

This is a gzip'ed tar file containing the source code of MonetDB/SQL;
read HowToStart-SQL or HowToStart-SQL-Win32.txt for build instructions.

Contains the MonetDB JDBC drive & client for MonetDB.
See http://monetdb.cwi.nl/TechDocs/APIs/JDBC/index.html for details.

Mknife is a 'Swiss army knife' GUI to ease the interaction with a running
MonetDB server.
See http://monetdb.cwi.nl/GetGoing/Usage/Mknife/ for details.

This zip file contains a file Setup.exe which is the Windows installer.
Extract the zip file somewhere, and start Setup.exe to install MonetDB.
The installer also contains the SQL frontend which is automatically
installed. Once installed, you can find shortcuts to the SQL server and SQL
client in the Start menu. 
"MonetDB-Installer-4.3.18.zip" is built with Visual Studio .NET 2003, and
hence requires the .NET runtime environment to be installed, too.

(In case you need binary installers for other systems/platform,
 please feel free to contact us.)

CVS update

If you are already using the release branches "MonetDB_4-4-0" and
"SQL_2-4-0" from CVS, simply run
	"cvs update -dP"
to update your code to this new release version.

If you are already using a CVS version of MonetDB/MonetDB-SQL, 
you can run either
	"cvs update -dP -rMonetDB_4-4-0_release"
	"cvs update -dP -rSQL_2-4-0_release"
to get this very release, or
	"cvs update -dP -rMonetDB_4-4-0"
	"cvs update -dP -rSQL_2-4-0"
to get the most recent version in the release branch. The difference is,
that via the first option, you are "stuck" with this very release, i.e.,
future "cvs update" (without "-r..." or "-A") will not change your
checked-out version; via the second option, however, future "cvs update"
will get you again the latest version in the release branch.

CVS checkins

All bug fixes (and only these!) on MonetDB and/or SQL are bound to go to the
new release branches ("MonetDB_4-4-0"/"SQL_2-4-0"), first.
On a regular basis, these bug-fixes will be propagated back to the respective
main trunk.

All new features are bound to go to the main trunks (and only there!).

As usually, any (constructive;-) comments and feedback are more than welcome!


The MonetDB development team

| The MonetDB development team   |
| mailto:monet at cwi.nl            |
| http://monetdb.cwi.nl/         |
| http://sf.net/project/monetdb/ |

More information about the announce-list mailing list