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

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.

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.