-
公开(公告)号:US20050149550A1
公开(公告)日:2005-07-07
申请号:US10750205
申请日:2003-12-31
CPC分类号: G06F17/30592 , Y10S707/99952
摘要: The ability to link dimensions and measure groups in one analysis database to a second database is provided. This feature enables the use of the dimension or measure group without physically creating and managing the contents of the cube so defined.
摘要翻译: 提供了将维度和测量组在一个分析数据库中链接到第二个数据库的能力。 此功能可以使用维度或度量组,而无需物理创建和管理如此定义的多维数据集的内容。
-
公开(公告)号:US20050177358A1
公开(公告)日:2005-08-11
申请号:US10775612
申请日:2004-02-10
申请人: Edward Melomed , Alexander Berger , Amir Netz , Ariel Netz
发明人: Edward Melomed , Alexander Berger , Amir Netz , Ariel Netz
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.
摘要翻译: 本发明涉及一种翻译存储数据的系统和方法。 特别地,本发明通过在一种语言中存储的数据和喜欢以一种或多种不同语言交互的用户之间提供翻译组件来促进与数据存储的多语言交互。 查询或命令可以在数据库上执行,结果以由用户选择的多种语言中的任何一种呈现。 此外,还提供了一种机制,以允许用户以其首选语言而不是底层系统的语言输入查询。
-
公开(公告)号:US07562086B2
公开(公告)日:2009-07-14
申请号:US11167413
申请日:2005-06-27
IPC分类号: G06F7/00
CPC分类号: G06F17/30592 , Y10S707/99942
摘要: 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)定义,以影响对数据立方体的更改。 自定义分组可以提供中间维度级别,用于在具有少量成员的级别和具有众多成员的级别之间进行深入和/或钻取或汇总。 可以创建单独的维度属性或级别,并且定义的组包括或映射离散成员的集合或集合。
-
公开(公告)号:US20060010159A1
公开(公告)日:2006-01-12
申请号:US11167413
申请日:2005-06-27
IPC分类号: G06F17/00
CPC分类号: G06F17/30592 , Y10S707/99942
摘要: 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.
摘要翻译: 主题公开涉及对多维数据库立方体进行快速有效的修改。 例如,提供支持以添加尺寸成员的自定义分组。 在一个实例中,自定义分组可以提供一个中间维度级别,用于在具有少数成员的级别与具有众多成员的级别之间进行深入和/或钻取或卷积。 可以创建单独的维度属性或级别,并且定义的组包括或映射离散成员的集合或集合。 此外,可以实现定制分组而没有与重建,再处理或重新加载维度结构相关联的延迟。
-
5.
公开(公告)号: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.
摘要翻译: 为了允许使用尺度属性中的数据来对维度的成员进行分组,对维度属性数据进行分析,因此可以将其用作具有可管理数量状态的分类属性的数据。 维度属性可能的值被分为几组。 这是通过确定数据的分布来完成的。 可以确定近似分布(通过对某些数据进行采样),或者可以确定实际分布(通过对所有数据进行采样)。 然后使用该分布来确定数据值范围将被划分到的组。 然后将每个组视为对于分类型维度属性的状态。 可以通过确定哪个子范围包含成员的维度属性的值来确定成员的状态。 组的数量可以由用户确定或动态地确定,例如, 最适合发现的分布。 可以存储组数据以便进一步转换未来的情况。
-
公开(公告)号:US07809678B2
公开(公告)日:2010-10-05
申请号:US11135718
申请日:2005-05-24
申请人: Alexander Berger , Edward Melomed , Amir Netz , Cristian Petculescu , Akshai M. Mirchandani , Mosha Pasumansky , Marius Dumitru , Richard R. Tkachuk
发明人: Alexander Berger , Edward Melomed , Amir Netz , Cristian Petculescu , Akshai M. Mirchandani , Mosha Pasumansky , Marius Dumitru , Richard R. Tkachuk
CPC分类号: G06F17/30592 , G06F17/30418
摘要: The subject invention pertains to systems and methods for interacting with fact dimensions. In particular, systems and methods are disclosed that optimize performance and scalability with respect to processing queries that involve fact dimensions. Furthermore, queries involving fact dimensions can be evaluated in distinct manners. For instance, queries can be processed such that regular dimensions restrict the scope of the data and only fact dimension members that are relevant to that scope are exposed.
摘要翻译: 本发明涉及与事实维度相互作用的系统和方法。 特别地,公开了关于处理涉及事实维度的查询的性能和可扩展性的系统和方法。 此外,可以以不同的方式评估涉及事实维度的查询。 例如,可以处理查询,使得常规维度限制数据的范围,并且仅暴露与该范围相关的事实维度成员。
-
公开(公告)号:US07593969B2
公开(公告)日:2009-09-22
申请号:US10750205
申请日:2003-12-31
IPC分类号: G06F17/30
CPC分类号: G06F17/30592 , Y10S707/99952
摘要: The ability to link dimensions and measure groups in one analysis database to a second database is provided. This feature enables the use of the dimension or measure group without physically creating and managing the contents of the cube so defined.
摘要翻译: 提供了将维度和测量组在一个分析数据库中链接到第二个数据库的能力。 此功能可以使用维度或度量组,而无需物理创建和管理如此定义的多维数据集的内容。
-
公开(公告)号:US20060010113A1
公开(公告)日:2006-01-12
申请号:US11135718
申请日:2005-05-24
申请人: Alexander Berger , Edward Melomed , Amir Netz , Cristian Petculescu , Akshai Mirchandani , Mosha Pasumansky , Marius Dumitru , Richard Tkachuk
发明人: Alexander Berger , Edward Melomed , Amir Netz , Cristian Petculescu , Akshai Mirchandani , Mosha Pasumansky , Marius Dumitru , Richard Tkachuk
IPC分类号: G06F17/30
CPC分类号: G06F17/30592 , G06F17/30418
摘要: The subject invention pertains to systems and methods for interacting with fact dimensions. In particular, systems and methods are disclosed that optimize performance and scalability with respect to processing queries that involve fact dimensions. Furthermore, queries involving fact dimensions can be evaluated in distinct manners. For instance, queries can be processed such that regular dimensions restrict the scope of the data and only fact dimension members that are relevant to that scope are exposed.
摘要翻译: 本发明涉及与事实维度相互作用的系统和方法。 特别地,公开了关于处理涉及事实维度的查询的性能和可扩展性的系统和方法。 此外,可以以不同的方式评估涉及事实维度的查询。 例如,可以处理查询,使得常规维度限制数据的范围,并且仅暴露与该范围相关的事实维度成员。
-
公开(公告)号:US20050278458A1
公开(公告)日:2005-12-15
申请号:US10864745
申请日:2004-06-09
CPC分类号: H04L67/1095 , G06F16/27 , H04L67/1097
摘要: 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.
摘要翻译: 提供了系统和方法,用于将目标服务的状态与源服务器的状态同步。 在这种同步过程中,与目标服务器交互的用户仍可以从服务中断查询数据,并且在完成同步处理之后切换到数据库的新状态。 此外,维护事务一致性,并且启用系统管理员以改变数据高速缓存的位置,并且通过同步过程在多个服务器配置之间分发数据和/或应用程序。
-
-
-
-
-
-
-
-