Systems and methods for enhanced SQL indices for duplicate row entries
    1.
    发明授权
    Systems and methods for enhanced SQL indices for duplicate row entries 有权
    用于重复行条目的增强SQL索引的系统和方法

    公开(公告)号:US08645313B1

    公开(公告)日:2014-02-04

    申请号:US11139017

    申请日:2005-05-27

    IPC分类号: G06F17/00 G06F7/00

    CPC分类号: G06F17/30312

    摘要: A system and method for indexing non-uniquely indexed entries in a report generated with a business intelligence system, such as, for example, an on-line analytical processing (OLAP) system. A dummy index is added to each index element returned in the report. Non-unique index elements receive different dummy indices to distinguish otherwise identical row elements. The dummy index is added to a base template and optionally also to a view template of a report generator of the OLAP system.

    摘要翻译: 一种用于对由商业智能系统(例如在线分析处理(OLAP))系统生成的报告中的非唯一索引条目进行索引的系统和方法。 向报表中返回的每个索引元素添加一个虚拟索引。 非唯一索引元素接收不同的虚拟索引以区分其他相同的行元素。 虚拟索引被添加到基本模板,并且还可以添加到OLAP系统的报告生成器的视图模板。