17.4. Key Elements of Parallel Database Processing

Following are the key elements of parallel database processing:

  • Speed-up

  • Scale-up

  • Synchronisation

  • Locking

17.4.1. Speed-up

Speed-up is a property in which the time taken for performing a task decreases in proportion to the increase in the number of CPUs and disks in parallel. In other words, speed-up is the property of running a given task in less time by increasing the degree of parallelism (more number of hardware). With additional hardware, speed-up holds the task constant and measures the time saved. Thus, speed-up enables users to improve the system response time for their queries, assuming the size of their databases remain roughly the same. Speed-up due to parallelism can be defined as ...

Get Database Systems: Concepts, Design and Applications 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.