Title :
ETL Function Realization of Data Warehouse System Based on SSIS Platform
Author_Institution :
Coll. of Comput. Sci. & Inf. Technol., Guizhou Univ., Guiyang, China
Abstract :
The application system constructed by use of data warehouse is a new form of decision-making support system. The data warehouse system involves a great deal of time consumption in its building process and problems often occur in its daily operation, among which the most common one is the realization of ETL (Extraction Transformation Loading). ETL realizes the data extraction, transformation and loading of data warehouse. Utilization of SSIS (SQL Server 2005 Integration Services) platform can efficiently and speedily realize ETL function of data warehouse system.
Keywords :
data warehouses; decision support systems; ETL function realization; SSIS platform; data extraction; data warehouse system; decision-making support system; extraction transformation loading; time consumption; Business; Containers; Data mining; Data warehouses; Distributed databases; Relational databases; Servers;
Conference_Titel :
Database Technology and Applications (DBTA), 2010 2nd International Workshop on
Conference_Location :
Wuhan
Print_ISBN :
978-1-4244-6975-8
Electronic_ISBN :
978-1-4244-6977-2
DOI :
10.1109/DBTA.2010.5659098
