CN105528278A - Method, device and system for determining index data state - Google Patents
Method, device and system for determining index data state Download PDFInfo
- Publication number
- CN105528278A CN105528278A CN201510943000.XA CN201510943000A CN105528278A CN 105528278 A CN105528278 A CN 105528278A CN 201510943000 A CN201510943000 A CN 201510943000A CN 105528278 A CN105528278 A CN 105528278A
- Authority
- CN
- China
- Prior art keywords
- achievement data
- index
- relational database
- monitored item
- state
- 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/3065—Monitoring arrangements determined by the means or processing involved in reporting the monitored data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Abstract
The invention relates to the field of computers and in particular discloses a method, a device and a system for determining index data state. The method comprises the following steps: obtaining at least one index datum from different types of index monitoring items in a target monitoring system; storing the at least one index datum in a relational database; determining the state of the at least one index datum according to the relational database and generating a determining result which is used for indicating the range and the validity of the at least one index datum. Through the method, the device and the system for determining the index data state, the index data state is determined by the relational database based on a conditional operation function of the relational database; complex and tedious mathematical relational operations in the prior art are abandoned; the realization process is simple; the efficiency is high.
Description
Technical field
The present invention relates to computer realm, particularly relate to a kind of method, equipment and system of Judging index data mode.
Background technology
Judging index data mode is a critical function in O&M monitoring system, and its fundamental purpose realizes judging the state of the achievement data gathered in target monitor system, carrys out the achievement data of evaluating objects supervisory system whether in rational scope.
At present, the method for widely used Judging index data mode normally utilizes mathematical relation computing to realize the judgement to achievement data state.When achievement data is more, when decision condition is more complicated, just need the judgement that the mathematical relation computing utilizing multiple complexity realizes achievement data state.This process implementation gets up comparatively complicated loaded down with trivial details, and execution efficiency is lower.
Summary of the invention
The invention provides a kind of method, equipment and system of Judging index data mode, with the complicated loaded down with trivial details and inefficient problem of the implementation procedure solving decision method of the prior art.
First aspect, the invention provides a kind of method of Judging index data mode, described method comprises:
From target monitor system, obtain at least one achievement data of dissimilar index monitored item;
At least one achievement data described is stored into relational database;
According to described relational database, judge the state of at least one achievement data described, generate result of determination, described result of determination is used to indicate scope and the validity of at least one achievement data described.
As the optimal way of first aspect, described from target monitor system, obtain at least one achievement data and comprise:
Arrange the dissimilar index monitored item of described target monitor system, described index monitored item comprises at least one achievement data;
According to described index monitored item, obtain the acquisition parameter of at least one achievement data described, described acquisition parameter comprises acquisition interface mode;
According to described acquisition interface mode, obtain at least one achievement data described.
As the optimal way of first aspect, describedly at least one achievement data described be stored into relational database comprise:
According to the type of described index monitored item, at least one achievement data described is stored into relational database.
As the optimal way of first aspect, described according to described relational database, the state of at least one achievement data described is judged, generates result of determination and comprise:
The decision condition preset according to described index monitored item is converted into the SQL statement can run in described relational database;
According to described SQL statement, the state of at least one achievement data described in storage is judged, generates result of determination.
Second aspect, the invention provides a kind of equipment of Judging index data mode, described equipment comprises:
Acquiring unit, for from target monitor system, obtains at least one achievement data of dissimilar index monitored item;
Storage unit, for being stored into relational database by least one achievement data described;
Identifying unit, for according to described relational database, judges the state of at least one achievement data described, generates result of determination, and described result of determination is used to indicate scope and the validity of at least one achievement data described.
As the optimal way of second aspect, described acquiring unit specifically for:
Arrange the dissimilar index monitored item of described target monitor system, described index monitored item comprises at least one achievement data;
According to described index monitored item, obtain the acquisition parameter of at least one achievement data described, described acquisition parameter comprises acquisition interface mode;
According to described acquisition interface mode, obtain at least one achievement data described.
As the optimal way of second aspect, described storage unit specifically for:
According to the type of described index monitored item, at least one achievement data described is stored into relational database.
As the optimal way of second aspect, described identifying unit specifically for:
The decision condition preset according to described index monitored item is converted into the SQL statement can run in described relational database;
According to described SQL statement, the state of at least one achievement data described in storage is judged, generates result of determination.
The third aspect, the present invention also provides a kind of system of Judging index data mode, and described system comprises:
Target monitor system, for providing at least one achievement data of dissimilar index monitored item;
Relational database, for storing at least one achievement data described;
And, the equipment of the Judging index data mode as described in second aspect.
Method, the equipment and system of Judging index data mode provided by the invention, based on the conditional operation function of relational database, the judgement to achievement data state is realized by relational database, abandon complicated loaded down with trivial details mathematical relation computing in prior art, implementation procedure is comparatively simple, and efficiency is higher.
Accompanying drawing explanation
In order to be illustrated more clearly in the technical scheme in the embodiment of the present invention, below the accompanying drawing used required in describing embodiment is briefly described, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
The method flow diagram of a kind of Judging index data mode that Fig. 1 provides for the embodiment of the present invention;
The method flow diagram of a kind of Judging index data mode that Fig. 2 provides for the embodiment of the present invention;
The structural representation of the equipment of a kind of Judging index data mode that Fig. 3 provides for the embodiment of the present invention;
The structural representation of the system of a kind of Judging index data mode that Fig. 4 provides for the embodiment of the present invention.
Embodiment
For making the object, technical solutions and advantages of the present invention clearly, below in conjunction with accompanying drawing, embodiment of the present invention is described further in detail.
The embodiment of the present invention provides a kind of method of Judging index data mode, and with reference to shown in Fig. 1, the method comprises:
101, from target monitor system, at least one achievement data of dissimilar index monitored item is obtained.
102, at least one achievement data is stored into relational database.
103, according to relational database, judge the state of at least one achievement data, generate result of determination, this result of determination is used to indicate scope and the validity of at least one achievement data.
The method of Judging index data mode provided by the invention, based on the conditional operation function of relational database, realize the judgement to achievement data state by relational database, abandon complicated loaded down with trivial details mathematical relation computing in prior art, implementation procedure is comparatively simple, and efficiency is higher.
The embodiment of the present invention provides a kind of method of Judging index data mode, can judge the achievement data state of multiple target monitor system simultaneously, and with reference to shown in Fig. 2, the method comprises:
201, the dissimilar index monitored item of Offered target supervisory system.
For needing the target monitor system judging its achievement data state, the index monitored item that it is dissimilar being first set, distinguishing each index monitored item according to its type.Wherein, each index monitored item all comprises at least one achievement data, the index monitored item Ping of such as monitor network connectedness, the achievement data got comprises: return state value (K1), packet success rate (K2), data two-way time (K3), these achievement datas can be organized into as [< index name K1, desired value V1>, < index name K2, desired value V2> ... ] mode.
202, according to index monitored item, obtain the acquisition parameter of at least one achievement data, acquisition parameter comprises acquisition interface mode.
When the index monitored item of Offered target supervisory system, also will corresponding to the acquisition parameter obtaining this at least one achievement data, this acquisition parameter not only comprises acquisition interface mode, also comprises destination object IP address, access port, usemame/password etc.
203, according to acquisition interface mode, at least one achievement data is obtained.
According to the acquisition interface mode that target monitor system provides, from target monitor system, obtain at least one achievement data that dissimilar index monitored item is corresponding, conventional acquisition interface mode comprises SNMPget mode, WMI interface mode, SSH interface mode, database interface mode, TCPSocket communication interface mode etc.
204, according to the type of index monitored item, at least one achievement data is stored into relational database.
At least one achievement data got in step 203, the index monitored item according to its correspondence stores in relational database.For the index monitored item of each type, set up a database table corresponding with it, the achievement data of the index monitored item of the same kind got from different target monitor system, be all stored in same database table.Each database table can be distinguished according to time field, the index monitored item Ping of such as monitor network connectedness, the achievement data got comprises: return state value (K1), packet success rate (K2), data two-way time (K3), a then corresponding PingMonitorData (InfoId [long] in relational database, K1 [number], K2 [number], K3 [number], Status [number], Time [date]) table, for storing the achievement data of index monitored item Ping.Wherein InfoId is the unique identification of data record, and K1, K2, K3 are the achievement data obtained, and Status is the state of achievement data, and Time is the acquisition time of achievement data.The achievement data of the index monitored item of the network connectivty of all target monitor systems got will all stored in PingMonitorData table.
205, the decision condition preset according to index monitored item is converted into the SQL statement can run in relational database.
When setting target monitored item, also preset decision condition according to this index monitored item, this decision condition is for evaluating the state of at least one achievement data simultaneously.Wherein, this decision condition stores with the form of Where clause in relational database.
For at least one achievement data got, the state of decision condition to achievement data according to presetting is needed to judge.The state of achievement data can be divided into: normal (0), common fault (1), gross error (2) etc.This decision condition judges for the scope of achievement data and validity, can be the complex logic combination of at least one achievement data got according to index monitored item.Such as, for the index monitored item Ping of monitor network connectedness, decision condition can be:
Gross error: (state value unequal to 200) or (packet success rate <90);
Common fault: data two-way time (ms) >200;
Normal: other, what do not belong to gross error and common fault all can think normal condition.
In prior art, when utilizing mathematical relation computing to realize the judgement to achievement data state, need first to carry out dissection process to decision condition, then the result of parsing is converted into the attainable conditional statement of a series of computer program, comprise comparison operator and logical operator etc., according to condition the execution result of statement obtains the state of achievement data again, and implementation procedure more complicated is loaded down with trivial details, and execution efficiency is lower.
In the embodiment of the present invention, the conditional operation function based on relational database simplifies this implementation procedure, and above-mentioned decision condition is converted into the Where clause in the relational database SQL statement of standard.
So, above-mentioned decision condition is converted into Where clause and is:
Gross error: (K1 unequal to 200) or (K2<90)
Common fault: K3>200
Normal: other.
206, according to SQL statement, judge the state of at least one achievement data stored, generate result of determination, this result of determination is used to indicate scope and the validity of at least one achievement data.
In step 205, above-mentioned decision condition is converted into the Where clause in the relational database SQL statement of standard, realize the judgement of at least one achievement data state according to this Where clause, generate result of determination, this result of determination can indicate scope and the validity of at least one achievement data.Such as, for the index monitored item Ping of monitor network connectedness, this decision process is:
(1), after at least one achievement data obtained is stored into the correspondence database table of relational database, unique major key InfoId value of achievement data is id.
(2) according to the Select statement in relational database, whether there is in conjunction with above-mentioned Where clause's inquiry the record of the decision condition meeting gross error, if had, then illustrate just stored in the state of achievement data of InfoId=id meet serious error condition, the state of this achievement data is gross error (2).SQL statement corresponding to this process is:
Selectcount(*)asErrnumfromPingMonitorData
Where(InfoId＝id)and((K1！＝200)or(K2<90))
If Errnum>0, then the state of this achievement data is gross error (2).
(3) otherwise, according to the Select statement in relational database, whether there is in conjunction with above-mentioned Where clause's inquiry the record of the decision condition meeting common fault, if had, then illustrate just stored in the state of achievement data of InfoId=id meet common fault condition, the state of this achievement data is common fault (1).SQL statement corresponding to this process is:
Selectcount(*)asErrnumfromPingMonitorData
Where(InfoId＝id)and(K3>200)
If Errnum>0, then the state of this achievement data is common fault (1).
(4) otherwise, the discontented state being enough to the achievement data of gross error or common fault condition is normally (0).
The method of Judging index data mode provided by the invention, based on the conditional operation function of relational database, realize the judgement to achievement data state by relational database, abandon complicated loaded down with trivial details mathematical relation computing in prior art, implementation procedure is comparatively simple, and efficiency is higher.
It should be noted that, for the embodiment of said method, in order to simple description, therefore it is all expressed as a series of combination of actions, but those skilled in the art should know, the present invention is not by the restriction of described sequence of movement.Secondly, those skilled in the art also should know, the embodiment described in instructions all belongs to preferred embodiment, and involved action might not be that the present invention is necessary.
The embodiment of the present invention provides a kind of equipment of Judging index data mode, and with reference to shown in Fig. 3, this equipment comprises:
Acquiring unit 31, for from target monitor system, obtains at least one achievement data of dissimilar index monitored item;
Storage unit 32, for being stored into relational database by least one achievement data;
Identifying unit 33, for according to relational database, judges the state of at least one achievement data, and generate result of determination, result of determination is used to indicate scope and the validity of at least one achievement data.
Preferably, acquiring unit 31 specifically for:
The dissimilar index monitored item of Offered target supervisory system, index monitored item comprises at least one achievement data;
According to index monitored item, obtain the acquisition parameter of at least one achievement data, acquisition parameter comprises acquisition interface mode;
According to acquisition interface mode, obtain at least one achievement data.
Preferably, storage unit 32 specifically for:
According to the type of index monitored item, at least one achievement data is stored into relational database.
Preferably, identifying unit 33 specifically for:
The decision condition preset according to index monitored item is converted into the SQL statement can run in relational database;
According to SQL statement, the state of at least one achievement data stored is judged, generate result of determination.
The embodiment of the present invention provides a kind of system of Judging index data mode, and with reference to shown in Fig. 4, this system comprises:
Target monitor system 41, for providing at least one achievement data of dissimilar index monitored item;
Relational database 43, for storing at least one achievement data;
And, the equipment 42 of the Judging index data mode as described in above-described embodiment.
The equipment of Judging index data mode provided by the invention and system, based on the conditional operation function of relational database, realize the judgement to achievement data state by relational database, abandon complicated loaded down with trivial details mathematical relation computing in prior art, implementation procedure is comparatively simple, and efficiency is higher.
The foregoing is only preferred embodiment of the present invention, not in order to limit the present invention, within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (9)
1. a method for Judging index data mode, is characterized in that, described method comprises:
From target monitor system, obtain at least one achievement data of dissimilar index monitored item;
At least one achievement data described is stored into relational database;
According to described relational database, judge the state of at least one achievement data described, generate result of determination, described result of determination is used to indicate scope and the validity of at least one achievement data described.
2. method according to claim 1, is characterized in that, described from target monitor system, obtains at least one achievement data and comprises:
Arrange the dissimilar index monitored item of described target monitor system, described index monitored item comprises at least one achievement data;
According to described index monitored item, obtain the acquisition parameter of at least one achievement data described, described acquisition parameter comprises acquisition interface mode;
According to described acquisition interface mode, obtain at least one achievement data described.
3. method according to claim 1, is characterized in that, describedly at least one achievement data described is stored into relational database comprises:
According to the type of described index monitored item, at least one achievement data described is stored into relational database.
4. method according to claim 1, is characterized in that, described according to described relational database, judges the state of at least one achievement data described, generates result of determination and comprises:
The decision condition preset according to described index monitored item is converted into the SQL statement can run in described relational database;
According to described SQL statement, the state of at least one achievement data described in storage is judged, generates result of determination.
5. an equipment for Judging index data mode, is characterized in that, described equipment comprises:
Acquiring unit, for from target monitor system, obtains at least one achievement data of dissimilar index monitored item;
Storage unit, for being stored into relational database by least one achievement data described;
Identifying unit, for according to described relational database, judges the state of at least one achievement data described, generates result of determination, and described result of determination is used to indicate scope and the validity of at least one achievement data described.
6. equipment according to claim 5, is characterized in that, described acquiring unit specifically for:
Arrange the dissimilar index monitored item of described target monitor system, described index monitored item comprises at least one achievement data;
According to described index monitored item, obtain the acquisition parameter of at least one achievement data described, described acquisition parameter comprises acquisition interface mode;
According to described acquisition interface mode, obtain at least one achievement data described.
7. equipment according to claim 5, is characterized in that, described storage unit specifically for:
According to the type of described index monitored item, at least one achievement data described is stored into relational database.
8. equipment according to claim 5, is characterized in that, described identifying unit specifically for:
The decision condition preset according to described index monitored item is converted into the SQL statement can run in described relational database;
According to described SQL statement, the state of at least one achievement data described in storage is judged, generates result of determination.
9. a system for Judging index data mode, is characterized in that, described system comprises:
Target monitor system, for providing at least one achievement data of dissimilar index monitored item;
Relational database, for storing at least one achievement data described;
And, the equipment of the Judging index data mode according to any one of claim 5 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510943000.XA CN105528278A (en) | 2015-12-16 | 2015-12-16 | Method, device and system for determining index data state |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510943000.XA CN105528278A (en) | 2015-12-16 | 2015-12-16 | Method, device and system for determining index data state |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105528278A true CN105528278A (en) | 2016-04-27 |
Family
ID=55770521
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510943000.XA Pending CN105528278A (en) | 2015-12-16 | 2015-12-16 | Method, device and system for determining index data state |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105528278A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7814117B2 (en) * | 2007-04-05 | 2010-10-12 | Oracle International Corporation | Accessing data from asynchronously maintained index |
| CN104052634A (en) * | 2014-05-30 | 2014-09-17 | 国家电网公司 | Information security monitoring system and method |
| CN104537015A (en) * | 2014-12-19 | 2015-04-22 | 电信科学技术第十研究所 | Log analysis computer implementation method, computer and system |
| CN104572401A (en) * | 2015-02-09 | 2015-04-29 | 浪潮软件股份有限公司 | Alarming method and alarming system |
| CN104636483A (en) * | 2015-02-16 | 2015-05-20 | 广东省公安厅 | Data monitoring method |
-
2015
- 2015-12-16 CN CN201510943000.XA patent/CN105528278A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7814117B2 (en) * | 2007-04-05 | 2010-10-12 | Oracle International Corporation | Accessing data from asynchronously maintained index |
| CN104052634A (en) * | 2014-05-30 | 2014-09-17 | 国家电网公司 | Information security monitoring system and method |
| CN104537015A (en) * | 2014-12-19 | 2015-04-22 | 电信科学技术第十研究所 | Log analysis computer implementation method, computer and system |
| CN104572401A (en) * | 2015-02-09 | 2015-04-29 | 浪潮软件股份有限公司 | Alarming method and alarming system |
| CN104636483A (en) * | 2015-02-16 | 2015-05-20 | 广东省公安厅 | Data monitoring method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104899225B (en) | Object Relation Mapping method, apparatus and processor | |
| CN101651576B (en) | Alarm information processing method and system | |
| WO2017107853A1 (en) | Data monitoring management method, and data monitoring method and system | |
| CN108108439A (en) | A kind of data query method, apparatus and electronic equipment | |
| CN109086182A (en) | The method and terminal device of database auto-alarming | |
| WO2021003970A1 (en) | Production line monitoring method and apparatus, and electronic device and readable storage medium | |
| CN109408561A (en) | Business Name matching process and device | |
| US20220197950A1 (en) | Eliminating many-to-many joins between database tables | |
| CN109460661A (en) | A kind of logical security leak detection method, device and terminal device | |
| CA2461871A1 (en) | An efficient index structure to access hierarchical data in a relational database system | |
| CN108376320A (en) | Fulfilling data managing method and device | |
| CN104901833A (en) | Method for finding abnormal device and device | |
| CN112311574A (en) | Method, device and equipment for checking network topology connection | |
| US10572931B2 (en) | Approving group purchase requests | |
| CN112668314A (en) | Data standard conformance detection method, device, system and storage medium | |
| CN107704599A (en) | A kind of method and apparatus for realizing EDR data quick-searchings | |
| CN102855297B (en) | A kind of method of control data transmission and connector | |
| CN109583726B (en) | Method and system for detecting process state | |
| CN105117333A (en) | Method and system for management of test cases | |
| CN107577802A (en) | A kind of data base management method and device | |
| CN112181962A (en) | Report form checking method, device, equipment and storage medium | |
| CN104239212A (en) | Query method and device of test case and establishment method and device of test case | |
| CN105528278A (en) | Method, device and system for determining index data state | |
| CN106776295B (en) | Software FMEA analysis method based on Altarica formal language | |
| CN109299910A (en) | Data summarization method, device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160427 |