'Starsin title' presentation slideshows

Spring 2011 Instructor: Hassan Khosravi

375 views • 23 slides

Algebraic Laws

Algebraic Laws. For the binary operators, we push the selection only if all attributes in the condition C are in R. Example:. Consider relation schemas R ( A , B ) and S ( B , C ) and the expression below: ? ( A =1 OR A =3) AND B < C ( R ?? S )

433 views • 23 slides

Algebraic Laws

Algebraic Laws. For the binary operators, we push the selection only if all attributes in the condition C are in R. Example:. Consider relation schemas R ( A , B ) and S ( B , C ) and the expression below: ? ( A =1 OR A =3) AND B < C ( R ?? S )

269 views • 23 slides

The Query Compiler

The Query Compiler. Parses SQL query into parse tree Transforms parse tree into expression tree ( logical query plan ) Transforms logical query plan into physical query plan. SQL query. parse. parse tree. convert. answer. logical query plan. execute. apply laws. Pi.

372 views • 18 slides

The Query Compiler

The Query Compiler. Parses SQL query into parse tree Transforms parse tree into expression tree ( logical query plan ) Transforms logical query plan into physical query plan. SQL query. parse. parse tree. convert. answer. logical query plan. execute. apply laws. Pi.

200 views • 18 slides