System, method and computer program product for monitoring data activity utilizing a shared data store

• US 10,055,328 B2
• Filed: 03/27/2017
• Issued: 08/21/2018
• Est. Priority Date: 02/24/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Yancey, Scott, Hansma, Scott
• Primary Examiner(s): Pollack, Melvin H
• Application Number:
  US15/470,858
• Publication Number:
  US 20170212823A1
• Time in Patent Office: 512 Days
• Field of Search: 707688
• CPC Class Codes: G06F 11/3006 where the computing system is distributed, e.g. networked systems, clusters, multiprocessor systems multiprogramming arrangements G06F9/46; allocation of resources G06F9/50
• CPC Class Codes: G06F 11/3438 monitoring of user actions tracking the activity of the user H04L67/535
• CPC Class Codes: G06F 12/0813 with a network or matrix configuration
• CPC Class Codes: G06F 15/173 using an interconnection network, e.g. matrix, shuffle, pyramid, star, snowflake
• CPC Class Codes: G06F 16/219 Managing data history or versioning querying versioned data G06F16/2474; querying temporal data G06F16/2477
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 2212/60 Details of cache memory
• CPC Class Codes: G06F 2212/62 Details of cache specific to multiprocessor cache arrangements
• CPC Class Codes: H04L 43/067 using time frame reporting
• CPC Class Codes: H04L 43/0817 by checking functioning
• CPC Class Codes: H04L 43/0876 Network utilisation, e.g. volume of load or congestion level
• CPC Class Codes: H04L 67/306 User profiles
• CPC Class Codes: H04L 67/535 Tracking the activity of the user network monitoring arrangements H04L43/00; recording of computer activity G06F11/34
• CPC Class Codes: H04L 67/568 Storing data temporarily at an intermediate stage, e.g. caching

Abstract

In accordance with embodiments, there are provided mechanisms and methods for monitoring data activity utilizing a shared data store. These mechanisms and methods for monitoring data activity utilizing a shared data store can enable enhanced data monitoring, more efficient data storage, improved system resource utilization, etc.

Claims

1. A computer program product, comprising a non-transitory computer usable medium having a computer readable program code embodied therein, the computer readable program code adapted to be executed by a computer to implement a method comprising:

identifying, by a database system that includes a plurality of servers and a distributed memory cache shared by the servers, data activity performed across the servers, the data activity including events associated with a user system coupled to the database system, wherein identifying the data activity comprises activity tracking using a request count within the distributed memory cache;

storing, by the database system, first information indicating the identified data activity;

following the storing of the first information, moving a portion of the first information to the distributed memory cache;

generating, by the database system, second information associated with the data activity from contents of the distributed memory cache, wherein the generated second information is based on a total count of activity indicated by the request count; and

providing the user system with access to the generated second information.

2. The computer program product of claim 1, wherein the data activity is associated with one or more users associated with the user system.

3. The computer program product of claim 1, wherein the data activity is associated with an application available to the user system from the database system.

4. The computer program product of claim 1, wherein the database system includes a multi-tenant database system.

5. The computer program product of claim 1, wherein the data activity relates to data that is transferred to the database system.

6. The computer program product of claim 1, wherein the data activity relates to application programming interface (API) calls made to the database system.

7. The computer program product of claim 1, wherein the portion of the first information includes data activity performed during a most recent predetermined period of time.

8. The computer program product of claim 1, further comprising:

storing, within a database of the database system, the first information; and

moving the portion of the first information from the database to the distributed memory cache.

9. A method, comprising:

identifying, by a database system that includes a plurality of servers and a distributed memory cache shared by the servers, data activity performed across the servers, the data activity including events associated with a user system coupled to the database system, wherein identifying the data activity comprises activity tracking using a request count within the distributed memory cache;

storing, by the database system, first information indicating the identified data activity;

following the storing of the first information, moving a portion of the first information to the distributed memory cache;

generating, by the database system, second information associated with the data activity from contents of the distributed memory cache, wherein the generated second information is based on a total count of activity indicated by the request count; and

providing the user system with access to the generated second information.

19. The method of claim 9, wherein the portion of the first information includes data activity performed during a most recent predetermined period of time.

20. The method of claim 19, further comprising:

storing, within a database of the database system, the first information; and

moving the portion of the first information from the database to the distributed memory cache.

10. An apparatus, comprising:

a processor of a database system, the database system including a plurality of servers and a distributed memory cache shared by the servers, the processor to;

identify data activity performed across the servers, the data activity including events associated with a user system coupled to the database system, wherein identify the data activity comprises activity tracking using a request count within the distributed memory cache;

store first information indicating the identified data activity;

following storage of the first information, move a portion of the first information to the distributed memory cache;

generate second information associated with the data activity from contents of the distributed memory cache, wherein the generated second information is based on a total count of activity indicated by the request count; and

provide the user system with access to the generated second information.

12. The apparatus of claim 10, wherein the data activity is associated with one or more users associated with the user system.

13. The apparatus of claim 10, wherein the data activity is associated with an application available to the user system from the database system.

14. The apparatus of claim 10, wherein the database system includes a multi-tenant database system.

15. The apparatus of claim 10, wherein the data activity relates to data that is transferred to the database system.

16. The apparatus of claim 10, wherein the data activity relates to application programming interface (API) calls made to the database system.

17. The apparatus of claim 10, wherein the portion of the first information includes data activity performed during a most recent predetermined period of time.

18. The apparatus of claim 10, the processor further to:

store, within a database of the database system, the first information; and

move the portion of the first information from the database to the distributed memory cache.

11. A method for transmitting code for use in a multi-tenant database system on a transmission medium, the multi-tenant database system including a plurality of servers and a distributed memory cache shared by the servers, the method comprising:

transmitting code for identifying, by the multi-tenant database system, data activity performed across the servers, the data activity including events associated with a user system coupled to the multi-tenant database system, wherein identifying the data activity comprises activity tracking using a request count within the distributed memory cache;

transmitting code for storing, by the multi-tenant database system, first information indicating the identified data activity;

transmitting code for moving a portion of the first information to the distributed memory cache following the storing of the first information;

transmitting code for generating, by the multi-tenant database system, second information associated with the data activity from contents of the distributed memory cache, wherein the generated second information is based on a total count of activity indicated by the request count; and

transmitting code for providing the user system with access to the generated second information.