【作者】 刘丹；

【导师】 王霓虹；

【作者基本信息】 东北林业大学 ， 计算机应用技术， 2006， 硕士

【摘要】 随着计算机和网络技术的不断发展，以及企业信息化建设的不断深入、软硬件资源的升级和各种应用的扩展，异构数据库访问技术已是数据库研究的一个焦点。因此如何利用现有网络资源，在多系统的环境下实现异构数据的移植与整合已是本课题研究的关键问题。本课题主要基于导师主持的黑龙江省科技攻关项目“面向数字林业应用软件的研究”，研究的主要目标就是应用J2EE平台实现异构数据访问的中间件技术为数字林业系统异构、异种数据库的数据移植和数据分析提供解决方案。 本文主要根据当前林业局现有系统的数据异构问题而提出，并依据系统的现状提出了解决数据异构问题的方案，主要实现互联网环境下对各种异构数据库(如：Oracle、SQL Server等)的连接、访问、移植，以及对各数据库中的数据进行提取，并且完成数据的整合与分析。 企业异构数据访问系统的实现涉及到众多技术，本文对中间件、ORM、Hibernate等关键技术进行了深入研究，并提出了数字林业系统异构数据访问的实现方案。最后，本文主要以J2EE平台的多层体系结构为依据，结合中间件技术，应用现今最前卫的数据中间件开发工具Hibernate框架实现了数字林业系统的异构数据访问。 本论文在系统开发过程中，综合运用了多种先进技术，将J2EE平台的Java前端开发技术与数据库中间件Hibernate技术紧密结合，实现了中间件技术与数字林业系统的整合，在林业项目开发技术上实现了创新。 本课题的研究，将为程序的开发带来良好的经济效应。多层的开发体系使整个开发程序构件化，提高程序开发的可重用性，为其他程序的开发提供良好的组件。本系统的实现，可以将它的中间层构件成可复用的中间件产品，应用到需要与异构数据库建立连接、访问的程序中，从而减少程序员开发的工作量，减少开发周期，大大降低程序开发成本。更多还原

【Abstract】 With the unceasing development of computer and the network technology, as well as the enterprise information construction unceasingly is thorough, and the promotion of the software and hardware resources and the expansion of each kind of application, the heterogeneous database access technology already is a focal point of database research. How therefore uses the existing network resources that realizing the heterogeneous data transplant and the conformity under the multi- systems environment already is the key question of this topic research. This topic mainly the Heilongjiang Province science and technology attack project which manages based on supervisor "face the digital forestry application software research", and essential target of the research is realizing heterogeneous data accessing middleware technology using the J2EE platform for providing the solution to digital forestry system with the heterogeneous and the heterogeneous database data transplant and the data analysis.This article main basis current forestry bureau existing system data heterogeneous question proposed that, and proposed based on the system present situation the solution of data heterogeneous question, mainly realizes under the Internet environment to each kind of heterogeneous database (for example: Oracle, SQL Server and so on) the connection, the access, the transplant, as well as carries on to in various databases data withdraws, and completes the data the conformity and the analysis.The enterprise heterogeneous data accessing system realization involved to the multitudinous technology of middleware, ORM and Hibernate. This article has conducted the thorough research to the essential technology, and proposed the plan of realizing heterogeneous data access in the digital forestry system. Finally, this article has realized the digital forestry system heterogeneous data access that mainly basing on the J2EE platform with the multilayered system structure, and having the union with middleware technology, and using the nowadays most vanguard’s data middleware development tool -- Hibernate frame.In the system developing process, the present thesis has utilized the many kinds of advanced technologies by synthesis, and has built close integration between Java front end development technical based on J2EE platform and database middleware Hibernate technology, and has realized the middleware technology and the digital forestry system conformity. It has realized the innovation in the forestry project development technology.The research of this topic will bring the good economical effect for the procedure development. The multilayered development system causes component of the entire development procedure, and enhances the procedure development to be possible to duplicated use, and provides the good module for other procedures developments. The realization of the更多还原