SYSTEM, METHOD AND COMPUTER PROGRAM PRODUCT FOR MONITORING DATA ACTIVITY UTILIZING A SHARED DATA STORE

• US 20160019255A1
• Filed: 09/28/2015
• Published: 01/21/2016
• Est. Priority Date: 02/24/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Yancey, Scott, Hansma, Scott
• Granted Patent: US 9,607,034 B2
• Time in Patent Office: Days
• 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 events initiated by at least one first entity external to the system;

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, a first portion of the information indicating the identified data activity;

retrieving, by the system from the distributed memory cache, a second portion of the information indicating the identified data activity;

using, by the system, the retrieved second portion of the information indicating the identified data activity to generate a historical profile of the data activity;

reporting, by the system, the generated historical profile.

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 database system.

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

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

7. The computer program product of claim 1, wherein the identified data activity for which information is stored in the distributed memory cache of the system 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 system that is shared by the multiple servers, the information indicating the identified data activity.

9. A method, comprising:

identifying, by a system, data activity performed across multiple servers, the data activity including events initiated by at least one first entity external to the system;

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, a first portion of the information indicating the identified data activity;

retrieving, by the system from the distributed memory cache, a second portion of the information indicating the identified data activity;

using, by the system, the retrieved second portion of the information indicating the identified data activity to generate a historical profile of the data activity;

reporting, by the system, the generated historical profile.

10. An apparatus, comprising:

a processor of a system for;

identifying, by the system, data activity performed across multiple servers, the data activity including events initiated by at least one first entity external to the system;

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, a first portion of the information indicating the identified data activity;

retrieving, by the system from the distributed memory cache, a second portion of the information indicating the identified data activity;

using, by the system, the retrieved second portion of the information indicating the identified data activity to generate a historical profile of the data activity;

reporting, by the system, the generated historical profile.

11. 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 events initiated by at least one first entity external to the system;

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, a first portion of the information indicating the identified data activity;

transmitting code for retrieving, by the system from the distributed memory cache, a second portion of the information indicating the identified data activity;

transmitting code for using, by the system, the retrieved second portion of the information indicating the identified data activity to generate a historical profile of the data activity;

transmitting code for reporting, by the system, the generated historical profile.