The Investment Club Benchmark tests a class of update-intensive and highly-concurrent transactions of a set of imaginable investment clubs. The transactions represent the most frequent and data-implicated class of transactions including real-time business intelligence.
The performance is measured by the following metrics:
In this benchmark, the database has 5,000 investment clubs with 20 members per club (100,000 user accounts). The users initiate five types of transactions: Deposit, Withdraw, Buy, Sell, and Vote. Additionally, stock prices can be changed and the system initiates transactions to update the market value of corresponding stock positions. Every transaction ends with real-time analytics which includes calculating a dynamic view of the market performance of positions, portfolios, clubs, and members.
Transactions within an investment club must be ordered by the server and executed sequentially. Thus, for instance, two investment club members can not spend more funds than available. Transactions applying to different investment clubs should be executed in parallel. Also, for higher throughput, read-only transactions should not block read-write transactions and should be executed in parallel even they access the same data.