Page 232 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Unit 13: Parallel Databases

To make non-redundant data in the above table we construct two tables first consists of Vendor Notes
information and secondly the product sale information:

Vendor

Vendor_id vendorName Loc Region
1111 Radha Krishna GopalPatnam Vizag
2222 Raj shekhar ReinBazar Hyd

Product-sale

P_id qty rate Sale_on Vendor_id
898 5 9.90 24-JAN-03 1111
987 4 89.00 24-1AN-03 2222
342 6 44.30 27- JAN-03 1111
433 2 300.00 29-JAN-03 1111

Splitting is like to split less used column information out from a frequently accessed fact table in
data warehouse. Row splitting is to speed access to the large table by reducing its size and the
other data is still maintained and can be accessed separately.
Vertical partition has to be done when there is no requirements to perform major join operations
between the two partitions.

Task Discuss SMP and DSS.

13.3 Inter-query Parallelism

Inter-query parallelism is the ability to use multiple processors to execute several independent
queries simultaneously. Figure 13.5 illustrates inter-query parallelism, showing how three
independent queries can be performed simultaneously by three processors. Inter-query
parallelism does not provide speedup, because each query is still executed by only one processor.

Figure 13.5: Inter-query Parallelism

LOVELY PROFESSIONAL UNIVERSITY 225