skip to main content
OSTI.GOV title logo U.S. Department of Energy
Office of Scientific and Technical Information

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

Abstract

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
Publication Date:
Research Org.:
Lawrence Livermore National Lab. (LLNL), Livermore, CA (United States)
Sponsoring Org.:
USDOE
OSTI Identifier:
907739
Patent Number(s):
7,152,070
Application Number:
09/479,432
Assignee:
The Regents of the University of California (Oakland, CA) LLNL
DOE Contract Number:  
W-7405-ENG-48
Resource Type:
Patent
Country of Publication:
United States
Language:
English
Subject:
96 KNOWLEDGE MANAGEMENT AND PRESERVATION

Citation Formats

Musick, Charles R, Critchlow, Terence, Ganesh, Madhaven, Slezak, Tom, and Fidelis, Krzysztof. System and method for integrating and accessing multiple data sources within a data warehouse architecture. United States: N. p., 2006. Web.
Musick, Charles R, Critchlow, Terence, Ganesh, Madhaven, Slezak, Tom, & Fidelis, Krzysztof. System and method for integrating and accessing multiple data sources within a data warehouse architecture. United States.
Musick, Charles R, Critchlow, Terence, Ganesh, Madhaven, Slezak, Tom, and Fidelis, Krzysztof. Tue . "System and method for integrating and accessing multiple data sources within a data warehouse architecture". United States. doi:. https://www.osti.gov/servlets/purl/907739.
@article{osti_907739,
title = {System and method for integrating and accessing multiple data sources within a data warehouse architecture},
author = {Musick, Charles R and Critchlow, Terence and Ganesh, Madhaven and Slezak, Tom and Fidelis, Krzysztof},
abstractNote = {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.},
doi = {},
journal = {},
number = ,
volume = ,
place = {United States},
year = {Tue Dec 19 00:00:00 EST 2006},
month = {Tue Dec 19 00:00:00 EST 2006}
}

Patent:

Save / Share: