Application of log records by storage servers

• US 20060218200A1
• Filed: 03/24/2005
• Published: 09/28/2006
• Est. Priority Date: 03/24/2005
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Valentin, Gary, Zlotnick, Aviad, Satran, Julian, Factor, Michael
• Application Number:
  US11/088,701
• Publication Number:
  US 20060218200A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27

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.

Claims

1. 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.

2. The method according to claim 1, wherein said log entry is an instruction to said storage server for updating said database record responsively to said modification.

3. The method according to claim 1, wherein said storage server has a database table space and a plurality of logical volumes, further comprising the steps of:

designating one of said logical volumes as a log volume to receive said log entry;

establishing a one-to-one mapping between said database table space and said log volume; and

identifying said database record using said mapping.

4. The method according to claim 1, wherein said step of updating said database record comprises the steps of:

establishing a copy of said database manager on said storage server; and

executing said copy to identify said database record and to apply said log entry for updating thereof.

5. The method according to claim 4, further comprising the step of establishing a virtual machine in said storage server, wherein said copy is a component of said virtual machine.

6. The method according to claim 1, wherein said step of updating said database record comprises the step of:

emulating said database manager on said storage server to identify said database record and to apply said log entry for updating thereof.

7. The method according to claim 1, further comprising the steps of maintaining a heartbeat synchronization between said host server and said storage server.

8. The method according to claim 1, further comprising the steps of:

subsequent to performing said step of transmitting a log entry and prior to completing said update of said database record by said storage server, initiating a read operation on said database record; and

thereafter delaying said read operation until completion of said update of said database record by said storage server.

9. The method according to claim 1, further comprising the steps of:

subsequent to performing said step of transmitting a log entry and prior to completing said update of said database record by said storage server, initiating a read operation on said database record; and

thereafter immediately applying said log entry to update said database record.

10. 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.

11. The computer software product according to claim 10, wherein said log entry is an instruction to said storage server for updating said database record responsively to said modification.

12. The computer software product according to claim 10, wherein said storage server has a database table space and a plurality of logical volumes, further comprising the steps of:

designating one of said logical volumes as a log volume to receive said log entry;

establishing a one-to-one mapping between said database table space and said log volume; and

identifying said database record using said mapping.

13. The computer software product according to claim 10, wherein said step of updating said database record comprises the steps of:

establishing a copy of said database manager on said storage server; and

executing said copy to identify said database record and to apply said log entry for updating thereof.

14. The computer software product according to claim 13, further comprising the step of establishing a virtual machine in said storage server, wherein said copy is a component of said virtual machine.

15. The computer software product according to claim 10, wherein said step of updating said database record comprises the step of:

emulating said database manager on said storage server to identify said database record and to apply said log entry for updating thereof.

16. The computer software product according to claim 10, further comprising the steps of maintaining a heartbeat synchronization between said host server and said storage server.

17. The computer software product according to claim 10, further comprising the steps of:

subsequent to performing said step of transmitting a log entry and prior to completing said update of said database record by said storage server, initiating a read operation on said database record; and

thereafter delaying said read operation until completion of said update of said database record by said storage server.

18. The computer software product according to claim 10, further comprising the steps of:

subsequent to performing said step of transmitting a log entry and prior to completing said update of said database record by said storage server, initiating a read operation on said database record; and

thereafter immediately applying said log entry to update said database record.

19. 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.

20. The database management system according to claim 19, wherein said storage server has a database table space and a plurality of logical volumes, said storage server having a one-to-one mapping between said database table space and said logical volumes, said storage server being operative to identify said database record using said mapping.

21. The database management system according to claim 19, wherein said storage server has a copy of said database manager executing thereon to identify said database record and to apply said log entry for updating thereof.

22. The database management system according to claim 21, wherein said storage server has a virtual machine executing thereon, wherein said copy is a component of said virtual machine.

23. The database management system according to claim 19, wherein said storage server has an emulator of said database manager executing thereon to identify said database record and to apply said log entry for updating thereof.

24. The database management system according to claim 19, wherein said host server and said storage server are operative to maintain a heartbeat synchronization therebetween.

25. The database management system according to claim 19, wherein said storage server is operative to delay a read operation on said database record that is initiated subsequent to said transmission of said modification until completion of an updating of said database record by said storage server.

26. The database management system according to claim 19, wherein said storage server is operative subsequent to transmission of said log entry and prior to completion of said update of said database record by said storage server, for responding to a read operation on said database record by immediately applying said log entry to update said database record.