Skip to main content
Article
Ontology-guided Reference Data Alignment in Information Integration Projects
AMCIS 2012 Proceedings
  • Sushain Pandit, Information Management, IBM, Austin, TX, United States.
  • Martin Oberhofer, Information Management, IBM, Austin, TX, United States.
  • Ivan Milman, Information Management, IBM, Austin, TX, United States.
Abstract

One of the hard problems in information integration projects (harmonizing data from various legacy sources into one or more targets) is the appropriate alignment of reference data values across systems. Without this alignment, the process of loading records into the target systems might fail because the target might reject any record with an unknown reference data value or different underlying data semantics. Today, detecting reference data tables and determining the relative alignment between a source and a target is largely manual, cumbersome, error-prone and costly. We propose a novel ontology-guided approach to detect reference data tables and their relative alignment across source/target systems to enable semi-automated creation of translation tables.

Citation Information
Sushain Pandit, Martin Oberhofer and Ivan Milman. "Ontology-guided Reference Data Alignment in Information Integration Projects"
Available at: http://works.bepress.com/sushain/3/