System for automated storage management for databases

• US 20040122799A1
• Filed: 12/19/2002
• Published: 06/24/2004
• Est. Priority Date: 12/19/2002
• Status: Active Grant

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: International Business Machines Corporation
• Inventors: Goyal, Pawan, Tetzlaff, William H.
• Granted Patent: US 7,305,379 B2
• Time in Patent Office: Days
• US Class Current: 707/2
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

The invention provides a storage system that includes a policy manager. The policy manager has a user interface and a policy engine which encodes performance and workload requirements of tablespaces in a policy that is based on user input received through the user interface. Databases are connected to the policy manager and tablespaces are connected to the databases. The databases create the tablespaces, and the databases establish a storage allocation for the tablespace based on the policy. The policy manager detects if the tablespace is out of storage and automatically extends the storage allocation for the tablespace based on the policy, when the tablespace is out of storage.

Claims

1. A method for managing a storage system storing databases as storage objects in tablespaces, said method comprising:

encoding performance and workload requirements of said tablespaces in a policy;

creating, by a database, a tablespace for said database;

establishing a storage allocation for said tablespace based on said policy;

detecting if said tablespace is out of storage;

automatically extending said storage allocation for said tablespace based on said policy, when said tablespace is out of storage;

monitoring said storage system and determining if said performance and workload requirements are being met by said storage system; and

adjusting said storage allocation to achieve said performance and workload requirements.

2. The method in claim 1, further comprising storing said policy in a storage policy manager.

3. The method in claim 1, wherein said extending of said storage allocation comprises:

said database supplying said storage policy manager with policy name for said tablespace; and

said storage policy manager allocating the amount of additional storage that is permitted by said policy.

4. The method in claim 1, wherein said detecting if said tablespace is out of storage is performed by one of said database and an autonomic agent of said database.

5. The method in claim 1, wherein said detecting process is performed during a tablespace transaction and said extending process is performed while said transaction is pending, without failing said transaction.

6. The method in claim 1, wherein said monitoring comprises collecting information on response time, throughput, and utilization at storage disks and storage controllers.

7. A method for managing a storage system storing databases as storage objects in tablespaces, said method comprising:

encoding performance and workload requirements of said tablespaces in a policy;

creating, by a database, a tablespace for said database;

establishing a storage allocation for said tablespace based on said policy;

detecting if said tablespace is out of storage; and

automatically, and without user intervention, extending said storage allocation for said tablespace based on said policy, when said tablespace is out of storage.

8. The method in claim 7, further comprising storing said policy in a storage policy manager.

9. The method in claim 7, wherein said extending of said storage allocation comprises:

said database supplying said storage policy manager with policy name for said tablespace; and

said storage policy manager allocating the amount of additional storage that is permitted by said policy.

10. The method in claim 7, wherein said detecting if said tablespace is out of storage is performed by one of said database and an autonomic agent of said database.

11. The method in claim 7, wherein said detecting process is performed during a tablespace transaction and said extending process is performed while said transaction is pending, without failing said transaction.

12. A storage system comprising:

a policy manager comprising a user interface and a policy engine adapted to encode performance and workload requirements of tablespaces in a policy that is based on user input received through said user interface;

at least one database connected to said policy manager; and

at least one tablespace connected to said database, wherein said database creates said tablespace, and wherein said database establishes a storage allocation for said tablespace based on said policy;

wherein said database is adapted to detect if said tablespace is out of storage and said policy manager is further adapted to automatically extend said storage allocation for said tablespace based on said policy, when said tablespace is out of storage.

13. The storage system in claim 12, wherein said policy manager is further adpated to:

monitor said storage system and determining if said performance and workload requirements are being met by said storage system; and

adjust said storage allocation to achieve said performance and workload requirements.

14. The storage system in claim 12, wherein said database is adapted to supply said storage policy manager with a policy name for said tablespace;

and

said storage policy manager is adapted to allocate an amount of additional storage to extend said tablespace that is permitted by said policy.

15. The storage system in claim 12, further comprising an autonomic agent of said database adapted to detect if said tablespace is out of storage.

16. The storage system in claim 12, wherein said policy manager is further adapted to allocate additional storage to extend said tablespace during a tablespace transaction such that said transaction is prevented from failing.

17. The storage system in claim 12, further comprising monitors connected to said database, wherein said monitors are adapted to collect information on response time, throughput, and utilization at storage disks and storage controllers.

18. A storage system comprising:

a policy manager comprising a user interface and a policy engine adapted to encode performance and workload requirements of tablespaces in a policy that is based on user input received through said user interface;

at least one database connected to said policy manager; and

at least one tablespace connected to said database, wherein said database creates said tablespace, and wherein said database establishes a storage allocation for said tablespace based on said policy;

wherein said database is adapted to detect if said tablespace is out of storage during a tablespace transaction and said policy manager is adapted to automatically and without user intervention extend said storage allocation for said tablespace based on said policy, when said tablespace is out of storage such that said transaction is prevented from failing.

19. The storage system in claim 18, wherein said policy manager is further adpated to:

monitor said storage system and determining if said performance and workload requirements are being met by said storage system; and

adjust said storage allocation to achieve said performance and workload requirements.

monitor said storage system and determining if said performance and workload requirements are being met by said storage system; and

adjust said storage allocation to achieve said performance and workload requirements.

20. The storage system in claim 18, wherein said database is adapted to supply said storage policy manager with a policy name for said tablespace;

and

said storage policy manager is adapted to allocate an amount of additional storage to extend said tablespace that is permitted by said policy.

21. The storage system in claim 18, further comprising an autonomic agent of said database adapted to detect if said tablespace is out of storage.

22. The storage system in claim 18, further comprising monitors connected to said database, wherein said monitors are adapted to collect information on response time, throughput, and utilization at storage disks and storage controllers.

23. A program storage device readable by machine, tangibly embodying a program of instructions executable by the machine to perform a method for managing a storage system storing databases as storage objects in tablespaces, said method comprising:

encoding performance and workload requirements of said tablespaces in a policy;

creating, by a database, a tablespace for said database;

establishing a storage allocation for said tablespace based on said policy;

detecting if said tablespace is out of storage;

automatically extending said storage allocation for said tablespace based on said policy, when said tablespace is out of storage;

monitoring said storage system and determining if said performance and workload requirements are being met by said storage system; and

adjusting said storage allocation to achieve said performance and workload requirements.

24. The program storage device in claim 23, wherein said method further comprises storing said policy in a storage policy manager.

25. The program storage device in claim 23, wherein said extending of said storage allocation comprises:

said database supplying said storage policy manager with policy name for said tablespace; and

said storage policy manager allocating the amount of additional storage that is permitted by said policy.

26. The program storage device in claim 23, wherein said detecting if said tablespace is out of storage is performed by one of said database and an autonomic agent of said database.

27. The program storage device in claim 23, wherein said detecting process is performed during a tablespace transaction and said extending process is performed while said transaction is pending, without failing said transaction.

28. The program storage device in claim 23, wherein monitoring comprises collecting information on response time, throughput, and utilization at storage disks and storage controllers.