System method and program product to estimate cost of integrating and utilizing heterogeneous data sources

• US 20060259442A1
• Filed: 05/17/2005
• Published: 11/16/2006
• Est. Priority Date: 05/17/2005
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Iqbal, Mickey
• Application Number:
  US11/130,737
• Publication Number:
  US 20060259442A1
• Time in Patent Office: Days
• US Class Current: 705/400
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06Q 30/0283 Price estimation or determination

Abstract

System, method and program product for estimating a cost of reconciling heterogeneous data sources. A transition cost for integrating together a first program to identify semantic conflicts, a second program to classify semantic conflicts and a third program to reconcile semantic conflicts is estimated. A steady state cost for managing and maintaining the integrated first, second and third programs is estimated. Another system, method and program product for estimating a cost of integrating heterogeneous data sources. A steady state cost of managing and maintaining a first program which identifies semantic conflicts between a cross data source query and schema elements in a data source is estimated. A steady state cost of managing and maintaining a second program which classifies semantic conflicts between the cross data source query and schema elements in the data source is estimated. A steady state cost of managing and maintaining a third program which reconciles semantic conflicts between the cross data source query and schema elements in the data source is estimated.

Claims

1. A method for estimating cost of reconciling heterogeneous data sources, said method comprising the steps of:

estimating a transition cost for integrating together a first program to identify semantic conflicts, a second program to classify semantic conflicts and a third program to reconcile semantic conflicts; and

estimating a steady state cost for managing and maintaining the integrated first, second and third programs.

2. A method as set forth in claim 1 further comprising the steps of:

estimating a transition cost for configuring and implementing said third program.

3. A method as set forth in claim 1 further comprising the steps of:

estimating a transition cost for implementing a non-monotonic semantic assertion maintenance system which supports context queries generated by the integrated first, second and third programs; and

estimating a steady state cost for managing and maintaining said non-monotonic semantic assertion maintenance system.

4. A method for estimating a cost of integrating heterogeneous data sources, said method comprising the steps of:

estimating a steady state cost of managing and maintaining a first program which identifies semantic conflicts between a cross data source query and schema elements in a data source;

estimating a steady state cost of managing and maintaining a second program which classifies semantic conflicts between said cross data source query and schema elements in said data source; and

estimating a steady state cost of managing and maintaining a third program which reconciles semantic conflicts between said cross data source query and schema elements in said data source.

5. A method as set forth in claim 4 further comprising the step of:

estmimating a steady state cost of transforming at least some of said cross data source queries to a canonical data model form.

6. A method for estimating a cost of integrating heterogeneous data sources, said method comprising the steps of:

estimating a transition cost of implementing a first program which identifies semantic conflicts between a cross data source query and schema elements in a data source;

estimating a transition cost of implementing a second program which classifies semantic conflicts between said cross data source query and schema elements in said data source; and

estimating a transition cost of implementing a third program which reconciles semantic conflicts between said cross data source query and schema elements in said data source.

7. A method as set forth in claim 6, further comprising the steps of:

estimating a transition cost for reconciling cross data source queries which require manual intervention for validation of reconciled semantic conflicts; and

estimating a steady state cost for reconciling cross data source queries which require manual intervention for validation of reconciled semantic conflicts.

8. A method for estimating a cost of integrating heterogeneous data sources, said method comprising the steps of:

estimating a percent of schema elements in the data sources where functional computation based on semantic mapping between schema terms and ontology terms is required;

estimating a steady state labor cost for said functional computation for said percent of schema elements where functional computation is required;

estimating a percent of schema elements in the data sources where structural heterogeneity semantic mapping between schema terms and ontology terms is required; and

estimating a steady state labor cost for said semantic mapping for said percent of schema elements where semantic mapping is required.

9. A method as set forth in claim 8 further comprising the step of estimating a steady state cost of mapping local data source schema elements from the data sources to a shared ontology.

10. A method for estimating a cost of integrating heterogeneous data sources, said method comprising the steps of:

estimating a percent of schema elements in each data source where functional computation based on semantic mapping between schema terms and ontology terms is required;

estimating a transitional labor cost for implementing a first program to perform said functional computation for said percent of schema elements where functional computation is required;

estimating a percent of schema elements in each data source where structural heterogeneity semantic mapping between schema terms and ontology terms is required; and

estimating a transitional labor cost for implementing a second program to perform said semantic mapping for said percent of schema elements where semantic mapping is required.

11. A method as set forth in claim 10 further comprising the step of estimating a transitional labor cost of mapping local data source schema elements from each data source to a shared ontology.

12. A method as set forth in claim 10 further comprising the steps of:

estimating a transitional labor cost for automatically mapping the first said percent of schema elements to correct ontology terms; and

estimating a transitional labor cost for manually mapping the first said percent of schema elements to correct ontology terms.

13. A method as set forth in claim 10 further comprising the step of:

estimating a transitional labor cost for validating said semantic mapping of the second said percent of schema elements to correct ontology terms.

14. A method as set forth in claim 13 further comprising the step of:

estimating a steady state labor cost for validating said semantic mapping of the second said percent of schema elements to correct ontology terms.

15. A method as set forth in claim 10 further comprising the steps of:

estimating a transitional labor cost for implementing a wrapper to convert semi-structured data from a semi-structured data source to a structured schema which can interface with a semantic reconciliation program; and

estimating a steady state labor cost for managing and maintaining said wrapper.