Managing databases in data storage systems
US-9460136-B1 · Oct 4, 2016 · US
US10831727B2 · US · B2
| Field | Value |
|---|---|
| Publication number | US-10831727-B2 |
| Application number | US-201213482819-A |
| Country | US |
| Kind code | B2 |
| Filing date | May 29, 2012 |
| Priority date | May 29, 2012 |
| Publication date | Nov 10, 2020 |
| Grant date | Nov 10, 2020 |
A practical reading order for non-experts. Skip the full description unless you need deep technical detail.
What the patent document calls the invention.
A short plain-language summary of the technical disclosure.
Who owns or filed the patent and who is credited as inventor.
Filing, priority, publication, and grant dates set the timeline.
The legal scope of protection — read this for what is actually claimed.
Technology tags used to group this patent with similar filings.
Prior art links and similar publications in this corpus.
Official abstract text for this publication.
An application programming interface (API) is used to migrate, from a specified source LUN to a specified target LUN, at least one specified sub-LUN data chunk, the API functioning as an interface between a storage controller and an owning application.
Opening claim text (preview).
What is claimed is: 1. A system for sub-Logical Unit Name (LUN) data migration in a computing environment, comprising: a processor, operable in the computing environment, wherein the processor is configured for, in host-based data migration, using an application programming interface (API) on a host to migrate as directed by an owning application comprising a database application, from a specified source LUN to a new physical location on a specified target LUN and at a specific predetermined time as specified by the owning application, at least one specified sub-LUN data chunk, each of the at least one specified sub-LUN data chunks comprised of a single database table associated with and generated by the owning application such that the single database table associated with and generated by the owning application is individually migrated from within the specified source LUN to the specified target LUN in lieu of migrating an entire volume containing multiple ones of the database tables, the API functioning as an interface between a storage controller and the owning application, and the data being migrated based upon a frequency of access and a hardware Input/Output Operations per second (IOPs) rate of the target LUN; wherein the at least one specified sub-LUN data chunk is transferred transparently to the owning application such that the storage controller executes the migration independently notwithstanding the migration being commanded by the owning application, wherein the owning application specifies the source LUN and the target LUN; generating an API call by the database application executing on the host directly to the storage controller using the API to initiate the migration of the at least one sub-LUN data chunk such that, between a first time at which the database application determines the at least one sub-LUN data chunk should be migrated and a second time at which the storage controller completes the migration of the at least one sub-LUN data chunk to the specified target LUN, only a single migration instruction, comprising the API call issued by the database application on the host to the storage controller, is issued in connection with the migration of the at least one sub-LUN data chunk; wherein the storage controller comprises a storage server managing Input/Output (I/O) requests to read and write data from multiple hosts including the host to storage pools over a Storage Area Network (SAN); wherein a migration size of the data migrated commensurate with the API call is fixed such that additional instances of the API call are generated until the migration of the chunk of the data is completed; exposing to the database application, using the API, a list of physical storage devices of the storage pools supported by the storage controller along with at least one storage characteristic associated with at least one of the list of the storage pools; wherein the storage characteristic includes at least a size and an available storage space; and responsive to receiving the exposed list of physical storage devices of the storage pools supported by the storage controller, determining a best fit for the at least one specified sub-LUN data chunk on the target storage pool by the storage controller according to an identification as to whether the at least one specified sub-LUN data chunk should be stored on one physical volume and whether the at least one specified sub-LUN data chunk should be split across multiple physical volumes. 2. The system of claim 1 , wherein the processor is further configured for specifying, by the owning application in operable communication with the API, a start Logical Block Address (LBA) and the size of the sub-LUN data chunk on a virtual disk and a target physical storage description to identify the new physical location. 3. The system of claim 2 , wherein the processor is further configured for receiving the API call via the API requesting data from the start LBA and the at least one specified sub-LUN data chunk to be migrated to a target storage pool of the exposed list of storage pools. 4. The system of claim 1 , wherein the processor is further configured for, as a migration operation, migrating the sub-LUN data chunk to the target storage pool as a background process, the background process transparent to the owning application. 5. The system of claim 4 , wherein the processor is further configured for pointing a virtual disk map to the new physical location on the target storage pool. 6. The system of claim 5 , wherein the processor is further configured for, subsequent to completing pointing the virtual disk map to the new physical location, committing the migration operation. 7. The system of claim 1 , wherein the API is one of provided inline to the owning application via a small computer systems interface (SCSI), and provided out-of-band to the owning application via an internet protocol (IP). 8. A computer program product for sub-Logical Unit Name (LUN) data migration by a processor in a computing environment, the computer program product comprising a non-transitory computer-readable storage medium having computer-readable program code portions stored therein, the computer-readable program code portions comprising: a first executable portion for, in host-based data migration, using an application programming interface (API) on a host to migrate as directed by an owning application comprising a database application, from a specified source LUN to a new physical location on a specified target LUN and at a specific predetermined time as specified by the owning application, at least one specified sub-LUN data chunk, each of the at least one specified sub-LUN data chunks comprised of a single database table associated with and generated by the owning application such that the single database table associated with and generated by the owning application is individually migrated from within the specified source LUN to the specified target LUN in lieu of migrating an entire volume containing multiple ones of the database records tables, the API functioning as an interface between a storage controller and the owning application, and the data being migrated based upon a frequency of access and a hardware Input/Output Operations per second (IOPs) rate of the target LUN; wherein the at least one specified sub-LUN data chunk is transferred transparently to the owning application such that the storage controller executes the migration independently notwithstanding the migration being commanded by the owning application, wherein the owning application specifies the source LUN and the target LUN; a second executable portion for generating an API call by the database application executing on the host directly to the storage controller using the API to initiate the migration of the at least one sub-LUN data chunk such that, between a first time at which the database application determines the at least one sub-LUN data chunk should be migrated and a second time at which the storage controller completes the migration of the at least one sub-LUN data chunk to the specified target LUN, only a single migration instruction, comprising the API call issued by the database application on the host to the storage controller, is issued in connection with the migration of the at least one sub-LUN data chunk; wherein the storage controller comprises a storage server managing Input/Output (I/O) requests to read and write data from multiple hosts including the host to storage pools over a Storage Area Network (SAN); wherein a migration size of the data migrated commensurate with the API call is fixed such that additional instances of the API call are generated until the migration of the chunk of the data is completed; a third executable portion for exposing to the
Database migration support · CPC title
Related publications grouped by family.
Answers are generated from the same data shown on this page.