Implementation of Federated Databases Through Updatable Views

Much work has been done in the area of data access and integration using various data mapping, matching, and loading techniques. One of the main concerns when integrating data from heterogeneous data sources is data redundancy. The concern is mainly due to the different business contexts and purposes from which the data systems were originally built. A common process for accessing data from integrated databases involves the use of each data source’s own catalogue or metadata schema. In this article, the authors take the view that there is a greater chance of data inconsistencies, such as data redundancies when integrating them within a grid environment as compared to traditional distributed paradigms. The importance of improving the data search and matching process is briefly discussed, and a partial service oriented generic strategy is adopted to consolidate distinct catalogue schemas of federated databases to access information seamlessly. To this end, a proposed matching strategy between structure objects and data values across federated databases in a grid environment is presented.

Download Full-text

The Federated Databases and System: A New Generation of Advanced Database Systems

Database and Expert Systems Applications ◽

10.1007/978-3-7091-7553-8_30 ◽

1990 ◽

pp. 186-190 ◽

Cited By ~ 2

Author(s):

David K. Hsiao ◽

Magdi N. Kamel ◽

C. Thomas Wu

Keyword(s):

Database Systems ◽

Federated Databases ◽

System A ◽

New Generation

Download Full-text

Managing Inconsistencies in Data Grid Environments

International Journal of Grid and High Performance Computing ◽

10.4018/jghpc.2010100105 ◽

2010 ◽

Vol 2 (4) ◽

pp. 51-64 ◽

Cited By ~ 2

Author(s):

Ejaz Ahmed ◽

Nik Bessis ◽

Peter Norrington ◽

Yong Yue

Keyword(s):

Data Access ◽

Heterogeneous Data ◽

Data Mapping ◽

Data Systems ◽

Grid Environment ◽

Federated Databases ◽

Matching Process ◽

Generic Strategy ◽

Service Oriented ◽

Matching Strategy

Much work has been done in the area of data access and integration using various data mapping, matching, and loading techniques. One of the main concerns when integrating data from heterogeneous data sources is data redundancy. The concern is mainly due to the different business contexts and purposes from which the data systems were originally built. A common process for accessing data from integrated databases involves the use of each data source’s own catalogue or metadata schema. In this article, the authors take the view that there is a greater chance of data inconsistencies, such as data redundancies when integrating them within a grid environment as compared to traditional distributed paradigms. The importance of improving the data search and matching process is briefly discussed, and a partial service oriented generic strategy is adopted to consolidate distinct catalogue schemas of federated databases to access information seamlessly. To this end, a proposed matching strategy between structure objects and data values across federated databases in a grid environment is presented.

Download Full-text

Managing Inconsistent Databases Using Active Integrity Constraints

Encyclopedia of Database Technologies and Applications ◽

10.4018/978-1-59140-560-3.ch059 ◽

2005 ◽

pp. 345-350

Author(s):

Sergio Flesca ◽

Sergio Greco ◽

Ester Zumpano

Keyword(s):

Data Warehousing ◽

Integrity Constraints ◽

Database Integration ◽

Functional Dependencies ◽

Minimal Set ◽

Federated Databases ◽

Inconsistent Databases ◽

Conflicting Information ◽

Integration Data ◽

Inconsistent Database

Integrity constraints are a fundamental part of a database schema. They are generally used to define constraints on data (functional dependencies, inclusion dependencies, exclusion dependencies, etc.), and their enforcement ensures a semantically correct state of a database. As the presence of data inconsistent with respect to integrity constraints is not unusual, its management plays a key role in all the areas in which duplicate or conflicting information is likely to occur, such as database integration, data warehousing, and federated databases (Bry, 1997; Lin, 1996; Subrahmanian, 1994). It is well known that the presence of inconsistent data can be managed by “repairing” the database, that is, by providing consistent databases, obtained by a minimal set of update operations on the inconsistent original environment, or by consistently answering queries posed over the inconsistent database.

Download Full-text