Skip to Content
Find More Like This
Return to Search

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

United States Patent

December 19, 2006
View the Complete Patent at the US Patent & Trademark Office
Lawrence Livermore National Laboratory - Visit the Industrial Partnerships Office Website
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.
Musick; Charles R. (Castro Valley, CA), Critchlow; Terence (Livermore, CA), Ganesh; Madhaven (San Jose, CA), Slezak; Tom (Livermore, CA), Fidelis; Krzysztof (Brentwood, CA)
The Regents of the University of California (Oakland, CA)
09/ 479,432
January 7, 2000
The United States Government has rights in this invention pursuant to Contract No. W-7405-ENG-48 between the United States Department of Energy and the University of California for the operation of Lawrence Livermore National Laboratory.