Secure and useful data sharing
Decision Support Systems
Data & Knowledge Engineering
Usercentric Operational Decision Making in Distributed Information Retrieval
Information Systems Research
Data Quality of Query Results with Generalized Selection Conditions
Operations Research
Identity matching and information acquisition: Estimation of optimal threshold parameters
Decision Support Systems
Hi-index | 0.00 |
The notion of a data warehouse for integrating operational data into a single repository is rapidly becoming popular in modern organizations. An important issue in the integration process is how to deal with the identifier mismatch problem when combining similar data from disparate sources. A real-world entity may be represented using different identifiers in different operational data sources, and matching them may often be difficult using simple database operations expressed, say, as an SQL query. A record-by-record manual matching is also not practical because the databases may be large. A decision model is presented that combines probability-based automated matching with manual matching in a cost minimization formulation. A heuristic approach is proposed for solving the decision model. Both the model and the heuristic solution approach have been tested on real data. The results from the testing indicate that the model can be effectively used in real-world situations.