The Oracle-based Distributed Database System For Intelligent Building Office Automation

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...