Distributed Database Systems, 1st Edition by Chhanda Ray

Distributed Database Design

■

77

values (55, $salary,$design)

Delete from Emp1 where emp-id ⴝ 55

Delete from Emp2 where emp-id ⴝ 55

Local Mapping transparency:

Select emp-name, project-no into $emp-name, $project-no from Emp1 at site 1

where emp-id ⴝ 55

Select salary, design into $salary, $design from Emp2 at site 2

where emp-id ⴝ 55

Insert into Emp3 at site 3 (emp-id, emp-name, emp-branch, project-no)

values (55, $emp-name, 20, $project-no)

Insert into Emp3 at site 7 (emp-id, emp-name, emp-branch, project-no)

values (55, $emp-name, 20, $project-no)

Insert into Emp4 at site 4(emp-id, salary, design)

values (55, $salary,$design)

Insert into Emp4 at site 8(emp-id, ...