【作者】 吕恢艳；

【导师】 冉春玉；

【作者基本信息】 武汉理工大学 ， 计算机应用技术， 2004， 硕士

【摘要】 近年来，各种各样的新技术应运而生，分布处理的技术也从多个处理机的系统领域渗透到数据库技术中，并掀起分布式数据库研制与开发的热潮。分布式数据库系统符合当今信息系统应用的要求，符合当今企业组织的管理思想和管理方式。 在分布式数据库系统环境下，信息可能存储在地理位置分散的数据库中。如何在全局逻辑上查询、更新分布在分布式数据库中的错误，是分布式数据库技术要着力解决的问题。分布式数据库技术是数据库技术和计算机网络技术的结合，它除了具有集中式数据库所具有的特点外，还具有它自己独有的特点：它不但要考虑局部场地的自治，而且要解决全局数据库的逻辑整体性；它除了具有集中式数据库所具有的数据逻辑独立性和物理独立性，还具有数据的分布独立性。另外，在查询处理、事务管理、数据的完整性与安全性等方面，分布式数据库系统比集中式数据库系统具有更复杂、更丰富的内容。 本论文对Oracle分布式数据库系统的原理、设计与实现技术进行研究，并基于C／S模式实现一个智能大厦OA的分布式数据库应用系统。文中，对Oracle分布式数据库系统设计与实现中的数据库链接与位置透明性、远程过程中错误的管理、悬而未决事务的处理、参照完整性约束、数据库访问的安全性以及查询优化几个部分重点进行了探索。 通过初步的开发和应用，所设计的Oracle分布式数据库系统基本上达到了理论设计要求，运行结果表明，用Oracle建立智能大厦OA系统的分布式数据库方案是切实可行的、并具有良好的应用和发展前景。更多还原

【Abstract】 In recently years, various kinds of new technologies have been springing up like mushrooms, one of which is distributed processing technology. With distributed processing technology extending to database technology from the field of multi-processor system, there is a great upsurge in the research and development of distributed database, as it meets the requirement of the current information system application and caters to the present organizational management mode and concept.Under the environment of distributed database system, information can be stored in databases which are physically separated. To logically look into and update the errors in the distributed databases on the whole is the key issue for the technology of distributed database. Distributed database technology is the integration of database technology and computer network technology. Apart from the characteristics of centralized database such as data logical independence and physical independence, it has its own unique characteristics such as distributed independence of data. It has to consider not only the self-government of local places, but also the logical integrity of the whole database. In addition, Distributed database system contains more complex contents than centralized database system.This essay aims to research on the principle, design and realization technology of Oracle distributed database system. Based on C/S mode, actualize the distributed database application system of a intelligence building office automation. In the essay, discussions are focused on the transparency of database linkage and location, error management in remote control, treatment of suspending matters, referential integrity constraint, database access security and inquiry optimization.Through initial development and application, the Oracle distributed database system can meet the basic theoretical design requirement. The results of trial operation indicate that the plan to establish distributed database in intelligent building OA system is practical and has great application and development prospects更多还原