CN101226497A - Application program monitoring system and monitoring method - Google Patents
Application program monitoring system and monitoring method Download PDFInfo
- Publication number
- CN101226497A CN101226497A CNA2007101953368A CN200710195336A CN101226497A CN 101226497 A CN101226497 A CN 101226497A CN A2007101953368 A CNA2007101953368 A CN A2007101953368A CN 200710195336 A CN200710195336 A CN 200710195336A CN 101226497 A CN101226497 A CN 101226497A
- Authority
- CN
- China
- Prior art keywords
- application program
- database
- monitoring
- statement
- agency
- 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.)
- Granted
Links
Images
Landscapes
- Debugging And Monitoring (AREA)
Abstract
The invention provides an application program detecting system, which comprises a JDBC drive interface, at least one database drive and at least one data, wherein the database via a relative database drive is connected with the JDBC drive interface, to receive and execute the statement of one application program via the JDBC drive interface. The invention further comprises a proxy drive respectively connected with relative databases via the JDBC drive interface and at least one database drive to receive the statement of one application program and record the detection information generated by execute statement. The invention provides a relative application program detecting method. The inventive system and method can detect and manage the execution condition of SQL statement via proxy drive, which can easily realize detection and management on databases and realize the detection and management on SQL statement on database drive layer, without third party detecting tools. The invention has the advantages of database spanning, easy detection and simple management.
Description
Technical field
The present invention relates to electric digital data processing field, particularly application program monitoring system and method for supervising.
Background technology
In the existing application, need monitor and manage, add up with the performance bottleneck of finding out system or to operation to the execution of the SQL statement that sends to database.
The function of SQL is not monitored and manage to most of application programs itself, but the SQL statement of checking transmission by the watchdog routine that database server has.
Because it mostly is to be provided by the database manufacturer that the JDBC of database realizes, application program can't be interfered the establishment database to connect and be used database to connect and carry out inquiry or upgrade the statement process, so the employing of most of application program realizes in the mode that the place of needs monitoring adds watchdog routine.
Prior art uses watchdog routine to realize that the flow process of monitoring comprises:
Step S01 uses database-driven to create database and connects;
Step S02, the record monitor message;
Step S03 uses database to connect and carries out SQL statement;
Step S04, the record monitor message outputs to assigned address with monitor message.
Above-mentioned requirements of process influences the normal flow of application program in a plurality of local watchdog routine that increases of application program; Application maintenance difficulty, watchdog routine are distributed in a plurality of places of application program, are not easy to revise; Be difficult for realizing the unified unlatching of monitoring or close that needing to increase extra code and global configuration item could realize; Can't realize the integration across database monitoring, the watchdog routine recompile when changing target database in the necessary application programs; Some information such as link information that needs can't be obtained by the JDBC interface of standard, thereby can't record.
Summary of the invention
The object of the invention is to provide application program monitoring system and method for supervising, realizes the SQL statement implementation status of integration across database is monitored and managed.
The invention provides a kind of application program monitoring system, comprise JDBC driving interface, at least one database-driven and at least one database, at least one database drives by corresponding database and is connected with the JDBC driving interface, by the statement that the JDBC driving interface receives and executive utility sends, comprise that also the agency drives, the agency drives by the JDBC driving interface and is connected with corresponding database respectively with at least one database-driven, reception is write down the monitor message that perform statement produces from the statement of application program.
Preferably, above-mentioned application program drives by the agency and creates at least one database connection, and the agency drives and creates and return agency's connection.
Preferably, above-mentioned agency connects the JDBC interface of realization standard, quotes by JDBC and drives the original connecting object of creating, with the link information and the additional managing configuration information of preserving application program; The agency connects the establishment Proxy Statement, realizes the interface statement of standard, quotes the original claim object of being created by original connecting object.
Preferably, the statement of activation record Proxy Statement execution and/or the monitor message of generation acted on behalf of in the statement that above-mentioned Proxy Statement executive utility sends.
The present invention also provides a kind of method for monitoring application program, realize Application Monitoring based on application program monitoring system, application program monitoring system comprises agency's driving, JDBC driving interface, at least one database-driven and at least one database, at least one database drives by corresponding database and is connected with the JDBC driving interface, the agency drives and is connected with JDBC driving interface application program respectively, reception is from the statement of application program, the monitor message that the record perform statement produces comprises: the agency drives and opens the database step of connecting; The agency drives the step that receives from the statement of application program; Act on behalf of the step of activation record monitor message; The step of database perform statement; Act on behalf of the step of activation record monitor message; The agency drives the closing database step of connecting.
Preferably, above-mentioned method for monitoring application program also comprises analysis monitoring information, draws the step of monitoring form.
Preferably, above-mentioned method for monitoring application program also comprises: the step that monitoring mark is set; Agency's driving is write down monitor message according to monitoring mark or is not write down the step of monitor message.
Preferably, above-mentioned monitoring mark is driven by the agency and is arranged in the link information, is driven by the agency and revises.
Preferably, above-mentioned agency drives interface supply routine call is provided, with control agent activation record monitor message.
Preferably, above-mentioned method for monitoring application program also comprises: application call interface, the step of control agent activation record monitor message; And/or the application call interface, control agent drives the step that stops to write down monitor message.
Application program monitoring system provided by the invention and method for supervising are monitored and are managed the implementation status of SQL statement by the mode that the agency drives, and can realize the monitoring and the management of integration across database easily.Because the present invention is monitoring and the management that has realized on the database-driven layer SQL statement, does not need third party's monitoring tools, has integration across database, be easy to monitor and convenient advantage of managing.
Description of drawings
Fig. 1 is the application program monitoring system synoptic diagram of first embodiment of the invention;
Fig. 2 is that the agency of first embodiment of the invention drives the principle of work synoptic diagram;
Fig. 3 is the Application Monitoring process synoptic diagram of third embodiment of the invention;
Fig. 4 is that the present invention adopts the 3rd application program of implementing to carry out schematic flow sheet;
Fig. 5 is the Application Monitoring process synoptic diagram of fourth embodiment of the invention.
The realization of the object of the invention, functional characteristics and advantage will be in conjunction with the embodiments, are described further with reference to accompanying drawing.
Embodiment
With reference to Fig. 1, the application program monitoring system synoptic diagram of first embodiment of the invention is shown.Present embodiment proposes the agency and drives 12, is used to create database and connects, and the actual local data base of encapsulation drives, and realizes striding the connection in several data storehouse.The agency drives 12 SQL statement that receive from application program 11, is connected with the several data storehouse respectively by JDBC driving interface 13.The several data storehouse of present embodiment comprises oracle database 151, SQL Server database 152 and My SQL database 153, JDBC driving interface 13 drives by corresponding database respectively, as Oracle JDBC drive 141, SQL Server JDBC drive 142 and My SQLJDBC drive 143 and be connected with JDBC driving interface 13.
The agency drive 12 with the JDBC driving interface (java.sql.Driver) that is connected the standard that realizes in several data storehouse, create various Proxy Statement objects (Statement), recording-related information before perform statement, and SQL statement is passed through real statement object (Statement) carry out.Agency's driving 12 is created the agency by the concrete database-driven in the link information (comprising managing configuration information) and is connected, and link information (comprising managing configuration information) is passed in agency's connection.Wherein link information also comprises and is used for monitoring and information of managing except comprising the link information that original connecting object is an application program 11, is called managing configuration information.The agency drive 12 create when connecting the part or all of content in the link information is saved in application program 11 corresponding managing configuration information in.
Above-mentioned managing configuration information is the necessary information that is provided with at database linkage information, is the part of link information.Database linkage information such as database server address, database-name, login user Service name and password etc., managing configuration information are the configuration informations that is used for management and monitoring outside these database linkage informations. which place should output to, whether want information such as recording parameters as daily record.
The agency of present embodiment drives 12 principle of work as shown in Figure 2, comprising:
Step S11, application program 11 and each database agency by present embodiment drives 12 and is connected, for the monitoring and the management of the SQL statement that realizes application programs 11 provides precondition;
Step S12 when driving database connection of 12 establishments by the agency, can connect outer package one deck at this database, creates and return agency's connection.The agency connects the JDBC interface (java.sql.Connection) of realization standard, quotes original connecting object (original connecting object is created by database-driven) simultaneously, is used to preserve the link information and the additional managing configuration information of application program 11; The agency connects the establishment Proxy Statement, realizes the interface statement (java.sql.Statement) of standard, quotes original statement object (being created by original connecting object) simultaneously;
Step S13, the SQL statement that Proxy Statement executive utility 11 sends comprises inquiry, establishment, deletion, modification etc.;
Step S14, agency drive the SQL statement of 12 record statement execution and the monitor message of generation, and monitor message comprises method, start time, execution time, the statement of execution and the parameter of execution etc. of link information, execution.
After catching through the monitor message of top four steps, SQL statement implementation status that just can application programs 11 is monitored and is managed, and further can draw statistical report form.
Method, perform statement, start time, execution time, the statement of execution and the parameter of execution etc. that comprise execution in the above-mentioned Proxy Statement.Agency's driving, agency's connection with the pass of Proxy Statement are: the agency drives according to link information establishment agency and is connected, and acts on behalf of to connect and creates Proxy Statement, the SQL statement that the Proxy Statement executive utility sends.
Present embodiment is applicable to the several data storehouse, is not limited only to oracle database, SQL Server database and My SQL database, and also is not limited only to the JDBC standard, also connects standard applicable to other databases.
Based on first embodiment, the present invention proposes second embodiment.Present embodiment provides method for monitoring application program, realize Application Monitoring based on application program monitoring system, application program monitoring system comprises agency's driving, JDBC driving interface, at least one database-driven and at least one database, at least one database drives by corresponding database and is connected with the JDBC driving interface, the agency drives and is connected with JDBC driving interface application program respectively, reception is from the SQL statement of application program, and the monitor message that SQL statement produces carried out in record, specifically comprises:
Step S21, agency drive and open the database connection;
Step S22, the agency drives the SQL statement that receives from application program;
Step S23 acts on behalf of the activation record monitor message;
Step S24, database is carried out SQL statement;
Step S25, agency drive and write down monitor message once more;
Step S26, agency drive closing database and connect.
Above-mentioned agency drives can be defined as an object, and this object comprises link information, open method such as database connection.In step S21, this object is opened database according to link information and is connected; In step S23, according to this object of SQL statement instantiation from application program, be the link information of this object, a plurality of attributes difference such as method, start time, the statement of execution and the parameter of execution assignment of execution, these attributes and value thereof i.e. one group of monitor message; At step S24, this object reference perform statement method is carried out the SQL operation according to SQL statement to database; At step S25, database returns the SQL statement execution result, and the time of returning according to execution result produces the execution time, is the execution time attribute assignment of this object, promptly writes down monitor message once more.
Whether application programs is enabled method for supervising of the present invention is monitored in order to control flexibly, the present invention also proposes the 3rd embodiment, on the second embodiment basis, in managing configuration information, add monitoring mark, this monitoring mark is used for agency's driving and enables/close Application Monitoring.Present embodiment is provided with monitoring mark trace, and value indicates and whether will enable Application Monitoring to certain database that the trace value is enabled Application Monitoring for opening expression for opening or closing; The trace value is closed Application Monitoring for closing expression; The trace value is defaulted as closes, and promptly closes Application Monitoring.
Present embodiment also proposes the monitor message record is become the monitoring daily record, and the analysis monitoring daily record draws the monitoring form.Monitor message is to be saved in the monitoring daily record with the prescribed paper form, and it is as shown in the table for the data structure of monitoring journal file record:
| URL | METHOD | START_TIME | EXECUTE_TIME |
| Link information | The method of carrying out | Start time | Execution time |
| SQL | PARAMETERS | ||
| The statement of carrying out | The parameter of carrying out |
Table 1
In the monitoring daily record, separate with line between per two groups of monitor messages, every group of monitor message comprises a plurality of clauses and subclauses, and each clauses and subclauses accounts for delegation separately, and form is: monitor message name=value.The concrete example of two groups of monitor messages below is shown:
SQL：UPDATE?FROM?T_MQ?SET?F1＝′MIC′WHERE?F1＝′MIC2′
PARAMETERS：
URL：jdbc：oracle：thin：@127.0.0.1：TEST_DB
METHOD：Statement.execute
START_TIME：1188976693633
EXECUTE_TIME：200
--------------------------------------------------------
SQL：SELECT*FROM?T_MQ?T1WHERE?T1.F1＝？AND?T2.F2＝？
PARAMETERS：′id1′，′value2′
URL：jdbc：oracle：thin：@127.0.0.1：TEST_DB
METHOD：Statement.executeQuery
START_TIME：1188976693633
Because monitor message is preserved with prescribed paper, can come the analysis monitoring daily record by artificial or program easily, to draw statistical report form.
The Application Monitoring process of present embodiment comprises as shown in Figure 3:
Step S31 judges that the monitoring mark of learning in the configuration link information is for opening;
Step S32 starts application program;
Step S33 opens database and connects;
Step S34, perform statement and Application Monitoring;
Step S35 closes application program;
Step S36, the analysis monitoring daily record draws the monitoring form.
Above-mentioned steps S33 opens database and connects and step S34, and the method for monitoring application program of the detailed process of perform statement and Application Monitoring and second embodiment is similar, so do not give unnecessary details.
Above-mentioned steps S36, the analysis monitoring daily record draws the monitoring form and comprises:
Step S361: read in the monitoring daily record;
Step S362: read in next line;
Step S363:, then current line is saved in internal memory as clauses and subclauses if current line is not separator "--------";
Step S364: if current line is a separator, then begin a new record object, jump to step 2; If current line is an end-of-file, then finish the process of analysis monitoring daily record.
Process through above-mentioned analysis monitoring daily record can draw statistical report form.
Below lifting a concrete example explanation adopts the application program of present embodiment method for supervising to carry out flow process.As shown in Figure 4, application program execution flow process comprises:
Step S41, agency drive and create agency's connection, prepare to carry out inquiry or upgrade statement;
Step S42, initial setting up monitoring mark are true, i.e. opening application program monitoring; And obtain managing configuration information, be kept in agency's connection, to carry out follow-up judgement;
Step S43, agency drive and judge that whether the value of monitoring mark trace in the managing configuration information is for opening; If monitoring mark then carries out step S44 for opening, otherwise carry out step S46;
Step S44, agency drive and judge whether managing configuration information has disposed the filtration expression formula; If disposed the filtration expression formula, then carry out step S45, otherwise carry out step S47;
Step S45, the agency drives to judge whether the current SQL statement that will carry out meets filtercondition, then carries out step S47 if meet, otherwise carries out step S46;
Step S46 is provided with monitoring mark for closing, and promptly current SQL statement is not monitored; Carry out step S47;
Step S47 acts on behalf of the linkage record monitor message, carries out SQL statement;
Step S48 after agency's connection execution SQL statement finishes, judges that whether monitoring mark is for opening, if monitoring mark then carries out step S49 for opening; Otherwise process ends;
Step S49, with the statement of carrying out, the time that begins to carry out, carry out the monitor messages such as parameter of elapsed time and execution and carry out record, be saved in the monitoring daily record or output to control desk, process ends.
Step S41 in the said process, application program drives to create by the agency and connects, and the agency drives the JDBC driving interface (being java.sql.Driver) of the standard that realized to realize that creating database connects.The agency drives agreement, and to be used to create the link information format sample of connection as follows:
jdbc：ksql：ORIGINAL_DRIVER：dbtype＝DB_TYPE[：trace＝on|off[：file＝FILE_NAME][：filter＝FILE_REG]：ORIGINAL_URL
The clauses and subclauses of wherein using [] to comprise represent it is optionally, use | the two or more tables of articles that separate are shown in and select one in the value of listing.Above-mentioned jdbc:ksql represents that this character string is the prefix of link information; ORIGINAL_DRIVER represents the original driving class of target database, and the value of these clauses and subclauses depends on the employed real driving class of target database, is com.microsoft.jdbc.sqlserver.SQLServerDriver down as SQL SERVER database; Dbtype=DB_TYPE indicates real type of database; Dbtype=is the fixed character string; DB_TYPE is the integer of expression catalog data base type, and system's agreement 1 is represented the DB2-UDB database; 2 expression ORACLE databases, 3 expression SQLSERVER databases, 4 expression sybase databases etc.; Trace indicates the Application Monitoring that whether will enable present embodiment to this database, and trace=opens expression and enables Application Monitoring, and trace=closes expression and closes Application Monitoring, is defaulted as and closes Application Monitoring; File=FILE_NAME indicates the file address of preserving monitor message; File is the fixed character string, and FILE_NAME can be that a file directory also can be a character string " console ", expression directly outputs to control desk with the information of monitoring; Above-mentioned filter=FILE_REG shows the filtercondition of monitoring, and FILE_REG is a regular expression character string, and the statement that only meets this expression formula just can be monitored and be caught; ORIGINAL_URL represents original database linkage information, and its value is determined by target database.
Below lift an agency and drive the concrete example of link information that agreement is used to create connection:
jdbc：ksql：oracle.jdbc.driver.OracleDriver：dbtype＝oracle9：trace＝off：file＝Clksql.log：jdbc：oracle：thin：@127.0.0.1：dbName
Can see from above-mentioned example, comprised other real database-driven information in the link information that the agency drives, be connected to other database if desired and conduct interviews, the value that only needs to change ORIGINAL_DRIVER and ORIGINAL_URL clauses and subclauses just can realize.
Application Monitoring enables and closes by monitoring mark is set and realize in the foregoing description, advantage do not need to be the interface that provides extra, software systems do not need to enable continually/close Application Monitoring in the reality, but just enable when running into performance or other problem; On the other hand, owing to need re-launching applications just can come into force after revising monitoring mark, this is unacceptable for application program that can not break in service.The present invention proposes the 4th embodiment for this reason, propose dynamically to enable/close Application Monitoring, enabling and closing of Application Monitoring do not need to be configured in the middle of the configuration link information, but provide an interface supply routine call by agency's driving, realize dynamically enabling/closing Application Monitoring.
The Application Monitoring process of employing present embodiment comprises as shown in Figure 5:
Step S51 starts application program;
Step S52 opens database and connects;
Step S53 dynamically enables Application Monitoring;
Step S54, perform statement and Application Monitoring;
Step S55 dynamically closes Application Monitoring;
Step S56, the analysis monitoring daily record draws the monitoring form.
In the above-mentioned flow process, it is similar to open database connection and perform statement and previous embodiment, all drives by the agency and realizes.Be meant the application call interface and dynamically enable Application Monitoring, control agent activation record monitor message; Be meant the application call interface and dynamically close Application Monitoring, control agent drives and stops to write down monitor message.
Compare with the 3rd embodiment, the advantage of present embodiment is to provide dynamically and enables/close Application Monitoring, and application program enabling/and need not to restart just and can come into force after closing Application Monitoring; Shortcoming is to provide additional interface and increases the difficulty that realizes.
The above only is the preferred embodiments of the present invention; be not so limit claim of the present invention; every equivalent structure or equivalent flow process conversion that utilizes instructions of the present invention and accompanying drawing content to be done; or directly or indirectly be used in other relevant technical fields, all in like manner be included in the scope of patent protection of the present invention.
Claims (10)
1. application program monitoring system, comprise JDBC driving interface, at least one database-driven and at least one database, described at least one database drives by corresponding database and is connected with described JDBC driving interface, receive and carry out the statement that described application program is sent by described JDBC driving interface, it is characterized in that:
Comprise that also the agency drives, described agency drives by the JDBC driving interface and is connected with corresponding database respectively with at least one database-driven, receives the statement from described application program, and the monitor message that described statement produces carried out in record.
2. application program monitoring system according to claim 1 is characterized in that, described application program is created at least one database by agency's driving and connected, and described agency drives and creates and return agency's connection.
3. application program monitoring system according to claim 1 and 2, it is characterized in that, described agency connects the JDBC interface of realization standard, quotes by described JDBC and drives the original connecting object of creating, with the link information and the additional managing configuration information of preserving described application program; Described agency connects the establishment Proxy Statement, realizes the interface statement of standard, quotes the original claim object of being created by original connecting object.
4. application program monitoring system according to claim 3 is characterized in that, the statement that described Proxy Statement executive utility sends, the described statement of activation record Proxy Statement execution and/or the monitor message of generation acted on behalf of.
5. method for monitoring application program, realize Application Monitoring based on application program monitoring system, described application program monitoring system comprises agency's driving, JDBC driving interface, at least one database-driven and at least one database, described at least one database drives by corresponding database and is connected with described JDBC driving interface, described agency drives and is connected with JDBC driving interface application program respectively, reception is from the statement of described application program, the monitor message that described statement produces carried out in record, it is characterized in that, comprising:
The agency drives and opens the database step of connecting;
The agency drives the step that receives from the statement of application program;
Act on behalf of the step of activation record monitor message;
The step of database perform statement;
Act on behalf of the step of activation record monitor message;
The agency drives the closing database step of connecting.
6. method for monitoring application program according to claim 5 is characterized in that:
Also comprise analysis monitoring information, draw the step of monitoring form.
7. according to claim 5 or 6 described method for monitoring application program, it is characterized in that, also comprise:
The step of monitoring mark is set;
Agency's driving is write down monitor message according to described monitoring mark or is not write down the step of monitor message.
8. method for monitoring application program according to claim 7 is characterized in that:
Described monitoring mark is driven by the agency and is arranged in the link information, is driven by the agency and revises.
9. method for monitoring application program according to claim 5 is characterized in that, described agency drives interface supply routine call is provided, with control agent activation record monitor message.
10. method for monitoring application program according to claim 9 is characterized in that, also comprises:
The application call interface is controlled the described step of acting on behalf of the activation record monitor message; And/or the application call interface, control described agency and drive the step that stops to write down monitor message.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2007101953368A CN101226497B (en) | 2007-12-10 | 2007-12-10 | Application program monitoring system and monitoring method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2007101953368A CN101226497B (en) | 2007-12-10 | 2007-12-10 | Application program monitoring system and monitoring method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101226497A true CN101226497A (en) | 2008-07-23 |
| CN101226497B CN101226497B (en) | 2011-06-22 |
Family
ID=39858507
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2007101953368A Active CN101226497B (en) | 2007-12-10 | 2007-12-10 | Application program monitoring system and monitoring method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101226497B (en) |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102110162A (en) * | 2011-02-24 | 2011-06-29 | 北京中电普华信息技术有限公司 | Method and device for realizing monitoring on SQL (structured query language) database |
| CN102122263A (en) * | 2011-03-23 | 2011-07-13 | 成都勤智数码科技有限公司 | Monitoring method and device of JAVA application system in running |
| WO2011134233A1 (en) * | 2010-04-29 | 2011-11-03 | 中兴通讯股份有限公司 | Method and device for monitoring database connection pool |
| CN102622289A (en) * | 2011-01-26 | 2012-08-01 | 阿里巴巴集团控股有限公司 | Program setting method, program monitoring method, and devices and systems for program setting and monitoring |
| CN102739654A (en) * | 2012-06-08 | 2012-10-17 | 北京久其软件股份有限公司 | Method for realizing application program to access database |
| CN103034679A (en) * | 2012-11-14 | 2013-04-10 | 上海百事通信息技术有限公司 | Monitoring system for java operational database |
| CN103064776A (en) * | 2011-10-21 | 2013-04-24 | 中国移动通信集团广西有限公司 | Performance monitoring method and performance monitoring device |
| CN103164455A (en) * | 2011-12-15 | 2013-06-19 | 百度在线网络技术（北京）有限公司 | Optimization method and optimization device of data base |
| CN103678630A (en) * | 2013-12-19 | 2014-03-26 | 北京用友政务软件有限公司 | Database monitoring method and system |
| CN104063301A (en) * | 2014-07-02 | 2014-09-24 | 网神信息技术（北京）股份有限公司 | Monitoring method and device |
| CN104683179A (en) * | 2015-02-12 | 2015-06-03 | 北京蓝海讯通科技有限公司 | Method, device and system for monitoring execution performance of objects |
| CN106021071A (en) * | 2016-05-04 | 2016-10-12 | 北京思特奇信息技术股份有限公司 | Method and system for monitoring SQL operation process |
| CN106294075A (en) * | 2016-08-17 | 2017-01-04 | 浪潮软件股份有限公司 | A kind of SQL is monitored method, Apparatus and system |
| CN107832634A (en) * | 2017-11-29 | 2018-03-23 | 江苏方天电力技术有限公司 | A kind of Dblink monitoring method and monitoring system |
| CN107870850A (en) * | 2017-08-25 | 2018-04-03 | 成都萌想科技有限责任公司 | A kind of efficient the Internet, applications log system |
| CN112231180A (en) * | 2020-11-10 | 2021-01-15 | 北京中电普华信息技术有限公司 | SQL monitoring method and device based on cloud environment |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102546810A (en) * | 2012-01-16 | 2012-07-04 | 广州市新信荟智信息产业有限公司 | Remote access method of database |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1904885A (en) * | 2005-07-29 | 2007-01-31 | 北京航空航天大学 | Database adapter |
-
2007
- 2007-12-10 CN CN2007101953368A patent/CN101226497B/en active Active
Cited By (23)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2011134233A1 (en) * | 2010-04-29 | 2011-11-03 | 中兴通讯股份有限公司 | Method and device for monitoring database connection pool |
| CN102622289B (en) * | 2011-01-26 | 2015-03-18 | 阿里巴巴集团控股有限公司 | Program setting method, program monitoring method, and devices and systems for program setting and monitoring |
| CN102622289A (en) * | 2011-01-26 | 2012-08-01 | 阿里巴巴集团控股有限公司 | Program setting method, program monitoring method, and devices and systems for program setting and monitoring |
| CN102110162A (en) * | 2011-02-24 | 2011-06-29 | 北京中电普华信息技术有限公司 | Method and device for realizing monitoring on SQL (structured query language) database |
| CN102110162B (en) * | 2011-02-24 | 2013-03-20 | 国家电网公司 | Method and device for realizing monitoring on SQL (structured query language) database |
| CN102122263A (en) * | 2011-03-23 | 2011-07-13 | 成都勤智数码科技有限公司 | Monitoring method and device of JAVA application system in running |
| CN103064776B (en) * | 2011-10-21 | 2015-07-01 | 中国移动通信集团广西有限公司 | Performance monitoring method and performance monitoring device |
| CN103064776A (en) * | 2011-10-21 | 2013-04-24 | 中国移动通信集团广西有限公司 | Performance monitoring method and performance monitoring device |
| CN103164455B (en) * | 2011-12-15 | 2016-08-03 | 百度在线网络技术（北京）有限公司 | The optimization method and device of data base |
| CN103164455A (en) * | 2011-12-15 | 2013-06-19 | 百度在线网络技术（北京）有限公司 | Optimization method and optimization device of data base |
| CN102739654A (en) * | 2012-06-08 | 2012-10-17 | 北京久其软件股份有限公司 | Method for realizing application program to access database |
| CN102739654B (en) * | 2012-06-08 | 2015-03-18 | 北京久其软件股份有限公司 | Method for realizing application program to access database |
| CN103034679A (en) * | 2012-11-14 | 2013-04-10 | 上海百事通信息技术有限公司 | Monitoring system for java operational database |
| CN103678630A (en) * | 2013-12-19 | 2014-03-26 | 北京用友政务软件有限公司 | Database monitoring method and system |
| CN104063301A (en) * | 2014-07-02 | 2014-09-24 | 网神信息技术（北京）股份有限公司 | Monitoring method and device |
| CN104683179A (en) * | 2015-02-12 | 2015-06-03 | 北京蓝海讯通科技有限公司 | Method, device and system for monitoring execution performance of objects |
| CN106021071A (en) * | 2016-05-04 | 2016-10-12 | 北京思特奇信息技术股份有限公司 | Method and system for monitoring SQL operation process |
| CN106294075A (en) * | 2016-08-17 | 2017-01-04 | 浪潮软件股份有限公司 | A kind of SQL is monitored method, Apparatus and system |
| CN106294075B (en) * | 2016-08-17 | 2018-09-21 | 浪潮软件股份有限公司 | A kind of method, apparatus and system that SQL is monitored |
| CN107870850A (en) * | 2017-08-25 | 2018-04-03 | 成都萌想科技有限责任公司 | A kind of efficient the Internet, applications log system |
| CN107832634A (en) * | 2017-11-29 | 2018-03-23 | 江苏方天电力技术有限公司 | A kind of Dblink monitoring method and monitoring system |
| CN112231180A (en) * | 2020-11-10 | 2021-01-15 | 北京中电普华信息技术有限公司 | SQL monitoring method and device based on cloud environment |
| WO2022099832A1 (en) * | 2020-11-10 | 2022-05-19 | 北京中电普华信息技术有限公司 | Cloud environment-based sql monitoring method and apparatus |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101226497B (en) | 2011-06-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101226497B (en) | Application program monitoring system and monitoring method | |
| US6976262B1 (en) | Web-based enterprise management with multiple repository capability | |
| US7690000B2 (en) | Metadata journal for information technology systems | |
| US7401143B2 (en) | System and methods for monitoring application server performance | |
| CN101739277A (en) | Self-defined script mode-based method for managing service monitoring system | |
| US20070268822A1 (en) | Conformance control module | |
| US7069184B1 (en) | Centralized monitoring and early warning operations console | |
| US20020152277A1 (en) | System and method for agent reporting in to server | |
| AU2008263492A1 (en) | Migration of legacy applications | |
| CN102375731A (en) | Coding-free integrated application platform system | |
| US20060225026A1 (en) | User-defined type consistency checker | |
| AU2002254635A1 (en) | System and method for rules-based web scenarios and campaigns | |
| US10354208B2 (en) | System and method for defining run books | |
| US20040186903A1 (en) | Remote support of an IT infrastructure | |
| US20070294097A1 (en) | Method and apparatus for monitoring execution of a business process managed using a state machine | |
| CN113407421A (en) | Dynamic log record management method and system for micro-service gateway | |
| CN101478445B (en) | General monitoring model technique used for information system monitoring | |
| US20030158937A1 (en) | Methods and systems for using distributed business data using observation technology to avoid the need to integrate servers and clients | |
| CN108228464A (en) | A kind of mobile application UI test frames and its implementation based on data-driven | |
| CN107463490B (en) | Cluster log centralized collection method applied to platform development | |
| CN115796758A (en) | Factory rule management platform | |
| CN106301912A (en) | The method building desktop version C/S automatization operation platform based on phthon | |
| US7630988B2 (en) | Computer product and session management method | |
| US7685147B2 (en) | Automatic management method and system with category-based correlations | |
| US7979474B2 (en) | Search center dynamic configuration using field mappings |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |