-
11.发明授权公开(公告)号：US11182144B2
公开(公告)日：2021-11-23
申请号：US16236915
申请日：2018-12-31
Applicant: salesforce.com, inc.
Inventor： Rohitashva Mathur
Abstract: 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
Applicant: salesforce.com, inc.
Inventor： Rohitashva Mathur
Abstract: 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
Applicant: salesforce.com, inc.
Inventor： Rohitashva Mathur
IPC: G06F17/30
Abstract: 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.
-
公开(公告)号：US11921721B2
公开(公告)日：2024-03-05
申请号：US17493422
申请日：2021-10-04
Applicant: salesforce.com, inc.
Inventor： Rohitashva Mathur
IPC: G06F16/2455 , G06F16/22 , G06F16/23 , G06F16/2458
CPC classification number: G06F16/2455 , G06F16/2282 , G06F16/2379 , G06F16/24558 , G06F16/2471
Abstract: 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.
-
15.发明授权公开(公告)号：US11860847B2
公开(公告)日：2024-01-02
申请号：US17111039
申请日：2020-12-03
Applicant: salesforce.com, inc.
Inventor： Rohitashva Mathur
CPC classification number: G06F16/2282 , G06F7/026
Abstract: A seed value assigned to a database table is determined. Numerically ordered invocation numbers are determined. Unordered pseudorandom numbers are generated based on the seed value and the invocation numbers to index temporally ordered data changes to the database table. It is determined whether the total number of yet-to-be-saved pseudorandom numbers reaches a maximum total number threshold. If so, the yet-to-be-saved pseudorandom numbers and a sequence of corresponding invocation numbers are saved in a sync table.
-
Patent Agency Ranking
公开(公告)号：US11481376B2
公开(公告)日：2022-10-25
申请号：US16012690
申请日：2018-06-19
Applicant: salesforce.com, inc.
Inventor： Rohitashva Mathur
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.
-
公开(公告)号：US11366810B2
公开(公告)日：2022-06-21
申请号：US16858856
申请日：2020-04-27
Applicant: Salesforce.com, Inc.
Inventor： Rohitashva Mathur
IPC: G06F16/2455 , G06F16/2458
Abstract: A database query message may be received at a database system via a network. The database query message may include one or more parameters for retrieving data from a database based on a designated database record insertion timestamp. A database query may be executed against the database system to retrieve one or more database records based on a database record insertion timestamp range determined based on the designated database record insertion timestamp and including a plurality of database record insertion timestamp values.
-
18.发明授权公开(公告)号：US11151269B2
公开(公告)日：2021-10-19
申请号：US15879101
申请日：2018-01-24
Applicant: salesforce.com, inc.
Inventor： Rohitashva Mathur
IPC: G06F16/00 , G06F21/62 , G06F16/951 , G06F16/242
Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating regulation-compliant processing of queries in an on-demand services environment according to one embodiment. In one embodiment and by way of example, a method includes receiving a query having first information not permitted to be stored per a regulation and second information permitted to be stored, and parameterizing the query into a parameterized query to replace the first information with parameters, where the first information includes data types. The method further includes annotating the parameters with decisions based on data properties correspondingly associated with the data types being represented by the parameters, and generating a final query based on the annotated parameters such that the final query is capable of being executed based on the annotated parameters and without storing the first information.
-
公开(公告)号：US20200320079A1
公开(公告)日：2020-10-08
申请号：US16374640
申请日：2019-04-03
Applicant: Salesforce.com, Inc.
Inventor： Rohitashva Mathur
IPC: G06F16/2453 , G06F16/22
Abstract: A database query may be determined based on a database query definition. The database query definition may include a filter criterion that contains a wildcard match, which may include a first fixed portion and a second wildcard portion. The first fixed portion may include one or more combining characters. The database query may include a first query portion including a first canonical representation of the first fixed portion that omits the one or more characters. The database query may include a second query portion including a second canonical representation of the first fixed portion. The database query may be executed to select a result set that includes a plurality of query result values by applying the second query portion to filter values accessed by the first query portion.
-
公开(公告)号：US10713243B2
公开(公告)日：2020-07-14
申请号：US16011396
申请日：2018-06-18
Applicant: salesforce.com, inc.
Inventor： Rohitashva Mathur
IPC: G06F16/2452 , G06F16/242 , G06F16/2455 , G06F16/22
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.
-
-
-
-
-
-
-
-
-
Search Results
41
records
(took 0.018 seconds)
