Design And Optimization Of Wireless Meter Reading Heating Database System Based On MySQL

With the development of wireless network communication technology change rapidly, people put forward higher requirements on living environment of the wireless network, wireless remote meter reading system will become the development direction of Chinese intelligent meter reading system.Artificial intelligent wireless remote meter reading system is a combination of wireless sensor network, embedded system, network system, database system and so on, various aspects of technology. It is composed of data acquisition system, data transmission system, data storage system, data access system, etc. Among them, the database system is a crucial part of remote meter reading system, responsible for data storage and management, which guarantees the data information integrity and security.This subject comes from the project of wireless remote meter reading system of heating. At present, to the Thermo Electron Corporation, a public utilities operation unit, the traditional manual meter reading and charging method has been unable to meet the new development of residential intelligent need. Due to some inevitable factors, it may appear in missing data, false positives and the cost of miscalculation etc. Computer information management can store and process large amounts of data information timely and quickly, and also improve their own quality of staff. The project is based on wireless remote meter reading system of heating with household metering policies, heating usage statistics of regular users, real-time monitoring of heating use, troubleshooting timely, ensure the needs of the user with warm.This design of the database system in this paper has strong application value. This system ensures that the main function of wireless remote meter reading database system of heating, such as memory, query, statistics of data, maintenance of meter information, processing of alarm information, setup and maintenance of base information, maintenance of user information, charging and other functions. At the same time, we solve the influence of mass data fixed-point incoming, fixed-point settlement, high concurrency to database through optimization, to improve the query efficiency, make sure the staff can quickly and efficiently monitor the district heating, and the users can also convenient query heating usage of themselves.