Method and device for realizing function of database trigger

A trigger and database technology, applied in the field of communication, to achieve the effect of improving efficiency, enriching functions, and meeting application requirements
CN102289433BInactive Publication Date: 2015-03-25ZTE CORP
2 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN Β· China
Patent Type
Patents(China)
Current Assignee / Owner
ZTE CORP
Publication Date
2015-03-25
Estimated Expiration
Not applicable Β· inactive patent

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

A method and a device for realizing the function of database trigger are disclosed. The method includes the following steps: registering a table-level trigger (S101); obtaining a table record, which is needed to be loaded, from a file, when the file is needed to be added to the database, and comparing the obtained table record with a table record in the database (S102); updating the database when there is variation in the obtained table record, and distributing a message about variety of the table in the database according to the registered table-level trigger (S103). A function of triggering in table unit and informing an application module of the data in the database being varied is realized. The method enriches the function of database trigger, satisfies the application requirement of table-level triggering, saves the processing time of the trigger by the database, and enhances the efficiency of the data real-time synchronization at the foreground.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The invention relates to the technical field of communication, in particular to a method and device for realizing the trigger function of a database. Background technique

[0002] A trigger in a database is a stored procedure that improves the execution efficiency of an embedded system. In the embedded database, when the data changes, whether it is adding, deleting, or modifying the data, it is necessary to notify the application that the data it cares about has changed and the specific content of the change. The function of the trigger is to improve the real-time performance of the system and enhance the synchronization function of the system to external data.

[0003] The specific implementation of the embedded database trigger, as well as the collaborative relationship between modules, and the data processing flow, as shown in the attached figure 1 shown. Among them, the trigger registration module is used to register triggers, providing a trigge...

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