I'm not too familiar with the whole group. So getting reports out of summary tables then? I understand that it is clustered by column rather than by row, is it also clustered based on a specfc key? What about write speed? Does having default values for a column make inserts faster? Thanks! On Thu, Oct 23, 2008 at 8:46 PM, Travis Brady wrote:

MonetDB is useful for read-mostly applications like data warehousing/OLAP and such where you're often looking to summarize your data in bulk as opposed to OLTP where you have lots of single row inserts, point lookups and updates.

Basically stuff like: SELECT country, SUM(sales) FROM sales WHERE sale_date > '2005-01-01' GROUP BY country

MonetDB is a column store not entirely unlike Vertica, LucidDB or Infobright.

Travis

On Thu, Oct 23, 2008 at 12:52 AM, Martin Kersten wrote:

...

steve wrote:

...

What are the use cases for monetdb?

what are you looking for? See the website for indications of the deployment of MonetDB..

...

------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users