OPTIMIZATION OF JOIN STRATEGIES IN DISTRIBUTED DATABASES

被引:4
作者
LEGATO, P
PALETTA, G
PALOPOLI, L
机构
[1] UNIV CALABRIA,DIPARTIMENTO ELETTRON INFORMAT & SISTEMIST,I-87036 RENDE,ITALY
[2] UNIV SALERNO,DIPARTIMENTO INFORMAT & APPLICAZ,I-84100 SALERNO,ITALY
关键词
DISTRIBUTED DATABASES; QUERY OPTIMIZATION; DYNAMIC PROGRAMMING;
D O I
10.1016/0306-4379(91)90028-8
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
The paper presents a structured approach to the problem of minimizing the join cost in a relational distributed environment. A tree model is used to present a query and a set of tree equivalence classes for query representation is identified corresponding to the space of all the feasible strategies to execute the query. The optimal strategy is then chosen by a dynamic programming approach which exploits the properties of the tree model, although the computational complexity remains exponential in the size of the problem.
引用
收藏
页码:363 / 374
页数:12
相关论文
共 16 条
[1]  
APERS PMG, 1979, DISTRIBUTED QUERY PR
[2]   QUERY-PROCESSING IN A SYSTEM FOR DISTRIBUTED DATABASES (SDD-1) [J].
BERNSTEIN, PA ;
GOODMAN, N ;
WONG, E ;
REEVE, CL ;
ROTHNIE, JB .
ACM TRANSACTIONS ON DATABASE SYSTEMS, 1981, 6 (04) :602-625
[3]   OPTIMIZING JOINS BETWEEN 2 PARTITIONED RELATIONS IN DISTRIBUTED DATABASES [J].
CERI, S ;
GOTTLOB, G .
JOURNAL OF PARALLEL AND DISTRIBUTED COMPUTING, 1986, 3 (02) :183-205
[4]   TAXONOMY AND FORMAL PROPERTIES OF DISTRIBUTED JOINS [J].
CERI, S ;
GOTTLOB, G ;
PELAGATTI, G .
INFORMATION SYSTEMS, 1986, 11 (01) :25-40
[5]  
Ceri S., 1984, DISTRIBUTED DATABASE
[6]  
CERI S, 1982, IEEE TC C, V31
[7]   OPTIMIZING JOINS IN FRAGMENTED DATABASE-SYSTEMS ON A BROADCAST LOCAL-NETWORK [J].
CHEN, JSJ ;
LI, VOK .
IEEE TRANSACTIONS ON SOFTWARE ENGINEERING, 1989, 15 (01) :26-38
[8]  
Epstein R., 1978, P ACM SIGMOD INT C M, P169
[9]  
GOUDA MG, 1981, P ACM SIGMOD C NEW Y, P164
[10]   QUERY OPTIMIZATION ON LOCAL AREA NETWORKS [J].
HEVNER, AR ;
WU, OQ ;
YAO, SB .
ACM TRANSACTIONS ON OFFICE INFORMATION SYSTEMS, 1985, 3 (01) :35-62