Case Study 2: An OLTP Application on a Cluster
Bull-Bull, a stock brokerage company, maintains its trading application on an Oracle database. The database and the application are critical for the business of the firm. They need to be highly efficient and highly available, at least during business hours. The database has two types of users: direct and indirect. The direct users are the brokers; the indirect users access the database over the Internet. At peak hours of operation, the number of direct users goes up to 200, and the number of indirect users goes up to 800. The size of the database is 80 GB.
Application Requirements
The trading application is a mission-critical application for Bull-Bull firm. The success of the firm relies heavily on the performance and availability of this application. The application has the following performance and availability requirements:
- High availability
The main reason for Bull-Bull firm’s existence is to buy and sell stock. Consequently, the availability of their trading application is of prime importance. The cost of unavailability is extremely high—on the order of millions of dollars per hour. Therefore, the hardware and the database application need to be configured in a way that eliminates single points of failure and that provides high availability.
- Fast response to online users
Hundreds of online users use the application during trading hours, and hundreds of transactions are in process at any given time. The expected response time is on ...
Get Oracle Parallel Processing now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
