The design of a RDBMS architecture maintains a logical level (Conceptual view) and a physical level (actual File storages) of a database Independently, which makes RDBMS thriving over rapid changes in complex modern enterprise database systems. Describe how this independence between a logical level and a physical level can be achieved in RDBMS by explaining how a view is maintained and a view query (that is a query with view) is processed in RDBMS using the following example Q1 and the view v1 below Create View v1 (x1, sum_y1) As
Select t1.x1, Sum(t1.y1)
From t1
Group By t1.x1:
1-1) Specify which subsystem of a SQL Server in the following is in charge of view processing mechanism? The subsystems of a SQL Server for query processing are: Syntaxer, Resolver, Optimizer, or File Execution subsystem.
1-2) Show the view processing mechanism how Q1 - the query with a view below is processed when the query Q1 is submitted to a RDBMS server. Assume that v1 is already created in the system and you can name the temporary table in the view processing as needed.
Q1: Select*
From v1. t2
Where v1.x1 = t2.x2 and v1.x1 > 10;
1-3) For the final processed query of Q1 in 1-2), build a query execution algorithm in Relational Algebra operators either in data pipelining steps (top to bottom) or a query execution tree (in a bottom up sequence) that will be built by the end of the Optimizer.