Tracking usage of data elements in electronic business communications

• US 7,818,342 B2
• Filed: 11/21/2005
• Issued: 10/19/2010
• Est. Priority Date: 11/12/2004
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Stuhec, Gunther
• Primary Examiner(s): Jalil; Neveen Abel
• Assistant Examiner(s): BUCKINGHAM, KELLYE DEE
• Application Number:
  US11/285,368
• Publication Number:
  US 20060106755A1
• Time in Patent Office: 1,793 Days
• Field of Search: 707/777
• US Class Current: 707/777
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/84 Mapping; Conversion
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A computer program product that is tangibly embodied in an information carrier is described. The computer program product includes instructions that, when executed, perform operations for tracking data elements that are used in electronic documents. The method includes identifying an instance of a data element in a first electronic document comprising one or more data elements, modifying stored information based on the identification of the data element, periodically retrieving the stored information specifying a number of times a data element is used during a time interval, applying a calculation process to the information to determine a usage trend for the data element, and providing a visual display on a display device that shows an identifier for the data element and the usage trend.

Claims

1. A computer program product tangibly embodied in a machine readable storage device, the computer program product including instructions that, when executed, perform operations for tracking data elements that are used in electronic documents, the operations comprising:

(i) monitoring a plurality of electronic documents that include one or more data elements, wherein the one or more data elements comprise metadata tags that identify a type of information associated with the metadata tags;

(ii) identifying whether an instance of a data element comprising a metadata tag is present in a first electronic document of the plurality of monitored electronic documents;

(iii) incrementing a counter value that reflects a number of times the data element is used during a time interval based on the identification of whether the data element comprising the metadata tag is present in the first electronic document, the counter value incremented once for the first electronic document regardless of how many times the data element is present in the first electronic document and regardless of how many times the first electronic document including the data element is accessed;

(iv) resetting the counter value at an end of the time interval and thereafter incrementing the reset counter value during a subsequent time interval based on the use of the data element during the subsequent time interval, in accordance with step (iii);

(v) periodically retrieving the counter value that reflects the number of times the data element is used during a time interval;

(vi) applying a calculation process to the information to determine a usage trend, and identifying a usage trend interface element based on the usage trend, for the data element that comprises the metadata tag;

(vii) using the usage trend to map the data element in a second electronic document to a data element in an intermediate document; and

(viii) providing a visual display on a display device that shows an identifier for the data element and the usage trend interface element, wherein the visual display of the usage trend interface element replaces a display of an earlier usage trend interface element for the data element corresponding to a previous time interval.

2. The computer program product of claim 1, wherein the operations further comprise mapping the data element in the intermediate document to a data element in a third electronic document.

3. The computer program product of claim 1, wherein the counter value is stored in a schema comprising a definition associated with the data element.

4. The computer program product of claim 3, wherein the operations further comprise deleting or modifying the definition based the usage trend for the data element.

5. The computer program product of claim 3, wherein the operations further comprise generating a recommendation to delete or modify-the definition based on the usage trend for the data element.

6. The computer program product of claim 3, wherein the operations further comprise receiving a revised definition for the schema.

7. The computer program product of claim 3, wherein the periodic retrieval comprises aggregating the retrieved counter value with a previously retrieved counter value that reflects a number of times the data element was used during a previous time interval.

8. The computer program product of claim 7, wherein the periodic retrieval further comprises resetting the stored information.

9. The computer program product of claim 1, wherein the calculation process comprises ordering the information according to a time series model.

10. The computer program product of claim 9, wherein the time series model comprises a component selected from a group consisting of a smooth trend component, a cyclic trend component, a seasonal trend component, and an irregular trend component.

11. The computer program product of claim 10, wherein the displayed usage trend comprises one component.

12. The computer program product of claim 9, wherein the calculation process further comprises applying a statistical smoothing procedure to the time series model.

13. The computer program product of claim 12, wherein the smoothing procedure comprises a linear regression calculation, an exponential smoothing calculation, or both.

14. The computer program product of claim 12, wherein the statistical smoothing procedure generates an estimate for a future trend usage.

15. The computer program product of claim 1, wherein the usage trend for the data element is displayed as a single symbol.

16. The computer program product of claim 15, wherein the usage trend varies graphically based on a value of the usage trend.

17. The computer program product of claim 1, wherein the usage trend indicates that the data element may be deleted because the element has not been used for a determined amount of time.

22. The computer program product of claim 1, wherein the operations further comprise determining, at the end of the predetermined time interval, that the counter value is below a threshold, and, in response to the determination, providing a recommendation to the user to delete the data element from the set of data element definitions.

18. A computer program product tangibly embodied in a machine readable storage device, the computer program product including instructions that, when executed, perform a method for tracking usage data for a data element, the method comprising:

