Browse Prior Art Database

Method for data import insuring data integrity

IP.com Disclosure Number: IPCOM000124406D
Original Publication Date: 2005-Apr-19
Included in the Prior Art Database: 2005-Apr-19
Document File: 4 page(s) / 46K

Publishing Venue

IBM

Abstract

Disclosed is a method for importing data into a system that will predict the result of the process and force corrections to the input data, thus ensuring both a successful import and a properly functioning target system following the procedure. Quite often this method will prove useful when the source is another similar system and it is desired to migrate configuration data to a target system in a controlled manner. The method which is disclosed assists a user performing this task by visually presenting data conflicts and suggesting resolutions for each, as well as correcting mismatches between objects in the input data and the target system.

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 24% of the total text.

Page 1 of 4

Method for data import insuring data integrity Summary

Disclosed is a method for importing data into a system that will predict the result of the process and force corrections to the input data, thus ensuring both a successful import and a properly functioning target system following the procedure. Quite often this method will prove useful when the source is another similar system and it is desired to migrate configuration data to a target system in a controlled manner. The method which is disclosed assists a user performing this task by visually presenting data conflicts and suggesting resolutions for each, as well as correcting mismatches between objects in the input data and the target system.

Details

It is a frequent requirement in data processing systems to enable the import of data from external sources, including other systems that are similar or even identical in structure. Traditionally this must be accomplished by a skilled user who invokes a manual, frequently error-prone, process, which may need to be repeated multiple times. A method is disclosed here which can be used to predict the result of the import process before it executes, enabling a user to perform the task with a much higher probability of success, usually on the first attempt.

Manual Methodology

The migration of data is a frequent requirement of organizations utilizing any form of data processing system, particularly for configuration data. For example, an organization might establish a data model on a test system and at some point wish to migrate it to a production system. Later, changes to the test system might need to be migrated to the production system. In a complex environment, it may also be desirable to merge the data models from multiple systems into one. Various forms of configuration information might be required to migrate from one system to another. In any case, it is extremely important that data integrity and proper functioning of the target system be maintained following the import of migrated data.

In order to achieve this in a traditional fashion the following manual steps are required:

Export the required objects from the source system to an intermediate format that can be edited.

Examine the exported data and the target system, resolving any conflicts or inconsistencies and

Import the data into the target system. If an error occurs, return to step 2 and correct the problem.


1.


2.


3.


4.

Clearly, this method has several obvious drawbacks, particularly for complex configuration data. First, it is manual and therefore both time consuming and error prone. If the user performing these tasks does not have a thorough understanding of the system's requirements and constraints, it is very likely that many iterations through the import process will be required. Second, if the system is designed in such a way as to permit invalid configurations to be stored, it is possible to complete the above process and be left with an unusable target system.

co...