Decision problems in designing database architecture for the assessment of logistics services

• Autorzy: Izdebski Mariusz , Jacyna-Gołda Ilona , Gołębiowski Piotr , Gołda Paweł , Pyza Dariusz , Żak Jolanta

Identyfikatory

DOI

10.20858/sjsutst.2020.108.6

• Języki publikacji: EN

Abstrakty

EN

This paper presents decision problems which occur in designing database architecture for the assessment of logistics services. In the work, it was emphasized that the key stages in database design is to define a database model comprising a set of rules that characterize the structure of data in the database and a list of operations that can be performed on the data entered into the database. Research presented in the article is conducted as part of the project on the European Portal of Logistics Services (EPLOS) implemented on the basis of an agreement with the National Center for Research and Development under the EUREKA program. As part of the research carried out as part of the project, the principles of functioning of distributed architecture were developed and evaluated for the services offered by carriers or logistics operators operating on the international market. These include operators providing air services, international road, intermodal, sea transports, etc. The article indicates that the purpose of the database responsible for processing information in cargo intermodal connections is not only to collect input data on aviation and road infrastructure, but also to save the results generated by computational modules. At work, the modular database structure for assessing logistics services consisting of among others from dynamic data module, archive module, data entry module, optimization algorithm calibration module was proposed. Catalog structure and rules for supplying the database with data on the example of a railway operator were presented in detail.

Słowa kluczowe

EN

database architecture; logistics services; European Portal of Logistics Services

PL

architektura baz danych; usługi logistyczne; Europejski Portal Usług Logistycznych

• Wydawca: Wydawnictwo Politechniki Śląskiej
• Czasopismo: Zeszyty Naukowe. Transport / Politechnika Śląska
• Rocznik: 2020
• Tom: z. 108
• Strony: 53--71
• Opis fizyczny: Bibliogr. 32 poz.

Twórcy

autor

Izdebski Mariusz

• Warsaw University of Technology, Warsaw, Poland

autor

Jacyna-Gołda Ilona

• Warsaw University of Technology, Warsaw, Poland

autor

Gołębiowski Piotr

• Warsaw University of Technology, Warsaw, Poland

autor

Gołda Paweł

• Air Force Institute of Technology, Warsaw, Poland

autor

Pyza Dariusz

• Warsaw University of Technology, Warsaw, Poland

autor

Żak Jolanta

• Warsaw University of Technology, Warsaw, Poland

Bibliografia

