Multilingual database interaction system and method
    1.
    发明申请
    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.

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

    Multidimensional data cubes with high-cardinality attributes
    4.
    发明授权
    Multidimensional data cubes with high-cardinality attributes 有权
    具有高基数属性的多维数据立方体

    公开(公告)号:US08380748B2

    公开(公告)日:2013-02-19

    申请号:US12042674

    申请日:2008-03-05

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30592

    摘要: Computer-readable media, systems, and methods for building a multidimensional data cube having one or more high-cardinality attributes are described. In embodiments, data is extracted from one or more databases. It is determined that one or more instances of the data are fact data and one or more instances of the data are dimension data. Each member of the fact data is one instance of a dimension and each instance of the dimension data includes an attribute for grouping the fact data. Moreover, in embodiments it is determined that one or more instances of the dimension data are high-cardinality attributes. The one or more high-cardinality attributes are processed with fact data and stored in fact tables on a computer storage medium.

    摘要翻译: 描述了用于构建具有一个或多个高基数属性的多维数据立方体的计算机可读介质,系统和方法。 在实施例中,从一个或多个数据库提取数据。 确定数据的一个或多个实例是事实数据,并且数据的一个或多个实例是尺寸数据。 事实数据的每个成员是维度的一个实例,维数据的每个实例包括用于对事实数据进行分组的属性。 此外,在实施例中,确定尺寸数据的一个或多个实例是高基数属性。 一个或多个高基数属性用事实数据处理并存储在计算机存储介质上的事实表中。

    Path compression for records of multidimensional database
    5.
    发明授权
    Path compression for records of multidimensional database 有权
    用于多维数据库记录的路径压缩

    公开(公告)号:US06430565B1

    公开(公告)日:2002-08-06

    申请号:US09602599

    申请日:2000-06-22

    IPC分类号: G06F1730

    摘要: Compressing system paths in a database is disclosed. The systems and methods of the invention define an efficient mechanism to specify a cell's location within the database where there are hierarchies of levels within a dimension. The compressed system paths allow random access of the data without decompressing the data. The format used lends itself well to indexing, and also to creating aggregations of the cell data.

    摘要翻译: 公开了压缩数据库中的系统路径。 本发明的系统和方法定义了一种有效的机制来指定数据库内的单元格的位置,其中存在维度内的层级。 压缩的系统路径允许随机访问数据而不解压缩数据。 所使用的格式很好地用于索引,也用于创建单元数据的聚合。

    System and method for analytically modeling data from different measure groups onto a single cube
    7.
    发明授权
    System and method for analytically modeling data from different measure groups onto a single cube 有权
    将来自不同测量组的数据分析建模到单个立方体上的系统和方法

    公开(公告)号:US07260513B2

    公开(公告)日:2007-08-21

    申请号:US10606343

    申请日:2003-06-25

    IPC分类号: G06F17/10 G06F7/60

    摘要: A system and method for analytically modeling data from different measure groups onto a single cube are disclosed. The single cube preferably includes a first measure associated with a first measure group with a first set of corresponding dimensions. The single cube preferably also includes a second measure associated with a second measure group with a second set of corresponding dimensions. The single cube preferably also includes each dimension in both the first and second set of dimensions. Each measure is preferably tied to each corresponding dimension according to data in an underlying relational data table. Each measure is preferably tied to each non-corresponding dimension according to an approximation.

    摘要翻译: 公开了将来自不同测量组的数据分析建模到单个立方体上的系统和方法。 单个立方体优选地包括与具有第一组对应尺寸的第一测量组相关联的第一测量。 单个立方体优选地还包括与具有第二组对应尺寸的第二测量组相关联的第二测量。 单个立方体优选地还包括第一和第二组尺寸中的每个尺寸。 根据潜在关系数据表中的数据,每个度量优选地连接到每个对应的维度。 每个度量优选地根据近似被连接到每个非对应的维度。

    Record for a multidimensional database with flexible paths
    9.
    发明授权
    Record for a multidimensional database with flexible paths 有权
    使用灵活路径记录多维数据库

    公开(公告)号:US06446059B1

    公开(公告)日:2002-09-03

    申请号:US09338207

    申请日:1999-06-22

    IPC分类号: G06F1730

    摘要: Creating and maintaining cell data records in a multidimensional database is disclosed using flexible dimension paths is disclosed. The systems and methods of the invention define an efficient mechanism to specify a cell's location within the multidimensional database where there are hierarchies of levels within a dimension. The flexible dimension path does not change when a member is moved from a first point to a second point on a dimension thereby avoiding the need to rebuild the OLAP database. The format used lends itself well to indexing, and also to creating aggregations of the cell data.

    摘要翻译: 公开了使用柔性尺寸路径来创建和维护多维数据库中的单元数据记录。 本发明的系统和方法定义了在多维数据库中指定单元格位置的有效机制,其中在维度内存在层级。 当成员从维度上的第一个点移动到第二个点时,灵活的维度路径不会改变,从而避免重建OLAP数据库的需要。 所使用的格式很好地用于索引,也用于创建单元数据的聚合。