公开(公告)号：US08321373B2

公开(公告)日：2012-11-27

申请号：US12653373

申请日：2009-12-11

申请人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

发明人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

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

CPC分类号： G06F17/30592 ,  G06F17/30457 ,  G06F17/30477 ,  G06F17/30489 ,  G06F17/3061 ,  Y10S707/954 ,  Y10S707/957 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99943

摘要： A method of serving query statements from one or more client machines using a database management system (DBMS) employing a relational data store and a multi-dimensional database (MDDB). A query interface is adapted to receive query statements from the client machines, and generate one or more query requests. A query handling mechanism (i) receives each request from the query interface, (ii) extracts a set of dimensions associated with the request, (iii) uses the dimensions to retrieve aggregated fact data from the MDDB, and (iv) forwards retrieved aggregated fact data to the query processing mechanism for subsequent processing. When the query processing mechanism determines that servicing of one or more query requests require data stored in the relational tables, then the query handling mechanism automatically routes the requests to the relational data tables, so that data can be accessed from the relational tables and forwarded to the query processing mechanism for use in servicing the requests, in a manner transparent to the client machine.

摘要翻译： 使用使用关系数据存储和多维数据库（MDDB）的数据库管理系统（DBMS）从一个或多个客户机提供查询语句的方法。 查询界面适用于从客户机接收查询语句，并生成一个或多个查询请求。 查询处理机制（i）从查询接口接收每个请求，（ii）提取与请求相关联的一组维度，（iii）使用维度从MDDB中检索汇总事实数据，以及（iv）转发检索的汇总 事实数据到查询处理机制进行后续处理。 当查询处理机制确定对一个或多个查询请求的服务需要存储在关系表中的数据时，查询处理机制自动将请求路由到关系数据表，从而可以从关系表中访问数据并将其转发到 用于对请求进行服务的查询处理机制，以对客户端机器透明的方式。

公开(公告)号：US08195602B2

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

申请号：US12455664

申请日：2009-06-04

申请人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

发明人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

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

CPC分类号： G06F17/30592 ,  G06F17/30457 ,  G06F17/30477 ,  G06F17/30489 ,  G06F17/3061 ,  Y10S707/954 ,  Y10S707/957 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99943

摘要： A relational database management system (RDBMS) for servicing query statements from one or more client machines, using a relational data store and a multi-dimensional database (MDDB). The RDBMS includes a query interface which is adapted to receive query statements from the client machines, and to generate one or more query requests. The RDBMS includes a query handling mechanism which receives each request from the query interface, extracts a set of dimensions associated with the request, uses the dimensions to retrieve aggregated fact data from the MDDB, and forwards retrieved aggregated fact data to the query processing mechanism for subsequent processing. When the query processing mechanism of the RDBMS determines that servicing one or more query requests requires data stored in the relational tables, then the query handling mechanism automatically routes the requests to the relational data tables, so that data can be accessed from the relational tables and forwarded to the query processing mechanism for use in servicing the requests, in a manner transparent to the client machine. When the query processing mechanism determines that servicing one or more query requests requires aggregated data from the MDDB, then the query handling mechanism automatically routes the requests to the MDDB, so that data can be accessed from the MDDB and forwarded to the query processing mechanism for use in servicing the requests, in a manner transparent to the client machine.

摘要翻译： 用于使用关系数据存储和多维数据库（MDDB）从一个或多个客户端机器处理查询语句的关系数据库管理系统（RDBMS）。 RDBMS包括一个查询接口，适用于从客户机接收查询语句，并生成一个或多个查询请求。 RDBMS包括查询处理机制，从查询接口接收每个请求，提取与请求相关联的维度集合，使用维度从MDDB检索汇总事实数据，并将检索到的汇总事实数据转发到查询处理机制 后续处理。 当RDBMS的查询处理机制确定服务一个或多个查询请求需要存储在关系表中的数据时，查询处理机制自动将请求路由到关系数据表，从而可以从关系表访问数据， 以对客户端机器透明的方式转发到用于服务请求的查询处理机制。 当查询处理机制确定服务一个或多个查询请求需要来自MDDB的聚合数据时，查询处理机制自动将请求路由到MDDB，从而可以从MDDB访问数据并将其转发到查询处理机制 用于以对客户端机器透明的方式来处理请求。

公开(公告)号：US20120089564A1

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

申请号：US13289954

申请日：2011-11-04

申请人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

发明人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

IPC分类号： G06F17/30

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

