Design Of Power Information Query And Management System And Optimization

Generally speaking, with the increasing of visitor volume, the application system of database will have all kinds of problems after running a few times. As the adjustment and optimization of database relate to many fields, the administrator sometimes tries to find out the bottleneck which leads to drop the system performance, then analysis it for the sake of taking a series of steps to adjust and optimize. Meanwhile, it can also curtail the waiting time. Not only the system response rate and response speed to customer satisfaction, but also can reduce the system development costs, and bring much more economic benefits to enterprise.Compare with the United States, Britain and other advanced countries, our country is still relatively weak in the database application and optimization, what’s more, we are short of a set of application system for the optimization, which wish to be unify and comprehensive. System based on the application of Oracle database on the optimization is not more, and some optimization technologies are explained in a more abstract way. Bases on the source, background and significance of this issue, this paper first produces the frame, function and constitution of the power information query and management system, then base on the foundation of investigate and analysis, the designer accomplished the physical design of database by uses PowerDesigner modeling tool to model the database. On the other hand, the use of datafactory created more than one hundred thousand grade testing data, and established the foundation of optimization for database by inserted these testing data to table successfully. Thirdly, testing the performance of database by testing the index of answer time and hit rates of buffer zone, and adjusting and optimizing the oracle database by a series of optimized proposals. The last step is to summarize the work of this paper. To sum up, what this paper has finished can be showed as follows:(1).The author has finished the demand analysis for frame and function of power information query and management system. Before writing this paper, the author has investigated and read many relative literatures, and according to the standard of "The Function Cruterion of The power Information Collection System "[1], which was published by the National Grid, the author set specific goals for system design and show out the function demand, performance demand and the configuration. In this system, the designer has designed9modules: automatic meter reading management module, equipment testing management module, stop power supply management module,file management module, rights management module, price management module, statements management module, charge management module, historical data query module.(2).The author has finished to module and established more than one hundred thousand grade testing data. Firstly, on the foundation of demand analysis, the designer created the data model to achieve conception design of database by the way of from substance to connection. Secondly, changing the Conception Data Model which stands for CDM to Physical Data Model which stands for PDM by the modeling tool which named PowerDesigner and then accomplishing the physical design of database. Thirdly, according to practical demand, using Oracle database as the data bank administration information system, and using physical data model to establish Structured Query Language(SQL) of Oracle database, then the target database can be created. The last is to create more than one hundred thousand grade testing data for table fast by the tool of datafactory.(3).The author has finished the function adjustment and optimization for database which is based on the power information query and management system. After finished the design of database and created testing data for database, the designer also uses queried sentence to test performance of database, then adjust and optimize database by the ways of adjusting the parameter of internal storage, improving SQL sentence, adding index and using optimized technology to set up subarea list. Comparing to the system before optimize, the new system can be improved on the hand of response speed, times of logical read, hit rates of buffer zone and so on. In a word, the adjustment and optimization have enhanced the performance of database.