Title
A SERM based framework for defining and processing rules supporting the verification of data consistency and integrity
Authors
[ 1 ] Wydział Techniczny, Akademia im. Jakuba z Paradyża | [ P ] employee
Scientific discipline (Law 2.0)
Year of publication
2022
Published in
Article type
scientific article / paper
Publication language
english
Keywords
EN
- SERM semantic data model; logical rules; database programming objects; rule functions
Abstract
EN The SERM (Structured Entity Relationship Diagram) data model is a hierarchical extension of the classic ER (Entity Relationship) model. The hierarchical structure of the SERM diagram means that any closed circuit relationship can cause inconsistency and lack of data integrity. The occurrence of these problems is uncertain and should be systematically investigated. Therefore, there is a clear need to develop an approach supporting the definition of logical rules that would control these elements. The aim of the article is to present the framework supporting the intelligent design of relational databases. Its main aspects include identification and semi-automatic handling of logical rules based on the SERM model. An important advantage of the approach is that it does not limit itself to building a semantic data model, but also uses it to design database programming objects such as procedures, functions and triggers that guard the consistency of databases
Pages (from - to)
4227 - 4236
License type
CC BY-NC-ND (attribution - noncommercial - no derivatives)
Open Access Mode
open journal
Open Access Text Version
final published version
Release date
19.10.2022
Date of Open Access to the publication
at the time of publication
Ministry points / journal
5
Ministry points / conference (CORE)
70
This website works thanks to the software SINUS
created by Poznan Supercomputing and Networking Center
Log in to submit to SIS: