The Design And Implementation Of TPC-W For OpenBASE

How does one determine Database performance and price/performance for an Internet commerce, Ecommerce, environment? The most notable benchmarks, (SPECWeb and TPC-C), have been referenced by many vendors promoting the performance of their Ecommerce servers. However these benchmarks do not come close to representing the complex environment of an Ecommerce workload, The Transaction Performance Council, TPC, introduced the TPC-W benchmark targeted at the Ecommerce environment. TPC-W specifies an Ecommerce workload that simulates customers browsing and buying products from a website. The solution for this workload is a number of servers, for example, Web Application Server, Database Server and Remote Browser Emulator (RBE), working in concert to provide an Ecommerce solution. It's very similar to how an actual Ecommerce site would operate. The TPC-W specification describes in detail the 14 different web pages of website. For example, Home, New Order, Order Inquiry, etc. It simulate the activity of a retail store. For the data statistic, TPC-W specification defined the scale of the data, maximum response time for each transaction, the number of concurrence clients, and the number of web interaction per second. These data will represent the maximum of workload for the database under the specified hardware and software environment. According the testing result, we can also tune the parameter of the web application server and database server for the highest performance.This subject is to design and implement the TPC-W for OpenBASE Database, and perform the TPC-W performance testing under the specified hardware and software environment, according to the testing result; we can find the bottleneck of the performance for the OpenBASE Database in the high workload environment.TPC-W can find some bugs which the other testing can not find, such as index performance issues in the high data-load and concurrency transaction processing and concurrency lock control issues. These kinds of issues only can be found under the complex testing environment. TPC-W is a useful tool for finding and resolving these issues. TPC-W will be used for evaluating the performance of the hardware for the product environment, and provide a initial optimized configuration for the Database and Application server. It will be very helpful for the web application implementation person.