Simple Demo: OBSERVER execution



Last update: June 17, 2003

This is the Main Plan as ERA tree for the query:

This is the Main Plan for the query:

[ JOIN
   [ UNION
      [ UNION
         [ AUX-1 ] ( T1 )
         [ AUX-2 ] ( T2 )
          ( T1.Name T2.Name ) ( T1.Price T2.Price )
      ] ( T3 )
      [ AUX-3 ] ( T4 )
       ( T3.Name T4.Name ) ( T3.Price T4.Price )
   ] ( ALIAS6 )
   [ JOIN
      [ UNION
         [ UNION
            [ AUX-4] ( T1 )
            [ AUX-5 ] ( T2 )
             ( T1.Name T2.Name ) ( T1.Location T2.Location )
         ] ( T3 )
         [ AUX-6 ] ( T4 )
          ( T3.Name T4.Name ) ( T3.Location T4.Location )
      ] ( ALIAS4 )
      [ JOIN
         [ UNION
            [ UNION
               [ AUX-7] ( T1 )
               [ AUX-8] ( T2 )
                ( T1.Name T2.Name ) ( T1.Name T2.Name )
            ] ( T3 )
            [ AUX-9 ] ( T4 )
             ( T3.Name T4.Name ) ( T3.Name T4.Name )
         ] ( ALIAS2 )
         [ JOIN
            [ UNION
               [ UNION
                  [ AUX-10] ( T1 )
                  [ AUX-11] ( T2 )
                   ( T1.Name T2.Name ) ( T1.Location T2.Location ) ( T1.Meals T2.Meals ) ( T1.Building T2.Building ) ( T1.Facilities T2.Facilities ) ( T1.Units T2.Units ) ( T1.Price T2.Price ) ( T1.Stars T2.Stars )
               ] ( T3 )
               [ AUX-12 ] ( T4 )
                ( T3.Name T4.Name ) ( T3.Location T4.Location ) ( T3.Meals T4.Meals ) ( T3.Building T4.Building ) ( T3.Facilities T4.Facilities ) ( T3.Units T4.Units ) ( T3.Price T4.Price ) ( T3.stars T4.stars )
            ] ( ALIAS0 )
            [ SELECTION
               [ UNION
                  [ UNION
                     [ AUX-13 ] ( T1 )
                     [ AUX-14 ] ( T2 )
                      ( T1.Name T2.Name ) ( T1.Price T2.Price )
                  ] ( T3 )
                  [ AUX-15 ] ( T4 )
                   ( T3.Name T4.Name ) ( T3.Price T4.Price )
               ]
               [ = dbHotels.hotels.price 200 ]
            ] ( ALIAS1 )
            [ = ALIAS0.name ALIAS1.name ]
         ] ( ALIAS3 )
         [ = ALIAS2.name ALIAS3.name ]
      ] ( ALIAS5 )
      [ = ALIAS4.name ALIAS5.name ]
   ] ( ALIAS7 )
   [ = ALIAS6.name ALIAS7.name ]
]
	f: NULO


joalroyo@unizar.es
June 16, 2003