title: Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° ÑÐµÑÐ²ÐµÑÐ½Ð¾Ð¹ ÑÐ°ÑÑÐ¸ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ñ ÑÐ±Ð¾ÑÐ° Ð¸ Ð¾Ð±ÑÐ°Ð±Ð¾ÑÐºÐ¸ ÑÐ°Ð±Ð»Ð¸ÑÐ½ÑÑ Ð´Ð°Ð½Ð½ÑÑ
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Development of the server part of the web application Â«Information system for collecting and processing tabular dataÂ»
Creators: name: ÐÐµÐ¾Ð½Ð¾Ð², Ð¡ÐµÑÐ³ÐµÐ¹
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2024
Subjects: ÑÐ°Ð±Ð»Ð¸ÑÐ½ÑÐµ Ð´Ð°Ð½Ð½ÑÐµ
Ð²ÐµÐ±-Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ðµ
Java
Spring
PostgreSQL
Minio
ÑÑÐµÐ½Ð°ÑÐ¸Ð¸ Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ð¸
Ð¿ÑÐ°Ð²Ð° Ð´Ð¾ÑÑÑÐ¿Ð°
tabular data
web application
PostreSQL
automation scripts
access rights

description: Ð¦ÐµÐ»Ñ ÑÐ°Ð±Ð¾ÑÑ â ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°ÑÑ Ð¿ÑÐ¾ÑÐ¾ÑÐ¸Ð¿ ÑÐµÑÐ²ÐµÑÐ½Ð¾Ð¹ ÑÐ°ÑÑÐ¸ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ñ Ð´Ð»Ñ ÑÐ¿ÑÐ¾ÑÐµÐ½Ð¸Ñ Ð¸ Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ð¸ Ð¿ÑÐ¾ÑÐµÑÑÐ° ÑÐ±Ð¾ÑÐ° Ð¸ Ð¾Ð±ÑÐ°Ð±Ð¾ÑÐºÐ¸ ÑÐ°Ð±Ð»Ð¸ÑÐ½ÑÑ Ð´Ð°Ð½Ð½ÑÑ Ñ ÑÐµÐ»ÑÑ Ð¿Ð¾Ð²ÑÑÐµÐ½Ð¸Ñ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ ÑÐ°Ð±Ð¾ÑÑ, Ð° ÑÐ°ÐºÐ¶Ðµ Ð³Ð°ÑÐ°Ð½ÑÐ¸ÑÐ¾Ð²Ð°ÑÑ Ð·Ð°ÑÐ¸ÑÑ Ð´Ð°Ð½Ð½ÑÑ Ð¾Ñ Ð½ÐµÑÐ°Ð½ÐºÑÐ¸Ð¾Ð½Ð¸ÑÐ¾Ð²Ð°Ð½Ð½Ð¾Ð³Ð¾ Ð´Ð¾ÑÑÑÐ¿Ð°. Ð ÑÐ¾Ð´Ðµ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ¸ ÑÐµÑÐ°Ð»Ð¸ÑÑ ÑÐ»ÐµÐ´ÑÑÑÐ¸Ðµ Ð·Ð°Ð´Ð°ÑÐ¸: 1. ÐÐ±Ð·Ð¾Ñ Ð¸ ÑÑÐ°Ð²Ð½ÐµÐ½Ð¸Ðµ Ð°Ð½Ð°Ð»Ð¾Ð³Ð¾Ð²; 2. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¾Ð³Ð¾ Ð·Ð°Ð´Ð°Ð½Ð¸Ñ; 3. ÐÑÐ±Ð¾Ñ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸ÑÐµÑÐºÐ¾Ð³Ð¾ ÑÑÐµÐºÐ°; 4. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° ÑÐµÑÐ²ÐµÑÐ½Ð¾Ð¹ ÑÐ°ÑÑÐ¸ Ð²ÐµÐ±-Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ; 5. ÐÐµÐ¼Ð¾Ð½ÑÑÑÐ°ÑÐ¸Ñ ÑÐ°Ð±Ð¾ÑÐ¾ÑÐ¿Ð¾ÑÐ¾Ð±Ð½Ð¾ÑÑÐ¸ Ð¸ ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ ÑÐ¸ÑÑÐµÐ¼Ñ; 6. ÐÑÐµÐ½ÐºÐ° Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ÑÑÐ¸ Ð´Ð°Ð»ÑÐ½ÐµÐ¹ÑÐµÐ³Ð¾ ÑÐ°Ð·Ð²Ð¸ÑÐ¸Ñ Ð²ÐµÐ±-Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸Ð»Ð°ÑÑ Ð½Ð° ÑÐ·ÑÐºÐµ Java Ð² IntelliJ IDEA Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ ÑÑÐµÐ¹Ð¼Ð²Ð¾ÑÐºÐ° Spring. ÐÐ»Ñ ÑÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¾ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»ÑÑ Ð¸ ÑÐ°Ð±Ð»Ð¸ÑÐ°Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð»Ð°ÑÑ Ð¡Ð£ÐÐ PostgreSQL. ÐÐ»Ñ ÑÑÐ°Ð½ÐµÐ½Ð¸Ñ ÑÐ°Ð±Ð»Ð¸ÑÐ½ÑÑ Ð´Ð°Ð½Ð½ÑÑ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð»Ð¾ÑÑ ÑÐ°Ð¹Ð»Ð¾Ð²Ð¾Ðµ ÑÑÐ°Ð½Ð¸Ð»Ð¸ÑÐµ Minio. Ð ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐµ Ð±ÑÐ» ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½ Ð¿ÑÐ¾ÑÐ¾ÑÐ¸Ð¿ ÑÐµÑÐ²ÐµÑÐ½Ð¾Ð¹ ÑÐ°ÑÑÑ Ð²ÐµÐ±-Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ñ ÑÐ±Ð¾ÑÐ° Ð¸ Ð¾Ð±ÑÐ°Ð±Ð¾ÑÐºÐ¸ ÑÐ°Ð±Ð»Ð¸ÑÐ½ÑÑ Ð´Ð°Ð½Ð½ÑÑ. ÐÑÐ»Ð¸ ÑÐµÐ°Ð»Ð¸Ð·Ð¾Ð²Ð°Ð½Ñ ÑÑÐ½ÐºÑÐ¸Ð¸ Ð´Ð»Ñ Ð²Ð·Ð°Ð¸Ð¼Ð¾Ð´ÐµÐ¹ÑÑÐ²Ð¸Ñ Ñ ÑÐ°Ð±Ð»Ð¸ÑÐ°Ð¼Ð¸, ÑÑÐµÐ½Ð°ÑÐ¸Ð¸ Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ð¸ ÑÐ±Ð¾ÑÐ° Ð´Ð°Ð½Ð½ÑÑ, ÑÐ¸ÑÑÐµÐ¼Ð° Ð¿ÑÐ°Ð² Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð±Ð»Ð¸ÑÐµ, Ð° ÑÐ°ÐºÐ¶Ðµ Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ð¾ÑÑÑ Ð¸Ð¼Ð¿Ð¾ÑÑÐ° Ð¸ ÑÐºÑÐ¿Ð¾ÑÑÐ° Ð´Ð°Ð½Ð½ÑÑ Ð² Excel. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½Ð¾Ðµ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ðµ ÑÑÐµÐ´ÑÑÐ²Ð¾ Ð±ÑÐ»Ð¾ ÑÑÐ¿ÐµÑÐ½Ð¾ Ð¿ÑÐ¾ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¾.
description: The purpose of the work is to develop a prototype of server part of an information system to simplify and automate the process of collecting and processing tabular data to increase work efficiency, as well as to guarantee data protection from unauthorized access. During the development, the following tasks were solved: 1. Review and comparison of analogues; 2. Development of technical specifications; 3. Choosing a technology stack; 4. Development of the backend of the web application; 5. Performance demonstration and system testing; 6. Assessment of the possibility of further development of the web application. The application was developed in Java in IntelliJ IDEA using the Spring framework. The PostgreSQL database was used to store data about users and tables. The Minio file storage was used to store tabular data. As a result, the prototype of the server part of the web application of the information system for collecting and processing tabular data was developed. Functions for interacting with tables, automation scenarios for data collection, a system of access rights to the table, as well as the ability to import and export data to Excel were implemented. The developed software tool has been successfully tested.