GeoDWFrame: A Framework for Guiding the Design of Geographical Dimensional Schemas

Data Warehouse (DW) is a dimensional database for providing decision support by means of on-line analytical processing (OLAP) techniques. Another technology also used to provide decision support is Geographical Information System (GIS). Much research aims at integrating these technologies, but there are still some open questions, particularly regarding the design of a geographical dimensional data schema. This paper discusses some related work and proposes GeoDWFrame that is a framework based on the star schema and has been specified as guidance for designing geographical dimensional schemas. Some experimental results are also given.

[1]  W. H. Inmon,et al.  Building the data warehouse (2nd ed.) , 1996 .

[2]  Jiawei Han,et al.  Fundamentals of spatial data warehousing for geographic knowledge discovery , 2001 .

[3]  Long Zhang,et al.  Spatial hierarchy and OLAP-favored search in spatial data warehouse , 2003, DOLAP '03.

[4]  Ralph Kimball,et al.  The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom , 1998 .

[5]  Jeffrey D. Ullman,et al.  Implementing data cubes efficiently , 1996, SIGMOD '96.

[6]  Yvan Bédard,et al.  Toward better support for spatial decision making: Defining the characteristics of spatial on-line analytical processing (SOLAP) , 2001 .

[7]  A. Guttman,et al.  A Dynamic Index Structure for Spatial Searching , 1984, SIGMOD 1984.

[8]  Ranga Raju Vatsavai,et al.  Map cube: A visualization tool for spatial data warehouses , 2001 .

[9]  Panos Kalnis,et al.  Efficient OLAP Operations in Spatial Data Warehouses , 2001, SSTD.

[10]  Jiawei Han,et al.  Selective Materialization: An Efficient Method for Spatial Data Cube Construction , 1998, PAKDD.

[11]  Ralph Kimball,et al.  The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses , 1996 .

[12]  Michael N. DeMers,et al.  Fundamentals of Geographic Information Systems , 1996 .

[13]  Kamil Matousek,et al.  On Data Warehouse and GIS Integration , 2000, DEXA.

[14]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.