专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

31. 发明授权

US06385604B1 Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements 有权
标题翻译：关系数据库管理系统具有集成数据元素的非关系多维数据存储
公开(公告)号：US06385604B1
公开(公告)日：2002-05-07
申请号：US09634748
申请日：2000-08-09
申请人： Reuven Bakalash , Guy Shaked , Joseph Caspi
发明人： Reuven Bakalash , Guy Shaked , Joseph Caspi
IPC分类号： G06F1730
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] 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）操作或实现改进的信息数据库系统等。

32. 发明授权

US08473450B2 Relational database management system (RDBMS) employing multi-dimensional database (MDDB) for servicing query statements through one or more client machines 有权
标题翻译：使用多维数据库（MDDB）的关系数据库管理系统（RDBMS）用于通过一个或多个客户端机器来处理查询语句
公开(公告)号：US08473450B2
公开(公告)日：2013-06-25
申请号：US12455665
申请日：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 through one or more client machines. The RDBMS comprises a query interface adapted to receive query statements from the client machines. The 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 a multi-dimensional database (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 processing 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.
摘要翻译：关系数据库管理系统（RDBMS），用于通过一个或多个客户端机器来处理查询语句。 RDBMS包括适于从客户机接收查询语句的查询接口。查询处理机制（i）从查询接口接收每个请求，（ii）提取与该请求相关联的一组维度，（iii）使用维度从多维数据库（MDDB）中检索汇总事实数据;以及（iv）将检索到的聚合事实数据转发到查询处理机构用于后续处理。当查询处理机制确定一个或多个查询请求的服务需要存储在关系表中的数据时，查询处理机制自动将请求路由到关系数据表，从而可以从关系表中访问数据并将其转发到用于对请求进行服务的查询处理机制，以对客户端机器透明的方式。

33. 发明授权

US08452804B2 Database management system (DBMS) employing a relational datastore and a multi-dimensional database (MDDB) for servicing query statements in a manner transparent to client machine 有权
标题翻译：数据库管理系统（DBMS）采用关系数据存储和多维数据库（MDDB），以客户端机器透明的方式处理查询语句
公开(公告)号：US08452804B2
公开(公告)日：2013-05-28
申请号：US12590504
申请日：2009-11-09
申请人： Reuven Bakalash , Guy Shaked , Joseph Caspi
发明人： Reuven Bakalash , Guy Shaked , Joseph Caspi
IPC分类号： G06F7/00 , 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 database management system (DBMS) for servicing query statements through one or more client machines. The DBMS comprises a query interface adapted to receive query statements from the client machines. The 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 a multi-dimensional database (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 processing 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.
摘要翻译：数据库管理系统（DBMS），用于通过一个或多个客户端机器来处理查询语句。 DBMS包括适于从客户机接收查询语句的查询界面。查询处理机制（i）从查询接口接收每个请求，（ii）提取与该请求相关联的一组维度，（iii）使用维度从多维数据库（MDDB）中检索汇总事实数据;以及（iv）将检索到的聚合事实数据转发到查询处理机构用于后续处理。当查询处理机制确定一个或多个查询请求的服务需要存储在关系表中的数据时，查询处理机制自动将请求路由到关系数据表，从而可以从关系表中访问数据并将其转发到用于对请求进行服务的查询处理机制，以对客户端机器透明的方式。

34. 发明授权

US08041670B2 Data aggregation module supporting dynamic query responsive aggregation during the servicing of database query requests provided by one or more client machines 有权
标题翻译：在由一个或多个客户机提供的数据库查询请求的服务期间，数据聚合模块支持动态查询响应聚合
公开(公告)号：US08041670B2
公开(公告)日：2011-10-18
申请号：US12657143
申请日：2010-01-14
申请人： Reuven Bakalash , Guy Shaked , Joseph Caspi
发明人： Reuven Bakalash , Guy Shaked , Joseph Caspi
IPC分类号： G06F17/30 , G06F7/00
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. 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中反映的复杂信息状态的进程的实时控制。

35. 发明申请

US20100042645A1 System with a data aggregation module generating aggregated data for responding to OLAP analysis queries in a user transparent manner 有权
标题翻译：具有数据聚合模块的系统以用户透明的方式生成用于响应OLAP分析查询的聚合数据
公开(公告)号：US20100042645A1
公开(公告)日：2010-02-18
申请号：US12589383
申请日：2009-10-22
申请人： Reuven Bakalash , Guy Shaked , Joseph Caspi
发明人： Reuven Bakalash , Guy Shaked , Joseph Caspi
IPC分类号： 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用户。

36. 发明申请

US20090271384A1 Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements 有权
公开(公告)号：US20090271384A1
公开(公告)日：2009-10-29
申请号：US12384093
申请日：2009-03-31
申请人： 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.

37. 发明申请

US20070192295A1 Relational database management system having integrated non-relational multi-dimensional data store or aggregated data elements 审中-公开
标题翻译：具有集成非关系多维数据存储或聚合数据元素的关系数据库管理系统
公开(公告)号：US20070192295A1
公开(公告)日：2007-08-16
申请号：US11473299
申请日：2006-06-22
申请人： Reuven Bakalash , Guy Shaked , Joseph Caspi
发明人： Reuven Bakalash , Guy Shaked , Joseph Caspi
IPC分类号： G06F17/30
CPC分类号： C03B37/02718 , C03B2203/36 , C03B2205/42 , C03B2205/55 , G06F16/283 , 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）操作或实现改进的信息数据库系统等。

38. 发明申请

US20050060325A1 Method of and apparatus for data aggregation utilizing a multidimensional database and multi-stage data aggregation operations 审中-公开
标题翻译：使用多维数据库和多级数据聚合操作的数据聚合方法和装置
公开(公告)号：US20050060325A1
公开(公告)日：2005-03-17
申请号：US10849501
申请日：2004-05-19
申请人： 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 including a scalable multi-dimensional database (MDDB) storing multidimensional data logically organized along N dimensions and a high performance aggregation engine that performs multi-stage data aggregation operations on the multidimensional data. A first stage of such data aggregation operations is performed along a first dimension of the N dimensions; and a second stage of such data aggregation operations is performed for a given slice in the first dimension along another dimension of the N dimensions. Such multi-stage data aggregation operations achieve a significant increase in system performance (e.g. deceased access/search time). The MDDB and high performance aggregation engine 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.
摘要翻译：一种用于聚合数据的改进方法和装置，包括存储沿N维逻辑地组织的多维数据的可缩放多维数据库（MDDB），以及对多维数据执行多级数据聚合操作的高性能聚合引擎。这样的数据聚合操作的第一阶段沿N维的第一维度执行; 并且对于沿着N维的另一维度的第一维度中的给定切片执行这种数据聚合操作的第二阶段。这种多级数据聚合操作实现了系统性能的显着增加（例如，已故接入/搜索时间）。本发明的MDDB和高性能聚合引擎可以集成到支持OLAP系统（一个或多个OLAP服务器和客户端）的独立数据聚合服务器中，或者可以集成到数据库管理系统（DBMS）中，从而实现改进用户灵活性和易用性。本发明的改进的DBMS系统可用于实现改进的数据仓库，用于支持在线分析处理（OLAP）操作或实现改进的信息数据库系统，操作数据库系统等。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式