Modeling and verifying DML triggers using event-B

Authors:
Hong Anh Le;Ninh Thuan Truong
Affiliations:
Hanoi University of Mining and Geology, Hanoi, Vietnam;VNU - University of Engineering and Technology, Hanoi, Vietnam
Venue:
ACIIDS'13 Proceedings of the 5th Asian conference on Intelligent Information and Database Systems - Volume Part II
Year:
2013

Citing 8
Cited 0

An algebraic approach to static analysis of active database rules

ACM Transactions on Database Systems (TODS)
Detecting Termination of Active Database Rules Using Symbolic Model Checking

ADBIS '01 Proceedings of the 5th East European Conference on Advances in Databases and Information Systems
A Structural Model of ECA Rules in Active Database

MICAI '02 Proceedings of the Second Mexican International Conference on Artificial Intelligence: Advances in Artificial Intelligence
Verify Updating Trigger Correctness

DEXA '99 Proceedings of the 10th International Conference on Database and Expert Systems Applications
Are Your Trigger Rules Correct?

DEXA '98 Proceedings of the 9th International Workshop on Database and Expert Systems Applications
Modeling in Event-B: System and Software Engineering

Modeling in Event-B: System and Software Engineering
ECAPNVer: A Software Tool to Verify Active Rule Bases

ICTAI '10 Proceedings of the 2010 22nd IEEE International Conference on Tools with Artificial Intelligence - Volume 02
A Petri Net-Based Metric for Active Rule Validation

ICTAI '11 Proceedings of the 2011 IEEE 23rd International Conference on Tools with Artificial Intelligence

Quantified Score

Hi-index	0.00

Visualization

Abstract

Database trigger is a block code that automatically executes in response to changes of table or view in the database system. The correctness of a trigger usually can be verified when it is executed. It is apparently useful if we can detect the trigger system's errors in the design phase. In this paper, we introduce an approach to model and verify data manipulation language (DML) triggers in the database system by a formal method. In the first phase, we formalize a database trigger system by an Event-B model. After that, we use the Rodin tool to verify some properties of the system such as termination, preservation of constraint rules. We also run an example to illustrate the approach in detail.