The information is scattered all over the web, but here's what I found out:
Introduction to database benchmarking
The first thing that you need to do is figure out a standard benchmark to use for comparing your in-memory database choices. A wiki page on Oracle gives an overview of the industry standard database benchmarks. If you can find results for the same industry standard benchmarks for TimesTen and MySql Cluster, you'll be able to compare the two. Finding a detailed comparison of all the in-memory databases is quite rare.
Summary: Since you mentioned OLTP, the industry standard benchmark that you're probably interested in is TPC-E which simulates the OLTP workload of a brokerage firm. Other industry standard benchmarks measure decision support and e-commerce database transactions.
Open source database benchmark kits
The Open Source Development Labs Database Test Suite is the most comprehensive open source implementation of those industry standard benchmarks I mentioned earlier. They have four main suite of tests numbered DBT1, DBT2, DBT3, DBT4. They haven't implemented the TPC-E benchmark, but the Database Test 2 (DBT2) is what you are looking for since it simulates OLTP transactions. Everyone simply refers to running the DBT2 benchmark instead of spelling it out as OSDLB DBT2.
You'll need to register to get the white paper emailed to you, but here is the summary that I took from their site:
Ultimately, MySQL Cluster was able to reach 100,000 transactions per minute in an 8-node configuration. This showed impressive scaling improvements when compared to a 2-node cluster which was able to obtain 26,000 transactions per minute. These performance improvements were realized through the use of new Multi Core Intel Xeon servers based on the Intel Core T micro architecture.
Transaction Processing Performance Council website - You can search their database for benchmarks from various hardware vendors using various DBMSes. I was unable to find any in memory DBMS benchmarks however.
Sebastian Czechowski at BigDataMatters has a comparison of four different IMDBs, suggesting selects tend to be 5X faster, and inserts/deletes tend to be 2x-4x faster.
VoltDB is an in-memory highly-scalable OLTP database that provides SQL/ACID and runs on commodity hardware in a shared-nothing cluster. It is open-source and exists in both a free/community (AGPLv3) version as well as a commercially supported version.
There is a post in the VoltDB forums discussing some of the other in-memory OLTP RDBMS solutions at http://community.voltdb.com/node/95. Feel free to review and add to that posting.
Almost every DBMS will do the same thing but differently, therefore you should look for the fastest DBMS you can find, if what you need is speed then you should use TimesTen wich is accepted as one of the fastest solutions, the thing with open-source DBMS is that, some of the more advanced features (such as replication) are nowhere near what you'd find on commercial alternatives. Quite simply, most users don't need replication at the levels that Oracle, DB2, or MS-SQL offer; therefore, PostgreSQL and MySQL developers don't get feel the need to improve it.
This answer was obtained after looking for the fastest between RDBMS mentioned here and some already known by me, I went 2 by 2 looking for the best and then looking for the best between the winner and the other, and the result was that TimesTen is the fastest between:
DB2
Oracle (not TimesTen)
MySQL
PostgreSQL
MS-SQL
So, you should use for the application you are mentioning and the conditions set TimesTen.
发布评论
评论（5）
这些信息散布在网络上，但这是我发现的：
数据库基准测试简介
您需要做的第一件事是找出一个标准基准来用于比较内存数据库选择。 Oracle 的 wiki 页面提供了行业标准数据库基准测试的概述。 如果您可以找到 TimesTen 和 MySql Cluster 的相同行业标准基准的结果，您就可以对两者进行比较。 找到所有内存数据库的详细比较是非常罕见的。
摘要：既然您提到了 OLTP，您可能感兴趣的行业标准基准是 TPC-E，它模拟经纪公司的 OLTP 工作负载。 其他行业标准基准衡量决策支持和电子商务数据库交易。
开源数据库基准测试套件
开源开发实验室数据库测试套件是我之前提到的那些行业标准基准的最全面的开源实现。 他们有四个主要测试套件，编号为 DBT1、DBT2、DBT3、DBT4。 他们尚未实施 TPC-E 基准测试，但您正在寻找数据库测试 2 (DBT2)，因为它模拟 OLTP 事务。 大家只是简单地提到运行 DBT2 基准测试，而不是将其拼写为 OSDLB DBT2。
结果
MySql
MySql 集群网站
MySql 发布的基准
您需要注册才能获得白色论文已通过电子邮件发送给您，但以下是我从他们的网站上获取的摘要：
Oracle
Oracle TimesTen 网站
不幸的是，DBT2 没有不支持TimesTen。 不过，我发现了一份白皮书，其中提供了 OLTP 工作负载中的 TimesTen 的详细基准测试信息。
IBM
IBM SolidDB 网站
其他资源
The information is scattered all over the web, but here's what I found out:
Introduction to database benchmarking
The first thing that you need to do is figure out a standard benchmark to use for comparing your in-memory database choices. A wiki page on Oracle gives an overview of the industry standard database benchmarks. If you can find results for the same industry standard benchmarks for TimesTen and MySql Cluster, you'll be able to compare the two. Finding a detailed comparison of all the in-memory databases is quite rare.
Summary: Since you mentioned OLTP, the industry standard benchmark that you're probably interested in is TPC-E which simulates the OLTP workload of a brokerage firm. Other industry standard benchmarks measure decision support and e-commerce database transactions.
Open source database benchmark kits
The Open Source Development Labs Database Test Suite is the most comprehensive open source implementation of those industry standard benchmarks I mentioned earlier. They have four main suite of tests numbered DBT1, DBT2, DBT3, DBT4. They haven't implemented the TPC-E benchmark, but the Database Test 2 (DBT2) is what you are looking for since it simulates OLTP transactions. Everyone simply refers to running the DBT2 benchmark instead of spelling it out as OSDLB DBT2.
Results
MySql
MySql Cluster Website
MySql published benchmarks
You'll need to register to get the white paper emailed to you, but here is the summary that I took from their site:
Oracle
Oracle TimesTen Website
Unfortunately the DBT2 does not support TimesTen. However I found a whitepaper that gives detailed benchmarking information for TimesTen in an OLTP workload.
IBM
IBM SolidDB Website
Other Resources
BigDataMatters 的 Sebastian Czechowski 对四种不同的 IMDB 进行了比较，表明选择速度往往快 5 倍，插入/删除速度往往快 2 倍到 4 倍。
http://bigdatamatters.com/bigdatamatters/2009/12/oracle_ibm_database_comparison.html
Sebastian Czechowski at BigDataMatters has a comparison of four different IMDBs, suggesting selects tend to be 5X faster, and inserts/deletes tend to be 2x-4x faster.
http://bigdatamatters.com/bigdatamatters/2009/12/oracle_ibm_database_comparison.html
VoltDB 是一个内存中高度可扩展的 OLTP 数据库，它提供 SQL/ACID 并在共享的商用硬件上运行-没有任何簇。 它是开源的，存在免费/社区 (AGPLv3) 版本 以及商业版本支持的版本。
VoltDB 论坛中有一篇文章讨论了其他一些内存中 OLTP RDBMS 解决方案，网址为 http:// Community.voltdb.com/node/95。 请随意查看并添加到该帖子中。
VoltDB is an in-memory highly-scalable OLTP database that provides SQL/ACID and runs on commodity hardware in a shared-nothing cluster. It is open-source and exists in both a free/community (AGPLv3) version as well as a commercially supported version.
There is a post in the VoltDB forums discussing some of the other in-memory OLTP RDBMS solutions at http://community.voltdb.com/node/95. Feel free to review and add to that posting.
这篇 wiki 文章对大多数著名的 RDBMS 进行了比较：关系数据库管理系统的比较
没有比较，但列出了内存中的 RDBMS： 内存数据库
另外，它在某种程度上取决于您的预期用途。 您的限制和最低性能要求是什么？
我认为您最好的选择是获取试用（或免费）版本并设置您自己的基准。
This wiki article gives a comparison of most of the well known RDBMS's: Comparison of relational database management systems
No comparison, but lists the in-memory RDBMS's: In-memory database
Also, it is going to depend on your intended use to some extent. What are your constraints and minimum performance requirements?
I think your best option is to obtain trial (or free) versions and set up your own benchmarks.
几乎每个 DBMS 都会做相同的事情，但有所不同，因此您应该寻找您能找到的最快的 DBMS，如果您需要的是速度，那么您应该使用 TimesTen ，它被认为是最快的解决方案之一开源 DBMS 的问题在于，一些更高级的功能（例如复制）远不及商业替代品中的功能。 很简单，大多数用户不需要 Oracle、DB2 或 MS-SQL 提供的级别的复制；他们需要复制。 因此，PostgreSQL 和 MySQL 开发人员并不觉得有必要改进它。
这个答案是在寻找这里提到的 RDBMS 和我已经知道的一些 RDBMS 之间最快的之后获得的，我2个2地寻找最好的，然后在获胜者和另一个之间寻找最好的，结果是 TimesTen 是以下各项中最快的：
因此，您应该将其用于您提到的应用程序和条件集 TimesTen。
Almost every DBMS will do the same thing but differently, therefore you should look for the fastest DBMS you can find, if what you need is speed then you should use TimesTen wich is accepted as one of the fastest solutions, the thing with open-source DBMS is that, some of the more advanced features (such as replication) are nowhere near what you'd find on commercial alternatives. Quite simply, most users don't need replication at the levels that Oracle, DB2, or MS-SQL offer; therefore, PostgreSQL and MySQL developers don't get feel the need to improve it.
This answer was obtained after looking for the fastest between RDBMS mentioned here and some already known by me, I went 2 by 2 looking for the best and then looking for the best between the winner and the other, and the result was that TimesTen is the fastest between:
So, you should use for the application you are mentioning and the conditions set TimesTen.