US 5,493,671 AGranted

Method and apparatus for conversion of database data into a different format on a field by field basis using a table of conversion procedures

AssigneeMarcam Corporation

InventorsJanice S. Pitt, John Lawton

Life of this patent

Estimating the term…

Loading patent…

Abstract

A data conversion apparatus and method for translating information stored in a first relational database to that stored in a second relational database, and for translating information in a relational database used by a first selected version of a computer program into information stored in a second relational database for use by a second selected version of a computer program. The apparatus and method thus allow the sharing of data by computer systems running different versions of a given software package. The data conversion apparatus includes a first file storage element for storing a first relational database having a plurality of digital records representing information used by a first selected version of a computer program, and a second file storage element capable of storing a second relational database representing at least a portion of the information from the first database for use by a second selected version of the computer program. The apparatus further includes a file management element that converts information from the first database for storage in the second. That conversion is performed as a function of the identities of the first and second selected versions of the computer program. The file management element includes table entry elements that identify, in table-like form, the procedures for translating individual records or fields of information stored in the first relational database into a form compatible with the second software subroutines, each of which executes steps necessary for converting data between computer program version. Each file management table entry stores the names of the respective formats.

Claims8

Dependent claims

A method of data conversion for use with a digital data processing system of the type having

first file storage means for storing a first relational database, said first relational database including a plurality of digital records representing information used by a first selected version of a computer program,
second file storage means capable of storing a second relational database, said second relational database including a plurality of digital records representing at least a portion of said information for use by a second selected version of said computer program,
said data conversion apparatus comprising
A. a file management step for generating and storing in said second relational database a plurality of digital records for use by said second selected version of said computer program, wherein each such generated digital record includes at least selected information from a corresponding digital record of said first relational database,
B. said file management step including a conversion step for generating said digital records for storage in said second relational database by converting at least selected information contained in the corresponding digital record of said first relational database, wherein said conversion is a function of (i) the identity of said first selected version of said computer program, and (ii) the identity of said second selected version of said computer program
C. said conversion step includes the steps of
accessing a selected entry in a table of entries, each storing a procedure-representative signal representative of procedure for converting information contained in at least a component of a digital record of said first relational database to information contained in at least one corresponding component of a digital record of said second relational database, said entry being selected as a function of the identities of said selected versions of said computer program with which said first and second relational databases are associated, and
ii) executing the procedure represented by the procedure-representative signal stored in said selected entry to perform said conversion.

5 more elements

Data conversion apparatus for use with a digital data processing system of the type having

first file storage means for storing a first relational database, said first relational database including a plurality of digital records representing information used by a first selected version of a computer program,
second file storage means capable of storing a second relational database, said second relational database including a plurality of digital records representing at least a portion of said information for use by a second selected version of said computer program,
said data conversion apparatus comprising
A. file management means, coupled to said first and second file storage means, for generating and storing in said second relational database a plurality of digital records for use by said second selected version of said computer program, wherein each such generated digital record includes at least selected information from a corresponding digital record of said first relational database,
B. said file management means includes conversion means for generating said digital records for storage in said second relational database by converting at least selected information contained in the corresponding digital record of said first relational database, wherein said conversion is a function of (i) the identity of said first selected version of said computer program, and (ii) the identity of said second selected version of said computer program,
C. said conversion means comprising
i) a plurality of table entry means, each for storing a procedure-representative signal representative of a procedure for converting information contained in at least a component of a digital record of said first relational database to information contained in at least one corresponding component of a digital record of said second relational database,
ii) execution means for accessing a selected said table entry means as a function of the identities of said selected versions of said computer program with which said first and second relational databases are associated, and for executing the procedure represented by the procedure-representative signal stored therein to perform said conversion.

5 more elements

Dependencies are inferred from the claim text.