List five issues that arise in the design of heterogeneous distributed transaction processing systems that do not arise in homogeneous distributed systems.
What will be an ideal response?
1. The DBMSs are supplied by different vendors and speak different dialects of SQL.
2. Some of the DBMSs do not perform the two-phase commit protocol.
3. The systems use different low-level communication protocols.
4. At a higher level, some systems use RPCs and others use peer-to-peer communication.
5. Some of the legacy systems are so old that the source code for the transactions has disappeared from the face of the earth.
You might also like to view...
When you call a stored procedure, you can pass the parameters by position or by name.
a. true b. false
Consider the example string network in Figure 4.5 where only five nodes are shown. Write a program to create a similar topology of 40 nodes. Apply the SDLA algorithm to add five LLs. Also apply the MinAPL, MaxBC, and MaxCC strategies to add the same number of LLs. Compare APL values after adding each LL with the above strategies. What is the percentage deviation for each APL value? Also compare the execution time of these algorithms. Comment on overall performance of all the strategies.
