Parallel database technology can benefit certain kinds of applications by enabling:
- Higher Performance: With more CPUs available to an applicatio , higher speedup and scaleup can be attained. The performance improvement depends on the degree of inter-node locking and synchronization activities. Each lock operation is processor — and mess, ge-intensive; there can be a lot of latency. The volume of lock operations and database contention, as well as the throughput and performance of the IDLM, ultimately determine the scalability of the system.
- High Availability: Nodes are isolated from each other, so a failure' at one node does not bring the entire system down. One of the surviving nodes recovers the failed node and the system continues to provide data access to users. This means data is much more available than it would be with a single node upon node failure. This also amounts to significantly higher database availability.
- Greater Flexibility: An OPS environment is extremely flexible. One can allocate or deallocate instances as necessary. For example, as database demand increases, you can temporarily allocate more instances. Then one can deallocate the instances and use them for other purposes once they are no longer required.
- More Users: Parallel database technology can make it possible to overcome memory limits, enabling a single system to serve thousands of users.
- Improve Response Time: Useful for the application to query extremely large database and to process an extremely large number of transactions rate (in the order of thousands of transactions per second).
