Data management system that provides flexible time-based query capability

• US 20040103084A1
• Filed: 11/21/2002
• Published: 05/27/2004
• Est. Priority Date: 11/21/2002
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Megerian, Mark Gregory
• Application Number:
  US10/301,128
• Publication Number:
  US 20040103084A1
• Time in Patent Office: Days
• US Class Current: 707/3
• CPC Class Codes: G06F 16/2477 Temporal data queries

Abstract

Disclosed is an apparatus, method, and program product for performing time-based queries using an enhanced conventional (called Unitemporal herein) Data Management System (DMS). A user is able to specify a date and time of day as part of a query, and the disclosed DMS will query stored data and return query results that reflect the data as it appeared on the date and at the time specified in the query. The time-based query capability is accomplished by using database journal information to reconstruct the data as of the specified effective time.

Claims

1. A method for performing a time-based query, said method comprising the steps of:

receiving said time-based query, said time-based query comprising temporal information;

applying said time-based query to data stored in a Unitemporal database; and

returning results based on said time-based query, said results being a time-specific representation of said data relative to said temporal information.

2. The method of claim 1 wherein said temporal information comprises a time.

3. The method of claim 1 wherein said temporal information comprises a date.

4. The method of claim 1 wherein said applying step further comprising the substep of:

using a journal to create said time-specific representation of said data prior to said applying step.

5. The method of claim 4 wherein said using step comprises the steps of:

copying said data to create copied data; and

using said journal to reverse changes to said copied data that occurred between and effective time and a current time, said effective time being specified in said temporal information.

6. A method for performing a time-based query, said method comprising the steps of:

receiving said time-based query, said time-based query comprising temporal information;

using a database journal to convert data stored in a database in a current time-specific representation into a past time-specific representation, an effective time of said past time-specific representation being specified in said temporal information; and

applying said time-based query against said past time-specific representation; and

presenting results of said applying step.

7. The method of claim 6 wherein said temporal information comprises a time.

8. The method of claim 6 wherein said temporal information comprises a date.

9. A method for performing a time-based query, said method comprising the steps of:

receiving said time-based query, said time-based query comprising temporal information;

converting data stored in a database in a current time-specific representation into a past time-specific representation, an effective time of said past time-specific representation being specified in said temporal information; and

presenting results, said results being based upon said past time-specific representation.

10. The method of claim 9 wherein said temporal information comprises a time.

11. The method of claim 9 wherein said temporal information comprises a date.

12. A program product, said program product comprising:

signal bearing media; and

a program disposed on said signal bearing media, said program being configured to perform the steps of,

receiving said time-based query, said time-based query comprising temporal information;

applying said time-based query to data stored in a Unitemporal database; and

returning results based on said time-based query, said results being a time-specific representation of said data relative to said temporal information.

13. The program product of claim 12 wherein said temporal information comprises a time.

14. The program product of claim 12 wherein said temporal information comprises a date.

15. The program product of claim 12 wherein said applying step further comprising the substep of:

using a journal to create said time-specific representation of said data prior to said applying step.

16. The program product of claim 15 wherein said using step comprises the steps of:

copying said data to create copied data; and

using said journal to reverse changes to said copied data that occurred between and effective time and a current time, said effective time being specified in said temporal information.

17. A program product for performing a time-based query, said program product comprising:

signal bearing media; and

a program disposed on said signal bearing media, said program being configured to perform the steps of,

receiving said time-based query, said time-based query comprising temporal information;

using a database journal to convert data stored in a database in a current time-specific representation into a past time-specific representation, an effective time of said past time-specific representation being specified in said temporal information; and

applying said time-based query against said past time-specific representation; and

presenting results of said applying step.

18. The program product of claim 17 wherein said temporal information comprises a time.

19. The program product of claim 17 wherein said temporal information comprises a date.

20. A program product for performing a time-based query, said program product comprising:

signal bearing media; and

a program disposed on said signal bearing media, said program being configured to perform the steps of,

receiving said time-based query, said time-based query comprising temporal information;

converting data stored in a database in a current time-specific representation into a past time-specific representation, an effective time of said past time-specific representation being specified in said temporal information; and

presenting results, said results being based upon said past time-specific representation.

21. The program product of claim 20 wherein said temporal information comprises a time.

22. The program product of claim 20 wherein said temporal information comprises a date.

23. An apparatus, said apparatus comprising:

a processor;

memory; and

a program stored in said memory for execution on said processor, said program being configured to perform the steps of,

receiving said time-based query, said time-based query comprising temporal information;

applying said time-based query to data stored in a Unitemporal database; and

returning results based on said time-based query, said results being a time-specific representation of said data relative to said temporal information.

24. The apparatus of claim 23 wherein said temporal information comprises a time.

25. The apparatus of claim 23 wherein said temporal information comprises a date.

26. The apparatus of claim 23 wherein said applying step further comprising the substep of:

using a journal to create said time-specific representation of said data prior to said applying step.

27. The apparatus of claim 26 wherein said using step comprises the steps of:

copying said data to create copied data; and

using said journal to reverse changes to said copied data that occurred between and effective time and a current time, said effective time being specified in said temporal information.

28. An apparatus for performing a time-based query, said program product comprising:

a processor;

memory; and

a program stored in said memory for execution on said processor, said program being configured to perform the steps of,

receiving said time-based query, said time-based query comprising temporal information;

using a database journal to convert data stored in a database in a current time-specific representation into a past time-specific representation, an effective time of said past time-specific representation being specified in said temporal information; and

applying said time-based query against said past time-specific representation; and

presenting results of said applying step.

29. The apparatus of claim 28 wherein said temporal information comprises a time.

30. The apparatus of claim 28 wherein said temporal information comprises a date.

31. An apparatus for performing a time-based query, said program product comprising:

a processor;

memory; and

a program stored in said memory for execution on said processor, said program being configured to perform the steps of,

receiving said time-based query, said time-based query comprising temporal information;

converting data stored in a database in a current time-specific representation into a past time-specific representation, an effective time of said past time-specific representation being specified in said temporal information; and

presenting results, said results being based upon said past time-specific representation.

32. The apparatus of claim 31 wherein said temporal information comprises a time.

33. The apparatus of claim 31 wherein said temporal information comprises a date.