公开(公告)号：US11537571B2

公开(公告)日：2022-12-27

申请号：US16141572

申请日：2018-09-25

申请人： salesforce.com, inc.

发明人： Rohitashva Mathur

IPC分类号： G06F16/215 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2455 ,  H03M7/46 ,  H03M7/30

摘要： 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.

公开(公告)号：US11341130B2

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

申请号：US16852395

申请日：2020-04-17

申请人： salesforce.com, inc.

发明人： Rohitashva Mathur

IPC分类号： G06F16/2452 ,  G06F16/2455 ,  G06F16/22 ,  G06F16/242

摘要： 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.

公开(公告)号：US11238017B2

公开(公告)日：2022-02-01

申请号：US15884165

申请日：2018-01-30

申请人： salesforce.com, inc.

发明人： Rohitashva Mathur

IPC分类号： G06F17/30 ,  G06F16/215 ,  G06F16/22

摘要： In a multitenant data platform architecture, one or more supporting data tables are used to efficiently retrieve data responsive to data retrieval requests. Programmatic code markers associated with contextual data about a data transaction thread are identified. The contextual data is examined using the one or more programmatic code markers invoked by the database in the data transaction thread at runtime. 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.

公开(公告)号：US11182144B2

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

申请号：US16236915

申请日：2018-12-31

申请人： salesforce.com, inc.

发明人： Rohitashva Mathur

IPC分类号： G06F9/44 ,  G06F8/65 ,  G06F16/28 ,  G06F16/21

摘要： A method for processing database package connections and updates has been developed. First, an execution request for a database package is received. A connection context is then established which can execute the execution request. The database package is determined whether or not it is valid with proper package updates prior to establishing the connection. If the database package is determined to not be valid, change packages are retrieved for the database package. The valid change packages are then compiled for the database package and the connection request is executed for the updated database package with the connection context.

公开(公告)号：US20200250166A1

公开(公告)日：2020-08-06

申请号：US16264442

申请日：2019-01-31

申请人： salesforce.com, inc.

发明人： Rohitashva Mathur

IPC分类号： G06F16/22 ,  G06F16/21

摘要： A data table comprising one or more table columns including but not limited to an organization table column for identifying individual organizations, data entities and one or more table columns storing common-denominator data type values is accessed. Discriminant values and first native index values are generated by applying discriminant mappings and native index value mappings to table rows in the data table. A function-based table index using the discriminant values and the native index values is generated for the data table. The function-based table index is used for accessing at least a portion of data values in the data table.

公开(公告)号：US20190138658A1

公开(公告)日：2019-05-09

申请号：US15808008

申请日：2017-11-09

申请人： salesforce.com, inc.

发明人： Rohitashva Mathur

IPC分类号： G06F17/30

摘要： A first table that includes columns corresponding to data associated with entities may be identified. A selection of a subset of the columns of the first table may be received. Data from each column of the subset of columns may be identified. Furthermore, a second table may be generated based on the subset of the columns of the first table and the data from each column of the subset of the columns. A partition key may be generated for each row of the second table based on an entity and a portion of the data associated with each corresponding row of the second table.

公开(公告)号：US11232102B2

公开(公告)日：2022-01-25

申请号：US15295319

申请日：2016-10-17

申请人： salesforce.com, inc.

发明人： Awais Tariq ,  Rohitashva Mathur ,  Arup Dutta ,  Prem Veeramani ,  Jesse Collins

IPC分类号： G06F16/2453 ,  G06F16/21

摘要： A database query is received at a first time when a database is in a first state. The database query is analyzed to determine whether it has one or more characteristics that fall within a historical top range of database queries. If the database query falls within the historical top range of database queries the query is stored for later query tuning activity. The query is executed against the database in the first state. Query tuning recommendations are generated for stored database queries that fall within the historical top range of database queries. A subsequent request is received at a second time when a database is in a second state. The subsequent database query is executed with at least one of the query tuning recommendations against the database in the second state.

公开(公告)号：US11138196B2

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

申请号：US15998854

申请日：2018-08-17

申请人： salesforce.com, inc.

发明人： Rohitashva Mathur

IPC分类号： G06F16/2455 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2458

摘要： Disclosed herein are system, method, and computer program product embodiments for a query processing system. An embodiment operates by receiving a query associated with a table. An ordered index with entries that include key values that uniquely identifies a corresponding record in the table is determined. A last key value is initialized to store a minimum value for a data type of the key value. The query is executed as a union-all of a plurality of queries. While a count of selected records is less than or equal to a threshold quantity and at least one entry remains in the ordered index, an ordered next entry with a key value subsequent to the last key value in the index is identified, the corresponding record is selected from the table, the last key value is updated, the query is executed, and the count is incremented.

公开(公告)号：US10776336B2

公开(公告)日：2020-09-15

申请号：US15344326

申请日：2016-11-04

申请人： salesforce.com, inc.

发明人： Rohitashva Mathur

IPC分类号： G06F16/20 ,  G06F16/22 ,  G06F16/2455 ,  G06F16/2457

摘要： A method, system, and apparatus provide for multiple custom fields associated with an application running at a computing device, where the multiple custom fields are received in a specified sort order. The method includes dynamically building multi-column indexes of the multiple custom fields corresponding to multiple intrinsic datatypes stored in multiple custom field columns of a shared table, where the multiple intrinsic datatypes are converted into a generic-indexable datatype to preserve the specified sort order. The method further includes building a sorted index in a specified order in a multi-column indexable table, where the multi-column indexable table includes a partial copy of data from multiple tenants that inhibit the shared table.

公开(公告)号：US20200233721A1

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

申请号：US16252433

申请日：2019-01-18

申请人： Salesforce.com, Inc.

发明人： Rohitashva Mathur

IPC分类号： G06F9/50 ,  G06F16/11 ,  G06F3/06

摘要： 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.