Generic and Standard Database Constraint Meta-Models

Sonja Ristic1, Slavica Aleksic2, Milan Celikovic2 and Ivan Lukovic2

  1. University of Novi Sad, Faculty of Technical Sciences, Department for Industrial Engineering and Management
    Trg Dositeja Obradovica 6, 21000 Novi Sad, Serbia
    sdristic@uns.ac.rs
  2. University of Novi Sad, Faculty of Technical Sciences, Department of Computing and Control
    Trg Dositeja Obradovica 6, 21000 Novi Sad, Serbia
    {slavica, ivan, milancel}@uns.ac.rs

Abstract

Many software engineering activities entail dealing with legacy information systems. When these systems become too costly to maintain, or when new technologies need to be incorporated, they need to be replaced or somehow reengineered. This can be done with significantly reduced amount of effort and cost if the conceptual models of these systems are available. Reverse engineering is the process of analyzing a subject system to create representations of the system at a higher level of abstraction. Relational databases are a common source of reverse engineering. Starting from a physical database schema, that is recorded into relational database schema data repository, the conceptual database schema or logical database schema could be extracted. The extraction process may be seen as a chain of model-to-model transformations that trace model elements from a model at the lower level of abstraction to a model at the higher level of abstraction, achieved through meta-modeling. In the paper we present generic and standard database constraint meta-models, focusing on multi-relational database constraints captured in a legacy database. These meta-models are aimed at support of model transformations to create conceptual models, as a useful source for the system reengineering process.

Key words

Model-driven Software Engineering, Meta-modeling, Inclusion Dependency, Database Reengineering

Digital Object Identifier (DOI)

https://doi.org/10.2298/CSIS140216037R

Publication information

Volume 11, Issue 2 (June 2014)
Year of Publication: 2014
ISSN: 2406-1018 (Online)
Publisher: ComSIS Consortium

Full text

DownloadAvailable in PDF
Portable Document Format

How to cite

Ristic, S., Aleksic, S., Celikovic, M., Lukovic, I.: Generic and Standard Database Constraint Meta-Models. Computer Science and Information Systems, Vol. 11, No. 2, 679–696. (2014), https://doi.org/10.2298/CSIS140216037R