Method and system for rapidly generating identifiers for records of a database
AssigneeCharles Schwab & Co., Inc.
InventorAdam Richards
Life of this patent
Estimating the term…
Abstract
A method and apparatus generates identifiers of database records apart from the database. One or more application programs may request an identifier of a transaction, and a stored identifier of a prior transaction is incremented or otherwise altered to produce the identifier of the transaction. The identifier is provided to the application program, which uses it as an identifier of a record of a database if such a record is created. If a system failure occurs, the database is scanned to identify the most recently issued identifier stored in the database, for example by requesting from the database the highest transaction number stored, and that number is used to generate the next transaction number.
Claims30
A method of providing an identifier of a database record, the method comprising:
- receiving a request for the identifier of the database record;
- changing a value stored solely in volatile storage to produce a changed value, responsive to the receiving the request step;
- and
- providing the changed value for use as the identifier of the database record.
A computer program product comprising a computer useable medium having computer readable program code embodied therein for providing an identifier of a database record, the computer program product comprising:
- computer readable program code devices configured to cause a computer to receive a request for the identifier of the database record;
- computer readable program code devices configured to cause a computer to change a value stored solely in volatile storage to produce a changed value, responsive to the receiving the request step;
- and
- computer readable program code devices configured to cause a computer to provide the changed value for use as the identifier of the database record.
A system for providing an identifier of a database record, the method comprising:
- a request receiver having an input operatively coupled for receiving a request for the identifier of the database record, the request receiver for signaling at an output responsive to the request received at the request receiver input;
- an increaser/storer having an input coupled to the request receiver output for changing a value stored solely in volatile storage to produce a changed value responsive to the signal received at the increaser/storer input and for providing the changed value at an output;
- and
- a provider for receiving the changed value at an input and for providing at an output coupled to a database input the changed value for use as the identifier of the database record.
Dependencies are inferred from the claim text.