专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20110320435A1 STATIC QUERY OPTIMIZATION 有权
标题翻译：静态查询优化
公开(公告)号：US20110320435A1
公开(公告)日：2011-12-29
申请号：US13167498
申请日：2011-06-23
申请人： Jesse Collins , Jaikumar Bathija , John F. O'Brien
发明人： Jesse Collins , Jaikumar Bathija , John F. O'Brien
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30442 , G06F17/30536
摘要： In some embodiments, a computer-implemented method for tuning queries for a multi-tenant database system is provided. A processor retrieves actual statistics associated with data stored on one or more servers in the multi-tenant database system. The data may be associated with one or more tenants of the multi-tenant database system. A subset of the actual statistics is selected, wherein the subset of the actual statistics is related to tenants having a data trait targeted for optimization. The processor determines synthetic statistics based on the subset of the actual statistics. An original query is received at the multi-tenant database system, wherein the original query operates upon data associated with a tenant that has the data trait targeted for optimization. The processor determines an optimal query plan based on the original query and synthetic statistics. Finally, the processor executes the original query based on the optimal query plan.
摘要翻译：在一些实施例中，提供了一种用于调整多承租人数据库系统的查询的计算机实现的方法。处理器检索与存储在多租户数据库系统中的一个或多个服务器上的数据相关联的实际统计信息。数据可以与多租户数据库系统的一个或多个租户相关联。选择实际统计的子集，其中实际统计的子集与具有针对优化的数据特征的租户相关。处理器根据实际统计的子集确定合成统计。在多租户数据库系统处接收原始查询，其中原始查询根据与具有针对优化的数据特征的租户相关联的数据进行操作。处理器根据原始查询和综合统计信息确定最优查询计划。最后，处理器根据最优查询计划执行原始查询。

2. 发明授权

US09251204B2 Static query optimization 有权
标题翻译：静态查询优化
公开(公告)号：US09251204B2
公开(公告)日：2016-02-02
申请号：US13167498
申请日：2011-06-23
申请人： Jesse Collins , Jaikumar Bathija , John F. O'Brien
发明人： Jesse Collins , Jaikumar Bathija , John F. O'Brien
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30442 , G06F17/30536
摘要： In some embodiments, a computer-implemented method for tuning queries for a multi-tenant database system is provided. A processor retrieves actual statistics associated with data stored on one or more servers in the multi-tenant database system. The data may be associated with one or more tenants of the multi-tenant database system. A subset of the actual statistics is selected, wherein the subset of the actual statistics is related to tenants having a data trait targeted for optimization. The processor determines synthetic statistics based on the subset of the actual statistics. An original query is received at the multi-tenant database system, wherein the original query operates upon data associated with a tenant that has the data trait targeted for optimization. The processor determines an optimal query plan based on the original query and synthetic statistics. Finally, the processor executes the original query based on the optimal query plan.
摘要翻译：在一些实施例中，提供了一种用于调整多承租人数据库系统的查询的计算机实现的方法。处理器检索与存储在多租户数据库系统中的一个或多个服务器上的数据相关联的实际统计信息。数据可以与多租户数据库系统的一个或多个租户相关联。选择实际统计的子集，其中实际统计的子集与具有针对优化的数据特征的租户相关。处理器根据实际统计的子集确定合成统计。在多租户数据库系统处接收原始查询，其中原始查询根据与具有针对优化的数据特征的租户相关联的数据进行操作。处理器根据原始查询和综合统计信息确定最优查询计划。最后，处理器根据最优查询计划执行原始查询。

3. 发明申请

US20110295839A1 OPTIMIZING QUERIES IN A MULTI-TENANT DATABASE SYSTEM ENVIRONMENT 有权
标题翻译：在多重数据库系统环境中优化查询
公开(公告)号：US20110295839A1
公开(公告)日：2011-12-01
申请号：US12885255
申请日：2010-09-17
申请人： Jesse Collins , Jaikumar Bathija
发明人： Jesse Collins , Jaikumar Bathija
IPC分类号： G06F17/30
CPC分类号： G06F17/30398 , G06F17/30333 , G06F17/30442 , G06F17/30448 , G06F17/30463 , G06F17/30622 , G06F17/30867
摘要： In a method, system, and computer-readable medium having instructions for optimizing a query in a database system, a database statistic is generated for a number of related records for one or more entities for at least one tenant and a related record is a record with a relationship to a shared record in a database table for an entity from the one or more entities, a first cost is calculated for accessing the number of related records for at least one tenant, a second cost is calculated for accessing a number of related records accessible to a user, a comparison of the first cost to the second cost is performed to determine a data access path for retrieving accessible related records, and the data access path for retrieving accessible related records is determined based upon the comparison.
摘要翻译：在具有用于优化数据库系统中的查询的指令的方法，系统和计算机可读介质中，针对至少一个租户的一个或多个实体的多个相关记录生成数据库统计量，并且相关记录是记录与来自一个或多个实体的实体的数据库表中的共享记录的关系，计算用于访问至少一个租户的相关记录的数量的第一成本，计算第二成本以访问多个相关用户可访问的记录，执行第一成本与第二成本的比较，以确定用于检索可访问相关记录的数据访问路径，并且基于该比较来确定用于检索可访问相关记录的数据访问路径。

