Browse Prior Art Database

Data Conversion Toolkit

IP.com Disclosure Number: IPCOM000116927D
Original Publication Date: 1995-Nov-01
Included in the Prior Art Database: 2005-Mar-31
Document File: 4 page(s) / 172K

Publishing Venue

IBM

Related People

Grams, GL: AUTHOR

Abstract

An application is disclosed to assist data conversion projects in formulating a controlled and automated data mapping approach. The Data Conversion Toolkit (DCT) is a Graphical User Interface (GUI) Windows based application. It consists of functional areas supporting data mapping, data mapping reports, data mapping progress reports, data mapping versioning control reports, code generation, and consolidation. See Fig. 1 for a diagram of the architecture.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 37% of the total text.

Data Conversion Toolkit

      An application is disclosed to assist data conversion projects
in formulating a controlled and automated data mapping approach.  The
Data Conversion Toolkit (DCT) is a Graphical User Interface (GUI)
Windows based application.  It consists of functional areas
supporting data mapping, data mapping reports, data mapping progress
reports, data mapping versioning control reports, code generation,
and consolidation.  See Fig. 1 for a diagram of the architecture.

      The Data Conversion Toolkit provides a user friendly interface
for the data mapping process.  This process consists of creating,
documenting, and maintaining source element to target element
mappings.  The DCT provides data mapping integrity; a single database
repository where data mapping information can be obtained in a timely
and efficient manner; an automated versioning control process that
loads new versions of source and/or target data models; a variety of
data mapping reports; a consolidation application that permits data
conversion project(s) to store, retrieve, and maintain data mappings
in a database common to an enterprise; and a code generator that
generates programming source code.

      Productivity enhancements are achieved by having an automated
verses manual data conversion process.  Automation is faster, more
reliable, more accurate, and easier to maintain.  Another area where
the DCT provides productivity enhancements is the code generator.
Programmers are allowed to concentrate on the design and
interpretation of complex data conversion requirements instead of the
simple task of coding source to target assignment statements.  The
DCT code generator generates the assignment statements.

      A number of features of the DCT provide for consistent quality
throughout the conversion process.  These include:
  o  Common mapping process promotes consistent analysis of legacy
      data
  o  Consolidated mapping repository identifies multiple sources
  o  Permits integrated analysis of data across multiple systems
  o  Identifies the primary sources for data to be converted
  o  Determines a "natural order" to approach conversions
  o  Identifies redundant data

      Before the data mapping process actually begins, legacy system
(source) and state of the art system (target) information is loaded
into the DCT.  The loading process is performed via a DCT load
program.  The source and target information loaded is obtained from a
file which is generated from a Computer Assisted Software Engineering
(CASE) tool or is manually created.  The DCT load program is executed
whenever the source or target information is modified.

      The data mapping functional unit is the process of specifying
how a source data element is mapped to a target data element.  The
criteria of uniquely defining a data mapping are many.  For example,
the DCT provides the following criteria for defining a data mapping...