Designing and efficiency of database for simulation of processes in systems. Case study for the simulation of warehouse processes

Roland Jachimowski; Piotr Gołębiowski; Mariusz Izdebski; Dariusz Pyza; Emilian Szczepański

doi:10.5604/01.3001.0009.7380

Authors

Roland Jachimowski Warsaw University of Technology, Faculty of Transport, Warsaw, Poland Author
Piotr Gołębiowski Warsaw University of Technology, Faculty of Transport, Warsaw, Poland Author
Mariusz Izdebski Warsaw University of Technology, Faculty of Transport, Warsaw, Poland Author
Dariusz Pyza Warsaw University of Technology, Faculty of Transport, Warsaw, Poland Author
Emilian Szczepański Warsaw University of Technology, Faculty of Transport, Warsaw, Poland Author

DOI:

https://doi.org/10.5604/01.3001.0009.7380

Keywords:

SIMMAG3D, database, processes simulation in systems, warehouse processes, external transport, internal transport

Abstract

The basis of each IT system is data exchange both between individual modules of program and between program and user. The number of exchanged data and the number of operations on the data, which should be performed, require application of professional tools allowing for collecting and performing operations on multiple types of data. One of these tools are databases, which are an essential part of any IT system. With database designing are connected many decision problems which can occur both during the construction of database management system and at the stage of integration of entire user application with developed database. The article presents typical decision problems connected with designing of databases. These problems mainly concern sphere of information technology (including the programming language or recovery mechanism of database after the failure). Database architecture for typical IT system from the point of view possible paths for users were discussed, and role of catalogues played in development of database were presented. In addition, modular structure of the database, which was developed for the system SIMMAG3D for modelling and visualization of warehouse facilities in 3D was shown. This system is being developed under a project financed by the National Centre for Research and Development. We discussed in detail one of the essential elements in developed database - catalogues of means of external and internal transport, non-mechanical equipment and accessories which are essential from the point of view of the work load.

References

AMBROZIAK, T., JACHIMOWSKI, R., & PYZA, D, 2016. Analytical selection of devices for the task performance in warehouse facilities. In: P. ĆOSIĆ, G. BARIĆ, & G. ĐUKIĆ (Eds.), Conference Proceedings 8th International Scientific Conference Management of Technology – Step to Sustainable Production (pp. 1-8). Zagreb: Croatian Association for PLM.

BABAIAN, T., & LUCAS, W., 2013. Modeling Data for Enterprise Systems with Memories. Journal of Database Management, 24(2), 1-12.

BELIEN, J., & BOECK, L., 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.

BENEDIKT, M., BOURHIS, P., & LEY, C., 2015. Analysis of Schemas with Access Restriction. ACM Transactions on Database Systems, 40(1), 5.

BRANDEAU, M.L., & CHIU, S.S., 1989. An overview of representative problems in location research. Management Science, 35(6), 645–674.

CONNAN, S., 1993. SQL-The standard Handbook. London: McGraw-Hill Book Company.

CONNOLLY, T., & BEGG, C., 2005. Database systems: a practical approach to design, implementation, and management. Essex: Pearson Education.

DEY, B., BAIRAGI, B., SARKAR, B., & SANYAL, S.K., 2015. Warehouse location selection by fuzzy multi-criteria decision making methodologies based on subjective and objective criteria International Journal of Management Science and Engineering Management, 0, 1-17.

DONG, Y., & GOH, A., 1998. An intelligent database for engineering applications. Artificial Intelligence in Engineering, 12(1), 1-14.

ELMASRI, R., 2008. Fundamentals of database systems. Essex: Pearson Education.

FIJAŁKOWSKI, J., 2003. Transport wewnętrzny w systemach logistycznych. Wybrane zagadnienia. Warszawa: Oficyna Wydawnicza Politechniki Warszawskiej.

HASSELBRING, W., 2000. Information system integration. Communications of the ACM, 43(6), 32-38.

HUNT, V., 1996. Process Mapping. How to Reengineer Your Business Processes. New York: John Wiley & Sons.

