General data triggering method based on triggering rule description file
A technology for describing files and data. It is used in electrical digital data processing, natural language data processing, software engineering design, etc. It can solve the problems of reusability and poor portability of relational database triggers, and achieve reusability. and portability improvement, the effect of improving scalability
Active Publication Date: 2020-12-08
NARI TECH CO LTD +2
View PDF2 Cites 1 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0006] Purpose of the invention: In order to solve the problems existing in the prior art, the present invention proposes a general data trigger method based on the trigger rule description file to provide an efficient and accurate power grid equipment model data trigger solution and solve the problem of using relational data in the control system. Poor reusability and portability of database triggers
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment
[0084] In this embodiment, the trigger rule description file is defined as follows:
[0085]
[0086]
[0087] When the submitted data operation is to delete the data whose id is 1 in TABLEA, the generated statement triggered by this rule is delete from tableB where id='1'; delete from tableA where id='1'.
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention provides a general data triggering method based on a triggering rule description file, which comprises the following steps of: defining a triggering rule in the file, performing lexicaland syntactic analysis through Lex and Yacc to generate an abstract syntax tree, traversing a corresponding syntax tree linked list structure according to submitted data to obtain a triggering statement, and finally realizing triggering of the data. According to the invention, the problem that a relational database trigger used in a regulation and control system is poor in reusability and transportability is solved.
Description
technical field [0001] The invention belongs to the technical field of research and application of smart grid power transmission and transformation equipment model data triggering, and in particular relates to a general data triggering method based on a trigger rule description file. Background technique [0002] In existing systems, commercial database triggers are used to achieve the data trigger function. Commercial library triggers mainly complete cascading data triggering and data validity verification, mainly using the implicit transaction characteristics of triggers to ensure that modified records and triggered records are submitted in the same transaction, thereby ensuring business data integrity. However, with the diversification and complexity of system business logic and the increase of data volume, excessive use of database triggers will have a negative impact on system function expansion and portability. [0003] For business scenarios triggered by grid equipm...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More IPC IPC(8): G06F8/30G06F8/41G06F40/205G06F40/253
CPCG06F8/315G06F8/42G06F40/205G06F40/253
Inventor 曹卫华李昊杨启京陶士昌翟毅徐天品刘春尧季惠英沈嘉灵孙荣西
Owner NARI TECH CO LTD



