公开(公告)号：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.

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

公开(公告)号：US07260513B2

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

申请号：US10606343

申请日：2003-06-25

申请人： Cristian Petrulescu ,  Amir Netz ,  Mosha Pasumansky ,  Alexander Berger

发明人： Cristian Petrulescu ,  Amir Netz ,  Mosha Pasumansky ,  Alexander Berger

IPC分类号： G06F17/10 ,  G06F7/60

CPC分类号： G06F17/30592 ,  G06F2216/03 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99943

摘要： 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.

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

公开(公告)号：US06446059B1

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

申请号：US09338207

申请日：1999-06-22

申请人： Alexander Berger ,  Amir Netz ,  Mosha Pasumansky

发明人： Alexander Berger ,  Amir Netz ,  Mosha Pasumansky

IPC分类号： G06F1730

CPC分类号： G06F17/30592 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99935

摘要： 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数据库的需要。 所使用的格式很好地用于索引，也用于创建单元数据的聚合。

公开(公告)号：US06477536B1

公开(公告)日：2002-11-05

申请号：US09337828

申请日：1999-06-22

申请人： Mosha Pasumansky ,  Alexander Berger ,  Amir Netz

发明人： Mosha Pasumansky ,  Alexander Berger ,  Amir Netz

IPC分类号： G06F1730

CPC分类号： G06F17/30592 ,  G06F17/30418 ,  G06F17/3048 ,  Y10S707/99934 ,  Y10S707/99942 ,  Y10S707/99943

摘要： Systems and methods for creating and maintaining virtual cubes are disclosed. A virtual cube is a logical representation of a subset of the dimensions and measures of at least one physical cube maintained by an OLAP server. Metadata defines the mappings from the dimensions and measures of the virtual cube to the dimensions and measures of the physical cube. Client applications can manipulate the virtual cube as if it were a physical cube.

摘要翻译： 公开了用于创建和维护虚拟立方体的系统和方法。 虚拟多维数据集是由OLAP服务器维护的至少一个物理多维数据集的维度和度量的子集的逻辑表示。 元数据定义了从虚拟多维数据集的维度和度量到物理多维数据集的维度和度量的映射。 客户端应用程序可以像虚拟立方体那样操纵虚拟立方体。

公开(公告)号：US06442560B1

公开(公告)日：2002-08-27

申请号：US09338666

申请日：1999-06-22

申请人： Alexander Berger ,  Amir Netz ,  Mosha Pasumansky

发明人： Alexander Berger ,  Amir Netz ,  Mosha Pasumansky

IPC分类号： G06F1713

CPC分类号： G06F17/30592 ,  G06F17/18 ,  G06F2216/03 ,  Y10S707/99943

摘要： Creating and maintaining cell data records in a multidimensional database 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 format used lends itself well to indexing, and also to creating aggregations of the cell data.

摘要翻译： 公开了在多维数据库中创建和维护单元数据记录。 本发明的系统和方法定义了在多维数据库中指定单元格位置的有效机制，其中在维度内存在层级。 所使用的格式很好地用于索引，也用于创建单元数据的聚合。

公开(公告)号：US06424972B1

公开(公告)日：2002-07-23

申请号：US09602610

申请日：2000-06-22

申请人： Alexander Berger ,  Amir Netz ,  Cristian Petculescu

发明人： Alexander Berger ,  Amir Netz ,  Cristian Petculescu

IPC分类号： G06F1730

CPC分类号： H03M7/24 ,  G06F17/30569 ,  G06F17/30592 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99943

摘要： A method and system for compressing and decompressing read only data in records that have a fixed size. A plurality of records are divided into segments having a predetermined size. For each segment, the records are arranged in a table with rows for each record and a column for each field in each record. The width of each column of repeated data is compressed to zero bits and the repeated data is referenced in a header of the segment. The width of each column of integer data is compressed to the minimum number of bits required to represent the largest integer value in the fields of the column. Floating point data in each column is converted to integer data and the width of the each column with converted integer data is set to the minimum width necessary to represent the largest converted integer in each column. The conversion to integer data is calculated for floating point and real numbers with a minimum precision exponent that is stored in the header for the segment. Floating point data is cleaned when it is converted to integer data. The information in the header is employed to decompress the compressed records in the segment. The decompression lends itself well to fast random access of secondary storage devices.

摘要翻译： 用于压缩和解压缩具有固定大小的记录中的只读数据的方法和系统。 多个记录被划分成具有预定大小的段。 对于每个段，记录排列在每个记录的行中，每个记录中每个字段的列。 重复数据的每一列的宽度被压缩到零位，重复的数据被引用在段的标题中。 整列数据的每一列的宽度被压缩到列的字段中表示最大整数值所需的最小位数。 每列中的浮点数据被转换为整数数据，并且具有转换的整数数据的每列的宽度被设置为表示每列中最大转换整数所需的最小宽度。 针对浮点和实数计算转换为整数数据，最小精度指数存储在段的头部。 浮点数据被转换为整数数据时被清除。 头部中的信息用于解压缩片段中的压缩记录。 解压缩适用于二级存储设备的快速随机访问。

公开(公告)号：US07016912B2

公开(公告)日：2006-03-21

申请号：US10863188

申请日：2004-06-08

申请人： Mosha Pasumansky ,  Amir Netz

发明人： Mosha Pasumansky ,  Amir Netz

IPC分类号： G06F17/30

CPC分类号： G06F17/30554 ,  G06F17/30592 ,  Y10S707/99932 ,  Y10S707/99935 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944 ,  Y10S707/99945 ,  Y10S707/99953

摘要： 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.

公开(公告)号：US06999970B2

公开(公告)日：2006-02-14

申请号：US10996673

申请日：2004-11-24

申请人： Mosha Pasumansky ,  Amir Netz

发明人： Mosha Pasumansky ,  Amir Netz

IPC分类号： G06F17/30

CPC分类号： G06F17/30554 ,  G06F17/30592 ,  Y10S707/99932 ,  Y10S707/99935 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944 ,  Y10S707/99945 ,  Y10S707/99953

摘要： 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.

公开(公告)号：US06766325B1

公开(公告)日：2004-07-20

申请号：US09453193

申请日：1999-12-02

申请人： Mosha Pasumansky ,  Amir Netz

发明人： Mosha Pasumansky ,  Amir Netz

IPC分类号： G06F1730

CPC分类号： G06F17/30554 ,  G06F17/30592 ,  Y10S707/99932 ,  Y10S707/99935 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944 ,  Y10S707/99945 ,  Y10S707/99953

摘要： 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.

摘要翻译： 维护用于执行“假设”分析的数据被公开。 本发明的系统和方法定义了一种有效的机制，允许用户指定如何改变来自数据库的基本值。 这些更改可以保存在只能暴露给单个用户的本地增量缓存中，保留基本数据不变。 更改也可以在回写分区中维护，这导致更改暴露给数据库的所有客户端。 如果需要，回写分区中的值可以有选择地回退。

公开(公告)号：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.

摘要翻译： 维护用于执行“假设”分析的数据被公开。 本发明的系统和方法定义了一种有效的机制，允许用户指定如何改变来自数据库的基本值。 这些更改可以保存在只能暴露给单个用户的本地增量缓存中，保留基本数据不变。 更改也可以在回写分区中维护，这导致更改暴露给数据库的所有客户端。 如果需要，回写分区中的值可以有选择地回退。