JACHIMOWSKI, R., ŻAK, J., & PYZA, D., 2011. Routes Planning Problem with Heterogeneous Suppliers Demand. In: 21st International Conference on Systems Engineering (ICSEng), 434-437.

JACYNA, M., GOŁĘBIOWSKI, P., & LEWCZUK, K., 2016. Functions, relations and basic elements of database for the designing of storage facilities. In: P. ĆOSIĆ, G. BARIĆ, & G. ĐUKIĆ (Eds.), Conference Proceedings 8th International Scientific Conference Management of Technology – Step to Sustainable Production (pp. 1-8). Zagreb: Croatian Association for PLM.

JACYNA, M., KŁODAWSKI, M., & SZCZEPAŃSKI, E., 2016. Designing and management of storage facilities: The SIMMAG3D as an advanced decision support system. In: R. KERSYS (Eds.), Proceedings of 20th International Scientific Conference Transport Means (pp. 846 – 851). Kaunas: Publishing House "Technologija".

JACYNA, M., WASIAK, M., LEWCZUK, K., & KŁODAWSKI, M., 2014. Simulation model of transport system of Poland as a tool for developing sustainable transport. Archives of Transport, 31(3), 23-35.

Designing and efficiency of database for simulation of processes in systems. Case study for the simulation...

JACYNA-GOŁDA, I., 2015. Decision-making model for supporting supply chain efficiency evaluation. Archives of Transport, 33(1), 17-31.

JACYNA-GOŁDA, I., IZDEBSKI, M., & PODVIEZKO, A., 2016. Assessment of the efficiency of assignment of vehicles to tasks in supply chains: A case-study of a municipul company. Transport, 31(4) 1-9.

JACYNA-GOŁDA, I., IZDEBSKI, M., & SZCZEPAŃSKI, E., 2016. Assessment of the Method Effectiveness for Choosing the Location of Warehouses in the Supply Network. Challenge of Transport Telematics Springer, 640, 84-97.

JACYNA-GOŁDA, I., LEWCZUK, K., SZCZEPAŃSKI, E., & MURAWSKI, J., 2015. Computer Aided Implementation of Logistics Processes–Selected Aspects, In: Springer International Publishing, 67-80.

KISIELEWSKI, P., 2016. The system of IT support for logistics in the rail transport. Archives of Transport, 40(4), 39 – 50.

LEWCZUK, K., 2015. The concept of genetic programming in organizing internal transport processes. Archives of Transport, 34(2), 61-74.

MCFADDEN, F., PRESCOTT, M., & HOFFER, J., 1998. Modern database management. New Yersey: Pearson Education.

PYZA, D., & JACHIMOWSKI, R., 2015. Modelling of parcels' transport system. In: R. KERSYS (Eds.), Proceedings of 19th International Scientific Conference Transport Means (pp. 659 – 664). Kaunas: Publishing House "Technologija".

SZCZEPAŃSKI, E., JACYNA-GOŁDA, I., & MURAWSKI, J., 2014. Genetic algorithms based approach for transhipment hub location in urban areas. Archives of Transport, 31(3), 73-83.

VOSSEN, G., 1991. Data models, database languages and database management systems. Boston: Addison-Wesley Longman Publishing.

ZIEJA, M., SMOLIŃSKI, H., & GOŁDA, P., 2015. Information systems as a tool for supporting the management of aircraft flight safety. Archives of Transport, 36(4), 67 – 76.

ŻAK, J., JACHIMOWSKI, R., & GOŁĘBIOWSKI, P., 2016. Modelling of storage facilities using databases. In: R. KERSYS (Eds.), Proceedings of 20th International Scientific Conference Transport Means (pp. 772 – 777). Kaunas: Publishing House "Technologija".

ŻAK, J., & JACYNA-GOŁDA, I., 2013. Using Queue Theory to Analysis and Evaluation of the Logistics Centre Workload. Archives of Transport, 25-26(1-2), 117-135