Abstract

The integrated access to heterogeneous data sources is a major challenge for 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 developed at the University of Pennsylvania: K2, a view integration implementation, and GUS, a data warehouse. Although the view integration and the warehouse approaches each have advantages, there is no clear "winner." Therefore, in selecting the best strategy for a particular application, users must consider the data characteristics, the performance guarantees required, and the programming resources available. Our experiences also point to some practical tips on how database updates should be published, and how XML can be used to facilitate the processing of updates in a warehousing environment.

Keywords

Computer scienceData warehouseXMLData integrationDatabasePoint (geometry)Data scienceSystem integrationWorld Wide Web

Affiliated Institutions

Related Publications

Publication Info

Year
2001
Type
article
Volume
40
Issue
2
Pages
512-531
Citations
202
Access
Closed

External Links

View on DOI.org

Social Impact

Altmetric
PlumX Metrics

Social media, news, blog, policy document mentions

Citation Metrics

202
OpenAlex

Cite This

Susan B. Davidson, Jonathan Crabtree, Brian P. Brunk et al. (2001). K2/Kleisli and GUS: Experiments in integrated access to genomic data sources. IBM Systems Journal , 40 (2) , 512-531. https://doi.org/10.1147/sj.402.0512

Identifiers

DOI
10.1147/sj.402.0512