DATABASE SNAPSHOT ANALYSIS

• US 20140351217A1
• Filed: 08/20/2013
• Published: 11/27/2014
• Est. Priority Date: 05/23/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Bostock, Clive
• Granted Patent: US 9,116,901 B2
• Time in Patent Office: Days
• US Class Current: 707/639
• CPC Class Codes: G06F 16/128 Details of file system snapshots on the file-level, e.g. snapshot creation, administration, deletion use of snapshots for error detection or correction G06F11/14, G06F11/16
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409

Abstract

Analysis tools summarize and provide statistics from snapshot files. The analysis tools may provide a temporal view of the changes of the data values across two or more periods of time from one or more snapshot files to show trends in performance of the system. The analysis tools may include meta-data definitions for different sources of the snapshot information.

Claims

1. A system for providing statistic data for a database, the system comprising:

one or more processors;

a non-transitory computer-readable storage medium storing a plurality of instructions, which, when executed, cause the one or more processors to;

define a time period of analysis of a snapshot information dataset, the snapshot information dataset comprising data relating to a state of the database at multiple instances of times;

define a data field of the snapshot information to capture for analysis;

load a meta-data definition for the data field of the snapshot information dataset;

collect the data field from the snapshot information dataset using the meta-data definition;

compute a set of statistics over the time period of analysis for the data field of the snapshot information dataset;

format the set of statistics; and

output the set of statistics, wherein no snapshot information used to compute the statistics is directly outputted.

2. The system of claim 1, wherein the meta-data definition comprises information on a location of the data field within the snapshot information dataset.

3. The system of claim 2, wherein the location of data field within the snapshot information dataset is defined with a field number, the field number indicating which non-whitespace sequence of characters of the snapshot information is the at least one data field.

4. The system of claim 1, wherein the meta-data definition is determined from the snapshot information dataset and the data field.

5. The system of claim 1, wherein the meta-data definition comprises security and privacy information with a privacy policy for the data field.

6. The system of claim 5, wherein instructions to format the set of statistics are further configured to cause the one or more processors to strip the set of statistics of private information according to the privacy policy defined in the meta-data definition.

7. The system of claim 6, wherein the set of statistics is normalized to show only trends of the set of statistics.

8. A method for providing statistic data for a database, the method comprising:

collecting, by a computer system, a snapshot information dataset according to a schedule, wherein the snapshot information comprises relating to a state of the database at the time of the snapshot information collection;

defining, by the computer system, a time period of analysis of the snapshot information dataset;

defining, by the computer system, a data field of the snapshot information dataset;

determining, by the computer system, a meta-data definition, the meta-data definition defining a structure and organization of the snapshot information dataset;

loading, by the computer system, the meta-data definition;

collecting, by the computer system, the data field from the snapshot information dataset;

computing, by the computer system, a set of statistics over the time period of analysis for the collected data field; and

formatting, by the computer system, the set of statistics.

9. The method of claim 8, wherein the meta-data definition comprises information on a location of the data field within the snapshot information dataset.

10. The method of claim 8, wherein the meta-data definition is determined from the snapshot information dataset structure and the data field of the snapshot information dataset.

11. The method of claim 8, wherein the meta-data definition includes snapshot information security and privacy information defining a privacy policy for each data field.

12. The method of claim 11, wherein formatting the set of statistics further comprises stripping the set of statistics of private information according to the privacy policy defined in the meta-data definition.

13. The method of claim 12, further comprising the step of normalizing the set of statistics.

14. The method of claim 12, further comprising the step of stripping time related information from the set of statistics.

15. A computer program product residing on a non-transitory processor-readable medium and comprising processor readable instructions configured to cause one or more processors to:

collect a snapshot information dataset according to a schedule, the snapshot information dataset comprising data relating to a state of a database at the time of the snapshot information dataset collection;

define a time period of analysis of the snapshot information dataset;

define a data field of the snapshot information dataset to capture for analysis;

determine a meta-data definition, the meta-data definition defining a structure and organization of the snapshot information dataset and the data field;

load the meta-data definition;

collect the data field from the snapshot information;

compute a set of statistics over the time period of analysis for the data field;

format the set of statistics; and

output the set of statistics, wherein no snapshot information used to compute the statistics is directly outputted.

16. The computer program of claim 15, wherein the meta-data definition comprises information on a location of the data field within the snapshot information dataset.

17. The computer program of claim 15, wherein the meta-data definition is determined from the snapshot information dataset structure and the data field of the snapshot information dataset.

18. The computer program of claim 15, wherein the meta-data definition includes security and privacy information defining a privacy policy for the data.

19. The computer program of claim 18, wherein the set of statistics are formatted to strip private information according to the privacy policy defined in the meta-data definition.

20. The computer program of claim 19, further comprising instructions to cause the one or more processors to normalize the set of statistics.