Prischepa Vladimir

Faculty of computer science and technology

Department of computer engineering

Speciality "Computer systems and networks"

Research and development of optimal queries for multi related and large amounts data in relational databases. Development workstation "Teacher's workload" in the ACS DonNTU

Scientific adviser: Cand. of Tech. Sciences, Assistant professor Krasnokutskiy Vladimir

Russian flag
Ukrainian flag
Great Britain flag
Abstract

Content

  1. Goals and objectives
  2. Relevance and motivation
  3. Scientific novelty
  4. Planned practical results
  5. Conclusions
  6. References

Goals and objectives

The purpose of the master's work is the development of the software system to automate the formation of university workload, namely - automation of teacher’s workload.

Forming of the workload is performed sequentially and consists of the following stages:

  • forming workload of departments;
  • forming workload of teachers;
  • forming of class schedules.

Team contains three developers. Command task is the design of software package and coordination of data structures for the exchange of information among package units.

Master's objective is to design and develop a single module providing a different set of rights and user interfaces for different groups: administrators, teachers, staff of educational-methodical department, decision-makers of the Department.

Relevance and motivation

Workload formation is a time consuming task. The whole process takes several months, from the beginning - academic plan development, to the end - workload approval. All data for the documents, records and reports are generated manually, which involves a large number of errors due to human error, errors search and fixing takes a significant part of the total time.

The disadvantages of the scheme manual distribution of the workload at the departments are:

  • low flexibility of the method;
  • high complexity and time consuming of the distribution process;
  • a high probability of error in the calculations;
  • high complexity of check of calculation results;
  • lack of means of information protection;
  • lack of mechanisms for the organization of joint access to the results [10].

Scientific novelty

At the beginning of the development was assumed that the module for forming teacher’s workload will be program with user friendly interface that will help a decision-makers of the Department to distribute academic disciplines between the teachers of the department. When searching for information on the work it was found that artificial intelligence techniques have not been applied earlier for a similar problem. It was suggested to develop and use intelligent decision support system (DSS). The idea is that the system should provide advice in the distribution of the academic disciplines between the teachers of the department, analyzing their requests which they make before the distribution of disciplines and such factors as the degree, title, work experience, age and others.

For the analysis and decision-making are different methods used in the DSS:

  • information retrieval is the activity of obtaining information resources relevant to an information need from a collection of information resources. Searches can be based on or on full-text indexing or other content-based;
  • data mining is the computational process of discovering patterns in large data sets involving methods at the intersection of artificial intelligence, machine learning, statistics, and database systems;
  • case-based reasoning, broadly construed, is the process of solving new problems based on the solutions of similar past problems;
  • genetic algorithm is a search heuristic that mimics the process of natural selection;
  • artificial neural networks (ANN) are a family of models inspired by biological neural networks which are used to estimate or approximate functions that can depend on a large number of inputs and are generally unknown.

If the result is incorrect, the person in charge of the process of distribution of academic disciplines, will be able to correct the results of the system. This implies that the system must be able to training to prevent a repetition of the error the next time it is used.

Among the methods described above, the property of self-learning has artificial neural networks. The possibility of training - one of the major advantages of neural networks over conventional algorithms [9]. Neural network training is to find the coefficients of the connections between neurons. In the process of training the neural network is able to identify complex relationships between inputs and outputs and perform generalization. This means that in case of successful learning network will be able to return the correct result on the basis of data that were missing in the training set, and the incomplete and / or "noisy" data, or partially corrupted data [9].

Taking into account all of the above, it can be concluded that the most suitable system implementation to solve the problem, will be system based on artificial neural networks.

With the help of ANN to solve a wide range of tasks:

  • pattern recognition and classification;
  • clustering;
  • forecasting;
  • approximation;
  • data analysis;
  • decision-making and management.

In all described above classes of problems in practice successfully used perceptron (Fig. 1). Perceptron is one of the first models of the neural network proposed by Frank Rosenblatt in 1957 [4]. Perceptron has a high degree of flexibility, successfully trained and can deal with a wide range of complex problems.

Described problem belongs to the class of decision-making tasks. In solving this problem, there is no need to use complex models of neural networks, such as the Elman network, which is used to solve problems in real time, for example, moving object management.

Figure 1 - The two-layer perceptron with n inputs, hidden layer with a neurons and r outputs

Figure 1 - The two-layer perceptron with n inputs, hidden layer with a neurons and r outputs

Figure 1 shows the structure of a classical perceptron. A set of input - a vector X, the result - a vector Y, S-layer (sensor) - network inputs, their number depends on the problem, A-layer (association) - an associative or a hidden layer, selecting the required number neurons of this layer is the main task of designing a neural network, R-layer (reaction) - the output layer, or layer response, the number of network outputs depends on the specific problem. Each sensor S-layer is associated with each element of the A-layer synapses (interneurons connections), wan - separately taken the synapse of a plurality of layers between the S and A, in the same way there is communication between the layers of neurons A and R.

