Matching/merging two data warehouse physical data models
AssigneeNCR Corporation
InventorRonald Fink
Life of this patent
Estimating the term…
Abstract
The mechanism is directed to a method and apparatus which provides a technique and tools to allow a combination of existing customer databases to be used by transforming a portion of the data in the existing data warehouses into a second data structure. Advantageously, greater functionality can be achieved by using new application programs while existing application programs can continue to be used without changes to code of the existing applications.
Claims20
A method of using a first database structure and a first application program by transforming a portion of data in the first database structure into a second database structure in a second database for use by a second application program, the method comprising:
- establishing a set of classes for the second database structure;
- creating a list which relates the set of classes between the first database structure and the second database structure;
- and
- moving and transforming a selected portion of the data from the first database structure to the second database structure such that the second application program can use the remaining untransformed data in the first database structure and the transformed data in the second database structure.
A method of using a first database structure and a first application program by transforming a portion of data in the first database structure into a second database structure in a second database for use by a second application program, the method comprising:
- establishing a set of classes for the second database structure;
- creating a list which relates the set of classes between the first database structure and the second database structure, wherein each of the classes in the set of classes relate a table/column in the second database structure to a table/column in the first database structure;
- and
- moving and transforming data from a data source to the second database structure such that the second application program can use the data in the first database structure and the data in the second database structure.
A computer architecture using a first database structure and a first application program by transforming a portion of data in the first database structure into a second database structure in a second database for use by a second application program, comprising:
- establishing means for establishing a set of classes for the second database structure;
- creating means for creating a list which relates the set of classes between the first database structure and the second database structure;
- and
- moving and transforming means for moving and transforming a selected portion of the data from the first database structure to the second database structure such that the second application program can use the remaining untransformed data in the first database structure and the transformed data in the second database structure.
An article using a first database structure and a first application program by transforming a portion of data in the first database structure into a second database structure in a second database for use by a second application program, comprising:
- at least one sequence of machine executable instructions;
- a medium bearing the executable instructions in machine form, wherein execution of the instructions by one or more processor causes the one or more processors to:
- establish a set of classes for the second database structure;
- create a list which relates the set of classes between the first database structure and the second database structure;
- and
- move and transform a selected portion of the data from the first database structure to the second database structure such that the second application program can use the remaining untransformed data in the first database structure and the transformed data in the second database structure.
A computer system, comprising:
- a processor;
- and
- a memory coupled to said processor, the memory having stored therein sequences of instructions, which, when executed by said processor, causes said processor to perform the steps of:
- establishing a set of classes for the second database structure;
- creating a list which relates the set of classes between the first database structure and the second database structure;
- and
- moving and transforming a selected portion of the data from the first database structure to the second database structure such that the second application program can use the remaining untransformed data in the first database structure and the transformed data in the second database structure.
Dependencies are inferred from the claim text.