Abstract: Spatial databases store information about spatial objects.In many applications summarized data is required, however this summary is very time consume and expensive.Driven by the non-spatial database,spatial data warehouses can be constructed to accelerate spatial OALP operations.It is considered the star schema and focus on the hierarchies of spatial dimensions,which based on the spatial R-tree index.It is also proposed a spatial query algorithm and considerd the updates of the data.