| With the development of information technology, the intelligentized building management becomes an important goal of modern building. Integration of heterogeneous database becomes a prime problem to be solved in the proceeding of constructing an intelligent building management system. In order to realize information sharing across many heterogeneous and distributed databases, the prime work is to build an operating platform on the basis of these heterogeneous database systems, and then enables users to access these heterogeneous database systems transparently.The main research of this paper is as follows:(1)Based on the background of intelligent building management system, implement the scheme of integration of heterogeneous database based B/S three layers of frame pattern: adopt middleware to integrate heterogeneous database, enact data format of conversion by XML at the same time, control the flow of conformity monitor and control the program administer by Java which can stride platform.(2)It carries out intelligent building management system based on the middleware. The middleware include query magement, wrapper, metadata and intelligent cache. Query magement carry out query decomposer and attemperation, the query results of fliteration and combination. The wrapper accomplishes mainly the heterogeneous database of connection and query. Metadata preserves the mapping information of global data and part data. Intelligent cache preserves query results which are visited by users frequently.(3)According to the query optimization of integration system, we research on the query optimization of join, put forward a query optimization algorithm based on the dynamic optimization. The results of experiments prove the algorithm efficiently reduce price of global join query, enhance query efficiency.(4)Test the alarming inquiry system of intelligent building and contrast experimental data, the results of test prove the system has favorable stability and query efficiency. |
PDF Full Text Request