Interactively Eliciting Database Constraints and Dependencies

Résultats de recherche: Contribution dans un livre/un catalogue/un rapport/dans les actes d'une conférenceArticle dans les actes d'une conférence/un colloque

Résumé

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.
langue originaleAnglais
titreProceedings of the 23rd International Conference on Advanced Information Systems Engineering (CAiSE'2011) - to appear
Etat de la publicationNon publié - 2011

Empreinte digitale Examiner les sujets de recherche de « Interactively Eliciting Database Constraints and Dependencies ». Ensemble, ils forment une empreinte digitale unique.

  • Contient cette citation

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