%A Zhai Dongsheng, He Wenhui %T Design and Implementation of Data Integration over Heterogeneous Patent Sources %0 Journal Article %D 2010 %J Data Analysis and Knowledge Discovery %R 10.11925/infotech.1003-3513.2010.09.11 %P 67-73 %V 26 %N 9 %U {https://manu44.magtech.com.cn/Jwk_infotech_wk3/CN/abstract/article_3273.shtml} %8 2010-09-25 %X

With consideration of the problems concerning the data of patent analysis, such as single data source, rough pretreatment, and low-level data mining, this paper designs and achieves the data integration over heterogeneous patent sources. Specifically, the local patent database where the data are acquired from heterogeneous sources including two organizations and seven countries is regarded as basic data source. After using the SSIS tool for data cleaning and data transformation, the data from local database are loaded into data warehouse that is built according to the key performance indicators, which provides data support for more advantaged analysis.