# US 2025/0165453 A1 · Unified persistence overall feature

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

- Number: US 2025/0165453 A1
- Document ID: US20250165453A1
- Status: Published application
- Kind: A1
- Application number: 18/515,731
- Filed: 2023-11-21
- Published: 2025-05-22
- Earliest claimed: 2023-11-21
- Assignees: Sap SE
- Applicants: Sap SE
- Inventors: Janardhan Hungund; Amit Pathak; Amit Saonerker; Deepak Shrivastava; Souvik Pal; Sebastian Seifert; Robert Schulze; Mihnea Andrei
- Web page: https://patentgrep.com/patent/US20250165453A1

## CPC

- G06F 16/2291: {User-Defined Types; Storage management thereof}
- G06F 16/2365: {Ensuring data consistency and integrity}
- G06F 16/22: Indexing; Data structures therefor; Storage structures
- G06F 16/23: Updating
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A database system detects an operation to move a first database object from an in-memory store to a persistence store, wherein the first database object is in either a page-loadable or column-loadable format in the in-memory store, and wherein the first database object comprises a plurality of subcomponents. Each subcomponent of the first database object is examined separately from other subcomponents of the plurality of subcomponents. In response to determining that a first subcomponent of the plurality of subcomponents has a datatype and a compression type supported by a unified persistence format, the first subcomponent is stored in a unified persistence format in the persistence store. In response to determining that a second subcomponent of the plurality of subcomponents has either a datatype or a compression type which is not supported by the unified persistence format, the second subcomponent is stored in a serial persistence format in the persistence store.

## Claims

### Claim 1

A method performed by a database system, comprising:
detecting an operation to move a first database object from an in-memory store to a persistence store, wherein the first database object is in a first format in the in-memory store, and wherein the first database object comprises a plurality of subcomponents;
examining each subcomponent of the first database object individually and separately from other subcomponents of the plurality of subcomponents;
responsive to determining that a first subcomponent of the plurality of subcomponents has a datatype and a compression type supported by a unified persistence format, storing the first subcomponent in the unified persistence format in the persistence store; and
responsive to determining that a second subcomponent of the plurality of subcomponents has either a datatype or a compression type which is not supported by the unified persistence format, storing the second subcomponent in a serial persistence format in the persistence store.

### Claim 2 (depends on 1)

The method of claim 1, further comprising:
detecting an operation to move a second database object from the in-memory store to the persistence store, wherein the second database object is in a second format in the in-memory store, and wherein the second format is different from the first format; and
responsive to determining that both the first database object and the second database object meet one or more conditions, storing both the first database object and the second database object in the unified persistence format in the persistence store, wherein the unified persistence format enables format conversion without requiring a persistence rewrite.

### Claim 3 (depends on 2)

The method of claim 2, wherein the first format is a column-loadable format, and wherein the second format is a page-loadable format.

### Claim 4 (depends on 3)

The method of claim 3, further comprising loading a third database object from the persistence store to the in-memory store in either the column-loadable format or the page-loadable format without causing a rewrite of the third database object in the persistence store responsive to determining that the third database object is stored in the unified persistence format.

### Claim 5 (depends on 4)

The method of claim 4, further comprising determining a load format of the third database object based at least on memory utilization of the in-memory store and based at least on an access frequency of the third database object.

### Claim 6 (depends on 4)

The method of claim 4, further comprising loading a first subcomponent of the third database object from the persistence store to the in-memory store in the column-loadable format and loading a second subcomponent of the third database object from the persistence store to the in-memory store in the page-loadable format responsive to determining that the third database object is stored in the unified persistence format.

### Claim 7 (depends on 4)

The method of claim 4, wherein for the page-loadable format, only pages relevant to a corresponding query are loaded into the in-memory store.

### Claim 8 (depends on 7)

The method of claim 7, wherein for the column-loadable format, an entirety of a corresponding database object is loaded into the in-memory store.

