next up previous
Next: References Up: Demos Previous: Geometric Figures

Hurricane

  The hurricane database consists of heterogeneous data, representing both traditional and spatiotemporal attributes. Two relations, Land and Hurricane, are considered in this demo. The Land relation represents geographic land and has a traditional attribute landID and two constrained attributes x and y. The geometry of each land is described by algebra constraints as functions of the constrained attributes x and y. The Hurricane relation represents the evolution of a hurricane with time. Each tuple in Hurricane table describes the path of the hurricane during a time interval. An interesting query is to retrieve the landIDs that the hurricane passed, and the query steps may be found at http://www.cse.uconn.edu/cdb/hurQueries2.htm .

  
Figure 18: college database

  
Figure 19: query 5.1

 
Figure 20: result of query5.1

    
Figure 22: graphical presentation of prism


Figure 21: Relation prism

 
Figure 23: query 5.2 1)

    
Figure 24: result of 5.2 1)


Figure 25: graphical presentation of the selection

 
Figure 26: query 5.2 2)

   
Figure 27: result of 5.2 2)


Figure 28: graphical presentation of the projection

  
Figure 29: hurricane database

 
Figure 30: graphical presentation of hurricane database

  
Figure 31: query5.3

 
Figure 32: result of 5.3



Yang Fuzheng
Tue Aug 20 18:48:50 EDT 2002