公开(公告)号：US20050144185A1

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

申请号：US10975014

申请日：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.

公开(公告)号：US06778996B2

公开(公告)日：2004-08-17

申请号：US10435428

申请日：2003-05-09

申请人： Raymond Roccaforte

发明人： Raymond Roccaforte

IPC分类号： G06F1730

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.

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

公开(公告)号：US20040059724A1

公开(公告)日：2004-03-25

申请号：US10624726

申请日：2003-07-23

发明人： Cristian Petculescu ,  Amir Netz

IPC分类号： G06F007/00

CPC分类号： G06F17/30592 ,  Y10S707/958 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99945

摘要： Systems, clients, servers, methods, and computer-readable media of varying scope are described in which, two extensions for a multidimensional database query language extensions, AddCalculatedMembers and StripCalculatedMembers, allow an OLAP client to easily control the integration of calculated members into the results of OLAP database queries. The OLAP client need not be aware of the details of which calculated members are defined within the multidimensional database and need not explicitly request the inclusion or removal of each calculate member from the output data set of the query.

摘要翻译： 描述了不同范围的系统，客户端，服务器，方法和计算机可读介质，其中用于多维数据库查询语言扩展，AddCalculatedMembers和StripCalculatedMembers的两个扩展允许OLAP客户端轻松地将计算的成员集成到结果中 的OLAP数据库查询。 OLAP客户端不需要知道在多维数据库中定义哪些计算成员的详细信息，并且不需要明确地请求从查询的输出数据集中包含或删除每个计算成员。

公开(公告)号：US20040015507A1

公开(公告)日：2004-01-22

申请号：US10199913

申请日：2002-07-19

发明人： Amir Netz ,  Cristian Petculescu ,  Mosha Pasumansky ,  Richard R. Tkachuk ,  Alexander Berger ,  Paul J. Sanders

IPC分类号： G06F017/00 ,  G06F007/00

CPC分类号： G06F17/30592 ,  Y10S707/954 ,  Y10S707/957 ,  Y10S707/958 ,  Y10S707/99933 ,  Y10S707/99944

摘要： A system and method for analytically modeling data with related attributes is disclosed. A single dimension is used to provide data according to each of the related attributes, and, thus, may be said to play the role of each related attribute depending on a received query. The measure of the analytical data model is tied to the dimension according to both data attributes to allow the measure to be analyzed by the dimension according to both attributes.

摘要翻译： 公开了一种用于对具有相关属性的数据进行分析建模的系统和方法。 单个维度用于根据每个相关属性提供数据，并且因此可以被称为根据所接收的查询发挥每个相关属性的作用。 分析数据模型的度量根据两个数据属性与维度相关联，以允许根据两个属性通过维度来分析度量。

公开(公告)号：US20030225768A1

公开(公告)日：2003-12-04

申请号：US10161397

申请日：2002-06-03

申请人： Microsoft Corporation

发明人： Surajit Chaudhuri ,  Vivek Narasayya ,  Omer Zaki

IPC分类号： G06F007/00 ,  G06F017/30

CPC分类号： G06F17/30595 ,  Y10S707/958 ,  Y10S707/99932 ,  Y10S707/99942

摘要： A method for providing workload information in a structured workload information data structure format that is organized according to a workload schema to be conducive to a given end usage of the information. The structured workload information can be made accessible using standard database analytical server applications to facilitate ad-hoc querying of the structured workload information to summarize and analyze the database workload or to facilitate exchange of workload information. A structured workload information (SWI) is constructed according to a SWI schema to facilitate a desired end usage of the workload information. The query information is extracted from the workload and stored in a structured workload information (SWI) data structure according to the schema based on the desired end usage of the information such as ad hoc querying or information exchange. The query information may be stored in a relational database having query information organized as a central fact table and a collection of hierarchical dimension tables or as an OLAP cube featuring hierarchical dimensions that arrange the query information in dimensions having objects ordered as a function of granularity or the information may be stored according to an XML schema wherein units of query information are separated by XML tags that identify a type of workload information.

摘要翻译： 一种用于以结构化工作负载信息数据结构格式提供工作负载信息的方法，所述结构化工作负载信息数据结构格式根据工作负载模式被组织以有利于信息的给定最终使用。 结构化工作负载信息可以使用标准数据库分析服务器应用程序进行访问，以便于对结构化工作负载信息进行即席查询，以总结和分析数据库工作负载或促进工作负载信息的交换。 根据SWI模式构建结构化工作负载信息（SWI），以便于工作负载信息的期望的最终使用。 从工作负载中提取查询信息，并根据信息的期望最终使用情况，根据模式，将其存储在结构化工作负载信息（SWI）数据结构中，例如即席查询或信息交换。 查询信息可以存储在具有被组织为中心事实表和分层维度表的集合的查询信息的关系数据库中，或者作为具有分层维度的OLAP多维数据集，OLAP多维数据集将维度中的查询信息排列成具有作为粒度的函数排列的对象，或者 可以根据XML模式存储信息，其中查询信息的单位由标识工作负载信息类型的XML标签分隔。

公开(公告)号：US20030145004A1

公开(公告)日：2003-07-31

申请号：US10057314

申请日：2002-01-25

申请人： deCODE Genetics, ehf

发明人： Agust S. Egilsson ,  Hakon Gudbjartsson

IPC分类号： G06F007/00