### Claim 9 (depends on 8)

The method of claim 8, wherein the column-loadable format comprises having a data subcomponent, a dictionary subcomponent, and an index subcomponent of a corresponding database object serialized together into a single page chain.

### Claim 10 (depends on 9)

The method of claim 9, wherein the page-loadable format comprises having a separate page chain for each of the data subcomponent, the dictionary subcomponent, and the index subcomponent of the first database object.

### Claim 11 (depends on 10)

The method of claim 10, wherein the unified persistence format comprises having a separate page chain for each of the data subcomponent, the dictionary subcomponent, and the index subcomponent of the first database object.

### Claim 12 (depends on 11)

The method of claim 11, wherein a first condition, of the one or more conditions, comprises a datatype of a first subcomponent of the first database object being supported by the unified persistence format.

### Claim 13 (depends on 12)

The method of claim 12, wherein a second condition, of the one or more conditions, comprises a type of compression used to compress a first subcomponent of the first database object being supported by the unified persistence format.

### Claim 14 (depends on 13)

The method of claim 13, further comprising storing a second subcomponent of the first database object in an alternate persistence format responsive to determining that a type of compression used to compress the second subcomponent is not supported by the unified persistence format.

### Claim 15

A system, comprising:
at least one processor; and
at least one memory including program instructions which when executed by the at least one processor causes operations comprising:
detecting an operation to move a first database object from an in-memory store to a persistence store, wherein the first database object is in a first format in the in-memory store, and wherein the first database object comprises a plurality of subcomponents;
examining each subcomponent of the first database object individually and separately from other subcomponents of the plurality of subcomponents;
responsive to determining that a first subcomponent of the plurality of subcomponents has a datatype and a compression type supported by a unified persistence format, storing the first subcomponent in the unified persistence format in the persistence store; and
responsive to determining that a second subcomponent of the plurality of subcomponents has either a datatype or a compression type which is not supported by the unified persistence format, storing the second subcomponent in a serial persistence format in the persistence store.

### Claim 16 (depends on 15)

The system of claim 15, wherein the program instructions are further executable by the at least one processor to cause operations comprising:
detecting an operation to move a second database object from the in-memory store to the persistence store, wherein the second database object is in a second format in the in-memory store, and wherein the second format is different from the first format; and
responsive to determining that both the first database object and the second database object meet one or more conditions, storing both the first database object and the second database object in the unified persistence format in the persistence store, wherein the unified persistence format enables format conversion without requiring a persistence rewrite.

### Claim 17 (depends on 16)

The system of claim 16, wherein the first format is a column-loadable format, and wherein the second format is a page-loadable format.

### Claim 18 (depends on 17)

The system of claim 17, wherein the program instructions are further executable by the at least one processor to cause operations comprising loading a third database object from the persistence store to the in-memory store in either the column-loadable format or the page-loadable format without causing a rewrite of the third database object in the persistence store responsive to determining that the third database object is stored in the unified persistence format.

### Claim 19 (depends on 18)

The system of claim 18, wherein the program instructions are further executable by the at least one processor to cause operations comprising determining a load format of the third database object based at least on memory utilization of the in-memory store and based at least on an access frequency of the third database object.

### Claim 20

A non-transitory computer readable medium storing instructions, which when executed by at least one data processor, cause operations comprising:
detecting an operation to move a first database object from an in-memory store to a persistence store, wherein the first database object is in a first format in the in-memory store, and wherein the first database object comprises a plurality of subcomponents;
examining each subcomponent of the first database object individually and separately from other subcomponents of the plurality of subcomponents;
responsive to determining that a first subcomponent of the plurality of subcomponents has a datatype and a compression type supported by a unified persistence format, storing the first subcomponent in the unified persistence format in the persistence store; and
responsive to determining that a second subcomponent of the plurality of subcomponents has either a datatype or a compression type which is not supported by the unified persistence format, storing the second subcomponent in a serial persistence format in the persistence store.
