Heterogeneous database management system

• US 8,060,470 B2
• Filed: 12/23/2008
• Issued: 11/15/2011
• Est. Priority Date: 12/23/2008
• Status: Active Grant

• Current Assignee: Apple Inc.
• Original Assignee: Apple Inc.
• Inventors: Davidson, Mark, Hom, Erwin, Parks, Robert
• Primary Examiner(s): Lewis; Cheryl
• Application Number:
  US12/342,684
• Publication Number:
  US 20100161574A1
• Time in Patent Office: 1,057 Days
• Field of Search: 707/634, 707/636, 707/648, 707/809, 707/999.201
• US Class Current: 707/634
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/26 Visual data mining; Browsing structured data

Abstract

An administration server in a database management system retrieves log files in a plurality of formats from a plurality of clients through helper programs running on the clients. The plurality of clients can include Web servers, application servers, and database servers. The log files can be generated by software modules on the clients. An administration engine converts log entries in the log files into a unified format for display. The converted log entries can be stored in a log database. Upon a user request, the administration server presents the log entries to the user in a log viewer. The log viewer can display log entries originated from heterogeneous software modules in a unified view.

Claims

1. A computer-implemented method of viewing logs in a database management system, comprising:

obtaining a first log file in a first format, the first log file associated with a first software module of the database management system;

obtaining a second log file in a second format, wherein the second format is associated with a second software module of the database management system, and wherein the second format differs from the first format;

converting log entries in the first log file and log entries in the second log file into a third format, wherein the third format differs from the first format and the second format; and

responsive to a log viewing request, presenting the converted log entries in a log viewer in the third format on a display device, wherein the log entries are presented in a table comprising rows and columns, the rows of the table corresponding to log entry times, a first column of the table indicating the first software module or the second software module, and a second column of the table indicating a severity condition associated with the first software module or the second software module.

2. The method of claim 1, wherein presenting the converted log entries in the log viewer comprises displaying statistics of software modules, the statistics generated by periodic computer system measurements.

3. The method of claim 1, wherein presenting the converted log entries in the log viewer comprises:

displaying the log entries in a table view in a first portion of the log viewer;

displaying statistics of software modules in a second portion of the log viewer, the statistics generated by periodic computer system measurements; and

displaying graphical controls that link the log entries with the statistics, wherein a user'"'"'s selection in one portion of the log viewer causes updates in another portion of the log viewer.

4. The method of claim 3, where the graphical controls allow toggling between the table view, a statistics display, and a combined table view and statistics display.

5. The method of claim 3, wherein the updates in the portions of the log viewer is synchronous.

6. The method of claim 1, wherein the first and second software modules are heterogeneous.

7. A computer-readable medium storing a computer program which, when executed by a computer processor, causes the computer processor to perform operations comprising:

obtaining a first log file in a first format, the first log file associated with a first software module of a database management system;

obtaining a second log file in a second format, wherein the second format is associated with a second software module of the database management system, and wherein the second format differs from the first format;

converting log entries in the first log file and log entries in the second log file into a third format, wherein the third format differs from the first format and the second format; and

responsive to a log viewing request, presenting the converted log entries in a log viewer in the third format on a display device, wherein the log entries are presented in a table comprising rows and columns, the rows of the table corresponding to log entry times, a first column of the table indicating the first software module or the second software module, and a second column of the table indicating a severity condition associated with the first software module or the second software module.

8. The computer-readable medium of claim 7, wherein presenting the converted log entries in the log viewer comprises displaying statistics of software modules, the statistics generated by periodic computer system measurements.

9. The computer-readable medium of claim 7, wherein presenting the converted log entries in the log viewer comprises:

displaying the log entries in a table view in a first portion of the log viewer;

displaying statistics of software modules in a second portion of the log viewer, the statistics generated by periodic computer system measurements; and

displaying graphical controls that link the log entries with the statistics, wherein a user'"'"'s selection in one portion of the log viewer causes updates in another portion of the log viewer.

10. The computer-readable medium of claim 9, where the graphical controls allow toggling between the table view, a statistics display, and a combined table view and statistics display.

11. The computer-readable medium of claim 9, wherein the updates in the portions of the log viewer are synchronous.

12. The computer-readable medium of claim 7, wherein the first and second software modules are heterogeneous.

13. A system comprising:

a processor;

memory coupled to the processor and operable for storing instructions, which, when executed by the processor, cause the processor to perform operations comprising;

obtaining a first log file in a first format, the first log file associated with a first software module of a database management system;

obtaining a second log file in a second format, wherein the second format is associated with a second software module of the database management system, and wherein the second format differs from the first format;

converting log entries in the first log file and log entries in the second log file into a third format, wherein the third format differs from the first format and the second format; and

responsive to a log viewing request, presenting the converted log entries in a log viewer in the third format on a display device, wherein the log entries are presented in a table comprising rows and columns, the rows of the table corresponding to log entry times, a first column of the table indicating the first software module or the second software module, and a second column of the table indicating a severity condition associated with the first software module or the second software module.

14. The system of claim 13 wherein presenting the converted log files in the log viewer comprises displaying statistics of software modules, the statistics generated by periodic computer system measurements.

15. The system of claim 13, wherein presenting the converted log files in the log viewer comprises:

displaying log entries in a table view in a first portion of the log viewer;

displaying statistics of software modules in a second portion of the log viewer, the statistics generated by periodic computer system measurements; and

displaying graphical controls that link the log entries with the statistics, wherein a user'"'"'s selection in one portion of the log viewer causes updates in another portion of the log viewer.

16. The system of claim 15, where the graphical controls allow toggling between the table view, a statistics display, and a combined table view and statistics display.

17. The system of claim 15, wherein the updates in the portions of the log viewer are synchronous.

18. The system of claim 13, wherein the first and second software modules are heterogeneous.