Original scientific paper

RESOLVING DATABASE CONSTRAINT COLLISIONS USING IIS*CASE TOOL

Sonja Ristić ; Faculty of Technical Sciences University of Novi Sad, Novi Sad, Serbia
Ivan Luković ; Faculty of Technical Sciences University of Novi Sad, Novi Sad, Serbia
Jelena Pavičević ; Faculty of Science University of Montenegro, Montenegro
Pavle Mogin ; School of Mathematical and Computing Sciences Victoria University of Wellington, New Zealand

Abstract

Integrated Information Systems*Case (IIS*Case) R.6.21 is a CASE tool that we developed to support automated database (db) schema design, based on a methodology of gradual integration of independently designed subschemas into a database schema. It provides complete intelligent support for developing db schemas and enables designers to work together and cooperate reaching the most appropriate solutions. The process of independent design of subschemas may lead to collisions in expressing the real world constraints and business rules. IIS*Case uses specialized algorithms for checking the consistency of constraints embedded in the database schema and the subschemas. IIS*Case supports designers in reviewing and validating results obtained after each step of the design process. The paper outlines the process of resolving collisions. A case study based on an imaginary production system is used to illustrate the application of IIS*Case. Different outcomes and their consequences are presented.

Keywords

database schema design and integration; CASE tool; constraint collisions; IIS*Case

Hrčak ID:

21485

URI

https://hrcak.srce.hr/21485

Publication date:

12.6.2007.

Visits: 1.333 *