-
1.发明授权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.
摘要翻译： 描述了用于构建具有一个或多个高基数属性的多维数据立方体的计算机可读介质，系统和方法。 在实施例中，从一个或多个数据库提取数据。 确定数据的一个或多个实例是事实数据，并且数据的一个或多个实例是尺寸数据。 事实数据的每个成员是维度的一个实例，维数据的每个实例包括用于对事实数据进行分组的属性。 此外，在实施例中，确定尺寸数据的一个或多个实例是高基数属性。 一个或多个高基数属性用事实数据处理并存储在计算机存储介质上的事实表中。
-
公开(公告)号：US06430565B1
公开(公告)日：2002-08-06
申请号：US09602599
申请日：2000-06-22
申请人： Alexander Berger , Amir Netz , Mosha Pasumansky
发明人： Alexander Berger , Amir Netz , Mosha Pasumansky
IPC分类号： G06F1730
CPC分类号： H03M7/30 , G06F17/30592 , Y10S707/99942 , Y10S707/99952
摘要： 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.
摘要翻译： 公开了压缩数据库中的系统路径。 本发明的系统和方法定义了一种有效的机制来指定数据库内的单元格的位置，其中存在维度内的层级。 压缩的系统路径允许随机访问数据而不解压缩数据。 所使用的格式很好地用于索引，也用于创建单元数据的聚合。
-
公开(公告)号：US07873669B2
公开(公告)日：2011-01-18
申请号：US11137232
申请日：2005-05-25
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.
摘要翻译： 提供了便于在多维数据库中直接回写的系统和方法。 该系统包括增量缓存组件，其接收用户请求以改变原始小区值，并且至少部分地基于所改变的小区值来确定增量值。 还包括写回分区组件，其至少部分地基于增量值来选择性地更新数据单元，而不更新对应的数据单元值。 系统和方法允许将属性添加到多维数据集的任何维度，而不会影响回写数据。 添加，修改或删除层次结构对回写数据没有影响，也不会删除未被回写引用的维。
-
公开(公告)号：US07660811B2
公开(公告)日：2010-02-09
申请号：US11069693
申请日：2005-03-01
申请人： Amir Netz , Marius Dumitru , Mosha Pasumansky , Cristian Petculescu , Richard R. Tkachuk , Alexander Berger
发明人： Amir Netz , Marius Dumitru , Mosha Pasumansky , Cristian Petculescu , Richard R. Tkachuk , Alexander Berger
IPC分类号： G06F7/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.
摘要翻译： 便于分析多维结构的内容的系统包括计算组件，其以与分配和计算中的一个或多个相关的声明语言接收语句，并针对多维结构执行这些语句。 通过生成组件创建一个通行证，以便在执行语句之前保持多维结构的内容，因为在参考此类通过时可以访问该通行证。
-
公开(公告)号：US20060010156A1
公开(公告)日：2006-01-12
申请号：US11069314
申请日：2005-03-01
申请人： Amir Netz , Richard Tkachuk , Cristian Petculescu , Mosha Pasumansky , Paul Sanders , Alexander Berger
发明人： Amir Netz , Richard Tkachuk , Cristian Petculescu , Mosha Pasumansky , Paul Sanders , Alexander Berger
IPC分类号： G06F17/00
CPC分类号： G06F16/24556 , G06F16/283
摘要： A system that facilitates generating a report based upon data within a relational database comprises a mapping component that utilizes mapping functions to associate a multi-dimensional structure with the relational database. A report generator communicates with the multi-dimensional structure to obtain data relating to the relational database and generates a report that includes the obtained data. For example, the mapping component can utilize measure groups to effectuate the association between the multi-dimensional structure and the relational database.
摘要翻译： 基于关系数据库内的数据来生成报告的系统包括利用映射函数将多维结构与关系数据库相关联的映射组件。 报告生成器与多维结构通信以获得与关系数据库相关的数据，并生成包括所获得的数据的报告。 例如，映射组件可以利用测量组来实现多维结构和关系数据库之间的关联。
-
公开(公告)号：US06493718B1
公开(公告)日：2002-12-10
申请号：US09419437
申请日：1999-10-15
IPC分类号： G06F1730
CPC分类号： G06F17/30592 , G06F17/3048 , Y10S707/956 , Y10S707/99943 , Y10S707/99945
摘要： Systems, clients, servers, methods, and computer-readable media of varying scope are described in which, a data retrieval module of database client implements an aggressive caching scheme that seeks to predict what data cells will be needed to satisfy future queries. The data retrieval module applies an adaptive algorithm to dynamically determine the granularity of data to retrieve from a database server. The data retrieval module adaptively balances the benefit of satisfying future queries locally with the cost of retrieving larger data set from remote database server.
摘要翻译： 描述了不同范围的系统，客户端，服务器，方法和计算机可读介质，其中数据库客户端的数据检索模块实现了一种积极的缓存方案，其寻求预测将需要哪些数据单元来满足将来的查询。 数据检索模块应用自适应算法来动态地确定从数据库服务器检索的数据的粒度。 数据检索模块自适应地平衡本地满足未来查询的好处与从远程数据库服务器检索较大数据集的成本。
-
公开(公告)号：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.
摘要翻译： 本发明涉及与事实维度相互作用的系统和方法。 特别地，公开了关于处理涉及事实维度的查询的性能和可扩展性的系统和方法。 此外，可以以不同的方式评估涉及事实维度的查询。 例如，可以处理查询，使得常规维度限制数据的范围，并且仅暴露与该范围相关的事实维度成员。
-
-
-
-
-
-
-
-
-
搜索结果
50 条记录 (耗时 0.021 秒)
