# US 2019/0171633 A1 · Multi-system operation audit log

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2019/0171633 A1
- Document ID: US20190171633A1
- Status: Published application
- Kind: A1
- Application number: 16/231,918
- Filed: 2018-12-24
- Published: 2019-06-06
- Earliest claimed: 2017-11-13
- Assignees: LendingClub Corporation
- Applicants: LendingClub Corporation
- Inventors: Prateek Demla; Igor Petrunya; Dmitry Kondratenko
- Web page: https://patentgrep.com/patent/US20190171633A1

## CPC

- G06F 16/2379: {Updates performed during online database operations; commit processing}
- G06F 16/2358: {Change logging, detection, and notification (replication G06F16/27)}
- G06F 16/2365: {Ensuring data consistency and integrity}
- G06N 20/00: Machine learning
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- G06N: COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS

## Abstract

Techniques are provided for recording, in an audit log data store, log records that satisfy one or more audit log rules. Audit log rules may be associated with one or more context attributes. Specifically, based on the context attribute of a given rule, embodiments store, in the audit log data store, additional log records that are associated with the context attribute value from log records that satisfied the rule. Because a context attribute may span multiple systems that implement a multi-system operation, the information in the audit log data store may include cross-system contextual information for changes that are of interest to administrators. The audit log data store may be efficiently queried to provide information regarding multi-system operations because of the targeted nature of the audit log data gathering techniques. Automatically-generated indexes on audit log data provide additional efficiency gains for executing queries over the audit log data.

## Claims

### Claim 1

A computer-executed method, comprising:
causing each system, of a plurality of systems involved in executing a particular operation instance of a particular type of multi-system operation, to generate log records that reflect work done by the respective system as part of executing a respective portion of the particular operation instance;
wherein the work done by each system of the plurality of systems includes storing, as part of its respective portion of the particular operation instance, a respective correlation context associated with the particular operation instance;
determining that one or more log records, generated by one or more of the plurality of systems, satisfy a particular audit log rule associated with a context attribute;
in response to determining that the one or more log records satisfy the particular audit log rule:
determining a particular value, for the context attribute, contained in the one or more log records;
automatically storing the one or more log records into an audit log data store,
identifying one or more additional log records that are associated with the particular value for the context attribute, and
automatically storing the one or more additional log records in the audit log data store;
receiving, from a user, a query over the audit log data store; and
returning query results for the query to the user;
wherein the method is performed by one or more computing devices.

### Claim 2 (depends on 1)

The computer-executed method of claim 1, wherein:
the one or more log records were generated by a particular system of the plurality of systems; and
the one or more additional log records were generated from one or more other systems, of the plurality of systems, other than the particular system.

### Claim 3 (depends on 2)

The computer-executed method of claim 2, wherein:
the particular system maintains a database of a first type, and at least one of the one or more other systems maintains a database of a second type; and
the first type is different than the second type.

### Claim 4 (depends on 1)

The computer-executed method of claim 1, wherein:
the respective correlation context stored by each system of the plurality of systems includes at least a particular correlation identifier that uniquely identifies the particular operation instance; and
the context attribute is one or more of: a common correlation identifier, a common user identifier, a common timestamp, a timestamp within a particular range of timestamps, or a common service identifier.

### Claim 5 (depends on 1)

The computer-executed method of claim 1, further comprising:
automatically generating particular index data that associates the particular value of the context attribute with both of the one or more log records and the one or more additional log records; and
after receiving the query over the audit log data store, automatically generating the query results based on an index data structure that stores the particular index data.

### Claim 6 (depends on 1)

The method of claim 1, wherein:
the one or more log records are published in one or more event streams;
an auditor service detects event records from the one or more event streams; and
automatically storing the one or more log records into the audit log data store comprises:
automatically detecting one or more event records containing the one or more log records, and
automatically extracting, from the one or more event records, information for the one or more log records; and
storing the one or more log records in the audit log data store based on the extracted information.

### Claim 7 (depends on 1)

The method of claim 1, wherein:
the respective correlation context stored by each system of the plurality of systems includes at least a particular correlation identifier that uniquely identifies the particular operation instance;
the context attribute is a common correlation identifier; and
the one or more log records record one or more changes were (a) caused by the particular operation instance, and (b) made to a particular database that is maintained by a particular system of the plurality of systems;
the method further comprises:
identifying one or more associated log records, which record changes made to the particular database, and which are associated with the one or more log records,
wherein the one or more associated log records include a particular correlation context for the particular operation instance,
identifying the particular value for the context attribute based on the particular correlation identifier in the particular correlation context.

### Claim 8 (depends on 7)

The method of claim 7 wherein the one or more associated log records are associated with the one or more log records based on a common transaction identifier.

### Claim 9 (depends on 1)

The method of claim 1 wherein:
the audit log data store is maintained by a database management system;
a set of rules for the audit log data store, which includes the particular audit log rule, is stored in a rules table maintained by the database management system;
the method further comprises updating the set of rules for the audit log data store by causing the database management system to update the rules table.

### Claim 10

A computer-executed method, comprising:
causing each system, of a plurality of systems involved in executing a particular operation instance of a particular type of multi-system operation, to generate log records that reflect work done by the respective system as part of executing a respective portion of the particular operation instance; wherein the work done by each system of the plurality of systems includes storing, as part of its respective portion of the particular operation instance, a respective correlation context associated with the particular operation instance; wherein the respective correlation context stored by each system of the plurality of systems includes at least a particular correlation identifier that uniquely identifies the particular operation instance;
determining that a set of operation log records, all of which are associated with the particular correlation identifier, satisfies a particular audit log rule based on the particular operation instance exhibiting anomalous behavior;
in response to determining that the set of operation log records satisfies the particular audit log rule, automatically storing the set of operation log records into an audit log data store;
receiving, from a user, a query over the audit log data store; and
returning query results for the query to the user;
wherein the method is performed by one or more computing devices.

