Concepts and evaluation of the extended entity-relationship approach to database design in a multi-paradigm information system modeling tool

Dimitrieski, Vladimir; Čeliković, Milan; Aleksic, Slavica; Ristić, Sonja; Alargt, Abdalla; Luković, Ivan

doi:10.1016/j.cl.2015.08.011

Cited by 15 publications

(16 citation statements)

References 38 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…The 'any relevant rules are executed' is coordinated by the metamodel; e.g., the metamodel states that each Relationship has to have two or more Roles, which, in turn, have to have attached to it either an Object Type or Value Type, so those mapping and transformation rules are called as well during the checking of the link. The MIST EER tool [97] has a similar goal, though currently it supports only EER and its translation to SQL and therewith is complementary to our work presented here.…”

Section: Discussionmentioning

confidence: 99%

Evidence-Based Languages for Conceptual Data Modelling Profiles

Fillottrani

Keet

2015

Advances in Databases and Information Systems

View full text Add to dashboard Cite

Multiple logic-based reconstruction of conceptual data modelling languages such as EER, UML Class Diagrams, and ORM exists. They mainly cover various fragments of the languages and none are formalised such that the logic applies simultaneously for all three modelling language families as unifying mechanism. This hampers interchangeability, interoperability, and tooling support. In addition, due to the lack of a systematic design process of the logic used for the formalisation, hidden choices permeate the formalisations that have rendered them incompatible.We aim to address these problems, first, by structuring the logic design process in a methodological way. We generalise and extend the DSL design process to apply to logic language design more generally and, in particular, by incorporating an ontological analysis of language features in the process. Second, availing of this extended process, of evidence gathered of language feature usage, and of computational complexity insights from Description Logics (DL), we specify logic profiles taking into account the ontological commitments embedded in the languages. The profiles characterise the minimum logic structure needed to handle the semantics of conceptual models, enabling the development of interoperability tools. There is no known DL language that matches exactly the features of those profiles and the common core is small (in the tractable ALN I). Although hardly any inconsistencies can be derived with the profiles, it is promising for scalable runtime use of conceptual data models.

show abstract

Section: Discussionmentioning

confidence: 99%

Evidence-Based Languages for Conceptual Data Modelling Profiles

Fillottrani

Keet

2015

Advances in Databases and Information Systems

View full text Add to dashboard Cite

show abstract

“…Similar to AGM, PIM is targeted at information systems, and its approach is also generative but uses a pre-generated application interface and database. Dimitrieski et al [30] also took a generative approach in their Multi-Paradigm Information System Modeling Tool (MIST) for building information systems through the simultaneous use of three different approaches.…”

Section: Related Workmentioning

confidence: 99%

Run-time interpretation of information system application models in mobile cloud environments

Tanković

Grbac

2020

COMSIS J

View full text Add to dashboard Cite

Application models are commonly used in the development of information systems. Recent trends have introduced techniques by which models can be directly transformed into execution code and thus become a single source for application design. Inherently, it has been challenging for software developers to become proficient in designing entire systems due to the complex chain of model transformations and the further refinements required to the code generated from the models. We propose an architectural framework for building the distributed information system applications in which the application models are directly interpreted during execution. This approach shortens the evaluation cycles and provides faster feedback to developers. Our framework is based on a holistic application model represented as a graph structure complemented with a procedural action scripting language that can express more complex software behavior. We present the implementation details of this framework architecture in a mobile cloud environment and evaluate its benefits in eleven projects for different customers in the retail, supply-chain management and merchandising domain involving 300 active application users. Our approach allowed engaging end-users in the software development process in the phase of specifying executable application models. It succeeded in shortening the requirements engineering process and automating the configuration and deployment process. Moreover, it benefited from the automatic synchronization of application updates for all active versions at the customer sites.

show abstract

“…There are also approaches for transformation of the Extended ER models (EER), e.g. [5]. However, the traditional approaches neglect checking certain constraints.…”

Section: Related Workmentioning

confidence: 99%

Towards ontoUML for software engineering: Transformation of kinds and subkinds into relational databases

Rybola

Pergl

2017

COMSIS J

View full text Add to dashboard Cite

OntoUML is an ontologically well-founded conceptual modelling language that distinguishes various types of classifiers and relations providing precise meaning to the modelled entities. While Model-Driven Development is a wellestablished approach, OntoUML has been overlooked so far as a conceptual modelling language for the PIM of application data. This paper is an extension of the paper presented at MDASD 2016, where we outlined the transformation of Rigid Sortal Types-Kinds and Subkinds. In this paper, we discuss the details of various variants of the transformation of these types and the rigid generalization sets. The result of our effort is a complete method for preserving high-level ontological constraints during the transformations, specifically special multiplicities and generalization set meta-properties in a relational database using views, CHECK constraints and triggers.

show abstract

Concepts and evaluation of the extended entity-relationship approach to database design in a multi-paradigm information system modeling tool

Cited by 15 publications

References 38 publications

Evidence-Based Languages for Conceptual Data Modelling Profiles

Evidence-Based Languages for Conceptual Data Modelling Profiles

Run-time interpretation of information system application models in mobile cloud environments

Towards ontoUML for software engineering: Transformation of kinds and subkinds into relational databases

Contact Info

Product

Resources

About