Evaluating a current partitioning of a database

• US 20070226177A1
• Filed: 03/23/2006
• Published: 09/27/2007
• Est. Priority Date: 03/23/2006
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Santosuosso, John, Barsness, Eric
• Application Number:
  US11/388,009
• Publication Number:
  US 20070226177A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof

Abstract

Methods, apparatus, and products for evaluating a current partitioning of a database are disclosed that include querying each database partition of the database with an identical query statement, measuring performance of each database partition query, and identifying database partition characteristics of the current partitioning of the database in dependence upon the measured performance.

Claims

1. A method for evaluating a current partitioning of a database, the method comprising:

querying each database partition of the database with an identical query statement;

measuring performance of each database partition query; and

identifying database partition characteristics of the current partitioning of the database in dependence upon the measured performance.

2. The method of claim 1 further comprising selecting the identical query statement from a historical list of query statements for querying the database.

3. The method of claim 1 further comprising identifying a new partitioning of the database in dependence upon the database partition characteristics.

4. The method of claim 1 further comprising modifying at least one database partition of the database in dependence upon the database partition characteristics.

5. The method of claim 4 wherein modifying at least one database partition of the database in dependence upon the database partition characteristics further comprises moving data from at least one database partition of the database to at least one other database partition of the database in dependence upon the database partition characteristics.

6. The method of claim 1 further comprising reporting the database partition characteristics.

7. The method of claim 1 wherein measuring the performance of each database partition query further comprises measuring the response time of each database partition query.

8. An apparatus for evaluating a current partitioning of a database, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions capable of:

querying each database partition of the database with an identical query statement;

measuring performance of each database partition query; and

identifying database partition characteristics of the current partitioning of the database in dependence upon the measured performance.

9. The apparatus of claim 8 further comprising computer program instructions capable of selecting the identical query statement from a historical list of query statements for querying the database.

10. The apparatus of claim 8 further comprising computer program instructions capable of identifying a new partitioning of the database in dependence upon the database partition characteristics.

11. The apparatus of claim 8 further comprising computer program instructions capable of modifying at least one database partition of the database in dependence upon the database partition characteristics.

12. The apparatus of claim 11 wherein modifying at least one database partition of the database in dependence upon the database partition characteristics further comprises moving data from at least one database partition of the database to at least one other database partition of the database in dependence upon the database partition characteristics.

13. The apparatus of claim 8 wherein measuring the performance of each database partition query further comprises measuring the response time of each database partition query.

14. A computer program product for evaluating a current partitioning of a database, the computer program product disposed upon a signal bearing medium, the computer program product comprising computer program instructions capable of:

querying each database partition of the database with an identical query statement;

measuring performance of each database partition query; and

identifying database partition characteristics of the current partitioning of the database in dependence upon the measured performance.

15. The computer program product of claim 14 wherein the signal bearing medium comprises a recordable medium.

16. The computer program product of claim 14 wherein the signal bearing medium comprises a transmission medium.

17. The computer program product of claim 14 further comprising computer program instructions capable of identifying a new partitioning of the database in dependence upon the database partition characteristics.

18. The computer program product of claim 14 further comprising computer program instructions capable of modifying at least one database partition of the database in dependence upon the database partition characteristics.

19. The computer program product of claim 18 wherein modifying at least one database partition of the database in dependence upon the database partition characteristics further comprises moving data from at least one database partition of the database to at least one other database partition of the database in dependence upon the database partition characteristics.

20. The computer program product of claim 14 wherein measuring the performance of each database partition query further comprises measuring the response time of each database partition query.