Interactively Eliciting Database Constraints and Dependencies

Research output: Contribution in Book/Catalog/Report/Conference proceedingConference contribution

Abstract

When designing the conceptual schema of a future information system, it is crucial to define a set of constraints that will guarantee that once the subsequent database is implemented and operational, any changes made to its content by authorised users will maintain its consistency. Eliciting and expressing such constraints and dependencies is far from trivial, especially when end-users are involved and when there is no directly usable data to play with. In this paper, we present an interactive process aimed to elicit hidden constraints such as value domains, functional dependencies, attribute and role optionality and existence constraints. Inspired by the principles of Armstrong relations, it attempts to acquire minimal data samples in order to validate declared constraints, to elicit hidden constraints and to reject irrelevant constraints in conceptual schemas. This process is part of the RAINBOW approach, a collaborative interactive user-oriented approach to develop the data model of an information system based, among others, on the reverse engineering of user-drawn form-based interfaces.
Original languageEnglish
Title of host publicationProceedings of the 23rd International Conference on Advanced Information Systems Engineering (CAiSE'2011) - to appear
Publication statusUnpublished - 2011

Fingerprint

Information systems
Reverse engineering
Data structures

Keywords

  • Electronic forms Reverse Engineering
  • Database Engineering
  • Requirements Engineering
  • Constraint Discovery
  • Information Systems Engineering

Cite this

Ramdoyal, R., & Hainaut, J-L. (2011). Interactively Eliciting Database Constraints and Dependencies. Unpublished. In Proceedings of the 23rd International Conference on Advanced Information Systems Engineering (CAiSE'2011) - to appear
Ramdoyal, Ravi ; Hainaut, Jean-Luc. / Interactively Eliciting Database Constraints and Dependencies. Proceedings of the 23rd International Conference on Advanced Information Systems Engineering (CAiSE'2011) - to appear. 2011.
@inproceedings{bb9a4522ba3047d9b837790bef190a2b,
title = "Interactively Eliciting Database Constraints and Dependencies",
abstract = "When designing the conceptual schema of a future information system, it is crucial to define a set of constraints that will guarantee that once the subsequent database is implemented and operational, any changes made to its content by authorised users will maintain its consistency. Eliciting and expressing such constraints and dependencies is far from trivial, especially when end-users are involved and when there is no directly usable data to play with. In this paper, we present an interactive process aimed to elicit hidden constraints such as value domains, functional dependencies, attribute and role optionality and existence constraints. Inspired by the principles of Armstrong relations, it attempts to acquire minimal data samples in order to validate declared constraints, to elicit hidden constraints and to reject irrelevant constraints in conceptual schemas. This process is part of the RAINBOW approach, a collaborative interactive user-oriented approach to develop the data model of an information system based, among others, on the reverse engineering of user-drawn form-based interfaces.",
keywords = "Electronic forms Reverse Engineering, Database Engineering, Requirements Engineering, Constraint Discovery, Information Systems Engineering",
author = "Ravi Ramdoyal and Jean-Luc Hainaut",
year = "2011",
language = "English",
booktitle = "Proceedings of the 23rd International Conference on Advanced Information Systems Engineering (CAiSE'2011) - to appear",

}

Ramdoyal, R & Hainaut, J-L 2011, Interactively Eliciting Database Constraints and Dependencies. in Proceedings of the 23rd International Conference on Advanced Information Systems Engineering (CAiSE'2011) - to appear.

Interactively Eliciting Database Constraints and Dependencies. / Ramdoyal, Ravi; Hainaut, Jean-Luc.

Proceedings of the 23rd International Conference on Advanced Information Systems Engineering (CAiSE'2011) - to appear. 2011.

Research output: Contribution in Book/Catalog/Report/Conference proceedingConference contribution

TY - GEN

T1 - Interactively Eliciting Database Constraints and Dependencies

AU - Ramdoyal, Ravi

AU - Hainaut, Jean-Luc

PY - 2011

Y1 - 2011

N2 - When designing the conceptual schema of a future information system, it is crucial to define a set of constraints that will guarantee that once the subsequent database is implemented and operational, any changes made to its content by authorised users will maintain its consistency. Eliciting and expressing such constraints and dependencies is far from trivial, especially when end-users are involved and when there is no directly usable data to play with. In this paper, we present an interactive process aimed to elicit hidden constraints such as value domains, functional dependencies, attribute and role optionality and existence constraints. Inspired by the principles of Armstrong relations, it attempts to acquire minimal data samples in order to validate declared constraints, to elicit hidden constraints and to reject irrelevant constraints in conceptual schemas. This process is part of the RAINBOW approach, a collaborative interactive user-oriented approach to develop the data model of an information system based, among others, on the reverse engineering of user-drawn form-based interfaces.

AB - When designing the conceptual schema of a future information system, it is crucial to define a set of constraints that will guarantee that once the subsequent database is implemented and operational, any changes made to its content by authorised users will maintain its consistency. Eliciting and expressing such constraints and dependencies is far from trivial, especially when end-users are involved and when there is no directly usable data to play with. In this paper, we present an interactive process aimed to elicit hidden constraints such as value domains, functional dependencies, attribute and role optionality and existence constraints. Inspired by the principles of Armstrong relations, it attempts to acquire minimal data samples in order to validate declared constraints, to elicit hidden constraints and to reject irrelevant constraints in conceptual schemas. This process is part of the RAINBOW approach, a collaborative interactive user-oriented approach to develop the data model of an information system based, among others, on the reverse engineering of user-drawn form-based interfaces.

KW - Electronic forms Reverse Engineering

KW - Database Engineering

KW - Requirements Engineering

KW - Constraint Discovery

KW - Information Systems Engineering

M3 - Conference contribution

BT - Proceedings of the 23rd International Conference on Advanced Information Systems Engineering (CAiSE'2011) - to appear

ER -

Ramdoyal R, Hainaut J-L. Interactively Eliciting Database Constraints and Dependencies. In Proceedings of the 23rd International Conference on Advanced Information Systems Engineering (CAiSE'2011) - to appear. 2011