Research On Application Of Information Integration In Intelligent Building Based On Data Warehouse Technology

The intelligent building is the production combined of architecture, computer science and information technology. The necessary condition of that is to make the building intellectualization, while the core of designing an intellectualized system for the building is systematic integration. The major purpose of intelligent building systematic integration is to realize the integration of information. The data base of each intellectualized subsystem is heterogeneous and dispersed, and there are a lot of isolated information islands. Data warehouse can use a uniform global mode to describe the data in a heterogeneous data base and integrate these data into the data warehouse. The users can implement accessing and statistically analyzing via the uniform data interface, so the technology of data warehouse becomes the effective scheme to solve the problem of information integration of the intelligent building. The thesis deeply analyzes the relevant technologies of intelligent building systematic integration, constructs the integrated intelligent building management system which is based on the data warehouse technology and whose integration means is equal subsystem integration,and realizes the information integration of each subsystem.The thesis expatiates on the design idea of constructing an integrated building management system, the scheme and implement of information integration. The research content includes:①The way of current intelligent building systems integrated and the integration technology is deeply analyzed, and the realistic meaning of the intelligent building systematic integration based on the data warehouse technology is demonstrated;②the primary concepts and relevant technologies of data warehouse are expounded, and a deep understanding into the data warehouse technology is obtained, which builds firm basis for the design of data warehouse and the implement of information integration in the intelligent building;③After discussing the characteristics of systematic integration, the integrated intelligent building management system of a certain hospital comprehensive building and its software framework are constructed. The system is based on the data warehouse technology and its'integration means is equal subsystem integration;④The data for comprehensive building information integration is analyzed in detail. The rule of information integration is established and the scheme of information integration is designed. The central data base is designed, including conceptual subject analysis, logic model design and physical model design; ⑤The information which needs integrating is extracted and transformed, and then saved in the central data base (the data warehouse). In the updating process of the data in the data warehouse, the real-time data is updated by means of the trigger, and the general data by means of copying, linking the server, creating DTS package etc..⑥Using Microsoft SQL Server2000, the central data warehouse is created and OLAP multi-dimensional data set is constructed. Multi-dimensional analysis and inquiry of data is realized, and data exhibition based on Web is implemented with JSP programming.