From GIS database to spatial data warehouse

The research described in this paper combine a geographical information system (GIS) with a database management system, to determinate near optimal storage location in Data Warehouse. The first section provides an introduction to the field of spatial databases and data warehouses by presenting some definitions of this notion, characteristics and objectives. Section two presents specific data models for data warehouses, which are diagrams showing the design used in data warehouse and also presents concepts of cube, dimension hierarchies and OLAP operations. The third, is the design scheme of a data warehouse, followed by building the data warehouse using Oracle Warehouse Builder 10g, analyzing all the steps needed for this. We define a geographical data cube. In the four section we discuss about query language for retrieving data stored in data warehouse. Here, the fact table attributes consist of measures and a spatial measure is seen as geometry or function.