公开(公告)号：US20030208503A1

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

申请号：US10435428

申请日：2003-05-09

申请人： ORACLE INTERNATIONAL CORPORATION

发明人： Raymond Roccaforte

IPC分类号： G06F017/00

CPC分类号： G06F17/3061 ,  G06F17/30592 ,  Y10S707/954 ,  Y10S707/957 ,  Y10S707/958 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99945 ,  Y10S707/99948

摘要： According to one aspect, an index that is built on a table having a plurality of rows comprises an index entry that contains a key value for a sub-part of a row and that includes data for locating a row and data for locating, within the row, a value associated with the sub-part of the row. In one embodiment, the sub-part of the row is an array, with each member of the array represented in the row.

摘要翻译： 根据一个方面，构建在具有多个行的表上的索引包括索引条目，其包含行的子部分的键值，并且包括用于定位行的数据和用于定位的数据， 行，与该行的子部分相关联的值。 在一个实施例中，该行的子部分是阵列，阵列中的每个成员表示在该行中。

公开(公告)号：US20030088540A1

公开(公告)日：2003-05-08

申请号：US10016262

申请日：2001-11-02

发明人： David Walter Edmunds ,  Robert Minns ,  James Wallace Sinclair

IPC分类号： G06F007/00

CPC分类号： G06F17/246 ,  G06Q10/06 ,  Y10S707/958 ,  Y10S707/99931 ,  Y10S707/99934 ,  Y10S707/99936

摘要： This invention addresses the need for dealing with complex planning calculations based on data warehouse or Planning Data Repository (PDR) data where some aggregated data or forecast data might be changed without directly manipulating the underlying data, and where there may be several relationships linking the data. The system is able to deal with complex relationships along more than one axis or dimension. A number of iterations are typically used involving both back-solving and nullforward-solvingnull. The subset of cells that needs to be recalculated is identified before steps of back-solving and/or forward-solving using parent/child tables. The scanning of these tables looking for potential dependencies is much simpler and faster than to looking at the actual formulae or functions relating the cells. The step of creating the parent/child tables is carried out in advance of the actual calculation by parsing all the relationships (formulae and functions) and summarising the dependencies between cells in the parent/child tables.

摘要翻译： 本发明解决了处理基于数据仓库或规划数据存储库（PDR）数据的复杂规划计算的需要，其中可以改变一些聚合数据或预测数据而不直接操纵底层数据，以及可能存在几个关联数据的关系 。 该系统能够处理沿着多个轴或维度的复杂关系。 通常使用多次迭代，涉及反求解和“前向解决”，需要重新计算的单元的子集在使用父/子表的反求解和/或前向解析的步骤之前被识别。扫描 这些表寻找潜在的依赖关系比查看与单元格相关的实际公式或功能要简单得多，创建父/子表的步骤是在实际计算之前通过解析所有关系（公式 和函数），并总结父/子表中单元格之间的依赖关系。

公开(公告)号：US20140006443A1

公开(公告)日：2014-01-02

申请号：US14014074

申请日：2013-08-29

申请人： Schlumberger Technology Corporation

发明人： Carlos Santieri De Figueiredo Boneti

IPC分类号： G06F17/30

CPC分类号： G06F17/30592 ,  G06F17/30477 ,  Y10S707/958

摘要： A method for processing requests includes receiving, from a requestor, a first read request to read a portion of a seismic cube. The first read request includes a virtual location of the portion. The method further includes querying a seismic cube index to obtain a mapping parameter and a storage location of a section including the portion of the seismic cube. The mapping parameter maps virtual locations in the seismic cube with data locations in the section. The section is identified using the virtual location of the portion. The method further includes calculating, on a computer processor and using the mapping parameter, a data location in the section corresponding to the virtual location of the portion, and transmitting a second read request to the storage location of the section. The second read request includes the data location. The requestor receives the portion from the storage location.

