15 results about "Database trigger" patented technology

The invention relates to the technical field of information management methods, and discloses a data query management method based on dynamic cache optimization. Comprising the steps of constructing a dynamic aging adjustment engine, and automatically adjusting cache time based on data change frequency; real-time monitoring is carried out through a database trigger and log analysis; the method comprises the following steps: acquiring a historical query record, predicting query types and time possibly initiated by a user in the future through a machine learning model, before the query time is predicted, loading predicted query type data to a cache, dynamically marking hotspot data according to an access frequency, preferentially allocating cache resources to the hotspot data, and prolonging the time efficiency; constructing a multi-level cache architecture based on a local cache and a distributed cache, and acquiring data by adopting a cache degradation strategy; an enhanced Kafka message processing mechanism is introduced; the method has the advantages of improving data query efficiency and ensuring data consistency.

The invention discloses a multi-dimensional index calculation method based on a graph database. The method comprises the following steps: defining an index graph storage model based on the graph database; registering a parameterized calculation task corresponding to the index in a built-in calculation framework of a graph database; when a user query request arrives, submitting a query transaction through a long connection channel established by driving the graph database, and directly accessing local storage data by a calculation framework to complete real-time calculation and return a result; when the original data in the graph database is changed, a database trigger captures a change event and pulls up the calculation task in the same process; user query triggering and data updating triggering share the same set of calculation task and graph traversal logic, and storage and calculation integrated real-time multi-dimensional index calculation and updating are achieved. The multi-dimensional index calculation method based on the graph database provided by the invention only depends on the graph database and its own calculation framework, simplifies a data processing link, and improves the index output efficiency.

Database trigger firing techniques for reducing unnecessary trigger firings are disclosed. In one embodiment a computer system stores trigger information relating to initiating execution of at least one trigger instruction for a database in connection with a database operation statement. The trigger information includes a first set of one or more database field identifiers for a first set of one or more fields in the database and a second set of one or more database field identifiers for a second set of one or more fields in the database. The computer system receives a database operation statement and makes determinations that at least one field within the first set of fields and at least one field within the second set of fields is specified by the database operation statement. Based at least in part on the determinations, the computer system initiates execution of the at least one trigger instruction.

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.

This invention discloses a multi-dimensional indicator calculation method based on a graph database, comprising: defining an indicator graph storage model based on the graph database; registering parameterized calculation tasks corresponding to the indicators in the built-in computing framework of the graph database; when a user query request arrives, submitting the query transaction through a long connection channel established by the graph database driver, and the computing framework directly accessing local storage data to complete real-time calculation and return the results; when the original data in the graph database changes, the database trigger captures the change event and launches the calculation task in the same process; the user query trigger and the data update trigger share the same set of calculation tasks and graph traversal logic, realizing real-time multi-dimensional indicator calculation and updating with integrated storage and computation. The multi-dimensional indicator calculation method based on a graph database provided in this application only relies on the graph database and its own computing framework, simplifying the data processing chain and improving the efficiency of indicator output.

Techniques are disclosed relating to implementing a statement-level INSTEAD OF trigger. In one embodiment a computer system receives a database operation statement specifying performance of a particular database operation on one or more database views of selected data from a database, wherein a given database trigger of one or more statement-level database triggers is executable to initiate execution of at least one trigger instruction for the database instead of performing the particular database operation on a specified database view of the one or more database views. For a given database view of the one or more database views, the computer system stores a trigger function call in a function call data structure for each statement-level database trigger defined for the database operation statement and the given database view. The computer system executes the stored trigger function calls instead of executing the database operation statement.

This invention belongs to the field of database synchronization technology, specifically relating to a method and system for incremental synchronization of PostgreSQL database indexes. A first auxiliary table is created in the source PostgreSQL database, and all index information is stored in the first auxiliary table after database queries. A second auxiliary table is created in the source PostgreSQL database, including DDL execution event information. A trigger is created in the source PostgreSQL database to listen for DDL execution events. When a DDL statement is executed, storage logic is executed according to the different DDL statement types. A data synchronization tool is used to synchronize the second auxiliary table to the target database. A trigger is configured in the target database to listen for INSERT operations and execute the DDL statements in the INSERT event statements to perform DDL synchronization of specific tables. It supports synchronizing only DDL statements of specific tables, resulting in higher synchronization efficiency, stronger configurability, less modification to the source database, and no need to add a preset .so file configuration to the source database's lib directory.

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 relates to an SG-CIM model-based electric power project model review method and system, and belongs to the technical field of electric power system data management and intelligent review, and the method comprises the following steps: extracting a logic model from an electric power project design document, building a dynamic rule engine based on a power grid public data SG-CIM model library, performing real-time or regular rule matching on the logic model by adopting a three-stage filtering algorithm to generate a logic model difference report; a physical model in the power project implementation database is collected and analyzed, and a mapping matrix of the physical model and the logic model is constructed; when the physical model is updated, capturing real-time physical model data change through a database trigger, and verifying a mapping relation between the physical model and the logic model through a mapping matrix; calculating an electric power project model compliance score according to the logic model difference report and the mapping relation verification result; and outputting an electric power project review report and a rectification suggestion based on the electric power project model compliance score, the logic model difference report and the mapping relation verification result.

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.

Techniques are disclosed relating to implementing a statement-level INSTEAD OF trigger. In one embodiment a computer system stores trigger information associated with a statement-level database trigger executable to initiate execution of at least one trigger instruction for a database instead of performing a particular database operation, on a database view, specified by a database operation statement. The computer system receives a first database operation statement specifying performance of the particular database operation on the database view and identifies a set of target rows, within the database view, targeted by the first database operation statement. In addition, the computer system generates a reference table associated with the database view, where the reference table includes rows corresponding to the target rows. The computer system executes the statement-level database trigger instead of executing the database operation statement, where executing the statement-level database trigger includes accessing the reference table.

The invention provides a service directory change notification method and device and electronic equipment. The method comprises the steps of generating a directory change event of a target service directory based on a database trigger or a page operation capture mode; determining an event notification mode of the directory change event based on the application scene of the target service directory; and sending the directory change event conforming to the subscription rule selected by the user to the user side based on the event notification mode. According to the method, the directory change event of the target service directory is generated in a database trigger or page operation capture mode, and service directory change can be monitored in real time; according to the embodiment of the invention, the event notification mode of the directory change event is determined through the application scene of the target service directory, and the directory change event conforming to the subscription rule selected by the user is sent to the terminal of the user based on the event notification mode, so that the event notification efficiency can be improved, and accurate pushing of service directory change is realized.

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.