Method and apparatus for performing conflict resolution in database logging
First Claim
1. A system, comprising:
- a materialized view that is derived at least in part from a table;
a logging mechanism that maintains a refresh log, the refresh log containing a first range and a second range that at least partially overlap, the first range and the second range each having a timestamp associated therewith; and
a refresh manager that resolves conflicts between the first range and the second range that at least partially overlap by selecting portions of the first range and the second range that have the more recent timestamp and applying the selected portions of the first range and the second range to the materialized view.
1 Assignment
0 Petitions
Accused Products
Abstract
The disclosed embodiments relate to a system and method for performing conflict resolution when refreshing a materialized view. The system may comprise a logging mechanism that maintains a refresh log, the refresh log may contain a first range and a second range that at least partially overlap, the first range and the second range each having a timestamp associated therewith. The system may also include a refresh manager that resolves conflicts between the first range and the second range that at least partially overlap by selecting portions of the first range and the second range that have the more recent timestamp and applying the selected portions of the first range and the second range to the materialized view. In another embodiment, the system may comprise a logging mechanism that maintains a refresh log, the refresh log containing a range and a single-row entry, the range and the single row entry each having a timestamp associated therewith. The system may also include a refresh manager that resolves conflicts between the range and the single-row entry by ignoring the single-row entry if the single-row entry is part of the range and if the single-row entry has the more recent timestamp and by applying the single-row entry to the materialized view if the single-row entry is not part of the range or if the range has the more recent timestamp.
-
Citations
21 Claims
-
1. A system, comprising:
-
a materialized view that is derived at least in part from a table;
a logging mechanism that maintains a refresh log, the refresh log containing a first range and a second range that at least partially overlap, the first range and the second range each having a timestamp associated therewith; and
a refresh manager that resolves conflicts between the first range and the second range that at least partially overlap by selecting portions of the first range and the second range that have the more recent timestamp and applying the selected portions of the first range and the second range to the materialized view. - View Dependent Claims (2, 3, 4)
-
-
5. A system, comprising:
-
a materialized view that is derived at least in part from a table;
a logging mechanism that maintains a refresh log, the refresh log containing a range and a single-row entry, the range and the single row entry each having a timestamp associated therewith; and
a refresh manager that resolves conflicts between the range and the single-row entry by ignoring the single-row entry if the single-row entry is part of the range and if the single-row entry has the more recent timestamp and by applying the single-row entry to the materialized view if the single-row entry is not part of the range or if the range has the more recent timestamp. - View Dependent Claims (6, 7, 8, 9)
-
-
10. A method, comprising:
-
deriving a materialized view at least in part from a table;
storing a first range and a second range that at least partially overlap in a refresh log;
associating a timestamp with the first range and the second range in the refresh log; and
resolving conflicts between the first range and the second range in the portion that overlaps by applying a portion of either the first range or the second range that has the more recent timestamp to the materialized view. - View Dependent Claims (11, 12, 13)
-
-
14. A method, comprising:
-
deriving a materialized view at least in part from a table;
storing a range and a single-row entry in a refresh log, the range and the single-row entry each having a timestamp associated therewith;
ignoring the single-row entry if the single-row entry is part of the range and if the single-row entry has the more recent timestamp; and
applying the single-row entry to the materialized view if the single-row entry is not part of the range or if the range has the more recent timestamp. - View Dependent Claims (15, 16, 17, 18)
-
-
19. A computer program, comprising:
-
a machine readable medium;
a logging mechanism stored on the machine readable medium, the logging mechanism being adapted to create a refresh log that containins a first range and a second range that at least partially overlap, the first range and the second range each having a timestamp associated therewith; and
a refresh manager stored on the machine readable medium, the refresh manager being adapted to resolve conflicts between the first range and the second range that at least partially overlap by selecting portions of the first range and the second range that have the more recent timestamp and applying the selected portions of the first range and the second range to the materialized view. - View Dependent Claims (20, 21)
-
Specification