Transforming Heterogeneous Data with Database Middleware: Beyond Integration

Authors: 
Haas, Laura M.; Miller, Renee J.; Niswonger, B.; Tork Roth, Mary; Schwarz, Peter M.; Wimmers, Edward L.
Author: 
Haas, L
Miller, R
Niswonger, B
Tork Roth, M
Schwarz, P
Wimmers, E
Year: 
1999
Venue: 
IEEE Data Eng. Bull. 22(1): 31-36 (1999)
URL: 
http://www.almaden.ibm.com/cs/clio/papers/HMN99.pdf
Citations: 
226
Citations range: 
100 - 499
AttachmentSize
Haas1999TransformingHeterogeneousDatawithDatabaseMiddleware.pdf397.27 KB

Database middleware systems integrate data from multiple sources.
To be effective, such systemsmust provide a unified, queryable schema, and must be able to transform data from different sources to conform to this schema when queries against the schema are issued. The power of their query engines and their ability to connect to several information sources makes them a natural base for doing
more complex transformations as well. In this paper, we look at database middleware systems as tranformation engines, and discuss when and how data is transformed to provide users with the information they need.