The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jan. 29, 2013
Filed:
Aug. 01, 2008
Richard J. Brodfuehrer, Endicott, NY (US);
Terence Patrick Purcell, Springfield, IL (US);
Michael S. Wang, Wappingers Falls, NY (US);
Kim Jon Worm, Red Hook, NY (US);
Richard J. Brodfuehrer, Endicott, NY (US);
Terence Patrick Purcell, Springfield, IL (US);
Michael S. Wang, Wappingers Falls, NY (US);
Kim Jon Worm, Red Hook, NY (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A method and apparatus for generating partition keys in an information handling system having a partitioned database. Partition keys are generated by concatenating a partition subrange identifier specifying a subrange of key values and a sequence number specifying a particular key value within a subrange. Partition keys are assigned with the aid of a partition key control table that stores subrange and available key block information and is updated whenever key blocks are reserved or the database is repartitioned. An activity indicator maintained for each partition indicates recent activity in the partition. In response to a request for a partition key, a partition is selected for key assignment having the least recent activity as indicated by its activity indicator. Specific activity indicators disclosed include a timestamp for each partition in the control table, as well as a count of the threads in a particular application instance concurrently accessing a partition.