-
公开(公告)号:US20140040235A1
公开(公告)日:2014-02-06
申请号:US14044657
申请日:2013-10-02
Applicant: salesforce.com, inc.
Inventor: Chirag Rajan , Jesse Collins , Seung-Yeoul Yang , Hoon Kim
IPC: G06F17/30
CPC classification number: G06F17/30463 , G06F17/30442 , G06F17/30477
Abstract: Methods and systems are provided for querying a database. One exemplary method for obtaining data from an on-demand database supporting one or more tenants involves obtaining model database statistics based on expected utilization information for a tenant and providing the model database statistics to the on-demand database. The on-demand database utilizes the model database statistics to generate a query plan and executes the query plan to obtain data from the model database statistics.
Abstract translation: 提供了方法和系统来查询数据库。 从支持一个或多个租户的点播数据库获取数据的一个示例性方法包括基于租户的预期利用信息获取模型数据库统计信息,并将该模型数据库统计信息提供给按需数据库。 按需数据库利用模型数据库统计信息生成查询计划,并执行查询计划以从模型数据库统计信息中获取数据。
-
2.
公开(公告)号:US09286343B2
公开(公告)日:2016-03-15
申请号:US13925064
申请日:2013-06-24
Applicant: salesforce.com, inc.
Inventor: Hoon Kim , Jesse Collins , Chirag Rajan
CPC classification number: G06F17/30371 , G06F17/30115 , G06F17/30327 , G06F17/30339 , G06F17/30598
Abstract: Statistics mechanisms in multitenant database environments. A master statistics file is maintained in a multitenant database system. The master statistics file has statistics corresponding to multiple tenants within the multitenant database system. Statistics for a selected table within the multitenant database system are generated. The selected table corresponding to a selected tenant of the multitenant database system. The master statistics file is updated based on the generated statistics for the selected table.
Abstract translation: 多租户数据库环境中的统计机制。 在多租户数据库系统中维护主统计信息文件。 主统计信息文件具有与多租户数据库系统中的多个租户对应的统计信息。 生成多租户数据库系统中选定表的统计信息。 所选择的表对应于多租户数据库系统的选定租户。 主统计信息文件根据所选表格的生成统计信息进行更新。
-
公开(公告)号:US09189521B2
公开(公告)日:2015-11-17
申请号:US14044657
申请日:2013-10-02
Applicant: salesforce.com, inc.
Inventor: Chirag Rajan , Jesse Collins , Seung-Yeoul Yang , Hoon Kim
CPC classification number: G06F17/30463 , G06F17/30442 , G06F17/30477
Abstract: Methods and systems are provided for querying a database. One exemplary method for obtaining data from an on-demand database supporting one or more tenants involves obtaining model database statistics based on expected utilization information for a tenant and providing the model database statistics to the on-demand database. The on-demand database utilizes the model database statistics to generate a query plan and executes the query plan to obtain data from the model database statistics.
Abstract translation: 提供了方法和系统来查询数据库。 从支持一个或多个租户的点播数据库获取数据的一个示例性方法包括基于租户的预期利用信息获取模型数据库统计信息,并将该模型数据库统计信息提供给按需数据库。 按需数据库利用模型数据库统计信息生成查询计划,并执行查询计划以从模型数据库统计信息中获取数据。
-
公开(公告)号:US10152511B2
公开(公告)日:2018-12-11
申请号:US14028316
申请日:2013-09-16
Applicant: salesforce.com, inc.
Inventor: Chirag Rajan , Jesse Collins , Jaikumar Bathija , Hoon Kim
IPC: G06F17/30
Abstract: In an on demand database system, a query engine applies a custom index for inner queries. The query engine receives a query and determines that the query has an inner query nested within the primary query. The query engine identifies that a custom index exists for a client associated with the query, and applies the custom index to filter results for the query. The custom index includes a subset of information of a table that includes accounts for multiple different clients. By using the custom index, the query engine can filter the results more efficiently that if solely using the multiple client table.
-
公开(公告)号:US20190108248A1
公开(公告)日:2019-04-11
申请号:US16166488
申请日:2018-10-22
Applicant: salesforce.com, inc.
Inventor: Chirag Rajan , Arup Dutta , John O'Brien , Jaikumar Bathija , Greg Salmon , Dan Soble , RamaLinga R. Penmetsa , Hoon Kim , Yanan Jiang , Karthik Rajan , Jesse Collins
IPC: G06F17/30
Abstract: Methods and systems are described for creating a custom index in a multi-tenant database environment. In one embodiment, a method includes obtaining query for a multi-tenant database that is recommended as a candidate for creating an additional filter, evaluating the query against criteria to determine whether to select the query for creating the additional filter, and creating the additional filter for the query, if the query is selected.
-
公开(公告)号:US09760594B2
公开(公告)日:2017-09-12
申请号:US15046338
申请日:2016-02-17
Applicant: salesforce.com, inc.
Inventor: Hoon Kim , Jesse Collins , Chirag Rajan
CPC classification number: G06F17/30371 , G06F17/30115 , G06F17/30327 , G06F17/30339 , G06F17/30598
Abstract: Statistics mechanisms in multitenant database environments. A master statistics file is maintained in a multitenant database system. The master statistics file has statistics corresponding to multiple tenants within the multitenant database system. Statistics for a selected table within the multitenant database system are generated. The selected table corresponding to a selected tenant of the multitenant database system. The master statistics file is updated based on the generated statistics for the selected table.
-
7.
公开(公告)号:US20160162536A1
公开(公告)日:2016-06-09
申请号:US15046338
申请日:2016-02-17
Applicant: salesforce.com, inc.
Inventor: Hoon Kim , Jesse Collins , Chirag Rajan
IPC: G06F17/30
CPC classification number: G06F17/30371 , G06F17/30115 , G06F17/30327 , G06F17/30339 , G06F17/30598
Abstract: Statistics mechanisms in multitenant database environments. A master statistics file is maintained in a multitenant database system. The master statistics file has statistics corresponding to multiple tenants within the multitenant database system. Statistics for a selected table within the multitenant database system are generated. The selected table corresponding to a selected tenant of the multitenant database system. The master statistics file is updated based on the generated statistics for the selected table.
Abstract translation: 多租户数据库环境中的统计机制。 在多租户数据库系统中维护主统计信息文件。 主统计信息文件具有与多租户数据库系统中的多个租户对应的统计信息。 生成多租户数据库系统中选定表的统计信息。 所选择的表对应于多租户数据库系统的选定租户。 主统计信息文件根据所选表格的生成统计信息进行更新。
-
-
-
-
-
-