Modelling of Designing a Conceptual Schema for Multimodal Freight Transportation Information System

Authors: Gia Surguladze, Lily Petriashvili, Nino Topuria, Giorgi Surguladze

Abstract:

Modelling of building processes of a multimodal freight transportation support information system is discussed based on modern CASE technologies. Functional efficiencies of ports in the eastern part of the Black Sea are analyzed taking into account their ecological, seasonal, resource usage parameters. By resources, we mean capacities of berths, cranes, automotive transport, as well as work crews and neighbouring airports. For the purpose of designing database of computer support system for Managerial (Logistics) function, using Object-Role Modeling (ORM) tool (NORMA–Natural ORM Architecture) is proposed, after which Entity Relationship Model (ERM) is generated in automated process. Software is developed based on Process-Oriented and Service-Oriented architecture, in Visual Studio.NET environment.

Keywords: Seaport resources, business-processes, multimodal transportation, CASE technology, object-role model, entity relationship model, SOA.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1109535

References:

[1] Meyer-Wegener K., Petriaschvili L., Surguladze G. (2014). Decision Support System for Optimization of Seaport Resource. III internat. Scientific Conference “Computing / Informatics, Education Sciences, Teacher Education”, Batumi, Georgia.
[2] Gogichaishvili G., Surguladze G. (2014). Concept of Automated Management of Multimodal Freight Transportation Business Processes. Transactions of Georgian Technical University. Automated Control Systems - No 2(18), pp.45-50.
[3] Virginia Multimodal Freight Plan. (2013). Draft Report. Prepared by Cambridge Systematics, Inc. 8573.230. http://www.cppdc.org/Transportation_ Data/Virginia_Multimodal_Freight_Plan_11.01.13_Draft_Fin al_with_appendices.pdf.
[4] Halpin T., Object-Role Modelling: an overview, Microsoft Corporation, http://www.orm.net/pdf/ormwhitepaper.pdf.
[5] Halpin T., Curland M. (2006). ORM 2 Constraint Verbalization Part 1, Technical Report ORM2-02. http://www.orm.net/pdf/ORM2_Tech- Report2.pdf.
[6] Wedekind H., Surguladze G., Topuria N. (2006). Design and Implementation of Data Bases of Distributed Office-Systems with UML. ISBN 99940-57-17-0. GTU. Tbilisi. 2006. pp237.