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

fYear

2012

fDate

9-11 Nov. 2012

Firstpage

1

Lastpage

5

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;

fLanguage

English

Publisher

ieee

Conference_Titel

Image Analysis and Signal Processing (IASP), 2012 International Conference on

Conference_Location

Hangzhou

Print_ISBN

978-1-4673-2547-9

Type

conf

DOI

10.1109/IASP.2012.6425038

Filename

6425038