Integrating Heterogenous Databases
This project is part of the Helix
Group at Stanford School of Medicine. Please address inquiries to
russ.altman@stanford.edu or sujansky@smi.stanford.edu. Walter
Sujansky is maintaining an up-to-date home page for TransFER.
1. Summary of Project Goals
The goals of this project is to develop technologies for mapping numerous
local relational database schemae to a single, global model. Having once
defined the mapping relationship between a local database schema and the
global model, the method allows queries that are written with respect to
the global model to be translated into executable SQL queries at the local
level.
The initial application area for this work is clinical medical databases.
With the increasing importance of standard practice guidelines, it becomes
important for local hospital database administrators to quickly implement
clinical guidelines. With the technology developed here, a one-time mapping
must be defined, and then all subsequent queries can be written (by the
authors of the clinical guidelines) using the global query model and automatically
translated into a local database operation.
This work represents the dissertation research of Walter Sujansky, with
Russ Altman as advisor. As conceived and implemented by Sujansky, this
methodology is referred to as TransFER.
2. Project Personnel
3. References
A list of relevant
papers is available.
Last update March 10 2004.
help@helix.stanford.edu