Archiving objects in a database environment

Patent metadata

Field	Value
Publication number	US-11640378-B2
Application number	US-202117358573-A
Country	US
Kind code	B2
Filing date	Jun 25, 2021
Priority date	Jan 7, 2019
Publication date	May 2, 2023
Grant date	May 2, 2023

Abstract

A method is provided for processing a query. In some embodiments, the method includes creating a historical schema defining an ordered set of fields based on a current schema of an object and a field modification of the current schema. The method includes inserting, based on the field modification, a new field at an end of the historical schema and archiving records into a second storage device. The method includes receiving a query, which includes a command specifying a subset of fields and which indicates a non-current field. The method includes searching in the second storage device for archive records having a second schema including the subset of fields and the non-current field. The first and second schemas follow the field order in accordance with the historical schema. The method further includes accessing the subset of fields and the non-current field in accordance with the command.

First claim

What is claimed is:

1. A computing device comprising:
a memory configured to store, for an object, a plurality of archive records of tenant-specific object versions comprising first tenant-specific object version having a first historical schema, a first current schema and first metadata; and
one or more processors coupled to the memory and configurable to execute the machine executable code to cause the one or more processors to:
receive a query including a command specifying a subset of fields based on the object;
determine, by decomposing the query into the subset of fields, whether the query includes a non-current field absent from the current schema;
search, the plurality of tenant-specific object versions in the memory, for at least one tenant-specific object version including the subset of fields and the non-current field according to timestamps included in metadata associated with the tenant-specific object versions; and
access the subset of fields and the non-current field in accordance with the command.

2. The computing device of claim 1 , wherein the first current schema comprises a field modification from the first historical schema, the field modification including at least one of an addition of a field to the object, a modification of a definition of the field, or removal of the field from the object.

3. The computing device of claim 1 , wherein the machine executable code further causes the one or more processors to:
snapshot the first current schema, wherein the first historical schema includes the snapshot and at least one new field inserted at the end of the historical schema.

4. The computing device of claim 1 , wherein the machine executable code further causes the one or more processors to:
search the first metadata for a second schema including the subset of fields; and
identify a schema identifier (ID) that identifies the second schema, the set of archive records including the schema ID.

5. The computing device of claim 4 , wherein the first metadata includes one or more entries, each entry including a given schema ID assigned to a given schema, the given schema, and a timestamp corresponding to a given time at which at least one archive record defined by the given schema was archived.

6. The computing device of claim 1 , wherein the query includes a backdoor field that maps to the non-current field, and wherein the current schema and the historical schema are devoid of the backdoor field.

7. The computing device of claim 6 , wherein the machine executable code further causes the one or more processors to:
access a set of fields specified in the first current schema in accordance with the command, wherein the backdoor field maps to the first current schema of the object.

8. A method comprising:
accessing, from a memory, for an object, a plurality of archive records of tenant-specific object versions comprising first tenant-specific object version having a first historical schema, a first current schema and first metadata; and
receiving a query including a command specifying a subset of fields based on the object;
determining, by decomposing the query into the subset of fields, whether the query includes a non-current field absent from the current schema;
searching, the plurality of tenant-specific object versions in the memory, for at least one tenant-specific object version including the subset of fields and the non-current field according to timestamps included in metadata associated with the tenant-specific object versions; and
accessing the subset of fields and the non-current field in accordance with the command.

9. The method of claim 8 , wherein the first current schema comprises a field modification from the first historical schema, the field modification including at least one of an addition of a field to the object, a modification of a definition of the field, or removal of the field from the object.

10. The method of claim 8 , further comprising:
taking a snapshot of the first current schema, wherein the first historical schema includes the snapshot and at least one new field inserted at the end of the historical schema.

11. The method of claim 8 , further comprising:
searching the first metadata for a second schema including the subset of fields; and
identifying a schema identifier (ID) that identifies the second schema, the set of archive records including the schema ID.

12. The method of claim 11 , wherein the first metadata includes one or more entries, each entry including a given schema ID assigned to a given schema, the given schema, and a timestamp corresponding to a given time at which at least one archive record defined by the given schema was archived.

13. The method of claim 8 , wherein the query includes a backdoor field that maps to the non-current field, and wherein the current schema and the historical schema are devoid of the backdoor field.

14. The method of claim 13 , further comprising:
accessing a set of fields specified in the first current schema in accordance with the command, wherein the backdoor field maps to the first current schema of the object;
search the first metadata for a second schema including the subset of fields; and
identify a schema identifier (ID) that identifies the second schema, the set of archive records including the schema ID.

15. A non-transitory processor-readable storage medium storing a plurality of processor-executable instructions, the processor-executable instructions being executed by a processor to:
access, for an object, a plurality of archive records of tenant-specific object versions comprising first tenant-specific object version having a first historical schema, a first current schema and first metadata;
receive a query including a command specifying a subset of fields based on the object;
determine, by decomposing the query into the subset of fields, whether the query includes a non-current field absent from the current schema;
search, the plurality of tenant-specific object versions in the memory, for at least one tenant-specific object version including the subset of fields and the non-current field according to timestamps included in metadata associated with the tenant-specific object versions; and
access the subset of fields and the non-current field in accordance with the command.

16. The non-transitory processor-readable medium of claim 15 , wherein the first current schema comprises a field modification from the first historical schema, the field modification including at least one of an addition of a field to the object, a modification of a definition of the field, or removal of the field from the object.

17. The non-transitory processor-readable medium of claim 15 , wherein the processor-executable instructions are further executed by the processor to:
snapshot the first current schema, wherein the first historical schema includes the snapshot and at least one new field inserted at the end of the historical schema.

18. The non-transitory processor-readable medium of claim 15 , wherein the processor-executable instructions are further executed by the processor to:
search the first metadata for a second schema including the subset of fields; and
identify a schema identifier (ID) that identifies the second schema, the set of archive records including the schema ID.

19. The non-transitory processor-readable medium of claim 18 , wherein the first metadata includes one or more entries, each entry including a given schema ID assigned to a given schema, the given schema, and a timestamp corresponding t

Assignees

• Salesforce Com Inc

Inventors

• Fernando Jan Asita
• Jain Samarpan
• Davidchuk Matthew
• Annamalai Natarajan Valliappan
• Syomichev Alexey
• Marcel Cody
• Kalvala Seshank
• Ramrakhyani Sahil
• Hersans Alexandre

Classifications

• G06F16/245

  Query processing · CPC title

• G06F16/24

  Querying · CPC title

• G06F16/213 Primary

  with details for schema evolution support · CPC title

• G06F16/28

  Databases characterised by their database models, e.g. relational or object models · CPC title

• G06F16/211 Primary

  Schema design and management · CPC title