Design and implementation of trigger on OceanBase

Abstract

Trigger technology is an important part of database design and development. It is an important function module of database management system. It is a special type of stored procedure. The implicit implementation of the trigger makes it an effective way to ensure data integrity in the database. OceanBase is a new type of mass distributed database system, but the existing OceanBase open-source version does not support the trigger function, affecting the system to promote and use. Based on the deep analysis of the working principle of traditional database triggers and the overall architecture of OceanBase, this paper designs and implements the trigger function of OceanBase.