DEVELOPMENT OF AN ALGORITHM AND PROGRAM ON MySQL TO CREATE A DATABASE TO CONTROL THE TURNOVER OF RAILWAY AUTOMATION RELAYS

ABSTRACT

The article deals with the topic of database management at the enterprise of the railway industry, namely instrumentation, which receives and maintains elements of railway automation and telemechanic, where the most critical device (element) relays that control the state of track sections, an algorithm has been developed and a program has been written to create a database in modern conditions for the repair and maintenance of railway automation relays.

АННОТАЦИЯ

В статье рассмотрена тема управления БД на предприятии железнодорожной отрасли, а именно КИПиА, принимающая и обслуживающая элементы железнодорожной автоматики и телемеханики, где наиболее ответственные устройства (элементы) реле, контролирующие состояние участков пути. Разработан алгоритм и написана программа для создания базы данных в современных условиях ремонта и обслуживания реле железнодорожной автоматики.

Keywords: railway automation, relay, railway industry, algorithm, program

Ключевые слова: железнодорожная автоматика, реле, железнодорожная отрасль, алгоритм, программа.

1. MySQL

MySQL is a Relational Database Management System (“RDBMS”) [1]. It is used by most modern websites and web-based services as a convenient and fast-access storage and retrieval solution for large volumes of data [2]. A simple example of items which might be stored in a MySQL database would be a site-registered user’s name with associated password (encrypted for security), the user registration date, and number of times visited, etc [3]. MySQL can also be accessed using many tools [4]. It can be easily communicated with via PHP (PHP Hypertext Preprocessor), a scripting language whose primary focus is to manipulate HTML for a webpage on the server before it is delivered to a client’s machine [5]. A user can submit queries to a database via PHP, allowing insertion, retrieval and manipulation of information into/from the database [6].

Figure 1.  Database                                                            Figure 2. Database

Another table “ItemTbl” which is ItemTable where we can store our items.

