会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 2. 发明授权
    • Methods and systems for joining indexes for query optimization in a multi-tenant database
    • 在多租户数据库中加入查询优化索引的方法和系统
    • US08706715B2
    • 2014-04-22
    • US12887367
    • 2010-09-21
    • William Charles EidsonJesse Collins
    • William Charles EidsonJesse Collins
    • G06F7/00G06F17/30
    • G06F17/30466G06F17/30327G06F17/30442G06F17/30463G06F17/30536
    • Methods and systems for query optimization for a multi-tenant database system are provided. Some embodiments comprise receiving at a network interface of a server in a multi-tenant database system an original query transmitted to the multi-tenant database system by a user associated with a tenant, wherein the original query is associated with data accessible by the tenant, and wherein the multi-tenant database system includes at least a first index and a second index. Metadata associated with the data is retrieved, wherein at least a portion of the data is stored in a common table within the multi-tenant database system. A tenant-selective query syntax is determined by analyzing at least one of metadata generated from information about the tenant or metadata generated from the data accessible by the tenant. An improved query is then generated using the query syntax, wherein the improved query is based at least in part upon the original query and a result of a join between a first number of rows associated with the first index and a second number of rows associated with the second index.
    • 提供了多租户数据库系统查询优化的方法和系统。 一些实施例包括在多租户数据库系统中的服务器的网络接口处接收由与租户相关联的用户发送到多承租人数据库系统的原始查询,其中原始查询与租户可访问的数据相关联, 并且其中所述多租户数据库系统至少包括第一索引和第二索引。 检索与数据相关联的元数据,其中数据的至少一部分存储在多租户数据库系统内的公用表中。 租户选择性查询语法是通过分析从租户的信息生成的元数据中的至少一个或由租户可访问的数据生成的元数据来确定的。 然后使用查询语法生成改进的查询,其中改进的查询至少部分地基于原始查询,以及与第一索引相关联的第一行数和与第一索引相关联的第二行数之间的连接的结果 第二个指标。
    • 3. 发明申请
    • METHODS AND SYSTEMS FOR JOINING INDEXES FOR QUERY OPTIMIZATION IN A MULTI-TENANT DATABASE
    • 用于在多重数据库中查询优化的索引的方法和系统
    • US20110082854A1
    • 2011-04-07
    • US12887367
    • 2010-09-21
    • William Charles EidsonJesse Collins
    • William Charles EidsonJesse Collins
    • G06F17/30
    • G06F17/30466G06F17/30327G06F17/30442G06F17/30463G06F17/30536
    • Methods and systems for query optimization for a multi-tenant database system are provided. Some embodiments comprise receiving at a network interface of a server in a multi-tenant database system an original query transmitted to the multi-tenant database system by a user associated with a tenant, wherein the original query is associated with data accessible by the tenant, and wherein the multi-tenant database system includes at least a first index and a second index. Metadata associated with the data is retrieved, wherein at least a portion of the data is stored in a common table within the multi-tenant database system. A tenant-selective query syntax is determined by analyzing at least one of metadata generated from information about the tenant or metadata generated from the data accessible by the tenant. An improved query is then generated using the query syntax, wherein the improved query is based at least in part upon the original query and a result of a join between a first number of rows associated with the first index and a second number of rows associated with the second index.
    • 提供了多租户数据库系统查询优化的方法和系统。 一些实施例包括在多租户数据库系统中的服务器的网络接口处接收由与租户相关联的用户发送到多承租人数据库系统的原始查询,其中原始查询与租户可访问的数据相关联, 并且其中所述多租户数据库系统至少包括第一索引和第二索引。 检索与数据相关联的元数据,其中数据的至少一部分存储在多租户数据库系统内的公用表中。 租户选择性查询语法是通过分析从租户的信息生成的元数据中的至少一个或由租户可访问的数据生成的元数据来确定的。 然后使用查询语法生成改进的查询,其中改进的查询至少部分地基于原始查询,以及与第一索引相关联的第一行数和与第一索引相关联的第二行数之间的连接的结果 第二个指标。