公开(公告)号：US06473764B1

公开(公告)日：2002-10-29

申请号：US09418807

申请日：1999-10-15

申请人： Cristian Petculescu ,  Amir Netz

发明人： Cristian Petculescu ,  Amir Netz

IPC分类号： G06F1730

CPC分类号： G06F17/30592 ,  Y10S707/956 ,  Y10S707/957 ,  Y10S707/99943

摘要： A method, apparatus, and software are disclosed for analyzing the data in an OLAP or other type of database. The data is analyzed as if it were indexed by desired dimensions without actually creating the dimensions. Relations known as virtual dimensions are defined in relation to existing base dimensions in the database rather than in relation to the underlying detailed data. Functions operating on these virtual dimensions are translated into functions that operate on the existing base dimensions. As a result, the need to perform certain precalculations is avoided, thereby promoting efficient use of computing resources.

摘要翻译： 公开了用于分析OLAP或其他类型的数据库中的数据的方法，装置和软件。 对数据进行分析，就好像它按照所需尺寸进行索引，而无需实际创建尺寸。 称为虚拟维度的关系是根据数据库中现有的基础维度定义的，而不是与底层详细数据相关。 在这些虚拟维度上运行的函数将转换为基于现有基本维度的函数。 结果，避免了执行某些预先计算的需要，从而促进计算资源的有效利用。

公开(公告)号：US06473750B1

公开(公告)日：2002-10-29

申请号：US09419452

申请日：1999-10-15

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

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

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.

摘要翻译： 描述了不同范围的系统，客户端，服务器，方法和计算机可读介质，其中数据库客户端应用自适应方法来动态地确定特定请求是否应在客户端或服务器端执行 服务器数据库系统。 在确定应该执行特定请求的位置时，数据库客户机分析所涉及的数据集的大小以及由数据集生成的数据流。

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

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

公开(公告)号：US06405207B1

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

申请号：US09418805

申请日：1999-10-15

申请人： Cristian Petculescu ,  Amir Netz

发明人： Cristian Petculescu ,  Amir Netz

IPC分类号： G06F1730

CPC分类号： G06F17/30398 ,  G06F17/30489 ,  G06F17/30592 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99935 ,  Y10S707/99943

摘要： A facility for multidimensional, multilevel databases has a query syntax for specifying that aggregate-data cells representing higher levels of the database in a report include only the data from certain ones of the lower-level database items, rather than from all of them. A database engine extracts data from the lower-level query items from the database, and aggregates only the data from those items into one or more aggregate cells in accordance with a function named in the query.

摘要翻译： 用于多维多级数据库的设施具有查询语法，用于指定报表中表示较高级别的数据库的聚合数据单元仅包含来自某些较低级别数据库项的数据，而不是其中的所有数据。 数据库引擎从数据库中提取较低级别的查询项目的数据，并根据查询中命名的函数将仅从这些项目的数据聚合到一个或多个聚合单元中。

公开(公告)号：US20130339351A1

公开(公告)日：2013-12-19

申请号：US13495952

申请日：2012-06-13

申请人： Vijay Mital ,  Suraj T. Poozhiyil ,  Darryl Rubin ,  Amir Netz ,  Olivier Colle ,  Andrew Douglas Reddish

发明人： Vijay Mital ,  Suraj T. Poozhiyil ,  Darryl Rubin ,  Amir Netz ,  Olivier Colle ,  Andrew Douglas Reddish ,  Christian Beaumont

IPC分类号： G06F17/30

CPC分类号： G06F17/30056 ,  G06F17/30038 ,  G06F17/30386 ,  G06F17/30554 ,  G06F17/30702 ,  G06F17/30784 ,  G06T13/00

摘要： The present invention extends to methods, systems, and computer program products for using cinematic techniques to present data. Embodiments of the invention can be used to infer and generate cinematic techniques or combinations thereof based on a model and user action. Cinematic techniques can be used to meet the data exploration and analysis requirements of a user. As such, embodiments of the invention permit users (including non-programmers) to employ cinematic techniques (possibly in combination with other techniques) to gain insights into their data and also convey appropriate emotional messages.

摘要翻译： 本发明扩展到用于使用电影技术呈现数据的方法，系统和计算机程序产品。 本发明的实施例可以用于基于模型和用户动作来推断和产生电影技术或其组合。 可以使用电影技术来满足用户的数据探索和分析要求。 因此，本发明的实施例允许用户（包括非程序员）使用电影技术（可能与其他技术组合）来获得对其数据的洞察并且还传达适当的情感消息。

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

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

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

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