Development of a data indexing system for the production, economic and labor sectors of the penitentiary system
Abstract
Development of a data indexing system for the production, economic and labor sectors of the penitentiary system
Incoming article date: 27.01.2024The development of business analytics, decision-making and resource planning systems is one of the most important components of almost any enterprise. In these matters, enterprises and production facilities of the penitentiary system are no exception. The paper examines the problem of the relationship between existing databases and statistical reporting forms of the production, economic and labor sectors of the penitentiary system. It has been established that indirectly interrelated parameters are quite difficult to compare due to different data recording systems, as well as approved statistical forms. One of the first steps in solving this problem could be the introduction of a generalized data indexing system. The paper discusses data indexing systems, the construction of their hierarchical structures, as well as the possibility of practical application using SQL. Examples of implementation using ORM technology and the Python language are considered.
Keywords: databases, indexing, ORM, SQL, Python, manufacturing sector, economic indicators, penitentiary system