摘要： Improved method of and apparatus for aggregating data elements in multidimensional databases (MDDB). In the preferred embodiment, the apparatus is realized in the form of a high-performance stand-alone (i.e. external) aggregation server which can be plugged-into conventional MOLAP systems to achieve significant improvements in system performance. In accordance with the principles of the present invention, the stand-alone aggregation server contains a scalable MDDB and a high-performance aggregation engine that are integrated into the modular architecture of the aggregation server. The stand-alone aggregation server of the present invention can uniformly distribute data elements among a plurality of processors, for balanced loading and processing, and therefore is highly scalable.

公开(公告)号：US20100100558A1

公开(公告)日：2010-04-22

申请号：US12653373

申请日：2009-12-11

申请人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

发明人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

IPC分类号： G06F17/30

CPC分类号： G06F17/30592 ,  G06F17/30457 ,  G06F17/30477 ,  G06F17/30489 ,  G06F17/3061 ,  Y10S707/954 ,  Y10S707/957 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99943

摘要： A method of serving query statements from one or more client machines using a database management system (DBMS) employing a relational data store and a multi-dimensional database (MDDB). A query interface is adapted to receive query statements from the client machines, and generate one or more query requests. A query handling mechanism (i) receives each request from the query interface, (ii) extracts a set of dimensions associated with the request, (iii) uses the dimensions to retrieve aggregated fact data from the MDDB, and (iv) forwards retrieved aggregated fact data to the query processing mechanism for subsequent processing. When the query processing mechanism determines that servicing of one or more query requests require data stored in the relational tables, then the query handling mechanism automatically routes the requests to the relational data tables, so that data can be accessed from the relational tables and forwarded to the query processing mechanism for use in servicing the requests, in a manner transparent to the client machine.

摘要翻译： 使用使用关系数据存储和多维数据库（MDDB）的数据库管理系统（DBMS）从一个或多个客户机提供查询语句的方法。 查询界面适用于从客户机接收查询语句，并生成一个或多个查询请求。 查询处理机制（i）从查询接口接收每个请求，（ii）提取与请求相关联的一组维度，（iii）使用维度从MDDB中检索汇总事实数据，以及（iv）转发检索的汇总 事实数据到查询处理机制进行后续处理。 当查询处理机制确定对一个或多个查询请求的服务需要存储在关系表中的数据时，查询处理机制自动将请求路由到关系数据表，从而可以从关系表中访问数据并将其转发到 用于对请求进行服务的查询处理机制，以对客户端机器透明的方式。

公开(公告)号：US20090271379A1

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

申请号：US12455664

申请日：2009-06-04

申请人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

发明人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

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

CPC分类号： G06F17/30592 ,  G06F17/30457 ,  G06F17/30477 ,  G06F17/30489 ,  G06F17/3061 ,  Y10S707/954 ,  Y10S707/957 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99943

摘要： A relational database management system (RDBMS) for servicing query statements from one or more client machines, using a relational data store and a multi-dimensional database (MDDB). The RDBMS includes a query interface which is adapted to receive query statements from the client machines, and to generate one or more query requests. The RDBMS includes a query handling mechanism which receives each request from the query interface, extracts a set of dimensions associated with the request, uses the dimensions to retrieve aggregated fact data from the MDDB, and forwards retrieved aggregated fact data to the query processing mechanism for subsequent processing. When the query processing mechanism of the RDBMS determines that servicing one or more query requests requires data stored in the relational tables, then the query handling mechanism automatically routes the requests to the relational data tables, so that data can be accessed from the relational tables and forwarded to the query processing mechanism for use in servicing the requests, in a manner transparent to the client machine. When the query processing mechanism determines that servicing one or more query requests requires aggregated data from the MDDB, then the query handling mechanism automatically routes the requests to the MDDB, so that data can be accessed from the MDDB and forwarded to the query processing mechanism for use in servicing the requests, in a manner transparent to the client machine.

摘要翻译： 用于使用关系数据存储和多维数据库（MDDB）从一个或多个客户端机器处理查询语句的关系数据库管理系统（RDBMS）。 RDBMS包括一个查询接口，适用于从客户机接收查询语句，并生成一个或多个查询请求。 RDBMS包括查询处理机制，从查询接口接收每个请求，提取与请求相关联的维度集合，使用维度从MDDB检索汇总事实数据，并将检索到的汇总事实数据转发到查询处理机制 后续处理。 当RDBMS的查询处理机制确定服务一个或多个查询请求需要存储在关系表中的数据时，查询处理机制自动将请求路由到关系数据表，从而可以从关系表访问数据， 以对客户端机器透明的方式转发到用于服务请求的查询处理机制。 当查询处理机制确定服务一个或多个查询请求需要来自MDDB的聚合数据时，查询处理机制自动将请求路由到MDDB，从而可以从MDDB访问数据并将其转发到查询处理机制 用于以对客户端机器透明的方式来处理请求。

