会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 7. 发明申请
    • STRUCTURED INDEXES ON RESULTS OF FUNCTION APPLICATIONS OVER DATA
    • 功能应用结果的结构化指标超过数据
    • WO2005096185A1
    • 2005-10-13
    • PCT/US2004/024566
    • 2004-07-29
    • MICROSOFT CORPORATIONCUNNINGHAM, Conor, J.HANSON, Eric, N.JOSHI, Milind, M.GALINDO-LEGARIA, Cesar, A.WAAS, Florian, M.
    • CUNNINGHAM, Conor, J.HANSON, Eric, N.JOSHI, Milind, M.GALINDO-LEGARIA, Cesar, A.WAAS, Florian, M.
    • G06F17/30
    • G06F17/30451Y10S707/99932Y10S707/99933Y10S707/99934Y10S707/99935
    • Indexed views or materialized views are used as a secondary index on a base table with multi-valued attributes. This provides for using the index to search in the nested data. Moreover, indexing is provided on the result of an unnest operation. Indexing a view on the result of an unnesting operation provides the ability to index the contents of a nested collection. One such unnesting operation is "cross apply unnest". This provides additional options for a query execution plan, leading to a more optimized query. A back-join is provided from the indexed view to the base table to allow fields from the base table that are not present in the indexed view to be included in a result of a query on the table which is processed using the indexed view as an access path. This provides a means of including columns in the query result that are not in the indexed view but are in the base table. The back-join is supported from a single-table indexed view to the base table via a unique clustering key which acts as a logical row locator. Thus, the system can back-join to the base table from an indexed view via the unique clustering key. These features allow the use of indexed views to index a table on the contents of multi-set or multi-valued attributes.
    • 索引视图或物化视图用作具有多值属性的基表上的辅助索引。 这提供了使用索引来搜索嵌套数据。 而且,索引是针对不良操作的结果。 索引对不察觉操作的结果的视图提供了对嵌套集合的内容进行索引的能力。 一个这样的不太理想的操作是“不适用”。 这为查询执行计划提供了其他选项,从而导致更优化的查询。 从索引视图向基表提供反向连接,以允许来自索引视图中不存在的基表中的字段包含在使用索引视图处理的表上的查询结果中作为 访问路径 这提供了一种在查询结果中包含不在索引视图中但在基表中的列的方法。 通过独立的集群密钥(作为逻辑行定位符),从单表索引视图向基表支持后连接。 因此,系统可以通过独特的聚类键从索引视图返回到基表。 这些功能允许使用索引视图来索引关于多集或多值属性的内容的表。