About the journal

• Home page
• Contact information
• Aims and scope
• Indexing information
• Editorial policies
• ComSIS consortium
• Journal boards
• Managing board

For authors

• Information for contributors
• Paper submission
• Article submission through OJS
• Copyright transfer form
• Download section

For readers

• Forthcoming articles
• Current issue
• Archive

For reviewers

• View and review submissions

News

• Journal's Facebook page
• Calls for special issues
• New issue notification

Automatic Conceptual Database Design based on Heterogeneous Source Artifacts

Goran Banjac¹, Drazen Brdjanin¹ and Danijela Banjac¹

1. Faculty of Electrical Engineering, University of Banja Luka
   Patre 5, 78000 Banja Luka, Bosnia and Herzegovina
   {goran.banjac,drazen.brdjanin,danijela.banjac}@etf.unibl.org

Abstract

The article presents an approach to the automatic derivation of conceptual database models from heterogeneous source artifacts. The approach is based on the integration of conceptual database models that are derived from source artifacts of one single type by already existing tools, whereby those models possess limited certainty given their limited completeness and correctness. The uncertainty of the automatically derived models from specific source artifacts is expressed and managed through the effectiveness measure of the generation of specific concepts of the input conceptual database models. The approach is implemented by the DBomnia tool – the first online web-based tool enabling automatic derivation of conceptual database models from heterogeneous source artifacts (business process models and textual specifications). DBomnia employs other pre-existing tools to derive conceptual models from sources of the same type and then integrates those models. The case study-based evaluation proves that the implemented approach enables effective automatic derivation of the conceptual database model from a set of heterogeneous source artifacts. Moreover, the automatic derivation of the conceptual database model from a set of heterogeneous source artifacts is more effective than each independent automatic derivation of the conceptual database model from sources of one single type only.

Key words

AMADEOS, DBomnia, Schema integration, Schema matching, Schema merging, TexToData, UML class diagram, Uncertain schema

Digital Object Identifier (DOI)

https://doi.org/10.2298/CSIS240229065B

Publication information

Volume 21, Issue 4 (September 2024)
Year of Publication: 2024
ISSN: 2406-1018 (Online)
Publisher: ComSIS Consortium

Full text

Available in PDF
Portable Document Format

How to cite

Banjac, G., Brdjanin, D., Banjac, D.: Automatic Conceptual Database Design based on Heterogeneous Source Artifacts. Computer Science and Information Systems, Vol. 21, No. 4, 1913–1961. (2024), https://doi.org/10.2298/CSIS240229065B