Depending on the amount of data to process, file generation may take longer.

If it takes too long to generate, you can limit the data by, for example, reducing the range of years.


Download BibTeX


A SERM based framework for defining and processing rules supporting the verification of data consistency and integrity


[ 1 ] Wydział Techniczny, Akademia im. Jakuba z Paradyża | [ P ] employee

Scientific discipline (Law 2.0)

[2.3] Information and communication technology

Year of publication


Published in

Procedia Computer Science

Journal year: 2022 | Journal volume: 207

Article type

scientific article / paper

Publication language


  • SERM semantic data model; logical rules; database programming objects; rule functions

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




Presented on

26th International Conference on Knowledge-Based and Intelligent Information & Engineering Systems (KES 2022), 7-9.09.2022, VERONA, Włochy

License type

CC BY-NC-ND (attribution - noncommercial - no derivatives)

Open Access Mode

open journal

Open Access Text Version

final published version

Release date


Date of Open Access to the publication

at the time of publication

Ministry points / journal


Ministry points / conference (CORE)