Lecture #10 «Introduction into RDBMS»

Hi there!

You can find out here of “Introduction into Relational Databases” course with theme “Semantic SQL query optimization”.

RDBMS Lecture 10

Themes are below.

  • Relational algebra and optimization
  • Database statistics
  • Parse tree
  • Query tree
  • Plan tree
  • Reduction Law
  • Projection Law
  • Reduction Projection Law
  • Distribution Law
  • Commutative Law
  • Associative Law
  • Idempotent Law
  • Expression Transformation
  • Semantic equivalent
  • Query cost

Please if you have some comments / questions or remarks , just let me know about it.