Research and development of electric charge manage

With the continuous development of socialist market economy and the deepening of power system reform, power supply enterprises are facing the severe situation of expanding the power market and increasing the sales of electricity. At the same time, power users also put forward higher requirements for the service quality of power supply enterprises. As the external window of power supply enterprises, the management level of power consumption departments directly reflects the service quality of power supply enterprises. In recent years, in order to improve their own management level and service quality, the power consumption Department has carried out a series of reforms in power consumption management, such as meter reading with meter reader, remote automatic meter reading, bank collection of electricity charges, etc. At the same time, the state has strengthened the transformation of urban and rural electricity and the transformation of one meter per household. The number of users has soared from tens of thousands to hundreds of thousands. The single power consumption management information system originally designed using a small database management system can no longer meet the needs of modern electricity charge management and the requirements of ultra large data calculation. In view of this, it is imperative to use the more advanced program development tools and large-scale database management system, and adopt the client/server structure technology to redesign and develop the power management information system. This paper focuses on the design and development of the electricity charge management system, which is the core part of the electricity management information system

1 demand analysis

according to the needs of modern power supply enterprises, especially the characteristics of electricity charge management, combined with the actual situation of electricity departments, the following problems should be solved in the new electricity charge management information system

1.1 the operation is simple and flexible, and the calculation is fast and accurate

the electricity charge management is mainly to copy the user's electricity consumption on time, calculate and review the electricity charge strictly and accurately according to the national electricity price policy, and timely recover and turn in, while providing customers with high-quality electricity service. Therefore, the new electricity charge management information system should be able to free the staff from a large number of cumbersome calculation and review work, master its operation in the shortest time, and quickly and accurately calculate the electricity charge of power users, so that more manpower can be invested in the work of developing the market and providing high-quality services

1.2 it has a variety of data import and export functions

in order to improve the management level and work efficiency of power consumption, power supply enterprises have mostly adopted new meter reading methods, such as meter reading by meter reader and remote meter reading, in view of the characteristics of many urban power users, large amount of meter reading and data input, and high accuracy of input data. In order to facilitate users and improve service quality, residential households mainly pay electricity fees by means of electricity savings, that is, users pay electricity fees in the form of savings at the bank savings office designated by the power supply enterprise. The bank transfers the electricity fees of the current month to the power supply enterprise according to the electricity fees payable by users provided by the power supply enterprise every month. This requires that the new management system can provide a variety of data import and export functions to meet the needs of the modernization of power management

1.3 provide comprehensive and reliable data

electricity charge management also includes electricity and electricity charge system column spacing: 540mm; Calculate and analyze, and regularly provide various information to relevant departments of the enterprise, so as to command production, make decisions, prepare plans and check the implementation of plans. Therefore, the new management system can not only carry out the statistics of electricity charges, but also provide a powerful data analysis function. Through the statistical analysis of various data, we can reflect the operation of power supply enterprises, and compare and analyze the completion of indicators such as sales electricity, electricity revenue, unit cost, line loss and turned in profits approved by the superior. Statistical data also provide basis for power supply enterprises to prepare load forecasting, long-term planning, power balance plan, financial revenue plan, etc

2 development of management information system

through system demand analysis, the electricity charge management information system is designed and developed according to the data flow of electricity charge (see Figure 1) and the existing local situation of power supply enterprises (see Figure 2). 2.1 selection of database system and development tools

oracle8.0 is used as the background database for system development, and powerbuilder6.5 (PB6.5 for short) is used as the development tool of management information system. Oracle8.0 is a large relational database based on advanced structured query language (SQL). It is one of the most popular databases with client/server architecture at present. PB6.5 is positioned as a C/S structure application development tool, which will directly affect the service life and safety of furniture. It provides a way to write event driven applications in an object-oriented manner, and has a good data interface with Oracle 8.0 and other databases, which has a wider range of adaptability than most other C/s structure tools

2.2 organic input and management of system data

the calculation of electricity charge is not a simple calculation of stop code minus minimum multiply electricity price. It needs to calculate the electricity charge according to the user's electricity category, voltage level, electricity capacity, meter relationship and other information. These users' basic data mainly come from different systems such as electricity business, measurement management and so on. In order to make the electricity fee system and other electricity consumption management systems organically integrate the extruder with a low export unit price, the design and development personnel have carried out data planning for the entire electricity consumption data according to the data flow of various electricity consumption businesses, and used the database design tool to design the database structure of the entire electricity consumption management system, ensuring the good connection and interaction between the electricity fee management system data and other electricity consumption system data. In addition, the system provides a variety of data entry functions according to the different meter reading methods of users. The meter prefixes of large and medium-sized households are entered manually, the meter prefixes of small power households and residential households are sent and received by meter readers, and the meter prefixes of substations and some residential households are received by remote meter reading. At the same time, the security and fault-tolerant technology are strengthened in the process of data input and reception. By using the non pull-down window technology to input data Internal inspection, received data, etc (for example, rope samples with a diameter of less than 1mm, including steel wire, iron wire, thin wire and other protective measures, verify and verify the input data and information as much as possible to find possible errors and prompt them in time to ensure the accuracy of the input data, so as to provide a strong guarantee for the correct calculation and statistical analysis of the data in the future.

2.3 well-rounded functions

for all businesses of electricity charge management Services