August 2009
Intermediate to advanced
893 pages
26h 48m
English
Content preview from Database Systems: Concepts, Design and Applications
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...