DPK Railways SQL

A general description of the system and its intended use

DPK Railways SQL is an Integrated Management System of teams traction and teams conductors. It is designed for railway that handles passengers transport and freight. The main goal the system is embracing most of the issues related to work performed in the transport and service sectors of the railway activity. The specification of dispersed structure imposes the need for networking of multi-stations.

The system is based on solution: Client – Server. Database is located on the server, as well as calculations concerned on optimization are performed on the server, and applications are installed client workstations. Continuous work security requirements in the railway companies incline to use dispersed system with data replication. The system enables interaction with other systems in the company in terms of data import and export. DPK Railways SQL is an ergonomic tool that performs quick, efficient and effective decision-making based on data generated in the system.

System Architecture

The system is based on dispersed network of servers. In practice, this means the assumption of one server to one section of company. The databases on the server is used in each of the modules which are installed on user workstations.

Sectional Server processes data required to create schedules of crews work, manage that work and vehicles on the section level. The section server allows to handle any number of sectional workstations within one section, but the verification is done according to number of simultaneous users of the system.

Company Server

Each SECTIONAL SERVER within the company is a connected to the COMPANY SERVER. On the company server in database there is collected data for the entire company. This data includes a database of vehicles and employees. This data is performed in statistic form, so it is not required to perform constant data exchange between servers. Once a day (or on the request of authorized user) the is proceeded update of information between servers. Data management at the server level is possible through Vehicles and Employees/Drivers Modules. Some of activities performed in sections requires approval of Administration Department. Data from servers are replicated on central server where data are collected from all company.

Central Server

Data management at the central server is also possible through the module Vehicles and Employees/Drivers. Some activities in companies require approval of Administration Department. That data includes a database of vehicles and employees. This data is performed in statistic form, so it is not required to perform constant data exchange between servers. Once a day (or on the request of authorized user) the is proceeded update of information between servers. This solution provides the maximum security of system and its low sensitivity to interference due to failure or failure of IT infrastructure.