会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 66. 发明申请
    • Hybrid push-down/pull-up of unions with expensive operations in a federated query processor
    • 在联合查询处理器中使用昂贵的操作的工会的混合下推/上拉
    • US20070067274A1
    • 2007-03-22
    • US11228888
    • 2005-09-16
    • Wei HanInderpal NarangVijayshankar Raman
    • Wei HanInderpal NarangVijayshankar Raman
    • G06F17/30
    • G06F16/2456
    • Disclosed are a method and a system for executing a query that requires an expensive process, such as a join, between two or more datasets. If each dataset has multiple partitions that are located at multiple sources, then each of the multiple partitions for each dataset must be unioned prior to completing execution of the query. The method and system develop both a query execution plan and at least one alternative query execution plan to indicate when the process should be pushed down below the unions and when the process should be pulled up above the unions based on collocation of partitions. The query execution plan and the alternative query execution plan(s) are embedded in a composite query execution plan which is evaluated and re-evaluated at run time to determine which of the query execution plan and the alternative query execution plan is currently the most efficient plan and the query is executed, accordingly.
    • 公开了一种执行查询的方法和系统,该查询需要在两个或更多个数据集之间的昂贵的处理,诸如连接。 如果每个数据集具有位于多个源的多个分区,则在完成执行查询之前,必须对每个数据集的每个分区进行联合。 该方法和系统开发查询执行计划和至少一个替代查询执行计划,以指示何时将流程推送到工会下方,以及何时应该根据分区的搭配将工作提升到工会以上。 查询执行计划和替代查询执行计划嵌入在复合查询执行计划中,该计划在运行时进行评估和重新评估,以确定查询执行计划和备用查询执行计划中的哪一个当前是最有效的 相应地执行计划并执行查询。