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.
翟东升, 禾文汇. 异构专利数据源集成方案设计与实现[J]. 现代图书情报技术, 2010, 26(9): 67-73.
Zhai Dongsheng, He Wenhui. Design and Implementation of Data Integration over Heterogeneous Patent Sources. New Technology of Library and Information Service, 2010, 26(9): 67-73.
[11] Fabry B, Ernst H, Langholz J,et al.Patent Portfolio Analysis as a Useful Tool for Identifying R&D and Business Opportunities - An Empirical Application in the Nutrition and Health Industry
[J]. World Patent Information, 2006,28 (3):215-225.