CN112256261A - Monitoring script visual configuration method based on power grid collaborative service scene - Google Patents
Monitoring script visual configuration method based on power grid collaborative service scene Download PDFInfo
- Publication number
- CN112256261A CN112256261A CN202011190402.4A CN202011190402A CN112256261A CN 112256261 A CN112256261 A CN 112256261A CN 202011190402 A CN202011190402 A CN 202011190402A CN 112256261 A CN112256261 A CN 112256261A
- Authority
- CN
- China
- Prior art keywords
- monitoring
- service
- script
- rule
- sql
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a monitoring script visual configuration method based on a power grid collaborative service scene, which specifically comprises the following steps: selecting a service range, configuring a master table sql, judging whether a service monitoring rule capable of being directly multiplexed exists at present, selecting a current rule to copy and generate a new monitoring rule when the rule capable of being directly multiplexed exists, splicing the new monitoring rule with the master table sql to generate the monitoring rule, and if the rule capable of being directly multiplexed does not exist, visually configuring the service monitoring rule according to service monitoring logic, converting the service monitoring rule into an sql script, custom-adjusting the monitoring script, and splicing the monitoring script with the master table sql to generate a complete monitoring script. The invention can support the configuration of the business association relation and the monitoring object from the perspective of business logic, automatically complete the conversion from the business relation to the sql script, and adjust the converted script, thereby not only facilitating the understanding and configuration of business personnel, but also reducing the difficulty of script writing.
Description
Technical Field
The invention relates to the technical field of power systems, in particular to a monitoring script visual configuration method based on a power grid collaborative service scene.
Background
Along with the popularization of the collaborative application of the integrated enterprise management information system, the data quality and the business collaborative management work are very important, especially the station line subscriber identity and the account object accuracy, a great amount of manpower is always spent on compiling the verification rule script, and meanwhile, because the problems that the script is difficult to compile due to the technical shortage of business personnel and the incapability of keeping up with the business capability of the technical personnel often occur, a more business-approaching and visual rule configuration page needs to be established to support the business personnel and the technical personnel to better complete the compiling of the collaborative data monitoring script, so that the data consistency analysis efficiency is improved, and the smooth circulation of the collaborative business process is further promoted.
Disclosure of Invention
The technical problem to be solved by the invention is to provide a monitoring script visual configuration method based on a power grid collaborative service scene, which is convenient for service personnel to understand and configure and reduces the difficulty of script writing.
In order to solve the technical problems, the technical scheme adopted by the invention is as follows.
A monitoring script visual configuration method based on a power grid collaborative service scene specifically comprises the following steps:
A. selecting a service range, and configuring a main table sql;
B. judging whether a service monitoring rule capable of being directly multiplexed exists or not at present, if so, performing the step C, and if not, performing the step D;
c, selecting a current rule to copy to generate a new monitoring rule, and splicing the new monitoring rule with the master table sql to generate a monitoring rule;
D. configuring a service monitoring rule according to the service monitoring logic visualization;
E. converting the service monitoring rule into an sql script;
F. self-defining and adjusting the monitoring script;
G. and splicing the monitoring script with the main table sql to generate a complete monitoring script.
In the above visualized configuration method of monitoring scripts based on power grid collaborative service scenario, the service monitoring rule in step B is a set of service data error judgment logic set for finding a problem of data transmission errors in a service collaboration process.
In the step B, the judgment method is to check whether the currently existing monitoring rule name, the used service table, the used service logic, the related coordination system and other information are related to the service logic table or the service logic to be configured.
In the visual configuration method of the monitoring script based on the power grid collaborative service scene, the self-defined adjustment method of the monitoring script in the step F is to enter an editing interface of the sql script and directly edit and increase relevant database tables and data conditions.
In the step F, the splicing method is to establish an association relationship with equal attributes through the key service attributes in the main table and the key attributes set in the monitoring rule sql, and splice the rule script sql directly after being limited by exists syntax to generate executable complete sql.
Due to the adoption of the technical scheme, the technical progress of the invention is as follows.
The invention can support the configuration of the business association relation and the monitoring object from the perspective of business logic, automatically complete the conversion from the business relation to the sql script, and adjust the converted script, thereby not only facilitating the understanding and configuration of business personnel, but also reducing the difficulty of script writing.
Drawings
FIG. 1 is a block flow diagram of the present invention.
Detailed Description
The invention will be described in further detail below with reference to the figures and specific examples.
A monitoring script visualization configuration method based on a power grid collaborative service scene is disclosed, a flow chart of which is shown in figure 1, and the method specifically comprises the following steps:
A. selecting a service range, and configuring a master table sql. And configuring key service attributes of the main table and generating a main table sql, wherein the data range of the main table sql represents the service range.
B. And judging whether a directly reusable service monitoring rule exists at present.
The service monitoring rule is a set of service data error judgment logic set for finding a problem of data transmission errors in a service cooperation process.
The judging method is that whether the currently existing monitoring rule name, the used information such as the service table, the service logic, the related coordination system and the like has the same service table or service logic with the service logic to be configured is checked.
And C, when the rule capable of being directly multiplexed exists, performing step C, and when the rule capable of being directly multiplexed does not exist, performing step D.
C. When the rule capable of being directly multiplexed exists, the current rule is selected to be copied to generate a new monitoring rule, and the new monitoring rule is spliced with the main table sql to generate the monitoring rule.
And if the checked service monitoring rules are basically consistent and only the service range is expanded, directly selecting the current rule to copy to generate a new monitoring rule, and splicing with the master table sql to generate the monitoring rule.
D. And when no rule of direct multiplexing exists, the business monitoring rule is configured according to the business monitoring logic visualization.
For example, in a collaborative process, a link of the system a is collaborative to a batch of data of the system B, and it is necessary to determine whether the batch of data is collaboratively erroneous, and the consistency and accuracy of data related attributes transmitted between the two systems are determined by setting basic conditions such as data collaboration trigger conditions and collaboration success.
Then, selecting a service table according to the understanding of the service monitoring requirement, and finding a service association relation on an interface, for example, whether indexes of a service table A and a service table B are consistent or not, a unique main key capable of being associated between the two service tables needs to be set firstly, so that the same service data is compared; meanwhile, the monitored service index and the key attribute of monitoring result output need to be specified.
E. And converting the service monitoring rule into an sql script.
And automatically generating a monitoring script in an sql format according to the service table, the service association relation, the monitoring index and the service key attribute configured by the visual page.
F. And (5) self-defining the adjustment monitoring script.
And entering an automatically generated sql script interface, clicking and editing, modifying the script interface into an editable state, directly editing and adding a related database table and data conditions on a script page, and storing after editing is finished.
G. And splicing the monitoring script with the main table sql to generate a complete monitoring script.
The splicing method comprises the steps of establishing an association relation with equal attributes through key service attributes in a main table and key attributes set in a monitoring rule sql, directly splicing the main table sql after a rule script sql is limited by exists grammar to generate executable complete sql, and flexibly controlling a monitoring range within a service range
When the visual monitoring script is configured, the system can automatically generate the script and simultaneously support the self-defined adjustment of the script by selecting the corresponding service table through understanding the service, particularly, clicking an interface on an automatically generated script page to separate from the current visual configuration page to support the editing of the script page, so that a user can manually increase the corresponding script sql and then click to store the script, namely, the latest script is generated, and the difficulty in manually writing the script is reduced.
After the splicing of the monitoring script and the service range master table sql is completed, the last layer of filtering is performed on the monitoring data, meanwhile, the monitoring scripts of different service scenes can be generated by splicing different master tables sql, and the flexible expansion of the monitoring scenes is supported.
Claims (5)
1. A monitoring script visual configuration method based on a power grid collaborative service scene is characterized in that: the method specifically comprises the following steps:
A. selecting a service range, and configuring a main table sql;
B. judging whether a service monitoring rule capable of being directly multiplexed exists or not at present, if so, performing the step C, and if not, performing the step D;
C. selecting a current rule to copy and generate a new monitoring rule, and splicing the new monitoring rule with the master table sql to generate the monitoring rule;
D. configuring a service monitoring rule according to the service monitoring logic visualization;
E. converting the service monitoring rule into an sql script;
F. self-defining and adjusting the monitoring script;
G. and splicing the monitoring script with the main table sql to generate a complete monitoring script.
2. The monitoring script visualization configuration method based on the power grid collaborative service scenario according to claim 1, wherein: the service monitoring rule in step B is a set of service data error judgment logic set for finding a problem of data transmission error in the service cooperation process.
3. The monitoring script visualization configuration method based on the power grid collaborative service scenario according to claim 1, wherein: and the judgment method in the step B is to check whether the currently existing monitoring rule name, the used information such as the service table, the service logic, the related cooperative system and the like are related to the service logic table or the service logic to be configured.
4. The monitoring script visualization configuration method based on the power grid collaborative service scenario according to claim 1, wherein: and F, entering an editing interface of the sql script to directly edit and increase relevant database tables and data conditions.
5. The monitoring script visualization configuration method based on the power grid collaborative service scenario according to claim 1, wherein: and G, the splicing method is to establish an association relation with equal attributes through the key service attributes in the main table and the key attributes set in the monitoring rule sql, and directly splice the main table sql after the rule script sql is limited by exists syntax to generate executable complete sql.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011190402.4A CN112256261A (en) | 2020-10-30 | 2020-10-30 | Monitoring script visual configuration method based on power grid collaborative service scene |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011190402.4A CN112256261A (en) | 2020-10-30 | 2020-10-30 | Monitoring script visual configuration method based on power grid collaborative service scene |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112256261A true CN112256261A (en) | 2021-01-22 |
Family
ID=74268341
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011190402.4A Pending CN112256261A (en) | 2020-10-30 | 2020-10-30 | Monitoring script visual configuration method based on power grid collaborative service scene |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112256261A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116204177A (en) * | 2023-03-17 | 2023-06-02 | 湖北坤盈数字科技有限公司 | System service module development coupling assembly method and device and computer equipment |
-
2020
- 2020-10-30 CN CN202011190402.4A patent/CN112256261A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116204177A (en) * | 2023-03-17 | 2023-06-02 | 湖北坤盈数字科技有限公司 | System service module development coupling assembly method and device and computer equipment |
| CN116204177B (en) * | 2023-03-17 | 2023-10-03 | 湖北坤盈数字科技有限公司 | System service module development coupling assembly method and device and computer equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108647883B (en) | Business approval method, device, equipment and medium | |
| CN101888655B (en) | Method and device for configuring network element data in template way in network management system | |
| CN105760991A (en) | Workflow engine establishment method of changeable service flow | |
| CN104123227A (en) | Method for automatically generating testing cases | |
| CN110659018B (en) | Method and device for realizing flow engine | |
| US20090198727A1 (en) | Trace-based database schema evolution method and system | |
| CN102043753B (en) | Device information setting apparatus and device information setting method | |
| CN111208995A (en) | Method, system, device and storage medium for automatically generating IBM host job | |
| CN112256261A (en) | Monitoring script visual configuration method based on power grid collaborative service scene | |
| CN102521008A (en) | Program compiling device and method for compiling program | |
| CN103109289B (en) | Based on the script edit methods of WEB, system and WEB client side | |
| CN105893591A (en) | Intelligent compiling technology of data sharing service | |
| CN110854824B (en) | Method and device for monitoring availability of relay protection service of power communication network | |
| CN116893822A (en) | Workflow engine multi-environment deployment method and system, electronic device and storage medium | |
| CN112989451B (en) | Point table automatic generation method based on secondary system digital software | |
| CN104731597A (en) | Method for applying SQL statements to engineering software compiling platform | |
| CN111428379B (en) | Method for guaranteeing connection consistency between simulation system diagrams of nuclear power station analog machine | |
| CN115344966A (en) | CAD assembly body part replacement method and system | |
| CN105868410A (en) | Model-driven intelligent SCD (substation configuration description) file and CIM/E (common information model/efficiency) file conversion tool and method | |
| CN111831561B (en) | Plug-in type test case library system | |
| CN112597343A (en) | Netconf automatic configuration generation method | |
| CN100474852C (en) | Method for communicating between telecommunication equipment service terminal and customer terminal | |
| CN109446386A (en) | A kind of data query method and device | |
| CN108647018A (en) | Can live preview code generating system | |
| CN114531335B (en) | Method, equipment and device for detecting management information base data |
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 |