Method, system, and product for data integration through a dynamic common model

• US 6,792,431 B2
• Filed: 05/07/2001
• Issued: 09/14/2004
• Est. Priority Date: 05/07/2001
• Status: Expired due to Term

• Current Assignee: Petris Technology Corporation
• Original Assignee: Anadarko Petroleum Corporation (Occidental Petroleum Corporation)
• Inventors: Jacobs, John, Tamboli, Aderbad
• Primary Examiner(s): Robinson, Greta
• Assistant Examiner(s): RAYYAN, SUSAN F
• Application Number:
  US09/850,317
• Publication Number:
  US 20030014617A1
• Time in Patent Office: 1,226 Days
• Field of Search: 707/100, 707/102
• 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/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

Data integration including extracting a first native record having a first native format from a first native repository through a first adapter, the first adapter loosely coupled for data integration to a data integration application, the first native format having a datatype; transforming the first native record having first native format to a first native record having dynamic common format, the dynamic common format being a subset of a dynamic common model, the dynamic common model comprising mappings to and from the dynamic common format for all native records in all datatypes; transforming the format of the first native record having dynamic common format to a first native record having second native format; and inserting through a second adapter, also loosely coupled to the application, the first native record the second native format into a second native repository.

Claims

1. A method of creating a system implementing a dynamic common model, the system including a data integration application, the method comprising the steps of:

developing a first adapter for a first native repository, the first adapter being loosely coupled for data integration to the data integration application, the first native repository comprising first native records having first native formats, the first native formats belonging to categories of formats identified as datatypes;

developing a second adapter for a second native repository, the second adapter being loosely coupled for data integration to the data integration application, the second native repository comprising second native records having second native formats, the second native formats belonging to categories of formats identified as datatypes;

creating mappings specifying transformations of records;

from the first native format to a first dynamic common format, from the first dynamic common format to the first native format, from the second native format to a second dynamic common format, and from the second dynamic common format to the second native format;

providing a transformation service capable of transforming formats in dependence upon the mappings, the transformation service coupled for data communications to the first adapter and to the second adapter;

wherein the data integration application is coupled for data communications to a multiplicity of native repositories through a multiplicity of adapters;

wherein the multiplicity of adapters includes the first adapter and the second adapter;

wherein all the adapters among the multiplicity of adapters are loosely coupled for data integration to the data integration application;

wherein the data integration application comprises the transformation service; and

wherein the dynamic common format is a subset of a dynamic common model, the dynamic common model having the capability of specifying transformations to and from dynamic common format for all formats of records in all datatypes of the multiplicity of native repositories.

2. The method of claim 1 wherein the multiplicity of native repositories consists of only the first native repository and the second native repository.

3. The method of claim 1 further comprising registering, through an adapter manager in the data integration application, the adapters for the first native repository and the second native repository.

4. The method of claim 1 further comprising populating, through spiders, a catalog in the data integration application with identifying attributes and proxy data for all records of all datatypes in the native first native repository and the second native repository.

5. A method of integrating an additional native repository with a system implementing a dynamic common model, the system including a data integration application, the method comprising the steps of:

developing a first adapter;

creating mappings specifying transformations of records;

from a first native format to a first dynamic common format, and

from the first dynamic common format to the first native format;

developing an additional adapter for the additional native repository, the additional adapter being loosely coupled for data integration to the data integration application, the additional native repository comprising additional native records having at least one additional native format, the additional native format belonging to at least one category of formats identified as a datatype;

creating mappings specifying transformations of records;

from the at least one additional native format to an additional dynamic common format, and from the additional dynamic common format to the at least one additional native format;

wherein the data integration application is coupled for data communications to a multiplicity of native repositories through a multiplicity of adapters;

wherein the multiplicity of adapters includes the additional adapter;

wherein all the adapters among the multiplicity of adapters are loosely coupled for data integration to the data integration application;

wherein the data integration application comprises a transformation service capable of transforming formats in dependence upon the mappings, the transformation service coupled for data communications to all the adapters among the multiplicity of adapters;

wherein the dynamic common format is a subset of a dynamic common model, the dynamic common model having the capability of specifying transformations to and from dynamic common format for all formats of records in all datatypes of the multiplicity of native repositories.

6. The method of claim 5 further comprising registering, through an adapter manager in the data integration application, the additional adapter.

7. The method of claim 5 further comprising populating, through a spider, a catalog in the data integration application with identifying attributes and proxy data for all records of all datatypes in the additional native repository.