Spatial data warehouse design and spatial OLAP implementation for decision making of geospatial data update

• Published in: KSCE journal of civil engineering Vol. 16; no. 6; pp. 1023 - 1031
• Main Authors: Kyung, Min-Ju, Yom, Jae-Hong, Kim, Seung-Yong
• Format: Journal Article
• Language: English
• Published: Heidelberg Korean Society of Civil Engineers 01.09.2012; Springer Nature B.V; 대한토목학회
• Subjects: Aerial photography; Civil Engineering; Data warehouses; Decision making; Engineering; Geotechnical Engineering & Applied Earth Sciences; Global positioning systems; GPS; Industrial Pollution Prevention; Lidar; Local government; Maintenance costs; OLAP; Online analytical processing; Research Paper; Satellite imagery; Satellite navigation systems; Satellite photography; Spatial data; Surface layer; Texture; Three dimensional models; Warehouses; 토목공학; SDW (Spatial Data Warehouse); geospatial data update; GIS (Geographic Information System); SOLAP (Spatial OLAP); decision making
• ISSN: 1226-7988; 1976-3808
• DOI: 10.1007/s12205-012-1410-2

Many authorities and local governments collect and maintain immense geospatial databases composed of various types of vector and raster data. These geospatial data need to be updated and monitored on a regular basis to provide accurate information. As the mapping area and the variety of data (GPS, DEM, LIDAR, aerial photography, satellite imagery, 3D building models, texture images, videos, etc.) collected for these areas increase, the maintenance costs also increases. Therefore, it is crucial to make effective costsaving decisions regarding the time, place, and type of geospatial data to be updated. In this study, geospatial data updating criteria are discussed and a multi-dimensional database model is proposed to aid the decision-making process in updating geospatial data. Based on this model, a star schema SDW (Spatial Data Warehouse) is designed and a SOLAP (Spatial OLAP) is implemented to aid in making optimal decisions regarding geospatial database updating.