# US 2017/0286477 A1 · Database system recovery using non-volatile system memory

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2017/0286477 A1
- Document ID: US20170286477A1
- Status: Published application
- Kind: A1
- Application number: 15/627,338
- Filed: 2017-06-19
- Published: 2017-10-05
- Earliest claimed: 2013-09-04
- Assignees: Amazon Technologies, Inc.
- Applicants: Amazon Technologies, Inc.
- Inventors: Adam Douglas Morley; Swaminathan Sivasubramanian
- Web page: https://patentgrep.com/patent/US20170286477A1

## CPC

- G06F 11/1469: {Backup restoration techniques}
- G06F 16/22: Indexing; Data structures therefor; Storage structures
- G06F 16/23: Updating
- G06F 16/2358: {Change logging, detection, and notification (replication G06F16/27)}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A database system may implement database system recovery using non-volatile system memory. An update to a data page of a database may be received. A version of the data page may be obtained in system memory. A new version of the data page may be determined according to the received update. The new version of the data page may be maintained in a non-volatile portion of system memory irrespective of a failure of the database. In at least some embodiments, the update may be performed without generating recovery log records indicating the update. Upon recovery from a database failure, data pages maintained in non-volatile system memory may be made available to service access requests.

## Claims

### Claim at position 1

-21. (canceled)

### Claim 22

A system, comprising:
a data store, configured to store one or more data pages for a database;
system memory, wherein at least a portion of the system memory is a non-volatile memory portion; and
a database engine, wherein the database engine is configured to:
store a data page of the database in the non-volatile memory portion, wherein a copy of the data page is stored in the data store; and
access the data page from the non-volatile memory portion.

### Claim 23 (depends on 22)

The system of claim 22, wherein the database engine is further configured to:
receive an update to the data page of the database;
determine a new version of the data page according to the received update to the data page; and
store in the non-volatile memory portion the new version of the data page.

### Claim 24 (depends on 23)

The system of claim 23, wherein the database engine is further configured to:
perform the determining of the new version of the data page and the storing of the new version of the data page without writing a log for the update to the data page.

### Claim 25 (depends on 23)

The system of claim 23, wherein the database engine is further configured to:
flush the new version of the data page from the non-volatile memory portion to the data store.

### Claim 26 (depends on 22)

The system of claim 22,
wherein at least another portion of the system memory is a volatile memory portion that stores another data page of the one or more data pages of the database, wherein a copy of the other data page is stored in the data store; and
wherein the database engine is further configured to:
receive an update to the other data page;
determine a new version of the other data page according to the received update to the other data page;
store the new version of the other data page in the non-volatile memory portion; and
invalidate the other data page in the volatile memory portion.

### Claim 27 (depends on 26)

The system of claim 26, wherein the database engine is further configured to:
receive a read request for the other data page; and
read the new version of the data page from the non-volatile memory portion in order service the read request for the other data page.

### Claim 28

A method, comprising:
storing a data page of a database in a non-volatile memory portion of system memory of a computing device, wherein a copy of the data page is stored in a data store other than the system memory; and
accessing the data page from the non-volatile memory portion of the system memory.

### Claim 29 (depends on 28)

The method of claim 28, further comprising:
receiving an update to the data page of the database;
determining a new version of the data page according to the received update to the data page; and
storing in the non-volatile memory portion the new version of the data page.

### Claim 30 (depends on 29)

The method of claim 29, further comprising:
determining the new version of the data page and storing the new version of the data page without writing a log for the update to the data page.

### Claim 31 (depends on 29)

The method of claim 29, further comprising:
flushing the new version of the data page from the non-volatile memory portion to the data store.

### Claim 32 (depends on 28)

The method of claim 28, further comprising:
receiving an update to another data page of the database that is stored in a volatile memory portion of the system memory, wherein a copy of the other data page is stored in the data store;
determining a new version of the other data page according to the received update to the other data page; and
storing the new version of the other data page in the non-volatile memory portion.

### Claim 33 (depends on 32)

The method of claim 32, further comprising:
receiving a read request for the other data page; and
reading the new version of the data page from the non-volatile memory portion in order service the read request for the other database page.

### Claim 34 (depends on 28)

The method of claim 28, wherein the computing device implements at least a portion of a multi-tenant, network-based, database service, wherein the database service maintains one or more databases including the database for one or more clients, and wherein the update to the data page is received from one of the one or more clients of the database service.

### Claim 35

A non-transitory, computer-readable storage medium, storing program instructions that when executed by a computing device implements:
storing a data page of a database in a non-volatile memory portion of system memory of the computing device, wherein a copy of the data page is stored in a data store other than the system memory; and
accessing the data page from the non-volatile memory portion of the system memory.

### Claim 36 (depends on 35)

The non-transitory, computer-readable storage medium of claim 35, wherein the program instructions further implement:
receiving an update to the data page of the database;
determining a new version of the data page according to the received update to the data page; and
storing in the non-volatile memory portion the new version of the data page.

### Claim 37 (depends on 36)

The non-transitory, computer-readable storage medium of claim 36, wherein the program instructions further implement:
determining the new version of the data page and storing the new version of the data page without writing a log for the update to the data page.

### Claim 38 (depends on 35)

The non-transitory, computer-readable storage medium of claim 35, wherein the program instructions further implement:
receiving an update to another data page of the database that is stored in a volatile memory portion of the system memory, wherein a copy of the other data page is stored in the data store;
determining a new version of the other data page according to the received update to the other data page; and
storing the new version of the other data page in the non-volatile memory portion.

### Claim 39 (depends on 38)

The non-transitory, computer-readable storage medium of claim 38, wherein the program instructions further implement:
invalidating the other data page in the volatile memory portion.

### Claim 40 (depends on 38)

The non-transitory, computer-readable storage medium of claim 38, wherein read performance of the volatile memory portion is faster than read performance of the non-volatile memory portion.

### Claim 41 (depends on 36)

The non-transitory, computer-readable storage medium of claim 36, wherein the program instructions further implement:
upon recovery from a system failure, making the new version of the data page in the non-volatile portion of the system memory available for servicing access requests without applying a log record to the data page.
