Discovering and using entity mappings in federated databases

Dearnley, P. A. and Smith, D. J. (1999) Discovering and using entity mappings in federated databases. Software: Practice and Experience, 29 (1). pp. 17-42. ISSN 1097-024X

Full text not available from this repository. (Request a copy)

Abstract

In the context of a federated database containing similar information in local component databases, we consider the problem of discovering the different local representations which database designers might use to map the same entity. An extension of the normal SQL system catalog to hold additional domain metadata is discussed. This enables common local mappings to be discovered and allows SQL retrieval queries expressed in terms of the logical federated schema to be transformed to match the appropriate local database schema. The result is a practical means of coping with differing mappings in federated databases without having to resort to special higher order languages or a layer of information mediation middleware.

Item Type:	Article
Faculty \ School:	Faculty of Science > School of Computing Sciences
UEA Research Groups:	Faculty of Science > Research Groups > Smart Emerging Technologies (former - to 2025)
Depositing User:	EPrints Services
Date Deposited:	01 Oct 2010 13:42
Last Modified:	28 Mar 2025 04:59
URI:	https://ueaeprints.uea.ac.uk/id/eprint/3208
DOI:	10.1002/(SICI)1097-024X(199901)29:1<17::AID-SPE219>3.0.CO;2-Q

Actions (login required)

View Item