南开大学数据库原理lecturequery processing.pptxVIP

  • 4
  • 0
  • 约3.86千字
  • 约 73页
  • 2020-10-15 发布于上海
  • 举报

南开大学数据库原理lecturequery processing.pptx

Query Processing;Overview of Query Execution;Step 1: Parsing;Example: SQL query;Example: Parse Tree;Step 2: Parse Tree - Logical Query Plan;Example: Logical Query Plan;Step 3: Improving the L.Q.P;Example: Improved Logical Query Plan;Step 4: Estimate Result Sizes;;Steps 5, 6, ...;Example: One Physical Plan;Example;Relational Algebra - used to describe logical plans; R A B C S C D E a 1 10 10 x 2 b 1 20 20 y 2 c 2 10 30 z 2 d 2 35 40 x 1 e 3 45 50 y 3; How to execute query?;RxS R.A R.B R.C S.C S.D S.E a 1 10 10 x 2 a 1 10 20 y 2 .

文档评论(0)

1亿VIP精品文档

相关文档