使用何种类型的并行处理也会受到查询的执行方式的影响。
The type of parallelism used is also influenced by how the query is processed.
我也可以并行处理每个查询所得结果,在其到达时打印到屏幕。
I can also process the results from each query in parallel, printing them to the screen as they arrive.
DB 2UDBV 5引入了sysplex查询并行,进一步扩展了并行处理。
DB2 UDB V5 extended parallel processing even further by introducing sysplex query parallelism.
CP并行可以在db2子系统中为一条查询使用多个任务,而sysplex查询并行这种方法使一个DB 2数据共享组中的所有成员可以一起处理一个查询。
While query CP parallelism used multi-tasking for a query within a DB2 subsystem, this method enables all the members of a DB2 data-sharing group to process a single query.
此外,通过跨多个数据库分区分散数据以使多个分区可并行处理分配到其上的数据,也能减少复杂的分析查询的响应时间。
Also, the response time of complex analytical queries can be reduced by spreading the data across multiple database partitions, such that all partitions work on their assigned data in parallel.
查询优化和处理是并行数据库管理系统的关键组成部分。
Query optimization and processing is a critical component of parallel database systems.
以此为基础,进一步提出了循环查询的并行处理策略。
Based on this, the parallel processing strategy for cyclic query is proposed.
查询处理器未能为并行查询的执行启动必要的线程资源。
The query processor could not start the necessary thread resources for parallel query execution.
为了提高查询处理器的执行效率,采用启发式规则来搜索最优的多连接表达式并行调度执行计划。
To improve the execution efficiency of the query processors, the authors exploit heuristics to seek the optimum parallel scheduling execution plan for multi-join expressions.
数据分布是数据库查询并行处理的基础,良好的数据分布方法对查询性能有着重要影响。
Data declustering is the foundation of the parallel processing of database query, which has significant effect on query performance.
这些算法和相应的查询优化处理器已用于作者自行设计的并行数据库管理系统原型。
A complete set of a algorithms and techniques are proposed. the algorithms and techniques have been used in a prototype parallel database system designed by the author.
本文利用数据分片和并行处理策略,提出一种采用直接连接的查询优化算法,能有效地缩减查询处理的响应时间。
This paper presents an optimized query algorithm, which adopts direct-join using data partition and parallel processing. It can reduce the response time of query process.
实践证明,这些技术和方法不仅能够快速有效地实现并行数据库管理系统,也能够有效地进行并行数据库查询的优化和处理。
It is shown by the prototype system that the proposed algorithms and techniques are very efficient and effective for query optimization and...
实践证明,这些技术和方法不仅能够快速有效地实现并行数据库管理系统,也能够有效地进行并行数据库查询的优化和处理。
It is shown by the prototype system that the proposed algorithms and techniques are very efficient and effective for query optimization and...
应用推荐