Metadata based mediator generation
- LLNL
Mediators are a critical component of any data warehouse, particularly one utilizing partially materialized views; they transform data from its source format 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. This maintenance may be a significant undertaking if a warehouse integrates several dynamic data sources. However, failure to quickly perform these updates significantly reduces the reliability of the warehouse because queries do not have access to the m current data. This may result in incorrect or misleading responses, and reduce user confidence in the warehouse. This paper describes a metadata framework, and associated software designed to automate a significant portion of the mediator generation task and thereby reduce the effort involved in adapting the 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 Laboratory, Livermore, CA
- Sponsoring Organization:
- USDOE Office of Defense Programs (DP)
- DOE Contract Number:
- W-7405-ENG-48
- OSTI ID:
- 2393
- Report Number(s):
- UCRL-JC-130234; LDRD Funding; ON: DE00002393
- Country of Publication:
- United States
- Language:
- English
Similar Records
Automatic generation of warehouse mediators using an ontology engine
Automatic generation of warehouse mediators using an ontology engine