Method and device for realizing trigger

A trigger and statement technology, applied in the database field, can solve problems such as not supporting triggers and affecting the functional characteristics of distributed databases, and achieve the effect of improving experience and enhancing functional characteristics

Active Publication Date: 2021-05-28
金篆信科有限责任公司
View PDF6 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the process of implementing this application, the inventor found that the distributed database in the prior art does not support triggers yet, but in some appl...

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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for realizing trigger
  • Method and device for realizing trigger
  • Method and device for realizing trigger

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] In order to make the purpose, technical solution and advantages of the application clearer, the embodiments of the application will be described in detail below in conjunction with the accompanying drawings. It should be noted that, in the case of no conflict, the embodiments in the present application and the features in the embodiments can be combined arbitrarily with each other.

[0019] Such as figure 1 As shown in FIG. 1 , it is a schematic flow chart of a trigger implementation method provided in this application. This method may be applicable to a situation where a trigger is used to trigger a request to execute a statement. The method can be executed by the device implemented by the trigger provided in this application, the device implemented by the trigger is implemented by software and / or hardware, and integrated on a device.

[0020] Such as figure 1 As shown, a schematic flow chart of a trigger-implemented method provided in an embodiment of the present a...

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

No PUM Login to view more

Abstract

The invention provides a trigger implementation method and device. The method comprises the following steps: determining a statement writing request execution plan tree and a trigger execution plan tree corresponding to a statement writing request according to the type of the statement writing request; combining the write statement request execution plan tree and the trigger execution plan tree to obtain a write request trigger plan tree; and executing the write request to trigger the plan tree. When the statement writing request is executed, the execution logic of the trigger can be added into the execution logic of the original statement writing request, and the original statement writing request is executed through the newly formed execution plan, so that the application of the trigger is realized on the basis of the distributed database, and the functional characteristics of the distributed database are enhanced; The user experience effect is improved.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a method and device for trigger realization. Background technique [0002] A trigger is a method provided by the database to programmers and analysts to ensure data integrity. It is a special stored procedure related to table events. Its execution is not called by the program, but triggered by the event. For example, when It is activated when an operation is performed on a table. [0003] In the process of implementing this application, the inventor found that the distributed database in the prior art does not support triggers at present, but the function of triggers is urgently needed in some application scenarios and business lines, thus affecting the functional characteristics of distributed databases. and user experience. Contents of the invention [0004] In order to solve at least one of the above technical problems, embodiments of the present application pr...

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
no application Login to view more
IPC IPC(8): G06F16/2455G06F16/27
CPCG06F16/24565G06F16/27G06F16/24542
Inventor 王海军丁岩
Owner 金篆信科有限责任公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap