-
1.
公开(公告)号:US20060020921A1
公开(公告)日:2006-01-26
申请号:US11133557
申请日:2005-05-20
IPC分类号: G06F9/44
CPC分类号: G06F11/3636
摘要: The subject invention pertains to systems and methods that facilitate development and debugging of calculations in a multidimensional data environment or model. Data cube calculation scripts, including those provided in MDX (Multidimensional Expressions), can be executed or applied incrementally. Breakpoints can be set with respect to a calculation script and the cube state can be viewed and queried via a user interface. Users are enabled by the subject systems and methods to step through calculation scripts, identify the effects on a cube, and alter the script if the desired results failed to occur. In addition to debugging, the systems and methods can be employed for initial development of scripts.
摘要翻译: 本发明涉及促进在多维数据环境或模型中计算的开发和调试的系统和方法。 包括MDX(多维表达式)中提供的数据立方体计算脚本可以逐步执行或应用。 可以针对计算脚本设置断点,并且可以通过用户界面查看和查询多维数据集状态。 用户通过主题系统和方法来启用逐步计算脚本,识别对多维数据集的影响,如果所需的结果未能发生,则更改脚本。 除了调试之外,系统和方法可以用于脚本的初始开发。
-
2.
公开(公告)号:US07694278B2
公开(公告)日:2010-04-06
申请号:US11133557
申请日:2005-05-20
IPC分类号: G06F9/44
CPC分类号: G06F11/3636
摘要: The subject invention pertains to systems and methods that facilitate development and debugging of calculations in a multidimensional data environment or model. Data cube calculation scripts, including those provided in MDX (Multidimensional Expressions), can be executed or applied incrementally. Breakpoints can be set with respect to a calculation script and the cube state can be viewed and queried via a user interface. Users are enabled by the subject systems and methods to step through calculation scripts, identify the effects on a cube, and alter the script if the desired results failed to occur. In addition to debugging, the systems and methods can be employed for initial development of scripts.
摘要翻译: 本发明涉及促进在多维数据环境或模型中计算的开发和调试的系统和方法。 包括MDX(多维表达式)中提供的数据立方体计算脚本可以逐步执行或应用。 可以针对计算脚本设置断点,并且可以通过用户界面查看和查询多维数据集状态。 用户通过主题系统和方法来启用逐步计算脚本,识别对多维数据集的影响,如果所需的结果未能发生,则更改脚本。 除了调试之外,系统和方法可以用于脚本的初始开发。
-
公开(公告)号:US20060026167A1
公开(公告)日:2006-02-02
申请号:US11069342
申请日:2005-03-01
申请人: Mosha Pasumansky , Marius Dumitru , Adrian Dumitrascu , Cristian Petculescu , Akshai Mirchandani , Paul Sanders , T.K. Anand , Richard Tkachuk , Raman Iyer , Thomas Conlon , Alexander Berger , Sergei Gringauze , Ioan Crivat , C. MacLennan , Rong Guan
发明人: Mosha Pasumansky , Marius Dumitru , Adrian Dumitrascu , Cristian Petculescu , Akshai Mirchandani , Paul Sanders , T.K. Anand , Richard Tkachuk , Raman Iyer , Thomas Conlon , Alexander Berger , Sergei Gringauze , Ioan Crivat , C. MacLennan , Rong Guan
IPC分类号: G06F17/30
CPC分类号: G06F17/30893
摘要: The subject invention relates to systems and methods that extend the network data access capabilities of mark-up language protocols. In one aspect, a network data transfer system is provided. The system includes a protocol component that employs a computerized mark-up language to facilitate data interactions between network components, whereby the data interactions were previously limited or based on a statement command associated with the markup language. An extension component operates with the protocol component to support the data transactions, where the extension component supplies at least one other command from the statement command to facilitate the data interactions.
摘要翻译: 本发明涉及扩展标记语言协议的网络数据访问能力的系统和方法。 一方面,提供一种网络数据传送系统。 该系统包括协议组件,其采用计算机化的标记语言来促进网络组件之间的数据交互,由此先前限制数据交互或基于与标记语言相关联的语句命令。 扩展组件与协议组件一起运行以支持数据事务,其中扩展组件从语句命令提供至少一个其他命令,以促进数据交互。
-
公开(公告)号:US20060010114A1
公开(公告)日:2006-01-12
申请号:US11137233
申请日:2005-05-25
申请人: Marius Dumitru , Amir Netz , Mosha Pasumansky , Cristian Petculescu , Richard Tkachuk , Paul Sanders
发明人: Marius Dumitru , Amir Netz , Mosha Pasumansky , Cristian Petculescu , Richard Tkachuk , Paul Sanders
IPC分类号: G06F7/00
CPC分类号: G06F17/30592 , G06F17/30418 , Y10S707/99933 , Y10S707/99945 , Y10S707/99948
摘要: The subject invention pertains to interaction with multidimensional data. More specifically, interactions can be constrained to a limited subset of a multidimensional data cube, namely a subcube. Subsequent to or concurrently with subcube creation, query execution or other interactions such as calculations can be consolidated or restricted to the smaller subcube query space rather than the typically enormous main cube. Multiple subcubes can also be created and nested to gradually reduce the query space. Deletion of one subcube can cause a reversion back to a previously defined or hierarchical parent subcube.
-
公开(公告)号: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.
摘要翻译: 本发明涉及与事实维度相互作用的系统和方法。 特别地,公开了关于处理涉及事实维度的查询的性能和可扩展性的系统和方法。 此外,可以以不同的方式评估涉及事实维度的查询。 例如,可以处理查询,使得常规维度限制数据的范围,并且仅暴露与该范围相关的事实维度成员。
-
公开(公告)号:US20060007731A1
公开(公告)日:2006-01-12
申请号:US11069263
申请日:2005-03-01
申请人: Marius Dumitru , Amir Netz , Mosha Pasumansky , Cristian Petculescu , Richard Tkachuk , Alexander Berger , Irina Gorbach , Grzegorz Guzik
发明人: Marius Dumitru , Amir Netz , Mosha Pasumansky , Cristian Petculescu , Richard Tkachuk , Alexander Berger , Irina Gorbach , Grzegorz Guzik
IPC分类号: G11C11/34
CPC分类号: G06F17/30522 , G06F17/30389 , G06F17/30592 , Y10S707/99933
摘要: A system that facilitates one or more of querying and updating a multi-dimensional structure comprises a component that receives a statement in a declarative language relating to a typed object associated with a multi-dimensional structure. A conversion component analyzes context associated with the statement and automatically converts the object to a disparate type as a function of the analysis. For example, an execution engine can comprise the conversion component, and the execution engine can be an Online Analytical Processing (OLAP) engine.
摘要翻译: 促进查询和更新多维结构中的一个或多个的系统包括接收与与多维结构相关联的类型对象相关的声明语言的语句的组件。 转换组件分析与语句相关联的上下文,并根据分析自动将对象转换为不同类型。 例如,执行引擎可以包括转换组件,并且执行引擎可以是在线分析处理(OLAP)引擎。
-
公开(公告)号:US20060010139A1
公开(公告)日:2006-01-12
申请号:US11069693
申请日:2005-03-01
申请人: Amir Netz , Marius Dumitru , Mosha Pasumansky , Cristian Petculescu , Richard Tkachuk , Alexander Berger
发明人: Amir Netz , Marius Dumitru , Mosha Pasumansky , Cristian Petculescu , Richard Tkachuk , Alexander Berger
IPC分类号: G06F17/00
CPC分类号: G06F17/30539 , G06F17/30522 , G06F17/30592 , Y10S707/99943
摘要: A system that facilitates analyzing content of a multi-dimensional structure comprises a calculation component that receives statements in a declarative language relating to one or more of an assignment and calculation and executes such statements against a multi-dimensional structure. A pass generation component creates a pass in order to maintain content of the multi-dimensional structure as it existed prior to execution of the statement, the pass is accessible upon reference to such pass.
摘要翻译: 便于分析多维结构的内容的系统包括计算组件,其以与分配和计算中的一个或多个相关的声明语言接收语句,并针对多维结构执行这些语句。 通过生成组件创建一个通行证,以便在执行语句之前保持多维结构的内容,因为在参考此类通过时可以访问该通行证。
-
公开(公告)号:US07490106B2
公开(公告)日:2009-02-10
申请号:US11137233
申请日:2005-05-25
申请人: Marius Dumitru , Amir Netz , Mosha Pasumansky , Cristian Petculescu , Richard R. Tkachuk , Paul J. Sanders
发明人: Marius Dumitru , Amir Netz , Mosha Pasumansky , Cristian Petculescu , Richard R. Tkachuk , Paul J. Sanders
IPC分类号: G06F7/00
CPC分类号: G06F17/30592 , G06F17/30418 , Y10S707/99933 , Y10S707/99945 , Y10S707/99948
摘要: The subject invention pertains to interaction with multidimensional data. More specifically, interactions can be constrained to a limited subset of a multidimensional data cube, namely a subcube. Subsequent to or concurrently with subcube creation, query execution or other interactions such as calculations can be consolidated or restricted to the smaller subcube query space rather than the typically enormous main cube. Multiple subcubes can also be created and nested to gradually reduce the query space. Deletion of one subcube can cause a reversion back to a previously defined or hierarchical parent subcube.
摘要翻译: 本发明涉及与多维数据的交互。 更具体地,可以将交互约束到多维数据立方体的有限子集,即子多维数据集。 在子多维数据集创建之后或之后,查询执行或其他交互(如计算)可以合并或限制于较小的子多维数据集查询空间,而不是典型的巨大的主多维数据集。 也可以创建和嵌套多个子多维数据集,以逐渐减少查询空间。 删除一个子多维数据集可能导致返回到先前定义的或分层的父子单元。
-
公开(公告)号:US08380748B2
公开(公告)日:2013-02-19
申请号:US12042674
申请日:2008-03-05
申请人: Alexander Berger , Mosha Pasumansky , Amir Netz , Akshai M. Mirchandani , Marius Dumitru , Cristian Petculescu
发明人: Alexander Berger , Mosha Pasumansky , Amir Netz , Akshai M. Mirchandani , Marius Dumitru , Cristian Petculescu
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.
摘要翻译: 描述了用于构建具有一个或多个高基数属性的多维数据立方体的计算机可读介质,系统和方法。 在实施例中,从一个或多个数据库提取数据。 确定数据的一个或多个实例是事实数据,并且数据的一个或多个实例是尺寸数据。 事实数据的每个成员是维度的一个实例,维数据的每个实例包括用于对事实数据进行分组的属性。 此外,在实施例中,确定尺寸数据的一个或多个实例是高基数属性。 一个或多个高基数属性用事实数据处理并存储在计算机存储介质上的事实表中。
-
公开(公告)号:US08229923B2
公开(公告)日:2012-07-24
申请号:US12239695
申请日:2008-09-26
CPC分类号: G06F17/30592 , Y10S707/957
摘要: A system and techniques for executing queries of a sparse multidimensional data space in the presence of expressions. A dimension is associated with a set of data references, which reference stored data items. A query expression has dimension or a data reference as an operand. A result space with one or more result dimensions is defined based on the query. A plan is built and executed for retrieving the stored data items associated with the result dimensions, and forming “calculated data items” by evaluating the expression. Executing the plan produces a stream of data tuples, each having a set of data components storing the retrieved data items and/or the calculated data items. Data components are either empty or have data values. An iterative algorithm is employed on the stream to locate the data tuples that are empty at the intersection of each result dimension.
摘要翻译: 用于在存在表达式的情况下执行稀疏多维数据空间的查询的系统和技术。 维度与一组数据引用相关联,引用存储的数据项。 查询表达式具有维或数据引用作为操作数。 基于查询定义具有一个或多个结果维度的结果空间。 构建并执行用于检索与结果维度相关联的存储数据项的计划,并通过评估表达式形成“计算的数据项”。 执行该计划产生一组数据元组,每个数据流都具有存储检索到的数据项和/或计算的数据项的一组数据组件。 数据组件为空或具有数据值。 在流上采用迭代算法来定位在每个结果维度的交集处为空的数据元组。
-
-
-
-
-
-
-
-
-