2023

Procedia Computer Science

Rocznik: 2023 | Tom: 225

artykuł naukowy / referat

angielski

EN The SERM (Structured Entity Relationship Diagram) data model is an extension of the classic ER (Entity Relationship) model. Its transparent, hierarchical structure allows you to control and analyze the order in which information resources are entered into the database. Assuming attention to referential integrity, it has a significant impact on the verification of relationship complexity. Uncertainty in the identification of obligatory relations, confirmed by numerous corrections, demonstrates the need to develop an approach to support this task. The aim of this article is to present a solution in the form of a framework based on the SERM model. Its main aspects are optimization of the identification of obligatory relations and automatic handling of their protections. The proposed solution supports intelligent design of relational databases beyond conceptual design. It extends the scope to the design of database programming objects, such as procedures that generate triggers to handle obligatory relationships. This is an important aspect for securing database integrity.

1757 - 1766

10.1016/j.procs.2023.10.165

https://www.sciencedirect.com/science/article/pii/S1877050923013236?via%3Dihub

27th International Conference on Knowledge-Based and Intelligent Information & Engineering Systems (KES 2023), 6-9.09.2023, Athens, Grecja

CC BY-NC-ND (uznanie autorstwa - użycie niekomercyjne - bez utworów zależnych)

otwarte czasopismo

ostateczna wersja opublikowana

12.2023

w momencie opublikowania

5

70