Computing Reviews
Today's Issue Hot Topics Search Browse Recommended My Account Log In
Review Help
Search
A model for matching and integrating heterogeneous relational biomedical databases schemas
Karasneh Y., Ibrahim H., Othman M., Yaakob R.  IDEAS 2009 (Proceedings of the 2009 International Database Engineering & Applications Symposium, Cetraro, Calabria, Italy, Sep 16-18, 2009)242-250.2009.Type:Proceedings
Date Reviewed: Dec 24 2009

When working to integrate multiple database schemas, either to merge them or to enable queries across their federation, the desirability of automatic schema matching is apparent. Although schema matching and integration has been studied for over 25 years [1], it is still a difficult problem. Bernstein et al. describe it as “AI-complete, that is, as hard as reproducing human intelligence” [2].

Nowadays, many researchers are working on semi-automatic systems that propose potential schema matches, with human experts making the final decisions. In this vein, Karasneh et al. propose a model to extend previous work on the integration of multiple heterogeneous biomedical databases’ schemas.

Unlike other contemporary research efforts, this paper’s approach is limited to integrating relational database schemas. The approach is straightforward, focusing primarily on the schema-matching phase of database integration. Although Karasneh et al. make the unsupported claim of “using as much as possible the available information during the process of matching the schemas,” the model does incorporate multilevel matching and decision making at four levels: schema, attribute name, domain, and instance. Two similarity metrics--n-gram and synonym--are used for matching. The results presented support the following hypotheses: all of the elements used for matching are significant; the approach reduces the number of attributes in the global schema; and the approach reduces the number of null values in an integrated database.

Despite several grammatical errors, the paper is well organized and easy to read. It should be of interest to researchers who are looking for practical approaches to database schema matching and integration.

Reviewer:  S. Thomas Review #: CR137594 (1102-0205)
1) Motro, A.; Buneman, P. Constructing superviews. In Proceedings of the 1981 ACM SIGMOD International Conference on Management of Data ACM, 1981, 56–64.
2) Bernstein, P.A.; Melnik, S.; Petropoulos, M.; Quix, C. Industrial-strength schema matching. ACM SIGMOD Record 33, 4(2004), 38–43.
Bookmark and Share
  Reviewer Selected
 
 
Relational Databases (H.2.4 ... )
 
 
Transaction Processing (H.2.4 ... )
 
Would you recommend this review?
yes
no
Other reviews under "Relational Databases": Date
A sound and sometimes complete query evaluation algorithm for relational databases with null values
Reiter R. Journal of the ACM 33(2): 349-370, 1986. Type: Article
Nov 1 1986
Sort sets in the relational model
Ginsburg S., Hull R. Journal of the ACM 33(3): 465-488, 1986. Type: Article
Nov 1 1986
Foundation for object/relational databases
Date C., Darwen H., Addison Wesley Longman Publishing Co., Inc., Redwood City, CA, 1998. Type: Book (9780201309782)
Nov 1 1998
more...

E-Mail This Printer-Friendly
Send Your Comments
Contact Us
Reproduction in whole or in part without permission is prohibited.   Copyright 1999-2024 ThinkLoud®
Terms of Use
| Privacy Policy