ETL and Data Management

ETL and Data Management

ETL Detailed Discussion

The system of ETL is in general utilized to join in the data from numerous applications in the systems, characteristically established as well as reinforced by a number of existing vendors or others held on distinct hardware of the computer. The distinct systems comprising the actual data is most repeatedly accomplished as well as run by a number of employees. Referring to example of system used for cost accounting, it is evident that this system would thereby collate the information flow from payroll, transactions as well as acquiring. In the process of ETL, the initial phase comprise of the data extraction from the number of sources in the existing systems. In numerous circumstances this refers to the actual challenging factor of the process of ETL, subsequently the data extraction appropriately initiate the efficacy platform for by what means succeeding developments would further advance. The second phase of transformation in ETL process implies a chain of guidelines along with the necessary functions applied on the data after extraction from its source to develop the output data for effectively loading (Wyatt, L., Caufield, B., & Pol, 2009). A number of sources of data need precisely slight or sometimes absolutely no data manipulation. The last phase of data loading on the target end typically referred as the data warehouse. On the basis of the necessities of the businesses, the ETL overall process differs extensively. A number of data warehouse possibly will overwrite the present data by means of collective information; commonly, appraising the data which is extracted carried out based on the frequency of day-to-day, week on week, or month on month.

ETL and ELT

Con...

... middle of paper ...

...adis, P., Karagiannis, A., Tziovara, V., Simitsis, A., & Hellas, I. (2007). Towards a benchmark for ETL workflows.

Vassiliadis, P., Simitsis, A., & Skiadopoulos, S. (2002, January). On the logical modeling of ETL processes. In Advanced Information Systems Engineering (pp. 782-786). Springer Berlin Heidelberg.

Hellerstein, J. M., Stonebraker, M., & Caccia, R. (1999). Independent, open enterprise data integration. IEEE Data Eng. Bull., 22(1), 43-49.

Rahm, E., & Do, H. H. (2000). Data cleaning: Problems and current approaches. IEEE Data Eng. Bull., 23(4), 3-13.

Wyatt, L., Caufield, B., & Pol, D. (2009). Principles for an ETL Benchmark. InPerformance Evaluation and Benchmarking (pp. 183-198). Springer Berlin Heidelberg.

Wang, Y. Z., & Li, H. B. (2002). Design and Implementation of Data ETL Tools Basing on OLE DB. MINIMICRO SYSTEMS-SHENYANG-, 23(4), 453-455.