Re: OLTP Benchmark on Monetdb

19 Dec 2012

      Sure, you can run TPC-C, because MonetDB provides ACID properties.
If you want to compare it against e.g. VoltDB, it is like comparing
apples and organges.
For one thing, you should be aware that TPC-C typical uses traditional locking schemes,
while MonetDB uses an optimistic CC, which is not designed for OLTP.
A typical pitfall is to draw conclusions without understanding the design
and their consequences on the application setting.
regards, Martin
On 12/19/12 1:22 PM, Hassan, Ahmad wrote:
...
Thanks Franck for the email. So does it mean that TPC-C benchmark cannot be executed on top of MonetDB?
Kind Regards, Ahmad
*From:*users-list-bounces+ahmad.hassan=sap.com@monetdb.org [mailto:users-list-bounces+ahmad.hassan=sap.com@monetdb.org] *On Behalf Of *Franck Routier
*Sent:* 19 December 2012 11:40
*To:* users-list@monetdb.org
*Subject:* Re: OLTP Benchmark on Monetdb
I think MonetDB is really not designed to do OLTP.
I think that if you really mean to do OLTP, MonetDB will most probably not fit.
Le 19/12/2012 12:10, Hassan, Ahmad a écrit :
Hi Team,

I am trying to run TPC-C benchmark provided by opensource oltpbenchmark (http://oltpbenchmark.com) on MonetDB. But I am getting JDBC Exception while loading the data set:

java.sql.BatchUpdateException: Error(s) occurred while executing the batch, see next SQLExceptions for details

         at nl.cwi.monetdb.jdbc.MonetStatement.executeBatch(MonetStatement.java:209)

Exception in thread "main" java.lang.ArithmeticException: / by zero

         at com.oltpbenchmark.benchmarks.tpcc.TPCCLoader.load(TPCCLoader.java:1857)

Please can you let me know any TPC-C benchmark implementation that is compatible with monetdb?

Thanks.

Kind Regards, Ahmad

_______________________________________________

users-list mailing list

users-list@monetdb.org  <mailto:users-list@monetdb.org>

http://mail.monetdb.org/mailman/listinfo/users-list

users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list

Re: OLTP Benchmark on Monetdb

Martin Kersten