Global to push GA events into
skip to main content

Title: System and method for integrating and accessing multiple data sources within a data warehouse architecture

A system and method is disclosed for integrating and accessing multiple data sources within a data warehouse architecture. The metadata formed by the present method provide a way to declaratively present domain specific knowledge, obtained by analyzing data sources, in a consistent and useable way. Four types of information are represented by the metadata: abstract concepts, databases, transformations and mappings. A mediator generator automatically generates data management computer code based on the metadata. The resulting code defines a translation library and a mediator class. The translation library provides a data representation for domain specific knowledge represented in a data warehouse, including "get" and "set" methods for attributes that call transformation methods and derive a value of an attribute if it is missing. The mediator class defines methods that take "distinguished" high-level objects as input and traverse their data structures and enter information into the data warehouse.
Inventors:
 [1];  [2];  [3];  [2];  [4]
  1. Castro Valley, CA
  2. Livermore, CA
  3. San Jose, CA
  4. Brentwood, CA
Issue Date:
OSTI Identifier:
907739
Assignee:
The Regents of the University of California (Oakland, CA) LLNL
Patent Number(s):
7,152,070
Application Number:
09/479,432
Contract Number:
W-7405-ENG-48
Research Org:
Lawrence Livermore National Lab. (LLNL), Livermore, CA (United States)
Sponsoring Org:
USDOE
Country of Publication:
United States
Language:
English
Subject:
96 KNOWLEDGE MANAGEMENT AND PRESERVATION