Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1998-06-18
2001-03-06
Kulik, Paul V. (Department: 2777)
Data processing: database and file management or data structures
Database design
Data structure types
C714S020000
Reexamination Certificate
active
06199070
ABSTRACT:
BACKGROUND OF THE INVENTION
1. Field of the Invention
The present invention relates to computer software, and deals more particularly with a method and apparatus for using a database to store program logs. The amount of data stored can be reduced using data normalization. Data retrieval and display, including statistics and report generation, is simplified by using the existing facilities of the database manager.
2. Description of the Related Art
Software products are customarily written to generate information on the tasks which they perform. The more complex the program, the more important it is to generate information about what is occurring in the program, in case something should go wrong. In the early days of computer use, programs logged information by sending text strings to a dedicated printer, or console, in real time. A human operator could then determine what was occurring in the program by inspecting the log entries as they were written, or by reading the entries that had been written out over a period of time. The log-creation process has evolved over time, to where log information is now written into disk files instead of directly to a printer. These disk files are commonly referred to in a general sense as “program logs”, or simply “logs”. Some products may create more than one such file, to separate classes of information. An example of this separation could be storing data of interest to the end user in one file (for example, an “activity log”) while storing information of interest to a developer in a different file (a “trace log”, for example). In either case, the log is a flat file, ordered sequentially according to the time each entry is made. A “flat file” is a file containing simple records that have no complex structure, and no explicit relationships between entries, other than their sequential order. The entries in the flat file consist of fully-formed, human-readable messages. These flat files have no inherent means for sorting, filtering, or analyzing the data they contain. A simple text editor may be used to display the contents of the log, but this does not allow the data to be processed in any way (such as sorting or filtering) to facilitate meaningful interpretation. Alternatively, a custom-written software program may be written to display the log. Custom-written programs are required in order to manipulate the entries in the log—for example, to select only certain entries for viewing, to change the order of the entries, or to revise the contents of entries.
Writing messages that are fully-formed leads to redundant data being stored in the files. When an application logs many messages, the log files can grow to be quite large. When the message text is long, and the same message is logged many times, this is an inefficient use of system resources.
Accordingly, a need exists for a technique by which program-generated logs can be created in a more usable, efficient manner. The present invention provides a technique for storing the messages of program logs in databases. The messages are stored in multiple database files, in order to allow normalization of the message content. Further, the messages are stored in computer-readable form, instead of human-readable form. This technique enables optimization of the storage used for storing the log entries, and eliminates the storage of redundant message text. In addition, this technique allows quick, efficient analysis of log entries without writing custom software, because the report-generating facilities of the database manager—which are provided as part of the database software—can be used. Because the messages are stored in computer readable form, they can be translated into other languages easily and efficiently.
SUMMARY OF THE INVENTION
An object of the present invention is to provide a technique whereby log entries are stored in a more efficient manner.
Another object of the present invention is to provide a technique whereby log entries can be easily and efficiently analyzed.
Yet another object of the present invention is to provide a technique for this analysis which does not require writing custom software.
A further object of the present invention is to provide a technique whereby log entries can be translated into various languages in an optimal manner.
Other objects and advantages of the present invention will be set forth in part in the description and in the drawings which follow and, in part, will be obvious from the description or may be learned by practice of the invention.
To achieve the foregoing objects, and in accordance with the purpose of the invention as broadly described herein, the present invention provides a system, method, and computer-readable code for use in a computing environment, for using a database to store program logs. This technique comprises: a subprocess for generating a plurality of log entries; a subprocess for accessing one or more database tables; and a subprocess for storing said generated log entries in said one or more database tables. Preferably, this technique further comprises a subprocess for using one or more predefined database tables, such that said one or more database tables are at least partially normalized. The facilities of a database manager may be used to process said stored log entries. In addition, each of said generated log entries may comprise a plurality of fields, and one or more of said fields may be stored in machine-readable format.
The present invention will now be described with reference to the following drawings, in which like reference numbers denote the same element throughout.
REFERENCES:
patent: 5524241 (1996-06-01), Ghoniemy et al.
Polo-Wood Felipe
Volkmar Peter Williams
Doubet Marcia L.
International Business Machines - Corporation
Kulik Paul V.
Ray-Yarletts Jeanine S.
LandOfFree
Using a database for program logs does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Using a database for program logs, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Using a database for program logs will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2456540