Real Time Delta Extraction Based on Triggers to Support Data Warehousing

Download Now
Provided by: The International Conference on Parallel and Distributed Computing, Applications and Technologies (PDCAT)
Topic: Data Management
Format: PDF
Now-a-days large corporations require integrated data from diverse sources, leading to the use of data warehouse architectures for this purpose. To bypass problems related to the use of computational resources to process large volumes of data, an ETL (Extract, Transform and Load) technique with zero latency can be used, that works by constantly processing small data loads. Among the extraction techniques of the zero latency ETL are the use of logs, triggers, materialized views and timestamps. This paper proposes a structure capable of performing this task by means of triggers and a tool developed for the automatic generation of the SQL (Structured Query Language) code to create these trigger, besides showing its performance and comparing it to other techniques.
Download Now

Find By Topic