Patent US3907924A successfully refreshed from Google Patents.
Patent US5544359A successfully refreshed from Google Patents.
US5544359A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Apparatus and method for classifying and acquiring log data by updating and storing log data
Assignee: Google LLC
•
Filing: 1994-03-02
•
Granted: 1996-08-06
•
Expires: 2014-03-02
Abstract
Abstract Historical log data for a plurality of databases are classified for the individual databases. Alternatively, the historical log data associated with the database and user log data are classified. The classified log data are stored in a plurality of volatile buffers. When the nonvolatile buffers are full, the contents of the nonvolatile buffers are temporarily written into the historical log files, following which the classified log data are stored in the nonvolatile buffers.
Inventors
- 👤 Masayuki Tada
- 👤 Hitoshi Suzuki
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-26 22:36
CPC Classifications
G; G06; G06F; G06F11/00; G06F11/07; G06F11/14; G06F11/1471; G06F11/30; G06F11/34; G06F11/3466; G06F11/3476; G06F2201/00; G06F2201/87; Y; Y10; Y10S; Y10S707/00; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 18
Claim 1
Independent Claim
161 words
An apparatus for classifying and acquiring log data in a database system that updates the log data through an execution of a transaction and stores the updated log data in a storage device, comprising: log data acquiring means for acquiring a plurality of log data for each individual transaction executed by a same processor; log data classifying means for classifying the plurality of log data acquired by said log data acquiring means into a plurality of groups of log data according to a predetermined classification condition; a plurality of buffers for storing said plurality of groups of log data classified by said log data classifying means, respectively, each of said plurality of buffers being associated with the predetermined classification condition; and a plurality of historical log files, provided within the storage device, for storing said plurality of groups of log data written from the plurality of buffers, respectively, said plurality of historical log files being associated with the predetermined classification condition.
Claim 2
Independent Claim
161 words
An apparatus for classifying and acquiring log data in a database system that updates the log data through an execution of a transaction and stores the updated log data in a storage device, comprising: log data acquiring means for acquiring a plurality of log data for each individual transaction executed by a same processor; log data classifying means for classifying the plurality of log data acquired by said log data acquiring means into a plurality of groups of log data according to a predetermined classification condition; a plurality of buffers for storing said plurality of groups of log data classified by said log data classifying means, respectively, each of said plurality of buffers being associated with the predetermined classification condition; and a plurality of historical log files, provided within the storage device, for storing said plurality of groups of log data written from the plurality of buffers, respectively, said plurality of historical log files being associated with the predetermined classification condition.
Claim 3
Dependent Claim
16 words
An apparatus as claimed in claim 1, wherein the storage device is an external storage device.
Claim 4
Dependent Claim
47 words
An apparatus as claimed in claim 2 further comprising log data writing means for writing the plurality of groups of log data from said plurality of buffers into the plurality of historical log files within the external storage device in asynchronism with the execution of the transactions.
Claim 5
Dependent Claim
34 words
An apparatus as claimed in claim 3, wherein said log data writing means writes the corresponding groups of log data from said buffers into the plurality of historical log files in a parallel manner.
Claim 6
Dependent Claim
23 words
An apparatus as claimed in claim 1 further comprising a nonvolatile memory, wherein said buffers are nonvolatile buffers provided on the nonvolatile memory.
Claim 7
Dependent Claim
49 words
An apparatus as claimed in claim 5 further comprising a plurality of volatile buffers as internal devices, wherein the volatile buffers are associated with the predetermined classification condition, and wherein the groups of log data are temporarily stored in the volatile buffers and then transferred to the nonvolatile buffers.
Claim 8
Dependent Claim
79 words
An apparatus as claimed in claim 1 further comprising: a transaction file for using in recording an audit trail of the transactions; and transaction end managing means for managing a transaction end in said transaction file, said transaction end managing means recording the transaction end in said transaction file at the time when the corresponding group of log data is ensured in one of the historical log files provided within the storage in the case of the transaction end.
Claim 9
Dependent Claim
30 words
An apparatus as claimed in claim 1 further comprising a plurality of databases, wherein said log data classifying means classifies the log data for each of the plurality of databases.
Claim 10
Dependent Claim
22 words
An apparatus as claimed in claim 1, wherein said log data classifying means classifies the log data for every group of databases.
Claim 11
Dependent Claim
49 words
An apparatus as claimed in claim 1, wherein said log data classifying means classifies updated log data for a database and user log data including types of data other than the updated log data to supply the classified updated and user log data to a plurality of log files.
Claim 12
Independent Claim
135 words
A method for classifying and acquiring log data in a database system that updates the log data through an execution of a transaction and stores the updated log data in a log file, comprising the steps of: acquiring a plurality of log data for each individual transaction executed by a same processor; classifying the acquired plurality of log data into a plurality of groups of data according to a predetermined classification condition; storing the plurality of groups of log data respectively into a plurality of buffers, each of said plurality of buffers being associated with the predetermined classification condition; and writing the plurality of groups of log data stored in the plurality of buffers respectively into a plurality of log files, each of said plurality of log files being associated with the predetermined classification condition.
Claim 13
Independent Claim
135 words
A method for classifying and acquiring log data in a database system that updates the log data through an execution of a transaction and stores the updated log data in a log file, comprising the steps of: acquiring a plurality of log data for each individual transaction executed by a same processor; classifying the acquired plurality of log data into a plurality of groups of data according to a predetermined classification condition; storing the plurality of groups of log data respectively into a plurality of buffers, each of said plurality of buffers being associated with the predetermined classification condition; and writing the plurality of groups of log data stored in the plurality of buffers respectively into a plurality of log files, each of said plurality of log files being associated with the predetermined classification condition.
Claim 14
Dependent Claim
27 words
A method as claimed in claim 11, wherein the groups of log data are stored in corresponding nonvolatile buffers each being associated with the predetermined classification condition.
Claim 15
Dependent Claim
52 words
A method as claimed in claim 12, wherein the groups of log data stored in the nonvolatile buffers are written into log files if the nonvolatile buffers are full before the classified log data are stored in the nonvolatile buffers, following which the classified log data are stored in the nonvolatile buffers.
Claim 16
Dependent Claim
43 words
A method as claimed in claim 12, wherein the classified groups of log data are temporarily stored in a plurality of volatile buffers each being associated with the predetermined classification condition before the groups of log data are written into the nonvolatile buffers.
Claim 17
Dependent Claim
18 words
A method as claimed in claim 11, wherein the groups of log data are classified for individual databases.
Claim 18
Dependent Claim
28 words
A method as claimed in claim 11, wherein user log data and updated log data for a database are classified and supplied to the plurality of log files.
References Cited (Backward Citations)
US4159517A
Cited
EP0097234A2
Cited
US4507751A
Cited
JPS5958566A
Cited
JPS602036A
Cited
JPS61133450A
Cited
US5043871A
Cited
EP0250847A2
Cited
US5115392A
Cited
US5151988A
Cited
US5333314A
Cited
JPS6421649A
Cited
US5319780A
Cited
US5043866A
Cited
US5193188A
Cited
US5140689A
Cited
JPH0327184A
Cited
EP0420425A2
Cited
US5201044A
Cited
US5390302A
Cited
US5280611A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1999-08-06 | 2000-02-05 | 2000-08-06 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2003-08-06 | 2004-02-05 | 2004-08-06 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2007-08-06 | 2008-02-05 | 2008-08-06 | $7700.00 | Window Closed / Lapsed |