ABSTRACT
The need to store and analyze movement data is continuously growing as a consequence of the huge availability of data being collected through GPS receivers, mobile devices, sensors, and others technologies. This paper presents an approach for the storage and analysis of maritime transportation data in a spatial data warehouse. The aim is to identify near-miss situations, which are the contexts where collisions between ships may occur. Moreover, a key performance indicator is proposed to compute the target percentage of safe situations between ships. The proposed spatial data warehouse was modeled, implemented and loaded with the data collected by The Netherland Coastguard, and includes data of shipping movements collected by AIS (Automatic Identification System) base stations. Through the SOLAP analysis of this data set, and taking a sample safety distance of 50 meters between ships, it was possible to verify that the percentage of safe situations is of 92%, going beyond the defined target limit of 90%. The results are promising at the conceptual level and demonstrate the need for further development of key performance indicators for analyzing large movement data sets.
- del-Río-Ortega, A. and Resinas, M. 2009. Towards Modelling and Tracing Key Performance Indicators in Business Processes. In Proceedings of SISTEDES'2009.Google Scholar
- Eckerson, W. 2011. Performance Dashboards: Measuring, Monitoring, and Managing Your Business. 2nd. Edition. John Wiley & Sons Inc.Google Scholar
- Viswanathan, G. and Schneider, M. 2011. On the Requirements for User-Centric Spatial Data Warehousing and SOLAP. In 1st Int. Workshop on Spatial Information Modeling, Management and Mining (Hong Kong, 2011). Google ScholarDigital Library
- Rivest, S., et al. 2005. SOLAP technology: Merging business intelligence with geospatial technology for interactive spatio-temporal exploration and analysis of data. In ISPRS Journal of Photogrammetry and Remote Sensing. 60, 17--33.Google ScholarCross Ref
- Goralski, R. I. and Gold, C. M. 2007. The development of a Dynamic GIS for Maritime Navigation Safety. In ISPRS Workshop on Updating Geo-Spatial Databases with Imagery & The 5th ISPRS Workshop on Dynamic and Multi-Dimensional GIS (China, 2007).Google Scholar
- Alter, S. 1992. Information Systems: a management perspective. Addison-Wesley. Google ScholarDigital Library
- Han, J. and Kamber, M. 2001. Data Mining: Concepts and Techniques. Morgan Kaufmann Publishers. Google ScholarDigital Library
- Shahin, A. and Mahbod, M.A. 2007. Prioritization of key performance indicators: An integration of analytical hierarchy process and goal setting. Int. Journal of Productivity and Performance Management. 56, 3, 226--240.Google ScholarCross Ref
- Han, J., Stefanovic, N. and Kopersky, K. 1998. Selective Materialization: An Efficient Method for Spatial Data Cube Construction. In Proceedings of PAKDD'98. Google ScholarDigital Library
- Stefanovic, N., Han, J., and Koperski, K. 2000. Object-based selective materialization for efficient implementation of spatial data cubes. IEEE Transactions on Knowledge and Data Engineering. 12, 6, 938--958. Google ScholarDigital Library
- Symmetry Corporation. 2006. Getting Started with ADAPT TM: OLAP Database Design.Google Scholar
Index Terms
- Computing performance indicators in detecting shipping collision
Recommendations
Spatial hierarchy and OLAP-favored search in spatial data warehouse
DOLAP '03: Proceedings of the 6th ACM international workshop on Data warehousing and OLAPData warehouse and Online Analytical Processing(OLAP) play a key role in business intelligent systems. With the increasing amount of spatial data stored in business database, how to utilize these spatial information to get insight into business data ...
The SB-index and the HSB-index: efficient indices for spatial data warehouses
Spatial data warehouses (SDWs) allow for spatial analysis together with analytical multidimensional queries over huge volumes of data. The challenge is to retrieve data related to ad hoc spatial query windows according to spatial predicates, avoiding ...
The Construction and Key Issues of Spatial Data Warehouse for Oil Exploration and Development
AICI '10: Proceedings of the 2010 International Conference on Artificial Intelligence and Computational Intelligence - Volume 03professional database especially the data center management model has achieved the integration, share of data and the separation between data and application in oil exploration and development, but the issues for data analysis and data mining, ...
Comments