-
公开(公告)号：US07162505B2
公开(公告)日：2007-01-09
申请号：US10393852
申请日：2003-03-21
申请人： Serge Rielau , Roberta J. Cochrane , George Lapis , Hamid Pirahesh , Richard S. Sidle , Biao Zhu
发明人： Serge Rielau , Roberta J. Cochrane , George Lapis , Hamid Pirahesh , Richard S. Sidle , Biao Zhu
CPC分类号： G06F17/30365 , G06F17/30483 , Y10S707/99952 , Y10S707/99955
摘要： A method and system for use in a computing environment for selecting a subset of records from a set of records for placement of the subset of records in a plurality of destinations. A group of replica records is formed for a record of the subset of records, and a destination identification is assigned to each replica record, except one, of the group of replica records. A replica record associated with one of the plurality of destinations can be selected and can be placed in the associated destination.
摘要翻译： 一种在计算环境中使用的方法和系统，用于从一组记录中选择记录的子集，以将记录子集放置在多个目的地中。 为记录子集的记录形成一组副本记录，并且将目的地标识分配给每个副本记录，除复制记录组之外的一个。 可以选择与多个目的地之一相关联的副本记录，并且可以将其放置在相关联的目的地中。
-
公开(公告)号：US07007006B2
公开(公告)日：2006-02-28
申请号：US10177007
申请日：2002-06-21
申请人： Daniel C. Zilio , Gary G. Valentin , Guy M. Lohman , Calisto P. Zuzarte , Roberta J. Cochrane , Hamid Pirahesh , Markos Zaharioudakis , Kit Man Cheung , Kevin S. Beyer , David E. Simmen , Ting Y. Leung , Samuel S. Lightstone
发明人： Daniel C. Zilio , Gary G. Valentin , Guy M. Lohman , Calisto P. Zuzarte , Roberta J. Cochrane , Hamid Pirahesh , Markos Zaharioudakis , Kit Man Cheung , Kevin S. Beyer , David E. Simmen , Ting Y. Leung , Samuel S. Lightstone
IPC分类号： G06F17/30
CPC分类号： G06F17/30312 , Y10S707/99932 , Y10S707/99934 , Y10S707/99935
摘要： The invention herein provides method and apparatus, including software for determining a set of materialized views or indices of the contents or a subset of the contents of a database in a data processing system to be created for one or more users of the database. The method and apparatus provide method and means for evaluating a workload presented by a user to the database; evaluating the data processing system characteristics; evaluating the database characteristics; and, using the above evaluations for recommending a set of suitable materialized views or indices to the user. Another aspect of the invention, which may be used for a workload presented by a user of a database in a data processing system, provides method and apparatus, including software for determining a set of materialized views or indices of the contents or a subset of the contents of the database, by: generating a plurality of materialized view candidates from evaluation of the workload, data processing system characteristics and database characteristics; estimating statistics for the materialized view candidates such as the number of rows, row size, and column statistics; generating a plurality of potential index candidates by evaluating the workload, data processing system characteristics, database characteristics and the materialized view candidates; and, from the materialized view candidates and index candidates selecting a set of suitable materialized views and/or indices for submission to the user.
-
公开(公告)号：US08538985B2
公开(公告)日：2013-09-17
申请号：US12046273
申请日：2008-03-11
IPC分类号： G06F17/30
CPC分类号： G06F17/30545
摘要： Methods and apparatus, including computer program products, implementing and using techniques for processing a federated query in a federated database system. A federated query is received at a federated database server. A federated query execution plan is generated based on the received federated query. The federated query execution plan defines one or more source servers of the federated database and a unique subquery to be executed on each of the source servers. The subqueries are distributed to the source servers in accordance with the federated query execution plan. The respective subqueries are executed asynchronously at the source servers. The subquery results are passed to a first designated source server defined in the federated query execution plan. The subquery results are joined and aggregated at the first designated source server into a final query result. The final query result is returned to the federated database server.
摘要翻译： 方法和装置，包括计算机程序产品，在联合数据库系统中处理联合查询的实现和使用技术。 在联合数据库服务器处接收联合查询。 基于接收的联合查询生成联合查询执行计划。 联合查询执行计划定义联合数据库的一个或多个源服务器和要在每个源服务器上执行的唯一子查询。 根据联合查询执行计划，子查询分发到源服务器。 相应的子查询在源服务器上异步执行。 子查询结果被传递到联合查询执行计划中定义的第一个指定的源服务器。 子查询结果在第一个指定的源服务器上加入并聚合成最终的查询结果。 最终查询结果返回到联合数据库服务器。
-
公开(公告)号：US20090234799A1
公开(公告)日：2009-09-17
申请号：US12046273
申请日：2008-03-11
IPC分类号： G06F17/30
CPC分类号： G06F17/30545
摘要： Methods and apparatus, including computer program products, implementing and using techniques for processing a federated query in a federated database system. A federated query is received at a federated database server. A federated query execution plan is generated based on the received federated query. The federated query execution plan defines one or more source servers of the federated database and a unique subquery to be executed on each of the source servers. The subqueries are distributed to the source servers in accordance with the federated query execution plan. The respective subqueries are executed asynchronously at the source servers. The subquery results are passed to a first designated source server defined in the federated query execution plan. The subquery results are joined and aggregated at the first designated source server into a final query result. The final query result is returned to the federated database server.
摘要翻译： 方法和装置，包括计算机程序产品，在联合数据库系统中处理联合查询的实现和使用技术。 在联合数据库服务器处接收联合查询。 基于接收的联合查询生成联合查询执行计划。 联合查询执行计划定义联合数据库的一个或多个源服务器和要在每个源服务器上执行的唯一子查询。 根据联合查询执行计划，子查询分发到源服务器。 相应的子查询在源服务器上异步执行。 子查询结果被传递到联合查询执行计划中定义的第一个指定的源服务器。 子查询结果在第一个指定的源服务器上加入并聚合成最终的查询结果。 最终查询结果返回到联合数据库服务器。
-
-
-
搜索结果
4 条记录 (耗时 0.024 秒)
