验证测试 - 使用TPC-C？ （或者是什么？） [英] validation testing -- use TPC-C? (or what?)
问题描述
如何对DBMS（如DB2和Oracle）进行验证测试？
是否有快速常用的公开DBMS测试，可以是
二手？
可以使用TPC-C吗？如果是这样，可以从哪里获得TPC-C？ （是公开的
可用？）
谢谢。
我的TPC知识有点陈旧，所以请耐心等待。
首先，确保你正在为
$ b寻找合适的基准您感兴趣的$ b类型的处理。例如，TPC-C是一个基准指示
，主要表示快速交易处理。对于DSS密集型（TPC-H或TPC-D）
或网络密集型（TPC-W）的工作负载，还有其他基准测试。
其次，我不知道任何公开的TPC-C套件。我的理解是，用于TPC-C基准测试应用程序的源代码是密切保护的秘密，因为应用程序代码本身可能包含
代码可以显着提升性能。
-
--------------------
拉里·梅纳德
鹅和自然物的后卫
" z" < z@y.x.invalid>在消息中写道
news：6O ******************* @ newssvr27.news.prodigy。 net ...如何对DBMS（如DB2和Oracle）进行验证测试？
是否有一个快速常用的公开可用的DBMS测试，可以使用过？
可以使用TPC-C吗？如果是这样，可以从哪里获得TPC-C？ （是公开的吗？）
谢谢。
z写道：如何对DBMS（如DB2和Oracle）进行验证测试？
是否可以使用快速常用的公开DBMS测试？
可以使用TPC-C吗？如果是这样，可以从哪里获得TPC-C？ （是公开的吗？）
谢谢。
要验证什么？为什么？出于何种目的？
安全验证与银行系统交易验证之间存在巨大差异。
您的查询大致相当于我如何测试带轮子的车辆？
我的答案大致相当于它是自行车还是超音速
jet？"
-
Daniel A. Morgan
http://www.psoug.org
da ****** @ x.washington.edu
（用你的x代替x来回复）
< blockquote>" Larry Menard" < RO ** @ GoSpamYourself.com>在消息中写道
新闻：致****************************** @ rogers.com .. 。
我的TPC知识有点陈旧，所以请耐心等待。首先，确保你正在为<寻找合适的基准您感兴趣的处理类型。例如，TPC-C是一个
基准，主要指示快速事务处理。
还有其他基准测试工作负载更多DSS密集型< （TPC-H或TPC-D）或网络密集型（TPC-W）。
其次，我不知道任何公开的TPC-C套件。我的理解是，用于TPC-C基准测试应用程序的源代码是密切关注的秘密，因为应用程序代码本身可能包含可以显着提高性能的代码。 /> -
--------------------
拉里·梅纳德
鹅和万物自然的后卫
TPC基准测试发布在 www.tpc.org
我已经复制了TPC-H（决策支持）基准和tpc.org
网站为您提供了所需的一切，包括测试数据
发电机程序。您可能会发现成功编译测试数据
生成器程序有点困难，但是我可以在更改几个编译参数之后让它工作。他们还提供架构和查询。您需要查看每个基准测试的供应商文档，以获取他们对查询所做的任何定制，以允许稍微变化
数据库之间的SQL语法。
TPC-C OLTP基准测试可能更难以重现，如上所述，但
基准测试的详细信息已发布由网站上的每个供应商所以你可以看到
。
How can validation testing on DBMSs such as DB2 and Oracle be performed?
Is there a quick commonly used publicly available DBMS test that can be
used?
Could TPC-C be used? If so, where can TPC-C be obtained? (Is is publicly
available?)
Thanks.
My TPC knowledge is a bit dated, so take it with a grain of salt.
First of all, make sure you are looking for the right benchmark for the
type of processing you are interested in. For example, TPC-C is a benchmark
that is indicative primarily of rapid transaction processing. There are
other benchmarks for workloads that are more DSS-intensive (TPC-H or TPC-D)
or web-intensive (TPC-W).
Second, I don''t know of any publicly available TPC-C kits. It is my
understanding that the source code used for TPC-C benchmark applications are
closely-guarded secrets, since the application code itself might contain
code that accounts for significant performance improvements.
--
--------------------
Larry Menard
"Defender of Geese and of All Things Natural"
"z" <z@y.x.invalid> wrote in message
news:6O*******************@newssvr27.news.prodigy. net...How can validation testing on DBMSs such as DB2 and Oracle be performed?
Is there a quick commonly used publicly available DBMS test that can be
used?
Could TPC-C be used? If so, where can TPC-C be obtained? (Is is publicly
available?)
Thanks.
z wrote:How can validation testing on DBMSs such as DB2 and Oracle be performed?
Is there a quick commonly used publicly available DBMS test that can be
used?
Could TPC-C be used? If so, where can TPC-C be obtained? (Is is publicly
available?)
Thanks.
To validate what? why? for what purpose?
There is a huge difference between validation for security and
validation for transaction for a banking system.
You inquiry is roughly equivalent to "How an I test a vehicle with wheels?"
And my answer is roughly equivalent to "Is it a bicycle or a supersonic
jet?"
--
Daniel A. Morgan
http://www.psoug.org
da******@x.washington.edu
(replace x with u to respond)
"Larry Menard" <ro**@GoSpamYourself.com> wrote in message
news:To******************************@rogers.com.. .My TPC knowledge is a bit dated, so take it with a grain of salt.
First of all, make sure you are looking for the right benchmark for the
type of processing you are interested in. For example, TPC-C is a
benchmark that is indicative primarily of rapid transaction processing.
There are other benchmarks for workloads that are more DSS-intensive
(TPC-H or TPC-D) or web-intensive (TPC-W).
Second, I don''t know of any publicly available TPC-C kits. It is my
understanding that the source code used for TPC-C benchmark applications
are closely-guarded secrets, since the application code itself might
contain code that accounts for significant performance improvements.
--
--------------------
Larry Menard
"Defender of Geese and of All Things Natural"
The TPC benchmarks are published at www.tpc.org
I have reproduced the TPC-H (decision support) benchmark and the tpc.org
site provides you with everything you will need, including the test data
generator program. You may find it a bit difficult to compile the test data
generator program successfully, but I was able to get it to work after
changing a few compile parms. They also supply the schema and queries. You
will want to look at the vendor docs for each benchmark to pick up any
customization they have done to queries to allow for slight variations in
SQL syntax between the databases.
The TPC-C OLTP benchmark may be harder to reproduce as mentioned above, but
details of the benchmarks are published by each vendor on the website so you
could look there.
这篇关于验证测试 - 使用TPC-C？ （或者是什么？）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
