1.Consider two relations R(A,B,C,D,E) and S(A,F,G,H). Assume there is a clustered index on attribute A for each relation. Assuming a database cluster with full replication, for each of the following queries, determine whether Virtual Partitioning can be used to obtain intraquery parallelism and, if so, write the corresponding subquery and the final result composition query. (a) SELECT B, COUNT(C) FROM R GROUP BYB (b) SELECT C, SUM(D), AVG(E) FROM R WHERE B=:v1 GROUP BY C (c) SELECT B, SUM(E) FROM. R, S WHERE. R.A=S.A GROUP BY B HAVING COUNT(*) > 50 (d) SELECT B, MAX(D) FROM+. R, S WHERE C=(SELECT SUM(G) FROM S WHERE S.A=R.A) GROUP BY B (e) SELECT B, MIN(E) FROM. R WHERE D>(SELECT MAX(H) FROM S WHERE G >= :v1)
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here