TPC BENCHMARK W (Web Commerce)

1
TPC BENCHMARK W(Web Commerce)

• SeungLak Choi
• Dept. of Computer Science, KAIST

2
Contents

• What is TPC-W?
• Performance Metrics
• Web Interactions and Workload Profile
• Database Transaction

3
What is TPC-W? (1/2)

• Benchmark for web commerce system
• Models on online bookstore
• www.tpc.org
• Version 1.2 (Oct 18)

4
What is TPC-W? (2/2)
5
Performance Metrics

• WIPS_at_scale_factor
• The number of web interactions processed per
  second
• scale_factor is the number of items in the ITEM
  table
• Primarily shopping
• WIPSb primarily browsing
• WIPSo primarily ordering
• / WIPS

6
Web Interactions and Workload Profile

• Schema for bookstore
• Data population
• Interactions
• What does it do?
• Mix of interactions
• Navigation options
• Sample SQL HTML code

7
Web Interactions and Workload Profile

• Interactions

• Home
• Shopping Cart
• Customer Registration
• Buy Request
• Buy Confirm
• Order Inquiry
• Order Display

• Search Request
• Search Result
• New Products
• Best Sellers
• Product Detail
• Admin Request
• Admin Confirm

8
Web Interactions and Workload Profile

• Mix of Web Interactions

9
Database Transaction

• Transaction ACID Properties
• Atomicity test
• Consistency test
• Isolation test
• Durability Test
• Web page consistency requirements
• Allow 30 sec for pages to be updated