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

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.

Authors:

• Gia Surguladze
• Lily Petriashvili
• Nino Topuria
• Giorgi Surguladze

Keywords:

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

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.