PRIMARY KEY GENERATOR

摘要

Systems and methods for reclaiming and reusing primary key values are provided. According to one embodiment, multiple unused primary key values of a database application are reclaimed by a key generator by locating a gap in a sequence of a primary key column of the database application. Reuse of the reclaimed unused primary key values is facilitated by the key generator by returning a reclaimed unused primary key value responsive to a request from the database system for a new primary key value for the primary key column.

主权项

1. A method comprising:
reclaiming, by a key generator running on a computer system, a plurality of unused primary key values of a database application by locating a gap in a sequence of a primary key column of the database application; and facilitating reuse of the one or more reclaimed unused primary key values, by the key generator, by returning one of the plurality of reclaimed unused primary key values responsive to a request from the database system for a new primary key value for the primary key column.