SIA OpenIR  > 数字工厂研究室
可视化多数据库ETL集成方法和系统
Alternative TitleVisual multi-database ETL integration method and system
王巍; 宋宏; 吕希胜; 刘昶; 原文斌; 姚丽丽
Department数字工厂研究室
Rights Holder中国科学院沈阳自动化研究所
Patent Agent沈阳科苑专利商标代理有限公司 21002
Country中国
Subtype发明授权
Status有权
Abstract本发明提供了可视化多数据库ETL集成方法和系统,方法包括以下步骤:连接源数据库和目标数据库;通过源数据库和目标数据库的ETL匹配,得到源数据库的源表的SQL语句;对SQL语句进行优化并执行、得到多个源数据库的ETL数据并注入到目标数据库的目标表。系统包括数据库管理系统层:连接源数据库和目标数据库;通过源数据库和目标数据库的ETL匹配,得到源数据库的源表的SQL语句;语义层:对SQL语句进行优化并执行、得到多个源数据库的ETL数据并注入到目标数据库的目标表。本发明降低多数据库集成的复杂程度,提高数据库集成的效率,降低数据库集成的风险。
Other AbstractThe invention provides a visual multi-database ETL integration method and system. The visual multi-database ETL integration method includes the following steps that source databases and target databases are connected; the SQL statements of source lists of the source databases are obtained through ETL matching of the source databases and the target databases; the SQL statements are optimized and executed, and the ETL data of the multiple source databases are obtained and introduced into target lists of the target databases. The visual multi-database ETL integration system comprises a database management system layer and a semantic layer, the database management system layer connects the source databases with the target databases, and the SQL statements of the source lists of the source databases are obtained through ETL matching of the source databases and the target databases; the semantic layer optimizes and executes the SQL statements, obtains the ETL data of the multiple source databases and introduces the ETL data to the target lists of the target databases. The visual multi-database ETL integration method and system reduce the complexity degree of integration of the multiple databases, improve the integration efficiency of the multiple databases, and reduce the risk of integration of the multiple databases.
PCT Attributes
Application Date2014-03-10
2015-09-16
Date Available2018-06-26
Application NumberCN201410086142.4
Open (Notice) NumberCN104915341B
Language中文
Contribution Rank1
Document Type专利
Identifierhttp://ir.sia.cn/handle/173321/22207
Collection数字工厂研究室
Affiliation中国科学院沈阳自动化研究所
Recommended Citation
GB/T 7714
王巍,宋宏,吕希胜,等. 可视化多数据库ETL集成方法和系统[P]. 2015-09-16.
Files in This Item: Download All
File Name/Size DocType Version Access License
CN201410086142.4授权.p(575KB)专利 开放获取CC BY-NC-SAView Download
Related Services
Recommend this item
Bookmark
Usage statistics
Export to Endnote
Google Scholar
Similar articles in Google Scholar
[王巍]'s Articles
[宋宏]'s Articles
[吕希胜]'s Articles
Baidu academic
Similar articles in Baidu academic
[王巍]'s Articles
[宋宏]'s Articles
[吕希胜]'s Articles
Bing Scholar
Similar articles in Bing Scholar
[王巍]'s Articles
[宋宏]'s Articles
[吕希胜]'s Articles
Terms of Use
No data!
Social Bookmark/Share
File name: CN201410086142.4授权.pdf
Format: Adobe PDF
All comments (0)
No comment.
 

Items in the repository are protected by copyright, with all rights reserved, unless otherwise indicated.