6 results about "Database trigger" patented technology

The invention provides a vector geographic data efficient visualization method and system based on multi-scale optimization and containerization architecture, and belongs to the field of spatial big data visualization and cloud native GIS application. According to the method, the filling rate of the enclosing rectangles and the number of the vertexes are calculated for the original geographic element data, so that automatic classification of regular elements and irregular elements is realized; and respectively constructing two sets of multi-scale expression systems, and storing four types of multi-scale data tables in a spatial database. A containerized micro-service architecture is adopted, and dependence management and cooperative operation are automatically completed through a container arrangement tool. The vector slicing service dynamically selects a corresponding scale expression according to the scaling level. Through cooperative work of a database trigger, a monitoring service and a cache service, the system can calculate an affected slice number range and execute accurate cache deletion when element attributes are updated, and real-time and on-demand slice updating is realized. The method has the beneficial effects that the visualization performance and updating efficiency of massive vector elements are improved.

The invention relates to the technical field of electrical equipment monitoring data processing, and particularly discloses a method and system for improving the latest monitoring data query efficiency of electrical equipment. Comprising the following steps that S1, a new table with the same structure is created for a source table for storing monitoring data of the electrical equipment in a database, and the new table is used for exclusively storing latest monitoring data of each piece of electrical equipment; s2, creating a database trigger on the source table, and when new monitoring data is inserted into the source table, automatically executing an updating operation by the trigger so as to maintain the data in the new table to only contain the latest record corresponding to each electrical equipment identifier; s3, in response to a query request for the latest monitoring data of the electrical equipment, routing a query object to the new table so as to obtain a query result from the new table; the technical problems that in the prior art, due to continuous accumulation of monitoring data of electrical equipment, response is slow when the latest state is inquired, and the database load is too high are solved.

The application provides a kind of data sharing method and system based on embedded rule, extracts entity under each subject domain and the association between entities, constructs entity relationship model, and embeds data constraint rules in entity relationship model, maps entity relationship model into physical data model, after extracting the business data required by customer, the rules embedded in physical data model can be directly called to check data. Based on the traditional mode, the business rules are scattered in the application code, database trigger or artificial experience, it is difficult to extract and reuse. Through systematic analysis, the core business rules (verified by pilot) are coded into the entity relationship model, and the data is issued together. After receiving, customers can directly call these preset rules for data verification, without starting from scratch to build a verification system, significantly reducing implementation costs.

The invention provides a pre-analysis method and device for business demand defects, a medium and a program product. Relates to the technical field of data processing. The method comprises the following steps: acquiring a demand document containing a business operation rule and a constraint requirement, splitting sub-tasks according to a preset splitting rule, distributing the sub-tasks to different computing nodes, and performing parallel analysis by combining a preset demand feature template to obtain a result; performing natural language processing on an analysis result to extract structured demand features, adjusting trigger scene feature weights in a historical defect database, matching the features with database trigger scenes to obtain defect information, and generating an early warning report; and finally, obtaining production operation data association structural features corresponding to the early warning report, performing analysis to obtain newly added defect information, supplementing the newly added defect information to the database, and updating the weight. The large-scale document analysis efficiency is effectively improved, the defect recognition accuracy and adaptability are enhanced, a dynamic iteration closed loop is formed, the disjunction limitation of traditional analysis and post-investment operation is broken through, and defect full-life-cycle management is achieved.

The invention discloses a database integrity protection method and device, equipment and a storage medium, and relates to the technical field of information security. Comprising the following steps: selecting an original table needing integrity protection in a database, and adding an integrity protection field for storing a message authentication code to generate a target table; creating a view with the same structure as the original table to take over data access; a database trigger is created on the target table, when data is added, deleted and changed through a view, the trigger triggers and calls a user-defined function, and according to a preset access control strategy, a message authentication code in the integrity protection field is generated, updated or kept; and when the data is queried through the view, calculating a current message authentication code of the protected field, comparing the current message authentication code with a stored historical message authentication code, and performing data integrity verification according to a comparison result. By means of the data integrity protection method and device, under the condition that the application system is free of transformation, data integrity protection of the database cell level can be achieved, and the application system is prevented from using tampered data.

This invention relates to the field of configuration management technology, specifically to a unified configuration and recovery method and a readable storage medium based on a relational model. The method includes the following steps: Model generation step: obtaining the schema definition and parsing it to generate a relational model; Configuration distribution step: performing rule and dependency checks on configuration parameters according to the relational model, and distributing configuration parameters according to database triggers after successful checks; Configuration saving step: configuring according to the distributed configuration parameters, and temporarily saving the configuration parameters in memory after successful configuration; saving the configuration parameters to disk when a configuration saving trigger is triggered. This solution addresses the technical problems of difficulty in maintaining configuration parameters and inconsistencies between user configuration and system configuration states in existing device configuration distribution and saving processes.