The University of Southampton
University of Southampton Institutional Repository

Incremental and rigorous database design and code generation using UML-B and event-B

Incremental and rigorous database design and code generation using UML-B and event-B
Incremental and rigorous database design and code generation using UML-B and event-B
Correct operation of many critical systems is dependent on the consistency and integrity properties of underlying databases. Therefore, a verifiable and rigorous database design process is highly desirable. This research investigated and delivered a comprehensive and practical approach for modelling databases in a formal method and provide a tool that translates the verified model to a database implementation. The methodology was guided by a number of case studies, using abstraction and refinement in UML-B and verification with the Rodin tool. UML-B is a graphical representation of the Event-B formalism and the Rodin tool supports verification for Event-B and UML-B. Our method guides developers to model relational databases in UML-B through layered refinement and to specify the necessary constraints and operations on the database. The guidelines are supported by a tool we have developed called UB2DB that automatically generates a database system from a verified UML-B model. The tool generates both the structure to create the database in Oracle as well as the necessary operations on the database that has been modelled as events in UML-B model. The evaluation shows that the generated code from the models of the case studies preserves the constraints of the database and the performance of the operations is not very different from a hand written code.
University of Southampton
Al-Brashdi, Ahmed Zahran Nasser
8395223a-1be2-4f00-9af1-271163edab41
Al-Brashdi, Ahmed Zahran Nasser
8395223a-1be2-4f00-9af1-271163edab41
Butler, Michael
54b9c2c7-2574-438e-9a36-6842a3d53ed0

Al-Brashdi, Ahmed Zahran Nasser (2020) Incremental and rigorous database design and code generation using UML-B and event-B. University of Southampton, Doctoral Thesis, 162pp.

Record type: Thesis (Doctoral)

Abstract

Correct operation of many critical systems is dependent on the consistency and integrity properties of underlying databases. Therefore, a verifiable and rigorous database design process is highly desirable. This research investigated and delivered a comprehensive and practical approach for modelling databases in a formal method and provide a tool that translates the verified model to a database implementation. The methodology was guided by a number of case studies, using abstraction and refinement in UML-B and verification with the Rodin tool. UML-B is a graphical representation of the Event-B formalism and the Rodin tool supports verification for Event-B and UML-B. Our method guides developers to model relational databases in UML-B through layered refinement and to specify the necessary constraints and operations on the database. The guidelines are supported by a tool we have developed called UB2DB that automatically generates a database system from a verified UML-B model. The tool generates both the structure to create the database in Oracle as well as the necessary operations on the database that has been modelled as events in UML-B model. The evaluation shows that the generated code from the models of the case studies preserves the constraints of the database and the performance of the operations is not very different from a hand written code.

Text
AhmedAlBrashdi,PhD,CyberPhysicalSystems,April2020
Available under License University of Southampton Thesis Licence.
Download (9MB)
Text
Permission to deposit thesis - form
Restricted to Repository staff only

More information

Published date: April 2020

Identifiers

Local EPrints ID: 447757
URI: http://eprints.soton.ac.uk/id/eprint/447757
PURE UUID: a42c223f-15e8-47cc-8415-5a6defe31ea0
ORCID for Michael Butler: ORCID iD orcid.org/0000-0003-4642-5373

Catalogue record

Date deposited: 19 Mar 2021 17:32
Last modified: 13 Dec 2021 02:40

Export record

Contributors

Author: Ahmed Zahran Nasser Al-Brashdi
Thesis advisor: Michael Butler ORCID iD

Download statistics

Downloads from ePrints over the past year. Other digital versions may also be available to download e.g. from the publisher's website.

View more statistics

Atom RSS 1.0 RSS 2.0

Contact ePrints Soton: eprints@soton.ac.uk

ePrints Soton supports OAI 2.0 with a base URL of http://eprints.soton.ac.uk/cgi/oai2

This repository has been built using EPrints software, developed at the University of Southampton, but available to everyone to use.

We use cookies to ensure that we give you the best experience on our website. If you continue without changing your settings, we will assume that you are happy to receive cookies on the University of Southampton website.

×