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:
-
- Castro Valley, CA
- Livermore, CA
- San Jose, CA
- Brentwood, CA
- Issue Date:
- Research Org.:
- Lawrence Livermore National Laboratory (LLNL), Livermore, CA (United States)
- Sponsoring Org.:
- USDOE
- OSTI Identifier:
- 907739
- Patent Number(s):
- 7152070
- Application Number:
- 09/479,432
- Assignee:
- The Regents of the University of California (Oakland, CA)
- Patent Classifications (CPCs):
-
G - PHYSICS G06 - COMPUTING G06F - ELECTRIC DIGITAL DATA PROCESSING
Y - NEW / CROSS SECTIONAL TECHNOLOGIES Y10 - TECHNICAL SUBJECTS COVERED BY FORMER USPC Y10S - TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- 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. 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}
}