摘要翻译： 一种处理请求的方法包括从请求者接收第一读取请求以读取地震立方体的一部分。 第一个读取请求包括该部分的虚拟位置。 该方法还包括查询地震多维数据集索引以获得包括地震立方体的部分的区段的映射参数和存储位置。 映射参数将地震多维数据集中的虚拟位置与该段中的数据位置进行映射。 使用部分的虚拟位置识别该部分。 该方法还包括在计算机处理器上并使用映射参数来计算与该部分的虚拟位置对应的部分中的数据位置，以及向该部分的存储位置发送第二读取请求。 第二个读取请求包括数据位置。 请求者从存储位置接收部分。

公开(公告)号：US08219547B2

公开(公告)日：2012-07-10

申请号：US12403501

申请日：2009-03-13

申请人： Celestine Joseph ,  Joyce Behrendt ,  Joshua Chait Caplan

发明人： Celestine Joseph ,  Joyce Behrendt ,  Joshua Chait Caplan

IPC分类号： G06F7/00

CPC分类号： G06F17/30457 ,  G06F17/30592 ,  Y10S707/958

摘要： A large OLAP cube includes data and dimensions not required for a particular query, or for a collection of queries. A response to a query is generated by using the large OLAP cube rather than using an OLAP cube tailored to the query, and rather than querying the relational database directly. The large OLAP cube may be created after identifying a set of frequently sought data and/or filters used in queries to the relational database. Data may be staged by creating a smaller OLAP cube with data extracted from the large OLAP cube. The cubes may then be queried, browsed, and used to prepare reports or generate flat files.

摘要翻译： 大型OLAP多维数据集包含特定查询或查询集合不需要的数据和维度。 通过使用大型OLAP多维数据集而不是使用为查询定制的OLAP多维数据集而生成对查询的响应，而不是直接查询关系数据库。 可以在识别在关系数据库的查询中使用的一组经常寻求的数据和/或过滤器之后创建大型OLAP多维数据集。 可以通过使用从大型OLAP多维数据集中提取的数据创建较小的OLAP多维数据集来分析数据。 然后可以查询，浏览立方体，并用于准备报告或生成平面文件。

公开(公告)号：US08024287B2

公开(公告)日：2011-09-20

申请号：US12163952

申请日：2008-06-27

申请人： Azza Mohamed Nagib Mohamed Shawkat Abdellatif Abouzied ,  Jacob Slonim ,  Michael Joseph McAllister

发明人： Azza Mohamed Nagib Mohamed Shawkat Abdellatif Abouzied ,  Jacob Slonim ,  Michael Joseph McAllister

IPC分类号： G06F7/26 ,  G06F17/30

CPC分类号： G06F17/30516 ,  G06F17/30442 ,  G06F17/30592 ,  Y10S707/958

摘要： A computer readable storage medium comprises executable instructions to generate a stream cube to store data received from multiple data sources. A plurality of multi-dimensional data streams are generated to represent the received data. A materialization strategy is repeatedly determined for the stream cube. The stream cube is materialized according to the materialization strategy to record the multi-dimensional data streams.

摘要翻译： 计算机可读存储介质包括可执行指令以产生流多维数据集以存储从多个数据源接收的数据。 生成多个多维数据流以表示所接收的数据。 重复确定流立方体的物化策略。 流立方体根据物化策略进行物化，以记录多维数据流。

公开(公告)号：US07747564B2

公开(公告)日：2010-06-29

申请号：US11473388

申请日：2006-06-22

申请人： Randy Westman ,  Stewart Winter ,  Andrew Liekucs ,  Todd MacCulloch ,  Murray Reid

发明人： Randy Westman ,  Stewart Winter ,  Andrew Liekucs ,  Todd MacCulloch ,  Murray Reid

IPC分类号： G06F7/00 ,  G06F17/00

CPC分类号： G06Q30/00 ,  G06Q40/06 ,  Y10S707/957 ,  Y10S707/958

