Towards NoSQL-based Data Warehouse Solution integrating ECDIS for Maritime Navigation Decision Support System

Charef Abdallah Bensalloua, Abdelkader Benameur


Maritime shipping is a complex process because it requires a continuous analysis of huge amounts of information. Much of this information has variable spatial and temporal properties. In addition, the analysis must be effective to help in making decisions in a timely manner. Generally the analysis is applied with Spatial On-Line Analytical Processing (SOLAP) basing on spatial data warehouses SDW.
Data warehousing by current technologies with relational database management systems (RDBMS) cannot be applied effectively to manage the increasing complexity and volume of geo-referenced data. In order to increase the performance and availability of services, NoSQL databases technologies have appeared.
This paper presents the modeling and the realization of a spatial decision support system (SDSS) for maritime navigation namely “Maritima”, basing on the integration of the ECDIS and OLAP systems. In fact, the spatio-multidimensional analysis of the stored data can benefit from the expressive power of the electronic navigation chart offered by the ECDIS system. In order to benefit from the NoSQL model advantages, we try to apply transformations for the conceptual model to create document NoSQL DW for maritime data.
In addition to that, the multidimensional analysis at different dimensions and aggregation levels can generate beneficial indicators for the decision-aid and can be very useful in addition of other steering systems for secure maritime navigation. Finally, “Maritima” is tested with a set of spatial data related to two different harbors “Arzew” and “Oran” in western of Algeria.

Full Text:



Rothblum A.M., Wheal D., Withington S., Shappell S.A., Wiegmann D.A., Boehm W., Chaderjian M.: “Key to successful incident inquiry”. In: Proceedings 2nd international workshop on human factors in offshore operations, HFW 2002, Houston, TX, p.1–6.

J.A. Morente-Molinera, G. Kou, R. González-Crespo, J.M. Corchado, E. Herrera-Viedma, “Solving multi-criteria group decision making problems under environments with a high number of alternatives using fuzzy ontologies and multi-granular linguistic modelling methods”, Knowledge-Based Systems, Volume 137, 2017, Pages 54-64.

Agnieszka Lazarowska, “Decision support system for collision avoidance at sea”, POLISH MARITIME RESEARCH Special Issue S1 (74) 2012 Vol 19; pp. 19-24.

Adam Weintrit, “Geoinformatics in Shipping and Marine Transport”, J. Mikulski (Ed.): TST 2016, CCIS 640, pp. 13–25, 2016.

G. Mannarini, G. Coppini, P. Oddo and N. Pinardi, “A Prototype of Ship Routing Decision Support System for an Operational Oceanographic Service”, the International Journal on Marine Navigation and Safety of Sea Transportation Volume 7 Number 1 March 2013.

Zbigniew Pietrzykowski, “Navigational decision support system as an element of intelligent transport systems”, Scientific Journals, Maritime University of Szczecin, 2011, 25(97) pp. 41–47.

Zbigniew Pietrzykowski, Piotr Borkowski, Piotr Wołejsza, “NAVDEC – navigational decision suport system on a sea-going vessel”, Scientific Journals, Maritime University of Szczecin, 2012, 30(102) pp. 102–108.

R. I. Goralski , C. M. Gold, “The Development of a Dynamic GIS for Maritime Navigation Safety”, ISPRS Workshop on Updating Geo-spatial Databases with Imagery & The 5th ISPRS Workshop on DMGISs, January 2007.

L.P. Perera, J.M. Rodrigues, R. Pascoal & C. Guedes Soares, Development of an onboard decision support system for ship navigation under rough weather conditions, Sustainable Maritime Transportation and Exploitation of Sea Resources – Rizzuto & Guedes Soares (eds), Taylor & Francis Group, London, 2012.

Codd Edgar F., Codd Sally B. and Salley Clynch T. 1993. « Providing OLAP (On-Line Analytical Processing) to User-Analysts: An IT Mandate ». Codd & Associates, pages 26.

Abdallah Bensalloua, C. “SOLAP et SIG pour le partage de données dans la gestion des espaces agroforestiers”, Doctorate thesis in sciences, university of Oran1, Algeria, 2018.

Inmon William H., « Building the Data Warehouse ». Édition : 4th Edition. Indianapolis, Ind: John Wiley & Sons. 2005.

Bédard Yvan, Jiawey HAN and Tim Merrett. 2001. « Fundamentals of Spatial Data Warehousing for Geographic Knowledge Discovery ». In Geographic Data Mining and Knowledge Discovery, Research Monographs in GIS, Taylor & Francis, pages 53‑ 73.

Teste, O., “Modélisation et manipulation d'entrepôts de données complexes et historisées». Doctorate thesis in computer sciences, university Paul Sabatier - Toulouse iii, France, 2000.

K. Boulil, « Une approche automatisée basée sur des contraintes d’intégrité définies en UML et OCL pour la vérification de la cohérence logique dans les systèmes SOLAP : Application dans le domaine agri-environnemental ». Doctorate thesis in Computer sciences. University Blaise Pascal - Clermont-Ferrand ii, France, 2012.

