Patent US6199070B1 successfully refreshed from Google Patents.
← Back to Patent Explorer
US6199070B1 Expired / Lapsed US ⏱️ 0.0 years remaining

Using a database for program logs

Assignee: International Business Machines Corp
•
Filing: 1998-06-18
•
Granted: 2001-03-06
•
Expires: 2018-06-18
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

Abstract A technique, system, and computer program for using a database to store program logs. Logged information can be created, stored, displayed, and analyzed in a more usable, efficient manner. Log information is preferably stored in two or more tables, enabling reduction of redundant information through database normalization. Message text is preferably stored in computer-readable, as opposed to human-readable, format. This enables optimization of the amount of storage required, and facilitates normalizing the database tables. In addition, translation to the user's national language is made easier, whereby a message code is stored, pointing to an entry in a table that contains message text in the chosen language. The report-generating facilities of the database manager are available for use in analyzing log entries, eliminating the need to write customized reporting software.

Inventors

  • 👤 Felipe Polo-Wood
  • 👤 Peter Williams Volkmar

Bibliographic Details

Application Number —
Jurisdiction US
Data Source google_patents
Last Synchronized 2026-10-31 11:08
CPC Classifications
G; G06; G06F; G06F16/00; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952; Y10S707/99953

Claims Analysis

Total Claims: 15
Claim 1
Independent Claim 83 words
In a computing environment, computer readable code for using a database to store program logs, said computer readable code comprising: a subprocess for generating a plurality of log entries; a subprocess for accessing one or more program logging database tables; a subprocess for using one or more predefined database tables, such that said one or more program logging database tables are at least partially normalized; and a subprocess for storing said generated log entries in said one or more program logging database tables.
Claim 2
Dependent Claim 83 words
In a computing environment, computer readable code for using a database to store program logs, said computer readable code comprising: a subprocess for generating a plurality of log entries; a subprocess for accessing one or more program logging database tables; a subprocess for using one or more predefined database tables, such that said one or more program logging database tables are at least partially normalized; and a subprocess for storing said generated log entries in said one or more program logging database tables.
Claim 3
Dependent Claim 33 words
Computer readable code for using a database to store program logs according to claim 1 , further comprising: a subprocess for using facilities of a database manager to process said stored log entries.
Claim 4
Dependent Claim 41 words
Computer readable code for using a database to store program logs according to claim 2 , wherein each of said generated log entries comprises a plurality of fields, and wherein one or more of said fields are stored in machine-readable format.
Claim 5
Dependent Claim 80 words
Computer readable code for using a database to store program logs according to claim 3 , wherein one of said fields is a sent flag which indicates whether said generated log entry has been sent to a server, and further comprising: a subprocess for sending selected ones of said generated log entries to said server; and a subprocess for setting said sent flag in said selected ones of said generated log entries, responsive to operation of said subprocess for sending.
Claim 6
Independent Claim 76 words
A system for using a database to store program logs in a computing environment, said system comprising: means for generating a plurality of log entries; means for accessing one or more program logging database tables; means for using one or more predefined database tables, such that said one or more program logging database tables are at least partially normalized; and means for storing said generated log entries in said one or more program logging database tables.
Claim 7
Independent Claim 76 words
A system for using a database to store program logs in a computing environment, said system comprising: means for generating a plurality of log entries; means for accessing one or more program logging database tables; means for using one or more predefined database tables, such that said one or more program logging database tables are at least partially normalized; and means for storing said generated log entries in said one or more program logging database tables.
Claim 8
Dependent Claim 31 words
The system for using a database to store program logs according to claim 4 , further comprising: means for using facilities of a database manager to process said stored log entries.
Claim 9
Dependent Claim 40 words
The system for using a database to store program logs according to claim 6 , wherein each of said generated log entries comprises a plurality of fields, and wherein one or more of said fields are stored in machine-readable format.
Claim 10
Dependent Claim 77 words
The system for using a database to store program logs according to claim 7 , wherein one of said fields is a sent flag which indicates whether said generated log entry has been sent to a server, and further comprising: means for sending selected ones of said generated log entries to said server; and means for setting said sent flag in said selected ones of said generated log entries, responsive to operation of said means for sending.
Claim 11
Independent Claim 71 words
A method for using a database to store program logs in a computing environment, said method comprising the steps of: generating a plurality of log entries; accessing one or more program logging database tables; using one or more predefined database tables, such that said one or more program logging database tables are at least partially normalized; and storing said generated log entries in said one or more program logging database tables.
Claim 12
Independent Claim 71 words
A method for using a database to store program logs in a computing environment, said method comprising the steps of: generating a plurality of log entries; accessing one or more program logging database tables; using one or more predefined database tables, such that said one or more program logging database tables are at least partially normalized; and storing said generated log entries in said one or more program logging database tables.
Claim 13
Dependent Claim 32 words
The method for using a database to store program logs according to claim 9 , further comprising the step of using facilities of a database manager to process said stored log entries.
Claim 14
Dependent Claim 40 words
The method for using a database to store program logs according to claim 10 , wherein each of said generated log entries comprises a plurality of fields, and wherein one or more of said fields are stored in machine-readable format.
Claim 15
Dependent Claim 75 words
The method for using a database to store program logs according to claim 11 , wherein one of said fields is a sent flag which indicates whether said generated log entry has been sent to a server, and further comprising the steps of sending selected ones of said generated log entries to said server; and setting said sent flag in said selected ones of said generated log entries, responsive to operation of said sending step.

References Cited (Backward Citations)

US5524241A Cited

USPTO Annuity & Maintenance Windows

Annuity Stage Window Opens Payment Deadline Surcharge Period Until Estimated Fee Status
3.5 Years (Year 4) 2004-03-05 2004-09-04 2005-03-06 $2000.00 Window Closed / Lapsed
7.5 Years (Year 8) 2008-03-05 2008-09-04 2009-03-06 $3760.00 Window Closed / Lapsed
11.5 Years (Year 12) 2012-03-05 2012-09-04 2013-03-06 $7700.00 Window Closed / Lapsed

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag