Custom grouping for dimension members
    3.
    发明申请
    Custom grouping for dimension members 有权
    维度成员的自定义分组

    公开(公告)号:US20060010159A1

    公开(公告)日:2006-01-12

    申请号:US11167413

    申请日:2005-06-27

    IPC分类号: G06F17/00

    摘要: The subject disclosure pertains to swift and efficient modification of multidimensional database cubes. For example, support is provided for the addition of custom groupings of dimension members. In one instance, the custom groupings can provide an intermediate dimension level for drill down and/or drill up or roll-up between a level with few members and a level with numerous members. A separate dimensional attribute or level can be created and a group defined comprising or mapping a set or collection of discrete members. Furthermore, the custom grouping can be realized without the delay associated with rebuilding, reprocessing or reloading dimensional structures.

    摘要翻译: 主题公开涉及对多维数据库立方体进行快速有效的修改。 例如,提供支持以添加尺寸成员的自定义分组。 在一个实例中,自定义分组可以提供一个中间维度级别,用于在具有少数成员的级别与具有众多成员的级别之间进行深入和/或钻取或卷积。 可以创建单独的维度属性或级别,并且定义的组包括或映射离散成员的集合或集合。 此外,可以实现定制分组而没有与重建,再处理或重新加载维度结构相关联的延迟。

    Multilingual database interaction system and method
    4.
    发明申请
    Multilingual database interaction system and method 审中-公开
    多语言数据库交互系统和方法

    公开(公告)号:US20050177358A1

    公开(公告)日:2005-08-11

    申请号:US10775612

    申请日:2004-02-10

    IPC分类号: G06F17/28

    CPC分类号: G06F17/2872 G06F16/24522

    摘要: The present invention relates to a system and method of translating stored data. In particular the present invention facilitates multilingual interaction with a data store by providing a translation component between data stored in one language and users that prefer to interact in one or more different languages. Queries or commands can be executed on a database and results presented in any one of a plurality of languages selected by a user. Furthermore, a mechanism is also provided to allow users to enter queries in their preferred language rather than the language of the underlying system.

    摘要翻译: 本发明涉及一种翻译存储数据的系统和方法。 特别地,本发明通过在一种语言中存储的数据和喜欢以一种或多种不同语言交互的用户之间提供翻译组件来促进与数据存储的多语言交互。 查询或命令可以在数据库上执行,结果以由用户选择的多种语言中的任何一种呈现。 此外,还提供了一种机制,以允许用户以其首选语言而不是底层系统的语言输入查询。

    Custom grouping for dimension members
    6.
    发明授权
    Custom grouping for dimension members 有权
    维度成员的自定义分组

    公开(公告)号:US07562086B2

    公开(公告)日:2009-07-14

    申请号:US11167413

    申请日:2005-06-27

    IPC分类号: G06F7/00

    摘要: Custom grouping for dimension members of an On-Line Analytical Processing (OLAP) cube is facilitated by an interface component that receives a grouping from a user. A modification component alters an attribute of a session OLAP data cube or a virtual OLAP multi-dimensional data cube so that the change becomes readily available without the time-consuming delay associated with rebuilding or reprocessing the underlying structure. A data scheme generation component produces a data definition language (DDL) definition of a user defined attribute executed by an execution component to affect the change to a data cube. Custom groupings can provide an intermediate dimension level for drill down and/or drill up or roll-up between a level with few members and a level with numerous members. A separate dimensional attribute or level can be created and a group defined comprising or mapping a set or collection of discrete members.

    摘要翻译: 由在线分析处理(OLAP)多维数据集的维度成员进行自定义分组,该接口组件从用户接收分组。 修改组件更改会话OLAP数据立方体或虚拟OLAP多维数据立方体的属性,以便更改变得容易获得,而不需要与重建或重新处理底层结构相关的耗时的延迟。 数据方案生成组件产生由执行组件执行的用户定义属性的数据定义语言(DDL)定义,以影响对数据立方体的更改。 自定义分组可以提供中间维度级别,用于在具有少量成员的级别和具有众多成员的级别之间进行深入和/或钻取或汇总。 可以创建单独的维度属性或级别,并且定义的组包括或映射离散成员的集合或集合。

    Discretization of dimension attributes using data mining techniques
    7.
    发明申请
    Discretization of dimension attributes using data mining techniques 审中-公开
    使用数据挖掘技术离散维度属性

    公开(公告)号:US20060005121A1

    公开(公告)日:2006-01-05

    申请号:US10881262

    申请日:2004-06-30

    IPC分类号: G06F17/30

    CPC分类号: G06F16/283 G06F2216/03

    摘要: In order to allow the use of data in dimension attributes for grouping members of a dimension, dimension attribute data is analyzed so it can be used as if it were data for a categorical attribute with a manageable number of states. The values possible for the dimension attribute are divided into groups. This is done by determining the distribution of data. An approximate distribution may be determined (by sampling some data) or an actual distribution may be determined (by sampling all data). The distribution is then used to determine the groups into which the range of data values will be divided. Each group is then treated as if it were a state for a categorical-type dimension attribute. A state can be determined for a member by determining which subrange contains the value for the dimension attribute for the member. The number of groups can be determined by a user or determined dynamically, e.g. to best fit the distribution found. The group data may be stored in order to allow further conversion of future cases.

    摘要翻译: 为了允许使用尺度属性中的数据来对维度的成员进行分组,对维度属性数据进行分析,因此可以将其用作具有可管理数量状态的分类属性的数据。 维度属性可能的值被分为几组。 这是通过确定数据的分布来完成的。 可以确定近似分布(通过对某些数据进行采样),或者可以确定实际分布(通过对所有数据进行采样)。 然后使用该分布来确定数据值范围将被划分到的组。 然后将每个组视为对于分类型维度属性的状态。 可以通过确定哪个子范围包含成员的维度属性的值来确定成员的状态。 组的数量可以由用户确定或动态地确定,例如, 最适合发现的分布。 可以存储组数据以便进一步转换未来的情况。

    Analysis services database synchronization
    9.
    发明申请
    Analysis services database synchronization 审中-公开
    分析服务数据库同步

    公开(公告)号:US20050278458A1

    公开(公告)日:2005-12-15

    申请号:US10864745

    申请日:2004-06-09

    IPC分类号: G06F17/00 G06F17/30 H04L29/08

    摘要: Systems and methodologies are provided for synchronizing a state of a target serve with that of a source server. During such synchronization process users that interact with the target server can still query data therefrom, with no interruption of service, and are switched to a new state of database upon completion of the synchronization process. Additionally, a transaction consistency is maintained and system administrators are enabled to change location of the data caches, and distribute data and/or applications among a plurality of server configurations by the synchronization process.

    摘要翻译: 提供了系统和方法,用于将目标服务的状态与源服务器的状态同步。 在这种同步过程中,与目标服务器交互的用户仍可以从服务中断查询数据,并且在完成同步处理之后切换到数据库的新状态。 此外,维护事务一致性,并且启用系统管理员以改变数据高速缓存的位置,并且通过同步过程在多个服务器配置之间分发数据和/或应用程序。