Ravat, F., Teste, O. et Zurfluh G., (Janvier 2005). « Manipulation et fusion de données multidimensionnelles ». In RNTI-E-3 Revue des Nouvelles Technologies de l'Information, Extraction et Gestion des Connaissances (EGC'2005) Vol. I, pages 349_354, Paris, France, Cépadues (ed.).

Naoum, L. (2006). « Un modèle multidimensionnel pour un processus d'analyse en ligne de résumés flous ». Doctorate thesis, University of Nantes, France.

Bédard, Y. et J. Han (2009). “Geographic Data Mining and Knowledge Discovery, Chapter Fundamentals of Spatial Data Warehousing for Geographic Knowledge Discovery”. Taylor & Francis.

Teste, O., (2000), « Modélisation et manipulation d'entrepôts de données complexes et historisées ». Doctorate thesis in computer sciences, University Paul Sabatier - Toulouse III, France.

Abdallah Bensalloua, C. and Hamdadou, D., Users Integrity Constraints in SOLAP Systems- Application in Agroforestry, International Journal of Interactive Multimedia and Artificial Intelligence, 5(1): 47-56, 2018

Rivest, S. (2000). "Investigation des modes d’intégration physique entre un serveur de base de données multidimensionnelle et un SIG." Informatics DEA Repport, Laval: Laval University, Canada.

Mazon, J.-N. and J. Trujillo (2008). "An MDA approach for the development of data warehouses." Decis. Support Syst. 45(1): 41-58.

Bimonte, S. (2007). Intégration de l'information géographique dans les entrepôts de données et l'analyse en ligne : de la modélisation à la visualisation, INSA-Lyon: 207.

Malinowski, E. and E. Zimanyi (2008). Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications, Springer.

Bédard, Y. and J. Han (2009). Fundamentals of Spatial Data Warehousing for Geographic Knowledge Discovery. Geographic Data Mining and Knowledge Discovery. H. J. Miller and J. Han, Taylor & Francis.

Salehi, M., Y. Bédard and S. Rivest (2010). " Formal Conceptual Model and Definition Framework for Spatial Datacubes." Geomatica 64(3): 313-326.

Grady, B. , James, R., et Ivar, J. (2005). The Unified Modeling Language: reference manual, (2nd ed.). USA: Addison-Wesley Professional press.

Octavio, G., Mazón, J.N., Irene, G., et Trujillo, J. (2012). A personalization process for spatial data warehouse development. Decision Support Systems, 52, 884–898.

Juan, T., Emilio, S., Eduardo, F.M., & Mario, P. (2009). A UML 2.0 profile to define security requirements for Data Warehouses, Computer Standards and Interfaces, 31, 969–983.

Boulil, K., Florence, L.B., Sandro, B., Corinne, G., & Flavie, C. (2014). Multidimensional modeling and analysis of large and complex watercourse data: an OLAP-based solution, Ecological Informatics, 24 , 90–106.

Boulil, K., Sandro, B. & Francois, P. (2015). Conceptual model for spatial data cubes: A UML profile and its automatic implementation. Computer Standards & Interfaces, 38, 113–132.

Abdallah Bensalloua, C. and Hamdadou, D. (2018a), Spatial OLAP and Multicriteria Integrated Approach for Decision Support System: Application in Agroforestry Management (030117-074730), International Journal of Decision Support System Technology (IJDSST ) Volume 10, Issue 3.

Sivakumar, H., Matt, C., Sethu. M., Robert, Z., et Denny, G.Y.L. (2009). Professional Microsoft SQL Server Analysis Services 2008 with MDX, Indianapolis, Indiana, USA. Wiley Publishing Inc Press.

Joel, D.S., Anjolina G.O., Robson, N.F., Ana, C.S., & Valéria, C.T. (2010). Modeling and querying geographical data warehouses, Information Systems, 35, 592–614.

R. Kimball, M. Ross, The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd edition Wiley, 2002.

[36] Crespo R.G., Fernandez G.G., Palacio D.Z., Franco E.T., Sanz A.C., García-Bustelo C.P. (2009) GIS Applications Use in Epidemiology GIS-EPI. In: Omatu S. et al. (eds) Distributed Computing, Artificial Intelligence, Bioinformatics, Soft Computing, and Ambient Assisted Living. IWANN 2009. Lecture Notes in Computer Science, vol 5518. Springer, Berlin, Heidelberg

Yao, Jing and Agadjanian, Victor, (2018) Bypassing health facilities in rural Mozambique: spatial, institutional, and individual determinants, BMC Health Services Research, 18(1).

Xiang, Yuanxi ; Zare, Hossein ; Guan, Cuiling and Gaskin, Darrell, (2018) The impact of rural-urban community settings on cognitive decline: results from a nationally-representative sample of seniors in China, BMC Geriatrics, 18(1)

