a. Federated database system: At some location, we can have special data items on which the lock will be obtained before starting a global transaction. The lock must be released after the completion of the transaction. This ensures the single active global transaction requirement...

Question

Want to see the full answer?

Answer 1

Expert Solution & Answer

Chapter 23, Problem 11PE

Explanation of Solution

a.

Federated database system:

At some location, we can have special data items on which the lock will be obtained before starting a global transaction.

The lock must be released after the completion of the transaction. This ensures the single active global transaction requirement...

Explanation of Solution

b.

Example for a non-serializable global schedule:

The following schedule includes 2 sites and 4 transactions.

T₁ and T₂ are the local transactions that are running at site1 and site2 respectively.

T_G1 and T_G2 are the global transactions that are running at both sites.

X₁, Y₁ area data items at site1, and X₂, Y₂ are at site2.

T₁ T₂ T_G1 T_G2
write(Y₁)
read(Y₁)
...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 2

Expert Solution & Answer

Chapter 23, Problem 11PE

Explanation of Solution

a.

Federated database system:

At some location, we can have special data items on which the lock will be obtained before starting a global transaction.

The lock must be released after the completion of the transaction. This ensures the single active global transaction requirement...

Explanation of Solution

b.

Example for a non-serializable global schedule:

The following schedule includes 2 sites and 4 transactions.

T₁ and T₂ are the local transactions that are running at site1 and site2 respectively.

T_G1 and T_G2 are the global transactions that are running at both sites.

X₁, Y₁ area data items at site1, and X₂, Y₂ are at site2.

T₁ T₂ T_G1 T_G2
write(Y₁)
read(Y₁)
...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Expert Solution & Answer

Chapter 23, Problem 11PE

Explanation of Solution

a.

Federated database system:

At some location, we can have special data items on which the lock will be obtained before starting a global transaction.

The lock must be released after the completion of the transaction. This ensures the single active global transaction requirement...

Explanation of Solution

b.

Example for a non-serializable global schedule:

The following schedule includes 2 sites and 4 transactions.

T₁ and T₂ are the local transactions that are running at site1 and site2 respectively.

T_G1 and T_G2 are the global transactions that are running at both sites.

X₁, Y₁ area data items at site1, and X₂, Y₂ are at site2.

T₁ T₂ T_G1 T_G2
write(Y₁)
read(Y₁)
...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Expert Solution & Answer

Chapter 23, Problem 11PE

Explanation of Solution

a.

Federated database system:

At some location, we can have special data items on which the lock will be obtained before starting a global transaction.

The lock must be released after the completion of the transaction. This ensures the single active global transaction requirement...

Explanation of Solution

b.

Example for a non-serializable global schedule:

The following schedule includes 2 sites and 4 transactions.

T₁ and T₂ are the local transactions that are running at site1 and site2 respectively.

T_G1 and T_G2 are the global transactions that are running at both sites.

X₁, Y₁ area data items at site1, and X₂, Y₂ are at site2.

T₁ T₂ T_G1 T_G2
write(Y₁)
read(Y₁)
...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Expert Solution & Answer

Answer 6

Expert Solution & Answer

Answer 7

Chapter 23, Problem 11PE

Explanation of Solution

a.

Federated database system:

At some location, we can have special data items on which the lock will be obtained before starting a global transaction.

The lock must be released after the completion of the transaction. This ensures the single active global transaction requirement...

Explanation of Solution

b.

Example for a non-serializable global schedule:

The following schedule includes 2 sites and 4 transactions.

T₁ and T₂ are the local transactions that are running at site1 and site2 respectively.

T_G1 and T_G2 are the global transactions that are running at both sites.

X₁, Y₁ area data items at site1, and X₂, Y₂ are at site2.

T₁ T₂ T_G1 T_G2
write(Y₁)
read(Y₁)
...

Answer 8

Chapter 23, Problem 11PE

Explanation of Solution

a.

Federated database system:

At some location, we can have special data items on which the lock will be obtained before starting a global transaction.

The lock must be released after the completion of the transaction. This ensures the single active global transaction requirement...

Answer 9

Chapter 23, Problem 11PE

Explanation of Solution

a.

Federated database system:

At some location, we can have special data items on which the lock will be obtained before starting a global transaction.

The lock must be released after the completion of the transaction. This ensures the single active global transaction requirement...

Answer 10

Explanation of Solution

b.

Example for a non-serializable global schedule:

The following schedule includes 2 sites and 4 transactions.

T₁ and T₂ are the local transactions that are running at site1 and site2 respectively.

T_G1 and T_G2 are the global transactions that are running at both sites.

X₁, Y₁ area data items at site1, and X₂, Y₂ are at site2.

T₁ T₂ T_G1 T_G2
write(Y₁)
read(Y₁)
...

Answer 11

Explanation of Solution

b.

Example for a non-serializable global schedule:

The following schedule includes 2 sites and 4 transactions.

T₁ and T₂ are the local transactions that are running at site1 and site2 respectively.

T_G1 and T_G2 are the global transactions that are running at both sites.

X₁, Y₁ area data items at site1, and X₂, Y₂ are at site2.

T₁ T₂ T_G1 T_G2
write(Y₁)
read(Y₁)
...

Answer 12

Expert Solution & Answer

Answer 13

Expert Solution & Answer

Answer 14

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 15

Ch. 23 - Prob. 1PE Ch. 23 - Prob. 2PE Ch. 23 - Prob. 3PE Ch. 23 - Prob. 4PE Ch. 23 - Prob. 6PE Ch. 23 - Prob. 7PE Ch. 23 - Prob. 8PE Ch. 23 - Prob. 10PE Ch. 23 - Prob. 11PE Ch. 23 - Prob. 12PE

a. Federated database system: At some location, we can have special data items on which the lock will be obtained before starting a global transaction. The lock must be released after the completion of the transaction. This ensures the single active global transaction requirement...

Explanation of Solution

a. Federated database system: At some location, we can have special data items on which the lock will be obtained before starting a global transaction. The lock must be released after the completion of the transaction. This ensures the single active global transaction requirement...

Explanation of Solution

Want to see the full answer?

Chapter 23 Solutions

a.

Federated database system:

At some location, we can have special data items on which the lock will be obtained before starting a global transaction.

The lock must be released after the completion of the transaction. This ensures the single active global transaction requirement...