BENCHMARKSQL README
===================
CHANGE LOG:
-----------
Version 5.0 lussman & jannicash:
--------------------------------------
+ Upgrade to PostgreSQL 9.3 JDBC 4.1 version 1102 driver
+ Improve support for Oracle
+ Re-implement the non-uniform random generator in TPC-C style.
+ Conform to clause 4.3.3.1 and enable lookup by last name
+ Add a switch to disable terminal-warehouse association, spreading
the data access over all configured warehouses.
+ Re-worked the run shell scripts and the location of SQL files to
make support of more database types easier.
+ Add support for Firebird (http://www.firebirdsql.org).
+ Add FOREIGN KEYS as defined by TPC-C 1.3.
+ Major code overhaul. The per transaction type terminal data
generation, execution and terminal trace code is moved into a
module jTPCCTData. The database connection with all prepared
statements has moved into a module jTPCCConnection.
+ Add collecting per transaction result data and OS Level
resource usage collection. The R statistics package is used
to graph detailed information and a complete report in HTML
can be generated from the data.
Version 4.1.2 TBD jannicash:
-----------------------------------
+ Fixed one more preparedStatement() leak. Hopefully with the help
of Oracle's V$OPEN_CURSOR view we got them all now.
+ Fixed a possible deadlock problem in the NEW_ORDER transaction.
Multiple parallel transaction could attempt to lock the same
STOCK rows in reverse order. Sorting the order lines by item ID
avoids this problem.
Version 4.1.1 2016-01-31 jannicash:
-----------------------------------
+ Changed the status line to update only once per second. The previous
implementation was getting rather noisy at high throughput.
+ Fixed two preparedStatement() leaks that could cause ORA-01000 errors
on longer runs with high throughput.
+ Fixed a problem in the calculation of sleep time between
transactions when using limitTxnsPerMin that could cause the test
to hang at the end.
+ Added support for escaping ; as \; in SQL files to be able to load
functions and execute anonymous PL blocks (needed for next item).
+ Changed the definition of history.hist_id into a plain integer with
no special functionality. Two new database vendor specific SQL
scripts allow to enable the column after data load as an auto
incrementing primary key. See HOW-TO-RUN.txt for details.
Version 4.1.0 2014-03-13 lussman:
---------------------------------
+ Upgrade to using JDK 7
+ Upgrade to PostgreSQL JDBC 4.1 version 1101 driver
+ Stop claiming to support DB2 (only Postgres & Oracle are well tested)
Version 4.0.9 2013-11-04 cadym:
-------------------------------
+ Incorporate new PostgreSQL JDBC 4 version 1100 driver
+ Changed default user from postgres to benchmarksql
+ Added id column as primary key to history table
+ Renamed schema to benchmarksql
+ Changed log4j format to be more readable
+ Created the "benchmark" schema to contain all tables
+ Incorporate new PostgreSQL JDBC4 version 1003 driver
+ Transaction rate pacing mechanism
+ Correct error with loading customer table from csv file
+ Status line report dynamically shown on terminal
+ Fix lookup by name in PaymentStatus and Delivery Transactions
(in order to be more compatible with the TPC-C spec)
+ Rationalized the variable naming in the input parameter files
(now that the GUI is gone, variable names still make sense)
+ Default log4j settings only writes to file (not terminal)
Version 4.0.2 2013-06-06 lussman & cadym:
--------------------------------------------
+ Removed Swing & AWT GUI so that this program is runnable from
the command line
+ Remove log4j usage from runSQL & runLoader (only used now for
the actual running of the Benchmark)
+ Fix truncation problem with customer.csv file
+ Comment out "BadCredit" business logic that was not working
and throwing stack traces
+ Fix log4j messages to always show the terminal name
+ Remove bogus log4j messages
Version 3.0.9 2013-03-21 lussman:
----------------------------------
+ Config log4j for rotating log files once per minute
+ Default flat file location to '/tmp/csv/' in
table copies script
+ Drop incomplete & untested Windoze '.bat' scripts
+ Standardize logging with log4j
+ Improve Logging with meaningful DEBUG and INFO levels
+ Simplify "build.xml" to eliminate nbproject dependency
+ Defaults read in from propeerties
+ Groudwork laid to eliminate the GUI
+ Default GUI console to PostgreSQL and 10 Warehouses
Version 2.3.5 2013-01-29 lussman:
-----------------------------------
+ Default build is now with JDK 1.6 and JDBC 4 Postgres 9.2 driver
+ Remove outdated JDBC 3 drivers (for JDK 1.5). You can run as
before by a JDBC4 driver from any supported vendor.
+ Remove ExecJDBC warning about trying to rollback when in
autocommit mode
+ Remove the extraneous COMMIT statements from the DDL scripts
since ExecJDBC runs in autocommit mode
+ Fix the version number displayed in the console
Versions 1.0 thru 2.2 2004 - 2012 lussman:
-------------------------------------------
+ Dare to Compare
+ Forked from the jTPCC project
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
benchmarksql-5.0-支持达梦.zip (94个子文件)
benchmarksql-5.0
.gitignore 11B
HOW-TO-RUN.txt 6KB
nbbuild.xml 4KB
src
com
lightstudio
bm
client
jTPCC.java 28KB
jTPCCRandom.java 7KB
jTPCCUtil.java 2KB
jTPCCTerminal.java 11KB
jTPCCConnection.java 13KB
jTPCCConfig.java 1KB
jTPCCTData.java 63KB
jdbc
ExecJDBC.java 3KB
oscollector
OSCollector.java 5KB
loaddata
LoadDataWorker.java 27KB
LoadData.java 10KB
build
classes
com
lightstudio
bm
client
jTPCCTData$1.class 230B
jTPCCTerminal.class 9KB
jTPCCTData$NewOrderData.class 1KB
jTPCCTData.class 34KB
jTPCCUtil.class 3KB
jTPCCTData$DeliveryData.class 930B
jTPCC.class 20KB
jTPCCTData$DeliveryBGData.class 942B
jTPCCConfig.class 1KB
jTPCCTData$StockLevelData.class 899B
jTPCCRandom.class 4KB
jTPCCTData$PaymentData.class 1KB
jTPCCConnection.class 8KB
jTPCCTData$OrderStatusData.class 1KB
jdbc
ExecJDBC.class 4KB
oscollector
OSCollector.class 5KB
OSCollector$CollectData.class 2KB
loaddata
LoadDataWorker.class 15KB
LoadData.class 8KB
empty
generated-sources
ap-source-output
built-jar.properties 66B
run
generateReport.sh 7KB
.gitignore 30B
funcs.sh 1KB
sql.postgres
tableCopies.sql 2KB
buildFinish.sql 157B
extraHistID.sql 827B
generateGraphs.sh 2KB
runDatabaseBuild.sh 606B
runDatabaseDestroy.sh 335B
runLoader.sh 217B
log4j.properties 962B
props.dm 1006B
sql.oracle
extraHistID.sql 1KB
props.fb 1KB
misc
cpu_utilization.R 2KB
blk_device_iops.R 2KB
latency.R 6KB
blk_device_kbps.R 2KB
os_collector_linux.py 9KB
tpm_nopm.R 2KB
net_device_kbps.R 2KB
net_device_iops.R 2KB
dirty_buffers.R 2KB
runBenchmark.sh 400B
props.pg 1021B
props.ora 947B
sql.firebird
extraHistID.sql 1KB
sql.common
tableDrops.sql 306B
indexDrops.sql 620B
tableCreates.sql 3KB
foreignKeys.sql 1KB
buildFinish.sql 117B
tableTruncates.sql 282B
indexCreates.sql 960B
runSQL.sh 1KB
dist
README.TXT 1KB
benchmarksql-5.0.jar 126KB
lib
log4j-1.2.17.jar 478KB
apache-log4j-extras-1.1.jar 339KB
doc
src
TimedDriver.odt 43KB
nbproject
genfiles.properties 481B
build-impl.xml 97KB
project.properties 4KB
project.xml 455B
private
config.properties 0B
private.properties 217B
private.xml 1KB
README.md 5KB
build.xml 1KB
manifest.mf 85B
lib
.gitignore 0B
dameng
DmJdbcDriver18.jar 800KB
postgres
postgresql-9.3-1102.jdbc41.jar 578KB
oracle
.gitignore 26B
README.txt 174B
firebird
connector-api-1.5.jar 36KB
jaybird-2.2.9.jar 856KB
log4j-1.2.17.jar 478KB
apache-log4j-extras-1.1.jar 339KB
联系作者.txt 74B
共 94 条
- 1
资源评论
- 踏雪归来常翩跹2022-04-01用户下载后在一定时间内未进行评价,系统默认好评。
老哥讲数据库
- 粉丝: 7942
- 资源: 27
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 论文(最终)_20240430235101.pdf
- 基于python编写的Keras深度学习框架开发,利用卷积神经网络CNN,快速识别图片并进行分类
- 最全空间计量实证方法(空间杜宾模型和检验以及结果解释文档).txt
- 5uonly.apk
- 蓝桥杯Python组的历年真题
- 2023-04-06-项目笔记 - 第一百十九阶段 - 4.4.2.117全局变量的作用域-117 -2024.04.30
- 2023-04-06-项目笔记 - 第一百十九阶段 - 4.4.2.117全局变量的作用域-117 -2024.04.30
- 前端开发技术实验报告:内含4四实验&实验报告
- Highlight Plus v20.0.1
- 林周瑜-论文.docx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功