In Section 16.3.2 we pointed out that in a multidatabase system, data could not be communicated directly from one database site to another and that even indirect communication was difficult since a query site cannot send data to a database site. However, the following “end run” might be considered for computing a semi-join. The query site, A, executes a SELECT statement at the first database site, B, which returns the projection, P, used in computing the semi-join. Site A then uses the projection to dynamically construct another SELECT statement whose result set is the semi-join. Using Example 16.3.1 on page 699 of Section 16.3.1 involving tables Student and Transcript, give the two queries. Under what circumstances could such an approach be considered?
What will be an ideal response?
The projection of Transcript is returned by query
SELECT T.StudId
FROM Transcript, T
If the result of this query is the set of values a, b, ... z, then the following query
submitted by A to C returns the semi-join
SELECT S.Id, S.Major
FROM Student, S
WHERE S.Id = ’a’ OR S.Id = ’b’ OR ... OR S.Id = ’z’
Such an approach would only make sense if the first query produced a very small result set.
You might also like to view...
To obtain the ENCE certification a candidate must accomplish which two of the following tasks?
a. Pass a written exam with a score of 71% or higher. b. Pass a written exam with a score of 80% or higher. c. Examine a media set within 3 months and provide a report with an accuracy of 80% or higher. d. Examine a media set within 2 months and provide a report with an accuracy of 85% or higher.
The first time you configure a DNS server, the forwarder list ____.
A. points to the slave name server B. contains the loopback address C. does no exist D. is empty
Which of the following is represented by a bent arrow indicator?
A) continuous break B) line break C) page break D) column break
A single pixel is equal to 1/96 of an inch. ____________________
Answer the following statement true (T) or false (F)