Design And Implementation Of The Statistical Analysis Subsystem For Intelligent Lighting

Intensive release of energy-saving policies promotes regional public energy-saving measures in the formulation and implementation. Energy-saving and control engineering for Streetlight, as a collection element of the city’s spirit, also gained strong support from the local governments. Some software manufacturers seize this opportunity, and publish their own intelligent lighting control system. This system plays an important role in the daily grind of streetlight operation department, it frees them from traditional control mode, such as time controller and so on, and let them more fine-grained control of street lamps. They can put more effort in the operation and maintenance of streetlight, and improves their Improve work efficiency. As a leader of intelligent lighting control industry, our intelligent lighting control system receives consistent praises from the customer since it comes to market, but the system still has its shortcomings, such as:its statistical analysis module has poor performance and its function is weak, as so on, this reduces the value of the system to some extent. So the development of a high-performance and powerful statistical analysis subsystem for our intelligent lighting control system is inevitable.Based on the business data generated by our intelligent lighting control system, we use advanced business intelligence technology, and contact with our customers several times to obtain requirement, then weight the requirements from different level users, we design and implement a statistical analysis subsystem for our intelligent lighting control system. The system is high-performance, beautiful, practical, and it can assist their daily maintenance work and decision-making, and improve the efficiency and effectiveness of street management, then it can play a greater role of intelligent lighting control system.First, we discuss the development background for the system and the existing system problems, then describe the design goal of the system and the problem to be solved, and also illustrate our system requirements capture mode and the problems encountered and solutions when obtain the system requirements, which focus on system functional requirements and nonfunctional requirements, then we give a brief description of each major function, together with the flow chart and use case to carry on the detailed introduction to the business.On the basis of the needs analysis, we conducted the system architecture design of the subsystem for intelligent lighting control system. Firstly, according to the system requirements, we give the system design objectives and principles, then the system architecture and functional architecture. Technical architecture, we divide into4parts, physical architecture, logical architecture, development architecture and deployment architecture and so on, and each part contains the corresponding architecture view. Technical Architecture focuses on various nonfunctional indicators of the system, such as:scalability, maintainability and performance and so on, so we use SqlServer2005SSIS, SSAS, SSRS and other mature technology for system development. In the functional architecture design, we discuss the function of each part of the system, and the main function modules in detail.In the detailed design part, we describe various system indicators and measures which the customers concerned in, and for each module and the database design is discussed in detail. Implementation and testing of the system introduces the system’s overall implementation and the detailed implementation of each module, and the key code. We also describe the test key points and test methods of each module in detail.Finally, we briefly introduce the application of the statistical analysis subsystem, and put forward some suggestions for the further improvement of the system.