Precedence based storage

摘要

Techniques for precedence based storage are presented. Storage for a database is organized into storage pools; collections of pools form storage classes. The storage pools within a particular class are organized in a precedence-based order so that when storage for the database is needed, the storage pools are used in the defined order of precedence. Additionally, each storage pool or storage class can be circumscribed by security limitations, quality of service limitations, and/or backup procedures.

主权项

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.