公开(公告)号：US20060265391A1

公开(公告)日：2006-11-23

申请号：US11238643

申请日：2005-09-29

申请人： Nicholas Posner ,  Ramana Idury ,  Richard Henderson ,  Randall Shoup ,  Vijay Kumar ,  Louis Monier ,  Anselm Baird-Smith ,  Thomas Nelson ,  Raghav Gupta ,  Raffi Tutundjian ,  Preston Smalley ,  Alvaro Bolivar

发明人： Nicholas Posner ,  Ramana Idury ,  Richard Henderson ,  Randall Shoup ,  Vijay Kumar ,  Louis Monier ,  Anselm Baird-Smith ,  Thomas Nelson ,  Raghav Gupta ,  Raffi Tutundjian ,  Preston Smalley ,  Alvaro Bolivar

IPC分类号： G06F17/30

CPC分类号： G06F17/30864 ,  G06F17/3064 ,  G06F17/30672 ,  G06F17/30973

摘要： A method and system to process a data search request. The system includes a query controller module to receive the data search request that includes constraints; a reduced constraint builder module to formulate a plurality of search definitions that are formulated to exclude at least one constraint; and a search engine to perform searches of a data source to generate search results and to utilize the search results to calculate counts of data items that respectively correspond to the search definitions. The query controller module communicates the counts of data items and the corresponding search definitions to a client machine. Each of the search definitions is formulated to include a constraint set.

摘要翻译： 一种处理数据搜索请求的方法和系统。 该系统包括用于接收包括约束的数据搜索请求的查询控制器模块; 减少的约束构建器模块，用于制定被配制为排除至少一个约束的多个搜索定义; 以及搜索引擎来执行数据源的搜索以生成搜索结果并利用搜索结果来计算分别对应于搜索定义的数据项的计数。 查询控制器模块将数据项的计数和相应的搜索定义传达给客户机。 每个搜索定义被制定为包括约束集合。

公开(公告)号：US20050262120A1

公开(公告)日：2005-11-24

申请号：US11155402

申请日：2005-06-16

申请人： Randall Shoup ,  James Wolf

发明人： Randall Shoup ,  James Wolf

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

CPC分类号： G06F17/30312 ,  G06F17/30554 ,  G06F17/30592 ,  Y10S707/99933 ,  Y10S707/99943

摘要： A record management system is provided for generating a multi-dimensional view for different measures. A set of records is retrieved in response to a set of queries. The records include dimension values and measure values, which are associated with the measures. The set of records is maintained in a master table. The record management system generates a record structure foundation, including a query map and a master table index. The record management system then employs the record structure foundation to generate a multi-dimensional layout mapping for the measures that are to be represented in the view. The record structure foundation and measure values in the master table are used to convert the layout mapping into the desired multi-dimensional view. The record management system includes data storage units for implementing the master table, query map, master table index, and layout mapping. These data storage units are coupled to a set of processing engines, which include a control engine, query engine, index engine, and layout engine that provide for performing operations that result in the generation of a multi-dimensional view.

摘要翻译： 提供了一种记录管理系统，用于生成用于不同措施的多维视图。 响应于一组查询检索一组记录。 记录包括与度量相关联的维度值和度量值。 记录集保存在主表中。 记录管理系统生成记录结构基础，包括查询映射和主表索引。 记录管理系统然后采用记录结构基础为视图中要表示的措施生成多维布局映射。 主表中的记录结构基础和度量值用于将布局映射转换为所需的多维视图。 记录管理系统包括用于实现主表，查询映射，主表索引和布局映射的数据存储单元。 这些数据存储单元耦合到一组处理引擎，其包括控制引擎，查询引擎，索引引擎和布局引擎，其提供导致生成多维视图的执行操作。

公开(公告)号：US6108657A

公开(公告)日：2000-08-22

申请号：US865574

申请日：1997-05-29

申请人： Randall Shoup ,  James Wolf

发明人： Randall Shoup ,  James Wolf

IPC分类号： G06F17/30

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

