# US 2014/0195567 A1 · Data storage management by using excess capacity in a capacity controlled environment > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2014/0195567 A1 - Document ID: US20140195567A1 - Status: Published application - Kind: A1 - Application number: 13/721,827 - Filed: 2012-12-20 - Published: 2014-07-10 - Earliest claimed: 2011-09-30 - Assignees: Teradata Corporation - Applicants: Teradata Corporation - Inventors: Thomas Julien; Louis Burger; Frank Roderic Vandervort - Web page: https://patentgrep.com/patent/US20140195567A1 ## CPC - G06F 16/217: {Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409)} - G06F 16/21: Design, administration or maintenance of databases - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract Excess capacity (or excess resources) can be used in a capacity controlled environment to effectively manage data storage of a database. In this context, excess capacity can, for example, be controlled used as needed, as configured and/or on a temporary basis. Management of data storage in a database can, for example, include operations associated with moving or relocating data of the database. Relocation of data can, for example, be performed to relocate data deemed to be “hot” data to a location that can provide a faster access time in order to improve the overall efficiency of the database system. ## Claims ### Claim 1 A method, implemented at least partly by a device, for managing storage of data in a database by using excess capacity of a database system configured to operate at a limited capacity below its full capacity, wherein the database system includes one or more processors operable to process data stored in the database, and wherein the method comprises: allowing at least a portion of the excess capacity available to the database system to be used to manage storage of the data in the database. ### Claim 2 (depends on 1) The method of claim 1, wherein the management of the storage data in the database includes relocating the data stored in the database from a first location to a second location in the database. ### Claim 3 (depends on 1) The method of claim 1, wherein the method further comprises: determining one or more parameters to configure one or more data management operations associated with the management of the storage of the data in the database in order to configure the use of the excess capacity for use by the one or more data management operations. ### Claim 4 (depends on 3) The method of claim 3, wherein the determining of the one or more parameters to configure one or more data management operations comprises one or more of the following: determining the extent of excess capacity to be used by the one or more data management operations; configuring the excess capacity to complete the one or more data management operations; determining an amount time to complete the one or more data management operations; and determining one more priorities associated with the one or more data management operations. ### Claim 5 (depends on 2) The method of claim 2, wherein the method further comprises: determining whether to relocate the data in the database; and relocating the data of the database in the database using only the excess capacity of the database system when the determining determines that the threshold amount of data of the database is to be relocated in the database. ### Claim 6 (depends on 5) The method of claim 5, wherein at least the determining of whether to relocate the data in the database is performed by the database system automatically without requiring input from one or more users or administrators of the database system. ### Claim 7 (depends on 5) The method of claim 5, wherein the method further comprises: determining whether a threshold amount of data of the database is to be relocated in the database; and relocating the threshold amount of the data in the database by configuring the excess capacity to complete the relocation of the data before another data relocation is initiated by using the excess capacity when the determining determines that the threshold amount of data of the database is to be relocated in the database. ### Claim 8 (depends on 1) The method of claim 1, wherein the method further comprises: not allowing one or more data operations, not associated with the management of the storage of data in the database, to use the excess capacity of the database system. ### Claim 9 (depends on 1) The method of claim 1, wherein the method further comprises: configuring at least a portion of the excess capacity only for the management of the storage of data in the database; and not allowing any database queries associated with one or more users of the database system to use the configured the excess capacity. ### Claim 10 (depends on 1) The method of claim 1, wherein the method further comprises: configuring at least a portion of the excess capacity only for the management of the storage of data in the database to the extent needed to complete one or more data management operations in a dynamic manner when the database system is operational and processing one or more database requests using the capacity which is not part of the excess capacity. ### Claim 11 (depends on 2) The method of claim 2, wherein the relocation of data further comprises moving more or most frequently accessed data to one or more storage devices of the database system with relatively faster access times. ### Claim 12 (depends on 2) The method of claim 2, wherein the relocation of data further comprises moving less or least accessed data, including data that is non-accessed data, to one or more storage devices of the database system with relatively slower access times. ### Claim 13 A device that includes one or more processors operable to: manage storage of data in a database by using excess capacity of a database system configured to operate at a limited capacity below its full capacity, wherein the database system is operable to process data stored in the database; and allow at least a portion of the excess capacity available to the database system to be used to manage storage of the data in the database. ### Claim 14 A non-transitory computer readable storage medium storing at least executable code for managing storage of data in a database by using excess capacity of a database system configured to operate at a limited capacity below its full capacity, wherein the database system includes one or more processors operable to process data stored in the database, and wherein the executable code includes: executable code for allowing at least a portion of the excess capacity available to the database system to be used to manage storage of the data in the database.