IP Library Granted Patent US 10,776,506
Granted Patent B2
US 10,776,506 · App. 14/980,459 · Granted Sep 15, 2020

Self-monitoring time series database system that enforces usage policies

Inventors: Thomas Nicholas Valine (San Jose, CA); Bhinav Sura (San Mateo, CA); Rajavardhan Sarkapally (San Francisco, CA); Dilip Devaraj (Colma, CA)
Assignee: salesforce.com, inc.
G06F21/6227G06F16/958
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 10,776,506
App. No.
14/980,459
Granted
Sep 15, 2020
Kind
B2
Abstract

A self-monitoring time series database system which enforces usage policies is described. A time series database system receives an alert trigger condition for a system user, wherein the system user is associated with multiple time series data points corresponding to multiple subsystems of the time series database system. The time series database system aggregates the multiple time series data points in an internal time series data point, which is internal to the time series database system, associated with the system user. The time series database system evaluates whether the internal time series data point associated with the system user meets the alert trigger condition. The time series database system reduces a level of access by the system user to the time series database system in response to an evaluation that the internal time series data point associated with the system user meets the alert trigger condition.

Claims (56)

1. A system for a self-monitoring time series database system which enforces usage policies, the system comprising:

one or more processors; and

a non-transitory computer readable medium storing a plurality of instructions, which when executed, cause the one or more processors to:

receive, by a time series database system that has multiple subsystems, an alert trigger condition for a threshold-exceeding level of aggregated access to the multiple subsystems by a single user who is associated with multiple time series data points corresponding to the multiple subsystems;

aggregate, by the time series database system, the multiple time series data points in an internal time series data point associated with the single user, the internal series data point being internal to the time series database system;

determine, by the time series database system, whether the internal time series data point, associated with the single user exceeds the threshold level; and

reduce, by the time series database system, a level of aggregated access by the single user to at least one of the multiple subsystems of the time series database system in response to a determination that the internal time series data point associated with the single user exceeds the threshold-exceeding level of aggregated access to the multiple subsystems by the single user; and

increase the level of aggregated access by the single user to at least one of the multiple subsystems of the time series database system in response to one of a system administrator and a fixed time period expiration, when the single user's access is not indefinitely suspended.

2. The system of claim 1 , wherein receiving the alert trigger condition comprises receiving the alert trigger condition from at least one of a system administrator and a configuration file.

3. The system of claim 1 , wherein the alert trigger condition comprises at least one of a system threshold associated with the time series database system and a subsystem threshold associated with at least one of the multiple time series data points corresponding to at least one of the multiple subsystems of the time series database system.

4. The system of claim 1 , wherein aggregating the multiple time series data points in the internal time series data point associated with the single user comprises:

creating a global counter;

aggregating the multiple time series data points in the global counter;

disabling subsystem aggregation to the global counter;

copying a value in the global counter to a data structure;

resetting the global counter;

enabling subsystem aggregation to the global counter; and

persisting the value in the data structure to the internal time series data point associated with the single user.

5. The system of claim 1 , wherein reducing the level of aggregated access by the single user is based on a reduction in the level of aggregated access by the single user to at least one of the time series database system and at least one of the multiple subsystems of the time series database system for one of a fixed time period and an indefinite period of time.

6. The system of claim 1 , wherein reducing the level of aggregated access by the single user comprises a reduction in the level of aggregated access by a plurality of single users to at least one of the time series database system and at least one of the multiple subsystems of the time series database system.

7. A computer program product comprising computer-readable program code to be executed by one or more processors when retrieved from a non-transitory computer-readable medium, the program code including instructions to:

receive, by a time series database system that has multiple subsystems, an alert trigger condition for a threshold-exceeding level of aggregated access to the multiple subsystems by a single user who is associated with multiple time series data points corresponding to the multiple subsystems;

aggregate, by the time series database system, the multiple time series data points in an internal time series data point associated with the single user, the internal series data point being internal to the time series database system;

determine, by the time series database system, whether the internal time series data point, associated with the single user exceeds the threshold level; and

reduce, by the time series database system, a level of aggregated access by the single user to at least one of the multiple subsystems of the time series database system in response to a determination that the internal time series data point associated with the single user exceeds the threshold-exceeding level of aggregated access to the multiple subsystems by the single user; and

