CN206258853U - A kind of database monitoring device - Google Patents
A kind of database monitoring device Download PDFInfo
- Publication number
- CN206258853U CN206258853U CN201621359188.XU CN201621359188U CN206258853U CN 206258853 U CN206258853 U CN 206258853U CN 201621359188 U CN201621359188 U CN 201621359188U CN 206258853 U CN206258853 U CN 206258853U
- Authority
- CN
- China
- Prior art keywords
- module
- data
- electrical connected
- processing unit
- central processing
- 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.)
- Expired - Fee Related
Links
Abstract
The utility model discloses a kind of database monitoring device, the central processing unit is electrical connected with signal transmitting and receiving module, the signal transmitting and receiving module is communicated with mobile phone wireless by wireless network data and is connected, the central processing unit is electrical connected with SQL query module, the SQL query module is electrical connected with data acquisition module, the data acquisition module is electrical connected with database, the central processing unit is electrical connected with data memory module, the data memory module is electrical connected with Data Comparison module, the Data Comparison module is electrical connected with data acquisition module.The database monitoring device, by SQL query module and the structure of data acquisition module, data run state in database can be acquired, and the data feeding SQL query module of collection is analyzed inquiry, by data memory module and the structure of data contrast module, the speed of troubleshooting is accelerated.
Description
Technical field
The utility model is related to field of computer technology, specially a kind of database monitoring device.
Background technology
Database is the warehouse that data are organized, store and managed according to data structure, in recent years, because data are in interconnection
The sustainable growth in net field, each company all suffers from the process demand of mass data.It is each that data analysis in department is mainly company
Department O＆M service, data analysis is based primarily upon the server of all departments to be analyzed, so as to be corporate server O＆M pipe
Reason, assignment of traffic, estimate etc. suggestion is provided.The management of database and the key point that monitoring is the operation of each company, if data
There is mistake in storehouse, and mistake occur in some decision-makings and data that will make company, and great loss will necessarily be caused to company, but
At present to the system mostly imperfection of database monitoring, the speed of processing data is slower, and same error is occurring in database
In the case of be required for re-starting analysis and judge, therefore we have proposed a kind of database monitoring device
Utility model content
The purpose of this utility model is to provide a kind of database monitoring device, to solve what is proposed in above-mentioned background technology
Problem.
To achieve the above object, the utility model provides following technical scheme：A kind of database monitoring device, including center
Processor, the central processing unit is electrical connected with power module, and the central processing unit is electrical connected with display module, described
Central processing unit is electrical connected with input module, and the central processing unit is electrical connected with warning module, the central processing unit
It is electrical connected with signal transmitting and receiving module, the signal transmitting and receiving module is communicated by wireless network data with mobile phone wireless
It is connected, the central processing unit is electrical connected with SQL query module, the SQL query module and the electrical phase of data acquisition module
Even, the data acquisition module is electrical connected with database, and the central processing unit is electrical connected with data memory module, described
Data memory module is electrical connected with Data Comparison module, and the Data Comparison module is electrical connected with data acquisition module.
Preferably, the display module includes projecting apparatus, display screen and projection screen.
Preferably, the data acquisition module includes data acquisition unit and converter.
Preferably, the warning module includes buzzer and light emitting diode.
Preferably, the input module is keyboard and USB port.
Compared with prior art, the beneficial effects of the utility model are：The database monitoring device, by SQL query mould
The structure of block and data acquisition module, can be acquired to the data run state in database, and the data of collection are sent
Enter SQL query module and be analyzed inquiry, by data memory module and.The structure of Data Comparison module, data memory module
By central processing unit, to database, some data cases for breaking down are stored, and such database breaks down again
When, information transmission to Data Comparison module and Data Comparison module are carried from data memory module by data acquisition module
Take with data acquisition module identical data, if contrasted successfully, central processing unit will directly be taken out by data memory module
Win the confidence breath, the failure in display data storehouse accelerates the speed of troubleshooting.
Brief description of the drawings
Fig. 1 is the utility model principle schematic diagram..
In figure：1 central processing unit, 2 display modules, 3 power modules, 4 signal transmitting and receiving modules, 5 radio data networks,
It is 6 mobile phones, 7 SQL query modules, 8 data acquisition modules, 9 databases, 10 Data Comparison modules, 11 data memory modules, 12 pre-
Alert module, 13 input modules.
Specific embodiment
Below in conjunction with the accompanying drawing in the utility model embodiment, the technical scheme in the utility model embodiment is carried out
Clearly and completely describe, it is clear that described embodiment is only a part of embodiment of the utility model, rather than whole
Embodiment.Based on the embodiment in the utility model, those of ordinary skill in the art are not under the premise of creative work is made
The every other embodiment for being obtained, belongs to the scope of the utility model protection.
Fig. 1 is referred to, the utility model provides a kind of technical scheme：A kind of database monitoring device, including center treatment
Device 1, central processing unit 1 is master controller.The central processing unit 1 is electrical connected with power module 3, and power module 3 is equipment
Power supply is provided, the treatment by power module 3 to voltage, for equipment provides suitable voltage, enables a device to normal work,
The central processing unit 1 is electrical connected with display module 2, and the display module 2 includes projecting apparatus, display screen and projection screen, shows
Show the relation of the data of database 9 that module 2 can be handled by display device, it can be seen that whether database 9 is normal.The center
Processor 1 is electrical connected with input module 13, and the input module 13 is keyboard and USB port, and staff can be by input
The input of module 13 needs the data of inquiry and the running status of data.The central processing unit 1 and the electrical phase of warning module 12
Even, the warning module 12 includes buzzer and light emitting diode, and warning module 12 is to point out whether database 9 occurs
Failure, if database 9 breaks down, can make buzzer sound by the control of central processing unit 1, and light emitting diode
It is luminous.The central processing unit 1 is electrical connected with signal transmitting and receiving module 4, and the signal transmitting and receiving module 4 is by wireless
Network data 5 is connected with the radio communication of mobile phone 6, and signal transmitting and receiving module 4 is to send out the result that central processing unit 1 is processed
Go, the end of mobile phone 6 is sent to by wireless network data 5, while the end of mobile phone 6 can also pass through wireless network by software input content
Network data 5 are sent to signal sending/receiving module 4, are sent to central processing unit 1 and are processed, and the information for the treatment of is sent in one's hands
On machine 6, even if can so make the staff can not also be apparent from the work of database 9 by mobile phone 6 in working site
Make state, staff can be enable to have the unnecessary time to do other things, a large amount of labours have been liberated, while also carrying
Operating efficiency high.The central processing unit 1 is electrical connected with SQL query module 7, the SQL query module 7 and data acquisition
Module 8 is electrical connected, and the data acquisition module 8 includes data acquisition unit and converter.The data acquisition module 8 and number
It is electrical connected according to storehouse 9, the collection that data acquisition module 8 passes through the data run situation to database 9, by converter letter
Number sending SQL query module 7 to carries out query analysis, and the result of query analysis is sent in central processing unit 1, in
The treatment of central processor 1, result is displayed on the display screen of display module 2, if the result of query analysis is abnormal, center
Buzzer sounds during processor 1 will control warning module 12, and lumination of light emitting diode, and data display in display mould
On the display screen of block 2.The central processing unit 1 is electrical connected with data memory module 11, the data memory module 11 with number
It is electrical connected according to contrast module 10, the Data Comparison module 10 is electrical connected with data acquisition module 8, data memory module 11
By central processing unit 1, to database 9, some data cases for breaking down are stored, when database 9 breaks down again
When, by data acquisition module 8 information transmission to Data Comparison module 10 and Data Comparison module 10 from data storage mould
The data with the phase pain of data acquisition module 8 are extracted in block 11, if contrasted successfully, central processing unit 1 will be by data storage
The direct Extracting Information of module 11, the failure in display data storehouse 9 otherwise will be by SQL query module 7 to data acquisition module 8
The data of collection are inquired about, so by the storage of fault data, when database 9 is broken down, if gone out before failure
Now cross, the step of inquiry will be saved so that data processing is very fast.
Operation principle：When equipment works, the collection that data acquisition module 8 passes through the data run situation to database 9 is led to
Crossing converter and transmitting signals to SQL query module 7 carries out query analysis, and the result of query analysis is sent to centre
In reason device 1, by the treatment of central processing unit 1, result is displayed on the display screen of display module 2, if query analysis
Result is abnormal, and buzzer sounds during central processing unit 1 will control warning module 12, and lumination of light emitting diode, and handle
On the display screen of display module 2, by central processing unit 1, to database 9, some data memory module 11 data display occur
The data cases of failure are stored, and when database 9 breaks down again, information transmission are arrived by data acquisition module 8
Data Comparison module 10 and Data Comparison module 10 are extracted and the identical number of data acquisition module 8 from data memory module 11
According to if contrasted successfully, central processing unit 1 will be by the direct Extracting Information of data memory module 11, the event in display data storehouse 9
The data that data acquisition module 8 is gathered will otherwise be inquired about, signal transmitting and receiving module by barrier by SQL query module 7
4 is to send the result that central processing unit 1 is processed, and the end of mobile phone 6 is sent to by wireless network data 5, while the end of mobile phone 6
Signal sending/receiving module 4 can also be sent to by wireless network data 5 by software input content, be sent to central processing unit
1 is processed, and the information for the treatment of is sent on mobile phone 6, even if can so make staff also can not in working site
The working condition of database 9 is enough apparent from by mobile phone 6.
While there has been shown and described that embodiment of the present utility model, for the ordinary skill in the art,
It is appreciated that these embodiments can be carried out various changes in the case where principle of the present utility model and spirit is not departed from, repaiies
Change, replace and modification, scope of the present utility model is defined by the appended claims and the equivalents thereof.
Claims (5)
1. a kind of database monitoring device, including central processing unit (1), it is characterised in that：The central processing unit (1) and power supply
Module (3) is electrical connected, and the central processing unit (1) is electrical connected with display module (2), the central processing unit (1) with it is defeated
Enter module (13) to be electrical connected, the central processing unit (1) is electrical connected with warning module (12), the central processing unit (1)
It is electrical connected with signal transmitting and receiving module (4), the signal transmitting and receiving module (4) is by wireless network data (5) and hand
Machine (6) radio communication is connected, and the central processing unit (1) is electrical connected with SQL query module (7), the SQL query module
(7) it is electrical connected with data acquisition module (8), the data acquisition module (8) is electrical connected with database (9), the center
Processor (1) is electrical connected with data memory module (11), and the data memory module (11) is electric with Data Comparison module (10)
Property be connected, the Data Comparison module (10) is electrical connected with data acquisition module (8).
2. a kind of database monitoring device according to claim 1, it is characterised in that：The display module (2) is including throwing
Shadow instrument, display screen and projection screen.
3. a kind of database monitoring device according to claim 1, it is characterised in that：Data acquisition module (8) bag
Include data acquisition unit and converter.
4. a kind of database monitoring device according to claim 1, it is characterised in that：The warning module (12) is including honeybee
Ring device and light emitting diode.
5. a kind of database monitoring device according to claim 1, it is characterised in that：The input module (13) is keyboard
And USB port.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201621359188.XU CN206258853U (en) | 2016-12-12 | 2016-12-12 | A kind of database monitoring device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201621359188.XU CN206258853U (en) | 2016-12-12 | 2016-12-12 | A kind of database monitoring device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN206258853U true CN206258853U (en) | 2017-06-16 |
Family
ID=59029397
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201621359188.XU Expired - Fee Related CN206258853U (en) | 2016-12-12 | 2016-12-12 | A kind of database monitoring device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN206258853U (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109149768A (en) * | 2018-09-10 | 2019-01-04 | 浙江电腾云光伏科技有限公司 | A kind of information management platform for photovoltaic power distribution network |
| CN111273592A (en) * | 2020-03-18 | 2020-06-12 | 安徽格雷皖创信息科技有限公司 | Big data acquisition and processing system of thing allies oneself with |
-
2016
- 2016-12-12 CN CN201621359188.XU patent/CN206258853U/en not_active Expired - Fee Related
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109149768A (en) * | 2018-09-10 | 2019-01-04 | 浙江电腾云光伏科技有限公司 | A kind of information management platform for photovoltaic power distribution network |
| CN111273592A (en) * | 2020-03-18 | 2020-06-12 | 安徽格雷皖创信息科技有限公司 | Big data acquisition and processing system of thing allies oneself with |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102750350B (en) | Monitoring system and method | |
| CN202903334U (en) | Cable intermediate joint temperature monitoring system | |
| CN104881352A (en) | System resource monitoring device based on mobile terminal | |
| CN206991380U (en) | A kind of intelligent interactive system of absorbent article production line | |
| CN206258853U (en) | A kind of database monitoring device | |
| CN107294788A (en) | A kind of method and device of troubleshooting | |
| CN106249714A (en) | A kind of distributed energy remote monitoring and managing system and method | |
| CN103366245B (en) | Electric network fault information issuing method based on OSB bus and system | |
| CN102984013B (en) | Alarm analysis method for communication transmission network | |
| CN103473936A (en) | Intelligent traffic signal control machine based on Internet of things | |
| CN206149326U (en) | Data acquisition analysis monitoring system | |
| CN202772610U (en) | Monitoring system for battery management systems of electric vehicles | |
| CN112505471A (en) | Transient disturbance-based early fault early warning and positioning system and method for looped network cable | |
| CN202190121U (en) | Monitoring system for power grid equipment | |
| CN202475463U (en) | Communication terminal monitoring device | |
| CN205666954U (en) | Data interchange monitored control system based on cloud calculates | |
| CN201681280U (en) | Remote monitoring wireless transmitter | |
| CN210327863U (en) | Information security vulnerability notification management and control system | |
| CN104578404A (en) | Online monitoring system for secondary equipment of power system | |
| CN202939482U (en) | Rail-transit automatic fare collection system station control center system | |
| CN204707132U (en) | For centralized monitor and the long distance control system of network management server group | |
| CN203191761U (en) | A device fault monitoring system of a rail transit automatic fare collection system station control center | |
| CN208506532U (en) | A kind of communication information equipment O&M intelligent alarm platform | |
| CN207354335U (en) | A kind of intelligence ground washing vehicle management system for internet of things | |
| CN202551066U (en) | System for quickly positioning failure nodes in cloud computing cluster |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20170616 Termination date: 20181212 |