Systems and methods for data management

• US 7,548,900 B2
• Filed: 11/30/2006
• Issued: 06/16/2009
• Est. Priority Date: 11/30/2006
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Adt, Melanie, Spohn, Roman, Weiler, Thomas, Wingert, Martina
• Primary Examiner(s): Lee; Wilson
• Application Number:
  US11/606,124
• Publication Number:
  US 20080133478A1
• Time in Patent Office: 929 Days
• Field of Search: 707 1- 10
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

A system, method and machine readable medium for the analysis and management of information is described. More specifically, the embodiments o relate to systems and methods for gathering, analyzing and reporting information in a business context. More specifically, the embodiments relate to systems and methods for presenting business metrics to system users in a reliable and efficient manner, including the employment of a data extractor and multiple data storage units arranged to generate reports.

Claims

1. A system for monitoring a data metric, comprising:

a plurality of records relating to a data metric;

a database for storing at least a portion of information from at least one of the plurality of records relating to a data metric;

a first data storage unit;

a second data storage unit;

an extractor for querying the database for database data relevant to the data metric within a particular time frame and providing query results to the first data storage unit and the second data storage unit;

wherein the second data storage unit is configured to store the provided query results;

wherein the first data storage unit is configured to store at most a portion of the provided query results, the at most a portion of the provided query results corresponding to less than all of the query results stored at the second data storage unit; and

wherein the first and second data storage units are used to generate first and second reports regarding the data metric.

2. The system of claim 1, wherein the database stores the at least a portion of information from at least one of the plurality of records relating to a data metric in rows, and wherein each row further comprises a time stamp relating to the time of the at least a portion of information.

3. The system of claim 2, wherein the extractor queries the database based for rows based on the time stamp of each row.

4. The system of claim 3, wherein the first data storage unit comprises a filter to reject at least a portion of the query results.

5. The system of claim 4, wherein the filter of the first data unit accepts only query results wherein a particular data value exceeds or is lower than a threshold value.

6. The system of claim 5, wherein the second data storage unit does not filter the query results.

7. The system of claim 6, further comprising an interface unit implemented between the extractor and the first data storage unit and the second data storage unit, such that the extractor provides query results to the first data unit and the second data unit through the interface unit.

8. The system of claim 7, wherein the first report comprises a list of query results wherein the particular data value exceeds or is lower than a threshold value;

and wherein the second report provides the capability to view all available records relating to the data metric.

9. The system of claim 8, wherein the data metric is the moving average price of a good.

10. A method for allowing monitoring of a data metric, comprising:

scanning a plurality of records to determine those related to a data metric;

storing information from at least some of the plurality of records in a database;

extracting, via a query, information from the database related to the data metric;

providing the information to a first data storage unit and a second data storage unit

storing at the second data storage unit the provided information;

storing at the first data storage unit at most a portion of the provided information, the at most a portion of the provided information corresponding to less than all of the information stored at the second data storage unit;

generating a report using the first data storage unit; and

generating a report using the second data storage unit.

11. The method of claim 10, wherein the step of storing information from at least some of the plurality of records in a database further comprises storing the information in rows and associating each row with a time stamp relating to the time the information was stored.

12. The method of claim 11, wherein the step of extracting, via a query, information from the database related to the data metric further comprises querying the database for rows based on the time stamp of each row.

13. The method of claim 12, wherein the step of providing the query information to a first data storage unit and a second data storage unit further comprises blocking, via a filter in the first data storage unit, at least a portion of the query results from being provided to the first data storage unit.

14. The method of claim 13, wherein the step of blocking, via a filter in the first data storage unit, at least a portion of the query results from being provided to the first data storage unit comprises accepting only query results wherein a particular data value exceeds or is lower than a threshold value.

15. The method of claim 14, wherein the step of providing the query information to a first data storage unit and a second data storage unit further comprises storing, at the second data storage unit, all of the query results.

16. The method of claim 15, wherein the step of providing the query information to a first data storage unit and a second data storage unit further comprises providing the query results to the first data unit and the second data unit through an interface unit.

17. The method of claim 16, wherein the step of generating a report using the first data storage unit comprises generating a report including a list of query results wherein the particular data value exceeds or is lower than a threshold value;

and wherein the step of generating a report using the second data storage unit comprises generating a report providing the capability to view all available records relating to the data metric.

18. The method of claim 17, wherein the data metric comprises the moving average price of a good.

19. A machine readable medium with executable program code embedded therein, the code when executed by a processor, performing a method, comprising:

scanning a plurality of records to determine those related to a data metric;

storing information from at least some of the plurality of records in a database;

extracting via a query information from the database related to the data metric;

providing the query information to a first data storage unit and a second data storage unit;

storing at the second data storage unit the provided information;

storing at the first data storage unit at most a portion of the provided information, the at most a portion of the provided information corresponding to less than all of the information stored at the second data storage unit;

generating a report using the first data storage unit; and

generating a report using the second data storage unit.

20. The machine readable medium of claim 19, wherein the method step of providing the query information to a first data storage unit and a second data storage unit further comprises blocking, via a filter in the first data storage unit, at least a portion of the query results from being provided to the first data storage unit;

and wherein the data metric comprises the moving average price of a good.