CN115185790B - Data monitoring method and equipment for auditing business software - Google Patents
Data monitoring method and equipment for auditing business software Download PDFInfo
- Publication number
- CN115185790B CN115185790B CN202211102312.4A CN202211102312A CN115185790B CN 115185790 B CN115185790 B CN 115185790B CN 202211102312 A CN202211102312 A CN 202211102312A CN 115185790 B CN115185790 B CN 115185790B
- Authority
- CN
- China
- Prior art keywords
- instruction
- query
- violation
- service
- data
- 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.)
- Active
Links
Images
Classifications
-
- 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
Abstract
The invention provides a data monitoring method and equipment for auditing service software, which execute a query instruction in a database and/or service application of the auditing service software at regular time; judging whether violation conditions exist or not based on the query result of the query instruction; and if the violation condition exists, executing an intervention instruction, and intervening the database data and/or the service application running with the violation condition. The invention can realize the abstraction of the service, complete the service data monitoring of multiple data sources and make corresponding service interference according to the monitoring result. The data problem is found in advance, the operation of the business process is better completed, and the progress of the business process is controlled.
Description
Technical Field
The invention relates to the technical field of software monitoring, in particular to a data monitoring method, a data monitoring device, data monitoring equipment and a data monitoring storage medium for auditing service software.
Background
In complex financial services, due to reasons such as system faults and non-standard user operation, problems in the aspects of data consistency, data standardization, data security, process state rationality and the like exist, and the problems need to be found in time, early warning information needs to be sent, and data intervention control operation needs to be carried out in time.
Disclosure of Invention
The invention provides a data monitoring method, a data monitoring device, equipment and a storage medium for auditing service software, and aims to monitor auditing service software data and interfere when violation conditions exist.
To this end, a first object of the present invention is to provide a data monitoring method for auditing service software, including:
executing a query instruction in a database and/or a service application of audit business software at regular time;
judging whether violation conditions exist or not based on the query result of the query instruction;
and if the violation condition exists, executing an intervention instruction, and intervening the database data and/or the service application running with the violation condition.
In the step of executing the query instruction in the database and/or the service application of the audit business software regularly, if the query object is the database in the audit business software, the query instruction is an sql query instruction; and if the service application in the business software is audited when the object is queried, the query instruction is an interface type query instruction or a query type query instruction.
And in the step of judging whether the violation condition exists, comparing the inquiry result after the inquiry instruction is executed with the audit rule, if the inquiry result does not accord with the audit rule, judging that the violation condition exists, otherwise, judging that the violation condition does not exist.
The interference instruction comprises a prompt interference instruction and a strong interference instruction; the prompting interference instruction is a prompting short message and is used for prompting the handling of the violation condition through text information; the strong interference instruction is an interface type instruction and an execution type instruction and is used for controlling and preventing the operation of auditing service software.
If the rule violation condition is judged to exist, writing a query result of the query instruction into an error log table prefabricated for the audit service software; and if the rule violation condition does not exist, writing the query result of the query instruction into an operation log table preset for the auditing service software.
Wherein, the time interval of the timing polling of the inquiry command is set to be 10 minutes; before the timed polling, a query instruction is written into the running log table, and the running log table is updated based on data generated in the previous polling time.
After the step of interfering database data with violation conditions and/or service application running, the interfered monitoring data set processing conditions are displayed through a visual monitoring page so as to perform data analysis, so that the violation conditions are avoided and the service is adjusted.
A second object of the present invention is to provide a data monitoring apparatus for auditing service software, comprising:
the query module is used for executing a query instruction in a database and/or service application of the audit business software at regular time;
the judging module is used for judging whether violation conditions exist or not based on the query result of the query instruction;
and the interference module is used for executing an interference instruction if the violation condition exists, and interfering the database data and/or the service application running with the violation condition.
A third object of the present invention is to provide an electronic apparatus, comprising: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the steps of the method of the foregoing technical solution.
A fourth object of the present invention is to propose a non-transitory computer-readable storage medium storing computer instructions for causing a computer to perform the steps of the method according to the aforementioned technical solution.
Different from the prior art, the data monitoring method for the audit service software provided by the invention executes the query instruction in the database and/or the service application of the audit service software at regular time; judging whether the violation condition exists or not based on the query result of the query instruction; and if the violation condition exists, executing an intervention instruction, and intervening the database data and/or the service application running with the violation condition. By the method and the device, abstraction of services can be realized, service data monitoring of multiple data sources is completed, and corresponding service interference is performed according to a monitoring result. The data problem is found in advance, the operation of the business process is better completed, and the progress of the business process is controlled.
Drawings
The invention and/or additional aspects and advantages will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings of which:
fig. 1 is a schematic flow chart of a data monitoring method for auditing business software according to the present invention.
Fig. 2 is a schematic structural diagram of a data monitoring apparatus for auditing service software according to the present invention.
FIG. 3 is a block diagram of a non-transitory computer readable storage medium storing computer instructions according to the present invention.
Detailed Description
Reference will now be made in detail to the embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like reference numerals refer to the same or similar elements or elements having the same or similar functions throughout. The embodiments described below with reference to the drawings are illustrative and intended to be illustrative of the invention and are not to be construed as limiting the invention.
As shown in fig. 1, a data monitoring method for auditing service software provided by an embodiment of the present invention includes:
executing a query instruction in a database and/or a service application of audit business software at regular time;
judging whether the violation condition exists or not based on the query result of the query instruction;
and if the violation condition exists, executing an intervention instruction, and intervening the database data and/or the service application running with the violation condition.
The invention provides a service for monitoring business data and interfering with data flow behavior operation. The service is to ensure the configuration of rules for different data sources, different business specifications and different data models. And secondly, realizing the data monitoring by timing polling based on rules, and providing various interference means to influence the operation of the business data flow according to the monitoring result.
Firstly, the invention realizes the capability of providing rule configuration, forms different models and data specifications mainly aiming at the abstraction of property business, and provides diversified configuration modes, such as sql, interfaces, execution classes and the like.
Secondly, based on the configured rules, analysis and polling execution can be performed, customized monitoring of the service data is realized, display is performed according to the monitoring result, operation of interfering the service data flow in various modes such as prompting, warning and error is provided, and interference can be performed in various modes such as short message, mailbox and system.
Based on the invention, the abstraction of the service can be realized, the service data monitoring of multiple data sources is completed, and corresponding service interference is made according to the monitoring result. The data problem is found in advance, the operation of the business process is better completed, and the progress of the business process is controlled.
In the step of executing the query instruction in the database and/or the service application of the audit service software at regular time, if the query object is the database in the audit service software, the query instruction is an sql query instruction; and if the service application in the business software is audited when the object is queried, the query instruction is an interface type query instruction or a query type query instruction.
In the step of judging whether the violation condition exists, comparing the query result after the query instruction is executed with the audit rule, if the query result does not accord with the audit rule, judging that the violation condition exists, otherwise, judging that the violation condition does not exist.
The interference instruction comprises a prompt interference instruction and a strong interference instruction; the prompting interference instruction is a prompting short message and is used for prompting the handling of the violation condition through text information; the strong interference instruction is an interface type instruction and an execution type instruction and is used for controlling and preventing the operation of auditing service software.
If the rule violation condition is judged to exist, writing a query result of the query instruction into an error log table prefabricated for the audit service software; and if the rule violation condition does not exist, writing the query result of the query instruction into an operation log table preset for the auditing service software.
Wherein, the time interval of the timing polling of the query command is set to be 10 minutes; before the timed polling, a query instruction is written into the running log table, and the running log table is updated based on data generated in the previous polling time. The polling time interval is default to 10 minutes, and the polling time can be customized according to the service condition.
After the step of interfering database data with violation conditions and/or service application running, the interfered monitoring data set processing conditions are displayed through a visual monitoring page so as to perform data analysis, so that the violation conditions are avoided and the service is adjusted.
The invention can satisfy the configuration of rules of different financial service specifications and different data models, can perform timing polling monitoring and output monitoring results, and provides various interference means to influence the operation of a service data flow, such as: prompt, pre-warning, error, etc.
As shown in fig. 2, the present invention provides a data monitoring apparatus for auditing service software, including:
the query module 310 is used for executing a query instruction in a database and/or a service application of the audit business software at regular time;
the judging module 320 is configured to judge whether an violation condition exists based on a query result of the query instruction;
and the intervention module 330 is configured to execute an intervention instruction if an illegal condition exists, and intervene the database data and/or the service application running where the illegal condition exists.
In order to implement the embodiment, the present invention further provides an electronic device, including: at least one processor; and a memory communicatively coupled to the at least one processor; the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor, so that the at least one processor can execute the steps of the data monitoring method for auditing business software in the technical scheme.
As shown in fig. 3, the non-transitory computer readable storage medium includes a memory 810 of instructions executable by a data monitoring processor 820 according to software for auditing services to perform a method, and an interface 830. Alternatively, the storage medium may be a non-transitory computer readable storage medium, for example, the non-transitory computer readable storage medium may be a ROM, a Random Access Memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, and the like.
To implement the embodiments, the present invention also proposes a non-transitory computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements data monitoring for auditing business software according to an embodiment of the present invention.
In the description of the specification, reference to the description of "one embodiment," "some embodiments," "an example," "a specific example," or "some examples" or the like means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, a schematic representation of the terms does not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.
Furthermore, the terms "first", "second" and "first" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In the description of the present invention, "a plurality" means at least two, e.g., two, three, etc., unless explicitly specified otherwise.
Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing steps of a custom logic function or process, and alternate implementations are included within the scope of the preferred embodiment of the present invention in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the present invention.
The logic and/or steps represented in the flowcharts or otherwise described herein, such as an ordered listing of executable instructions that can be considered to implement logical functions, can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. For the purposes of this description, a "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). Additionally, the computer-readable medium could even be paper or another suitable medium upon which the program is printed, as the program can be electronically captured, via for instance optical scanning of the paper or other medium, then compiled, interpreted or otherwise processed in a suitable manner if necessary, and then stored in a computer memory.
It should be understood that portions of the present invention may be implemented in hardware, software, firmware, or a combination thereof. In the described embodiments, various steps or methods may be implemented in software or firmware stored in a memory and executed by a suitable instruction execution system. If implemented in hardware, as in another embodiment, any one or combination of the following techniques, which are known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.
One of ordinary skill in the art will appreciate that all or part of the steps carried by the method implementing the embodiments may be implemented by hardware related to instructions of a program, which may be stored in a computer readable storage medium, and the program, when executed, includes one or a combination of the steps of the method embodiments.
In addition, functional units in the embodiments of the present invention may be integrated into one processing module, or each unit may exist alone physically, or two or more units are integrated into one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode. The integrated module, if implemented in the form of a software functional module and sold or used as a separate product, may also be stored in a computer-readable storage medium.
The mentioned storage medium may be a read-only memory, a magnetic or optical disk, etc. Although embodiments of the present invention have been shown and described above, it is understood that the embodiments are illustrative and not restrictive, and that those skilled in the art may make changes, modifications, substitutions and alterations to the embodiments described herein without departing from the scope of the invention.
Claims (4)
1. A data monitoring method for auditing service software is characterized by comprising the following steps:
executing a query instruction in a database and/or a service application of the audit business software at regular time;
judging whether violation conditions exist or not based on the query result of the query instruction;
if the violation condition exists, executing an interference instruction, and interfering the database data and/or service application running with the violation condition;
in the step of executing the query instruction in the database and/or the service application of the audit service software regularly, if the query object is the database in the audit service software, the query instruction is an sql query instruction; if service application in the service software is audited when the object is inquired, the inquiry instruction is an interface type inquiry instruction or an inquiry type inquiry instruction;
in the step of judging whether the violation condition exists, comparing the inquiry result after the inquiry instruction is executed with the audit rule, if the inquiry result does not accord with the audit rule, judging that the violation condition exists, otherwise, judging that the violation condition does not exist;
the interference instruction comprises an suggestive interference instruction and a strong interference instruction; the prompting interference instruction is a prompting short message and is used for prompting the handling of the violation condition through text information; the strong interference instruction is an interface type instruction and an execution type instruction and is used for controlling and preventing the operation of the auditing service software;
if the illegal condition is judged to exist, writing the query result of the query instruction into an error log table prefabricated for the audit service software; if the rule-breaking condition does not exist, writing the query result of the query instruction into an operation log table preset for the audit service software;
the time interval of the timed polling of the query instruction is set to 10 minutes; before timing polling, writing the query instruction into the running log table, and updating the running log table based on data generated in the previous polling time;
after the step of interfering database data with violation conditions and/or service application running, the interfered monitoring data set processing conditions are displayed through a visual monitoring page, so that data analysis is performed, the violation conditions are avoided, and services are adjusted.
2. A data monitoring apparatus for auditing business software, comprising:
the query module is used for executing a query instruction in a database and/or a service application of the audit business software at regular time;
the judging module is used for judging whether the violation condition exists or not based on the query result of the query instruction;
the interference module is used for executing an interference instruction if the violation condition exists, and interfering the database data and/or service application running with the violation condition;
in the step of executing the query instruction in the database and/or the service application of the audit service software regularly, if the query object is the database in the audit service software, the query instruction is an sql query instruction; if service application in the service software is audited when the object is inquired, the inquiry instruction is an interface type inquiry instruction or an inquiry type inquiry instruction;
in the step of judging whether the violation condition exists, comparing the inquiry result after the inquiry instruction is executed with the audit rule, if the inquiry result does not accord with the audit rule, judging that the violation condition exists, otherwise, judging that the violation condition does not exist;
the interference instruction comprises an suggestive interference instruction and a strong interference instruction; the prompting interference instruction is a prompting short message and is used for prompting the handling of the violation condition through text information; the strong interference instruction is an interface type instruction and an execution type instruction and is used for controlling and preventing the operation of the auditing service software;
if the condition of violation is judged to exist, writing a query result of the query instruction into an error log table prefabricated for the audit service software; if the rule-breaking condition does not exist, writing the query result of the query instruction into an operation log table preset for the audit service software;
the time interval of the timed polling of the query instruction is set to 10 minutes; before timing polling, writing the query instruction into the running log table, and updating the running log table based on data generated in the previous polling time;
after the step of interfering database data with violation conditions and/or service application running, the interfered monitoring data set processing conditions are displayed through a visual monitoring page, so that data analysis is performed, the violation conditions are avoided, and services are adjusted.
3. An electronic device, comprising: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the steps of the method of claim 1.
4. A non-transitory computer readable storage medium having stored thereon computer instructions for causing the computer to perform the steps of the method of claim 1.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211102312.4A CN115185790B (en) | 2022-09-09 | 2022-09-09 | Data monitoring method and equipment for auditing business software |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211102312.4A CN115185790B (en) | 2022-09-09 | 2022-09-09 | Data monitoring method and equipment for auditing business software |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115185790A CN115185790A (en) | 2022-10-14 |
| CN115185790B true CN115185790B (en) | 2022-12-27 |
Family
ID=83524837
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211102312.4A Active CN115185790B (en) | 2022-09-09 | 2022-09-09 | Data monitoring method and equipment for auditing business software |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115185790B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1417690A (en) * | 2002-12-03 | 2003-05-14 | 南京金鹰国际集团软件系统有限公司 | Application process audit platform system based on members |
| CN102496073A (en) * | 2011-12-20 | 2012-06-13 | 南京审计学院 | Financial fraud audit assisting system and audit assisting method |
| CN113032710A (en) * | 2021-04-13 | 2021-06-25 | 上海汉邦京泰数码技术有限公司 | Comprehensive audit supervisory system |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108763957B (en) * | 2018-05-29 | 2021-09-14 | 电子科技大学 | Database security audit system, method and server |
| KR102127522B1 (en) * | 2018-06-20 | 2020-06-26 | 주식회사 티맥스티베로 | Computer program stored in computer readable medium, database server and audit performing server |
| CN109325044A (en) * | 2018-09-20 | 2019-02-12 | 快云信息科技有限公司 | A kind of the audit log processing method and relevant apparatus of database |
| CN110134659B (en) * | 2019-05-08 | 2023-03-21 | 厦门稿定股份有限公司 | Log monitoring system, method, medium, and apparatus for running program |
-
2022
- 2022-09-09 CN CN202211102312.4A patent/CN115185790B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1417690A (en) * | 2002-12-03 | 2003-05-14 | 南京金鹰国际集团软件系统有限公司 | Application process audit platform system based on members |
| CN102496073A (en) * | 2011-12-20 | 2012-06-13 | 南京审计学院 | Financial fraud audit assisting system and audit assisting method |
| CN113032710A (en) * | 2021-04-13 | 2021-06-25 | 上海汉邦京泰数码技术有限公司 | Comprehensive audit supervisory system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115185790A (en) | 2022-10-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110059110B (en) | Business data security processing method and device, computer equipment and storage medium | |
| CN112666927A (en) | Upgrading method and upgrading system for vehicle Electronic Control Unit (ECU) | |
| CN110930131A (en) | Vehicle maintenance method, device, equipment and medium | |
| CN103455288B (en) | Information processor and control method | |
| CN105653008A (en) | Night sleep message prompting method and device and electronic equipment | |
| EP3722945A1 (en) | Program operation system and program operation method | |
| CN115167831A (en) | Software integration method and device based on AUTOSAR and use method | |
| CN115578051A (en) | Vehicle asset management method and device | |
| CN115185790B (en) | Data monitoring method and equipment for auditing business software | |
| CN105653354A (en) | Batch processing method and device | |
| CN112783906A (en) | Log data management method and system for industrial internet | |
| CN113272785B (en) | Method for mounting file system, terminal equipment and storage medium | |
| CN110008104A (en) | A kind of management method of log information, system, equipment and storage medium | |
| CN112882920B (en) | Alarm policy verification method and device, electronic equipment and readable storage medium | |
| US9245306B2 (en) | Methods and apparatus for generating and accessing information in binary files | |
| CN115473785B (en) | Alarm information processing method and device, electronic equipment and storage medium | |
| CN111352640A (en) | Backboard firmware updating method and system | |
| CN112306040A (en) | Vehicle detection method, device, equipment and server | |
| CN111158829A (en) | Operation rollback processing method and device | |
| CN112104766B (en) | Diagnostic protocol reconstruction method, device, terminal equipment and storage medium | |
| CN111610935B (en) | Access control method, device, equipment and medium | |
| CN105574055A (en) | Method and apparatus for preventing memory from being exhausted | |
| CN112863008B (en) | Fault recording method and device, storage medium and computer equipment | |
| CN116775083B (en) | Brushing method and device of vehicle-mounted controller and electronic equipment | |
| CN115509337A (en) | Power supply detection method, device, equipment and readable storage medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |