Transaction processing systems and methods utilizing non-disk persistent memory

• US 7,383,290 B2
• Filed: 03/09/2004
• Issued: 06/03/2008
• Est. Priority Date: 03/09/2004
• Status: Active Grant

• Current Assignee: Hewlett Packard Enterprise Development LP (Hewlett-Packard Enterprise Company)
• Original Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Inventors: Fineberg, Sam, Smith, Gary S., Mehra, Pankaj
• Primary Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US10/797,258
• Publication Number:
  US 20050203961A1
• Time in Patent Office: 1,547 Days
• Field of Search: 707/101, 707/202, 707/8, 707/200, 707/201
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1492 by run-time replication performed by the application software
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

In at least one embodiment, transaction processing systems comprise non-disk persistent memory that is utilized to commit transactions.

Claims

1. A transaction processing system comprising:

a database writer configured to process data in accordance with one or more transactions within the transaction processing system;

a transaction monitor for monitoring transactions within the transaction processing system;

a log writer for maintaining audit trail data associated with transactions within the transaction processing system; and

one or more non-disk persistent memory units comprising a primary non-disk persistent memory unit and a mirror non-disk persistent memory unit, associated with the log writer and configured to receive, from the log writer, audit trail data;

wherein the log writer is configured to first write audit trail data to the primary non-disk persistent memory unit and then write the audit trail data to the mirror non-disk persistent memory unit.

2. The transaction processing system of claim 1, wherein the log writer comprises a primary audit disk process and a backup audit disk process.

3. The transaction processing system of claim 1, wherein the one or more non-disk persistent memory units comprise a write aside buffer configured to receive the audit trail data, the write aside buffer being configured as a circular buffer.

4. A transaction processing system comprising:

a database writer configured to process data in accordance with one or more transactions within the transaction processing system;

a transaction monitor for monitoring transactions within the transaction processing system;

a log writer for maintaining audit trail data associated with transactions within the transaction processing system;

one or more non-disk persistent memory units associated with the log writer and configured to receive, from the log writer, audit trail data, wherein the memory units comprise a primary non-disk persistent memory unit and a mirror non-disk persistent memory unit; and

one or more audit log disks configured to receive audit trail data that is first received by the one or more non-disk persistent memory units;

wherein the log writer is configured to first write audit trail data to the primary non-disk persistent memory unit and then write the audit trail data to the mirror non-disk persistent memory unit.

5. The system of claim 4, wherein the log writer is configured to cause the audit trail data in the one or more non-disk persistent memory units to be written to the one or more audit log disks when a non-disk persistent memory unit threshold is reached or exceeded.

6. The system of claim 4, wherein the transaction processing system is configured to commit transactions before associated audit trail data is written to the one or more audit log disks.

7. The system of claim 4, wherein the transaction processing system is configured to commits transactions after associated audit trail data is received by the one or more non-disk persistent memory units and before the associated audit trail data is written to the one or more audit log disks.

8. The system of claim 4, wherein the log writer comprises a primary audit disk process and a backup audit disk process.

9. The system of claim 4, wherein the one or more non-disk persistent memory units comprise a write aside buffer configured to receive the audit trail data, the write aside buffer being configured as a circular buffer.

10. A method comprising:

receiving data associated with transaction-induced state changes, wherein the act of receiving is performed by a log writer comprising primary and backup audit disk processes; and

writing the received data to non-disk persistent memory sufficient to commit an associated transaction, wherein the act of writing comprises writing the received data to first and second non-disk persistent memory units.

11. The method of claim 10, wherein the first non-disk persistent memory unit comprises a primary non-disk persistent memory unit and the second non-disk persistent memory unit comprises a mirror non-disk persistent memory unit.

12. The method of claim 10, wherein the first non-disk persistent memory unit comprises a primary non-disk persistent memory unit and the second non-disk persistent memory unit comprises a mirror non-disk persistent memory unit and the act of writing comprises first writing the received data to the primary non-disk persistent memory unit and then writing the received data to the mirror non-disk persistent memory unit.

13. The method of claim 10, wherein the first non-disk persistent memory unit comprises a primary non-disk persistent memory unit and the second non-disk persistent memory unit comprises a mirror non-disk persistent memory unit and the act of writing comprises concurrently writing the received data to the primary non-disk persistent memory unit and the mirror non-disk persistent memory unit.

14. The method of claim 10 further comprising after writing the received data to the non-disk persistent memory, writing the transaction-induced state change data to one or more audit log disks.

15. The method of claim 10 further comprising after writing the received data to the non-disk persistent memory, writing the transaction-induced state change data to one or more audit log disks, wherein the act of writing the transaction-induced state change data to the one or more audit log disks comprises doing so responsive to a threshold associated with the non-disk persistent memory being reached or exceeded.

16. A method comprising:

maintaining at least two write aside buffers in non-disk persistent memory, a first of the buffers comprising a primary buffer, a second of the buffers comprising a mirror buffer;

synchronously flushing audit data associated with one or more transactions to said at least two write aside buffers, wherein said act of synchronously flushing is sufficient to commit an associated transaction; and

when a predetermined condition is met, writing the audit data in the write aside buffers to one or more audit log disks.

17. The method of claim 16, wherein the act of maintaining comprises maintaining said buffers as circular buffers.

18. The method of claim 16, wherein the predetermined condition comprises a threshold condition.

19. The method of claim 16, wherein said acts are performed by a transaction processing system that comprises a database writer component, a transaction monitor component and a log writer component, each component being implemented as a primary-backup process pair.

20. A method comprising:

receiving data associated with transaction-induced state changes; and

writing the received data to non-disk persistent memory sufficient to commit an associated transaction, wherein the act of writing comprises writing the received data to first and second non-disk persistent memory units, the first non-disk persistent memory unit comprising a primary non-disk persistent memory unit, the second non-disk persistent memory unit comprising a mirror non-disk persistent memory unit.

21. A method comprising:

receiving data associated with transaction-induced state changes; and

writing the received data to non-disk persistent memory sufficient to commit an associated transaction, wherein the act of writing comprises writing the received data to first and second non-disk persistent memory units, the first non-disk persistent memory unit comprising a primary non-disk persistent memory unit, the second non-disk persistent memory unit comprising a mirror non-disk persistent memory unit, the act of writing comprising first writing the received data to the primary non-disk persistent memory unit and then writing the received data to the mirror non-disk persistent memory unit.

22. A method comprising:

receiving data associated with transaction-induced state changes; and

writing the received data to non-disk persistent memory sufficient to commit an associated transaction, wherein the act of writing comprises writing the received data to first and second non-disk persistent memory units, the first non-disk persistent memory unit comprising a primary non-disk persistent memory unit, the second non-disk persistent memory unit comprising a mirror non-disk persistent memory unit, the act of writing comprising concurrently writing the received data to the primary non-disk persistent memory unit and the mirror non-disk persistent memory unit.

23. A method comprising:

receiving data associated with transaction-induced state changes;

writing the received data to non-disk persistent memory sufficient to commit an associated transaction, wherein the act of writing comprises writing the received data to first and second non-disk persistent memory units; and

after writing the received data to the non-disk persistent memory, writing the transaction-induced state change data to one or more audit log disks.

24. A method comprising:

receiving data associated with transaction-induced state changes;

writing the received data to non-disk persistent memory sufficient to commit an associated transaction; and

after writing the received data to the non-disk persistent memory, writing the transaction-induced state change data to one or more audit log disks, wherein the act of writing the transaction-induced state change data to the one or more audit log disks comprises doing so responsive to a threshold associated with the non-disk persistent memory being reached or exceeded.