摘要： A definition manager independently defines a plurality of dimensional members of a data source. An operation manager receives user input selecting a set of dimensional members of interest and at least one operator to manipulate the selected set of members based on the selected at least one operator. The set of dimensional members of interest comprise a first dimensional member of interest having a given dimension and a given level in a hierarchy of the given dimension and a second dimensional member of interest having a different dimension from the given dimension or a different level in the hierarchy from the given level in the hierarchy. A display manager places the manipulated set of dimensional members in a report so that the manipulated set of dimensional members are displayed adjacently based on the operator to facilitate comparative analysis.

摘要翻译： 定义管理器独立地定义数据源的多个维度成员。 操作管理器接收用户输入，所述用户输入选择一组感兴趣的维度成员和至少一个操作者，以基于所选择的至少一个操作者来操纵所选择的一组成员。 感兴趣的维度成员的集合包括具有给定维度的给定维度和给定维度的层次结构中的给定级别的感兴趣的第一维成员和感兴趣的第二维成员具有与给定维度不同的维度或不同级别 从层次结构中的给定级别开始层次结构。 显示管理器将操纵的维度成员集合放置在报告中，使得基于操作者相邻地显示操纵的维度成员集合以便于比较分析。

公开(公告)号：US07370033B1

公开(公告)日：2008-05-06

申请号：US10146937

申请日：2002-05-17

申请人： Shounak Roychowdhury

发明人： Shounak Roychowdhury

IPC分类号： G06F17/30

CPC分类号： G06F17/30592 ,  G06Q30/02 ,  Y10S707/958 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99936

摘要： Apriori algorithms are popular data mining techniques for extracting association rules from a body of data. The computational complexity of these algorithms is reduced by representing itemset information at cells of a hypercube. The cells encode associations between the items of each transaction. Direct computation of a cell as a lexicographic combination of items accelerates the computation of itemsets, and thereby improves the computational runtime complexity of the apriori algorithm that discovers association rules. Even faster computation is achieved by a user selected cardinality that limits the maximum size of the itemsets.

摘要翻译： Apriori算法是从数据体提取关联规则的流行数据挖掘技术。 通过在超立方体的单元处表示项目集信息来减少这些算法的计算复杂性。 单元格编码每个事务的项目之间的关联。 作为项目的词典组合的单元的直接计算加速了项集的计算，从而改进了发现关联规则的先验算法的计算运行时复杂度。 用户选择的基数可以实现更快的计算，从而限制了项目集的最大大小。

公开(公告)号：US07062479B2

公开(公告)日：2006-06-13

申请号：US10016262

申请日：2001-11-02

申请人： David Walter Edmunds ,  Robert Minns ,  James Wallace Sinclair

发明人： David Walter Edmunds ,  Robert Minns ,  James Wallace Sinclair

IPC分类号： G06F17/30 ,  G06F7/00

CPC分类号： G06F17/246 ,  G06Q10/06 ,  Y10S707/958 ,  Y10S707/99931 ,  Y10S707/99934 ,  Y10S707/99936

摘要： This invention addresses the need for dealing with complex planning calculations based on data warehouse or Planning Data Repository (PDR) data where some aggregated data or forecast data might be changed without directly manipulating the underlying data, and where there may be several relationships linking the data. The system is able to deal with complex relationships along more than one axis or dimension. A number of iterations are typically used involving both back-solving and ‘forward-solving’. The subset of cells that needs to be recalculated is identified before steps of back-solving and/or forward-solving using parent/child tables. The scanning of these tables looking for potential dependencies is much simpler and faster than to looking at the actual formulae or functions relating the cells. The step of creating the parent/child tables is carried out in advance of the actual calculation by parsing all the relationships (formulae and functions) and summarising the dependencies between cells in the parent/child tables.

