Title :
The research of enterprise data center based on SSIS
Author :
Yangeng, Wen ; Lei, Wang
Author_Institution :
Electron. & Inf. Eng. Exp. & Training Center, Handan Coll., Handan, China
Abstract :
Building an enterprise data center is the need of modern enterprise management and decision-making information, SQL SERVER 2005 Integration Services provides for the establishment of a complete enterprise data center solutions. This article discusses the SSIS-based enterprise data center construction process, focusing on the working principle of the SSIS data centers and the establishment of key technologies, including data extraction, transformation for cleaning, and loading.
Keywords :
SQL; business data processing; computer centres; decision making; SQL SERVER 2005 integration service; SSIS data center; data extraction; decision making information; enterprise data center; enterprise management; Cleaning; Data mining; Databases; Decision making; Loading; Servers; SSIS; cleaning; conversion; data center; data stream;
Conference_Titel :
Business Management and Electronic Information (BMEI), 2011 International Conference on
Conference_Location :
Guangzhou
Print_ISBN :
978-1-61284-108-3
DOI :
10.1109/ICBMEI.2011.5917849
