Flexible relation: an approach for integrating data from multiple, possibly inconsistent databases
- 19 November 2002
- proceedings article
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- Vol. 2, 495-504
- https://doi.org/10.1109/icde.1995.380364
Abstract
In this work we address the problem of dealing with data inconsistencies while integrating data sets derived from multiple autonomous relational databases. The fundamental assumption in the classical relational model is that data is consistent and hence no support is provided for dealing with inconsistent data. Due to this limitation of the classical relational model, the semantics for detecting, representing, and manipulating inconsistent data have to be explicitly encoded in the applications by the application developer. In this paper, we propose the flexible relational model, which extends the classical relational model by providing support for inconsistent data. We present a flexible relation algebra, which provides semantics for database operations in the presence of potentially inconsistent data. Finally, we discuss issues raised for query optimization when the data may be inconsistent.Keywords
This publication has 14 references indexed in Scilit:
- Integrating Relational Databases With Support For UpdatesPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2005
- Transaction atomicity in the presence of network partitionsPublished by Institute of Electrical and Electronics Engineers (IEEE) ,2003
- A taxonomy and current issues in multidatabase systemsComputer, 1992
- Data manipulation in heterogeneous databasesACM SIGMOD Record, 1991
- Interoperability of multiple autonomous databasesACM Computing Surveys, 1990
- MSQL: A multidatabase languageInformation Sciences, 1989
- Resolving database incompatibility: an approach to performing relational operations over mismatched domainsIEEE Transactions on Knowledge and Data Engineering, 1989
- On the Use of an Extended Relational Model to Handle Changing Incomplete InformationIEEE Transactions on Software Engineering, 1985
- Concurrency Control in Distributed Database SystemsACM Computing Surveys, 1981
- Extending the database relational model to capture more meaningACM Transactions on Database Systems, 1979