4. 发明授权

US09122722B2 Transforming queries in a multi-tenant database system 有权
标题翻译：在多租户数据库系统中转换查询
公开(公告)号：US09122722B2
公开(公告)日：2015-09-01
申请号：US12977041
申请日：2010-12-22
申请人： Jesse Collins , Jaikumar Bathija
发明人： Jesse Collins , Jaikumar Bathija
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30398 , G06F17/30333 , G06F17/30442 , G06F17/30448 , G06F17/30463 , G06F17/30622 , G06F17/30867
摘要： In a method, system, and computer-readable medium having instructions for optimizing a query in a database system, a query request is received with a query predicate to filter data returned in response to the query request and the query predicate has a formula, the query request is transformed to a transformed query request by preprocessing the formula in the query predicate, and the query request is optimized using the transformed query request.
摘要翻译：在具有用于优化数据库系统中的查询的指令的方法，系统和计算机可读介质中，使用查询谓词接收查询请求以过滤响应于查询请求返回的数据，并且查询谓词具有公式，通过对查询谓词中的公式进行预处理，将查询请求转换为变换查询请求，并使用转换查询请求优化查询请求。

5. 发明授权

US08655867B2 Method and system for optimizing queries in a multi-tenant database environment 有权
标题翻译：在多租户数据库环境中优化查询的方法和系统
公开(公告)号：US08655867B2
公开(公告)日：2014-02-18
申请号：US13014115
申请日：2011-01-26
申请人： Jesse Collins , Jaikumar Bathija
发明人： Jesse Collins , Jaikumar Bathija
IPC分类号： G06F7/00
CPC分类号： G06F17/30445 , G06F17/30448
摘要： In accordance with embodiments, there are provided mechanisms and methods for query optimization in a database system. These mechanisms and methods for query optimization in a database system can enable embodiments to optimize OR expression filters referencing different logical tables. The ability of embodiments to optimize OR expression filters referencing different logical tables can enable optimization that is dynamic and specific to the particular tenant for whom the query is run and improve the performance and efficiency of the database system in response to query requests.
摘要翻译：根据实施例，提供了一种用于数据库系统中的查询优化的机制和方法。用于数据库系统中的查询优化的这些机制和方法可使实施例能够优化引用不同逻辑表的OR表达式过滤器。实施例优化引用不同逻辑表的OR表达式过滤器的能力可以实现对运行查询的特定租户是动态特定的优化，并且响应于查询请求而提高数据库系统的性能和效率。

6. 发明授权

US10417611B2 Methods and systems for providing multiple column custom indexes in a multi-tenant database environment 有权
公开(公告)号：US10417611B2
公开(公告)日：2019-09-17
申请号：US12897276
申请日：2010-10-04
申请人： Jesse Collins , Simon Y Wong , Jaikumar Bathija , John F O'Brien
发明人： Jesse Collins , Simon Y Wong , Jaikumar Bathija , John F O'Brien
IPC分类号： G06F7/00 , G06Q10/10 , G06F16/22
摘要： In accordance with embodiments, there are provided methods and systems for providing multiple column custom indexes in a multi-tenant database environment. A method embodiment provides defining a multi-tenant data structure having a plurality of data columns data fields and a plurality of rows for each of multiple tenants, each row including a data column for a tenant identifier, defining a first data field for a tenant, the first data field having a first data type, defining a second data field for the tenant, the second field having a second data type, and defining an index table including a tenant identifier for the tenant, a copy of data from the first data field and the second data field, and a key to the corresponding rows of the multi-tenant data structure.

7. 发明授权

