̷ õ ش ǹ̰ ִ ϰڽϴ.
CPU : SPECint, SPECfp, SPECint_rate, SPECfp_rate
OLTP : TPC-C
Data Warehousing : TPC-H
Web : SPECweb96, SPECweb99, SPECweb99_SSL
Java : SPECjbb2000
Oracle : Oracle Standard Benchmark
SAP
SAP R/3 2-tier, 3-tier
SAP ATO (Assemble to Order) 2-tier. 3-tier
TPC-C Overview
http://www.tpc.org
OLTP Ʈ
TPC 2
ֹԷ ý ⺻ Ͽ ġũ
ֹ Ż ø̼
5 Ʈ ũε
ó Database
Full-Screen ̽ SPEC
1 ű ֹ ó Ǽ(tpmC) ($/tpmC)
1992 7 23 TPC-C Ʈ
Version 5 ǥ
TPC-C Workload
OLTP Transaction (80븻~90 ǥ)
New-order : κ ο ֹ Է
Payment : ó ܰ Update
Delivery : ֹ ó (Batch ۾)
Order-status : ֱ ֹ Ȯ
Stock-level : â Ȳ
Database 9 Table
Update, Insert, Delete Abort Transaction (Primary or Secondary Key Index).
ð 䱸 : 90% ̻ Transaction 5 ð, Stock-level Transaction 20
1 : IBM eServer p5 595 64p
TPC-H Overview
TPC-H Benchmark (DW, BI)
ǻ ý۰ Decision Support Benchmark Test
Ͻ Ȳ ݿ 뷮 Database 22 Ad-hoc 2
TPC-H Ǵ
Ͻ Ȳ ʿ ϴ ad-hoc
Ϲ OLTP Ʈǿ ξ
۰ (Constraints)
CPU Memory, I/O ͺ̽ ǰ (intensive)
뷮 ͺ̽ 䱸
TPC-H
QphH@Size (TPC-H Composite Query per Hour)
Size Benchmark ͺ̽ ũ 1GB, 10GB, 30GB, 100GB, 300GB, 1000GB, 3000GB, 10000GB ũ⸦ . Database ũ Scale Factor(SF) TPC-H Ŀ
Database ũⰡ 1GB ̸ SF=1, 3TB̸ SF=3000
TPC-H
TPC-H 3000 QphH@300GB ġ ǹ̴ 300GB 뷮 Database 3000/300 = 10 Adhoc Query ѽð ִ ɷ ǹ (SF=300)
Database Size ٸ QphH ǹϸ ߸ ʷ Ƿ
1 : Sun Fire[TM] E25K server
SPEC Overview
http://www.spec.org
Standard Performance Evaluation Corporation
SPECcpu2000
Processor, Memory, Compiler Unit پ ϴ ǥ
Ǽ (ε Ҽ) ۾ Ͽ
SPECint: ϳ ϴ°? Speed
SPECfp: ϳ Ǽ ϴ°? Speed
SPECint_rate: ־ ðȿ ۾ ϴ°? 뿪
SPECfp_rate: ־ ðȿ Ǽ ۾ ϴ°? 뿪
SPECweb
SPECweb96: ȯ Web Server (HTML, Image Downloading)
SPECweb99: ȯ Web Server (DHTML, CGI etc)
SPECweb_SSL: SSL ȣȭ Web Server