摘要
企业信息系统存在大量的异构数据库,如何集成异构数据库、解决信息孤岛现象是我们面临的问题。利用数据仓库技术来集成异构数据库是一个理想的解决方案。本文给出了异构数据库的集成方案,提出了从异构数据库抽取和转换数据的新方法,提出了ODBC用于数据抽取过程的思路,提出了数据转换规则集的概念并用于数据抽取过程中。数据仓库的建立不仅实现了企业信息系统中信息的集成,更重要的是为企业决策提供了信息源。
There are many heterogeneous databases in Enterprise Information System(EIS).It is a problem,which we faced,how to make the heterogeneous database integrity and solve Information Island.It is a good solution that heterogeneous databases are made integrity by using data warehouse technology.The integrity solution of heterogeneous database was given.The new method of extracting and transforming data was presented from heterogeneous databases.The idea that ODBC is used in extracting data processing was presented.The concept of data transform rule set was presented and used in extracting data processing.Data warehouse mot only makes information integrity in EIS but also provides information source for enterprise decision-making.
出处
《计算机应用与软件》
CSCD
北大核心
2005年第6期24-26,共3页
Computer Applications and Software
