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

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.

Keywords

• SIMMAG3D
• database
• processes simulation in systems
• warehouse processes.