Specialized software platform for analysis of information in data stores

2023;
: pp. 137 - 148
1
Lviv Polytechnic National University, Computer Engineering Department, Ukraine
2
Lviv Polytechnic National University, Computer Engineering Department

This article presents the design, development, and evaluation of a specialized program for analyzing, developing aggregations of this data, and visualizing large volumes of data. The main goal of this program is to simplify data processing, speed up their analysis, and make it easier to write code for problems with large amounts of data. To achieve this goal, machine learning is used, as well as two repositories.

The program includes a convenient and easy-to-understand interface, servers that process various types of requests from users and transfer them to the database, and the database itself with two repositories.

The research methodology used in this study involves a thorough analysis of existing programs and methods for solving problems with large volumes of data. This analysis informed the design of the core features of the program, which were then subjected to extensive testing and evaluation. A user study was conducted to evaluate the effectiveness of programs with machine learning in comparison to programs that work without it, and a comparison of the speed of implementations of program development and data processing was conducted.

The results of the study show that this approach has accelerated program development, accelerated data processing, and made it more qualitative and accurate. The study concludes that the platform has significant potential to improve the performance of large businesses and that with the growth of multiple times of data and technology, without using this, the development of programs with similar logic will be completely ineffective.

  1. Katharina Morik and Peter Marwedel. (2023).Machine Learning under Resource Constraints – Funda- mentals. [Online]. Volume 1. Available: https://www.degruyter.com/document/doi/10.1515/9783110785944/html
  2. Katharina Morik and Wolfgang Rhode. (2023).Machine Learning under Resource Constraints - Discovery in Physics. [Online]. Volume 2. Available: https://www.degruyter.com/document/doi/10.1515/9783110785968/
  3. Katharina Morik, Jörg Rahnenführer and Christian Wietfeld, (2023).Machine Learning under Resource Constraints               –                Applications.                                   [Online].                   Volume                3.                Avaliable: https://www.degruyter.com/document/doi/10.1515/9783110785982/
  4. Ralph Kimball. (2008, January 10). The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling. [Online]. Available: https://dl.acm.org/doi/10.5555/2543973
  5. Andrii Kirk (2016). Data Visualisation: A Handbook for Data Driven Design. [Online]. Available: https://dl.acm.org/doi/book/10.5555/3002857
  6. Lowrence A. Rowe and Michael Stonebraker. (2018). The implementation of PostgreSQL. [Online]. Avail- able: https://dl.acm.org/doi/10.1145/3226595.3226639
  7. T. Bray, Ed., (2017, December). The JavaScript Object Notation (JSON) Data Interchange Format. [Online]. Available: https://doi.org/10.17487/RFC8259