公开(公告)号：US11940963B2

公开(公告)日：2024-03-26

申请号：US17457244

申请日：2021-12-01

Applicant: salesforce.com, inc.

Inventor： Michael Sgroi ,  Helen Kwong ,  Benjamin Busjaeger ,  Igor Fedorenko

IPC: G06F16/21 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2455

CPC classification number: G06F16/213 ,  G06F16/2282 ,  G06F16/2358 ,  G06F16/24552

Abstract: Techniques are disclosed relating to database schemas. A computer system may receive a metadata document that describes an updated schema for a database that stores a plurality of records. The computer system may instantiate a set of processes to perform an upgrade routine to upgrade ones of the plurality of records to comply with the updated schema. While the set of processes are upgrading the records, the computer system may receive a request to perform an operation on one of the plurality of records. The computer system may detect that the record corresponds to an earlier schema version than a version of the updated schema of the metadata document and may upgrade the record to comply with that updated schema. After upgrading the record, the computer system may perform the requested operation on the record.

公开(公告)号：US20230169049A1

公开(公告)日：2023-06-01

申请号：US17457244

申请日：2021-12-01

Applicant: salesforce.com, inc.

Inventor： Michael Sgroi ,  Helen Kwong ,  Benjamin Busjaeger ,  Igor Fedorenko

IPC: G06F16/21 ,  G06F16/23 ,  G06F16/22 ,  G06F16/2455

CPC classification number: G06F16/213 ,  G06F16/2358 ,  G06F16/2282 ,  G06F16/24552

Abstract: Techniques are disclosed relating to database schemas. A computer system may receive a metadata document that describes an updated schema for a database that stores a plurality of records. The computer system may instantiate a set of processes to perform an upgrade routine to upgrade ones of the plurality of records to comply with the updated schema. While the set of processes are upgrading the records, the computer system may receive a request to perform an operation on one of the plurality of records. The computer system may detect that the record corresponds to an earlier schema version than a version of the updated schema of the metadata document and may upgrade the record to comply with that updated schema. After upgrading the record, the computer system may perform the requested operation on the record.

公开(公告)号：US20230143636A1

公开(公告)日：2023-05-11

申请号：US17454585

申请日：2021-11-11

Applicant: salesforce.com, inc.

Inventor： Benjamin Busjaeger ,  Igor Fedorenko

IPC: G06F16/23 ,  G06F16/2455 ,  G06F16/25 ,  G06F16/21

CPC classification number: G06F16/2358 ,  G06F16/24568 ,  G06F16/256 ,  G06F16/219

Abstract: Techniques are disclosed relating to methods that include receiving, by a computer system in a multi-tenant database service, a stream of change event records for a database on a server. A given change event record may be indicative of a modification made to the database by one of a plurality of tenants. The methods may further include storing the received change event records in one or more buffers, and tracking, in a data structure separate from the one or more buffers. Information for ones of the stored change event records may include a corresponding order of reception and a particular tenant associated with a respective change event record. In response to receiving a query from a given tenant, the methods may include processing the query using the data structure to identify change event records associated with the given tenant.

公开(公告)号：US20230067776A1

公开(公告)日：2023-03-02

申请号：US17407993

申请日：2021-08-20

Applicant: salesforce.com, inc.

Inventor： Igor Fedorenko ,  Helen Kwong ,  Benjamin Busjaeger

IPC: G06F16/22

Abstract: Techniques are disclosed relating to multi-tenant database systems with underlying key/value storage. In some embodiments, a computing system generates first logical table information for a first portion of a multi-tenant dataset corresponding to a first tenant and second logical table information for a second portion of the dataset corresponding to a second tenant. The system may store the first and second logical tables using non-relational key/value data structures in one or more storage elements, including: storing entries from the first logical table across a first set of multiple key/value store buckets and storing entries from the second logical table across a second set of multiple key/value store buckets. Disclosed techniques may reduce performance issues due to hotspots while allowing efficient data access for a given tenant by limiting the number of buckets per tenant, relative to traditional techniques.

公开(公告)号：US12222924B2

公开(公告)日：2025-02-11

申请号：US17454585

申请日：2021-11-11

Applicant: salesforce.com, inc.

Inventor： Benjamin Busjaeger ,  Igor Fedorenko

IPC: G06F16/23 ,  G06F16/21 ,  G06F16/2455 ,  G06F16/2458 ,  G06F16/25

Abstract: Techniques are disclosed relating to methods that include receiving, by a computer system in a multi-tenant database service, a stream of change event records for a database on a server. A given change event record may be indicative of a modification made to the database by one of a plurality of tenants. The methods may further include storing the received change event records in one or more buffers, and tracking, in a data structure separate from the one or more buffers. Information for ones of the stored change event records may include a corresponding order of reception and a particular tenant associated with a respective change event record. In response to receiving a query from a given tenant, the methods may include processing the query using the data structure to identify change event records associated with the given tenant.