Patent ID: 9594527
Date: 2017-03-14
CPC Classifications: G06F

Claim:
1. A method for precedence-based storage, the method implemented as executable instructions residing in a non-transitory computer-readable storage medium and executed by a hardware processor, the method comprising: associating, by the hardware processing device, storage classes to storage pools within a database; defining, via the hardware processor, storage pool precedence list for said storage pools, said storage pool precedence list specifying a predefined pecking order for using the storage pools, said storage pool precedence list including at least some storage pools within the predefined pecking order as higher, lower, or at a same level as other ones of the storage pools; associating, via the hardware processor, said storage classes to database tables within said database; receiving, via the hardware processor, a request to store data in a database table during operation of the database; identifying, via the hardware processor, in response to said request, a subset of the storage pools using the storage class associated with said database table; and automatically processing, via the hardware processor: i) the request in a current storage pool in the subset of the storage pools identified for the storage class indicating that enough space exists to handle the request and ii) obtaining an available storage pool from the subset of the storage pools identified for the storage class for handling the request indicating that enough space for handling the request does not exist.