Optimizing geographical information system data by using an agent-based approach to data warehousing

  • Authors:
  • Pooya Khosraviyan

  • Affiliations:
  • Islamic Azad University, Iran

  • Venue:
  • ICCOMP'10 Proceedings of the 14th WSEAS international conference on Computers: part of the 14th WSEAS CSCC multiconference - Volume I
  • Year:
  • 2010

Quantified Score

Hi-index 0.00

Visualization

Abstract

This article introduces the Data Warehouse such as Analytical Database to support the Geographical Data and is able to present topologic and spatial analytics of data. The basis of the definition of Analytical Database is Multi Dimensional Model, hence in this article, we design a Geographical Data cube designed as a useful structure for modeling multi dimensional data of Geographical Data Warehouse. Geographical Data cube is based on Spatial Dimensions and Measures. Spatial Dimensions is divided into four classes such as Non-Geographical, Non-Geographical to Geographical, All Geographical, and Topologic and also we consider three types of Spatial Measures for Geographical Data Warehouse like Geographical Measures, Spatial-Numerical Measures, and Topological Measures. To present and store these relations we use the four-cooperative model as a key model for present octal binary relation between two Geographical Objects. In this way we can store the result of this model as a Numerical Measure into Geographical Data Warehouse with definition of binary matrix. Finally, we implement the Geographical Data Warehouse system based on a proposed multi level architecture. To implement it, we use the Oracle Database Engine like as DBMS. Obviously DBMS must be able to manage the Spatial Data and Non-Spatial Data existing on Geographical Data Warehouse concurrency and cohesively, to do so, we use the Oracle Database Engine and software packages like Oracle Spatial10g and PLSQL Developer. In the end, for the examination and presentation of Geographical Data Warehouse Analytical Query results, in the proposed system, modeling and operate the scenario of researching article around of SOLAP and Spatial Multi Dimensional Query.