公开(公告)号：US20210342322A1

公开(公告)日：2021-11-04

申请号：US16866331

申请日：2020-05-04

Applicant: salesforce.com, inc.

Inventor： Serge Philippe Rielau ,  Randy Philip Spalten ,  Jeffrey Ira Cohen

IPC: G06F16/21 ,  G06F16/22 ,  G06F16/2458 ,  G06F16/2457

Abstract: Techniques are disclosed for handling database queries from multiple different application versions using a single database. A computer system executing a database management system (DBMS) may receive a database query for a database, where the database query is received from a particular version of an application having a plurality of versions. The database query may specify the particular version. The computer system may then identify catalog tables, where the catalog tables include version information columns storing version access information. The computer system may determine that version access information for the database query indicates that one or more database objects corresponding to the database query are accessible to the particular version of the application. Based on the determining, the computer system may access one or more database objects that are responsive to the database query and are accessible to the particular version of the application, which may advantageously reduce or avoid duplication of data stored in the database.

公开(公告)号：US11347713B2

公开(公告)日：2022-05-31

申请号：US16585191

申请日：2019-09-27

Applicant: salesforce.com, inc.

Inventor： Jeffrey Ira Cohen ,  Punit B. Shah ,  Serge Philippe Rielau

IPC: G06F16/23 ,  G06F16/21

Abstract: Techniques are disclosed relating to concurrently processing transactions. A computer system may maintain a database table having a plurality of versions. Each of the versions may identify a corresponding portion of the database table that transactions associated with that version are permitted to access. The computer system may receive a first request to perform a first transaction to modify a definition of the database table. The computer system may receive a second request to perform a second transaction to modify data stored in the database table. In response to determining that the first and second transactions are associated with different versions of the plurality of versions, the computer system may concurrently process the first and second transactions.

公开(公告)号：US11507566B2

公开(公告)日：2022-11-22

申请号：US16779475

申请日：2020-01-31

Applicant: salesforce.com, inc.

Inventor： Serge Philippe Rielau ,  Rui Zhang

IPC: G06F16/00 ,  G06F16/23 ,  G06F16/2455

Abstract: A method for maintaining cache of database objects using a chain set that includes multiple chains each specifying an ordering of database objects is disclosed. In response to a change of state of a particular database object, a corresponding chain is selected. The selected chain is then locked, the state of the particular database object changed, and then the selected chain is unlocked.

公开(公告)号：US20210240697A1

公开(公告)日：2021-08-05

申请号：US16779475

申请日：2020-01-31

Applicant: salesforce.com, inc.

Inventor： Serge Philippe Rielau ,  Rui Zhang

IPC: G06F16/23 ,  G06F16/2455

Abstract: A method for maintaining cache of database objects using a chain set that includes multiple chains each specifying an ordering of database objects is disclosed. In response to a change of state of a particular database object, a corresponding chain is selected. The selected chain is then locked, the state of the particular database object changed, and then the selected chain is unlocked.

公开(公告)号：US20210097051A1

公开(公告)日：2021-04-01

申请号：US16585191

申请日：2019-09-27

Applicant: salesforce.com, inc.

Inventor： Jeffrey Ira Cohen ,  Punit B. Shah ,  Serge Philippe Rielau

IPC: G06F16/23 ,  G06F16/21

Abstract: Techniques are disclosed relating to concurrently processing transactions. A computer system may maintain a database table having a plurality of versions. Each of the versions may identify a corresponding portion of the database table that transactions associated with that version are permitted to access. The computer system may receive a first request to perform a first transaction to modify a definition of the database table. The computer system may receive a second request to perform a second transaction to modify data stored in the database table. In response to determining that the first and second transactions are associated with different versions of the plurality of versions, the computer system may concurrently process the first and second transactions.