Headings of the journal
"Educational Resources and Technologies"

Annotation: The article is devoted to the organization of psychological support for the professional development of students studying in the direction of “Psychological and pedagogical education”. The analysis of the possibilities of the psychological laboratory as a system tool of personal and professional development of students in the conditions of the organization of higher education is carried out. The theoretical and methodological foundations of the work of the psychological laboratory are presented, its role in promoting the forming of competitive, readyto- solve practical tasks in the upcoming professional activity of teachers-psychologists is revealed. The article systematizes the priority areas of work of the psychological laboratory: the development of effective communication skills, the development of tools for working in the field of child-parent relations, mastering technologies for setting and implementing goals, as well as the basics of psychological counseling. A range of areas of particular relevance for future teachers-psychologists and expanding the scope of tasks facing the staff of the psychological laboratory is outlined. It is shown that the systematic innovative, educational and educational activities of the psychological laboratory contribute to the forming of a scientific, methodological and practical foundation that provides psychological support for the development of a student’s personality.

Annotation: The article explores the morphology and semantics of information figurative models. A new interpretation is introduced into the concepts of “morphology” and “semantics” by establishing a connection between them for a certain type of models. The difference between the morphology of information figurative models and the morphological box and F. Zwicke’s approach is considered. The article develops the idea that morphology and semantics complement each other in figurative information models. The analysis of content and form as the ba- sis of semantics and morphology is carried out. From the standpoint of morphology, the content of uncertainty and fuzziness of information figurative models is revealed. The idea is developing that morphology is a formal characteristic, and semantics is an actual characteristic. It is shown that the structure of the model for abstract situations is formally a morphological indicator. It is noted that there are other situations for which the structure characterizes related semantics and morphology. In these cases, morphological modeling changes the semantics. A figurative analysis of certainty and uncertainty and the concept of “polysemy” is given. Conceptual mixing is considered, a number of procedures for this type of semantic modeling are given. It is noted that semantic and morphological modeling are related for figurative information models. The results of the methodological research are aimed at developing a systematic approach to the development of semantic figurative models in the information field.

Annotation: Responding to the challenges of a changing educational environment and meeting the needs of a new generation of university students, a foreign language teacher is in constant search of relevant didactic tools and technologies. The problem of the cognitive activity reducing of university students of non-linguistic majors in the study of foreign languages remains unresolved. Being a quality of an individual and an important incentive for learning, cognitive activity has a direct impact on the educational process and its result. This justifies the relevance of the research. Choosing the Telegram-channel as a technique for stimulating cognitive activity, the authors rely on studies of the socio-psychological characteristics of Generation Z students, their interests and life strategies. The authors pay special attention on the types of content and ways of presenting information in the Telegram-channel of the educational language group. The practical significance of the research lies in the reflection of the pedagogical experience of the Telegram-channel integration into the educational process, as well as the possibility of using the presented specific types of publications to stimulate the cognitive activity of students in the context of language disciplines.

Annotation: The article describes the problem of optimizing the execution plans of analytical SQL queries using machine learning. Currently, none of the popular database management systems (DBMS) uses an optimizer based on machine learning. At the same time, it is machine learning that can solve the known problems of standard optimizers used in most modern DBMS. In this work, the disadvantages of existing approaches to planning analytical SQL queries are considered in detail. There is a lack of research on the use of well-known machine learning-based approaches to optimizing SQL queries in analytical databases. The relevance of solving the problem of optimizing SQL query execution plans for massively parallel column-based DBMS is shown. The paper provides a justification for the choice of specific methods based on machine learning. The modifications made are described, in particular, an approach to the selection of execution plans for analytical SQL queries based on the collection of a training sample and the selection of target values is proposed. The problem of implementing a machine learning-based approach is considered. Possible problems with the training of the model and its operation in fundamentally new situations arising during training are highlighted. The ways of their solution are proposed. Original experiments have been carried out with various methods of optimizing SQL queries in relation to a massively parallel column DBMS. It is shown that the proposed modifications of existing solutions significantly improve the speed of query execution.

Annotation: This study considers the metaphors used in the Russian and Chinese worldviews to characterize the teaching profession. The purpose of the work is the presentation of the diachronic and synchronic analysis of the metaphorical portrait of the teacher, starting with the works of Ya.A. Komenskiy to the present day, as well as the results of an empirical study of the reflective potential of the portrait of a teacher in the process of educating foreign language teachers. The article analyzes the views not only on the positive aspects of the teacher’s activity, but also critically examines his/her possible negative impact on the development of the personality of students. In the empirical part, the emphasis is on the results of a survey of foreign language teachers who have taken refresher courses in this area. The results of the study demonstrate the versatility of the concept of “teacher” in the Russian and Chinese worldviews, as well as the variability of respondents’ opinions regarding the role of the teacher in the modern model of teacher training. The results obtained can be interpreted for further projecting of a program for the professional development of foreign language teachers.