-
公开(公告)号：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（多维表达式）中提供的数据立方体计算脚本可以逐步执行或应用。 可以针对计算脚本设置断点，并且可以通过用户界面查看和查询多维数据集状态。 用户通过主题系统和方法来启用逐步计算脚本，识别对多维数据集的影响，如果所需的结果未能发生，则更改脚本。 除了调试之外，系统和方法可以用于脚本的初始开发。
-
公开(公告)号：US07536400B2
公开(公告)日：2009-05-19
申请号：US11220075
申请日：2005-09-06
申请人： Mosha Pasumansky , Amir Netz
发明人： Mosha Pasumansky , Amir Netz
IPC分类号： G06F17/00
CPC分类号： G06F17/30592 , G06F17/30554 , Y10S707/99942 , Y10S707/99943 , Y10S707/99944 , Y10S707/99945
摘要： Maintaining data used for performing “what-if” analysis is disclosed. The systems and methods of the invention define an efficient mechanism allowing a user to specify how base values from a database are to be changed. The changes can be held in a local delta cache which is only exposed to a single user, leaving the base data unchanged. The changes can also be maintained in a write-back partition, which results in the changes being exposed to all clients of the database. Values in the write-back partition can be selectively rolled back if required.
摘要翻译： 维护用于执行“假设”分析的数据被公开。 本发明的系统和方法定义了一种有效的机制，允许用户指定如何改变来自数据库的基本值。 这些更改可以保存在只能暴露给单个用户的本地增量缓存中，保留基本数据不变。 更改也可以在回写分区中维护，这导致更改暴露给数据库的所有客户端。 如果需要，回写分区中的值可以有选择地回退。
-
公开(公告)号：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.
摘要翻译： 本发明涉及与多维数据的交互。 更具体地，可以将交互约束到多维数据立方体的有限子集，即子多维数据集。 在子多维数据集创建之后或之后，查询执行或其他交互（如计算）可以合并或限制于较小的子多维数据集查询空间，而不是典型的巨大的主多维数据集。 也可以创建和嵌套多个子多维数据集，以逐渐减少查询空间。 删除一个子多维数据集可能导致返回到先前定义的或分层的父子单元。
-
公开(公告)号：US20080126552A1
公开(公告)日：2008-05-29
申请号：US11530383
申请日：2006-09-08
IPC分类号： G06F15/16
CPC分类号： G06F9/5038
摘要： A system, method, and related techniques are disclosed for processing data across a distributed network to a plurality of machines. The method may include receiving a first user-supplied transform and generating a first package based on the first user-supplied transform. The method may further include receiving a designated key and generating a second package based on the key. Furthermore, the method may include receiving a second user-supplied transform and generating a third package based on the second user-supplied transform. Moreover, the method may include distributing the first, second, and third packages to a plurality of machines using a cluster API.
摘要翻译： 公开了一种用于将分布式网络上的数据处理到多个机器的系统，方法和相关技术。 该方法可以包括接收第一用户提供的变换并且基于第一用户提供的变换来生成第一包。 该方法还可以包括接收指定的密钥并且基于密钥生成第二包。 此外，该方法可以包括接收第二用户提供的变换并且基于第二用户提供的变换来生成第三包。 此外，该方法可以包括使用集群API将第一，第二和第三包分发到多个机器。
-
5.发明授权System and method for analytically modeling data organized according to a referenced attribute 有权根据参考属性组织的分析建模数据的系统和方法公开(公告)号：US07313559B2
公开(公告)日：2007-12-25
申请号：US10199584
申请日：2002-07-19
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , Y10S707/99933
摘要： A system and method for analytically modeling data in a data cube is disclosed. A first dimension of the data cube is modeled according to a first table having a referencing attribute. A second dimension of the data cube is modeled according to a second table having a referenced attribute. The first dimension is tied to the second dimension according to the referencing attribute and the referenced attribute.
摘要翻译： 公开了一种用于在数据立方体中对数据进行分析建模的系统和方法。 根据具有引用属性的第一表，对数据立方体的第一维进行建模。 根据具有引用属性的第二表，对数据立方体的第二维进行建模。 根据引用属性和引用的属性，第一个维度与第二个维度相关联。
-
公开(公告)号：US20060010143A1
公开(公告)日：2006-01-12
申请号：US11137232
申请日：2005-05-25
IPC分类号： G06F7/00
CPC分类号： G06F17/30592
摘要： Provided are systems and methods that facilitate direct write back in a multi-dimensional database. The system includes a delta cache component that receives a user request to change an original cell value and determines a delta value based at least in part upon the changed cell value. Also included is a write back partition component that selectively updates a data cell based at least in part upon the delta value without updating corresponding data cell values. The system and methods allow attributes to be added to any dimension of a cube without affecting the write back data. Adding, modifying or removing a hierarchy has no affect on write back data nor does deleting a dimension that is not referenced by a write back.
摘要翻译： 提供了便于在多维数据库中直接回写的系统和方法。 该系统包括增量缓存组件，其接收用户请求以改变原始小区值，并且至少部分地基于所改变的小区值来确定增量值。 还包括写回分区组件，其至少部分地基于增量值来选择性地更新数据单元，而不更新对应的数据单元值。 系统和方法允许将属性添加到多维数据集的任何维度，而不会影响回写数据。 添加，修改或删除层次结构对回写数据没有影响，也不会删除未被回写引用的维。
-
公开(公告)号：US06473750B1
公开(公告)日：2002-10-29
申请号：US09419452
申请日：1999-10-15
IPC分类号： G06F1730
CPC分类号： G06F17/30592 , G06F17/30457 , G06F17/30545 , Y10S707/99933 , Y10S707/99943
摘要： Systems, clients, servers, methods, and computer-readable media of varying scope are described in which, a database client applies an adaptive method to dynamically determines whether a particular request should execute on the client-side or the server-side of a client-server database system. In determining where a particular request should be executed, the database client analyzes the size of the data sets involved and the data flow generated by the data sets.
摘要翻译： 描述了不同范围的系统，客户端，服务器，方法和计算机可读介质，其中数据库客户端应用自适应方法来动态地确定特定请求是否应在客户端或服务器端执行 服务器数据库系统。 在确定应该执行特定请求的位置时，数据库客户机分析所涉及的数据集的大小以及由数据集生成的数据流。
-
公开(公告)号：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.
摘要翻译： 用于在存在表达式的情况下执行稀疏多维数据空间的查询的系统和技术。 维度与一组数据引用相关联，引用存储的数据项。 查询表达式具有维或数据引用作为操作数。 基于查询定义具有一个或多个结果维度的结果空间。 构建并执行用于检索与结果维度相关联的存储数据项的计划，并通过评估表达式形成“计算的数据项”。 执行该计划产生一组数据元组，每个数据流都具有存储检索到的数据项和/或计算的数据项的一组数据组件。 数据组件为空或具有数据值。 在流上采用迭代算法来定位在每个结果维度的交集处为空的数据元组。
-
公开(公告)号：US07937401B2
公开(公告)日：2011-05-03
申请号：US11116924
申请日：2005-04-28
申请人： Mosha Pasumansky , Irina G. Gorbach , Alexander Gourkov Balikov , Alexander Berger , Marius Dumitru , Thomas P. Conlon
发明人： Mosha Pasumansky , Irina G. Gorbach , Alexander Gourkov Balikov , Alexander Berger , Marius Dumitru , Thomas P. Conlon
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , Y10S707/957
摘要： The subject invention pertains to the integration of an object model and a multidimensional database query language such as MDX. In particular, multidimensional declarative query language entities can be exposed through objects in an object model. The object model enables generation and employment of procedural language functions, routines, or procedures that interact with multidimensional database data. This effectively provides an extension for multidimensional query languages. For example, procedures can be stored and invoked from a declarative language query. Furthermore, the object model disclosed herein can expose a context object to enable conditional procedures based on the context of execution.
摘要翻译： 本发明涉及对象模型和诸如MDX的多维数据库查询语言的集成。 特别地，可以通过对象模型中的对象来公开多维声明式查询语言实体。 对象模型可以生成和使用与多维数据库数据交互的过程语言函数，例程或过程。 这有效地为多维查询语言提供了扩展。 例如，程序可以从声明式语言查询中存储和调用。 此外，本文公开的对象模型可以暴露上下文对象以基于执行的上下文来启用条件过程。
-
-
-
-
-
-
-
-
-
搜索结果
53 条记录 (耗时 0.017 秒)
