K2/Kleisli and GUS: Experiments in integrated access to genomic data sources

The integrated access to heterogeneous data sources is a major challenge fo r the biomedical community. Several solution strategies have been explored: link-driven federation of databases, view integration, and warehousing. In this paper we report on our experiences with two systems that were develop ed at the University of Pennsylvania: K2, a view integration implementation , and GUS, a data warehouse. Although the view integration and the warehous e approaches each have advantages, there is no clear "winner." Therefore, i n selecting the best strategy for a particular application, users must cons ider the data characteristics, the performance guarantees required, and the programming resources available. Our experiences also point to some practi cal tips on how database updates should be published, and how XML can be us ed to facilitate the processing of updates in a warehousing environment.