HELP! * BLUE=global GREY=local Global HTML version of Foils prepared July 23,1995

Foil 95 Consider the following PCM Example

From Full Relational Database HPDC-4 Presentation HPDC-4 Tutorial/CPS616 Spring95 -- August 1, Pentagon City Virginia. by Gang Cheng Marek Podgorny (Geoffrey Fox) * See also color IMAGE
Time
  • 1 Instance X attempts to update row 1 in (data block n)
  • Instance X becomes owner of PCM lock for data block n
  • Instance X update row 1
  • 2 Instance Y attempts to update row 2 in (data block n)
  • Instance Y requests the PCM lock from instance X for data block n
  • Instance X releases the PCM lock
  • Instance Y becomes owner of PCM lock for data block n
  • Instance Y update row 2
  • 3 Instance X attempts to update row 3 in (data block n)
  • Instance X requests the PCM lock from instance Y for data block n
  • Instance Y releases the PCM lock
  • Instance X becomes owner of PCM lock for data block n
  • Instance X update row 3
The PCM is handled separately from transaction lock -- when instance wish to update the same data (e.g.: Instance X and Y attempt to update Row 1), normal transaction locking is involved.
Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Tue Feb 18 1997