Design And Implementation Of Jiupeng Corp Building Energy Management Statistical Information Subsystem

World and our country's energy situation:the world's energy situation, the fossil energy such as coal, oil, natural gas is close to run out, the use of fossil energy to produce large amounts of carbon dioxide, sulfur dioxide, nitrogen oxide (NOX) and other greenhouse gases and waste gas waste, causing the earth's temperature rises and the serious pollution of the environment all over the world attaches great importance to the development and utilization of new energy thus, the world's energy situation is very urgent, development and utilization of renewable energy is the inevitable choice of human beings.Energy in China is more and more serious, the energy consumption is more and more rapid growth in our country, mainly reflected in the following aspects:the total energy consumption in China is very big, in 2014,2.85 billion tons of standard coal consumption in our country. The rapid growth of mining coal consumption, there is a very big number:2009,100 million tons; 2011,2.118 billion tons; 2013,2.5 billion tons; 2014,270 million tons.With China's economic development, on the other hand, office buildings, hotels, large public buildings energy problem increasingly prominent. Especially in shopping malls, high-grade hotels, high-grade office buildings, such as residential electricity energy consumption is much more than all the year round. So for the public building energy in energy management is to achieve energy saving is imperative.This graduation design is the cooperation with dalian long peng electronics co., LTD., Developed building energy management system for development zone administration. This system can be manually or automatically by the instrument for a large number of equipment data, provide the energy real-time information, record the historical data information. Through calculation provide custom graphics, reports, data model of characteristic analysis of energy consumption, as well as the equipment energy consumption monitoring and management. This paper discusses the design and implementation process of statistics and analysis subsystem, the subsystem is responsible for the construction of a building energy type and building energy management tree, energy management display group building, data display, analysis of energy consumption, etc., in the realization of the statistical analysis was carried out on the energy information, using the recursive and complex SQL query, such as energy complex of the tree traversal algorithm, and according to Software engineering process, Requirements, design, implementation and testing and proces is given in detail.After the on-line application of building energy management has played a very important role, part information of energy consumption statistics and energy management for the government department provides a very important decision-making information.