Title: Database interoperability through state-based logical data independence

Authors: Michael Johnson, Robert Rosebrugh

Addresses: Department of Computing, Macquarie University, Sydney, Australia. Department of Computer Science, Mount Allison University, NB, Canada

Abstract: Computer supported cooperative work (CSCW) involving business-to-business transactions depends more and more upon database interoperability. The design of interbusiness CSCW when the businesses are already operating independent systems depends either upon effective reverse engineering (to properly discover the semantics underlying each organisation|s systems and through that to develop appropriate matches for interbusiness software), or upon sufficiently rich semantic models and good database management system support for logical data independence (to allow database updating through a logical view). This paper takes the second approach, presenting a rich semantic data model that the authors have been developing and have used successfully in a number of major consultancies, and a new approach to logical data independence and view up datability based on that model. We show how these approaches support database interoperability for business-to-business transactions and, for CSCW within an organisation, how they support federated databases.

Keywords: logical data independence; category theory; semantic data modelling.

DOI: 10.1504/IJCAT.2003.000316

International Journal of Computer Applications in Technology, 2003 Vol.16 No.2/3, pp.97-102

Published online: 16 Jul 2003 *

Full-text access for editors Access for subscribers Purchase this article Comment on this article