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

1. 发明授权

US08788453B2 Data aggregation module supporting dynamic query responsive aggregation during the servicing of database query requests provided by one or more client machines 有权
公开(公告)号：US08788453B2
公开(公告)日：2014-07-22
申请号：US13275242
申请日：2011-10-17
申请人： Reuven Bakalash , Guy Shaked , Joseph Caspi
发明人： Reuven Bakalash , Guy Shaked , Joseph Caspi
IPC分类号： G06F7/00 , G06F17/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.

2. 发明申请

US20120089563A1 DATA AGGREGATION MODULE SUPPORTING DYNAMIC QUERY RESPONSIVE AGGREGATION DURING THE SERVICING OF DATABASE QUERY REQUESTS PROVIDED BY ONE OR MORE CLIENT MACHINES 有权
标题翻译：数据聚合模块在数据库服务期间支持动态查询响应查询由一个或多个客户机提供的查询请求
公开(公告)号：US20120089563A1
公开(公告)日：2012-04-12
申请号：US13275242
申请日：2011-10-17
申请人： 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.
摘要翻译：改进了多维数据库（MDDB）中数据元素聚合的方法和设备。在优选实施例中，该装置以高性能独立（即外部）聚合服务器的形式实现，该服务器可插入常规MOLAP系统中以实现系统性能的显着改进。根据本发明的原理，独立聚合服务器包含集成到聚合服务器的模块化架构中的可扩展MDDB和高性能聚合引擎。本发明的独立聚合服务器可以在多个处理器之间均匀分布数据元素，用于平衡加载和处理，因此具有高度可扩展性。

3. 发明申请

US20090327217A1 METHOD AND SYSTEM FOR CREATION AND DYNAMIC UPDATING OF BEST DATA ARRANGEMENT IN DIGITAL DATA STORE SYSTEM 有权
标题翻译：用于数字数据存储系统中最佳数据安排的创建和动态更新的方法和系统
公开(公告)号：US20090327217A1
公开(公告)日：2009-12-31
申请号：US12490981
申请日：2009-06-24
申请人： Yossi Matias , Guy Shaked , Vladimir Braverman , Victor Belyaev , Shahar Golan , Marina Sadetsky
发明人： Yossi Matias , Guy Shaked , Vladimir Braverman , Victor Belyaev , Shahar Golan , Marina Sadetsky
IPC分类号： G06F17/30
CPC分类号： G06F17/30424
摘要： The current invention is a method and a system for analyzing templates of queries, with different levels of precision. When the system of the current invention takes a decision to arrange data, these templates are used, and a single data arrangement object (HRBlob) is designed which may serve a single template or several templates and not just a single query. This approach has an important impact on data arrangement performance and on queries performance, since this approach may help many more queries to be handled using less data arrangement objects.
摘要翻译：本发明是用于分析不同级别精度的查询模板的方法和系统。当本发明的系统决定排列数据时，使用这些模板，并且设计单个数据排列对象（HRBlob），其可以提供单个模板或多个模板，而不仅仅是单个查询。这种方法对数据排列性能和查询性能有重要的影响，因为这种方法可以帮助使用较少的数据排列对象来处理更多的查询。

4. 发明申请

US20080021864A1 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），以客户端机器透明的方式处理查询语句
公开(公告)号：US20080021864A1
公开(公告)日：2008-01-24
申请号：US11888904
申请日：2007-08-02
申请人： Reuven Bakalash , Guy Shaked , Joseph Caspi
发明人： Reuven Bakalash , Guy Shaked , Joseph Caspi
IPC分类号： 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
摘要： 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）将检索到的聚合事实数据转发到查询处理机构用于后续处理。当查询处理机制确定一个或多个查询请求的服务需要存储在关系表中的数据时，查询处理机制自动将请求路由到关系数据表，从而可以从关系表中访问数据并将其转发到用于对请求进行服务的查询处理机制，以对客户端机器透明的方式。

5. 发明申请

US20080016043A1 Relational database management system (RDBMS) employing multi-dimensional database (MDDB) for servicing query statements through one or more client machines 审中-公开
标题翻译：使用多维数据库（MDDB）的关系数据库管理系统（RDBMS）用于通过一个或多个客户端机器来处理查询语句
公开(公告)号：US20080016043A1
公开(公告)日：2008-01-17
申请号：US11825644
申请日：2007-07-06
申请人： Reuven Bakalash , Guy Shaked , Joseph Caspi
发明人： Reuven Bakalash , Guy Shaked , Joseph Caspi
IPC分类号： G06F7/06 , G06F17/30
CPC分类号： G06F16/2455 , G06F16/24539 , G06F16/24556 , G06F16/283 , G06F16/30 , 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）将检索到的聚合事实数据转发到查询处理机构用于后续处理。当查询处理机制确定一个或多个查询请求的服务需要存储在关系表中的数据时，查询处理机制自动将请求路由到关系数据表，从而可以从关系表中访问数据并将其转发到用于对请求进行服务的查询处理机制，以对客户端机器透明的方式。

6. 发明授权

