CN109918547A - A kind of database session management method and device - Google Patents
A kind of database session management method and device Download PDFInfo
- Publication number
- CN109918547A CN109918547A CN201910174557.XA CN201910174557A CN109918547A CN 109918547 A CN109918547 A CN 109918547A CN 201910174557 A CN201910174557 A CN 201910174557A CN 109918547 A CN109918547 A CN 109918547A
- Authority
- CN
- China
- Prior art keywords
- database
- information
- analysis
- module
- database session
- 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.)
- Pending
Links
- 238000007726 management method Methods 0.000 title claims abstract description 10
- 238000004458 analytical method Methods 0.000 claims abstract description 97
- 230000002159 abnormal effect Effects 0.000 claims abstract description 13
- 238000007405 data analysis Methods 0.000 claims abstract description 13
- 238000004364 calculation method Methods 0.000 claims abstract description 9
- 238000000034 method Methods 0.000 claims description 19
- 238000005070 sampling Methods 0.000 claims description 6
- 230000002123 temporal effect Effects 0.000 claims description 2
- 238000012544 monitoring process Methods 0.000 description 6
- 230000008569 process Effects 0.000 description 6
- 238000012545 processing Methods 0.000 description 6
- 230000000903 blocking effect Effects 0.000 description 3
- 238000004140 cleaning Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 230000000737 periodic effect Effects 0.000 description 2
- 230000002547 anomalous effect Effects 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000003012 network analysis Methods 0.000 description 1
- 238000004451 qualitative analysis Methods 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 230000009897 systematic effect Effects 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Storage Device Security (AREA)
Abstract
The present invention discloses a kind of database session management method and device, is related to database O&M technical field；Including system configuration module, data acquisition module, data analysis module and show warning module, system configuration module is used to be arranged the configuration information of database, and support is interacted with user；Data acquisition module is used for acquisition database session related information；Data analysis module is electrically connected with data acquisition module, the database session relevant information of analytical calculation acquisition simultaneously generates analysis result, judge whether database session occurs abnormal and whether impact to the system for using database based on the analysis results, analysis result and judging result are supplied to displaying warning module；It shows that warning module makes corresponding operation according to judging result, and analysis result and judging result is organized into and is shown for the data of displaying, or analysis result and judging result are supplied to third party system module with interface form and used.
Description
Technical field
The present invention discloses a kind of database session management method and device, is related to database O&M technical field.
Background technique
With the development of Internet industry, the scale of all kinds of software systems and website is increasing, because functional development introduces
Globality delay machine problem clump go out not poor, and cause in the factor of system failure, significant portion is since database level is abnormal
Cause.Due to subproblem can only problem occurs in database session when analyzed in real time.
The invention discloses a kind of database session management method and device, may be implemented quickly to position because of database session
Systematic entirety problem caused by level problem.Apparatus of the present invention include system configuration module, data acquisition module, data analysis
Module and displaying warning module, system configuration module are used to be arranged the configuration information of database, and support is interacted with user；Data are adopted
Collect module and is used for acquisition database session related information；Data analysis module is electrically connected with data acquisition module, and analytical calculation is adopted
The database session relevant information of collection and generate analysis as a result, judge based on the analysis results database session whether occur extremely and
Whether the system for using database is impacted, analysis result and judging result are supplied to displaying warning module；It shows pre-
Alert module makes corresponding operation according to judging result, and result will be analyzed and judging result be organized into data for displaying into
Row is shown, or analysis result and judging result are supplied to third party system module with interface form and used.Based on the present invention
Method or apparatus can be with rapidly locating library session level problem source, or the automatic O&M class function of system provides number
It is supported according to source.
Summary of the invention
The present invention is directed to problem of the prior art, provides a kind of database session management method and device, solves original
Image collection function the case where being confined to a certain particular device, and improve the effect of the processing to collected image information
Rate.
Concrete scheme proposed by the present invention is:
A kind of database session managing device, including system configuration module, data acquisition module, data analysis module and exhibition
Show warning module,
System configuration module is used to be arranged the configuration information of database, and support is interacted with user；
Data acquisition module is used for acquisition database session related information；
Data analysis module is electrically connected with data acquisition module, the database session relevant information that analytical calculation acquires and life
At analysis as a result, judging whether database session occurs abnormal and whether cause to the system for using database based on the analysis results
It influences, analysis result and judging result is supplied to displaying warning module；
Show that warning module makes corresponding operation according to judging result, and analysis result and judging result are organized into can
It is shown for the data of displaying, or analysis result and judging result is supplied to third party system module with interface form and made
With.
The configuration information that system configuration module is arranged in the device includes type of database, user log-in authentication letter
Breath, sample information, log information.
System configuration module records in different ways according to the disparate modules run in described device in the device
Corresponding log information.
Data analysis module is according to problematic phenomenon and questions and prospect distinguishing analysis as a result, point that will be obtained in the device
Analysis result will be supplied to displaying warning module.
The configuration information of database is arranged in a kind of database session management method, and support is interacted with user,
Then acquisition database session related information,
The database session relevant information of analytical calculation acquisition simultaneously generates analysis as a result, judging database based on the analysis results
Whether whether session occur abnormal and impact to the system for using database,
Corresponding operation is made according to judging result, and analysis result is organized into and is shown for the data of displaying,
Or analysis result is supplied to third party system module with interface form and is used.
Specific steps in the method are as follows:
Step 1: the configuration information of database is set, and configuration information includes type of database, user log-in authentication information, adopts
Sample information, log information,
Step 2: according to sample frequency track database session related information, at interval of certain time with regard to acquisition database meeting
Relevant information is talked about,
Step 3: the database session relevant information of collection being subjected to calculating analysis, judges database meeting based on the analysis results
Whether whether words occur abnormal and impact to the system for using database, and according to the configuration information of setting and analysis result
Log recording is carried out,
Step 4: corresponding operation being made according to judging result, and analysis result and judging result are organized into for showing
Data be shown, or will analysis result and judging result with interface form be supplied to third party system module use.
In the method,
Step 1: the configuration information of database is set, and configuration information includes type of database, user log-in authentication information, adopts
Sample information, log information,
Step 2: according to sample frequency track database session related information, at interval of certain time with regard to acquisition database meeting
Relevant information is talked about, database session relevant information includes database session status information and temporal information,
Step 3: the database session relevant information of collection being subjected to calculating analysis, wherein judgement is worked as based on the analysis results
WAIT_TIME is greater than given threshold, it is believed that database session appearance causes the obstruction significantly affected to system performance；Work as database
When blocking the ratio of session in session more than given threshold, it is believed that there is the Severe blockage integrally having an impact to system,
Configuration information and analysis result according to setting carry out log recording,
Step 4: corresponding operation being made according to judging result, and analysis result and judging result are organized into for showing
Data be shown, or will analysis result and judging result with interface form be supplied to third party system module use.
In the method,
Step 1: the configuration information of database is set, and configuration information includes type of database, user log-in authentication information, adopts
Sample information, log information,
Step 2: according to sample frequency track database session related information, at interval of certain time with regard to acquisition database meeting
Relevant information is talked about, database session relevant information includes the machine name information and Java DataBase Connection class in database session source
The quantity of difference SQL and current connection sum in type information and current database session connection,
Step 3: the database session relevant information of collection being subjected to calculating analysis, wherein judgement is worked as based on the analysis results
SQL_COUNT/SESSION_COUNT is greater than given threshold, and when SQL_COUNT > given threshold, it is believed that occur be due to ID
The connection of database session caused by the SQL of SQL_ID leaks,
When the ratio for connecting leakage in database session is more than given threshold, it is believed that appearance integrally has an impact system
Serious connection leakage,
Configuration information and analysis result according to setting carry out log recording,
Step 4: corresponding operation being made according to judging result, and analysis result and judging result are organized into for showing
Data be shown, or will analysis result and judging result with interface form be supplied to third party system module use.
Usefulness of the present invention is:
The present invention provides a kind of database session management method and device, the configurations of the settable database of the method for the present invention
Information, support are interacted with user, then acquisition database session related information, the database session correlation letter of analytical calculation acquisition
It ceases and generates analysis as a result, judging whether database session occurs abnormal and be to the system for using database based on the analysis results
It is no to impact, corresponding operation is made according to judging result, and analysis result is organized into and is opened up for the data of displaying
Show, or analysis result is supplied to third party system module with interface form and is used.The present invention is suitable for a variety of common numbers
According to library type, the problem of supporting a variety of data volume type systems analysis, such as including but not limited to SqlServer, Oracle,
MySQL etc. can be used for analyzing the tracking of a variety of implementation systems, can analyze based on database connection pool mode or not base
In the network analysis that database connection pool mode is realized, can be used for analytical database session causes system function is abnormal to ask
Topic, system caused by especially blocking because of database level session is whole without response, causes to connect because database session is not turned off
The problem of pond exhausts and reports an error etc..
Detailed description of the invention
Fig. 1 is the method for the present invention flow diagram；
Fig. 2 apparatus of the present invention module contacts schematic diagram.
Specific embodiment
The present invention provides a kind of database session managing device, including system configuration module, data acquisition module, data point
It analyses module and shows warning module,
System configuration module is used to be arranged the configuration information of database, and support is interacted with user；
Data acquisition module is used for acquisition database session related information；
Data analysis module is electrically connected with data acquisition module, the database session relevant information that analytical calculation acquires and life
At analysis as a result, judging whether database session occurs abnormal and whether cause to the system for using database based on the analysis results
It influences, analysis result and judging result is supplied to displaying warning module；
Show that warning module makes corresponding operation according to judging result, and analysis result and judging result are organized into can
It is shown for the data of displaying, or analysis result and judging result is supplied to third party system module with interface form and made
With.
A kind of database session management method corresponding to the above device is provided simultaneously,
The configuration information of database is set, support is interacted with user,
Then acquisition database session related information,
The database session relevant information of analytical calculation acquisition simultaneously generates analysis as a result, judging database based on the analysis results
Whether whether session occur abnormal and impact to the system for using database,
Corresponding operation is made according to judging result, and analysis result is organized into and is shown for the data of displaying,
Or analysis result is supplied to third party system module with interface form and is used.
The present invention will be further explained below with reference to the attached drawings and specific examples, so that those skilled in the art can be with
It more fully understands the present invention and can be practiced, but illustrated embodiment is not as a limitation of the invention.
Using apparatus of the present invention and method, certain database session is managed, wherein apparatus of the present invention include that system is matched
Set module, data acquisition module, data analysis module and show warning module, system configuration module as a whole with merging
Mouthful, for a separate unit of the device, data acquisition module is the data collection module of system, provides data for subsequent analysis
Source is supported, shows that display unit of the warning module as system, predominantly display data carry out tissue and displaying,
System configuration module supports user's interaction, and user can be supported to switch disparate databases type, configuration information packet
Include the information such as type of database, user log-in authentication information, sampling time interval, log recording mode, data acquisition module master
It is used to acquire the data of track database session, data analysis module is used to collect the analysis processing of data, for anomalous field
Scape carries out qualitative analysis and provides analysis as a result, showing that warning module is used to analyze the displaying of data or is standardized to data
Processing externally provides data resource interface, and the abnormal conditions found for analysis carry out timely early warning,
Specific implementation process are as follows:
Step 1: system configuration module support is interacted with user, and the configuration information of database is arranged, passes through graphic interface
The information such as the settable user log-in authentication of user, tool tracing mode, log recording mode, wherein log recording mode can be with
File mode storage；Log can also be individually saved in database in corresponding log sheet in case subsequent use, above two
Kind of log can save the log information of a period in case consulting according to actual needs, and have periodic cleaning mechanism to avoid because
Journal file occupied space it is excessive and to storage introduce excessive pressure, according to user demand, when log is saved in file, default with
The storage of Excel format, individual data file can be limited in 3M, settable modes of warning and monitoring mode in the present apparatus, early warning mould
The journal file that formula and monitoring mode generate samples different naming rules；When log recording is to database table, two kinds of tracking moulds
Formula log is recorded respectively in different database tables.According to business scenario, when with full dose mode tracking, monitoring mode log is silent
Recognize and saves nearly log in two weeks；When being tracked with modes of warning, trace log full dose is saved,
When the present apparatus is run with tracing mode, prefabricated scene can be analyzed；Meanwhile complete database will be recorded
Session log information thinks with the system mode of database session just when analyzing result less than prefabricated scene alarm threshold
Often, when system mode is normal, analysis result related content will not be included in log, when analyzing results abnormity, analyzes result
It will be shown before log in a manner of abstract,
Step 2: the data information of acquisition database session, wherein according to the sample frequency track database meeting of user setting
Information is talked about, for the validity for guaranteeing data, section is can be set between 3s-120s in sampling time interval；
Step 3: the data information analysis processing of acquisition, and the configuration information according to analysis result according to setting carries out log
Record, this by taking database session blocks as an example, further illustrates the specific implementation of analysis processing, wherein detailed process in the process
Are as follows:
Obtain database session
SELECT
SESSION_ID,STATUS,SQL_ID,SQL_TEXT,WAIT_TIME,WAIT_RESOURCE,LOGIN_NAME,
PROGRAME_NAME,HOST_NAME FROM DB_SESSION；
When WAIT_TIME be greater than 30 seconds, that is, think the obstruction for occurring causing to significantly affect to system performance；When database meeting
When the ratio of obstruction session is more than 50% in words, that is, think the Severe blockage for occurring integrally having an impact system.Blocking out
Now, record is blocked session and blockage source session related information.
Acquisition is blocked session information
SELECT
SESSION_ID,STATUS,SQL_ID,SQL_TEXT,WAIT_TIME,WAIT_RESOURCE,LOGIN_NAME,
PROGRAME_NAME,HOST_NAME
FROM DB_SESSION
WHERE BLOCKED>0；
Acquisition is blocked source information
SELECT
SESSION_ID,STATUS,SQL_ID,SQL_TEXT,WAIT_TIME,WAIT_RESOURCE,LOGIN_NAME,
PROGRAME_NAME,HOST_NAME
FROM DB_SESSION
WHERE BLOCKED=0
AND SESSION_ID IN(SELECT SESSION_ID FROM DB_SESSION WHERE BLOCKED>0)；
In the above process, according to database session state and the time judges whether to block and whether current congestion can be to system
It causes globality to influence, blocks if there is database session, record obstruction is blocked session and obstruction source information, wherein
The information of record can carry out prefabricated according to the characteristic of user's actual need and database；
Step 4: according to user demand, after apparatus of the present invention analysis, can use and show that warning module passes through figure
Shape display panel show analysis and tracking content, to reach preset threshold value of warning result carry out early warning, can also according to
Family setting, is run with modes of warning or tracing mode, and the device will be according to record log be minimized, i.e., only under modes of warning
Analysis conclusion and log when recording exceptional, when tracing mode is run, which ties the trace log for recording full dose and analysis
By according to user demand, text being directly recorded as log information or be saved in database table, can also be used as
The data source of three method, systems is supplied to third party system use in the form of interface.
In addition, in another embodiment, specific implementation process are as follows:
Step 1: system configuration module support is interacted with user, and the configuration information of database is arranged, passes through graphic interface
The information such as the settable user log-in authentication of user, tool tracing mode, log recording mode, wherein log recording mode can be with
File mode storage；Log can also be individually saved in database in corresponding log sheet in case subsequent use, above two
Kind of log can save the log information of a period in case consulting according to actual needs, and have periodic cleaning mechanism to avoid because
Journal file occupied space it is excessive and to storage introduce excessive pressure, according to user demand, when log is saved in file, default with
The storage of Excel format, individual data file can be limited in 3M, settable modes of warning and monitoring mode in the present apparatus, early warning mould
The journal file that formula and monitoring mode generate samples different naming rules；When log recording is to database table, two kinds of tracking moulds
Formula log is recorded respectively in different database tables.According to business scenario, when with full dose mode tracking, monitoring mode log is silent
Recognize and saves nearly log in two weeks；When being tracked with modes of warning, trace log full dose is saved,
When the present apparatus is run with tracing mode, prefabricated scene can be analyzed；Meanwhile complete database will be recorded
Session log information thinks with the system mode of database session just when analyzing result less than prefabricated scene alarm threshold
Often, when system mode is normal, analysis result related content will not be included in log, when analyzing results abnormity, analyzes result
It will be shown before log in a manner of abstract,
Step 2: the data information of acquisition database session, wherein according to the sample frequency track database meeting of user setting
Information is talked about, for the validity for guaranteeing data, section is can be set between 3s-120s in sampling time interval；
Step 3: the data information analysis processing of acquisition, and the configuration information according to analysis result according to setting carries out log
Record, this by taking database session connection leakage as an example, further illustrates the specific implementation that analysis is handled, wherein specific mistake in the process
Journey are as follows:
The quantity of difference SQL in the current connection of statistics,
SELECT SQL_ID,COUNT(SQL_ID)AS SQL_COUNT FROM DB_SESSION WHERE BLOCKED
>0GROUP BY SQL_ID ORDER BY COUNT(SQL_ID)DESC；
The current connection sum of statistics,
SELECT COUNT(SESSION_ID)AS SESSION_COUNT FROM DB_SESSION；
Work as SQL_COUNT/SESSION_COUNT > 30%, and thinks occur due to ID being SQL_ when SQL_COUNT > 25
Leakage problem is connected caused by the SQL of ID, when the ratio for connecting leakage in database session is more than given threshold, it is believed that occur
The serious connection that system integrally has an impact is leaked,
Configuration information and analysis result according to setting carry out log recording,
Step 4: according to user demand, after apparatus of the present invention analysis, can use and show that warning module passes through figure
Shape display panel show analysis and tracking content, to reach preset threshold value of warning result carry out early warning, can also according to
Family setting, is run with modes of warning or tracing mode, and the device will be according to record log be minimized, i.e., only under modes of warning
Analysis conclusion and log when recording exceptional, when tracing mode is run, which ties the trace log for recording full dose and analysis
By according to user demand, text being directly recorded as log information or be saved in database table, can also be used as
The data source of three method, systems is supplied to third party system use in the form of interface.
Embodiment described above is only to absolutely prove preferred embodiment that is of the invention and being lifted, protection model of the invention
It encloses without being limited thereto.Those skilled in the art's made equivalent substitute or transformation on the basis of the present invention, in the present invention
Protection scope within.Protection scope of the present invention is subject to claims.
Claims (8)
1. a kind of database session managing device, it is characterized in that
Including system configuration module, data acquisition module, data analysis module and show warning module,
System configuration module is used to be arranged the configuration information of database, and support is interacted with user；
Data acquisition module is used for acquisition database session related information；
Data analysis module is electrically connected with data acquisition module, the database session relevant information that analytical calculation acquires and generation point
Analysis as a result, judge whether database session occurs abnormal and whether cause shadow to the system for using database based on the analysis results
It rings, analysis result and judging result is supplied to displaying warning module；
It shows that warning module makes corresponding operation according to judging result, and analysis result and judging result is organized into for exhibition
The data shown are shown, or analysis result and judging result are supplied to third party system module with interface form and used.
2. the apparatus according to claim 1, it is characterized in that the configuration information of system configuration module setting includes class database
Type, user log-in authentication information, sample information, log information.
3. the apparatus of claim 2, it is characterized in that system configuration module is according to the different moulds run in described device
Block records corresponding log information in different ways.
4. device according to claim 1 to 3, it is characterized in that data analysis module is former according to problematic phenomenon and problem
Because of distinguishing analysis as a result, obtained analysis result will be supplied to displaying warning module.
5. a kind of database session management method, it is characterized in that
The configuration information of database is set, support is interacted with user,
Then acquisition database session related information,
The database session relevant information of analytical calculation acquisition simultaneously generates analysis as a result, judging database session based on the analysis results
Whether occur abnormal and whether the system for using database impacted,
Corresponding operation is made according to judging result, and analysis result is organized into and is shown for the data of displaying, or
Analysis result is supplied to third party system module with interface form to use.
6. according to the method described in claim 5, it is characterized in that specific steps are as follows:
Step 1: the configuration information of database is set, and configuration information includes type of database, user log-in authentication information, sampling letter
Breath, log information,
Step 2: according to sample frequency track database session related information, at interval of certain time with regard to acquisition database session phase
Information is closed,
Step 3: the database session relevant information of collection being subjected to calculating analysis, judges that database session is based on the analysis results
Whether no appearance is abnormal and impact to the system for using database, and carries out according to the configuration information of setting and analysis result
Log recording,
Step 4: corresponding operation being made according to judging result, and analysis result and judging result are organized into the number for displaying
Third party system module is supplied to interface form and is used according to being shown, or by analysis result and judging result.
7. according to the method described in claim 6, it is characterized in that
Step 1: the configuration information of database is set, and configuration information includes type of database, user log-in authentication information, sampling letter
Breath, log information,
Step 2: according to sample frequency track database session related information, at interval of certain time with regard to acquisition database session phase
Information is closed, database session relevant information includes database session status information and temporal information,
Step 3: the database session relevant information of collection being subjected to calculating analysis, wherein WAIT_ is worked as in judgement based on the analysis results
TIME is greater than given threshold, it is believed that database session appearance causes the obstruction significantly affected to system performance；Work as database session
When the ratio of middle obstruction session is more than given threshold, it is believed that there is the Severe blockage integrally having an impact to system,
Configuration information and analysis result according to setting carry out log recording,
Step 4: corresponding operation being made according to judging result, and analysis result and judging result are organized into the number for displaying
Third party system module is supplied to interface form and is used according to being shown, or by analysis result and judging result.
8. according to the method described in claim 6, it is characterized in that
Step 1: the configuration information of database is set, and configuration information includes type of database, user log-in authentication information, sampling letter
Breath, log information,
Step 2: according to sample frequency track database session related information, at interval of certain time with regard to acquisition database session phase
Information is closed, database session relevant information includes the machine name information and Java DataBase Connection type letter in database session source
The quantity of difference SQL and current connection sum in breath and current database session connection,
Step 3: the database session relevant information of collection being subjected to calculating analysis, wherein SQL_ is worked as in judgement based on the analysis results
COUNT/SESSION_COUNT is greater than given threshold, and when SQL_COUNT > given threshold, it is believed that occurs due to ID being SQL_ID
SQL caused by database session connection leakage,
When the ratio for connecting leakage in database session is more than given threshold, it is believed that appearance integrally has an impact system tight
Reconnection leakage,
Configuration information and analysis result according to setting carry out log recording,
Step 4: corresponding operation being made according to judging result, and analysis result and judging result are organized into the number for displaying
Third party system module is supplied to interface form and is used according to being shown, or by analysis result and judging result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910174557.XA CN109918547A (en) | 2019-03-08 | 2019-03-08 | A kind of database session management method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910174557.XA CN109918547A (en) | 2019-03-08 | 2019-03-08 | A kind of database session management method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109918547A true CN109918547A (en) | 2019-06-21 |
Family
ID=66963893
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910174557.XA Pending CN109918547A (en) | 2019-03-08 | 2019-03-08 | A kind of database session management method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109918547A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112291310A (en) * | 2020-10-14 | 2021-01-29 | 杭州迪普科技股份有限公司 | Method and device for counting connection number |
| CN112732820A (en) * | 2021-01-26 | 2021-04-30 | 中国人寿保险股份有限公司上海数据中心 | Database session management system and method thereof |
| CN113641736A (en) * | 2021-10-13 | 2021-11-12 | 云和恩墨(北京)信息技术有限公司 | Method and device for displaying session blocking source |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050097149A1 (en) * | 2003-11-05 | 2005-05-05 | Lumigent Technologies, Inc. | Data audit system |
| CN101989283A (en) * | 2009-08-04 | 2011-03-23 | 中兴通讯股份有限公司 | Monitoring method and device of performance of database |
| CN103729361A (en) * | 2012-10-12 | 2014-04-16 | 百度在线网络技术（北京）有限公司 | Method and device for testing performance of database |
| CN107135119A (en) * | 2017-04-18 | 2017-09-05 | 国网福建省电力有限公司 | A kind of service response tracking and interface status monitor development system |
-
2019
- 2019-03-08 CN CN201910174557.XA patent/CN109918547A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050097149A1 (en) * | 2003-11-05 | 2005-05-05 | Lumigent Technologies, Inc. | Data audit system |
| CN101989283A (en) * | 2009-08-04 | 2011-03-23 | 中兴通讯股份有限公司 | Monitoring method and device of performance of database |
| CN103729361A (en) * | 2012-10-12 | 2014-04-16 | 百度在线网络技术（北京）有限公司 | Method and device for testing performance of database |
| CN107135119A (en) * | 2017-04-18 | 2017-09-05 | 国网福建省电力有限公司 | A kind of service response tracking and interface status monitor development system |
Non-Patent Citations (1)
| Title |
|---|
| 王伟平等: "Informix数据库安全审计系统设计与实现", 《计算技术与自动化》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112291310A (en) * | 2020-10-14 | 2021-01-29 | 杭州迪普科技股份有限公司 | Method and device for counting connection number |
| CN112291310B (en) * | 2020-10-14 | 2022-04-26 | 杭州迪普科技股份有限公司 | Method and device for counting connection number |
| CN112732820A (en) * | 2021-01-26 | 2021-04-30 | 中国人寿保险股份有限公司上海数据中心 | Database session management system and method thereof |
| CN112732820B (en) * | 2021-01-26 | 2024-05-17 | 中国人寿保险股份有限公司上海数据中心 | Database session management system and method thereof |
| CN113641736A (en) * | 2021-10-13 | 2021-11-12 | 云和恩墨(北京)信息技术有限公司 | Method and device for displaying session blocking source |
| CN113641736B (en) * | 2021-10-13 | 2022-01-25 | 云和恩墨(北京)信息技术有限公司 | Method and device for displaying session blocking source |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7966526B2 (en) | Software event recording and analysis system and method of use thereof | |
| CN109918547A (en) | A kind of database session management method and device | |
| CN106301971A (en) | Electric power application performance monitoring system based on flow analysis | |
| CN100589418C (en) | The generation method and the generation system of alarm correlation rule | |
| CN108170580A (en) | A kind of rule-based log alarming method, apparatus and system | |
| CN104966172A (en) | Large data visualization analysis and processing system for enterprise operation data analysis | |
| CN106598741B (en) | Distributed A/B test method and system for personalized recommendation system and video recommendation system | |
| US20130121580A1 (en) | Analysis of service delivery processes based on interrogation of work assisted devices | |
| CN105071969A (en) | JMX (Java Management Extensions)-based customization real-time monitoring and automatic exception handling system and method | |
| CN103378982A (en) | Internet business operation monitoring method and Internet business operation monitoring system | |
| CN105574150A (en) | Data processing method and device | |
| CN102143017B (en) | Service real-time monitoring method and system | |
| US20020026433A1 (en) | Knowledge system and methods of business alerting and business analysis | |
| CN113138906A (en) | Call chain data acquisition method, device, equipment and storage medium | |
| CN111784176A (en) | Data processing method, device, server and medium | |
| CN110532153A (en) | A kind of business level user's operation experience visualization system | |
| CN115392802A (en) | Method, system, medium, and apparatus for detecting defects of industrial products | |
| CN114595473A (en) | Access data processing method and device, electronic equipment and computer readable medium | |
| CN104239473B (en) | The device and method of data cross-system disposal is carried out based on natural language industry knowledge base | |
| CN113220543A (en) | Automatic service alarm method and device | |
| CN113179179A (en) | Algorithm for positioning service calling success rate index abnormal clue | |
| CN110703183A (en) | Intelligent electric energy meter fault data analysis method and system | |
| CN111274143A (en) | Buried point testing method, device, equipment and storage medium | |
| CN109800132A (en) | A kind of software development monitoring device and method | |
| CN110532242B (en) | Service message sending method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190621 |