Q3 Simplify Following Query Transform Optimized Operator Tree Using Restructuring Algorith Q43786463
Q3: Simplify the following query, and transform it into an optimized operator tree using the restructuring algorithm, where select and project operations are applied as soon as possible to reduce the size of intermediate relations. SELECT ENAME, PNAME FROM EMP, ASG, PROJ WHERE (DUR > 12 OR RESP = “Analyst”) AND EMP.ENO = ASG.ENO AND (TITLE=”Elect. Eng.” OR ASG.PNO < “P3″) AND (DUR > 12 OR RESP NOT=”Analyst”) AND ASG.PNO = PROJ.PNO Q4: Assume that relation PROJ of the sample database is horizontally fragmented as follows: PROJ1 = OPNOc”P2 (PROJ) PROJ2 = OPNO>”P2 (PROJ) Transform the following query into a reduced query on fragments: SELECT ENO, PNAME FROM PROJ, ASG WHERE PROJ.PNO = ASG.PNO AND PNO = “24” Show transcribed image text Q3: Simplify the following query, and transform it into an optimized operator tree using the restructuring algorithm, where select and project operations are applied as soon as possible to reduce the size of intermediate relations. SELECT ENAME, PNAME FROM EMP, ASG, PROJ WHERE (DUR > 12 OR RESP = “Analyst”) AND EMP.ENO = ASG.ENO AND (TITLE=”Elect. Eng.” OR ASG.PNO 12 OR RESP NOT=”Analyst”) AND ASG.PNO = PROJ.PNO Q4: Assume that relation PROJ of the sample database is horizontally fragmented as follows: PROJ1 = OPNOc”P2 (PROJ) PROJ2 = OPNO>”P2 (PROJ) Transform the following query into a reduced query on fragments: SELECT ENO, PNAME FROM PROJ, ASG WHERE PROJ.PNO = ASG.PNO AND PNO = “24”
Expert Answer
Answer to Q3: Simplify the following query, and transform it into an optimized operator tree using the restructuring algorithm, wh…
OR