ETL TECHNOLOGY AS AN APPROACH TO DATA INTEGRATION
Journal Title: Международный научный журнал "Интернаука" - Year 2018, Vol 2, Issue 19
Abstract
This article is devoted to the study of the corporate data integration problem. The aim of the work is the analysis of the existing ways of big data integration and implementation of a software system that allows the implementation of the full cycle of data extraction, transformation, and load (ETL). Most of the information required for analytical applications stored in the corporate management systems, databases and individual user files. Data integration tools provide the necessary infrastructure for converting disparate data sources into a single resource. When the company starts an integrated enterprise data warehouse (EDW) development, the number of data streams increases many times. For efficient use of EDW, it requires data on all aspects of the enterprise operations and the transfer of large volumes of detailed data from each source system to the warehouse. The main problem of data integration is the use of a large number of tools and technologies for solving integration problems in organizations. However, the effectiveness of such solutions drops with an increase in data streams quantity. In order to ensure effective integration, tools that can provide a general overview and management of all data flows are needed. Tools for integration should work equally effective with all DBMS used by the organization, data sources, messaging systems, etc. The integration method developed and presented in the article is designed for small enterprises that work with large data volumes that require low cost, easy to deploy and scale solutions. The features of work with data for small enterprises were investigated. Based on them, the requirements for the input data, as well as methods of their filtration and cleaning are formulated. The result of the work is a developed algorithm and data loading procedure into a prepared data warehouse.
Authors and Affiliations
Andriy Zhmurkevych, Iryna Rozhok
Keywords
Related Articles
- EP ID EP611749
- DOI -
- Views 71
- Downloads 0
THE ORGANIZATIONAL FEATURES OF HUNTING AND FISHING TOURISM
Theoretical aspects of organization, specific and distinctive features of the hunting and fishing tourism are explored.
MORPHOLOGICAL CHANGES IN SPLEEN IN TERMS OF CHRONIC NEOPLASTIC ENDOTOXEMIA
The features of the morphological changes in the spleen in terms of the chronic neoplastic endotoxemia, caused by induced colorectal cancer, were investigated.
ORGANIZATION AND METHODICAL APPROACHES TO THE COMPANY BANK’S FINANCIAL STATEMENTS BASIS ON THE BASIS OF THE EXISTING BANK ACCOUNTING
The article is a study of organizational and methodical approaches to the preparation of financial statements of a commercial bank on the basis of the current banking system. It is noted that the purpose of the general p...
INSTITUTE OF RECONCILIATION OF THE PARTIES IN CRIMINAL LAW OF UKRAINE AND FOREIGN COUNTRIES: COMPARATIVE AND LEGAL ASPECT
Legal regulation of institute of reconciliation of the parties in the different countries of the world is analyzed in the article. Two groups of the countries depending on a way of fixing of reconciliation of the parties...
DEVELOPMENT OF SELF-CONSCIOUSNESS OF STUDENTS-PSYCHOLOGISTS AS A GUARANTEE OF THEIR SUCCESS IN PROFESSIONAL ACTIVITY
The urgency of the problem under investigation is determined by the interest of psychological science in the phenomenon of self-consciousness. This problem is of special importance in connection with the fact that modern...