(i) creating a schema having definitions associated with data elements, wherein the data elements comprise metadata tags that identify a type of information associated with the metadata tags;

(ii) incrementing a counter value that reflects a number of times the data element comprising a metadata tag is used during a time interval based on an identification of whether one or more of the data elements is present in a plurality of monitored electronic documents, the counter value incremented once for a first electronic document in the plurality of documents regardless of how many times the one or more data elements is present in the first electronic document and regardless of how many times the first electronic document including the one or more data elements is accessed;

(iii) resetting the counter value at an end of the time interval and thereafter incrementing the resent counter value during a subsequent time interval based on the user of the data element during the subsequent time interval, in accordance with step (ii)

(iv) periodically retrieving the counter value that reflects the number of times each data element is used during a time interval;

(v) applying a calculation process to the information to determine a usage trend, and identifying a usage trend interface element for the usage trend, for each data element;

(vi) using the usage trend to map the data element in a second electronic document to a data element in an intermediate document;

(vii) providing a visual display on a display device that shows an identifier for a data element and a usage trend interface element associated with the data element, wherein the visual display of the usage trend interface element replaces a display of an earlier usage trend interface element for the data element corresponding to a previous time interval; and

(viii) receiving a revised schema definition.

19. A computer program product tangibly embodied in a machine readable storage device, the computer program product including instructions that, when executed, perform operations for tracking data elements that are used in electronic documents, the operations comprising:

(i) identifying an instance of a data element for semantically identifying information in a first electronic document comprising one or more data elements, the data element comprises a metadata tag and is instantiated based on a set of data element definitions;

(ii) incrementing a counter value based on the identification of the data element, the counter value reflecting a number of times that the data element is used within a time interval predefined in the set of data element definitions;

(iii) incrementing the counter value based on whether the data element is present in a second electronic document, the incrementing performed once for the second electronic document regardless of how many times the data element comprising a metadata tag is present in the second electronic document and regardless of how many times the second electronic document including the data element is accessed;

(iv) resetting the counter value at an end of the time interval and thereafter to incrementing the resent counter value during a subsequent time interval based on the use of the data element during the subsequent time interval, in accordance with steps (ii) and (iii);

(v) periodically retrieving the counter value;

(vi) storing, in a statistical database, (1) multiple counter values based on periodically retrieving the counter value; and

(2) a time period associated with the counter value, the time period representing a retrieval time of the associated counter value;

(vii) applying a calculation process to information stored in the statistical database to determine a usage trend that indicates a historical and a future predicted usage, and identifying a usage trend interface element based on the usage trend, for the data element, the calculation process comprising;

ordering the counter values in the statistical database based on the time periods associated with the counter values according to a time series model;

applying a statistical smoothing procedure by analyzing a linear trend of the data element'"'"'s usage; and

generating the usage trend using the time series model and the smoothing procedure;

(viii) using the usage trend to map the data element in a third electronic document to a data element in an intermediate document; and

(ix) providing a visual display on a display device that shows an identifier for the data element and a single symbol representing the usage trend, the identifier comprising a recommendation for the data element corresponding to the usage trend, wherein the single symbol replaces a display of an earlier single symbol for the data element corresponding to a previous time interval.

20. A computer program product tangibly embodied in a machine readable storage device, the computer program product including instructions that, when executed, perform operations for tracking data elements that are used in electronic documents, the operations comprising:

(i) identifying whether an instance of a data element comprising a metadata tag is present in a first electronic document comprising one or more data elements;

(ii) incrementing a counter value that reflects a number of times the data element comprising a metadata tag is used during a time interval based on the identification of whether the data element is present in the first electronic document, the counter value incremented once for the first electronic document regardless of how many times the data element is present in the first electronic document and regardless of how many times the first electronic document including the data element is accessed, wherein the counter value is stored in a schema comprising a definition associated with the data element;

(iii) resetting the counter value at an end of the time interval and thereafter incrementing the reset counter value during a subsequent time interval based on the use of the data element during the subsequent time interval, in accordance with step (ii);

(iv) periodically retrieving the counter value that reflects the number of times a data element is used in different electronic documents during a time interval;

(v) applying a calculation process to the information to determine a usage trend, and identifying a usage trend interface element based on the usage trend, for the data element;

(vi) using the usage trend to map the data element in a second electronic document to a data element in an intermediate document;

(vii) providing a visual display on a display device that shows an identifier for the data element and the usage trend interface element, wherein the visual display of the usage trend interface element replaces a display of an earlier usage trend interface element for the data element corresponding to a previous time interval; and

(viii) deleting or modifying the definition based the usage trend for the data element.

21. The computer program product of claim 20, wherein the operations further comprise generating a recommendation to delete or modify the definition based on the usage trend for the data element.