System and method for configuring storage resources for database storage

• US 8,566,560 B2
• Filed: 03/19/2008
• Issued: 10/22/2013
• Est. Priority Date: 02/01/2008
• Status: Active Grant

• Current Assignee: Dell Products LP (Dell Technologies Inc.)
• Original Assignee: Dell Products LP (Dell Technologies Inc.)
• Inventors: Sekhar, Sudhansu
• Primary Examiner(s): Bragdon, Reginald
• Assistant Examiner(s): Bansal, Gurtej
• Application Number:
  US12/050,978
• Publication Number:
  US 20090198945A1
• Time in Patent Office: 2,043 Days
• Field of Search: 711/5, 711/118, 711/171, 711/173
• US Class Current: 711/173
• CPC Class Codes: G06F 12/0804 with main memory updating G06F12/0806 takes precedence

Abstract

A system and method for configuring storage resources for database storage are disclosed. A method may include mapping at least one first tablespace having a first block size to at least one first logical unit. The method may also include mapping the at least one first tablespace and the at least one first logical unit to a first cache having a size equal to the first block size. In addition, the method may include mapping at least one second tablespace having a second block size to at least one second logical unit. The method may further include mapping the at least one second tablespace and the at least one second logical unit to a second cache having a size equal to the second block size.

Claims

1. A method for configuring a storage system for database storage comprising:

receiving, from an information handling system physically distinct from the storage system, an identity of at least one first tablespace and at least one second tablespace to be stored on the storage system, wherein the at least one first tablespace has a first block size and the at least one second tablespace has a second block size;

mapping, by a processor of the storage system the at least one first tablespace to at least one first logical unit, wherein the at least one first logical unit comprises all or a portion of at least one physical storage resource of the storage system and is configured to appear to an operating system executing on the information handling system as a single storage device;

mapping, by the processor, the at least one first tablespace and the at least one first logical unit to a first storage cache of the storage system, the first storage cache having a size equal to the first block size;

mapping, by at least one second tablespace to at least one second logical unit, wherein the at least one second logical unit comprises all or a portion of at least one physical storage resource of the storage system and is configured to appear to an operating system executing on information handling system as a single storage device; and

mapping, by the at least one second tablespace and the at least one second logical unit to a second storage cache of the storage system, the second storage cache having a size equal to the second block size.

2. A method according to claim 1, further comprising:

writing, by the processor, data of the at least one first tablespace to the at least one first logical unit and the first storage cache; and

writing, by the processor, data of the at least one second tablespace to the at least one second logical unit and the second storage cache.

3. A method according to claim 1, wherein at least one of mapping the at least one first tablespace to the first logical unit and mapping the at least one second tablespace to the second logical unit comprises:

in response to determining that the size of the tablespace is equal to the block size of a previously-mapped tablespace, mapping, by the processor, the tablespace to at least one logical unit mapped to the previously-mapped tablespace; and

in response to determining that the size of the tablespace is not equal to the block size of a previously-mapped tablespace, mapping, by the processor, the tablespace to at least one previously-unmapped logical unit.

4. A method according to claim 1, wherein the first storage cache comprises at least one of a read cache and a write cache.

5. A method according to claim 1, wherein the second storage cache comprises at least one of a read cache and a write cache.

6. A program of instructions embodied in a non-transitory computer-readable medium, the program of instructions configured to, when executed by a processor of a storage system, perform operations comprising:

receiving, from an information handling system physically district from the storage system, an identity of at least one first tablespace and at least one second tablespace to be stored on the storage system, wherein the at least one first tablespace has a first block size and the at least one second tablespace has a second block size;

map the at least one first tablespace to at least one first logical unit, wherein the at least one first logical unit comprises all or a portion of at least one physical storage resource of the storage system and is configured to appear to an operating system executing on an information handling system as a single storage device;

map the at least one first tablespace and the at least one first logical unit to a first storage cache of the storage system, the first storage cache having a size equal to the first block size;

map the at least one second tablespace to at least one second logical unit, wherein the at least one second logical unit comprises all or a portion of at least one physical storage resource of the storage system and is configured to appear to an operating system executing on an information handling system as a single storage device; and

map the at least one second tablespace and the at least one second logical unit to a second storage cache of the storage system, the second storage cache having a size equal to the second block size.

7. A program of instructions according to claim 6, further configured to, when executed by the processor:

write data of the at least one first tablespace to the at least one first logical unit and the first storage cache; and

write data of the at least one second tablespace to the at least one second logical unit and the second storage cache.

8. A program of instructions according to claim 6, wherein at least one of mapping the first tablespace to the first logical unit and mapping the second tablespace to the second logical unit comprises:

in response to determining that the size of the tablespace is equal to the block size of a previously-mapped tablespace, mapping, by the processor, the tablespace to at least one logical unit mapped to the previously-mapped tablespace; and

in response to determining that the size of the tablespace is not equal to the block size of a previously-mapped tablespace, mapping, by the processor, the tablespace to at least one previously-unmapped logical unit.

9. A program of instructions according to claim 6, wherein the first storage cache comprises at least one of a read cache and a write cache.

10. A program of instructions according to claim 6, wherein the second storage cache comprises at least one of a read cache and a write cache.

11. A storage system for storing a database, comprising:

a plurality of physical storage resources, comprising;

a first logical unit comprising all or a portion of at least one physical storage resource of the plurality of storage resources, the first logical unit configured to appear to an operating system executing on an information handling system as a single storage device;

a second logical unit comprising all or a portion of at least one physical storage resource of the plurality of storage resources, the second logical unit configured to appear to an operating system executing on the information handling system as a single storage device;

a processor communicatively coupled to the plurality of physical storage resources, the processor including a first storage cache having a first size and a second storage cache having a second size, the processor configured to;

receive from the information handling system an identity of at least one first tablespace and at least one second tablespace to be stored on the storage system, wherein the information handling system is physically distinct from the storage system;

map the at least one first tablespace the first logical unit, the at least one first tablespace having a first block size;

map the at least one first tablespace and the first logical unit to the first storage cache, wherein the first storage cache is configured to store tablespaces with a block size equal to the first size;

map the at least one second tablespace the second logical unit, the at least one second tablespace having a second block size; and

map the at least one second tablespace and the second logical unit to the second storage cache, the second storage cache being is configured to store tablespaces with a block size equal to the second size.

12. A system according to claim 11, wherein the at least one first storage cache comprises at least one of a read cache and a write cache.

13. A system according to claim 11, wherein the at least one second storage cache comprises at least one of a read cache and a write cache.