### Claim 11 (depends on 10)

The computer-executed method of claim 10, further comprising determining whether the set of operation log records exhibit anomalous behavior by:
generating a call graph for the particular operation instance based, at least in part, on sequence numbers in the set of operation log records; and
comparing the call graph for the particular operation instance to expected call graph features for the particular type of multi-system operation to determine whether the particular operation instance exhibits anomalous behavior.

### Claim 12 (depends on 10)

The computer-executed method of claim 10, further comprising:
determining that the particular operation instance is ripe for analysis based, at least in part, on the particular type of the particular operation instance;
wherein determining that the set of operation log records satisfies the particular audit log rule is performed in response to determining that the particular operation instance is ripe for analysis.

### Claim 13 (depends on 10)

The computer-executed method of claim 10, wherein:
the particular audit log rule is associated with a context attribute;
the method further comprises:
determining a particular value, for the context attribute, contained in the set of operation log records,
identifying one or more additional log records that are associated with the particular value for the context attribute, and
automatically storing the one or more additional log records in the audit log data store.

### Claim 14 (depends on 10)

The computer-executed method of claim 10, wherein the set of operation log records were generated by two or more systems of the plurality of systems.

### Claim 15

One or more non-transitory computer-readable media storing instructions which, when executed by one or more processors, cause:
causing each system, of a plurality of systems involved in executing a particular operation instance of a particular type of multi-system operation, to generate log records that reflect work done by the respective system as part of executing a respective portion of the particular operation instance;
wherein the work done by each system of the plurality of systems includes storing, as part of its respective portion of the particular operation instance, a respective correlation context associated with the particular operation instance;
determining that one or more log records, generated by one or more of the plurality of systems, satisfy a particular audit log rule associated with a context attribute;
in response to determining that the one or more log records satisfy the particular audit log rule:
determining a particular value, for the context attribute, contained in the one or more log records;
automatically storing the one or more log records into an audit log data store,
identifying one or more additional log records that are associated with the particular value for the context attribute, and
automatically storing the one or more additional log records in the audit log data store;
receiving, from a user, a query over the audit log data store; and
returning query results for the query to the user.

### Claim 16 (depends on 15)

The non-transitory computer-readable media of claim 15, wherein:
the one or more log records were generated by a particular system of the plurality of systems; and
the one or more additional log records were generated from one or more other systems, of the plurality of systems, other than the particular system.

### Claim 17 (depends on 16)

The non-transitory computer-readable media of claim 16, wherein:
the particular system maintains a database of a first type, and at least one of the one or more other systems maintains a database of a second type; and
the first type is different than the second type.

### Claim 18 (depends on 15)

The non-transitory computer-readable media of claim 15, wherein:
the respective correlation context stored by each system of the plurality of systems includes at least a particular correlation identifier that uniquely identifies the particular operation instance; and
the context attribute is one or more of: a common correlation identifier, a common user identifier, a common timestamp, a timestamp within a particular range of timestamps, or a common service identifier.

### Claim 19 (depends on 15)

The non-transitory computer-readable media of claim 15, wherein the instructions further comprise instructions which, when executed by one or more processors, cause:
automatically generating particular index data that associates the particular value of the context attribute with both of the one or more log records and the one or more additional log records; and
after receiving the query over the audit log data store, automatically generating the query results based on an index data structure that stores the particular index data.

### Claim 20

One or more non-transitory computer-readable media storing instructions which, when executed by one or more processors, cause:
causing each system, of a plurality of systems involved in executing a particular operation instance of a particular type of multi-system operation, to generate log records that reflect work done by the respective system as part of executing a respective portion of the particular operation instance; wherein the work done by each system of the plurality of systems includes storing, as part of its respective portion of the particular operation instance, a respective correlation context associated with the particular operation instance; wherein the respective correlation context stored by each system of the plurality of systems includes at least a particular correlation identifier that uniquely identifies the particular operation instance;
determining that a set of operation log records, all of which are associated with the particular correlation identifier, satisfies a particular audit log rule based on the particular operation instance exhibiting anomalous behavior;
in response to determining that the set of operation log records satisfies the particular audit log rule, automatically storing the set of operation log records into an audit log data store;
receiving, from a user, a query over the audit log data store; and
returning query results for the query to the user.

### Claim 21 (depends on 20)

The non-transitory computer-readable media of claim 20, wherein the instructions further comprise instructions which, when executed by one or more processors, cause determining whether the set of operation log records exhibit anomalous behavior by:
generating a call graph for the particular operation instance based, at least in part, on sequence numbers in the set of operation log records; and
comparing the call graph for the particular operation instance to expected call graph features for the particular type of multi-system operation to determine whether the particular operation instance exhibits anomalous behavior.

### Claim 22 (depends on 20)

The non-transitory computer-readable media of claim 20, wherein the instructions further comprise instructions which, when executed by one or more processors, cause:
determining that the particular operation instance is ripe for analysis based, at least in part, on the particular type of the particular operation instance;
wherein determining that the set of operation log records satisfies the particular audit log rule is performed in response to determining that the particular operation instance is ripe for analysis.
