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