Accession Number : ADA335348

Title :   Computer Support for Schema Integration

Descriptive Note : Technical note

Corporate Author : DEFENCE SCIENCE AND TECHNOLOGY ORGANISATION CANBERRA (AUSTRALIA)

Personal Author(s) : Ewald, C. A.

PDF Url : ADA335348

Report Date : SEP 1997

Pagination or Media Count : 16

Abstract : Currently, as part of an organization-wide move for greater interoperability and reduction of duplication, Defence is examining a number of existing information systems in order to make them work more closely together. Schema integration is the merging of different database design specifications which have commonality. In this report, we examine support for schema integration provided by commercial off the shelf (COTS) software products, in particular computer aided software engineering (CASE) tools, and suggest desirable features which current products do not support. We examine which of the two products tested provides cost-effective support for schema evolution. The two products chosen for examination are InfoModeler version 2 (chosen for its support of the rich object-role modelling methodology, and natural language interface) and ERwin Version 2.6.1 (the market leader both in Australia and the U.S.A.). It appears that no existing product provides a full schema merge capability, and this would not be expected, as schema integration needs to involve human creativity. However, some tasks within the integration process lend themselves to automation, and it is worthwhile examining tools to perform these tasks.

Descriptors :   *DATA BASES, *SOFTWARE ENGINEERING, *COMPUTER AIDED DESIGN, ALGORITHMS, DATA MANAGEMENT, COST EFFECTIVENESS, INTEROPERABILITY, OFF THE SHELF EQUIPMENT, COMPUTER PROGRAM VERIFICATION, DESIGN CRITERIA, AUSTRALIA, COMMONALITY.

Subject Categories : Computer Programming and Software

Distribution Statement : APPROVED FOR PUBLIC RELEASE