Computer implemented systems and methods for data usage monitoring

Patent metadata

Field	Value
Publication number	US-10002120-B2
Application number	US-201514701387-A
Country	US
Kind code	B2
Filing date	Apr 30, 2015
Priority date	Apr 30, 2015
Publication date	Jun 19, 2018
Grant date	Jun 19, 2018

Abstract

The present disclosure includes techniques pertaining to computer implemented systems and methods for data usage monitoring. In one embodiment, user manipulations of spreadsheets are translated into backend actions and executed against spreadsheet data. The actions of users on different spreadsheets automatically generate data records to track each action. The data records are stored in a data structure and portions of the records may be accessed to generate usage information.

First claim

What is claimed is:

1. A computer-implemented method comprising:
receiving, in a computer system, a plurality of user triggered inputs to perform actions on a plurality of spreadsheets each comprising data, wherein the actions each correspond to a manipulation of spreadsheet data selected by a particular user;
executing, by the computer system, the actions on data in corresponding spreadsheets, wherein each action, when executed, automatically generates an action specific data record to track each action,
wherein executing each action and automatically generating an action specific data record comprises executing a code block for each particular action, the code block for each particular action comprising code for generating action specific data records, and
wherein actions corresponding to worksheet manipulations have embedded code blocks for generating first data records having first associated data and actions corresponding to column manipulations have different embedded code blocks for generating second data records having second associated data;

automatically storing a plurality of said data records in a data structure;
receiving, in a computer system, a user triggered input to access a portion of the stored data records;
generating usage information for each of the executed actions from the data records; and
sending the usage information for display to the user.

2. The method of claim 1 wherein each data record comprises a link to an action history table.

3. The method of claim 1 wherein each data record comprises a link to worksheet definition table.

4. The method of claim 1 wherein each data record comprises a link to a project information table.

5. The method of claim 1 wherein each data record comprises a name of an action.

6. The method of claim 1 wherein each data record comprises a time stamp.

7. The method of claim 1 wherein the usage information comprises a count of a number of times a plurality of data sets are included in user projects.

8. The method of claim 7 wherein the data sets correspond to different data sources.

9. The method of claim 1 wherein the usage information comprises a count of a number of data manipulations for a plurality of data sets.

10. The method of claim 1 wherein the user triggered input corresponds to menu selections in a user interface, the method further comprising generating a query in response to the user triggered input, the query accessing one or more of said data records and accessing data associated with the one or more of said data records through links in particular fields of each data record to generate said usage information.

11. A computer system comprising:
one or more processors; and
a non-transitory computer readable medium having stored thereon one or more programs, which when executed by the one or more processors, causes the one or more processors to:
receive a plurality of user triggered inputs to perform actions on a plurality of spreadsheets each comprising data, wherein the actions each correspond to a manipulation of spreadsheet data selected by a particular user;
execute the actions on data in corresponding spreadsheets, wherein each action, when executed, automatically generates an action specific data record to track each action,
wherein executing each action and automatically generating an action specific data record comprises executing a code block for each particular action, the code block for each particular action comprising code for generating action specific data records,
wherein actions corresponding to worksheet manipulations have embedded code blocks for generating first data records having first associated data and actions corresponding to column manipulations have different embedded code blocks for generating second data records having second associated data;

automatically store a plurality of said data records in a data structure;
receive a user triggered input to access a portion of the stored data records;
generate usage information for each of the executed actions from the data records; and
send the usage information for display to the user.

12. The computer system of claim 11 wherein the user triggered input corresponds to menu selections in a user interface, the method further comprising generating a query in response to the user triggered input, the query accessing one or more of said data records and accessing data associated with the one or more of said data records through links in particular fields of each data record to generate said usage information.

13. A non-transitory computer readable storage medium storing one or more programs, the one or more programs comprising instructions for:
receiving a plurality of user triggered inputs to perform actions on a plurality of spreadsheets each comprising data, wherein the actions each correspond to a manipulation of spreadsheet data selected by a particular user;
executing the actions on data in corresponding spreadsheets, wherein each action, when executed, automatically generates an action specific data record to track each action,
wherein executing each action and automatically generating an action specific data record comprises executing a code block for each particular action, the code block for each particular action comprising code for generating action specific data records
wherein actions corresponding to worksheet manipulations have embedded code blocks for generating first data records having first associated data and actions corresponding to column manipulations have different embedded code blocks for generating second data records having second associated data;

automatically storing a plurality of said data records in a data structure;
receiving a user triggered input to access a portion of the stored data records;
generating usage information for each of the executed actions from the data records; and
sending the usage information for display to the user.

14. The non-transitory computer readable storage medium of claim 13 wherein the user triggered input corresponds to menu selections in a user interface, the method further comprising generating a query in response to the user triggered input, the query accessing one or more of said data records and accessing data associated with the one or more of said data records through links in particular fields of each data record to generate said usage information.

Assignees

• Sap Se

Inventors

• Tan Khuan
• YUEH Chien
• Liu Ying
• He Min

Classifications

• G06F40/18 Primary

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06F16/2465 Primary

  Query processing support for facilitating data mining operations in structured databases · CPC title

• G06F17/30539

  Physics · mapped topic

• G06F3/0482

  Interaction with lists of selectable items, e.g. menus · CPC title

• G06F3/0484

  for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range · CPC title