1981Very Large Data BasesRequires access

Logical integration of locally independent relational databases into a distributed database

Katsumi Tanaka, Yahiko Kambayashi

Open publisher page 3 citations

Abstract

This paper discusses a constraint integration problem, which occurs in constructing a global view of a distributed database by local relational databases. Each local database has its own semantic constraints. such as functional, join and embedded join dependencies (FDs. JDs and EJDs, respectively). A global view of a distributed database is assumed to be defined by taking a join of these local databases. Some dependency constraints on a local database may be violated on a global view. In this paper, we show (a) the relationship between dependencies of local databases and dependencies appearing in a global view, (b) a testing method whether an EJD appears in a global view when only FDs and JDs are given to each local database, end (c) some conditions for a JD of a local database to appear in a global view as an EJD.

About this research paper

What this paper is about

This paper discusses a constraint integration problem, which occurs in constructing a global view of a distributed database by local relational databases. Each local database has its own semantic constraints. such as functional, join and embedded join dependencies (FDs. JDs and EJDs, respectively). A global view of a distributed database is assumed to be defined by taking a join of these local databases. Some dependency constraints on a local database may be violated on a global view. In this paper, we show (a) the relationship between dependencies of local databases and dependencies appearing in a global view, (b) a testing method whether an EJD appears in a global view when only FDs and JDs are given to each local database, end (c) some conditions for a JD of a local database to appear in a global view as an EJD.

Why it matters

OpenAlex reports 3 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

This paper discusses a constraint integration problem, which occurs in constructing a global view of a distributed database by local relational databases. Each local database has its own semantic constraints. such as functional, join and embedded join dependencies (FDs. JDs and EJDs, respectively). A global view of a distributed database is assumed to be defined by taking a join of these local databases. Some dependency constraints on a local database may be violated on a global view. In this paper, we show (a) the relationship between dependencies of local databases and dependencies appearing in a global view, (b) a testing method whether an EJD appears in a global view when only FDs and JDs are given to each local database, end (c) some conditions for a JD of a local database to appear in a global view as an EJD.

Key concepts: Database, Dependency theory (database theory), Database theory, Distributed database, Computer science, Relational database, Functional dependency, Join (topology)

Related papers

Back to paper searchBrowse research topicsOriginal source
Logical integration of locally independent relational databases into a distributed database — Research Paper | ScholarLens