eprintid: 4076 rev_number: 6 eprint_status: archive userid: 329 dir: disk0/00/00/40/76 datestamp: 2020-10-09 07:10:50 lastmod: 2020-10-09 07:10:50 status_changed: 2020-10-09 07:10:50 type: article metadata_visibility: show creators_name: Le, Hong Anh creators_name: To, Van Khanh creators_name: Truong, Ninh Thuan creators_id: lehonganh@humg.edu.vn creators_id: khanhtv@vnu.edu.vn creators_id: thuantn@vnu.edu.vn title: Formal Analysis of Database Trigger Systems Using Event-B ispublished: inpress subjects: Scopus divisions: fac_fit abstract: Most modern relational database systems use triggers to implement automatic tasks in response to specific events happening inside or outside a system. A database trigger is a human readable block code without any formal semantics. Frequently, people can check if a trigger is designed correctly after it is executed or by manual checking. In this article, the authors introduce a new method to model and verify database trigger systems using Event-B formal method at design phase. First, the authors make use of similar mechanism between triggers and Event-B events to propose a set of rules translating a database trigger system into Event-B constructs. Then, the authors show how to verify data constraint preservation properties and detect infinite loops of trigger execution with RODIN/Event-B. The authors also illustrate the proposed method with a case study. Finally, a tool named Trigger2B which partly supports the automatic modeling process is presented. date: 2021 date_type: published publisher: IGI Global Publishing official_url: https://www.igi-global.com/journal/international-journal-software-innovation/64245 full_text_status: none publication: International Journal of Software Innovation volume: 9 number: 4 refereed: TRUE issn: 2166-7160 citation: Le, Hong Anh and To, Van Khanh and Truong, Ninh Thuan (2021) Formal Analysis of Database Trigger Systems Using Event-B. International Journal of Software Innovation, 9 (4). ISSN 2166-7160 (In Press)