Title :
A new tool for ETL process
Author :
Zuyi Chen ; Taixiang Zhao
Author_Institution :
Dept. of Found., First Aeronaut. Inst. of the Air Force, Xinyang, China
Abstract :
The data warehouse has increasingly become a focus of the database industry. A data warehouse is a collection of data from different sources that supports analytical querying. It constitutes the background to enable business intelligence solutions. In order to supply a decisional database, meta-data is needed to enable the communication between various function areas of the warehouse and an ETL (Extraction, Transformation, and Load) tool is needed to define the warehousing process. In this paper, we will use a model to create an active ETL tool. In our approach, we use queries to achieve the warehousing process. SQL queries will be used to represent the mapping between the source and the target data.
Keywords :
SQL; data warehouses; meta data; query processing; ETL process; SQL query; Structured Query Language; business intelligence solution; data collection; data mapping; data warehouse; data warehousing process; database industry; decisional database; extraction-transformation-load process; meta data; Data mining; Data warehouses; Databases; Finite element methods; Loading; Unified modeling language; Warehousing; SET; SQL query; data warehouse;
Conference_Titel :
Image Analysis and Signal Processing (IASP), 2012 International Conference on
Conference_Location :
Hangzhou
Print_ISBN :
978-1-4673-2547-9
DOI :
10.1109/IASP.2012.6425038
