Data management system that provides flexible time-based query capability
First Claim
Patent Images
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.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
33 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. - View Dependent Claims (2, 3, 4, 5)
-
-
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. - View Dependent Claims (7, 8)
-
-
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. - View Dependent Claims (10, 11)
-
-
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. - View Dependent Claims (13, 14, 15, 16)
-
-
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. - View Dependent Claims (18, 19)
-
-
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. - View Dependent Claims (21, 22)
-
-
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. - View Dependent Claims (24, 25, 26, 27)
-
-
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. - View Dependent Claims (29, 30)
-
-
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. - View Dependent Claims (32, 33)
-
Specification