Primary key pool summary
Theprimary key pool technique requires the following components:
♦Keypool table Atable to hold valid primary key values for each
databasein the installation.
♦Replenishmentprocedure A stored procedure keepsthe key pool table
filled.
♦Sharingof key pools Each database in the installation must subscribe
toits own set of valid values from the key pool table.
♦Dataentr y procedures Newrowsare entered using a stored procedure
thatpicks the next valid primary key value from the pool and delete that
valuefrom the key pool.
180