CN102110162B - Method and device for realizing monitoring on SQL (structured query language) database - Google Patents

Method and device for realizing monitoring on SQL (structured query language) database Download PDF

Info

Publication number
CN102110162B
CN102110162B CN 201110045271 CN201110045271A CN102110162B CN 102110162 B CN102110162 B CN 102110162B CN 201110045271 CN201110045271 CN 201110045271 CN 201110045271 A CN201110045271 A CN 201110045271A CN 102110162 B CN102110162 B CN 102110162B
Authority
CN
China
Prior art keywords
database
monitoring
class
sql
driving class
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN 201110045271
Other languages
Chinese (zh)
Other versions
CN102110162A (en
Inventor
杨宁
王能
张晶
李莹
张敏杰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Corp of China SGCC
Beijing China Power Information Technology Co Ltd
Original Assignee
State Grid Corp of China SGCC
Beijing China Power Information Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by State Grid Corp of China SGCC, Beijing China Power Information Technology Co Ltd filed Critical State Grid Corp of China SGCC
Priority to CN 201110045271 priority Critical patent/CN102110162B/en
Publication of CN102110162A publication Critical patent/CN102110162A/en
Application granted granted Critical
Publication of CN102110162B publication Critical patent/CN102110162B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Abstract

The embodiment of the invention discloses a method and device for realizing monitoring on an SQL (structured query language) database. The method comprises the following steps of: when a virtual machine loads a database driver used for acquiring database links, changing the name of the original method in the driver; regenerating a method with the same name of the original method in the driver and calling the original method the name of which is changed in the driver in the regenerated method; and modifying the return value of the method, and modifying the acquired database link into a proxy server to complete monitoring on access to a database by a service system. By applying the embodiment of the invention, database operation can be monitored in an operating period, the execution efficiency is increased by adopting a bytecode injection mode, and the driver of service application is not required to be modified.

Description

A kind of method and apparatus of realizing the SQL database monitoring
Technical field
The application relates to field of computer technology, particularly relates to a kind of method and apparatus of realizing the SQL database monitoring.
Background technology
Along with the development of society and the progress of science and technology, the informatization of industry-by-industry is just in carrying out like a raging fire.Comprehensive various technology and the project that develops is very different, how to realize the monitoring to the performance of various systems, especially to SQL (Structured Query Language, structurized query language) monitoring of the implementation status of database, further find system bottleneck, elevator system performance and stability have become technical matters in the urgent need to address.
The mode that realizes at present the SQL database monitoring can be divided into following several: the first is that for example, itself just provides some monitoring functions the Oracle10g database from the execution of database aspect monitoring SQL database.But, first kind of way can only monitor database inside implementation status, can not obtain objectively at net environment, from operation system send fill order to receive execution result during this period of time in the implementation status of database, the performance that therefore, can not reflect the operation of application program performing database.
The second is to revise service code,, adds monitor code in the service code of carrying out SQL database that is.Although the second way can overcome the defective that exists in the first kind of way, but, in the second way, need the original service code of modification to add monitor code and make both mixed in together, increase like this coupling of professional and monitoring, reduced the maintainability of operation system.
The third mode is to adopt the mode of dynamic proxy, that is, adopt dynamic proxy mechanism to come the Update Table storehouse to drive class.See also Fig. 1, it is dynamic proxy structural representation of the prior art.As shown in Figure 1, be that database manipulation drives class by proxy class, former manner of execution is to obtain the method that database connects, proxy class need to realize Invocation Handler interface, and rewrites the invoke method in the interface.Because proxy class need to adopt the mode of reflection just can call wherein former manner of execution, therefore, the execution efficient of proxy class when monitoring is lower, therefore is not suitable in the runtime SQL being monitored.
Summary of the invention
In order to solve the problems of the technologies described above, the embodiment of the present application provides a kind of method and apparatus of realizing the SQL database monitoring, to improve the execution efficient of proxy class when monitoring, simultaneously, guarantees in the runtime SQL database to be realized monitoring.
The embodiment of the present application discloses following technical scheme:
A kind of method that realizes the SQL database monitoring comprises: when the virtual machine loading is used for obtaining the driving class of database connection, change the method name of described driving class Central Plains method; Regenerate the method identical with former method name in the described driving class, and in the method that regenerates, call the former method of having changed the method name in the described driving class; The rreturn value of amending method is revised as the database connection object that obtains and acts on behalf of connecting object; Resemble the interpolation monitor code at the connecting object of described former method, the object and the execution result set pair that are used for execution SQL that obtains by described connecting object, generate corresponding agent object, in order to realize the monitoring that SQL carries out by agent object.
Preferably, described method also comprises: load before the driving class of obtaining the database connection at virtual machine, read the monitoring configuration file, when monitoring is carried out in described monitoring configuration file indication, described driving class is revised as agency's driving class.
Preferably, when the open and close of the connection of SQL database or affairs was monitored, the connecting object of described driving class was Connection.
A kind of device of monitoring SQL database comprises: the method name is changed the unit, is used for changing the method name of described driving class Central Plains method when the virtual machine loading is used for obtaining the driving class of database connection; Generation unit is used for regenerating the method identical with the former method name of described driving class, and calls the former method of having changed the method name in the described driving class in the method that regenerates; Adding device, for resembling the interpolation monitor code at the connecting object of described former method, the object and the execution result set pair that are used for execution SQL that obtains by described connecting object, generate corresponding agent object, in order to realize the monitoring that SQL carries out by agent object.
Preferably, described device also comprises: reading unit, be used for before virtual machine state is carried out the driving class of SQL database operation, reading the monitoring configuration file, and when monitoring is carried out in described monitoring configuration file indication, described driving class is revised as the agency drives class.
Preferably, when the open and close of the connection of SQL database or affairs was monitored, the connecting object of described driving class was Connection.
As can be seen from the above-described embodiment, unlike the prior art, the embodiment of the present application on-the-fly modifies the driving class of database manipulation in the process that service application is carried out, and the database access associated class is acted on behalf of, and realizes the monitoring that database SQL is carried out.Therefore, have the following advantages:
The embodiment of the present application can be revised the application driven class by the bytecode injection mode in the runtime in the process that service application is carried out, do not adopt the reflection mode, has improved the execution efficient of proxy class when monitoring.Can at the monitoring performance of real operation system net environment to SQL database, accurately reflect the performance of system.
Realize monitoring on the basis of not changing existing service code, finish the decoupling zero of watchdog routine and business procedure, not only reduced the impact of monitor procedure on existing system, reduced system risk, and be convenient to the maintenance service program, need not to revise the driver package of operation system.
Description of drawings
In order to be illustrated more clearly in the embodiment of the present application or technical scheme of the prior art, the below will do to introduce simply to the accompanying drawing of required use in embodiment or the description of the Prior Art, apparently, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain according to these accompanying drawings other accompanying drawing.
Fig. 1 is dynamic proxy structural representation of the prior art;
Fig. 2 is a kind of process flow diagram of realizing an embodiment of the method that SQL database is monitored of the application;
Fig. 3 is a kind of process flow diagram of realizing another embodiment of the method that SQL database is monitored of the application;
Fig. 4 is a kind of process flow diagram of realizing another embodiment of the method that SQL database is monitored of the application;
Fig. 5 is a kind of structural representation of realizing an embodiment of the device that SQL database is monitored of the application;
Fig. 6 is a kind of structural representation of realizing another embodiment of the device that SQL database is monitored of the application.
Embodiment
For above-mentioned purpose, the feature and advantage that make the application can become apparent more, below in conjunction with accompanying drawing the embodiment of the present application is described in detail.
Embodiment one
See also Fig. 2, it realizes the process flow diagram of an embodiment of the method that SQL database is monitored for the application is a kind of, and the method may further comprise the steps:
Step 201: when the virtual machine loading obtains the driving class of database manipulation, change the method name of described driving class Central Plains method;
For example, in the business application system that adopts the Spring framework, when virtual machine loads the driving class DriverManagerDataSource of performing database operation, the mode that adopts bytecode to inject is revised the method that all obtain connection, as with method name getConnectionFromDriverManager, be modified to getConnectionFromDriverManager_ $ Monitor.
Step 202: regenerate the method identical with former method name in the described driving class, and in the method that regenerates, call the former method of having changed the method name in the described driving class;
Still the getConnectionFromDriver-Manager in the above-mentioned DriverManagerDataSource class is as example, regenerate the method identical with this former method name of getConnectionFromDriverManager, and in the method that regenerates, call the former method of having changed the method name in the DriverManagerDataSource class, namely call getConnectionFromDriverManager_ $ Monitor.
Step 203: the rreturn value of amending method, be revised as the database connection object that obtains and act on behalf of connecting object;
Still the getConnectionFromDriver-Manager in the above-mentioned DriverManagerDataSource class changes rreturn value Connection into ProxyConnection as example.
Step 204: resemble the interpolation monitor code at the connecting object of described former method, the object and the execution result set pair that are used for execution SQL that obtains by described connecting object, generate corresponding agent object, so that the monitoring that realizes that by acting on behalf of connecting object SQL carries out.
As being ProxyConnection with the Connection object modification, Statement is revised as ProxyStatement etc.
As can be seen from the above-described embodiment, unlike the prior art, the embodiment of the present application is revised and is obtained the driving class that database connects in the process that service application is carried out, and returns and acts on behalf of connecting object.Therefore, have the following advantages:
The embodiment of the present application can the monitoring to SQL database in the runtime in the process that service application is carried out.The mode that adopts bytecode to inject comes database to drive the modification of class, avoids adopting the mode of reflection to call wherein former manner of execution, is implanted in the monitor code that drives in the class and sequentially carries out, and has improved the execution efficient of proxy class when monitoring.
Can at the monitoring performance of real operation system net environment to SQL database, accurately reflect the performance of system.
Realize monitoring on the basis of not changing existing service code, finish the decoupling zero of watchdog routine and business procedure, not only reduced the impact of monitor procedure on existing system, reduced system risk, and be convenient to the maintenance service program.
Embodiment two
Present embodiment also provides a kind of method that realizes the SQL database monitoring, present embodiment is with the difference of embodiment one: virtual machine load obtain the driving class that database is connected before, read the monitoring configuration file, because having indicated, this monitoring configuration file whether needs to carry out monitoring, therefore, virtual machine, just will drive class and be revised as agency's driving class when needs are carried out monitoring according to the indication of monitoring configuration file.See also Fig. 3, it realizes the process flow diagram of another embodiment of the method that SQL database is monitored for the application is a kind of, and the method may further comprise the steps:
Step 301: virtual machine reads the monitoring configuration file;
Step 302: when monitoring is carried out in described monitoring configuration file indication, when virtual machine loads the driving class of obtaining the database connection, change the method name of described driving class Central Plains method;
Step 303: regenerate the method identical with former method name in the described driving class, and in the method that regenerates, call the former method of having changed the method name in the described driving class;
Step 304: resemble the interpolation monitor code at the connecting object of described former method, the object and the execution result set pair that are used for execution SQL that obtains by described connecting object, generate corresponding agent object, in order to realize the monitoring that SQL carries out by agent object.
Above-mentioned steps 302-step 304 is illustrated in embodiment one, so locate to repeat no more.
Need to prove that when monitoring was not carried out in the indication of monitoring configuration file, the virtual machine normal load was carried out the driving class of SQL database operation.
As can be seen from the above-described embodiment, unlike the prior art, the embodiment of the present application is added monitor code in the driving class of carrying out the SQL database operation in the process that service application is carried out, and realization will drive class and be revised as agency's driving class.Therefore, have the following advantages:
The embodiment of the present application can determine whether SQL database is monitored according to configuration file in the process that service application starts.The mode that adopts bytecode to inject comes database to drive the modification of class, need not to revise the database-driven bag of service application, avoids adopting the mode of reflection to call wherein former manner of execution, has improved execution efficient.
Can at the monitoring performance of real operation system net environment to SQL database, accurately reflect the performance of system.
Realize monitoring on the basis of not changing existing service code, finish the decoupling zero of watchdog routine and business procedure, not only reduced the impact of monitor procedure on existing system, reduced system risk, and be convenient to the maintenance service program.
Embodiment three
Present embodiment provides a kind of driving class by proxy database to finish the method for SQL monitoring.See also Fig. 4, it realizes the process flow diagram of another embodiment of the method that SQL database is monitored for the application is a kind of, and the method may further comprise the steps:
Step 401: obtain the agency by the database-driven class of revising and connect class;
Step 402: the agency connects class and record monitor message when finishing original linkage function, the execution object that obtains by agency's connection class for act on behalf of the Statement object (as, ProxyStatement);
Step 403: the agency carries out object ProxyStatement record monitor message when carrying out SQL;
Step 404: the proxy results set pair resembles ProxyResultSet record result set information.
As can be seen from the above-described embodiment, unlike the prior art, the embodiment of the present application is in the process that service application is carried out, and the Update Table storehouse drives class, the database connection of obtaining is revised as the agency connects class, finish the monitoring that SQL is carried out by the relevant proxy class of database manipulation.Therefore, have the following advantages:
The embodiment of the present application is in the process that service application is carried out, can monitor SQL in the runtime, the mode that adopts bytecode to inject comes database to drive the modification of class, avoid adopting the mode of reflection to call wherein former manner of execution, be implanted in the monitor code that drives in the class and sequentially carry out, improved the execution efficient of proxy class when monitoring.
Can at the monitoring performance of real operation system net environment to SQL database, accurately reflect the performance of system.
Realize monitoring on the basis of not changing existing service code, finish the decoupling zero of watchdog routine and business procedure, not only reduced the impact of monitor procedure on existing system, reduced system risk, and be convenient to the maintenance service program.
Embodiment four
A kind ofly realize that the method for SQL database monitoring is corresponding with above-mentioned, the embodiment of the present application also provides a kind of device of realizing the SQL database monitoring.See also Fig. 5, it realizes an embodiment of the device that SQL database is monitored for the application is a kind of structural representation comprises: the method name is changed unit 501, generation unit 502 and adding device 503.Principle of work below in conjunction with this device is further introduced its inner structure and annexation.
The method name is changed unit 501, is used for changing the method name of described driving class Central Plains method when virtual machine loads the driving class of carrying out the SQL database operation;
Generation unit 502 is used for regenerating the method identical with the former method name of described driving class, and calls the former method of having changed the method name in the described driving class in the method that regenerates;
Adding device 503, for resembling the interpolation monitor code at the connecting object of described former method, the object and the execution result set pair that are used for execution SQL that obtains by described connecting object, generate corresponding agent object, in order to realize the monitoring that SQL carries out by agent object.
Preferably, see also Fig. 6, it realizes the structural representation of an embodiment of the device that SQL database is monitored for the application is a kind of, as shown in Figure 6, this device also comprises: reading unit is used for reading the monitoring configuration file before virtual machine drives class, when monitoring is carried out in described monitoring configuration file indication, described driving class is revised as the agency drives class.
Preferably, when the open and close of the connection of SQL database or affairs was monitored, the connecting object of described driving class was Connection.
As can be seen from the above-described embodiment, unlike the prior art, the embodiment of the present application is in the process that service application is carried out, and the Update Table storehouse drives class, the database connection of obtaining is revised as the agency connects class, finish the monitoring that SQL is carried out by the relevant proxy class of database manipulation.Therefore, have the following advantages:
The embodiment of the present application is in the process that service application is carried out, can monitor SQL in the runtime, the mode that adopts bytecode to inject comes database to drive the modification of class, avoid adopting the mode of reflection to call wherein former manner of execution, be implanted in the monitor code that drives in the class and sequentially carry out, improved the execution efficient of proxy class when monitoring.
Can at the monitoring performance of real operation system net environment to SQL database, accurately reflect the performance of system.
Realize monitoring on the basis of not changing existing service code, finish the decoupling zero of watchdog routine and business procedure, not only reduced the impact of monitor procedure on existing system, reduced system risk, and be convenient to the maintenance service program.
Need to prove, one of ordinary skill in the art will appreciate that all or part of flow process that realizes in above-described embodiment method, to come the relevant hardware of instruction to finish by computer program, described program can be stored in the computer read/write memory medium, this program can comprise the flow process such as the embodiment of above-mentioned each side method when carrying out.Wherein, described storage medium can be magnetic disc, CD, read-only store-memory body (Read-Only Memory, ROM) or store-memory body (Random AccessMemory, RAM) etc. at random.
More than a kind of method and apparatus of SQL database monitoring of realizing that the application is provided be described in detail, used specific embodiment herein the application's principle and embodiment are set forth, the explanation of above embodiment just is used for helping to understand the application's method and core concept thereof; Simultaneously, for one of ordinary skill in the art, the thought according to the application all will change in specific embodiments and applications, and in sum, this description should not be construed as the restriction to the application.

Claims (6)

1. realize that SQL carries out the method for monitoring for one kind, it is characterized in that, comprising:
When the virtual machine loading was used for obtaining the driving class of database connection, the mode that adopts bytecode to inject was changed the method name of described driving class Central Plains method;
Regenerate the method identical with former method name in the described driving class, and in the method that regenerates, call the former method of having changed the method name in the described driving class;
The rreturn value of amending method is revised as the database connection object that obtains and acts on behalf of connecting object;
Resemble the interpolation monitor code at the connecting object of described former method, the object and the execution result set pair that are used for execution SQL that obtains by described connecting object, generate corresponding agent object, in order to realize the monitoring that SQL carries out by agent object.
2. method according to claim 1, it is characterized in that described method also comprises: before virtual machine loads for the driving class of obtaining the database connection, read the monitoring configuration file, when monitoring is carried out in described monitoring configuration file indication, revise described driving class.
3. method according to claim 1 and 2 is characterized in that, when the open and close of the connection of SQL database or affairs was monitored, the connecting object of described driving class was Connection.
4. a device of monitoring SQL database is characterized in that, comprising:
The method name is changed the unit, is used for when the virtual machine loading is used for obtaining the driving class of database connection, and the mode that adopts bytecode to inject is changed the method name of described driving class Central Plains method;
Generation unit is used for regenerating the method identical with the former method name of described driving class, and calls the former method of having changed the method name in the described driving class in the method that regenerates;
Revise the unit, be used for the rreturn value of amending method, the database connection object that obtains is revised as acts on behalf of connecting object;
Adding device, for resembling the interpolation monitor code at the connecting object of described former method, the object and the execution result set pair that are used for execution SQL that obtains by described connecting object, generate corresponding agent object, in order to realize the monitoring that SQL carries out by agent object.
5. device according to claim 4 is characterized in that, described device also comprises: reading unit, be used for before virtual machine drives class, read the monitoring configuration file, when monitoring is carried out in described monitoring configuration file indication, described driving class is revised as the agency drives class.
6. according to claim 4 or 5 described devices, it is characterized in that when the open and close of the connection of SQL database or affairs was monitored, the connecting object of described driving class was Connection.
CN 201110045271 2011-02-24 2011-02-24 Method and device for realizing monitoring on SQL (structured query language) database Active CN102110162B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN 201110045271 CN102110162B (en) 2011-02-24 2011-02-24 Method and device for realizing monitoring on SQL (structured query language) database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN 201110045271 CN102110162B (en) 2011-02-24 2011-02-24 Method and device for realizing monitoring on SQL (structured query language) database

Publications (2)

Publication Number Publication Date
CN102110162A CN102110162A (en) 2011-06-29
CN102110162B true CN102110162B (en) 2013-03-20

Family

ID=44174323

Family Applications (1)

Application Number Title Priority Date Filing Date
CN 201110045271 Active CN102110162B (en) 2011-02-24 2011-02-24 Method and device for realizing monitoring on SQL (structured query language) database

Country Status (1)

Country Link
CN (1) CN102110162B (en)

Families Citing this family (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103164455B (en) * 2011-12-15 2016-08-03 百度在线网络技术(北京)有限公司 The optimization method and device of data base
CN103605722B (en) * 2013-11-15 2018-11-06 北京奇虎科技有限公司 Database monitoring method and device, equipment
CN104731780B (en) * 2013-12-18 2018-04-27 青岛海尔空调器有限总公司 Proxy server, the acquisition system comprising its database execution information and acquisition methods
CN105404498B (en) * 2014-09-16 2019-03-22 网宿科技股份有限公司 The method of flow in application program is forwarded under mobile intelligent terminal
CN108243238B (en) * 2016-12-27 2020-10-09 中国移动通信集团浙江有限公司 Method and device for acquiring performance data
CN109471768B (en) * 2017-09-08 2023-04-18 阿里巴巴集团控股有限公司 Service problem monitoring method and device and electronic equipment
CN111813633A (en) * 2020-07-20 2020-10-23 前海人寿保险股份有限公司 Performance monitoring method, device, equipment and readable storage medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6115646A (en) * 1997-12-18 2000-09-05 Nortel Networks Limited Dynamic and generic process automation system
CN101226497A (en) * 2007-12-10 2008-07-23 金蝶软件(中国)有限公司 Application program monitoring system and monitoring method
CN101840352A (en) * 2010-04-29 2010-09-22 中兴通讯股份有限公司 Method and device for monitoring database connection pool

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6115646A (en) * 1997-12-18 2000-09-05 Nortel Networks Limited Dynamic and generic process automation system
CN101226497A (en) * 2007-12-10 2008-07-23 金蝶软件(中国)有限公司 Application program monitoring system and monitoring method
CN101840352A (en) * 2010-04-29 2010-09-22 中兴通讯股份有限公司 Method and device for monitoring database connection pool

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
安文利.基于JAVA字节码的反木马技术的研究.《中国优秀硕士论文全文数据库》.2010,第3章. *

Also Published As

Publication number Publication date
CN102110162A (en) 2011-06-29

Similar Documents

Publication Publication Date Title
CN102110162B (en) Method and device for realizing monitoring on SQL (structured query language) database
US9792203B2 (en) Isolated testing of distributed development projects
US20100115495A1 (en) Intelligent engine for dynamic and rule based instrumentation of software
US8261248B2 (en) System and method of executing a dynamic program in a structured environment
US20110219383A1 (en) Processing model-based commands for distributed applications
US20070240113A1 (en) Model independent input reduction
US9824000B1 (en) Testing calling code dynamically with random error injection based on user-specified configuration
WO2007089353A1 (en) Xna relationship management
US8918762B2 (en) Generating test plans and test cases from service-oriented architecture and process models
Westergaard et al. Modeling and verification of a protocol for operational support using coloured petri nets
US7072820B1 (en) Accessing state information in a hardware/software co-simulation
Riccobene et al. A modeling and executable language for designing and prototyping service-oriented applications
CN102331961B (en) Method, system and dispatcher for simulating multiple processors in parallel
CN109558121A (en) Development approach, device, equipment and the storage medium of interface drive program
CN111142861B (en) Method and device for integrating structured comprehensive control system
Di Pompeo et al. A Microservice Reference Case Study for Design-Runtime Interaction in MDE.
US8640064B1 (en) Hardware description language simulator tracing and control
CN104317723A (en) Method and system for tracking running information of drive program
CN112559336B (en) Method, device and system for self-adaptively debugging heterogeneous computing chip and main board chip
Barbier et al. Software adaptation: classification and a case study with state chart xml
CN111930398B (en) Application program updating method, device, system, medium and equipment
US20060277082A1 (en) System and method for dynamically modeling workflows for interacting stateful resources
CN112559079A (en) Data source connection driving self-adaptive loading method and device and electronic equipment
Van Eekelen et al. Analysis of a session-layer protocol in mcrl2: verification of a real-life industrial implementation
CN112445607A (en) Method and device for executing method function by application program

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
ASS Succession or assignment of patent right

Owner name: STATE ELECTRIC NET CROP.

Free format text: FORMER OWNER: BEIJING ZHONGDIAN PUHUA INFORMATION TECHNOLOGY CO., LTD.

Effective date: 20120801

Owner name: BEIJING ZHONGDIAN PUHUA INFORMATION TECHNOLOGY CO.

Effective date: 20120801

C41 Transfer of patent application or patent right or utility model
COR Change of bibliographic data

Free format text: CORRECT: ADDRESS; FROM: 100192 HAIDIAN, BEIJING TO: 100031 XICHENG, BEIJING

TA01 Transfer of patent application right

Effective date of registration: 20120801

Address after: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing

Applicant after: State Grid Corporation of China

Co-applicant after: Beijing China Power Information Technology Co., Ltd.

Address before: 100192 Beijing city Haidian District Qinghe small Camp Road No. 15 building 710 room research

Applicant before: Beijing China Power Information Technology Co., Ltd.

C14 Grant of patent or utility model
GR01 Patent grant