Write short notes on: Spatial data cube construction.
1 Answer

• A spatial data cube has three types of dimensions:

  1. A non-spatial dimension contains only non-spatial data. Non spatial dimensions temperature and precipitation can be constructed for the warehouse in Example, since each contains non spatial data whose generalizations are non-spatial (such as “hot” for temperature and “wet” for precipitation).

  2. A spatial-to-non spatial dimension is a dimension whose primitive-level data are spatial but whose generalization, starting at a certain high level, becomes non spatial.

For example, the spatial dimension city relays geographic data for the U.S. map. Suppose that the dimension’s spatial representation of, say, Seattle is generalized to the string “pacific northwest.” Although “pacific northwest” is a spatial concept, its representation is not spatial (since, in our example, it is a string). It therefore plays the role of a non-spatial dimension.

  1. A spatial-to-spatial dimension is a dimension whose primitive level and all of its high level generalized data are spatial. For example, the dimension equi temperature region contains spatial data, as do all of its generalizations, such as with regions covering 0-5 degrees (Celsius), 5-10 degrees, and so on.

We distinguish two types of measures in a spatial data cube:

• A numerical measure contains only numerical data. For example, one measure in a spatial data warehouse could be the monthly revenue of a region, so that a roll-up may compute the total revenue by year, by county, and so on. Numerical measures can be further classified into distributive, algebraic, and holistic, as discussed in Chapter 3.

• A spatial measure contains a collection of pointers to spatial objects. For example, in a generalization (or roll-up) in the spatial data cube of Example 10.5, the regions with the same range of temperature and precipitation will be grouped into the same cell, and the measure so formed contains a collection of pointers to those regions.

• A non-spatial data cube contains only non-spatial dimensions and numerical measures. If a spatial data cube contains spatial dimensions but no spatial measures, its OLAP operations, such as drilling or pivoting, can be implemented in a manner similar to that for non-spatial data cubes.

Please log in to add an answer.