Application of log records by storage servers
AssigneeInternational Business Machines Corporation
InventorsMichael Factor, Julian Satran, Gary Valentin, Aviad Zlotnick
Life of this patent
Estimating the term…
Abstract
Logging and storage transactions in a database are directed to a single storage server. A modification of a database record is written only once to a log record on the storage server. Subsequently, the storage server interprets the database log records, and modifies the database storage accordingly. The number of bytes written to storage is potentially reduced by fifty percent as compared to writing the log record and then writing the modified database record to the storage server.
Claims26
A method of modifying a computer-implemented database, comprising the steps of:
- executing a database manager on a host server for managing said database;
- on said host server preparing a modification of a database record of said database;
- transmitting a log entry indicative of said modification exactly one time from said host server to a storage server that holds said database record, said log entry comprising less information than said database record;
- interpreting said log entry on said storage server;
- and
- wherein responsively to said interpretation of said log entry said storage server updates said database record responsively to said modification.
A computer software product, including a computer-readable medium in which computer program instructions are stored, which instructions, when read by one or more computers, cause the computers to perform a method for modifying a database, comprising the steps of:
- executing a database manager on a host server for managing said database;
- on said host server preparing a modification of a database record of said database;
- transmitting a log entry indicative of said modification exactly one time from said host server to a storage server that holds said database record, said log entry comprising less information than said database record;
- interpreting said log entry on said storage server;
- and
- wherein responsively to said interpretation of said log entry said storage server updates said database record responsively to said modification.
A database management system, comprising:
- a host server having a database manager executing thereon, said host server being operative to prepare a modification of a database record that is managed by said database manager;
- a storage server that stores said database record, said storage server being linked to said host server and accepting a transmission of said modification exactly one time as a log entry from said host server, said log entry describing said modification and comprising less information than said database record;
- and
- said storage server being operative to update said database record responsively to said log entry.
Dependencies are inferred from the claim text.