Database system for triggering event notifications based on updates to database records
US-2024419652-A1 · Dec 19, 2024 · US
US10949415B2 · US · B2
| Field | Value |
|---|---|
| Publication number | US-10949415-B2 |
| Application number | US-201113077574-A |
| Country | US |
| Kind code | B2 |
| Filing date | Mar 31, 2011 |
| Priority date | Mar 31, 2011 |
| Publication date | Mar 16, 2021 |
| Grant date | Mar 16, 2021 |
A practical reading order for non-experts. Skip the full description unless you need deep technical detail.
What the patent document calls the invention.
A short plain-language summary of the technical disclosure.
Who owns or filed the patent and who is credited as inventor.
Filing, priority, publication, and grant dates set the timeline.
The legal scope of protection — read this for what is actually claimed.
Technology tags used to group this patent with similar filings.
Prior art links and similar publications in this corpus.
Official abstract text for this publication.
A computer program product, including: a computer readable storage device to store a computer readable program, wherein the computer readable program, when executed by a processor within a computer, causes the computer to perform operations for logging. The operations include: receiving a transaction including data and a log record corresponding to the data; writing the data to a data storage device; and writing the log record to a log space on a persistent memory device coupled to the data storage device.
Opening claim text (preview).
What is claimed is: 1. A computer program product, comprising: a computer readable storage device to store a computer readable program, wherein the computer readable program, when executed by a processor within a computer, causes the computer to perform operations for logging, the operations comprising: receiving a transaction comprising data and a log record corresponding to the data; separating the data and the log record corresponding to the data; writing the data to a memory buffer on a main memory device for at least temporary storage in the main memory device; writing the log record directly to a log space on a persistent memory device that is separate from the main memory device for at least temporary storage in the persistent memory device, wherein the persistent memory device is a storage class memory device comprising phase change memory, wherein the log record is written to the persistent memory device without any intervening cache of the log record in the memory buffer storing the data, a log buffer, and/or other volatile memory device; storing the data from the memory buffer to a data file on a data storage device via a first write operation; and archiving the log record to a log file on the data storage device via a second write operation that is separate from the first write operation in response to a predetermined condition of the log space, wherein the second write operation is asynchronous with respect to the first write operation, and wherein the data storage device, the main memory device, and the persistent memory device are different devices. 2. The computer program product of claim 1 , wherein the predetermined condition of the log space comprises a determination that a size of log records and other data within the log space is above a watermark, the watermark comprising a configurable parameter used to specify a level of log space used before starting a log archival process. 3. The computer program product of claim 1 , wherein the computer program product, when executed on the computer, causes the computer to perform additional operations, comprising: managing a plurality of log records in the log space using a log space manager on the persistent memory device according to the log records received by the persistent memory device. 4. The computer program product of claim 3 , wherein the log space manager is further configured to: communicate with an operating system corresponding to the logging system to initialize and remove the log space on the persistent memory device according to the log records received by the persistent memory device; and allocate chunks on the log space for subsystems within the logging system to write the log records. 5. The computer program product of claim 1 , wherein the computer program product, when executed on the computer, causes the computer to perform additional operations, comprising: acquiring an address of the log space on the persistent memory device; locating a most recent checkpoint log record; reading each log record after the checkpoint log record; and restoring a system state. 6. A method for logging, comprising: receiving a transaction comprising data and a log record corresponding to the data; separating the data and the log record corresponding to the data; writing the data to a memory buffer on a main memory device for at least temporary storage in the main memory device; writing the log record directly to a log space on a persistent memory device that is separate from the main memory device for at least temporary storage in the persistent memory device, wherein the persistent memory device is a storage class memory device comprising phase change memory, wherein the log record is written to the persistent memory device without any intervening cache of the log record in the memory buffer storing the data, a log buffer, and/or other volatile memory device; storing the data from the memory buffer to a data file on a data storage device via a first write operation; and archiving the log record to a log file on the data storage device via a second write operation that is separate from the first write operation in response to a predetermined condition of the log space, wherein the second write operation is asynchronous with respect to the first write operation, and wherein the data storage device, the main memory device, and the persistent memory device are different devices. 7. The method of claim 6 , wherein the predetermined condition of the log space comprises a determination that a size of log records and other data within the log space is above a watermark, the watermark comprising a configurable parameter used to specify a level of log space used before starting a log archival process. 8. The method of claim 6 , further comprising managing a plurality of log records in the log space using a log space manager on the persistent memory device according to the log records received by the persistent memory device. 9. The method of claim 8 , wherein the log space manager is further configured to: communicate with an operating system corresponding to the logging system to initialize and remove the log space on the persistent memory device according to the log records received by the persistent memory device; and allocate chunks on the log space for subsystems within the logging system to write the log records. 10. The method of claim 6 , further comprising: acquiring an address of the log space on the persistent memory device; locating a most recent checkpoint log record; reading each log record after the checkpoint log record; and restoring a system state. 11. A logging system, comprising: a processor configured to: receive a transaction comprising data and a log record corresponding to the data; and separate the data and the log record corresponding to the data; a main memory device comprising a data buffer configured to at least temporarily store the data corresponding to the transaction; a persistent memory device comprising a log space configured to directly and at least temporarily store the log record corresponding to the transaction without any intervening cache of the log record in a log buffer, the memory buffer and/or other volatile memory device, wherein the persistent memory device is a storage class memory device comprising phase change memory; a data storage device coupled to the persistent memory device and the main memory device, wherein the data storage device comprises: a data file configured to store the data from the memory buffer on the main memory device in a first operation; and a log file configured to archive the log record from the log space on the persistent memory device in a second write operation file and in response to a predetermined condition of the log space, wherein the second write operation is asynchronous with respect to the first write operation. 12. The system of claim 11 , wherein the persistent memory device further comprises a log space manager configured to manage a plurality of log records in the log space on the persistent memory device according to the log records received by the persistent memory device. 13. The system of claim 12 , wherein the log space manager is further configured to: communicate with an operating system corresponding to the logging system to initialize and remove the log space on the persistent memory device according to the log records received by the persistent memory device; and allocate chunks on the log space for subsystems within the logging system to write the log records. 14. The system of claim 11 , further comprising a recovery subs
Updates performed during online database operations; commit processing · CPC title
Related publications grouped by family.
Answers are generated from the same data shown on this page.