Database Reference
In-Depth Information
Figure 5. Spatial Drill-down position, a) Input: Ile de France region, b) Output: Departments of Ile de
France
Seine river. Then, thanks to the Slice Predicate's
wizard she/he defines its spatial query:
'ANYINTERACT',RIVERS.GEOM, 0.5)=
'TRUE' AND RIVERS.NAME = 'Seine'
As a result, the pivot table and the map show
only the departments satisfying the spatial predi-
cate.
Cut and drill operators allow to explore the
spatial hypercube using, directly or not, the spa-
select * from MEASURES_VIEW, RIVERS
where (MEASURES_VIEW.NAME = 'Es-
sone') OR… OR (MEASURES_VIEW.
NAME = 'Yvelines') AND SDO_GEOM.
RELATE(MEASURES_VIEW.GEOM,
Search WWH ::




Custom Search