Black, Devin E. ; Poynter, Zachary W. ; Cotton, Claudia A. ; Upadhaya, Suraj ; Taylor, David D. , Leuenberger, Wendy ; Blankenship, Beth A. and Arthur, Mary A., (2018) Post-wildfire recovery of an upland oak−pine forest on the Cumberland Plateau, Kentucky, USA. 14 (2).

Costa, Nicole A. ; Jakobsen, Jeanette J. ; Weber, Reto ; Lundh, Monica and MacKinnon, Scott N. (2018) Assessing a maritime service website prototype in a ship bridge simulator: navigators' experiences and perceptions of novel e-Navigation solutions. WMU Journal of Maritime Affairs, 17(4)

Zolich, Artur ; Palma, David ; Kansanen, Kimmo ; Fortoft, Kay ; Sousa, Joao ; Johansson, Karl H. ; Jiang, Yuming ; Dong, Hefeng and Johansen, Tor A.,(2018) Survey on Communication and Networks for Autonomous Marine Systems. Journal of Intelligent & Robotic Systems.

Xu, Qingyang ; Yang, Yiqin ; Zhang, Chengjin and Zhang, Li. (2018), Deep Convolutional Neural Network-Based Autonomous Marine Vehicle Maneuver, International Journal of Fuzzy Systems, 20(2), pp"687-699"

Li, Z. (2018). NoSQL Databases. The Geographic Information Science & Technology Body of Knowledge (2nd Quarter 2018 Edition), John P. Wilson (Ed). DOI: 10.22224/gistbok/2018.2.10

Akon Dey, Alan Fekete, and Uwe Röhm. 2013. Scalable Transactions Across Heterogeneous NoSQL Key-value Data Stores. Proc VLDB Endow 6, 12 (August 2013), 1434–1439. DOI:

Douglas Crockford. 2006. The application/json media type for javascript object notation (json). (2006).

Lars George. 2011. HBase: The Definitive Guide, O’Reilly Media, Inc.

Eric Evans. 2004. Domain-driven design: tackling complexity in the heart of software, Addison-Wesley Professional.

Van der Veen, J. S., Van der Waaij, B., & Meijer, R. J. (2012). Sensor data storage performance: SQL or NoSQL, physical or virtual. In Cloud computing (CLOUD), 2012 IEEE 5th international conference on (pp. 431-438). IEEE. DOI: 10.1109/CLOUD.2012.18

Zhang, X., Song, W., & Liu, L. (2014). An implementation approach to store GIS spatial data on NoSQL database. In Geoinformatics (GeoInformatics), 2014 22nd International Conference on (pp. 1-5). IEEE. DOI: 10.1109/GEOINFORMATICS.2014.6950846

Han, D., & Stroulia, E. (2013, June). HGrid: A data model for large geospatial data sets in HBase. In Cloud Computing (CLOUD), 2013 IEEE Sixth International Conference on (pp. 910-917). IEEE. DOI: 10.1109/CLOUD.2013.78

Rania Yangui, Ahlem Nabli and Faiez Gargour. (2016). Automatic Transformation of Data Warehouse Schema To NoSQL Data Base: Comparative Study. 20th International Conference on Knowledge Based and Intelligent Information and Engineering Systems, KES2016, 5-7 September 2016, York, United Kingdom, Procedia Computer Science 96 ( 2016 ) 255 – 264.

Cuzzocrea, Alfredo and Bellatreche, Ladjel and Song, Il-Yeol.(2013a) Data Warehousing and OLAP over Big Data: Current Challenges and Future Research Directions. Proceedings of the Sixteenth International Workshop on Data Warehousing and OLAP, DOLAP 2013, San Francisco, 28 october 2013, pp. 67–70 (2013)

Rania Yangui, Ahlem Nabli, Faiez Gargouri. Automatic Transformation of Data Warehouse Schema To NoSQL Data Base: Comparative Study. 20th International Conference on Knowledge Based and Intelligent Information and Engineering Systems, KES2016, 5-7 September 2016, York, United Kingdom, Procedia Computer Science 96 ( 2016 ) 255 – 264

Paolo Atzeni, Francesca Bugiotti, Luca Cabibbo, Riccardo Torlone. Data modeling in the NoSQL world. Computer Standards & Interfaces, 2020

Khaled Dehdouh, Building OLAP Cubes from Columnar NoSQL Data Warehouses in Model and Data Engineering, Springer International Publishing. 2016

M. Chevalier, M. El Malki, A. Kopliku, O. Teste, Ronan Tournier. Not Only SQL Implementation of multidimensional database. International Conference on Big Data Analytics and Knowledge Discovery (DaWaK 2015a), p. 379-390, 2015.

M. Chevalier, M. El Malki, A. Kopliku, O. Teste, R. Tournier. Implementation of multidimensional databases in column-oriented NoSQL systems. East-European Conference on Advances in Databases and Information Systems (ADBIS 2015b), p. 79-91, 2015.


Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 License.