Time-Based Multiple Data Partitioning

• US 20090198736A1
• Filed: 01/31/2008
• Published: 08/06/2009
• Est. Priority Date: 01/31/2008
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Wang, Hao, Shen, Jinmei
• Application Number:
  US12/023,174
• Publication Number:
  US 20090198736A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2282 Tablespace storage structures; Management thereof

Abstract

A method, computer program product and computer system for dynamic data partitioning in a database system, which partitions data in a database system using at least one time-base data-partitioning scheme, maintains multiple time and data partitioning schemes, and utilizes database operations that work with partitions from time-based multiple data-partitioning schemes.

Claims

1. A method for dynamic data partitioning in a database system, comprising:

partitioning data in the database system into a plurality of data partitions using at least one time-based data-partitioning scheme;

maintaining the at least one time-based data partitioning scheme; and

enabling at least one database operation that is operatively coupled with the at least one time-based data-partitioning scheme in the database system.

2. The method of claim 1, wherein the partitioning comprises using at least one time interval to divide the database into a plurality of data partitions, wherein each time interval is determined by each one of the at least one time-based data-partitioning schemes.

3. The method of claim 1, wherein the maintaining comprises recording time, time intervals and the at least one time-based data partitioning scheme for all data partitions in the database system.

4. The method of claim 1, wherein the maintaining comprises deleting a data partition if the data partition is empty, and deleting a time-based partitioning scheme if all data partitions corresponding to the time-based partitioning scheme are deleted.

5. The method of claim 1, wherein the at least one database operation comprises at least one of an insert, update, delete and query operation.

6. The method of claim 1, wherein the at least one database operation comprises a query operation that uses a result assembler to combine data retrieved from data partitions.

7. The method of claim 1, wherein the enabling comprises using a data request router to route a database operation request to at least one data partition where correct data for the database operation request is located.

8. A computer program product for dynamic data partitioning in a database system, the computer program product comprising:

a computer usable medium having computer usable program code embodied therewith, the computer usable program code comprising;

instructions to partition data in the database system into a plurality of data partitions using at least one time-based data-partitioning scheme;

instructions to maintain the at least one time-based data partitioning scheme; and

instructions to enable at least one database operation that is operatively coupled with the at least one time-based data-partitioning scheme in the database system.

9. The computer program product of claim 8, wherein the instructions to partition comprises instructions to use at least one time interval to divide the database into a plurality of data partitions, wherein each time interval is determined by each one of the at least one time-based data-partitioning schemes.

10. The computer program product of claim 8, wherein the instructions to maintain comprises instructions to record time, time intervals and the at least one time-based data partitioning scheme for all data partitions in the database system.

11. The computer program product of claim 8, wherein the instructions to maintain comprises instructions to delete a data partition if the data partition is empty, and instructions to delete a time-based partitioning scheme if all data partitions corresponding to the time-based partitioning scheme are deleted.

12. The computer program product of claim 8, wherein the at least one database operation comprises at least one of an insert, update, delete and query operation.

13. The computer program product of claim 8, wherein the at least one database operation comprises a query operation that uses a result assembler to combine data retrieved from data partitions.

14. The computer program product of claim 8, wherein the instructions to enable comprises instructions to use a data request router to route a database operation request to at least one data partition where correct data for the database operation request is located.

15. A computer system comprising:

a processor;

a memory operatively coupled with the processor;

a storage device operatively coupled with the processor and the memory; and

a computer program product for dynamic data partitioning in a database system, the computer program product comprising;

a computer usable medium having computer usable program code embodied therewith, the computer usable program code comprising;

instructions to partition data in the database system into a plurality of data partitions using at least one time-based data-partitioning scheme;

instructions to maintain the at least one time-based data partitioning scheme; and

instructions to enable at least one database operation that is operatively coupled with the at least one time-based data-partitioning scheme in the database system.

16. The computer system of claim 15, wherein the instructions to partition comprises instructions to use at least one time interval to divide the database into a plurality of data partitions, wherein each time interval is determined by each one of the at least one time-based data-partitioning schemes.

17. The computer system of claim 15, wherein the instructions to maintain comprises instructions to record time, time intervals and the at least one time-based data partitioning scheme for all data partitions in the database system.

18. The computer system of claim 15, wherein the instructions to maintain comprises instructions to delete a data partition if the data partition is empty, and instructions to delete a time-based partitioning scheme if all data partitions corresponding to the time-based partitioning scheme are deleted.

19. The computer system of claim 15, wherein the at least one database operation comprises at least one of an insert, update, delete and query operation.

20. The computer system of claim 15, wherein the at least one database operation comprises a query operation that uses a result assembler to combine data retrieved from data partitions.

21. The computer system of claim 15, wherein the instructions to enable comprises instructions to use a data request router to route a database operation request to at least one data partition where correct data for the database operation request is located.