Meta-data based mediator generation
Mediators are a critical component of any data warehouse; they transform data from source formats to the warehouse representation while resolving semantic and syntactic conflicts. The close relationship between mediators and databases requires a mediator to be updated whenever an associated schema is modified. Failure to quickly perform these updates significantly reduces the reliability of the warehouse because queries do not have access to the most current data. This may result in incorrect or misleading responses, and reduce user confidence in the warehouse. Unfortunately, this maintenance may be a significant undertaking if a warehouse integrates several dynamic data sources. This paper describes a meta-data framework, and associated software, designed to automate a significant portion of the mediator generation task and thereby reduce the effort involved in adapting to schema changes. By allowing the DBA to concentrate on identifying the modifications at a high level, instead of reprogramming the mediator, turnaround time is reduced and warehouse reliability is improved.
- Research Organization:
- Lawrence Livermore National Lab. (LLNL), Livermore, CA (United States)
- Sponsoring Organization:
- USDOE Office of Defense Programs (DP)
- DOE Contract Number:
- W-7405-Eng-48
- OSTI ID:
- 2390
- Report Number(s):
- UCRL-JC-130234-REV-1; R&D Project: YN0100000; LDRD Funding; ON: DE00002390
- Resource Relation:
- Conference: 3rd International Foundation on Cooperative Information Systems (CoopIS '98), New York, NY, August 20-22, 1998
- Country of Publication:
- United States
- Language:
- English
Similar Records
Challenges in Microbial Database Interoperability Interagency Microbe Project Working Group
Automatic generation of warehouse mediators using an ontology engine