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

• US 9,178,788 B2
• Filed: 04/18/2013
• Issued: 11/03/2015
• 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:
  US13/865,870
• Publication Number:
  US 20130238671A1
• Time in Patent Office: 929 Days
• Field of Search: 709/224
• US Class Current: 1/1
• 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 system, data activity performed across multiple servers, the data activity including user initiated events;

storing, within a distributed memory cache of the system that is shared by the multiple servers, information indicating the identified data activity;

storing, within a database of the system that is shared by the multiple servers, the information indicating the identified data activity;

in response to receipt of a request from a user by the system, retrieving, by the system, at least a portion of the information indicating the identified data activity from the distributed memory cache;

performing, by the system, a historical profiling using the at least a portion of the information indicating the identified data activity retrieved from the distributed memory cache, the historical profiling including reporting to the user the at least a portion of the information retrieved from the distributed memory cache.

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

3. The computer program product of claim 1, wherein the data activity is associated with an application.

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

5. The computer program product of claim 1, wherein the data activity includes an amount of data that is transferred utilizing the system.

6. The computer program product of claim 1, wherein the distributed memory cache includes memcached.

10. The computer program product of claim 1, wherein an indication of a completion of each user initiated event is stored in the distributed memory cache.

11. The computer program product of claim 1, wherein the user initiated events include knowledge base article views, such that the reporting to the user the at least a portion of the information includes reporting on the knowledge base article views.

12. The computer program product of claim 1, wherein the distributed memory cache is used to store the information, such that the information is retrieved from the distributed memory cache for the reporting to avoid retrieving the information from the database.

7. A method, comprising:

identifying, by a system, data activity performed across multiple servers, the data activity including user initiated events;

storing, within a distributed memory cache of the system that is shared by the multiple servers, information indicating the identified data activity;

storing, within a database of the system that is shared by the multiple servers, the information indicating the identified data activity;

in response to receipt of a request from a user by the system, retrieving, by the system, at least a portion of the information indicating the identified data activity from the distributed memory cache;

performing, by the system, a historical profiling using the at least a portion of the information indicating the identified data activity retrieved from the distributed memory cache, the historical profiling including reporting to the user the at least a portion of the information retrieved from the distributed memory cache.

8. An apparatus, comprising:

a processor of a system for;

identifying, by the system, data activity performed across multiple servers, the data activity including user initiated events;

storing, within a distributed memory cache of the system that is shared by the multiple servers, information indicating the identified data activity;

storing, within a database of the system that is shared by the multiple servers, the information indicating the identified data activity;

in response to receipt of a request from a user by the system, retrieving, by the system, at least a portion of the information indicating the identified data activity from the distributed memory cache;

performing, by the system, a historical profiling using the at least a portion of the information indicating the identified data activity retrieved from the distributed memory cache, the historical profiling including reporting to the user the at least a portion of the information retrieved from the distributed memory cache.

9. A method for transmitting code for use in a multi-tenant database system on a transmission medium, the method comprising:

transmitting code for identifying, by a system, data activity performed across multiple servers, the data activity including user initiated events;

transmitting code for storing, within a distributed memory cache of the system that is shared by the multiple servers, information indicating the identified data activity;

transmitting code for storing, within a database of the system that is shared by the multiple servers, the information indicating the identified data activity;

transmitting code for, in response to receipt of a request from a user by the system, retrieving, by the system, at least a portion of the information indicating the identified data activity from the distributed memory cache;

performing, by a system, a historical profiling using the at least a portion of the information indicating the identified data activity retrieved from the distributed memory cache, the historical profiling including reporting to the user the at least a portion of the information retrieved from the distributed memory cache.