To train the ANN will use back propagation method. For R-layer neurons has the following formula [4]:

Formula 1 (1)

Formula 2 (2)

Formula (1) describes the change of weighting coefficients when training a network using the Hebb rule, the following notation is used herein:

  • Δwij – change in weight of the corresponding synapse;
  • δi – error of i-output of network;
  • η – learning rate factor;
  • r – number of network outputs;
  • n – the number of network inputs.

Formula (2) describes the calculation of the network output error (delta rule), the following symbols are used in it:

  • δi – error of i-output of network;
  • ei – expected net output value;
  • yi – the actual value of the output;
  • r – number of network outputs.

For A-layer neurons has formula [2]:

Formula 4 (3)

Formula 5 (4)

Figure 2 - Training perceptron by back propagation method

Figure 2 - Training perceptron by back propagation method
(animation: 7 frames, 10 cycles of repetition, size 509x540, 138 KB)

Planned practical results

Result of the work will be the decision support system based on artificial neural network. After the end of the training process for each synapse of network will installed some weighting. The magnitude of the weight coefficient can be regarded as the influence level of a given input parameter to the result of individual neurons and the network as a whole. Due to the inherent properties of generalized artificial neural networks after successful training, possible to carry out an experiment to determine the significance of the individual parameters for the result. In operating mode, the input is a training vector with one modified parameter, the error value will show the effect of the corresponding parameter for the result [5]. These experiments allow us to identify the most important set of parameters used for distributing workload for academic discipline and the most important characteristics of teachers.

Conclusions

Goals and objectives of the master's work were formed. For development software package for formation workload for teachers of the department, it was decided to use decision support system based on artificial neural network. A review of such developments showed that the artificial intelligence technology previously not applied to the task of forming the workload for universities.

References

  1. Джонс М.Т. Программирование искусственного интеллекта в приложениях / М. Тим Джонс; Пер. с англ. Осипов А.И. – М.: ДМК Пресс, 2004. – 312 с.
  2. Ясницкий Л.Н. Введение в искусственный интеллект: учебное пособие для студ. высш. учеб. заведений / Л.Н. Ясницкий – 2-е изд., испр. – М.: Издательский центр «Академия», 2008. – 176с.
  3. Ясницкий Л.Н. Использование методов искусственного интеллекта в изучении личности серийных убийц / Л.Н. Ясницкий, С.В. Ваулева, Д.Н. Сафонова, Ф.М. Черепанов // Криминологический журнал Байкальского государственного университета экономики и права. – 2015. – Т. 9, № 3. – С. 423-430.
  4. Хайкин С. Нейронные сети: полный курс, 2-е издание. : Пер. с англ. – М. : Издательский дом «Вильямс», 2006. – 1014 с.
  5. Ясницкий Л.Н., Михалева Ю.А., Черепанов Ф.М. Возможности методов искусственного интеллекта для выявления и использования новых знаний на примере задачи управления персоналом // International Journal of Unconventional Science. Журнал Формирующихся Направлений Науки. 2014. Вып. 6; URL: http://www.unconv-science.org/n6/yasnitsky/
  6. Султанова С.Н., Тархов С.В. Модели и алгоритмы поддержки принятия решений при распределении учебной нагрузки преподавателей // Вестник УГАТУ. Уфа: УГАТУ, 2006 T. 7, №3 (16). C. 107-114; URL: http://cyberleninka.ru/article/n/modeli-i-algoritmy-podderzhki-prinyatiya-resheniy-pri-raspredelenii-uchebnoy-nagruzki-prepodavateley
  7. Википедия свободная энциклопедия. Метод обратного распространения ошибки // Википедия. [Эелектронный ресурс] – Режим доступа: https://ru.wikipedia.org/wiki/Метод_обратного_распространения_ошибки
  8. Пользователь Noonv. Нейронная сеть – обучение ИНС с помощью алгоритма обратного распространения. // RoboCraft [Электронный ресурс] – Режим доступа: http://robocraft.ru/blog/algorithm/560.html
  9. Википедия свободная энциклопедия. Искусственная нейронная сеть // Википедия. [Эелектронный ресурс] – Режим доступа: https://ru.wikipedia.org/wiki/Искусственная_нейронная_сеть
  10. Калюжный Н.В. Анализ процесса распределения учебной нагрузки профессорско-преподавательского состава на кафедрах // Science Time. – 2015. – № 6 (18) / 2015. – С. 199-202. URL: http://cyberleninka.ru/article/n/analiz-protsessa-raspredeleniya-uchebnoy-nagruzki-professorsko-prepodavatelskogo-sostava-na-kafedrah

Important notice

This abstract refers to a work that has not been completed yet. Estimated completion date: June 2017 Contact author after that date to obtain complete text.