Back to results
US 2013/0173543 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.
Claims6
An apparatus comprising:
- at least one processor;
- a memory coupled to the at least one processor;
- a database residing in the memory having data in at least one base table;
- 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;
- and
- a database propagator residing in the memory that autonomically adjusts journaling of MQTs using the MQT control file.
6 more elements
A program product comprising:
- (A) 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) a database propagator in a database system that autonomically adjusts journaling of MQTs using the MQT control file;
- and
- (C) non-transitory computer-recordable media bearing the journal receiver and data propagator.
3 more elements
Dependencies are inferred from the claim text.