有没有人发布不同的内存中RDBMS之间的详细比较？ [英] Has anyone published a detailed comparison between different in-memory RDBMSs?
问题描述
到目前为止，我设法在TimesTen和MySQL Cluster上找到通用的白皮书，但是我还没有看到对比。还有其他替代方法（例如来自IBM），但是有更容易获得的材料。
信息散布在网络，但这里是我发现的：
数据库基准测试简介
你需要做的第一件事是找出一个标准的基准，用于比较你的内存数据库选择。 Oracle上的Wiki页面提供了行业标准数据库基准测试概述。如果您能找到TimesTen和MySql Cluster的相同行业标准基准的结果，您将能够比较两者。
总结：由于你提到OLTP，你的行业标准基准可能感兴趣的是TPC-E，它模拟经纪公司的OLTP工作负载。其他行业标准基准测量决策支持和电子商务数据库交易。
开源数据库基准套件
开源开发实验室数据库测试套件是最全面的开源实现我之前提到的那些行业标准基准。他们有四个主要的测试套件编号为DBT1，DBT2，DBT3，DBT4。他们没有实现TPC-E基准测试，但数据库测试2（DBT2）是你正在寻找，因为它模拟OLTP事务。每个人都只是指的是运行DBT2基准而不是拼写为OSDLB DBT2。
结果
MySql
您需要注册才能获得发送给您的白皮书，这里是我从他们的网站上取得的摘要：
最终，MySQL群集能够达到
每分钟达到100,000次交易
在8节点配置中。与双节点群集
相比，
显示出显着的缩放改进
，每分钟能够获得26,000
个事务。这些
性能改进通过使用基于Intel
Core T微架构的新的Multi Core
Intel Xeon服务器实现了
。
< blockquote>
Oracle
不幸的是，DBT2不支持TimesTen。不过，我发现了一份白皮书，可在OLTP工作负载中提供 TimesTen的详细基准化信息。 / p>
IBM
其他资源 / p>
- 在内存DBMS部分，专注于数据库。
- 事务处理性能委员会网站 - 您可以使用各种DBMS从各种硬件供应商搜索其数据库中的基准测试。我无法在内存DBMS基准中找到任何内容。
There are quite a few independent and not-so-independent studies comparing traditional RDBMSs but I haven't managed to find any good material on in-memory databases. I am primarily interested in ones specialized for OLTP.
So far, I managed to find generic white papers on TimesTen and MySQL Cluster, but I have yet to see a head-to-head comparison. There are other alternatives (e.g. from IBM), but there's even less easily available material.
解决方案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
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.
Oracle
Unfortunately the DBT2 does not support TimesTen. However I found a whitepaper that gives detailed benchmarking information for TimesTen in an OLTP workload.
IBM
Other Resources
- In Memory DBMS section of a blog that focuses on databases.
- 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.
这篇关于有没有人发布不同的内存中RDBMS之间的详细比较？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
