DocumentCode :
2873063
Title :
Efficient processing of distributed set queries
Author :
El-Sharkawi, Mohamed E. ; Kambayashi, Yahiko
Author_Institution :
Dept. of Comput. Sci. & Commun. Eng., Kyushu Univ., Hakozaki, Japan
fYear :
1990
fDate :
7-9 Mar 1990
Firstpage :
6
Lastpage :
13
Abstract :
The problem of efficiently processing queries that manipulate sets is considered with the objective of minimizing the processing cost by reducing the size of transmitted data as much as possible. The semantics of set operations is used to achieve this goal. A set query has the general form SET 1 op SET 2. For two sets to be related by a set operation, their sizes should satisfy a necessary condition. For the two sets to be equal, they should have the same size. For SET 1 to be a subset of SET 2, its size should be less than or equal to the size of SET 2. In the relational model, given two attributes, the size of a set of values from one attribute that is associated with a value from the other attribute can be determined using functional dependency between the two attributes. Using these semantics, a distributed set query can be converted into a distributed nonset query. When the two sets are of size greater than one, however, the query cannot be converted into a nonset query. It is converted into another distributed set query. The size of data transmitted to answer the new query is reduced as much as possible. This is done by sending sets that satisfy the necessary condition of the set operation
Keywords :
distributed databases; relational databases; SET 1 op SET 2; attributes; distributed nonset query; distributed set queries; efficient query processing; functional dependency; necessary condition; processing cost; relational model; semantics; set manipulation; set operation; set operations; size reduction; transmitted data; Cost function; Data communication; Distributed databases; Query processing;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Databases, Parallel Architectures and Their Applications,. PARBASE-90, International Conference on
Conference_Location :
Miami Beach, FL
Print_ISBN :
0-8186-2035-8
Type :
conf
DOI :
10.1109/PARBSE.1990.77111
Filename :
77111
Link To Document :
بازگشت