A Model-Driven Approach to Enterprise Data Migration

Abstract

Abstract. In a typical data migration project, analysts identify the mappings between source and target data models at a conceptual level using informal textual descriptions. An implementation team translates these mappings into programs that migrate the data. While doing so, the programmers have to understand how the conceptual models and business rules map to physical databases. We propose a modeling mechanism where we can specify conceptual models, physical models and mappings between them in a formal manner. We can also specify rules on conceptual models. From these models and mappings, we can automatically generate a program to migrate data from source to target. We can also generate a program to migrate data access queries from source to target. The overall approach results in a significant improvement in productivity and also a significant reduction in migration errors.

Toward Better Mapping between Regulations and Operations of Enterprises Using Vocabularies and Semantic Similarity

“…The BP model is created and traversed using an in-house tool that we describe in [41]. To interface with enterprise data, we are currently working with other in-house tools described in [42] and [43]. Figure 3.…”