IP Library Granted Patent US 11,886,610
Granted Patent B1
US 11,886,610 · App. 18/207,656 · Granted Jan 30, 2024

Cloud environment database log analyzer with risk signature detection

Inventors: Ajay Agrawal (Bangalore, IN); Yang Zhang (Los Altos, CA)
Assignee: Normalyze, Inc.
G06F21/6227G06F16/9038H04L63/1425
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,886,610
App. No.
18/207,656
Granted
Jan 30, 2024
Kind
B1
Abstract

The technology disclosed relates to analysis of security posture of a cloud environment. In particular, the disclosed technology relates to a system and method that detects a triggering criterion and, in response to the triggering criterion, automatically discovers a plurality of databases in the cloud environment. An orchestration engine is configured to deploy a plurality of log analyzer microservices on the plurality of databases, each log analyzer microservice, of the plurality of log analyzer microservices, being configured to scan a respective database log that represents database activities on a respective database of the plurality of databases. Analysis results are received from the plurality of log analyzer microservices, the analysis results represent detection of at least one of a performance criterion or a security criterion in one or more databases of the plurality of databases. An action signal representing the analysis results is generated.

Claims (60)

1. A computer-implemented method of detecting security posture of a cloud environment, the computer-implemented method comprising:

detecting a triggering criterion;

in response to the triggering criterion, automatically discovering a plurality of databases in the cloud environment, wherein automatically discovering the plurality of databases comprises accessing a cloud application programming interface (API) exposed by the cloud environment and executing a query through the cloud API that returns database identifiers that identify the plurality of databases that have logging enabled;

configuring an orchestration engine to deploy a plurality of log analyzer microservices on the plurality of databases,

each log analyzer microservice, of the plurality of log analyzer microservices, being configured to scan a respective database log that represents database activities on a respective database of the plurality of databases;

receiving analysis results from the plurality of log analyzer microservices, the analysis results representing detection of at least one of a performance criterion or a security criterion in one or more databases of the plurality of databases; and

generating an action signal representing the analysis results.

2. The computer-implemented method of claim 1 , wherein executing the query comprises:

obtaining database configuration information, for each database, indicating whether a database log generator is enabled on the database; and

identifying the plurality of databases based on the database configuration information.

3. The computer-implemented method of claim 2 , and further comprising deploying the plurality of log analyzer microservices on the plurality of databases in parallel.

4. The computer-implemented method of claim 1 , and further comprising:

receiving a request to on-board a cloud account in the cloud environment, wherein the cloud account includes the plurality of databases, each respective database, of the plurality of databases, including a database log generator configured to generate the respective database log that represents the database activities on the respective database; and

detecting the triggering criterion based on the on-boarding of the cloud account.

5. The computer-implemented method of claim 1 , wherein the respective database log comprises at least one of an audit log or a transaction log.

6. The computer-implemented method of claim 5 , wherein the respective database log comprises a slow query log that records details of queries that take more than a threshold amount of time to execute on the respective database.

7. The computer-implemented method of claim 6 , wherein each log analyzer microservice is configured to analyze the respective database log based on one or more of:

a query execution time,

a sensitive data profile,

a user permission associated with a data access request in the respective database, or

a time series pattern of queries representing at least one of a query count, a query type, or a query user.

8. The computer-implemented method of claim 1 , and further comprising:

detecting at least one database issue based on the at least one of a performance criterion or a security criterion, wherein generating the action signal comprises controlling a remedial action component to perform a remedial action relative to the database issue.

9. The computer-implemented method of claim 8 , wherein the at least one database issue comprises a malicious query.

10. The computer-implemented method of claim 9 , wherein the malicious query comprises a query to sensitive data that is executed more than a threshold number of times.

11. The computer-implemented method of claim 1 , and further comprising determining that the database activities match a pre-defined risk signature.

12. A computing system comprising:

at least one processor; and

memory storing instructions executable by the at least one processor, wherein the instructions, when executed, cause the computing system to:

detect a triggering criterion;

in response to the triggering criterion, automatically discover a plurality of databases in a cloud environment bar accessing a cloud application programming interface (API) exposed by the cloud environment and executing a query through the cloud API that returns database identifiers that identify the plurality of databases that have logging enabled;

configure an orchestration engine to deploy a plurality of log analyzer microservices on the plurality of databases,

each log analyzer microservice, of the plurality of log analyzer microservices, being configured to scan a respective database log that represents database activities on a respective database of the plurality of databases;

receive analysis results from the plurality of log analyzer microservices, the analysis results representing detection of at least one of a performance criterion or a security criterion in one or more databases of the plurality of databases; and

generate an action signal representing the analysis results.

13. The computing system of claim 12 , wherein the instructions, when executed, cause the computing system to:

obtain, through the cloud API, database configuration information, for each database, indicating whether a database log generator is enabled on the database; and

identify the plurality of databases based on the database configuration information.

14. The computing system of claim 12 , wherein the instructions, when executed, cause the computing system to:

deploy the plurality of log analyzer microservices on the plurality of databases in parallel.

15. The computing system of claim 12 , wherein the instructions, when executed, cause the computing system to:

determine that the database activities match a pre-defined risk signature comprising one or more of:

a query execution time,

a sensitive data profile, or

a user permission associated with a data access request in the respective database.

16. A computer-implemented method of detecting security posture of a cloud environment, the computer-implemented method comprising:

automatically discovering a plurality of databases, in response to a triggering criterion in the cloud environment, by accessing a cloud application programming interface (API) exposed by the cloud environment and executing a query through the cloud API that returns database identifiers that identify the plurality of databases that have logging enabled;

receiving a request to analyze a particular database, from among the plurality of databases, in the cloud environment;

parsing, using a loci analyzer microservice from among a plurality of microservices that were deployed by an orchestration engine on the plurality of databases, a database query log corresponding to the particular database to obtain a parser result, wherein the database query log includes a set of log entries representing database queries on the particular database, and each log entry of the set of log entries identifies a requestor and a target dataset on the particular database;

based on parsing the database query log, identifying one or more query instance that match a pre-defined risk signature;

generating an analysis result by the log analyzer microservice representing the one or more query instance that match the pre-defined risk signature; and

generating an output representing the analysis results.

17. The computer-implemented method of claim 16 , wherein the pre-defined risk signature defines a threshold level of access attempts of sensitive data by a particular requestor.

18. The computer-implemented method of claim 16 , wherein the pre-defined risk signature comprises one or more of:

a query execution time,

a sensitive data profile, or

a user permission associated with a data access in the particular database.

19. The computer-implemented method of claim 16 , and further comprising:

detecting at least one database issue based on at least one of a performance criterion or a security criterion; and

performing a remedial action relative to the database issue.

Assignments (4)
SECOND LIEN INTELLECTUAL PROPERTY SECURITY AGREEMENT Recorded Dec 8, 2025
From: PROOFPOINT, INC.
To: U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION, AS COLLATERAL AGENT
Reel/Frame 073889/0677 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jul 7, 2025
From: NORMALYZE, INC.
To: PROOFPOINT, INC.
Reel/Frame 071618/0634 →
SECURITY INTEREST Recorded Feb 19, 2025
From: NORMALYZE, INC.
To: GOLDMAN SACHS BANK USA, AS COLLATERAL AGENT
Reel/Frame 070254/0844 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 8, 2023
From: AGARWAL, AJAY; ZHANG, YANG
To: NORMALYZE, INC
Reel/Frame 063901/0453 →