US08386471B2 Optimizing queries in a multi-tenant database system environment 有权
标题翻译：在多租户数据库系统环境中优化查询
公开(公告)号：US08386471B2
公开(公告)日：2013-02-26
申请号：US12885255
申请日：2010-09-17
申请人： Jesse Collins , Jaikumar Bathija
发明人： Jesse Collins , Jaikumar Bathija
IPC分类号： G06F17/30
CPC分类号： G06F17/30398 , G06F17/30333 , G06F17/30442 , G06F17/30448 , G06F17/30463 , G06F17/30622 , G06F17/30867
摘要： In a method, system, and computer-readable medium having instructions for optimizing a query in a database system, a database statistic is generated for a number of related records for one or more entities for at least one tenant and a related record is a record with a relationship to a shared record in a database table for an entity from the one or more entities, a first cost is calculated for accessing the number of related records for at least one tenant, a second cost is calculated for accessing a number of related records accessible to a user, a comparison of the first cost to the second cost is performed to determine a data access path for retrieving accessible related records, and the data access path for retrieving accessible related records is determined based upon the comparison.
摘要翻译：在具有用于优化数据库系统中的查询的指令的方法，系统和计算机可读介质中，针对至少一个租户的一个或多个实体的多个相关记录生成数据库统计量，并且相关记录是记录与来自一个或多个实体的实体的数据库表中的共享记录的关系，计算用于访问至少一个租户的相关记录的数量的第一成本，计算第二成本以访问多个相关用户可访问的记录，执行第一成本与第二成本的比较，以确定用于检索可访问相关记录的数据访问路径，并且基于该比较来确定用于检索可访问相关记录的数据访问路径。

8. 发明申请

US20130018890A1 CREATING A CUSTOM INDEX IN A MULTI-TENANT DATABASE ENVIRONMENT 审中-公开
标题翻译：在多重数据库环境中创建自定义索引
公开(公告)号：US20130018890A1
公开(公告)日：2013-01-17
申请号：US13549306
申请日：2012-07-13
申请人： Chirag Rajan , Arup Dutta , John O'Brien , Jaikumar Bathija , Greg Salmon , Dan Soble , RamaLinga R. Penmetsa , Hoon Kim , Yanan Jiang , Karthik Rajan , Jesse Collins
发明人： 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
CPC分类号： G06F17/30336 , G06F17/30442 , G06F17/30477
摘要： 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.
摘要翻译：描述了在多租户数据库环境中创建自定义索引的方法和系统。在一个实施例中，一种方法包括获得建议作为创建附加过滤器的候选者的多租户数据库的查询，根据标准评估查询以确定是否选择用于创建附加过滤器的查询，以及创建附加过滤器对于查询，如果查询被选中。

9. 发明授权

US10108648B2 Creating a custom index in a multi-tenant database environment 有权
公开(公告)号：US10108648B2
公开(公告)日：2018-10-23
申请号：US13549306
申请日：2012-07-13
申请人： Chirag Rajan , Arup Dutta , John O'Brien , Jaikumar Bathija , Greg Salmon , Dan Soble , RamaLinga R. Penmetsa , Hoon Kim , Yanan Jiang , Karthik Rajan , Jesse Collins
发明人： 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
摘要： 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.

10. 发明申请

US20110295838A1 TRANSFORMING QUERIES IN A MULTI-TENANT DATABASE SYSTEM 有权
标题翻译：在多重数据库系统中转换查询
公开(公告)号：US20110295838A1
公开(公告)日：2011-12-01
申请号：US12977041
申请日：2010-12-22
申请人： Jesse Collins , Jaikumar Bathija
发明人： Jesse Collins , Jaikumar Bathija
IPC分类号： G06F17/30
CPC分类号： G06F17/30398 , G06F17/30333 , G06F17/30442 , G06F17/30448 , G06F17/30463 , G06F17/30622 , G06F17/30867
摘要： In a method, system, and computer-readable medium having instructions for optimizing a query in a database system, a query request is received with a query predicate to filter data returned in response to the query request and the query predicate has a formula, the query request is transformed to a transformed query request by preprocessing the formula in the query predicate, and the query request is optimized using the transformed query request.
摘要翻译：在具有用于优化数据库系统中的查询的指令的方法，系统和计算机可读介质中，使用查询谓词接收查询请求以过滤响应于查询请求返回的数据，并且查询谓词具有公式，通过对查询谓词中的公式进行预处理，将查询请求转换为变换查询请求，并使用转换查询请求优化查询请求。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式