公开(公告)号：US07392248B2

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

申请号：US10314868

申请日：2002-12-09

申请人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

发明人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

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

CPC分类号： G06F17/30592 ,  C03B37/02718 ,  C03B2203/36 ,  C03B2205/42 ,  C03B2205/55 ,  Y10S707/99933 ,  Y10S707/99935 ,  Y10S707/99943

摘要： Improved method of and apparatus for joining and aggregating data elements integrated within a relational database management system (RDBMS) using a non-relational multi-dimensional data structure (MDD). The improved RDBMS system of the present invention can be used to realize achieving a significant increase in system performance (e.g. deceased access/search time), user flexibility and ease of use. The improved RDBMS system of the present invention can be used to realize an improved Data Warehouse for supporting on-line analytical processing (OLAP) operations or to realize an improved informational database system or the like.

摘要翻译： 改进了使用非关系多维数据结构（MDD）连接和聚合集成在关系数据库管理系统（RDBMS）内的数据元素的方法和装置。 本发明的改进的RDBMS系统可以用于实现系统性能的显着增加（例如，死亡访问/搜索时间），用户灵活性和易用性。 本发明的改进的RDBMS系统可用于实现改进的数据仓库，用于支持在线分析处理（OLAP）操作或实现改进的信息数据库系统等。

公开(公告)号：US20050076067A1

公开(公告)日：2005-04-07

申请号：US10842648

申请日：2004-05-10

申请人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

发明人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

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

CPC分类号： G06F16/2455 ,  G06F16/24539 ,  G06F16/24556 ,  G06F16/283 ,  G06F16/30 ,  Y10S707/954 ,  Y10S707/957 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99943

摘要： An improved method of and apparatus for aggregating data having at least one dimension logically organized into multiple hierarchies of items, whereby such multiple hierarchies of items are transformed into a single hierarchy that is functionally equivalent to the multiple hierarchies. In the hierarchy transformation process, a given child item is linked with a parent item in the single hierarchy when no other child item linked to the parent item has a child item in common with the given child item. In the event that at least one other child item linked to the parent item has a child item in common with the given child item, the given child item is not linked with the parent item in the single hierarchy. The improved data aggregation mechanism of the present invention achieves a significant increase in system performance (e.g. deceased access/search time). Moreover, the improved data aggregation mechanism of the present invention may be integrated into a standalone data aggregation server supporting an OLAP system (one or more OLAP servers and clients), or may be integrated into a database management system (DBMS), thus achieving improved user flexibility and ease of use. The improved DBMS system of the present invention can be used to realize an improved Data Warehouse for supporting on-line analytical processing (OLAP) operations or to realize an improved informational database system, operational database system, or the like.

摘要翻译： 一种用于聚合具有逻辑上被组织成多个物品层次的至少一个维度的数据的改进方法和装置，由此这些物品的多个层级被转换成功能上等同于多个层级的单个层级。 在层次转换过程中，当没有链接到父项目的其他子项目具有与给定子项目相同的子项目时，给定的子项目与单个层次结构中的父项目链接。 如果链接到父项目的至少一个其他子项目具有与给定子项目相同的子项目，则给定子项目不与单个层次结构中的父项目链接。 本发明的改进的数据聚合机制实现了系统性能的显着增加（例如，死亡访问/搜索时间）。 此外，本发明的改进的数据聚合机制可以集成到支持OLAP系统（一个或多个OLAP服务器和客户机）的独立数据聚合服务器中，或者可以被集成到数据库管理系统（DBMS）中，从而实现改进 用户灵活性和易用性。 本发明的改进的DBMS系统可用于实现改进的数据仓库，用于支持在线分析处理（OLAP）操作或实现改进的信息数据库系统，操作数据库系统等。

公开(公告)号：US08463736B2

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

申请号：US12384093

申请日：2009-03-31

申请人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

发明人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

IPC分类号： G06F17/30

CPC分类号： G06F17/30592 ,  C03B37/02718 ,  C03B2203/36 ,  C03B2205/42 ,  C03B2205/55 ,  Y10S707/99933 ,  Y10S707/99935 ,  Y10S707/99943

摘要： Improved method of and apparatus for joining and aggregating data elements integrated within a relational database management system (RDBMS) using a non-relational multi-dimensional data structure (MDD). The improved RDBMS system of the present invention can be used to realize achieving a significant increase in system performance (e.g. decreased access/search time), user flexibility and ease of use. The improved RDBMS system of the present invention can be used to realize an improved Data Warehouse for supporting on-line analytical processing (OLAP) operations or to realize an improved informational database system or the like.

