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.orgmailto: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

Hi Martin, I completely agree with you. Thanks for the detailed insight. Kind Regards, Ahmad -----Original Message----- From: users-list-bounces+ahmad.hassan=sap.com@monetdb.org [mailto:users-list-bounces+ahmad.hassan=sap.com@monetdb.org] On Behalf Of Martin Kersten Sent: 19 December 2012 12:33 To: users-list@monetdb.org Subject: Re: OLTP Benchmark on Monetdb 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 _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list