CN104077371A - Method and system for monitoring abnormal data of database - Google Patents
Method and system for monitoring abnormal data of database Download PDFInfo
- Publication number
- CN104077371A CN104077371A CN201410285073.XA CN201410285073A CN104077371A CN 104077371 A CN104077371 A CN 104077371A CN 201410285073 A CN201410285073 A CN 201410285073A CN 104077371 A CN104077371 A CN 104077371A
- Authority
- CN
- China
- Prior art keywords
- abnormal data
- database
- abnormal
- data
- supervisor engine
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 230000002159 abnormal effect Effects 0.000 title claims abstract description 208
- 238000000034 method Methods 0.000 title claims abstract description 48
- 238000012544 monitoring process Methods 0.000 title claims abstract description 40
- 238000013499 data model Methods 0.000 claims abstract description 25
- 238000012545 processing Methods 0.000 claims abstract description 5
- 230000008569 process Effects 0.000 claims description 14
- 230000002688 persistence Effects 0.000 claims description 13
- 238000013507 mapping Methods 0.000 claims description 7
- 238000010586 diagram Methods 0.000 description 6
- 230000008878 coupling Effects 0.000 description 5
- 238000010168 coupling process Methods 0.000 description 5
- 238000005859 coupling reaction Methods 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 4
- 241001269238 Data Species 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000008901 benefit Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000002427 irreversible effect Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 239000004575 stone Substances 0.000 description 1
Classifications
-
- 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/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- 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/21—Design, administration or maintenance of databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention provides a method for monitoring abnormal data of a database. The method comprises defining an abnormal data model by a user; starting an abnormal data monitoring engine based on the abnormal data model and storing output data in the database; performing processing according to the abnormal condition of the output data of the abnormal data monitoring engine. The invention also provides a system for monitoring the abnormal data of the database. According to the method and the system for monitoring the abnormal data of the database, the single object types can be fully utilized to achieve the monitoring on the database abnormal data of the multi-object types on the basis of the existing database abnormal data monitoring mode and the general and unified monitoring thought for the multi-object type involved complex object database abnormal data monitoring is established.
Description
Technical field
The present invention relates to field of computer technology, particularly, relate to a kind of method of monitor database abnormal data and a kind of system of monitor database abnormal data.
Background technology
In software systems, reporting an error is the mode that a kind of user of prompting corrects a mistake and operates.In most of the cases, user can adjust according to error message, thereby deals with problems.But for some data mistakes, user cannot obtain by error message the solution of problem.For this situation, conventionally have two kinds of modes to process:
(1) user's flow process of the whole business of combing that need to start anew, the information of each flow nodes needs carefully to compare, and just likely knows the reason of problem.This mode requires user to have abundant business experience and enough patience, and in a lot of situation, even if navigated to the reason of problem, because a lot of operations are irreversible, causes final problem to solve.
(2) the developer who seeks system carrys out orientation problem, and this mode need to be given software supplier's delivery service expense conventionally, and because developer may need direct control database, therefore may have the leakage of confidential data.Meanwhile, (1) the same with mode, because problem occurs, the data of mistake cannot, recovering, cause final problem to solve.
After all, only before occurring, mistake just its discovery solution just can really be guaranteed to the robustness of system under abnormal conditions, so the user that wants help finds in time and deals with problems.
Therefore, the technology that needs a kind of new monitor database abnormal data, can be on existing monitor database abnormal data mode basis, make full use of the monitor database abnormal data that single object type completes multi-object type, set up general, the unified monitoring thinking towards complex object monitor database abnormal data that multi-object type participates in.
Summary of the invention
The present invention is just based on the problems referred to above, a kind of technology of new monitor database abnormal data has been proposed, can be on existing monitor database abnormal data mode basis, make full use of the monitor database abnormal data that single object type completes multi-object type, set up general, the unified monitoring thinking towards complex object monitor database abnormal data that multi-object type participates in.
In view of this, the present invention proposes a kind of method of monitor database abnormal data, comprising: step 102: User Defined abnormal data model; Step 104: based on abnormal data model, start abnormal data supervisor engine, deposit output data in database; Step 106: process according to the abnormal conditions of the output data of abnormal data supervisor engine.In this technical scheme, by definition abnormal data, revise database and avoid wrong generation, can help user find in time and deal with problems.
In technique scheme, preferably, described step 102 specifically comprises: user by arrange the monitored object of model specify in database which table monitor; According to the field of table, monitoring condition is set, abnormal data supervisor engine carrys out the abnormal data in Query Database according to these contents; And user defines execution type, control opportunity and the control mode of abnormal data supervisor engine.In this technical scheme, user realizes the monitoring to database data by defining these models.
In technique scheme, preferably, described step 104 specifically comprises: determine monitoring objective, engine obtains corresponding table name according to the monitored object arranging in model to metadata layer and claims after stress model; Metadata layer has recorded the mapping relations between upper layer entity and underlying database table; Determine monitoring condition, the database table name that engine obtains according to the condition in model and previous step is spliced into a complete OQL statement, gives the compiling of OQL compiler; Compiling OQL statement, translates into SQL statement for data base call by OQL compiler by OQL statement.In this technical scheme, by the monitor mode of this robotization, user can investigate some potential problems timely, can revise these misdata simultaneously.
In technique scheme, preferably, described step 106 specifically comprises: when the output data of abnormal data supervisor engine do not exist when abnormal, return to abnormal data supervisor engine when needs circular treatment.
In technique scheme, preferably, described step 106 specifically also comprises: when the output data of abnormal data supervisor engine exist when abnormal, by abnormal data essential information persistence concurrent message, notify user, return to abnormal data supervisor engine when needs circular treatment; And the information that the abnormal data after persistence is processed and abnormal data display interface show, deposits abnormal data information in the lump in.In this technical scheme, can avoid after follow-up flow process executes, due to strong coupling state cannot rollback problem.
According to a further aspect of the invention, also proposed a kind of system of monitor database abnormal data, having comprised: abnormal data model custom block, for User Defined abnormal data model; Abnormal data supervisor engine module, for based on abnormal data model, starts abnormal data supervisor engine, deposits output data in database; Result treatment module, for processing according to the abnormal conditions of the output data of abnormal data supervisor engine.In this technical scheme, by definition abnormal data, revise database and avoid wrong generation, can help user find in time and deal with problems.
In technique scheme, preferably, the operation of described abnormal data model custom block User Defined abnormal data model, specifically comprises: user by arrange the monitored object of model specify in database which table monitor; According to the field of table, monitoring condition is set, abnormal data supervisor engine carrys out the abnormal data in Query Database according to these contents; And user defines execution type, control opportunity and the control mode of abnormal data supervisor engine.In this technical scheme, user realizes the monitoring to database data by defining these models.
In technique scheme, preferably, described abnormal data supervisor engine module starts the operation of abnormal data supervisor engine, specifically comprises: determine monitoring objective, engine obtains corresponding table name according to the monitored object arranging in model to metadata layer and claims after stress model; Metadata layer has recorded the mapping relations between upper layer entity and underlying database table; Determine monitoring condition, the database table name that engine obtains according to the condition in model and previous step is spliced into a complete OQL statement, gives the compiling of OQL compiler; Compiling OQL statement, translates into SQL statement for data base call by OQL compiler by OQL statement.In this technical scheme, by the monitor mode of this robotization, user can investigate some potential problems timely, can revise these misdata simultaneously.
In technique scheme, preferably, the operation that described result treatment module is processed according to the abnormal conditions of the output data of abnormal data supervisor engine, specifically comprise: when the output data of abnormal data supervisor engine do not exist when abnormal, when needs circular treatment, return to abnormal data supervisor engine.
In technique scheme, preferably, the operation that described result treatment module is processed according to the abnormal conditions of the output data of abnormal data supervisor engine, specifically comprise: when the output data of abnormal data supervisor engine exist when abnormal, by abnormal data essential information persistence concurrent message, notify user, when needs circular treatment, return to abnormal data supervisor engine; And the information that the abnormal data after persistence is processed and abnormal data display interface show, deposits abnormal data information in the lump in.In this technical scheme, can avoid after follow-up flow process executes, due to strong coupling state cannot rollback problem.
By above technical scheme, can be on existing monitor database abnormal data mode basis, make full use of the monitor database abnormal data that single object type completes multi-object type, set up general, the unified monitoring thinking towards complex object monitor database abnormal data that multi-object type participates in.
Accompanying drawing explanation
Fig. 1 shows the process flow diagram of the method for monitor database abnormal data according to an embodiment of the invention;
Fig. 2 shows the detail flowchart of the method for monitor database abnormal data according to an embodiment of the invention;
Fig. 3 shows the process flow diagram of abnormal data supervisor engine according to an embodiment of the invention;
Fig. 4 shows the block diagram of the system of monitor database abnormal data according to an embodiment of the invention.
Embodiment
In order more clearly to understand above-mentioned purpose of the present invention, feature and advantage, below in conjunction with the drawings and specific embodiments, the present invention is further described in detail.It should be noted that, in the situation that not conflicting, the application's embodiment and the feature in embodiment can combine mutually.
A lot of details have been set forth in the following description so that fully understand the present invention; but; the present invention can also adopt other to be different from other modes described here and implement, and therefore, protection scope of the present invention is not subject to the restriction of following public specific embodiment.
Fig. 1 shows the process flow diagram of the method for monitor database abnormal data according to an embodiment of the invention.
As shown in Figure 1, the method for monitor database abnormal data, comprising: step 102: User Defined abnormal data model according to an embodiment of the invention; Step 104: based on abnormal data model, start abnormal data supervisor engine, deposit output data in database; Step 106: process according to the abnormal conditions of the output data of abnormal data supervisor engine.In this technical scheme, by definition abnormal data, revise database and avoid wrong generation, can help user find in time and deal with problems.
In technique scheme, preferably, step 102 specifically comprises: user by arrange the monitored object of model specify in database which table monitor; According to the field of table, monitoring condition is set, abnormal data supervisor engine carrys out the abnormal data in Query Database according to these contents; And user defines execution type, control opportunity and the control mode of abnormal data supervisor engine.In this technical scheme, user realizes the monitoring to database data by defining these models.
In technique scheme, preferably, as shown in Figure 3, step 104 specifically comprises: determine monitoring objective, engine obtains corresponding table name according to the monitored object arranging in model to metadata layer and claims after stress model; Metadata layer has recorded the mapping relations between upper layer entity and underlying database table; Determine monitoring condition, the database table name that engine obtains according to the condition in model and previous step is spliced into a complete OQL statement, gives the compiling of OQL compiler; Compiling OQL statement, translates into SQL statement for data base call by OQL compiler by OQL statement.In this technical scheme, by the monitor mode of this robotization, user can investigate some potential problems timely, can revise these misdata simultaneously.
In technique scheme, preferably, as shown in Figure 2, step 106 specifically comprises: when the output data of abnormal data supervisor engine do not exist when abnormal, return to abnormal data supervisor engine when needs circular treatment.
In technique scheme, preferably, as shown in Figure 2, step 106 specifically also comprises: when the output data of abnormal data supervisor engine exist when abnormal, by abnormal data essential information persistence concurrent message, notify user, when needs circular treatment, return to abnormal data supervisor engine; And the information that the abnormal data after persistence is processed and abnormal data display interface show, deposits abnormal data information in the lump in.In this technical scheme, can avoid after follow-up flow process executes, due to strong coupling state cannot rollback problem.
Fig. 4 shows the block diagram of the system of monitor database abnormal data according to an embodiment of the invention.
As shown in Figure 4, the system 200 of monitor database abnormal data according to an embodiment of the invention, comprising: abnormal data model custom block 202, for User Defined abnormal data model; Abnormal data supervisor engine module 204, for based on abnormal data model, starts abnormal data supervisor engine, deposits output data in database; Result treatment module 206, for processing according to the abnormal conditions of the output data of abnormal data supervisor engine.In this technical scheme, by definition abnormal data, revise database and avoid wrong generation, can help user find in time and deal with problems.
In technique scheme, preferably, the operation of abnormal data model custom block 202 User Defined abnormal data models, specifically comprises: user by arrange the monitored object of model specify in database which table monitor; According to the field of table, monitoring condition is set, abnormal data supervisor engine carrys out the abnormal data in Query Database according to these contents; And user defines execution type, control opportunity and the control mode of abnormal data supervisor engine.In this technical scheme, user realizes the monitoring to database data by defining these models.
In technique scheme, preferably, abnormal data supervisor engine module 204 starts the operation of abnormal data supervisor engine, specifically comprises: determine monitoring objective, engine obtains corresponding table name according to the monitored object arranging in model to metadata layer and claims after stress model; Metadata layer has recorded the mapping relations between upper layer entity and underlying database table; Determine monitoring condition, the database table name that engine obtains according to the condition in model and previous step is spliced into a complete OQL statement, gives the compiling of OQL compiler; Compiling OQL statement, translates into SQL statement for data base call by OQL compiler by OQL statement.In this technical scheme, by the monitor mode of this robotization, user can investigate some potential problems timely, can revise these misdata simultaneously.
In technique scheme, preferably, the operation that result treatment module 206 is processed according to the abnormal conditions of the output data of abnormal data supervisor engine, specifically comprise: when the output data of abnormal data supervisor engine do not exist when abnormal, when needs circular treatment, return to abnormal data supervisor engine.
In technique scheme, preferably, the operation that result treatment module 206 is processed according to the abnormal conditions of the output data of abnormal data supervisor engine, specifically comprise: when the output data of abnormal data supervisor engine exist when abnormal, by abnormal data essential information persistence concurrent message, notify user, when needs circular treatment, return to abnormal data supervisor engine; And the information that the abnormal data after persistence is processed and abnormal data display interface show, deposits abnormal data information in the lump in.In this technical scheme, can avoid after follow-up flow process executes, due to strong coupling state cannot rollback problem.
Technical scheme of the present invention, has versatility widely.Database is the foundation stone of most systems, and particularly in ERP field, all business information all can be stored in database.Generally, database is transparent for domestic consumer, if exist some abnormal datas can cause user to occur mistake when operation in database.Any system based on database can obtain these abnormal datas by technical scheme of the present invention, by revising these data, avoids wrong generation.Technical scheme of the present invention, can help user find in time and deal with problems.
With respect to original processing mode technical scheme of the present invention, need to solve: (1) how to define abnormal data, set up the model of abnormal data; (2) how to obtain and store abnormal data, by user-defined model, carry out garbled data persistence from database; (3) how abnormal data is sent to user.
For example, referring to Fig. 2, technical scheme of the present invention is specific as follows:
(1) abnormal data model
Abnormal data model be one by user-defined solid model, user realizes the monitoring to database data by defining these models.User specifies which table in database is monitored by the monitored object of model is set, and simultaneously according to the field of table, monitoring condition is set, and abnormal data supervisor engine carrys out the abnormal data in Query Database according to these contents.While model also comprises the following characteristic and supplies customization:
carry out type
control opportunity
control mode
(2) abnormal data supervisor engine, schematic diagram is referring to Fig. 3.
1. determine monitoring objective, engine obtains corresponding table name according to the monitored object arranging in model to metadata layer and claims after stress model.Metadata layer has recorded the mapping relations between upper layer entity and underlying database table.
2. determine monitoring condition, the database table name that engine obtains according to the condition in model and previous step is spliced into a complete OQL statement, gives the compiling of OQL compiler.
3. compile OQL statement, OQL is the language of a kind SQL in system, can use language keyword and familiar operational symbol to write inquiry for the object of strong typing.OQL compiler is translated into SQL statement for data base call by OQL statement.
Technical scheme of the present invention, by the monitor mode of this robotization, user can investigate some potential problems timely, can revise these misdata simultaneously, avoid after follow-up flow process executes, due to strong coupling state cannot rollback problem.
More than be described with reference to the accompanying drawings technical scheme of the present invention, considered and in correlation technique, there is no easy, the unified solution for complicated type monitor database abnormal data.Existing monitor database abnormal data cannot complete the monitor database abnormal data process that complicated type participates in.Therefore, the present invention proposes a kind of method of monitor database abnormal data and a kind of system of monitor database abnormal data, can be on existing monitor database abnormal data mode basis, make full use of the monitor database abnormal data that single object type completes multi-object type, set up general, the unified monitoring thinking towards complex object monitor database abnormal data that multi-object type participates in.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any modification of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (10)
1. a method for monitor database abnormal data, is characterized in that, comprising:
Step 102: User Defined abnormal data model;
Step 104: based on abnormal data model, start abnormal data supervisor engine, deposit output data in database;
Step 106: process according to the abnormal conditions of the output data of abnormal data supervisor engine.
2. the method for monitor database abnormal data according to claim 1, is characterized in that, described step 102 specifically comprises:
User by arrange the monitored object of model specify in database which table monitor;
According to the field of table, monitoring condition is set, abnormal data supervisor engine carrys out the abnormal data in Query Database according to these contents; And,
User defines execution type, control opportunity and the control mode of abnormal data supervisor engine.
3. the method for monitor database abnormal data according to claim 1 and 2, is characterized in that, described step 104 specifically comprises:
Determine monitoring objective, engine obtains corresponding table name according to the monitored object arranging in model to metadata layer and claims after stress model; Metadata layer has recorded the mapping relations between upper layer entity and underlying database table;
Determine monitoring condition, the database table name that engine obtains according to the condition in model and previous step is spliced into a complete OQL statement, gives the compiling of OQL compiler;
Compiling OQL statement, translates into SQL statement for data base call by OQL compiler by OQL statement.
4. the method for monitor database abnormal data according to claim 3, is characterized in that, described step 106 specifically comprises:
When the output data of abnormal data supervisor engine do not exist when abnormal, when needs circular treatment, return to abnormal data supervisor engine.
5. the method for monitor database abnormal data according to claim 4, is characterized in that, described step 106 specifically also comprises:
When the output data of abnormal data supervisor engine exist when abnormal, by abnormal data essential information persistence concurrent message, notify user, when needs circular treatment, return to abnormal data supervisor engine; And,
The information that abnormal data after persistence is processed and abnormal data display interface show, deposits abnormal data information in the lump in.
6. a system for monitor database abnormal data, is characterized in that, comprising:
Abnormal data model custom block, for User Defined abnormal data model;
Abnormal data supervisor engine module, for based on abnormal data model, starts abnormal data supervisor engine, deposits output data in database;
Result treatment module, for processing according to the abnormal conditions of the output data of abnormal data supervisor engine.
7. the system of monitor database abnormal data according to claim 6, is characterized in that, the operation of described abnormal data model custom block User Defined abnormal data model, specifically comprises:
User by arrange the monitored object of model specify in database which table monitor;
According to the field of table, monitoring condition is set, abnormal data supervisor engine carrys out the abnormal data in Query Database according to these contents; And,
User defines execution type, control opportunity and the control mode of abnormal data supervisor engine.
8. according to the system of the monitor database abnormal data described in claim 6 or 7, it is characterized in that, described abnormal data supervisor engine module starts the operation of abnormal data supervisor engine, specifically comprises:
Determine monitoring objective, engine obtains corresponding table name according to the monitored object arranging in model to metadata layer and claims after stress model; Metadata layer has recorded the mapping relations between upper layer entity and underlying database table;
Determine monitoring condition, the database table name that engine obtains according to the condition in model and previous step is spliced into a complete OQL statement, gives the compiling of OQL compiler;
Compiling OQL statement, translates into SQL statement for data base call by OQL compiler by OQL statement.
9. the system of monitor database abnormal data according to claim 8, is characterized in that, the operation that described result treatment module is processed according to the abnormal conditions of the output data of abnormal data supervisor engine, specifically comprises:
When the output data of abnormal data supervisor engine do not exist when abnormal, when needs circular treatment, return to abnormal data supervisor engine.
10. the system of monitor database abnormal data according to claim 9, is characterized in that, the operation that described result treatment module is processed according to the abnormal conditions of the output data of abnormal data supervisor engine, specifically comprises:
When the output data of abnormal data supervisor engine exist when abnormal, by abnormal data essential information persistence concurrent message, notify user, when needs circular treatment, return to abnormal data supervisor engine; And,
The information that abnormal data after persistence is processed and abnormal data display interface show, deposits abnormal data information in the lump in.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410285073.XA CN104077371B (en) | 2014-06-24 | 2014-06-24 | The method and system of monitor database abnormal data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410285073.XA CN104077371B (en) | 2014-06-24 | 2014-06-24 | The method and system of monitor database abnormal data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104077371A true CN104077371A (en) | 2014-10-01 |
| CN104077371B CN104077371B (en) | 2019-03-29 |
Family
ID=51598625
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410285073.XA Active CN104077371B (en) | 2014-06-24 | 2014-06-24 | The method and system of monitor database abnormal data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104077371B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104881256A (en) * | 2015-06-05 | 2015-09-02 | 北京京东尚科信息技术有限公司 | Method and device for monitoring availability of data sources |
| CN106020913A (en) * | 2016-06-06 | 2016-10-12 | 北京邮电大学 | Updating method and device for defect detection tools |
| CN106773993A (en) * | 2017-01-04 | 2017-05-31 | 国网山东省电力公司菏泽供电公司 | Field data acquiring terminal and system |
| CN108387794A (en) * | 2018-01-09 | 2018-08-10 | 国网山东省电力公司滨州供电公司 | A kind of electrical energy monitoring system |
| CN110866049A (en) * | 2019-11-27 | 2020-03-06 | 北京明略软件系统有限公司 | Target object type confirmation method and device, storage medium and electronic device |
| CN111581045A (en) * | 2020-03-18 | 2020-08-25 | 平安科技（深圳）有限公司 | Database anomaly monitoring method and device, computer device and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020036804A1 (en) * | 2000-08-04 | 2002-03-28 | Koji Taniguchi | System and method of data transmission/reception |
| CN1643520A (en) * | 2002-02-22 | 2005-07-20 | Ip锁有限公司 | Method and apparatus for monitoring a database system |
| US20070094265A1 (en) * | 2005-06-07 | 2007-04-26 | Varonis Systems Ltd. | Automatic detection of abnormal data access activities |
| CN103064988A (en) * | 2013-02-01 | 2013-04-24 | 北京华环电子股份有限公司 | Abnormal data detection method and device |
| CN103365969A (en) * | 2013-06-24 | 2013-10-23 | 北京奇虎科技有限公司 | Abnormal data detecting and processing method and system |
-
2014
- 2014-06-24 CN CN201410285073.XA patent/CN104077371B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020036804A1 (en) * | 2000-08-04 | 2002-03-28 | Koji Taniguchi | System and method of data transmission/reception |
| CN1643520A (en) * | 2002-02-22 | 2005-07-20 | Ip锁有限公司 | Method and apparatus for monitoring a database system |
| US20070094265A1 (en) * | 2005-06-07 | 2007-04-26 | Varonis Systems Ltd. | Automatic detection of abnormal data access activities |
| CN103064988A (en) * | 2013-02-01 | 2013-04-24 | 北京华环电子股份有限公司 | Abnormal data detection method and device |
| CN103365969A (en) * | 2013-06-24 | 2013-10-23 | 北京奇虎科技有限公司 | Abnormal data detecting and processing method and system |
Non-Patent Citations (2)
| Title |
|---|
| 戴秀红: "SQL 数据库入侵检测系统的设计", 《电脑知识与技术》 * |
| 深蓝医生: "ORM 查询语言（OQL）简介—概念篇", 《博客园》 * |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104881256A (en) * | 2015-06-05 | 2015-09-02 | 北京京东尚科信息技术有限公司 | Method and device for monitoring availability of data sources |
| CN104881256B (en) * | 2015-06-05 | 2018-09-11 | 北京京东尚科信息技术有限公司 | The method and apparatus being monitored for the availability to data source |
| CN106020913A (en) * | 2016-06-06 | 2016-10-12 | 北京邮电大学 | Updating method and device for defect detection tools |
| CN106020913B (en) * | 2016-06-06 | 2019-06-14 | 北京邮电大学 | A method and device for updating a defect detection tool |
| CN106773993A (en) * | 2017-01-04 | 2017-05-31 | 国网山东省电力公司菏泽供电公司 | Field data acquiring terminal and system |
| CN108387794A (en) * | 2018-01-09 | 2018-08-10 | 国网山东省电力公司滨州供电公司 | A kind of electrical energy monitoring system |
| CN110866049A (en) * | 2019-11-27 | 2020-03-06 | 北京明略软件系统有限公司 | Target object type confirmation method and device, storage medium and electronic device |
| CN111581045A (en) * | 2020-03-18 | 2020-08-25 | 平安科技（深圳）有限公司 | Database anomaly monitoring method and device, computer device and storage medium |
| CN111581045B (en) * | 2020-03-18 | 2024-05-28 | 平安科技（深圳）有限公司 | Database anomaly monitoring method, device, computer device and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104077371B (en) | 2019-03-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108536761B (en) | Report data query method and server | |
| JP7273045B2 (en) | Dimensional Context Propagation Techniques for Optimizing SQL Query Plans | |
| CN104077371A (en) | Method and system for monitoring abnormal data of database | |
| KR101621137B1 (en) | Low latency query engine for apache hadoop | |
| US9031920B2 (en) | Objects in a storage environment for connected applications | |
| CN102929771B (en) | Log recording apparatus and log recording method | |
| US20150007249A1 (en) | Method and system for on-the-fly anonymization on in-memory databases | |
| WO2019134340A1 (en) | Salary calculation method, application server, and computer readable storage medium | |
| US20130173664A1 (en) | Mapping non-relational database objects into a relational database model | |
| US8805777B2 (en) | Data record collapse and split functionality | |
| KR20150132858A (en) | System for metadata management | |
| CN109299074B (en) | Data verification method and system based on templated database view | |
| CN102567399B (en) | Method and device for accessing database | |
| CN104714972A (en) | Database sub-table establishing and searching method | |
| JP7508541B2 (en) | Blockchain data processing method, device, equipment and readable storage medium | |
| CN103092997B (en) | For interlock inquiry system and the interlock querying method of statement analysis | |
| US11023465B2 (en) | Cross-asset data modeling in multi-asset databases | |
| US10922640B2 (en) | Smart template for predictive analytics | |
| CN103235811A (en) | Data storage method and device | |
| CN104536987A (en) | Data query method and device | |
| US20150317336A1 (en) | Data reconstruction | |
| CN108984506A (en) | A kind of generation method and device of configurable intelligent report forms | |
| CN108628972A (en) | A kind of processing method of tables of data, device and storage medium | |
| JP2018538634A (en) | Database operating method and apparatus | |
| CA3155703A1 (en) | Map information retrieving method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |