Back to results
US 2013/0173544 A1Published application
Materialized query table journaling in a computer database system
AssigneeInternational Business Machines Corporation
InventorsEric L. Barsness, John M. Santosuosso
Life of this patent
Estimating the term…
Abstract
An apparatus and method utilize MQTs in a more efficient manner in a high availability computer database to improve database performance and utility. In preferred embodiments, an MQT control file indicates whether journal entries for specific tables are to be propagated to replicated databases residing on other computer servers. In other embodiments, the MQT control file includes metrics that are used to control when the propagation is turned on and off.
Claims5
A method for a utilizing a materialized query table (MQT) in a database journal system, the method comprising the steps of:
- (A) providing a journal receiver that maintains data consistency of duplicate data across multiple servers using journal entries, wherein the journal receiver uses journal entries to duplicate materialized query tables (MQTs) on a target system depending on journal receiver attributes with at least one journal receiver attributes flag that indicates whether to propagate MQTs based on an MQT control file that comprises:
- a propagate files flag for a plurality of target computers corresponding to each listed MQT in the MQT control file to indicate whether a journal entry should be propagated to a corresponding target computer for the listed MQT;
- and
- one or more metrics for the plurality of target computers to indicate when propagation should be turned on and off for any of the plurality of MQTs indicated by the corresponding propagate files flag;
- (B) for each entry into the journal receiver, determining if the entry is for an MQT;
- (C) processing the entry if it is not for an MQT;
- (D) processing the entry if it is for an MQT and the propagate files flag in the MQT control file is set;
- and
- (E) skipping the entry if it is for an MQT and the propagate files flag in the MQT control file is not set.
6 more elements
Dependencies are inferred from the claim text.