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:
  • A system and method of integrating information from multiple sources in a document centric application system. A plurality of application systems are connected through an object request broker to a central repository. The information may then be posted on a webpage. An example of an implementation of the method and system is an online procurement system.
  • Disclosed herein are representative embodiments of tools and techniques for classifying programs. According to one exemplary technique, at least one graph representation of at least one dynamic data source of at least one program is generated. Also, at least one graph representation of at least one static data source of the at least one program is generated. Additionally, at least using the at least one graph representation of the at least one dynamic data source and the at least one graph representation of the at least one static data source, the at least one program is classified.
  • A system and method of integrating diverse sources of data and data streams is presented. The method can include selecting a scenario based on a topic, creating a multi-relational directed graph based on the scenario, identifying and converting resources in accordance with the scenario and updating the multi-directed graph based on the resources, identifying data feeds in accordance with the scenario and updating the multi-directed graph based on the data feeds, identifying analytical routines in accordance with the scenario and updating the multi-directed graph using the analytical routines and identifying data outputs in accordance with the scenario and defining queriesmore » to produce the data outputs from the multi-directed graph.« less
  • A data collector for a massively parallel computer system obtains call-return stack traceback data for multiple nodes by retrieving partial call-return stack traceback data from each node, grouping the nodes in subsets according to the partial traceback data, and obtaining further call-return stack traceback data from a representative node or nodes of each subset. Preferably, the partial data is a respective instruction address from each node, nodes having identical instruction address being grouped together in the same subset. Preferably, a single node of each subset is chosen and full stack traceback data is retrieved from the call-return stack within themore » chosen node.« less
  • Mechanisms for generating and executing programs for a floating point (FP) only single instruction multiple data (SIMD) instruction set architecture (ISA) are provided. A computer program product comprising a computer recordable medium having a computer readable program recorded thereon is provided. The computer readable program, when executed on a computing device, causes the computing device to receive one or more instructions and execute the one or more instructions using logic in an execution unit of the computing device. The logic implements a floating point (FP) only single instruction multiple data (SIMD) instruction set architecture (ISA), based on data stored inmore » a vector register file of the computing device. The vector register file is configured to store both scalar and floating point values as vectors having a plurality of vector elements.« less