-
公开(公告)号：US20180025174A1
公开(公告)日：2018-01-25
申请号：US15295288
申请日：2016-10-17
Applicant: salesforce.com, inc.
Inventor： Rohitashva MATHUR , Prem Veeramani , Jesse Collins
CPC classification number: G06F21/6227 , H04L67/02 , H04L67/1097
Abstract: In an example, a processing device of a datastore system may be configured to identify one or more grants of permission corresponding to one or more first objects, respectively, wherein the one or more first objects comprise only a subset of objects of a datastore, wherein the one or more grants of permission are by a user of the datastore; generate an access control entry for a second object of the objects using at least one of the identified grants of permission, wherein the second object is not exposed to the user; and in responsive to receipt of a query for data corresponding to the objects, determine whether to grant access to the data based on the generated access control entry.
-
公开(公告)号：US20210334273A1
公开(公告)日：2021-10-28
申请号：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.
-
公开(公告)号：US20180107714A1
公开(公告)日：2018-04-19
申请号：US15295256
申请日：2016-10-17
Applicant: salesforce.com, inc.
Inventor： Awais Tariq , Rohitashva MATHUR , Arup DUTTA , Prem VEERAMANI , Jesse COLLINS
IPC: G06F17/30
CPC classification number: G06F16/24545 , G06F16/217 , G06F16/221 , G06F16/2228 , G06F16/24542 , G06F16/24544 , G06F16/24578
Abstract: Automated query tuning. A database query to be executed against a database is received. The database query is analyzed to determine one or more potential indexes to be evaluated. The one or more potential indexes are evaluated to determine if an optimization utilizing a selected potential index provides improved performance over performing the database query without the selected potential index. The one or more potential indexes are scored based on results of the evaluating. A recommendation of one or more of the potential indexes is provided to a source of the database query.
-
公开(公告)号：US20210034589A1
公开(公告)日：2021-02-04
申请号：US16526334
申请日：2019-07-30
Applicant: Salesforce.com, Inc.
Inventor： Rohitashva MATHUR
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.
-
5.发明申请公开(公告)号：US20190130002A1
公开(公告)日：2019-05-02
申请号：US15798077
申请日：2017-10-30
Applicant: salesforce.com, inc.
Inventor： Rohitashva MATHUR
IPC: G06F17/30
Abstract: Trigger-free asynchronous maintenance of custom indexes and skinny performance meta-structures is described. A database system receives a request to manipulate data in an object in a database table, and determines whether the object in the database table is associated with a user-based data structure. If the object in the database table is associated with the user-based data structure, the database system manipulates the data in the object in the database table and data in an object in an intermediate data table. The database system receives a query, and determines whether the query requests any data that is in the user-based data structure. If the query requests any data that is in the user-based data structure, the database system creates a query result by combining any data that is in the object in the intermediate data table with any requested data that is in the user-based data structure, and outputs the query result.
-
Patent Agency Ranking
公开(公告)号：US20210034476A1
公开(公告)日：2021-02-04
申请号：US16525818
申请日：2019-07-30
Applicant: Salesforce.com, Inc.
Inventor： Rohitashva MATHUR
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.
-
7.发明申请公开(公告)号：US20200210164A1
公开(公告)日：2020-07-02
申请号：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.
-
公开(公告)号：US20220027363A1
公开(公告)日：2022-01-27
申请号：US17493422
申请日：2021-10-04
Applicant: salesforce.com, inc.
Inventor： Rohitashva MATHUR
IPC: G06F16/2455 , G06F16/22 , G06F16/23 , G06F16/2458
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.
-
公开(公告)号：US20180150533A1
公开(公告)日：2018-05-31
申请号：US15363408
申请日：2016-11-29
Applicant: salesforce.com, inc.
Inventor： Rohitashva MATHUR
IPC: G06F17/30
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.
-
公开(公告)号：US20180107697A1
公开(公告)日：2018-04-19
申请号：US15295305
申请日：2016-10-17
Applicant: salesforce.com, inc.
Inventor： Awais TARIQ , Rohitashva MATHUR , Arup DUTTA , Prem VEERAMANI , Jesse COLLINS
IPC: G06F17/30
CPC classification number: G06F16/2228 , G06F16/245 , G06F16/24539 , G06F16/9535
Abstract: Reverse database query mapping. A database query to be executed on a computing platform against a database managed by the computing platform is received. Query mapping information is stored in a memory system accessible to the one or more processors. A source query corresponding to a query identifier is retrieved in response to statistical analysis. One or more potential indexes are generated for use with the source query, wherein at least one of the one or more potential indexes can function to improve performance of the source query.
-
-
-
-
-
-
-
-
-
Search Results
10
records
(took 0.021 seconds)