摘要： A record management system is provided for generating a multi-dimensional view for different measures. A set of records is retrieved in response to a set of queries. The records include dimension values and measure values, which are associated with the measures. The set of records is maintained in a master table. The record management system generates a record structure foundation, including a query map and a master table index. The record management system then employs the record structure foundation to generate a multi-dimensional layout mapping for the measures that are to be represented in the view. The record structure foundation and measure values in the master table are used to convert the layout mapping into the desired multi-dimensional view. The record management system includes data storage units for implementing the master table, query map, master table index, and layout mapping. These data storage units are coupled to a set of processing engines, which include a control engine, query engine, index engine, and layout engine that provide for performing operations that result in the generation of a multi-dimensional view.

摘要翻译： 提供了一种记录管理系统，用于生成用于不同措施的多维视图。 响应于一组查询检索一组记录。 记录包括与度量相关联的维度值和度量值。 记录集保存在主表中。 记录管理系统生成记录结构基础，包括查询映射和主表索引。 记录管理系统然后采用记录结构基础为视图中要表示的措施生成多维布局映射。 主表中的记录结构基础和度量值用于将布局映射转换为所需的多维视图。 记录管理系统包括用于实现主表，查询映射，主表索引和布局映射的数据存储单元。 这些数据存储单元耦合到一组处理引擎，其包括控制引擎，查询引擎，索引引擎和布局引擎，其提供导致生成多维视图的执行操作。

公开(公告)号：US06735590B1

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

申请号：US09513364

申请日：2000-02-25

申请人： Randall Shoup ,  James Wolf

发明人： Randall Shoup ,  James Wolf

IPC分类号： G06F1730

CPC分类号： G06F17/30312 ,  G06F17/30554 ,  G06F17/30592 ,  Y10S707/99933 ,  Y10S707/99943

摘要： A record management system is provided for generating a multi-dimensional view for different measures. A set of records is retrieved in response to a set of queries. The records include dimension values and measure values, which are associated with the measures. The set of records is maintained in a master table. The record management system generates a record structure foundation, including a query map and a master table index. The record management system then employs the record structure foundation to generate a multi-dimensional layout mapping for the measures that are to be represented in the view. The record structure foundation and measure values in the master table are used to convert the layout mapping into the desired multi-dimensional view. The record management system includes data storage units for implementing the master table, query map, master table index, and layout mapping. These data storage units are coupled to a set of processing engines, which include a control engine, query engine, index engine, and layout engine that provide for performing operations that result in the generation of a multi-dimensional view.

摘要翻译： 提供了一种记录管理系统，用于生成用于不同措施的多维视图。 响应于一组查询检索一组记录。 记录包括与度量相关联的维度值和度量值。 记录集保存在主表中。 记录管理系统生成记录结构基础，包括查询映射和主表索引。 记录管理系统然后采用记录结构基础为视图中要表示的措施生成多维布局映射。 主表中的记录结构基础和度量值用于将布局映射转换为所需的多维视图。 记录管理系统包括用于实现主表，查询映射，主表索引和布局映射的数据存储单元。 这些数据存储单元耦合到一组处理引擎，其包括控制引擎，查询引擎，索引引擎和布局引擎，其提供导致生成多维视图的执行操作。

公开(公告)号：US5970493A

公开(公告)日：1999-10-19

申请号：US865414

申请日：1997-05-29

申请人： Randall Shoup ,  James Wolf

发明人： Randall Shoup ,  James Wolf

IPC分类号： G06F17/30

CPC分类号： G06F17/30592 ,  G06F17/30554 ,  Y10S707/99943

摘要： A record management system is provided for generating a multi-dimensional view for different measures. A set of records is retrieved in response to a set of queries. The records include dimension values and measure values, which are associated with the measures. The set of records is maintained in a master table. The record management system generates a record structure foundation, including a query map and a master table index. The record management system then employs the record structure foundation to generate a multi-dimensional layout mapping for the measures that are to be represented in the view. The record structure foundation and measure values in the master table are used to convert the layout mapping into the desired multi-dimensional view. The record management system includes data storage units for implementing the master table, query map, master table index, and layout mapping. These data storage units are coupled to a set of processing engines, which include a control engine, query engine, index engine, and layout engine that provide for performing operations that result in the generation of a multi-dimensional view.

