New methods and fast algorithms for database normalization
ACM Transactions on Database Systems (TODS)
Computational problems related to the design of normal form relational schemas
ACM Transactions on Database Systems (TODS)
Integrating relational database schemas using a standardized dictionary
Proceedings of the 2001 ACM symposium on Applied computing
Foundation for Future Database Systems: The Third Manifesto
Foundation for Future Database Systems: The Third Manifesto
Relational Database: Writings, 1989-1991
Relational Database: Writings, 1989-1991
A new characterization of independence
SIGMOD '83 Proceedings of the 1983 ACM SIGMOD international conference on Management of data
An Expert Database Design System Based on Analysis of Forms
IEEE Transactions on Software Engineering
Interactive Specification and Integration of User Views Using Forms
Proceedings of the Eight International Conference on Enity-Relationship Approach to Database Design and Querying
A survey of approaches to automatic schema matching
The VLDB Journal — The International Journal on Very Large Data Bases
Proceedings of the 1st ACM International Health Informatics Symposium
Automatically mapping and integrating multiple data entry forms into a database
ER'11 Proceedings of the 30th international conference on Conceptual modeling
Some New Approaches in Functional Programming Using Algebras and Coalgebras
Electronic Notes in Theoretical Computer Science (ENTCS)
An approach to the specification of user interface templates for business applications
Proceedings of the Fifth Balkan Conference in Informatics
Meta-modeling of inclusion dependency constraints
Proceedings of the 6th Balkan Conference in Informatics
| Hi-index | 0.01 |
In this paper we consider an approach to developing complex database schemas. Apart from the theoretical model of the approach, we also developed a CASE tool named Integrated Information Systems*Case, R.6.2 (IIS*Case) that supports the practical application of the approach. In this paper the basis of our approach to the design and integration of database schemas and ways of using IIS*Case is outlined. The main features of a new version of IIS*Case, developed in Java, are described. IIS*Case is based on the concept of ‘form type’ and supports the conceptual modelling of a database schema, generating subschemas and integrating them into a relational database schema in 3NF. IIS*Case provides an intelligent support for complex and highly formalized design and programming tasks. Having an advanced knowledge of information systems and database design is not a compulsory prerequisite for using IIS*Case. IIS*Case is based on a methodology of gradual integration of independently designed subschemas into a database schema. The process of independent subschema design may lead to collisions in expressing real-world constraints. IIS*Case uses specialized algorithms for checking the consistency of constraints embedded in a database schema and its subschemas. This paper briefly outlines the application of the process of detecting collisions, and actions the designer may take to resolve them. Copyright © 2007 John Wiley & Sons, Ltd.