private void FillCategory()

        {

            try

            {

                Con = new SqlConnection(Program.connStr);

                if (Con.State != ConnectionState.Open)

                    Con.Open();

                string query = "select * from Category";

                SqlDataAdapter sda = new SqlDataAdapter(query, Con);

                SqlCommandBuilder builder = new SqlCommandBuilder(sda);

                var ds = new DataSet();

                sda.Fill(ds);

                CatCh.DataSource = ds.Tables[0];

                CatCh.ValueMember = "Id";

                CatCh.DisplayMember = "Name";

            }

            catch (Exception Ex)

            {

                errorLabel.Text = Ex.Message;

                errorLabel.Visible = true;

            }

            finally

            {

                if (Con != null && Con.State != ConnectionState.Closed)

                {

                    Con.Close();

                    Con = null;

                }

How to Complete the Exercises After Installing XAMPP, you are good to go [7]. You need to open XAMPP control panel (usually in C:/xampp/) and start MySQL [8, 9].  The database in the exercises which you are going to practice today is the same database used in other database courses at the IT Learning Programme. The database is for a surgery called St. Giles Surgery [10-12]. This database contains 4 tables to hold patients, doctors, receptionists and appointments data. Figure 2 shows a schematic diagram of the database. The figure also shows table names (tblPatient, tblDoctors, tblReceptionist and tblAppointment) and field names (or columns) in each table. It also shows the data type for each field (for more information, see section 4.1). The links in the figure reflect the primary-foreign key relationships. The first few exercises will show how to use phpMyAdmin to write an SQL statement and how to use its GUI instead.

It is better if you connect to it using a different user. You can create MySQL users using phpMyAdmin by clicking on the Users tab then click on Add user. Enter user name, password and repeated password. You also need to specify that the host is local for the purpose of this course. At the bottom of the page you will find all the permissions which can be granted/revoked from a user. After choosing the required credentials, click on the Add user button. phpMyAdmin allows you to drop or edit a user. You can find how to do these from the Users tab. You can also add or delete a user using SQL.

Another table “BillTbl” which is BillTbl where we can control our items. For instance, the following two statements add a local MySQL user “sqluser” with a password “test”. The second statement drops the user. In any syntax given in this book, we use [.] to refer to an optional part of a statement. For example, in the statement above (Drop USER user_name [, user_name]), the part [, user_name] is optional and it can be omitted. If you include one of the optional clauses in a statement, do not type the [square bracket] symbols.

2. Result and conclusion

The coding part. Creating our own Warehouse

Figure 3. Warehouse management

2.1. It`s coding part

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace Warehouse

{

    public partial class Splash : Form

    {

        public Splash()

        {

            InitializeComponent();

        }

        int startPost = 0;

        private void timer1_Tick(object sender, EventArgs e)

        {

            startPost += 1;

            Myprogress.Value = startPost;

            PercentageLbl.Text = startPost + "%";

            if (Myprogress.Value == 100)

            {

                Myprogress.Value = 0;

                timer1.Stop();

                Login log = new Login();

                log.Show();

                this.Hide();

            }

         private void Splash_Load(object sender, EventArgs e)

        {

            timer1.Start();

        }

Here our first part ends and now it`s turn into the other main parts. After the loading of the window the other window appears (below).

On the basis of C# programming system and MySQL database management system of the Information System for the Execution of orders was developed. Each user or any other creator of the program can expand the capabilities of this program, widely use it and recommend it to other developers.

References:

1. Xalmedova L, Aliev R. Using new site templates based on ms sharepoint // Актуальные вопросы развития инновационно-информационных технологий на транспорте. – 2022. – Т. 1. – №. 1. – С. 17-20.
2. Алиев Р. М. и др. Методы расчёта коэффициентов рельсового четырехполюсника бесстыковых рельсовых цепей //Фундаментальная и прикладная наука: состояние и тенденции развития. – 2022. – с. 60-75.
3. Aliev, R.M. & Aliev, M.M. Mathematical model of the sensor for controling the condition of the track section with an adaptive receiver at the free condition of the controlled section Journal of Physics: Conference Series this link is disabled, 2021, 1973(1), 012021
4. Gulyamova M., Aliev R. Mysqlni ishlab chiqish va boshqarish vositalari // Актуальные вопросы развития инновационно-информационных технологий на транспорте. – 2022. – Т. 1. – №. 1. – С. 196-198.
5. R.M. Aliev, E.T. Tokhirov, M.M. Aliev Mode Choice Model of Movement in Different Modes Наука, Общество, Образование в современных условиях: монография /Под общ. ред. Г. Ю. Гуляева — Пенза: МЦНС «Наука и Просвещение». - 2022. - 160 с.
6. Aliev R. Model Coordinate System of Interval Regulation Train Traffic // International Conference on Computational Techniques and Applications. – Springer, Singapore, 2022. – С. 459-467.
7. Алиев Р. М. Концепция разработки бесстыковых рельсовых цепей // Интерактивная наука. – 2021. – №. 6. – С. 56-57.
8. Tokhirov E. T., Aliev R. M., Aliev M. M. Modern Means and Methods for Monitoring the Condition of Track Sections //Наука, Общество, Технологии: проблемы и перспективы взаимодействия в современном мире. – 2022. – С. 186-203.
9. Aliev R.M., Aliev M.M., Tokhirov E.T. Methods of Monitoring the Condition of Track Sections Наука, Общество, Технологии: проблемы и перспективы взаимодействия в современном мире: монография/ [Абакирова Э. М. и др.]. – Петрозаводск: МЦНП «Новая наука», 2022. – 438 с
10. Aliev R.M., Aliev M.M., Tokhirov E.T. Solution to Security on Rail Transportation with the Help of a Database Наука, Общество, Технологии: проблемы и перспективы взаимодействия в современном мире: монография/ [Абакирова Э. М. и др.]. – Петрозаводск: МЦНП «Новая наука», 2022. – 438 с
11. Arkatov, V.S. Rail chains of main railways / V.S. Arkatov, A.I. Bazhenov, N.F. Kotlyarenko. - M.: Transport, 1992, 384 p.
12. Aliev,  R. Trends in Improving Sensors for Controlling the Condition of Track Sections E3S Web of Conferences this link is disabled, 2021, 264, 05045
13. Gregor Theeg, Sergej Vlasenko Railway Signalling & Interlocking. International Compendium.Editors:. A DVV Media Group publication. Eurailpress, 2009, 448 p.