Automatic transmission of legacy system data

• US 5,857,194 A
• Filed: 12/23/1996
• Issued: 01/05/1999
• Est. Priority Date: 11/07/1996
• Status: Expired due to Term

• Current Assignee: General Electric Company
• Original Assignee: General Electric Company
• Inventors: Kelliher, Timothy Patrick, Bruno, Jeanette Marie
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): CHANNAVAJJALA, SRIRAMA T
• Application Number:
  US08/772,634
• Time in Patent Office: 743 Days
• Field of Search: 707/512, 707/104, 707/4, 707/101, 705/2, 395/500
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

The present invention analyses an existing legacy system, such as a Physician'"'"'s Office Management System, and automatically extracts, reformats and sends required data to a service company, which may be for example, and insurance company. It begins by feeding the legacy system "seed data" and monitors the legacy system storage device to determine a "raw map" of where and how the seed data is stored. It then culls out multiple records, single records, inconsistent records in the raw map. Control flow information is also extracted. This indicates which fields are "key" fields and are used to extract other information. These key fields must be acquired before their related data. After the data is located and the order is determined, a script is automatically created to extract the data. The data is then extracted and reformatted in a predetermined format determined by the service company, and the required data is automatically sent, by conventional means, to the service company.

Claims

1. A system for automatically determining the data format of a storage device of existing legacy system, extracting the data, and transmitting the data in one of several predetermined formats required by a service company comprising:

a) a data input means for feeding seed data to said legacy system;

b) a Data Locator coupled to said legacy storage device, for searching said legacy system storage device and for storing location (table, record, record position) of occurrences of the seed values in a raw map along with the seed values and the format of the legacy field;

c) a Map Refining device coupled to, and for receiving the raw map from the Data Locator, for culling out false hits from the raw map to produce a clean map of domain fields to legacy fields;

d) a Control Flow Analyzer coupled to, and receiving the output clean map from the Map Refining device for identifying key fields in the clean map used to acquire other data which must be acquired first, and for creating control flow information indicating the order of data extraction;

e) an Output Generator coupled to the Map Refining device and the control flow analyser, for receiving the clean map the control flow information and for creating data extraction steps to extract the data in the required order;

f) an Extraction device is coupled to the Output Generator, and to legacy storage device, for executing the data extraction steps to acquire extracted data;

g) a Transmission device coupled to the Extraction device for receiving the extracted data, for reformating this data according to a predetermined format, for contacting a service company by conventional communications systems, and for sending the data in the predefined format.

2. The system of claim 1 wherein the Map Refining device comprises:

a Set Consistency device coupled to the Data Locator which receives the raw map and analyses the raw map checking for consistency from one seed set to the next, discarding inconsistent maps.

3. The system of claim 1 wherein the Map Refining device comprises:

a Single Record Cull device which receives the raw map and culls out single record maps where only one domain field maps to a given record in the legacy application.

4. The system of claim 1 wherein the Map Refining device comprises:

an iteration consistency device which receives the raw map and checks if all iterations of a given domain field map consistently to the same legacy field, culling out those which do not.

5. The system of claim 1 wherein the Map Refining device comprises:

a ranking device which receives the raw map and ranks the maps by the number of fields which map to a common record of legacy storage device, the set of maps that map the largest set of domain fields to a given legacy record are given the highest ranking.

6. The system of claim 1 wherein the Map Refining device comprises:

a Multiple Record Search device which receives the raw map and identifies if differing subsets of maps map to different records in the same file indicating that said legacy system is using different record layouts within the same file.

7. The system of claim 1 wherein the Map Refining device is adapted to search for repeated characters as delimiters, and indicate if the records are variable length to the Output Generator.