FILLING DATABASE THROUGH COLLECTIONS
DOI:
https://doi.org/10.31649/1999-9941-2023-57-2-58-62Keywords:
collections, database, data insertion, performance, population, SQLAbstract
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.
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
-
PDF (Українська)
Downloads: 89