-
公开(公告)号：US11232102B2
公开(公告)日：2022-01-25
申请号：US15295319
申请日：2016-10-17
Applicant: salesforce.com, inc.
Inventor： Awais Tariq , Rohitashva Mathur , Arup Dutta , Prem Veeramani , Jesse Collins
IPC: G06F16/2453 , G06F16/21
Abstract: 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.
-
公开(公告)号：US10452630B2
公开(公告)日：2019-10-22
申请号：US15295305
申请日：2016-10-17
Applicant: salesforce.com, inc.
Inventor： Awais Tariq , Rohitashva Mathur , Arup Dutta , Prem Veeramani , Jesse Collins
IPC: G06F16/22 , G06F16/245 , G06F16/9535 , G06F16/2453
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.
-
公开(公告)号：US11436223B2
公开(公告)日：2022-09-06
申请号：US15419509
申请日：2017-01-30
Applicant: salesforce.com, inc.
Inventor： RamaLinga Raju Penmetsa , Prem Veeramani , Jeffrey Lallana Freschl , Jesse Collins , Ganesh Maganti
IPC: G06F16/2453
Abstract: Systems, methods, and computer-readable media for pinning query execution plans are described. A database system may obtain a query, and determine a organization identifier and/or user identifier associated with the query. The database system may identify an optimized plan among a set of query plans that correspond with the query, and may generate a query execution plan based on the query and the optimized plan. The database system may determine a pinned plan that is associated with the optimized plan, and may generate a query execution plan based on the pinned plan when the pinned plan is associated with the optimized plan and corresponds with the organization identifier and/or the user identifier. The database system may generate a query execution plan using optimization functions when the pinned plan is not associated with the pinned plan, or the organization identifier and/or the user identifier. Other embodiments may be described and/or claimed.
-
Patent Agency Ranking
公开(公告)号：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.
-
公开(公告)号：US20150127680A1
公开(公告)日：2015-05-07
申请号：US14530559
申请日：2014-10-31
Applicant: salesforce.com, inc.
Inventor： Arup Dutta , Prem Veeramani , Jesse Yarbro Collins
CPC classification number: G06F17/30424 , G06F21/6218 , G06F21/85
Abstract: Embodiments regard protected handling of database queries. An embodiment of a method for querying database system views and tables includes: receiving a user query from a user, the user query being directed to one or both of a view and a table of a database, wherein the user is not a database administrator; parsing the user query with a query parser to identify elements of the user query, parsing the query including determining whether the query meets certain database access criteria; automatically generating a database query based on the parsing of the user query, the generation of the database query including generating a database query that is limited by the database access criteria; accessing the one or both of the view and the table using the generated database query, wherein the access is limited to read-only access; and obtaining a result of the access of the one or both of the view and table.
Abstract translation: 实施例涉及对数据库查询的保护处理。 用于查询数据库系统视图和表的方法的实施例包括：从用户接收用户查询，所述用户查询被定向到数据库的视图和表格中的一个或两个，其中所述用户不是数据库管理员; 用查询解析器解析所述用户查询以识别所述用户查询的元素，解析所述查询，包括确定所述查询是否满足某些数据库访问准则; 基于用户查询的解析自动生成数据库查询，生成数据库查询，包括生成受数据库访问条件限制的数据库查询; 使用所生成的数据库查询来访问所述视图和所述表中的一个或两个，其中所述访问被限制为只读访问; 并且获得视图和表中的一个或两者的访问结果。
-
公开(公告)号：US10762085B2
公开(公告)日：2020-09-01
申请号：US15295256
申请日：2016-10-17
Applicant: salesforce.com, inc.
Inventor： Awais Tariq , Rohitashva Mathur , Arup Dutta , Prem Veeramani , Jesse Collins
IPC: G06F7/00 , G06F16/2453 , G06F16/21 , G06F16/22 , G06F16/2457 , G06F17/00
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.
-
公开(公告)号：US10372934B2
公开(公告)日：2019-08-06
申请号：US15295288
申请日：2016-10-17
Applicant: salesforce.com, inc.
Inventor： Rohitashva Mathur , Prem Veeramani , Jesse Collins
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.
-
公开(公告)号：US10268721B2
公开(公告)日：2019-04-23
申请号：US14530559
申请日：2014-10-31
Applicant: salesforce.com, inc.
Inventor： Arup Dutta , Prem Veeramani , Jesse Yarbro Collins
Abstract: Embodiments regard protected handling of database queries. An embodiment of a method for querying database system views and tables includes: receiving a user query from a user, the user query being directed to one or both of a view and a table of a database, wherein the user is not a database administrator; parsing the user query with a query parser to identify elements of the user query, parsing the query including determining whether the query meets certain database access criteria; automatically generating a database query based on the parsing of the user query, the generation of the database query including generating a database query that is limited by the database access criteria; accessing the one or both of the view and the table using the generated database query, wherein the access is limited to read-only access; and obtaining a result of the access of the one or both of the view and table.
-
-
-
-
-
-
-
Search Results
8
records
(took 0.014 seconds)