US07315849B2 Enterprise-wide data-warehouse with integrated data aggregation engine 有权
标题翻译：具有集成数据聚合引擎的企业级数据仓库
公开(公告)号：US07315849B2
公开(公告)日：2008-01-01
申请号：US10314884
申请日：2002-12-09
申请人： 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
摘要： An enterprise-wide data-warehouse comprising a database management system (DBMS) including a relational datastore storing data in tables. An aggregation module, operatively coupled to the relational datastore aggregates the data stored in the tables of the relational datastore and storing the resultant aggregated data in a non-relational datastore. A reference generating mechanism generates a first reference to data stored in the relational datastore, and a second reference to aggregated data generated by the aggregation module and stored in the non-relational datastore. A query processing mechanism processes query statements, wherein, upon identifying that a given query statement is on the second reference, the query processing mechanism communicates with the aggregation module to retrieve portions of aggregated data identified by the reference that are relevant to the given query statement.
摘要翻译：企业范围的数据仓库包括数据库管理系统（DBMS），其包括在表中存储数据的关系数据存储区。可操作地耦合到关系数据存储区的聚合模块聚合存储在关系数据存储区的表中的数据，并将生成的聚合数据存储在非关系数据存储区中。参考生成机构生成对存储在关系数据存储中的数据的第一参考，以及由聚合模块生成并存储在非关系数据存储中的聚合数据的第二参考。查询处理机构处理查询语句，其中，在识别出给定查询语句位于第二参考时，查询处理机构与聚合模块进行通信，以检索由引用标识的与给定查询语句相关的聚合数据的部分。

7. 发明申请

US20050065940A1 Data aggregation server for managing a multi-dimensional database and database management system having data aggregation server integrated therein 审中-公开
标题翻译：用于管理多维数据库的数据聚合服务器和其中集成有数据聚合服务器的数据库管理系统
公开(公告)号：US20050065940A1
公开(公告)日：2005-03-24
申请号：US10832104
申请日：2004-04-26
申请人： Reuven Bakalash , Guy Shaked , Joseph Caspi
发明人： Reuven Bakalash , Guy Shaked , Joseph Caspi
IPC分类号： G06F17/30
CPC分类号： G06F16/2455 , G06F16/24539 , G06F16/24556 , G06F16/283 , G06F16/30 , Y10S707/954 , Y10S707/957 , Y10S707/99932 , Y10S707/99934 , Y10S707/99935 , Y10S707/99943
摘要： Improved method of and apparatus for aggregating data elements in multidimensional databases (MDDB). In one aspect of the present invention, the apparatus is realized in the form of a high-performance stand-alone (i.e. external) aggregation server which can be plugged-into conventional OLAP 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. In another aspect of the present invention, the apparatus is integrated within a database management system (DBMS). The improved DBMS 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 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.
摘要翻译：改进了多维数据库（MDDB）中数据元素聚合的方法和设备。在本发明的一个方面，该装置以高性能独立（即外部）聚合服务器的形式实现，该服务器可插入常规的OLAP系统中，以实现系统性能的显着改进。根据本发明的原理，独立聚合服务器包含集成到聚合服务器的模块化架构中的可扩展MDDB和高性能聚合引擎。本发明的独立聚合服务器可以在多个处理器之间均匀分布数据元素，用于平衡加载和处理，因此具有高度可扩展性。本发明的独立聚合服务器可以用于实现（i）用于支持在线分析处理（OLAP）操作的改进的MDDB，（ii）用于支持在线信息搜索操作的改进的因特网URL目录，支持Web的客户端机器，以及（iii）各种类型的基于MDDB的系统，用于支持响应MDDB中反映的复杂信息状态的进程的实时控制。在本发明的另一方面，该装置集成在数据库管理系统（DBMS）内。可以使用改进的DBMS来实现系统性能的显着增加（例如，死亡访问/搜索时间），用户灵活性和易用性。本发明的改进的DBMS系统可用于实现改进的数据仓库，用于支持在线分析处理（OLAP）操作或实现改进的信息数据库系统，操作数据库系统等。

8. 发明授权

US09047349B2 Methods for effective processing of time series 有权
标题翻译：时间序列有效处理方法
公开(公告)号：US09047349B2
公开(公告)日：2015-06-02
申请号：US12753388
申请日：2010-04-02
申请人： Guy Shaked , Vladimir Braverman , Victor Belyaev , Gabby Rubin , Marina Sadetsky
发明人： Guy Shaked , Vladimir Braverman , Victor Belyaev , Gabby Rubin , Marina Sadetsky
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30551 , G06F17/30595 , G06F17/30598 , G06F17/30864
摘要： A method of effectively representing and processing data sets with time series is disclosed. The method may comprise representing time series as a virtual part of data in a data store layer of a user system, thereby allowing processing of time-series related queries in said data store layer of said user system.
摘要翻译：公开了一种以时间序列有效地表示和处理数据集的方法。该方法可以包括将时间序列表示为用户系统的数据存储层中的数据的虚拟部分，从而允许在所述用户系统的所述数据存储层中处理时间序列相关查询。

9. 发明授权

US08463736B2 Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements 有权
标题翻译：关系数据库管理系统具有集成数据元素的非关系多维数据存储
公开(公告)号：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）操作或实现改进的信息数据库系统等。

10. 发明授权

US08170984B2 System with a data aggregation module generating aggregated data for responding to OLAP analysis queries in a user transparent manner 有权
标题翻译：具有数据聚合模块的系统以用户透明的方式生成用于响应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用户。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式