CN109446043A - A kind of application log is analyzed in real time and real-time monitoring system for database - Google Patents
A kind of application log is analyzed in real time and real-time monitoring system for database Download PDFInfo
- Publication number
- CN109446043A CN109446043A CN201811203936.9A CN201811203936A CN109446043A CN 109446043 A CN109446043 A CN 109446043A CN 201811203936 A CN201811203936 A CN 201811203936A CN 109446043 A CN109446043 A CN 109446043A
- Authority
- CN
- China
- Prior art keywords
- database
- module
- monitoring
- information
- real
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3452—Performance evaluation by statistical analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3003—Monitoring arrangements specially adapted to the computing system or computing system component being monitored
- G06F11/302—Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system component is a software system
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3466—Performance evaluation by tracing or monitoring
- G06F11/3476—Data logging
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Quality & Reliability (AREA)
- General Physics & Mathematics (AREA)
- Computer Hardware Design (AREA)
- Computing Systems (AREA)
- Mathematical Physics (AREA)
- Life Sciences & Earth Sciences (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Bioinformatics & Computational Biology (AREA)
- Evolutionary Biology (AREA)
- Probability & Statistics with Applications (AREA)
- Debugging And Monitoring (AREA)
Abstract
It is analyzed in real time the invention discloses a kind of application log and real-time monitoring system for database, including system synthesis, the system synthesis includes data source tracing module, database cursor monitoring module, database instance monitoring module, database session monitoring module, database table space monitoring module, database audit log monitoring module, database table space threshold alarm module, security device advanced alarm module, Database error code monitoring and inquiry module, database asm disk size monitoring module.
Description
Technical field
The present invention relates to on-line system for monitoring technical field more particularly to a kind of application log is analyzed in real time and database
Real-time monitoring system.
Background technique
Part monitor supervision platform carries out the monitoring deployment of application performance for core CSGII system at present, realizes to key
The real time monitoring and alarm of the web calling process of application.Preliminary taking the initiative property, prevention sexual norm monitor to enhance application system
Ability.But data collection capacity, data correlation degree is insufficient, is unable to satisfy the monitoring capacity for further promoting application system, protection
The O&M demand of ability, safe early warning ability and Ability of emergency management.The intuitive of the method for the displaying of another aspect data is not
Foot causes the service object of platform excessively to limit to, and is unable to satisfy to the working simultaneously to roles such as O&M, business, manufacturer, decisions
The various dimensions such as business working order, function service condition, workflow situation, system performance and application problem positioning analysis show clothes
The demand of business platform.
Summary of the invention
It is analyzed in real time it is an object of the invention to overcome the deficiencies of the prior art and provide a kind of application log and database
Real-time monitoring system.
In order to achieve the goal above, the technical scheme adopted by the invention is that:
A kind of application log is analyzed in real time and real-time monitoring system for database, it is characterised in that: including system synthesis, institute
Stating system synthesis includes data source tracing module, database cursor monitoring module, database instance monitoring module, database
Monitoring session module, database table space monitoring module, database audit log monitoring module, database table space threshold alarm
Module, security device advanced alarm module, Database error code monitoring and inquiry module, database asm disk size monitoring module；
Wherein the data source tracing module is for selecting inquiry using data, operation control, middleware and database dependency number
According to the access situation in source；The database cursor monitoring module passes through patterned for analyzing data vernier situation in real time
Mode intuitively provides the utilization rate of vernier and is monitored；The database instance monitoring module is used for monitoring data library example
Operating condition, support to check the information of instance name and operating status at timed intervals；The database session monitors mould
Block checks for session information, temporally puts that the various ways such as session station and number of sessions curve are detailed to show selection
The session case and status information of node；Database table space monitoring module by way of visualize icon by all means
Newest and historical data table space the service condition of each database of display access monitoring；The database audit log
Monitoring module temporally obtains the information such as audit log quantity, type and audit time；It is described according to the time period, threshold values be condition
Retrieval is more than the table space quantity of threshold values and the details more than threshold values table space；Database table space threshold alarm
Module, the warning information for implementing display security device support the comprehensive of the information such as alarm grade, time, details and alarm source
It closes and shows；The security device advanced alarm module supports to implement the warning information of display security device, support alarm grade, when
Between, the comprehensive displays of details and alarm source etc. information；The Database error code monitoring and inquiry module has real-time acquisition
The ability of Database error code, and Database error code can be realized monitoring and supervising, it is grasped by graphical easy analysis
Database error situation；The database asm disk size monitoring module is for the in-depth monitoring of database ASM disk size, packet
Graphical representation containing information such as control alarm, surplus, utilization rates.
Preferably, the system synthesis further includes having workbench, and the workbench is used to retrieve being configured for support
The function of temporal information and data summarization, while accessing log information.
Preferably, the system synthesis further includes having operation control homepage, and the operation control homepage is for providing monitoring
The abstract statistical information for accessing quantity, data access trend, registration and event, facilitates supervisor to check audit information.
Preferably, the system synthesis further includes having database overview module, and the database overview module is used for data
The total monitoring look facility in library can check that each example, session and vernier, operating status etc. are complete in this function
Portion's information.
Preferably, the system synthesis further includes having operation control alarm overview module, the operation control alarm overview
Module supports the overview of multi-class warning information, includes host alarm, safety equipment alarm and network equipment warning light letter
Breath supports that temporally condition is screened.
Preferably, system synthesis access by operating system, vmware, database, firewall, interchanger, router,
The log information that third-party application generates.
Preferably, the access way between the log information and system synthesis includes database reading, journal file
It reads and syslog is accessed.
The beneficial effects of the present invention are: log is analyzed in real time and real-time monitoring system for database has for of the invention applying
Data source tracing module, database cursor monitoring module, database instance monitoring module, database session monitoring module, number
According to library table space monitoring module, database audit log monitoring module.It can provide for customized table, curve graph, cake chart
Etc. data analysis show configuration tool, software user of service can be shown by the tool self-defined report, can accomplish log
Data analysis visualization, clearing.In addition, the present invention also has database table space threshold alarm module, security device advanced
Alarm module, Database error code monitoring and inquiry module, database asm disk size monitoring module are, it can be achieved that alarm monitoring
Function is monitored in real time, is alerted for accessible system.
Detailed description of the invention
Fig. 1 is the principle of the present invention figure.
Specific embodiment
Claimed technical solution of the invention is described in further detail now in conjunction with the drawings and specific embodiments.
Shown in Figure 1, analyzing in real time in the present embodiment using log and real-time monitoring system for database include being
System assembly, the system synthesis include workbench, operation control homepage, data source tracing module, database cursor monitoring mould
Block, database instance monitoring module, database session monitoring module, database table space monitoring module, database overview module,
Database audit log monitoring module, database table space threshold alarm module, security device advanced alarm module, database are wrong
Error code monitoring and inquiry module, database asm disk size monitoring module, operation control alarm overview module.System synthesis is with number
According to library read, journal file read and syslog access mode access by operating system, vmware, database, firewall,
The log information that interchanger, router, third-party application generate.
Wherein, the workbench be used for retrieve support the temporal information being configured and data summarization and function,
Access " data overview ", " log audit ", " association analysis ", " OCS applied system analysis " and the instrument that can be convenient simultaneously
The express passway of disk.
The operation control homepage is used to provide the abstract of monitoring access quantity, data access trend, registration and event
Statistical information, it is convenient to check audit information by all means.
The data source tracing module is for selecting inquiry using data, operation control, middleware and database phase
Close the access situation of data source.
The database cursor monitoring module analyzes data vernier situation for real-time, and intuitive by patterned mode
Offer vernier utilization rate and be monitored.
The database instance monitoring module is used for the operating condition of monitoring data library example, and support is checked at timed intervals
The information of instance name and operating status.
The database session monitoring module checks for session information, temporally point, session station skin and number of sessions
The session case and status information of the detailed node for showing selection of the various ways such as curve.
Display access of the database table space monitoring module by way of visualizing icon by all means monitors each
Newest and historical data table space the service condition of database.
The database overview module is used for the total monitoring look facility of database, can check in this function
The all information such as each example, session and vernier, operating status.
The database audit log monitoring module temporally obtains the letters such as audit log quantity, type and audit time
Breath.
The database table space threshold alarm module according to the time period, threshold values be conditional information retrieval be more than threshold values table space number
Amount and more than threshold values table space details.
The database table space threshold alarm module, the warning information for implementing display security device, support alarm grade,
The comprehensive display of the information such as time, details and alarm source.
The warning information of the security device advanced alarm module support implementation display security device, support alarm grade,
The comprehensive display of the information such as time, details and alarm source.
The Database error code monitoring and inquiry module has the ability for obtaining Database error code in real time, and can incite somebody to action
Database error code realizes monitoring and supervising, grasps Database error situation by graphical easy analysis.
The database asm disk size monitoring module is accused for the in-depth monitoring of database ASM disk size, comprising control
The graphical representation of the information such as police, surplus, utilization rate.
The operation control alarm overview module supports the overview of multi-class warning information, includes host alarm, safety
Equipment alarm and network equipment warning light information support that temporally condition is screened.
The embodiment of the above is only presently preferred embodiments of the present invention, not does limit in any form to the present invention
System.Anyone skilled in the art, without departing from the scope of the technical proposal of the invention, all using the disclosure above
Technology contents more possible variations and retouching are made to technical solution of the present invention, or be revised as the equivalence enforcement of equivalent variations
Example.Therefore all contents without departing from technical solution of the present invention, equivalent equivalence changes, should all cover made by thinking according to the present invention
In in protection scope of the present invention.
Claims (6)
1. a kind of application log is analyzed in real time and real-time monitoring system for database, it is characterised in that: described including system synthesis
System synthesis includes data source tracing module, database cursor monitoring module, database instance monitoring module, database meeting
Talk about monitoring module, database table space monitoring module, database audit log monitoring module, database table space threshold alarm mould
Block, security device advanced alarm module, Database error code monitoring and inquiry module, database asm disk size monitoring module；Its
Described in data source tracing module for selecting inquiry using data, operation control, middleware and database related data
The access situation in source；The database cursor monitoring module passes through patterned side for analyzing data vernier situation in real time
Formula intuitively provides the utilization rate of vernier and is monitored；The database instance monitoring module is for monitoring data library example
Operating condition supports the information for checking instance name and operating status at timed intervals；The database session monitoring module
It is checked for session information, temporally puts the detailed section for showing selection of the various ways such as session station and number of sessions curve
The session case and status information of point；Database table space monitoring module by all means aobvious by way of visualizing icon
Show newest and historical data table space the service condition of each database of access monitoring；The database audit log prison
Control module temporally obtains the information such as audit log quantity, type and audit time；It is described according to the time period, threshold values be condition inspection
Rope is more than the table space quantity of threshold values and the details more than threshold values table space；The database table space threshold alarm mould
Block, the warning information for implementing display security device support the synthesis of the information such as alarm grade, time, details and alarm source
It shows；The security device advanced alarm module supports to implement the warning information of display security device, support alarm grade, when
Between, the comprehensive displays of details and alarm source etc. information；The Database error code monitoring and inquiry module has real-time acquisition
The ability of Database error code, and Database error code can be realized monitoring and supervising, it is grasped by graphical easy analysis
Database error situation；The database asm disk size monitoring module is for the in-depth monitoring of database ASM disk size, packet
Graphical representation containing information such as control alarm, surplus, utilization rates.
2. a kind of application log according to claim 1 is analyzed in real time and real-time monitoring system for database, feature exist
In: the system synthesis further includes having workbench, the workbench be used for retrieve support the temporal information being configured and
The function of data summarization, while accessing log information.
3. a kind of application log according to claim 1 is analyzed in real time and real-time monitoring system for database, feature exist
In: the system synthesis further includes having operation control homepage, and the operation control homepage is for providing monitoring access quantity, data
The abstract statistical information of access trend, registration and event, facilitates supervisor to check audit information.
4. a kind of application log according to claim 1 is analyzed in real time and real-time monitoring system for database, feature exist
In: the system synthesis further includes having database overview module, and the database overview module is used for the total prison of database
Look facility is controlled, all information such as each example, session and vernier, operating status can be checked in this function.
5. a kind of application log according to claim 1 is analyzed in real time and real-time monitoring system for database, feature exist
In: the system synthesis further includes having operation control alarm overview module, and the operation control alarm overview module supports multiclass
The overview of other warning information is supported temporally comprising host alarm, safety equipment alarm and network equipment warning light information
Condition is screened.
6. a kind of application log according to claim 1 is analyzed in real time and real-time monitoring system for database, feature exist
In: the system synthesis access is produced by operating system, vmware, database, firewall, interchanger, router, third-party application
Raw log information.
A kind of application log according to claim 6 is analyzed in real time and real-time monitoring system for database, it is characterised in that:
Access way between the log information and system synthesis includes that database is read, journal file is read and syslog connects
Enter.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811203936.9A CN109446043A (en) | 2018-10-16 | 2018-10-16 | A kind of application log is analyzed in real time and real-time monitoring system for database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811203936.9A CN109446043A (en) | 2018-10-16 | 2018-10-16 | A kind of application log is analyzed in real time and real-time monitoring system for database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109446043A true CN109446043A (en) | 2019-03-08 |
Family
ID=65546435
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811203936.9A Pending CN109446043A (en) | 2018-10-16 | 2018-10-16 | A kind of application log is analyzed in real time and real-time monitoring system for database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109446043A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115714807A (en) * | 2021-08-18 | 2023-02-24 | 上海宝信软件股份有限公司 | Design system of platform in industrial scene data |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105407011A (en) * | 2015-10-26 | 2016-03-16 | 贵州电网公司信息通信分公司 | IT base platform monitoring index acquisition system and acquisition method |
| CN105843803A (en) * | 2015-01-12 | 2016-08-10 | 上海悦程信息技术有限公司 | Big data security visualization interaction analysis system and method |
| US20180246778A1 (en) * | 2017-02-27 | 2018-08-30 | International Business Machines Corporation | Utilizing an error prediction and avoidance component for a transaction processing system |
-
2018
- 2018-10-16 CN CN201811203936.9A patent/CN109446043A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105843803A (en) * | 2015-01-12 | 2016-08-10 | 上海悦程信息技术有限公司 | Big data security visualization interaction analysis system and method |
| CN105407011A (en) * | 2015-10-26 | 2016-03-16 | 贵州电网公司信息通信分公司 | IT base platform monitoring index acquisition system and acquisition method |
| US20180246778A1 (en) * | 2017-02-27 | 2018-08-30 | International Business Machines Corporation | Utilizing an error prediction and avoidance component for a transaction processing system |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115714807A (en) * | 2021-08-18 | 2023-02-24 | 上海宝信软件股份有限公司 | Design system of platform in industrial scene data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102035855B (en) | Network security incident association analysis system | |
| CN107294764A (en) | Intelligent supervision method and intelligent monitoring system | |
| CN107577588A (en) | A kind of massive logs data intelligence operational system | |
| CN108063699B (en) | Network performance monitoring method and device, electronic equipment and storage medium | |
| CN103491354A (en) | System operation monitoring and controlling visual platform | |
| CN103765432A (en) | Visual component and drill down mapping | |
| US20110320240A1 (en) | Video-based analysis workflow proposal tool | |
| KR102067032B1 (en) | Method and system for data processing based on hybrid big data system | |
| CN103440161B (en) | A kind of Java virtual machine internal object monitoring method, device and system | |
| CN111782890A (en) | Equipment state analysis and management system | |
| CN110398927A (en) | A kind of integrated data information monitoring platform and monitoring system | |
| CN103023693A (en) | Behaviour log data management system and behaviour log data management method | |
| CN108694448A (en) | PHM platforms | |
| CN113282474A (en) | User behavior monitoring method, system, equipment and medium based on bastion machine | |
| CN117270937A (en) | Digital operation and maintenance management system | |
| CN109802843A (en) | A kind of network equipment monitoring system based on SNMP | |
| CN109446043A (en) | A kind of application log is analyzed in real time and real-time monitoring system for database | |
| CN117235169A (en) | Wisdom fortune dimension data storage platform | |
| CN116895046B (en) | Abnormal operation and maintenance data processing method based on virtualization | |
| CN103618635A (en) | Classified association management and control system of informationized equipment | |
| CN112688929A (en) | Sharing system based on internet threat information | |
| CN117478672A (en) | Intelligent control system based on cloud platform technology | |
| CN112084152A (en) | Full life cycle management system of electronic measuring instrument | |
| CN110415136B (en) | Service capability evaluation system and method for power dispatching automation system | |
| CN103676835B (en) | Cloud computing based safety monitoring and auxiliary operation method for petrochemical 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: 20190308 |
|
| RJ01 | Rejection of invention patent application after publication |