公开(公告)号：US20200097571A1

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

申请号：US16141572

申请日：2018-09-25

Applicant: salesforce.com, inc.

Inventor： Rohitashva Mathur

IPC: G06F17/30

Abstract: A request for performing a data storing operation directed to a database table that comprises a plurality of table columns is received. Columnar compression metadata is accessed to identify one or more table columns in the database table, each of the one or more table columns being designated to store compressed columnar values. The columnar compression metadata is used to apply one or more columnar compression methods to generate, from one or more uncompressed columnar values received with the request for the data storing operation, one or more compressed columnar values to be persisted in the one or more table columns in the database table. A database statement is executed to persist the one or more compressed columnar values in the one or more table columns in the database table.

公开(公告)号：US11334539B2

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

申请号：US16526334

申请日：2019-07-30

Applicant: Salesforce.com, Inc.

Inventor： Rohitashva Mathur

IPC: G06F16/21 ,  G06F16/22 ,  G06F16/23 ,  G06F11/14

Abstract: A plurality of database access requests are received at a database system within a designated database access scope. The plurality of database access requests may include a first request to read from a first database table and a second request to write to a second database table. The second request may occur during or after the receipt of the first request. A database access dependency rule linking the first database table and the second database table may be created. The database access dependency rule may impose a protected database access framework when executing a subsequent write request to the second database table when the first database table is updated. The protected database access framework may store one or more values associated with the subsequent write request in a staging table that are capable of being used to undo the subsequent write request.

公开(公告)号：US11269741B2

公开(公告)日：2022-03-08

申请号：US16525818

申请日：2019-07-30

Applicant: Salesforce.com, Inc.

Inventor： Rohitashva Mathur

IPC: G06F16/22 ,  G06F16/23 ,  G06F11/14

Abstract: A request to update an original data value in a first row in a database table in a database system. An updated data value is written to a second row in a staging table in the database system. The updated data value corresponds with the original data value. The first row includes a database table key, which is also included in the second row. The original data value in the database table is replaced with a corresponding replacement value, which is determined based on a value replacement update function that takes as input the updated data value. The staging table maintains a record value for reversing the update to the database table.

公开(公告)号：US11138182B2

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

申请号：US16203125

申请日：2018-11-28

Applicant: salesforce.com, inc.

Inventor： Rohitashva Mathur

IPC: G06F16/00 ,  G06F16/23 ,  G06F16/215 ,  G06F11/14 ,  G06F16/2455

Abstract: In a multitenant database, one or more supporting data tables are used to write and store tenant data. Based on the contextual data returning an indication of validity of a detected database transaction, various actions are performed. Data changes may be captured if no valid context is found. At runtime, triggers are used to set a valid context or fix mode context, and database operations causing the data corruptions are captured in a change tracking data structure. The captured data from the database operations include a primary key and an original value for each data change. The original value and primary key for each data change is used to nullify the unintended write.

公开(公告)号：US20200242117A1

公开(公告)日：2020-07-30

申请号：US16852395

申请日：2020-04-17

Applicant: salesforce.com, inc.

Inventor： Rohitashva Mathur

IPC: G06F16/2452 ,  G06F16/2455 ,  G06F16/22 ,  G06F16/242

Abstract: A query to retrieve database values for a first subset of table columns in a database table is determined. Runtime column selection variables are set up to identify the first subset of table columns for data retrieval, and are dynamically bound to a prepared query statement with single-column query statements joined by interstitial union operators. Each single-column query statement in the prepared query statement specifies a single-column query directed to a corresponding table column with a corresponding predicate to be bound at runtime dynamically with a corresponding portion of the one or more runtime column selection variables. The predicate is evaluated to be true or false in dependence on whether the corresponding table column is in the first subset of table columns. The prepared query statement is executed to retrieve database values for the first subset of table columns in the database table.

公开(公告)号：US10726039B2

公开(公告)日：2020-07-28

申请号：US15363408

申请日：2016-11-29

Applicant: salesforce.com, inc.

Inventor： Rohitashva Mathur

IPC: G06F7/00 ,  G06F16/25 ,  G06F16/22 ,  G06F16/9535 ,  G06F16/23

Abstract: Systems, methods, and computer-readable media for obtaining database records during an index update process are described. A database system may identify indexes having a first data format to be converted into a second data format, and obtain a first query for retrieval of a set of records in a database. The first query may comprise a filter to be used for retrieval of the set of records. The database system may convert the filter into the first data format to obtain a first filter value, convert the filter into the second data format to obtain a second filter value, and generate a second query to include the first data format filter and the second data format filter. The database system may issue the second query to obtain the set of records. Other embodiments may be described and/or claimed.

公开(公告)号：US20200233861A1

公开(公告)日：2020-07-23

申请号：US16252454

申请日：2019-01-18

Applicant: Salesforce.com, Inc.

Inventor： Rohitashva Mathur

IPC: G06F16/2453 ,  G06F16/22

Abstract: A database entry may be stored in a container in a database table corresponding with a partition key. The partition key may be determined by applying one or more partition rules to one or more data values associated with the database entry. The database entry may be an instance of one of a plurality of data object definitions associated with database entries in the database. Each of the data object definitions may identify a respective one or more data fields included within an instance of the data object definition.

公开(公告)号：US20200167332A1

公开(公告)日：2020-05-28

申请号：US16203125

申请日：2018-11-28

Applicant: salesforce.com, inc.

Inventor： Rohitashva Mathur

IPC: G06F16/23 ,  G06F16/215 ,  G06F16/2455 ,  G06F11/14

Abstract: In a multitenant database, one or more supporting data tables are used to write and store tenant data. Based on the contextual data returning an indication of validity of a detected database transaction, various actions are performed. Data changes may be captured if no valid context is found. At runtime, triggers are used to set a valid context or fix mode context, and database operations causing the data corruptions are captured in a change tracking data structure. The captured data from the database operations include a primary key and an original value for each data change. The original value and primary key for each data change is used to nullify the unintended write.

公开(公告)号：US20190384846A1

公开(公告)日：2019-12-19

申请号：US16011396

申请日：2018-06-18

Applicant: salesforce.com, inc.

Inventor： Rohitashva Mathur

IPC: G06F17/30

Abstract: A query to retrieve database values for a first subset of table columns in a database table is determined. Runtime column selection variables are set up to identify the first subset of table columns for data retrieval, and are dynamically bound to a prepared query statement with single-column query statements joined by interstitial union operators. Each single-column query statement in the prepared query statement specifies a single-column query directed to a corresponding table column with a corresponding predicate to be bound at runtime dynamically with a corresponding portion of the one or more runtime column selection variables. The predicate is evaluated to be true or false in dependence on whether the corresponding table column is in the first subset of table columns. The prepared query statement is executed to retrieve database values for the first subset of table columns in the database table.

公开(公告)号：US20190384840A1

公开(公告)日：2019-12-19

申请号：US16012690

申请日：2018-06-19

Applicant: salesforce.com, inc.

Inventor： Rohitashva Mathur

IPC: G06F17/30 ,  G06F11/07

Abstract: In a multitenant data platform architecture, one or more supporting data tables are used to write and store tenant data responsive to data write requests. Based on the contextual data returning an indication of a data corruption in one or more supporting data structures, an action associated with the data transaction thread is performed. A log of data corruptions and corresponding call stack trace data may be generated. The data transaction thread may be allowed to continue to execute statements that modify data tables, or the data transaction thread may be terminated. Data corruptions may be compensated for by nullifying data changes caused by corruption causing call sites. Verification methods may be used to ensure correctness of data within a transaction thread.