Mermaid—A front-end to distributed heterogeneous databases

Templeton, Marjorie; Brill, David; Dao, Son; Lund, E.; Ward, Paul; Chen, A.L.P.; MacGregor, Robert M.

doi:10.1109/proc.1987.13782

Cited by 108 publications

(16 citation statements)

References 8 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Integration of relational databases also is the goal of the MERMAID system (Templeton, 1987). Their approach is still mainly manual, although the DBA is somehow assisted by the system.…”

Section: Manual Integration Methodologiesmentioning

confidence: 99%

“…As it deals with existing databases, database integration may be limited to support mainly modeling concepts from current DBMSs. However, in order to ensure proper understanding of the semantics of the input schemas, additional information has to be provided by the DBA (Data Base Administrator) before integration is performed (Biskup, 1986;Templeton, 1987;Siegel, 1989). Finally, existence of extensions and programs is the most important peculiarity of database integration versus view integration.…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Model independent assertions for integration of heterogeneous schemas

1992

View full text Add to dashboard Cite

Abstract. Due to the proliferation of database applications, the integration of existing databases into a distributed or federated system is one of the major challenges in responding to enterprises' information requirements. Some proposed integration techniques aim at providing database administrators (DBAs) with a view definition language they can use to build the desired integrated schema. These techniques leave to the DBA the responsibility of appropriately restructuring schema elements from existing local schemas and of solving inter-schema conflicts.This paper investigates the assertion-based approach, in which the DB~s action is limited to pointing out corresponding elements in the schemas and to defining the nature of the correspondence in between. This methodology is capable of: ensuring better integration by taking into account additional semantic information (assertions about links); automatically solving structural conflicts; building the integrated schema without requiring conforming of initial schemas; applying integration rules to a variety of data models; and performing view as well as database integration. This paper presents the basic ideas underlying our approach and focuses on resolution of structural conflicts.

show abstract

“…Integration of relational databases also is the goal of the MERMAID system (Templeton, 1987). Their approach is still mainly manual, although the DBA is somehow assisted by the system.…”

Section: Manual Integration Methodologiesmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

Model independent assertions for integration of heterogeneous schemas

1992

View full text Add to dashboard Cite

show abstract

“…This approach toward semantic interoperability is unlike most traditional integration strategies which either require users to engage in the detection and reconciliation of conflicts (in the case of loosely coupled systems, e.g., MRDSM [Litwin and Abdellatif 1987], VIP-MDBMS [ Kuhn and Ludwig 1988]), or insist that conflicts should be identified and reconciled, a priori, by some system administrator, in one or more shared schemas (as in tightly coupled systems, e.g., Multibase [Landers and Rosenberg 1982] and Mermaid [Templeton et al 1987]). In addition, the proposed framework plays a complementary role to an emerging class of integration strategies [Levy et al 1995b;Ullman 1997] where queries are formulated on an "ontology" without specifying a priori what information sources are relevant for the query.…”

Section: Introductionmentioning

confidence: 99%

Context interchange

Goh

Bressan

Madnick

et al. 1999

ACM Trans. Inf. Syst.

215

119

View full text Add to dashboard Cite

The Context Interchange strategy presents a novel perspective for mediated data access in which semantic conflicts among heterogeneous systems are not identified a priori, but are detected and reconciled by a context mediator through comparison of contexts axioms corresponding to the systems engaged in data exchange. In this article, we show that queries formulated on shared views, export schema, and shared "ontologies" can be mediated in the same way using the Context Interchange framework. The proposed framework provides a logic-based object-oriented formalism for representing and reasoning about data semantics in disparate systems, and has been validated in a prototype implementation providing mediated data access to both traditional and web-based information sources. We dedicate this work to the memory of Cheng Hian Goh (1965Goh ( -1999.

show abstract

“…Various aspects of federated databases have been researched and reported in the database literature [Smith et al, 1981;Lander & Rosenberg, 1982;Heimbigner & McLeod, 1985;Litwin & Abdellatif, 1986;Deen et al, 1987;Templeton et al, 1987;Reddy et al, 1989;Wang & Madnick, 1989;Rajinikanth, 1990;Sheth & Larson, 1990;Pu, 1988;Sheth, 1991]. In particular, significant research has been conducted to develop mechanisms for mapping between a federated schema and its corresponding export schemata and for the retrieval and integration of data from the component databases.…”

Section: Introductionmentioning

confidence: 99%

Estimating data accuracy in a federated database environment

Reddy¹,

Wang²

1995

Lecture Notes in Computer Science

View full text Add to dashboard Cite

Abstract:The need for integration of data in a heterogeneous or federated database environment creates a corresponding need for estimating the accuracy of the integrated data as a function of the accuracy of the originating data sources. Even in a single database system, different base relations are frequently characterized by dissimilar levels of accuracy; however, no technique exists for defining the accuracy of this single database system in terms of the accuracy of the base relations. This need is further heightened in the case of federated environments involving multiple heterogeneous databases. To address this need, a generalized method is proposed for estimating the overall data accuracy in terms of the accuracy of relevant base relations and the actual database query. The query is examined in terms of its underlying set of base operators. A rigorous theoretical framework encompassing all these possible base operators is presented in this paper using the relational model. While the accuracy estimates are postulated on the basis of uniform distribution, the implications of nonuniform error distributions are also examined in theoretical terms. Finally, a running example is utilized to highlight the practical implications of the proposed theoretical framework.

show abstract

Mermaid—A front-end to distributed heterogeneous databases

Cited by 108 publications

References 8 publications

Model independent assertions for integration of heterogeneous schemas

Model independent assertions for integration of heterogeneous schemas

Context interchange

Estimating data accuracy in a federated database environment

Contact Info

Product

Resources

About