Hierarchical database monitoring
AssigneeUnitedHealth Group Incorporated
InventorsNick Rooda, Matthew Rudd, Edward Krenz
Life of this patent
Estimating the term…
Abstract
There is a need for more effective and efficient hierarchical database monitoring. This need can be addressed by, for example, solutions for performing/executing hierarchical database monitoring in an effective and efficient manner. In one example, a method includes identifying related hierarchical entities for each hierarchical entity; identifying an entity tracking data object for each hierarchical entity; updating the entity tracking data objects; generating a database monitoring data object based at least in part on the updated entity tracking data objects; and performing monitoring of the hierarchical database based at least in part on the database monitoring data object.
Claims20
A computer-implemented for generating a database monitoring data object for a hierarchical database comprising entity-related data associated with a plurality of hierarchical entities, the computer-implemented method comprising:
- for each hierarchical entity of the plurality of hierarchical entities, identifying one or more related hierarchical entities of the plurality of hierarchical entities, wherein the one or more related hierarchical entities comprise the corresponding hierarchical entity and any hierarchical entities of the plurality of hierarchical entities that depend from the corresponding hierarchical entity;
- for each hierarchical entity of the plurality of hierarchical entities, identifying an entity tracking data object of a plurality of entity tracking data objects, wherein the entity tracking data object comprises an entity invalidation status for the corresponding hierarchical entity;
- for each hierarchical entity of the plurality of hierarchical entities whose entity invalidation status indicates a valid entity status, updating the plurality of entity tracking data objects by:
- (a) determining, based at least in part on the entity-related data, an entity invalidation condition associated with the corresponding hierarchical entity,
- (b) determining whether the entity invalidation condition associated with the corresponding hierarchical entity indicates an invalid entity condition or a modified entity condition,
- (c) responsive to determining that the entity invalidation condition associated with the corresponding hierarchical entity indicates the invalid entity condition, performing a non-replicating invalidation of the corresponding hierarchical entity, wherein performing the non-replicating invalidation of the corresponding hierarchical entity comprises updating each entity tracking data object for a related hierarchical entity of the one or more related hierarchical entities associated with the corresponding hierarchical entity to invalidate the related hierarchical entity, and
- (d) responsive to determining that the entity invalidation condition associated with the corresponding hierarchical entity indicates the modified entity condition, performing a replicating invalidation of the corresponding hierarchical entity, wherein performing the replicating invalidation of the corresponding hierarchical entity comprises updating each entity tracking data object for a related hierarchical entity of the one or more related hierarchical entities associated with the corresponding hierarchical entity to invalidate the related hierarchical entity, generating a modified entity tracking data object for the corresponding hierarchical entity, and generating a replicated tracking data object for each related hierarchical entity of the one or more related hierarchical entities associated with the corresponding hierarchical entity other than the corresponding hierarchical entity;
- and
- subsequent to updating the plurality of entity tracking data objects:
- (a) generating the database monitoring data object based at least in part on the plurality of entity tracking data objects, and
- (b) performing monitoring of the hierarchical database based at least in part on the database monitoring data object.
An apparatus for generating a database monitoring data object for a hierarchical database comprising entity-related data associated with a plurality of hierarchical entities, the apparatus comprising at least one processor and at least one memory including program code, the at least one memory and the program code configured to, with the processor, cause the apparatus to at least:
- for each hierarchical entity of the plurality of hierarchical entities, identify one or more related hierarchical entities of the plurality of hierarchical entities, wherein the one or more related hierarchical entities comprise the corresponding hierarchical entity and any hierarchical entities of the plurality of hierarchical entities that depend from the corresponding hierarchical entity;
- for each hierarchical entity of the plurality of hierarchical entities, identify an entity tracking data object of a plurality of entity tracking data objects, wherein the entity tracking data object comprises an entity invalidation status for the corresponding hierarchical entity;
- for each hierarchical entity of the plurality of hierarchical entities whose entity invalidation status indicates a valid entity status, update the plurality of entity tracking data objects by:
- (a) determining, based at least in part on the entity-related data, an entity invalidation condition associated with the corresponding hierarchical entity,
- (b) determining whether the entity invalidation condition associated with the corresponding hierarchical entity indicates an invalid entity condition or a modified entity condition,
- (c) responsive to determining that the entity invalidation condition associated with the corresponding hierarchical entity indicates the invalid entity condition, performing a non-replicating invalidation of the corresponding hierarchical entity, wherein performing the non-replicating invalidation of the corresponding hierarchical entity comprises updating each entity tracking data object for a related hierarchical entity of the one or more related hierarchical entities associated with the corresponding hierarchical entity to invalidate the related hierarchical entity, and
- (d) responsive to determining that the entity invalidation condition associated with the corresponding hierarchical entity indicates the modified entity condition, performing a replicating invalidation of the corresponding hierarchical entity, wherein performing the replicating invalidation of the corresponding hierarchical entity comprises updating each entity tracking data object for a related hierarchical entity of the one or more related hierarchical entities associated with the corresponding hierarchical entity to invalidate the related hierarchical entity, generating a modified entity tracking data object for the corresponding hierarchical entity, and generating a replicated tracking data object for each related hierarchical entity of the one or more related hierarchical entities associated with the corresponding hierarchical entity other than the corresponding hierarchical entity;
- and
- subsequent to updating the plurality of entity tracking data objects:
- (a) generate the database monitoring data object based at least in part on the plurality of entity tracking data objects, and
- (b) perform monitoring of the hierarchical database based at least in part on the database monitoring data object.
A computer program product for generating a database monitoring data object for a hierarchical database comprising entity-related data associated with a plurality of hierarchical entities, the computer program product comprising at least one non-transitory computer-readable storage medium having computer-readable program code portions stored therein, the computer-readable program code portions configured to:
- for each hierarchical entity of the plurality of hierarchical entities, identify one or more related hierarchical entities of the plurality of hierarchical entities, wherein the one or more related hierarchical entities comprise the corresponding hierarchical entity and any hierarchical entities of the plurality of hierarchical entities that depend from the corresponding hierarchical entity;
- for each hierarchical entity of the plurality of hierarchical entities, identify an entity tracking data object of a plurality of entity tracking data objects, wherein the entity tracking data object comprises an entity invalidation status for the corresponding hierarchical entity;
- for each hierarchical entity of the plurality of hierarchical entities whose entity invalidation status indicates a valid entity status, update the plurality of entity tracking data objects by:
- (a) determining, based at least in part on the entity-related data, an entity invalidation condition associated with the corresponding hierarchical entity,
- (b) determining whether the entity invalidation condition associated with the corresponding hierarchical entity indicates an invalid entity condition or a modified entity condition,
- (c) responsive to determining that the entity invalidation condition associated with the corresponding hierarchical entity indicates the invalid entity condition, performing a non-replicating invalidation of the corresponding hierarchical entity, wherein performing the non-replicating invalidation of the corresponding hierarchical entity comprises updating each entity tracking data object for a related hierarchical entity of the one or more related hierarchical entities associated with the corresponding hierarchical entity to invalidate the related hierarchical entity, and
- (d) responsive to determining that the entity invalidation condition associated with the corresponding hierarchical entity indicates the modified entity condition, performing a replicating invalidation of the corresponding hierarchical entity, wherein performing the replicating invalidation of the corresponding hierarchical entity comprises updating each entity tracking data object for a related hierarchical entity of the one or more related hierarchical entities associated with the corresponding hierarchical entity to invalidate the related hierarchical entity, generating a modified entity tracking data object for the corresponding hierarchical entity, and generating a replicated tracking data object for each related hierarchical entity of the one or more related hierarchical entities associated with the corresponding hierarchical entity other than the corresponding hierarchical entity;
- and
- subsequent to updating the plurality of entity tracking data objects:
- (a) generate the database monitoring data object based at least in part on the plurality of entity tracking data objects, and
- (b) perform monitoring of the hierarchical database based at least in part on the database monitoring data object.
Dependencies are inferred from the claim text.