loading...
Integration of Relational Databases and Record-Based Legacy Systems for Populating Data Warehouses
Big Island, Hawaii January 07-January 10
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/HICSS.2002.99428635th Annual Hawaii International Conf ...
 This Article 
 
PURCHASE ARTICLE: $0
HTML
 
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
OSDWH04The number of data sources that an organization has to deal with continues to be nontrivial. Integrating this data is a growing problem. A great deal of research has been done to solve the general problem. Work on topics like multidatabase, mediators, and ontologies has been directed at solving the general data integration problem. While all of this activity has been useful, the general problem of integrating heterogeneous data sources remains only partially solved. The present work looks at the solution of a sub-problem of the general problem where the data sources are restricted to relational databases and record-based legacy systems owned by the same organization. For many organizations, this restriction precisely defines their integration problem. For example, data warehouses typically have a tuple as their storage format whether they are table or cube oriented. The task of defining the tuple requires integrating the organization's existing relational and/or record-based legacy systems. Populating the data warehouse can be accomplished by querying the integrated data sources. Specifically, we provide a mechanism for developing a relational model for the set of data sources, provide a method for generating correct queries over the model and create an architecture for executing the queries based on the mobile agent paradigm. A prototype of the system has been designed and implemented.
Citation:
L. Miller, X. Yu, S. Nilakanta, "Integration of Relational Databases and Record-Based Legacy Systems for Populating Data Warehouses," hicss, vol. 8, pp.224b, 35th Annual Hawaii International Conference on System Sciences (HICSS'02)-Volume 8, 2002
Usage of this product signifies your acceptance of the Terms of Use.