System and Method For Configuring Storage Resources For Database Storage

• US 20090198945A1
• Filed: 03/19/2008
• Published: 08/06/2009
• 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
• Granted Patent: US 8,566,560 B2
• Time in Patent Office: Days
• US Class Current: 711/171
• 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 system for database storage comprising:

mapping at least one first tablespace having a first block size to at least one first logical unit;

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;

mapping at least one second tablespace having a second block size to at least one second logical unit; and

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.

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

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

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

3. A method according to claim 1, 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 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 the tablespace to at least one previously-unmapped logical unit.

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

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

6. A program of instructions embodied in a computer-readable medium, the program of instructions configured to, when executed:

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

map 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;

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

map 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.

7. A program of instructions according to claim 6, further configured to:

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

write data of the second tablespace to the at least one second logical unit and the second 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 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 the tablespace to at least one previously-unmapped logical unit.

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

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

11. A system for storing a database, comprising:

a processor;

a first logical unit communicatively coupled to the processor;

a second logical unit communicatively coupled to the processor;

a first cache communicatively coupled to the processor and having a first size; and

a second cache communicatively coupled to the processor and having a second size;

wherein;

the first logical unit is mapped to the first cache and is configured to store tablespaces with a block size equal to the first size; and

the second logical unit is mapped to the second cache and 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 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 cache comprises at least one of a read cache and a write cache.