摘要翻译： 本发明解决了处理基于数据仓库或规划数据存储库（PDR）数据的复杂规划计算的需要，其中可以改变一些聚合数据或预测数据而不直接操纵底层数据，以及可能存在几个关联数据的关系 。 该系统能够处理沿着多个轴或维度的复杂关系。 通常使用多次迭代，包括反求解和“前向解决”。 需要重新计算的单元的子集在使用父/子表的反求解和/或前向解析的步骤之前被识别。 寻找潜在依赖关系的这些表的扫描比查看与单元格相关的实际公式或功能更简单和更快。 通过解析所有关系（公式和函数）并总结父/子表中的单元格之间的依赖关系，在实际计算之前执行创建父/子表的步骤。

公开(公告)号：US20060106560A1

公开(公告)日：2006-05-18

申请号：US11299539

申请日：2005-12-12

申请人： Allan Folting ,  Bo Thiesson ,  David Heckerman ,  David Chickering ,  Eric Vigesaa

发明人： Allan Folting ,  Bo Thiesson ,  David Heckerman ,  David Chickering ,  Eric Vigesaa

IPC分类号： G06F19/00

CPC分类号： G06F17/30592 ,  G06N7/00 ,  Y10S707/957 ,  Y10S707/958 ,  Y10S707/99943

摘要： The present invention leverages curve fitting data techniques to provide automatic detection of data anomalies in a “data tube” from a data perspective, allowing, for example, detection of data anomalies such as on-screen, drill down, and drill across data anomalies in, for example, pivot tables and/or OLAP cubes. It determines if data substantially deviates from a predicted value established by a curve fitting process such as, for example, a piece-wise linear function applied to the data tube. A threshold value can also be employed by the present invention to facilitate in determining a degree of deviation necessary before a data value is considered anomalous. The threshold value can be supplied dynamically and/or statically by a system and/or a user via a user interface. Additionally, the present invention provides an indication to a user of the type and location of a detected anomaly from a top level data perspective.

公开(公告)号：US20050144191A1

公开(公告)日：2005-06-30

申请号：US10975012

申请日：2004-10-28

申请人： Gueorgui Chkodrov ,  Zach Jason ,  Wayne Clark ,  Tolga Yildirim ,  Lucy Chao ,  Andrew Ng

发明人： Gueorgui Chkodrov ,  Zach Jason ,  Wayne Clark ,  Tolga Yildirim ,  Lucy Chao ,  Andrew Ng

IPC分类号： G06F7/00 ,  G06F17/00 ,  G06Q10/06

CPC分类号： G06Q10/06 ,  Y10S707/947 ,  Y10S707/956 ,  Y10S707/958 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99944 ,  Y10S707/99945 ,  Y10S707/99948

摘要： A computer-implemented method is provided for defining interesting portions of a workflow of a business or other type of process. Using a tracking profile editor, a portion of a given workflow is selected and associated with a named process part. Items of payload data to be used in reports are selected from a message schema associated with the given workflow. A profile is generated based on the given workflow and the selected items of payload data. A tracking profile compiler receives the created tracking profile and generates a star schema, a flattened view and OLAP cube based on the tracking profile. An interceptor extracts monitored workflow events and stores event information to a tracking stream, based on the tracking profile. A tracking service extracts information pertaining to the monitored events from the tracking stream and stores the information in the queryable database. The OLAP cube and the flattened view are updated based on the information written to the queryable database.

摘要翻译： 提供了一种计算机实现的方法来定义业务或其他类型的过程的工作流的有趣部分。 使用跟踪配置文件编辑器，选择给定工作流的一部分并将其与指定的进程部分相关联。 报告中要使用的有效负载数据项目是从与给定工作流相关联的消息模式中选择的。 基于给定的工作流程和所选择的有效载荷数据项目生成配置文件。 跟踪配置文件编译器接收创建的跟踪配置文件，并根据跟踪配置文件生成星型模式，扁平化视图和OLAP多维数据集。 拦截器根据跟踪配置文件提取监视的工作流事件并将事件信息存储到跟踪流中。 跟踪服务从跟踪流中提取与被监视事件有关的信息，并将该信息存储在可查询的数据库中。 OLAP多维数据集和扁平化视图根据写入可查询数据库的信息进行更新。