摘要翻译： 提供了一种记录管理系统，用于生成用于不同措施的多维视图。 响应于一组查询检索一组记录。 记录包括与度量相关联的维度值和度量值。 记录集保存在主表中。 记录管理系统生成记录结构基础，包括查询映射和主表索引。 记录管理系统然后采用记录结构基础为视图中要表示的措施生成多维布局映射。 主表中的记录结构基础和度量值用于将布局映射转换为所需的多维视图。 记录管理系统包括用于实现主表，查询映射，主表索引和布局映射的数据存储单元。 这些数据存储单元耦合到一组处理引擎，其包括控制引擎，查询引擎，索引引擎和布局引擎，其提供导致生成多维视图的执行操作。

公开(公告)号：US07774303B2

公开(公告)日：2010-08-10

申请号：US11155402

申请日：2005-06-16

申请人： Randall Shoup ,  James Wolf

发明人： Randall Shoup ,  James Wolf

IPC分类号： G06F17/30

CPC分类号： G06F17/30312 ,  G06F17/30554 ,  G06F17/30592 ,  Y10S707/99933 ,  Y10S707/99943

摘要： A record management system is provided for generating a multi-dimensional view for different measures. A set of records is retrieved in response to a set of queries. The set of records is maintained in a master table. The record management system generates a record structure foundation, including a query map and a master table index. The record management system then employs the record structure foundation to generate a multi-dimensional layout mapping for the measures that are to be represented in the view. The record structure foundation and measure values in the master table are used to convert the layout mapping into the desired multidimensional view. The record management system includes data storage units. These data storage units are coupled to a set of processing engines, which that provide for performing operations that result in the generation of a multi-dimensional view.

摘要翻译： 提供了一种记录管理系统，用于生成用于不同措施的多维视图。 响应于一组查询检索一组记录。 记录集保存在主表中。 记录管理系统生成记录结构基础，包括查询映射和主表索引。 记录管理系统然后采用记录结构基础为视图中要表示的措施生成多维布局映射。 主表中的记录结构基础和度量值用于将布局映射转换为所需的多维视图。 记录管理系统包括数据存储单元。 这些数据存储单元耦合到一组处理引擎，这些处理引擎提供导致产生多维视图的操作。

公开(公告)号：US06226647B1

公开(公告)日：2001-05-01

申请号：US09122031

申请日：1998-07-24

申请人： Raghuram Venkatasubramanian ,  Jeffrey Douglas ,  Randall Shoup ,  James Wolf

发明人： Raghuram Venkatasubramanian ,  Jeffrey Douglas ,  Randall Shoup ,  James Wolf

IPC分类号： G06F1730

CPC分类号： G06F17/30592 ,  G06F17/30454 ,  G06F17/30489 ,  Y10S707/99933 ,  Y10S707/99943

摘要： A record management system provides for displaying a two-pass value measure result in a multi-dimensional view containing cells. The record management system identifies a set of cells in the multi-dimensional view. The set of cells includes all cells needed for determining the two-pass value measure result. The record management system determines a one-pass value for each cell in the set of cells. Based on the one-pass values, the record management system determines the two-pass value measure result.

摘要翻译： 记录管理系统提供在包含单元格的多维视图中显示二次值测量结果。 记录管理系统识别多维视图中的一组单元格。 这组单元格包括确定双程值测量结果所需的所有单元。 记录管理系统确定单元格集合中每个单元格的一次通过值。 基于一次通过值，记录管理系统确定二次通过值测量结果。

公开(公告)号：US07076502B2

公开(公告)日：2006-07-11

申请号：US10823096

申请日：2004-04-12

申请人： Randall Shoup ,  James Wolf

发明人： Randall Shoup ,  James Wolf

IPC分类号： G06F17/00

CPC分类号： G06F17/30312 ,  G06F17/30554 ,  G06F17/30592 ,  Y10S707/99933 ,  Y10S707/99943

摘要： A record management system is provided for generating a multi-dimensional view for different measures. A set of records is retrieved in response to a set of queries. The records include dimension values and measure values, which are associated with the measures. The set of records is maintained in a master table. The record management system generates a record structure foundation, including a query map and a master table index. The record management system then employs the record structure foundation to generate a multi-dimensional layout mapping for the measures that are to be represented in the view. The record structure foundation and measure values in the master table are used to convert the layout mapping into the desired multi-dimensional view.

