会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 3. 发明授权
    • Obtaining a plan for executing a query in a relational database
    • 获取在关系数据库中执行查询的计划
    • US07937385B2
    • 2011-05-03
    • US12114913
    • 2008-05-05
    • Robert J. BestgenWei HuShantan KethireddyAndrew P. PasseUlrich Thiemann
    • Robert J. BestgenWei HuShantan KethireddyAndrew P. PasseUlrich Thiemann
    • G06F17/30
    • G06F17/3048G06F17/30463
    • A plan for executing a query in a relational database is obtained. A query for accessing data in the relational database is received. The query specifies N tables in the relational database from which data is to be retrieved. A determination is made whether a syntax of the query matches a syntax of a plan in a plan cache for executing the query. Matches are identified between generic table formats of the N tables specified in the query to generic table formats of N tables specified in the plan responsive to the syntax of the query matching the syntax of a plan in the plan cache for executing the query. The plan for executing the query is obtained based on whether the syntax of the query matches the syntax of the plan and based on identified matches between the generic table formats of the N tables specified in the query to the generic table formats of the N tables specified in the plan.
    • 获得在关系数据库中执行查询的计划。 接收到关系数据库中访问数据的查询。 该查询指定要从中检索数据的关系数据库中的N个表。 确定查询的语法是否符合用于执行查询的计划高速缓存中的计划的语法。 在查询中指定的N个表的通用表格式之间的匹配在计划中指定的N个表的通用表格式中被标识,响应于查询的语法,该查询的语法与计划缓存中用于执行查询的计划的语法相匹配。 执行查询的计划是基于查询的语法是否符合计划的语法,并且基于查询中指定的N个表的通用表格格式与指定的N个表的通用表格式之间的所确定的匹配来获得 在计划中。
    • 9. 发明申请
    • Join Order for a Database Query
    • 加入订单数据库查询
    • US20110137890A1
    • 2011-06-09
    • US12630950
    • 2009-12-04
    • Robert J. BestgenRobert V. DownerBrian R. Muras
    • Robert J. BestgenRobert V. DownerBrian R. Muras
    • G06F17/30
    • G06F17/30466
    • In an embodiment, a portion of the execution plan is executed to produce a portion of records in a partial result set. If a first join of a table is performed that eliminates more than a first threshold number of records from the partial result set, a determination is made whether an estimated cost of a forced primary join is less than an estimated cost of a star join. If the estimated cost of the forced primary join is less than the estimated cost of the star join, then the table is moved first in a join order in the execution plan, the portion of the records in the partial result set is discarded, and the execution is re-started with a different portion of the execution plan to produce a different portion of the records.
    • 在一个实施例中,执行执行计划的一部分以产生部分结果集中的一部分记录。 如果执行表的第一次连接,其从部分结果集中消除超过第一阈值数量的记录,则确定强制主连接的估计成本是否小于星形联接的估计成本。 如果强制主连接的估计成本小于星形连接的估计成本,则首先在执行计划中以连接顺序移动表,部分结果集中的部分记录将被丢弃, 以执行计划的不同部分重新开始执行以产生记录的不同部分。