CPC分类号： G06F17/30592 ,  G06F21/6245 ,  Y10S707/958 ,  Y10S707/99932 ,  Y10S707/99943

摘要： A system for editing the dimension structure associated with a data cube is revealed. The editing may be used to enforce given criteria on the cube. This includes modifying the cube in order to satisfy regulations requiring researchers to protect information about individuals, such as medical, genealogy and genetics records. The inference control methods disclosed therefore enable safe aggregated datasets to be released to researchers. When combined with information theoretic methods, the invention method of editing the dimension structures may be used to express clearly and discover correlations that exist in the dataset. This mining of the data and editing of the dimension structure allows the user of a simple multidimensional cube viewer to visually verify the patterns discovered.

摘要翻译： 显示用于编辑与数据立方体相关联的维度结构的系统。 可以使用编辑来强制立方体上的给定条件。 这包括修改多维数据集，以满足法规要求研究人员保护个人信息，如医学，家谱和遗传学记录。 因此，所公开的推理控制方法可使安全的汇总数据集被释放给研究人员。 当结合信息理论方法时，可以使用编辑维度结构的发明方法来清楚地表达并发现数据集中存在的相关性。 数据的挖掘和维度结构的编辑允许简单的多维多维数据集查看器的用户可视化地验证发现的模式。

公开(公告)号：US20030055832A1

公开(公告)日：2003-03-20

申请号：US10232581

申请日：2002-08-30

申请人： ORACLE CORPORATION

发明人： Raymond Roccaforte

IPC分类号： G06F007/00

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

摘要： Techniques are provided which address the problems associated with the conventional approaches for storing multidimensional data in a relational database system. According to technique, the many foreign key values of each row in the fact table are mapped to and replaced by a nullreplacementnull value. A mapping function is provided that derives a replacement value from any given combination of foreign key values, and an inverse mapping function is provided to reproduce the combination of foreign key values given the replacement value. A mapping function is selected such that the foreign key value combinations of multidimensional values that are conceptually related to each other map to values that are close to each other. The rows in the fact table are then stored within the fact table in the sorted order, thus causing values that are conceptually related to each other to be stored physically near each other within the fact table. Various techniques are provided for generating the replacement value from the foreign key values by subdividing the multidimensional cube that contains all of the multidimensional values into smaller sub-cubes that are referred to as tiles. Variations on the tiling mechanism are provided. According to one approach, the cube is sub-divided into tiles based on the members of a particular level of a hierarchical dimension. According to another tiling approach, the tiles themselves may be subdivided into smaller tiles to create a hierarchy of tiles.

公开(公告)号：US20020198919A1

公开(公告)日：2002-12-26

申请号：US09881370

申请日：2001-06-14

申请人： INTERNATIONAL BUSINESS MACHINES CORPORATION

发明人： Bhooshan Prafulla Kelkar

IPC分类号： G06F009/00

CPC分类号： G06Q10/04 ,  Y10S707/958 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99935 ,  Y10S707/99943

摘要： There is provided a method for providing a function for use in detecting a presence of an exception in multidimensional data. The method comprises the steps of (a) partitioning the multidimensional data into at least a first region and a second region; (b) assigning a first region-specific function to the first region and a second region-specific function to the second region; and (c) determining a combined function from the first region-specific function and the second region-specific function. The combined function is used to calculate an expected value of the multidimensional data for distinguishing the presence of an exception.

摘要翻译： 提供了一种用于提供用于检测多维数据中的异常的存在的功能的方法。 该方法包括以下步骤：（a）将多维数据划分成至少第一区域和第二区域; （b）将第一区域特定功能分配给所述第一区域，以及向所述第二区域分配第二区域特定功能; 以及（c）根据第一区域特定功能和第二区域特定功能确定组合功能。 组合函数用于计算用于区分异常存在的多维数据的期望值。

公开(公告)号：US09454593B2

公开(公告)日：2016-09-27

申请号：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.

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

公开(公告)号：US08126871B2

公开(公告)日：2012-02-28

申请号：US12264891

申请日：2008-11-04

申请人： William Earl Malloy ,  Ken Qian Pu

发明人： William Earl Malloy ,  Ken Qian Pu

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

CPC分类号： G06F17/30333 ,  Y10S707/957 ,  Y10S707/958 ,  Y10S707/99936 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99945

摘要： Systems and computer program products that identify data that is related to and associated with data that has been selected from a multidimensional database. The overwhelming amount of data in a multidimensional database that may be viewed by a user, such as a data analyst, is reduced to the selected and associated data by use of index data and related index data, according to the present invention. The views of selected data and related data may be highlighted and formatted for presentation to the user. Further, irrelevant data is filtered out and not presented to the user. Existing systems have not been able to efficiently and adequately identify data that is related to and associated with selected data in a multidimensional database.

摘要翻译： 识别与从多维数据库中选择的数据相关并与之相关联的数据的系统和计算机程序产品。 根据本发明，通过使用索引数据和相关索引数据，可以由诸如数据分析者的用户观看的多维数据库中的压倒性数据量被减少到所选择的和相关联的数据。 所选数据和相关数据的视图可以被突出显示和格式化以呈现给用户。 此外，不相关的数据被过滤掉并且不呈现给用户。 现有系统无法有效和充分地识别与多维数据库中的所选数据相关并与之相关联的数据。