• 1. Amit Govind, Rose Luke, Noleen Pisa. 2017. „Investigating stock-outs in Johannesburg’s warehouse retail liquor sector”. Journal of Transport and Supply Chain Management 11(a303). DOI: https://doi.org/10.4102/jtscm.v11i0.303.
• 2. Babaian T., W. Lucas. 2013. “Modeling data for enterprise systems with memories”. Journal of Database Management 24(2): 1-12.
• 3. Bagchi P.K. 2000. On measuring supply chain competency of nations: A developing country perspective. LERC, Cardiff.
• 4. Belien J., L. Boeck. 2014. “Municipal solid waste collection and management problems: a literature revie”. Transportation Science, Institute for Operations Research and the Management Sciences (INFORMS) 48(1): 78-102. USA.
• 5. Benedikt M., P. Bourhis, C. Ley. 2015. “Analysis of schemas with access restriction”. ACM Transactions on Database Systems 40(1): 5.
• 6. Bluszcz M., M. Jacyna. 2010. “Model solution of connections between urban logistic system and national logistic system”. Archives of Transport 21(3-4): 5-24.
• 7. Connolly T., C. Begg. 2005. Database systems: a practical approach to design, implementation, and management. Pearson Education.
• 8. Cooper M.C., L.M. Ellram. 1993. “Characteristics of chain management and the implications for purchasing and logistics strategy”. International Journal of Logistics Management 2(4).
• 9. Dong Y., A. Goh. 1998. “An intelligent database for engineering applications”. Artificial Intelligence in Engineering 12(1): 1-14.
• 10. Directive 2012/34 / EU of the European Parliament and of the Council of November 21, 2012 on the creation of a single European railway area.
• 11. Elmasri R. 2008. Fundamentals of database systems. Pearson Education India.
• 12. Gołda P., M. Izdebski, E. Szczepański. 2018. “The application of ant algorithm in the assignment problem of aircrafts to stops points on the apron”. Journal of KONES 25(4): 479-488.
• 13. Gołda P., M. Kowalski, C. Wasser, P. Dygnatowski, A. Szporka. 2019. “Elements of the model positioning of aircraft on the apron”. Archives of Transport 51(3): 101-108.
• 14. Jacyna M., P. Gołębiowski, K. Lewczuk. 2016. “Functions, relations and basic elements of database for the designing of storage facilities”. Conference Proceedings of 8th International Scientific Conference Management of Technology – Step to Sustainable Production. Poreč.
• 15. Jacyna M., M. Izdebski, E. Szczepański, P. Gołda. 2018. „The task assignment of vehicles for a production company”. Symmetry-Basel 11(10): 1-19. DOI: 10.3390/sym10110551.
• 16. Jacyna M., E. Szczepański. 2013. “Holistic approach to the ecological cargo distribution in urban areas with the use of multi-modal transport”. WIT Transactions on The Built Environment 130: 53-65. WIT Press.
• 17. Jacyna M. 2008. “Distribution warehouses and realisation of logistic processes in supply chains”. Archives of Transport 20(3): 5-20.
• 18. Jacyna M. 2013. “The role of cargo consolidation center in urban logistic system". International Journal of Sustainable Development and Planning 8(1): 100-113.
• 19. Jacyna M., A. Bobiński. 2016. SIMMAG jako narzędzie dla wizualizacji obiektów magazynowych w 3D. [In Polish: SIMMAG as a tool for visualization of warehouse objects in 3D]. Warsaw University of Technology Publishing House. ISBN: 978-83-7814-637-7.
• 20. Jacyna M., J. Kukulski, P. Gołębiowski, S. Jasiński, W. Wychowański. 2018. “Technical-organizational and legal conditions related to the power supply of a railway vehicle equipped with automatic train control system”. Journal of KONES 25(4): 533-546.
• 21. Jacyna M., M. Wasiak (eds.). 2014. Simulation model to support designing a sustainable national transport system. Warsaw University of Technology Publishing House. ISBN: 978-83-941338-0-1.
• 22. Jacyna M., M. Wasiak. 2015. “Multicriteria decision support in designing transport systems”. Tools of Transport Telematics. In Mikulski Jerzy (ed.). Springer. ISBN: 978-3-319-24577-5. DOI: 10.1007/978-3-319-24577-5.
• 23. Kisielewski P. 2016. “The system of IT support for logistics in the rail transport”. Archives of Transport 40(4): 39-50.
• 24. Kłodawski M., R. Jachimowski, I. Jacyna-Golda, M. Izdebski. 2018. „Simulation analysis of order picking efficiency with congestion situations”. International Journal of Simulation Modelling 17(3): 431-443.
• 25. Kowalski M., P. Waślicki, J. Żak. 2018. “Selected aspects of the maintenance system optimization of the Polish Armed Forces helicopters”. Journal of KONES 25(3): 289-297.
• 26. Kukulski J., M. Jacyna, P. Gołębiowski. 2019. “Finite element method in assessing strength properties of a railway surface and its elements”. Symmetry-Basel 8(11): 1-29. DOI: 10.3390/sym11081014.
• 27. Sibilski K., A. Żyluk, M. Kowalski. 2015. „Simulation studies of micro air vehicle”. Journal of KONES 22(4): 243-252.
• 28. Sobota A., R. Żochowska, E. Szczepański, P. Gołda. 2018. “The influence of tram tracks on car vehicle speed and noise emission at four-approach intersections located on multilane arteries in cities”. Journal of Vibroengineering 20(6): 2453-2468.
• 29. Szczepański E., I. Jacyna-Gołda, J. Murawski. 2014. “Genetic algorithms based approach for transhipment hub location in urban areas”. Archives of Transport 31(3): 73-83.
• 30. Urbaniak M., E. Kardas-Cinal, M. Jacyna. 2019. “Optimization of energetic train cooperation”. Symmetry-Basel 11(9): 1175-1194. DOI: 10.3390/sym11091175.
• 31. Zieja M., H. Smoliński, P. Gołda. 2015. “Information systems as a tool for supporting the management of aircraft flight safety”. Archives of Transport 36(4): 67-76.
• 32. Żochowska R. 2014. “Selected issues in modelling of traffic flows in congested urban networks”. Archives of Transport 29(1): 77-89.