Back to results
US 11,960,465 B2Granted
Database inventory isolation
AssigneeSalesforce, Inc.
InventorsUdo Timpe, Andreas Eiserloh, Eckart Hilliger
Life of this patent
Estimating the term…
Abstract
Systems, devices, and techniques are disclosed for database inventory isolation. Demand levels for access to items may be monitored. The items may have associated inventory counts in a database. An item of the items for which to isolate the inventory count associated with the item may be determined based on the demand levels. The inventory count associated with the determined item may be isolated by moving the inventory count associated with the determined item from a first data block that stores the inventory count associated with the determined item and inventory counts associated with others of the items to a second data block that does not store any other inventory counts.
Claims17
A computer-implemented method comprising:
- monitoring demand levels for access to items, wherein each of the items has an associated inventory count in a database stored in a physical storage of at least one computing device, the physical storage divided into data blocks that store the inventory counts, by monitoring lock events and unlock events for the data blocks which store the inventory counts;
- determining based on the demand levels an item of the items for which to isolate the inventory count associated with the determined item by determining, based on the lock events and unlock events, that the first block, which stores the inventory count associated with the determined item, is subject to a number of parallel locks greater than a threshold;
- and
- isolating the inventory count associated with the determined item by moving the inventory count associated with the determined item from a first data block, of the physical storage, that stores the inventory count associated with the determined item and inventory counts associated with others of the items to a second data block, of the physical storage, that does not store any other inventory counts.
1 more element
A computer-implemented system comprising:
- one or more storage devices;
- and
- a processor that monitors demand levels for access to items, wherein each of the items has an associated inventory count in a database stored in a physical storage of the one or more storage devices, the physical storage divided into data blocks that store the inventory counts, by monitoring lock events and unlock events for the data blocks which store the inventory counts,
- determines based on the demand levels an item of the items for which to isolate the inventory count associated with the determined item by determining, based on the lock events and unlock events, that the first block, which stores the inventory count associated with the determined item, is subject to a number of parallel locks greater than a threshold, and
- isolates the inventory count associated with the determined item by moving the inventory count associated with the determined item from a first data block, of the physical storage, that stores the inventory count associated with the determined item and inventory counts associated with others of the items to a second data block, of the physical storage, that does not store any other inventory counts.
2 more elements
A system comprising:
- one or more computers and one or more non-transitory storage devices storing instructions which are operable, when executed by the one or more computers, to cause the one or more computers to perform operations comprising:
- monitoring demand levels for access to items, wherein each of the items has an associated inventory count in a database stored in a physical storage of at least one computing device, the physical storage divided into data blocks that store the inventory counts, by monitoring lock events and unlock events for the data blocks which store the inventory counts;
- determining based on the demand levels an item of the items for which to isolate the inventory count associated with the determined item by determining, based on the lock events and unlock events, that the first block, which stores the inventory count associated with the determined item, is subject to a number of parallel locks greater than a threshold;
- and
- isolating the inventory count associated with the determined item by moving the inventory count associated with the determined item from a first data block, of the physical storage, that stores the inventory count associated with the determined item and inventory counts associated with others of the items to a second data block, of the physical storage, that does not store any other inventory counts.
2 more elements
Dependencies are inferred from the claim text.