摘要翻译： 提供了一种记录管理系统，用于生成用于不同措施的多维视图。 响应于一组查询检索一组记录。 记录包括与度量相关联的维度值和度量值。 记录集保存在主表中。 记录管理系统生成记录结构的基础，包括查询映射和主表索引。 记录管理系统然后采用记录结构基础为视图中要表示的措施生成多维布局映射。 主表中的记录结构基础和度量值用于将布局映射转换为所需的多维视图。

公开(公告)号：US20050010579A1

公开(公告)日：2005-01-13

申请号：US10823096

申请日：2004-04-12

申请人： Randall Shoup ,  James Wolf

发明人： Randall Shoup ,  James Wolf

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

CPC分类号： G06F17/30312 ,  G06F17/30554 ,  G06F17/30592 ,  Y10S707/99933 ,  Y10S707/99943

摘要： A record management system is provided for generating a multi-dimensional view for different measures. A set of records is retrieved in response to a set of queries. The records include dimension values and measure values, which are associated with the measures. The set of records is maintained in a master table. The record management system generates a record structure foundation, including a query map and a master table index. The record management system then employs the record structure foundation to generate a multi-dimensional layout mapping for the measures that are to be represented in the view. The record structure foundation and measure values in the master table are used to convert the layout mapping into the desired multi-dimensional view. The record management system includes data storage units for implementing the master table, query map, master table index, and layout mapping. These data storage units are coupled to a set of processing engines, which include a control engine, query engine, index engine, and layout engine that provide for performing operations that result in the generation of a multi-dimensional view.

摘要翻译： 提供了一种记录管理系统，用于生成用于不同措施的多维视图。 响应于一组查询检索一组记录。 记录包括与度量相关联的维度值和度量值。 记录集保存在主表中。 记录管理系统生成记录结构基础，包括查询映射和主表索引。 记录管理系统然后采用记录结构基础为视图中要表示的措施生成多维布局映射。 主表中的记录结构基础和度量值用于将布局映射转换为所需的多维视图。 记录管理系统包括用于实现主表，查询映射，主表索引和布局映射的数据存储单元。 这些数据存储单元耦合到一组处理引擎，其包括控制引擎，查询引擎，索引引擎和布局引擎，其提供导致生成多维视图的执行操作。

公开(公告)号：US6073134A

公开(公告)日：2000-06-06

申请号：US865560

申请日：1997-05-29

申请人： Randall Shoup ,  James Wolf

发明人： Randall Shoup ,  James Wolf

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

CPC分类号： G06F17/30312 ,  G06F17/30554 ,  G06F17/30592 ,  Y10S707/99933 ,  Y10S707/99943

摘要： A record management system is provided for generating a multi-dimensional view for different measures. A set of records is retrieved in response to a set of queries. The records include dimension values and measure values, which are associated with the measures. The set of records is maintained in a master table. The record management system generates a record structure foundation, including a query map and a master table index. The record management system then employs the record structure foundation to generate a multi-dimensional layout mapping for the measures that are to be represented in the view. The record structure foundation and measure values in the master table are used to convert the layout mapping into the desired multi-dimensional view. The record management system includes data storage units for implementing the master table, query map, master table index, and layout mapping. These data storage units are coupled to a set of processing engines, which include a control engine, query engine, index engine, and layout engine that provide for performing operations that result in the generation of a multi-dimensional view.

摘要翻译： 提供了一种记录管理系统，用于生成用于不同措施的多维视图。 响应于一组查询检索一组记录。 记录包括与度量相关联的维度值和度量值。 记录集保存在主表中。 记录管理系统生成记录结构基础，包括查询映射和主表索引。 记录管理系统然后采用记录结构基础为视图中要表示的措施生成多维布局映射。 主表中的记录结构基础和度量值用于将布局映射转换为所需的多维视图。 记录管理系统包括用于实现主表，查询映射，主表索引和布局映射的数据存储单元。 这些数据存储单元耦合到一组处理引擎，其包括控制引擎，查询引擎，索引引擎和布局引擎，其提供导致生成多维视图的执行操作。