increase the level of aggregated access by the single user to at least one of the multiple subsystems of the time series database system in response to one of a system administrator and a fixed time period expiration, when the single user's access is not indefinitely suspended.

8. The computer program product of claim 7 , wherein receiving the alert trigger condition comprises receiving the alert trigger condition from at least one of a system administrator and a configuration file.

9. The computer program product of claim 7 , wherein the alert trigger condition comprises at least one of a system threshold associated with the time series database system and a subsystem threshold associated with at least one of the multiple time series data points corresponding to at least one of the multiple subsystems of the time series database system.

10. The computer program product of claim 7 , wherein aggregating the multiple time series data points in the internal time series data point associated with the single user comprises:

creating a global counter;

aggregating the multiple time series data points in the global counter;

disabling subsystem aggregation to the global counter;

copying a value in the global counter to a data structure;

resetting the global counter;

enabling subsystem aggregation to the global counter; and

persisting the value in the data structure to the internal time series data point associated with the single user.

11. The computer program product of claim 7 , wherein reducing the level of aggregated access by the single user is based on a reduction in the level of aggregated access by the single user to at least one of the time series database system and at least one of the multiple subsystems of the time series database system for one of a fixed time period and an indefinite period of time.

12. The computer program product of claim 7 , wherein reducing the level of aggregated access by the single user comprises a reduction in the level of aggregated access by a plurality of single user's to at least one of the time series database system and at least one of the multiple subsystems of the time series database system.

13. A method for a self-monitoring time series database system which enforces usage policies, the method comprising:

receiving, by a time series database system that has multiple subsystems, an alert trigger condition for a threshold-exceeding level of aggregated access to the multiple subsystems by a single user who is associated with a multiple time series data points corresponding to the multiple subsystems;

aggregating, by the time series database system, the multiple time series data points in an internal time series data point associated with the single user, the internal series data point being internal to the time series database system;

determining, by the time series database system, whether the internal time series data point, associated with the single user exceeds the threshold level; and

reducing, by the time series database system, a level of aggregated access by the single user to at least one of the multiple subsystems of the time series database system in response to a determination that the internal time series data point associated with the single user exceeds the threshold-exceeding level of aggregated access to the multiple subsystems by the single user; and

increasing the level of aggregated access by the single user to at least one of the multiple subsystems of the time series database system in response to one of a system administrator and a fixed time period expiration, when the single user's access is not indefinitely suspended.

14. The method of claim 13 , wherein receiving the alert trigger condition comprises receiving the alert trigger condition from at least one of a system administrator and a configuration file.

15. The method of claim 13 , wherein the alert trigger condition comprises at least one of a system threshold associated with the time series database system and a subsystem threshold associated with at least one of the multiple time series data points corresponding to at least one of the multiple subsystems of the time series database system.

16. The method of claim 13 , wherein aggregating the multiple time series data points in the internal time series data point associated with the single user comprises:

creating a global counter;

aggregating the multiple time series data points in the global counter;

disabling subsystem aggregation to the global counter;

copying a value in the global counter to a data structure;

resetting the global counter;

enabling subsystem aggregation to the global counter; and

persisting the value in the data structure to the internal time series data point associated with the single user.

17. The method of claim 13 , wherein reducing the level of aggregated access by the single user is based on a reduction in the level of aggregated access by the single user to at least one of the time series database system and at least one of the multiple subsystems of the time series database system for one of a fixed time period and an indefinite period of time.

18. The method of claim 13 , wherein reducing the level of aggregated access by the single user comprises a reduction in the level of aggregated access by a plurality of single users to at least one of the time series database system and at least one of the multiple subsystems of the time series database system.

Assignments (2)
CHANGE OF NAME Recorded Nov 21, 2024
From: SALESFORCE.COM, INC.
To: SALESFORCE, INC.
Reel/Frame 069430/0944 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 28, 2015
From: VALINE, THOMAS NICHOLAS; SURA, BHINAV; SARKAPALLY, RAJAVARDHAN; DEVARAJ, DILIP
To: SALESFORCE.COM, INC.
Reel/Frame 037366/0875 →
Continuity (1)
Related Publication 20170185797A1 · Jun 29, 2017