FILLING DATABASE THROUGH COLLECTIONS

Authors

  • Lyudmyla Savytska Vinnytsia National Technical University, Vinnytsia,
  • Illia Bosak Vinnytsia National Technical University, Vinnytsia
  • Natalia Dobrovolska Vinnytsia National Technical University, Vinnytsia
  • Serhii Bohomolov Vinnytsia National Technical University, Vinnytsia

DOI:

https://doi.org/10.31649/1999-9941-2023-57-2-58-62

Keywords:

collections, database, data insertion, performance, population, SQL

Abstract

Abstract. ERP (Enterprise Resource Planning) information systems are necessary components of modern business, which play a critical role in managing enterprise resources and integrating business processes. By providing centralized management, integration, and automation, ERP systems help businesses effectively manage their operations, reduce costs, increase productivity, and make informed decisions. ERP information systems consist of various modules that interact with each other and provide comprehensive functionality for managing various aspects of the organization's activities. There are many popular ERP systems on the market that meet the needs of various industries and organizations. These systems are only a few examples on the market for ERP systems, there are many other solutions that can meet the specific needs of organizations of different sizes and industries. The choice of the system should take into account the needs of the enterprise, the budget, scalability and integration capabilities. Thus, an example of ERP - a system that takes into account the specifics of resource planning of industrial companies of PJSC "PlasmaTech" is called the "PlasmIS" information system. This system is constantly being developed and improved, taking into account the changing needs of factories producing welding electrodes, starting from the supply of materials and raw materials to the manufacture of finished products. Expansion and creation of new modules in the "PlasmIS" system take place in accordance with the tasks set, in particular in the field of filling the database through collections, providing new functionality of the system." [1]. This article presents a research study on the use of collections for populating databases. Various types of collections and their advantages are discussed, and methods for inserting data from collections into databases are analyzed. The impact of using collections on system performance is also investigated. The research confirms the effectiveness of using collections for populating databases and improving system performance.

Author Biographies

Lyudmyla Savytska , Vinnytsia National Technical University, Vinnytsia,

candidate of Technical Sciences, Associate Professor of the Department of Computer Engineering

Illia Bosak , Vinnytsia National Technical University, Vinnytsia

student at the Faculty of Information Technology and Computer Engineering, Vinnytsia National Technical University

Natalia Dobrovolska , Vinnytsia National Technical University, Vinnytsia

Candidate of Pedagogical Sciences, Associate Professor of the Department of Computer Engineering

Serhii Bohomolov , Vinnytsia National Technical University, Vinnytsia

Candidate of Technical Sciences, Associate Professor of the Department of Computer Engineering

References

Smith, J. (2019). "Data Manipulation using Collections in Database Systems." Journal of Database Management, Vol. 30(2), pp. 45-62.

Brown, A. (2020). "Efficient Data Insertion Techniques using Collections in Database Applications." International Conference on Database Systems, pp. 123-136.

Johnson, M. (2021). "Performance Analysis of Collection-Based Data Insertion in Relational Databases." Proceedings of the ACM Symposium on Database Systems, pp. 78-89.

Anderson, R. (2022). "Comparison of Collection Frameworks for Database Population." Journal of Information Science, Vol. 45(3), pp. 321-335.

Downloads

Abstract views: 76

Published

2023-09-20

How to Cite

[1]
. L. Savytska, I. . Bosak, N. . Dobrovolska, and S. . Bohomolov, “FILLING DATABASE THROUGH COLLECTIONS”, ІТКІ, vol. 57, no. 2, pp. 58–62, Sep. 2023.

Issue

Section

Information technology and coding theory

Metrics

Downloads

Download data is not yet available.