摘要翻译： 改进了使用非关系多维数据结构（MDD）连接和聚合集成在关系数据库管理系统（RDBMS）内的数据元素的方法和装置。 本发明的改进的RDBMS系统可以用于实现系统性能的显着增加（例如减少访问/搜索时间），用户灵活性和易用性。 本发明的改进的RDBMS系统可用于实现改进的数据仓库，用于支持在线分析处理（OLAP）操作或实现改进的信息数据库系统等。

公开(公告)号：US08170984B2

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

申请号：US12589383

申请日：2009-10-22

申请人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

发明人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

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

CPC分类号： G06F17/30592 ,  G06F17/30457 ,  G06F17/30477 ,  G06F17/30489 ,  G06F17/3061 ,  Y10S707/954 ,  Y10S707/957 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99943

摘要： A system for supporting OLAP analysis over a network. The system comprises an OLAP server for enabling an OLAP user to perform OLAP analysis via interaction with a client machine on the network. The system also includes a data aggregation module comprising a multi-dimensional datastore, an aggregation engine integrated with the multi-dimensional datastore, and a first interface for loading base data from a data source to the aggregation engine. The aggregation engine performs data aggregation operations on loaded base data, generates aggregated data from the base data, and stores the aggregated data in the multi-dimensional datastore. A second interface receives requests for OLAP analysis from the OLAP server, accesses the aggregation engine to retrieve from the multi-dimensional datastore, aggregated data corresponding to requests, and communicates the retrieved aggregated data to the OLAP server for query servicing, in a manner transparent to the OLAP user.

摘要翻译： 用于通过网络支持OLAP分析的系统。 该系统包括OLAP服务器，用于使OLAP用户能够通过与网络上的客户机进行交互来执行OLAP分析。 该系统还包括数据聚合模块，其包括多维数据存储，与多维数据存储区集成的聚合引擎，以及用于将基本数据从数据源加载到聚合引擎的​​第一接口。 聚合引擎对加载的基本数据执行数据聚合操作，从基础数据生成聚合数据，并将聚合数据存储在多维数据存储中。 第二个接口从OLAP服务器接收对OLAP分析的请求，访问聚合引擎以从多维数据存储区检索与请求相对应的聚合数据，并将检索到的聚合数据传送到OLAP服务器进行查询服务，方式透明 到OLAP用户。

公开(公告)号：US20100185581A1

公开(公告)日：2010-07-22

申请号：US12657143

申请日：2010-01-14

申请人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

发明人： Reuven Bakalash ,  Guy Shaked ,  Joseph Caspi

IPC分类号： G06F17/30

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

摘要： Improved method of and apparatus for aggregating data elements in multidimensional databases (MDDB). In the preferred embodiment, the apparatus is realized in the form of a high-performance stand-alone (i.e. external) aggregation server which can be plugged-into conventional MOLAP systems to achieve significant improments in system performance. In accordance with the principles of the present invention, the stand-alone aggregation server contains a scalable MDDB and a high-performance aggregation engine that are integrated into the modular architecture of the aggregation server. The stand-alone aggregation server of the present invention can uniformly distribute data elements among a plurality of processors, for balanced loading and processing, and therefore is highly scalable. The stand-alone aggregation server of the present invention can be used to realize (i) an improved MDDB for supporting on-line analytical processing (OLAP) operations, (ii) an improved Internet URL Directory for supporting on-line information searching operations by Web-enabled client machines, as well as (iii) diverse types of MDDB-based systems for supporting real-time control of processes in response to complex states of information reflected in the MDDB.

摘要翻译： 改进了多维数据库（MDDB）中数据元素聚合的方法和设备。 在优选实施例中，该装置以高性能独立（即外部）聚合服务器的形式实现，该服务器可插入常规MOLAP系统以实现系统性能的显着改进。 根据本发明的原理，独立聚合服务器包含集成到聚合服务器的模块化架构中的可扩展MDDB和高性能聚合引擎。 本发明的独立聚合服务器可以在多个处理器之间均匀分布数据元素，用于平衡加载和处理，因此具有高度可扩展性。 本发明的独立聚合服务器可以用于实现（i）用于支持在线分析处理（OLAP）操作的改进的MDDB，（ii）用于支持在线信息搜索操作的改进的因特网URL目录 支持Web的客户端机器，以及（iii）各种类型的基于MDDB的系统，用于支持响应MDDB中反映的复杂信息状态的进程的实时控制。