US6832229B2
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for maintaining large-grained database concurrency with a log monitor incorporating dynamically redefinable business logic
Assignee: Oracle International Corp
•
Filing: 2001-03-09
•
Granted: 2004-12-14
•
Expires: 2021-03-09
Abstract
Abstract A system and method for maintaining large-grained database concurrency with a log monitor incorporating dynamically redefinable business logic are described. Operations expressed in a data manipulation language are executed against a source database. At least one operation constitutes a commit operation that completes each database transaction. A current rule set is defined. Each rule includes business logic specifying a data selection criteria for records stored in the source database. A log entry is periodically generated in a log for each transaction committed to the source database. Each log entry identifies an affected record and includes transactional data. The transaction identified in each log entry is evaluated against the data selection criteria specified in the current rule set. A new record is built in accordance with metadata describing a destination database. The new record contains select transactional data from the log entry of each transaction meeting the selection criteria. The new record is stored into the destination database. The data stored in the destination database includes at least a partial subset of the source database.
Inventors
- 👤 David Reed
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-04 04:34
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/23; G06F16/2308; G06F16/2358; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 30
Claim 1
Independent Claim
54 words
A method for using a log associated with a first database to update a second database, the method comprising the computer-implemented steps of: based on said log that is associated with said first database, identifying first data; generating second data based on said first data; and sending said second data to said second database.
Claim 2
Independent Claim
54 words
A method for using a log associated with a first database to update a second database, the method comprising the computer-implemented steps of: based on said log that is associated with said first database, identifying first data; generating second data based on said first data; and sending said second data to said second database.
Claim 3
Dependent Claim
42 words
The method of claim 1 , further comprising the computer-implemented step of: monitoring said log that is associated with said first database; identifying a change to said log; and in response to identifying said change to said log, identifying said first data.
Claim 4
Dependent Claim
35 words
The method of claim 1 , further comprising the computer-implemented steps of: based on said first data, determining that one or more selection criteria are satisfied prior to performing said steps of generating and sending.
Claim 5
Dependent Claim
39 words
The method of claim 3 , further comprising the computer-implemented step of: modifying said one or more selection criteria based on a change to third data that includes at least one of (a) a rule set and (b) metadata.
Claim 6
Dependent Claim
49 words
The method of claim 4 , wherein the step of modifying said one or more selection criteria includes the computer-implemented step of: in response to receiving notification of a change to said third data, modifying said one or more selection criteria based on said change to said third data.
Claim 7
Dependent Claim
22 words
The method of claim 5 , wherein said change is performed by a database builder in response to input from a user.
Claim 8
Dependent Claim
37 words
The method of claim 1 , wherein the step of generating said second data based on said first data includes the computer-implemented step of: generating said second data based on both said first data and third data.
Claim 9
Dependent Claim
29 words
The method of claim 7 , wherein said third data is a rule set that includes one or more criteria for identifying said first data based on said log.
Claim 10
Dependent Claim
47 words
The method of claim 7 , wherein said third data is metadata that includes at least one particular type of data selected from the group consisting of first database architecture data, second database architecture data, network topology data, job control data, scheduling data, and source code data.
Claim 11
Dependent Claim
47 words
The method of claim 1 , wherein: said second database is a particular database selected from the group consisting of a data warehouse and a datamart; said first database includes production data; and said second database includes informational data that is derived based on said production data.
Claim 12
Dependent Claim
37 words
The method of claim 1 , further comprising the computer-implemented steps of: after generating said second data, storing said second data in a cache; prior to sending said second data, retrieving said second data from said cache.
Claim 13
Dependent Claim
74 words
The method of claim 1 , further comprising the computer-implemented steps of: prior to identifying said first data, storing in a cache one or more log entries from said log, and retrieving from said cache at least one log entry of said one or more log entries; and wherein the step of identifying said first data further comprises the computer-implemented step of: based on said at least one log entry, identifying said first data.
Claim 14
Dependent Claim
139 words
The method of claim 1 , wherein: said first database is a production database; said second database is an informational database; said first data is a log entry in said log; said log entry is associated with a change to a first record stored in said first database; said log entry includes undo information; said first record includes production data; said second data is a second record that is to be stored in said second database; said second record includes at least one of a portion of said production data and informational data that is based on said production data; said steps of generating and sending are performed when one or more selection criteria are satisfied based on said undo information; and said one or more selection criteria are based on a rule set comprising dynamically redefinable business logic.
Claim 15
Dependent Claim
104 words
The method of claim 1 , wherein: the step of identifying first data further comprises the computer-implemented steps of: opening said log that is associated with said first database; and based on a rule set that specifies said one or more data selection criteria, dynamically analyzing one or more log entries in said log to identify said first data; and a log monitor performs said steps of dynamically analyzing, generating, and sending on a substantially continuous bases, thereby indirectly retrieving information from said first database for use in updating said second database to maintain large-grained concurrency between said first database and said second database.
Claim 16
Dependent Claim
81 words
A computer-readable medium carrying one or more sequences of instructions for using a log associated with a first database to update a second database, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform the steps of: based on said log that is associated with said first database, identifying first data; generating second data based on said first data; and sending said second data to said second database.
Claim 17
Dependent Claim
81 words
A computer-readable medium carrying one or more sequences of instructions for using a log associated with a first database to update a second database, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform the steps of: based on said log that is associated with said first database, identifying first data; generating second data based on said first data; and sending said second data to said second database.
Claim 18
Dependent Claim
61 words
The computer-readable medium of claim 15 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: monitoring said log that is associated with said first database; identifying a change to said log; and in response to identifying said change to said log, identifying said first data.
Claim 19
Dependent Claim
54 words
The computer-readable medium of claim 15 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: based on said first data, determining that one or more selection criteria are satisfied prior to performing said steps of generating and sending.
Claim 20
Dependent Claim
58 words
The computer-readable medium of claim 17 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: modifying said one or more selection criteria based on a change to third data that includes at least one of (a) a rule set and (b) metadata.
Claim 21
Dependent Claim
69 words
The computer-readable medium of claim 18 , wherein the instructions for modifying said one or more selection criteria further comprise instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: in response to receiving notification of a change to said third data, modifying said one or more selection criteria based on said change to said third data.
Claim 22
Dependent Claim
23 words
The computer-readable medium of claim 19 , wherein said change is performed by a database builder in response to input from a user.
Claim 23
Dependent Claim
57 words
The computer-readable medium of claim 15 , wherein the instructions for generating said second data based on said first data further comprise instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: generating said second data based on both said first data and third data.
Claim 24
Dependent Claim
30 words
The computer-readable medium of claim 21 , wherein said third data is a rule set that includes one or more criteria for identifying said first data based on said log.
Claim 25
Dependent Claim
48 words
The computer-readable medium of claim 21 , wherein said third data is metadata that includes at least one particular type of data selected from the group consisting of first database architecture data, second database architecture data, network topology data, job control data, scheduling data, and source code data.
Claim 26
Dependent Claim
48 words
The computer-readable medium of claim 15 , wherein: said second database is a particular database selected from the group consisting of a data warehouse and a datamart; said first database includes production data; and said second database includes informational data that is derived based on said production data.
Claim 27
Dependent Claim
56 words
The computer-readable medium of claim 15 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: after generating said second data, storing said second data in a cache; prior to sending said second data, retrieving said second data from said cache.
Claim 28
Dependent Claim
111 words
The computer-readable medium of claim 15 , further comprising instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: prior to identifying said first data, storing in a cache one or more log entries from said log, and retrieving from said cache at least one log entry of said one or more log entries; and wherein the instructions for identifying said first data further comprise instructions which, when executed by the one or more processors, cause the one or more processors to carry out the step of: based on said at least one log entry, identifying said first data.
Claim 29
Dependent Claim
146 words
The computer-readable medium of claim 15 , wherein: said first database is a production database; said second database is an informational database; said first data is a log entry in said log; said log entry is associated with a change to a first record stored in said first database; said log entry includes undo information; said first record includes production data; said second data is a second record that is to be stored in said second database; said second record includes at least one of a portion of said production data and informational data that is based on said production data; said instructions for generating and sending are executed by the one or more processors when one or more selection criteria are satisfied based on said undo information; and said one or more selection criteria are based on a rule set comprising dynamically redefinable business logic.
Claim 30
Dependent Claim
130 words
The computer-readable medium of claim 15 , wherein: the instructions for identifying first data further comprise instructions which, when executed by the one or more processors, cause the one or more processors to carry out the steps of: opening said log that is associated with said first database; and based on a rule set that specifies said one or more data selection criteria, dynamically analyzing one or more log entries in said log to identify said first data; and a log monitor directs the one or more processors to execute the instructions for dynamically analyzing, generating, and sending on a substantially continuous bases, thereby indirectly retrieving information from said first database for use in updating said second database to maintain large-grained concurrency between said first database and said second database.
References Cited (Backward Citations)
US5592660A
Cited
US5555404A
Cited
US5544359A
Cited
US6374252B1
Cited
US5970502A
Cited
US5903898A
Cited
US5907848A
Cited
US6609099B1
Cited
US6484149B1
Cited
US5991772A
Cited
US6480850B1
Cited
US6308168B1
Cited
US6446074B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2007-12-14 | 2008-06-14 | 2008-12-14 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2011-12-14 | 2012-06-14 | 2012-12-14 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2015-12-14 | 2016-06-14 | 2016-12-14 | $7700.00 | Window Closed / Lapsed |