Problem:
An international investment bank has a well-developed relational database system in operation for several years at its Headquarters in Paris. But, the bank has recently seen an important expansion of business activities, with ever increasing amount of financial data to process and examine. Consequently, the IT Department of bank has proposed to incorporate parallel database techniques in the existing database system in order to enhance system performance. You’ve been commissioned by the IT Department to make a report on technical merits of the proposal. Your report must address the following aspects.
Required:
Question 1: Illustrate out the main objectives of parallel database system. In specific, discuss two (2) kinds of parallelism typically found in relational database system. Use diagram to demonstrate your discussion.
Question 2: Illustrate how parallelism might be utilized advantageously at three (3) particular levels of the database operations: data level, relational level, and query level.
Question 3: Recognize the potential advantages and disadvantages, appropriate to the given business scenario, of implementing parallel database techniques for the bank.
Question 4: Make a distinction between multi-programming and multi-processing.