Luis Marenco1, Rixin Wang, Prakash Nadkarni. 1. Center for Medical Informatics, Yale University School of Medicine, PO Box 208009, New Haven, CT 06520-8009, USA. luis.marenco@yale.edu
Abstract
OBJECTIVE: To devise an automated approach for integrating federated database information using database ontologies constructed from their extended metadata. BACKGROUND: One challenge of database federation is that the granularity of representation of equivalent data varies across systems. Dealing effectively with this problem is analogous to dealing with precoordinated vs. postcoordinated concepts in biomedical ontologies. MODEL DESCRIPTION: The authors describe an approach based on ontological metadata mapping rules defined with elements of a global vocabulary, which allows a query specified at one granularity level to fetch data, where possible, from databases within the federation that use different granularities. This is implemented in OntoMediator, a newly developed production component of our previously described Query Integrator System. OntoMediator's operation is illustrated with a query that accesses three geographically separate, interoperating databases. An example based on SNOMED also illustrates the applicability of high-level rules to support the enforcement of constraints that can prevent inappropriate curator or power-user actions. SUMMARY: A rule-based framework simplifies the design and maintenance of systems where categories of data must be mapped to each other, for the purpose of either cross-database query or for curation of the contents of compositional controlled vocabularies.
OBJECTIVE: To devise an automated approach for integrating federated database information using database ontologies constructed from their extended metadata. BACKGROUND: One challenge of database federation is that the granularity of representation of equivalent data varies across systems. Dealing effectively with this problem is analogous to dealing with precoordinated vs. postcoordinated concepts in biomedical ontologies. MODEL DESCRIPTION: The authors describe an approach based on ontological metadata mapping rules defined with elements of a global vocabulary, which allows a query specified at one granularity level to fetch data, where possible, from databases within the federation that use different granularities. This is implemented in OntoMediator, a newly developed production component of our previously described Query Integrator System. OntoMediator's operation is illustrated with a query that accesses three geographically separate, interoperating databases. An example based on SNOMED also illustrates the applicability of high-level rules to support the enforcement of constraints that can prevent inappropriate curator or power-user actions. SUMMARY: A rule-based framework simplifies the design and maintenance of systems where categories of data must be mapped to each other, for the purpose of either cross-database query or for curation of the contents of compositional controlled vocabularies.
Authors: Luis Marenco; Nicholas Tosches; Chiquito Crasto; Gordon Shepherd; Perry L Miller; Prakash M Nadkarni Journal: J Am Med Inform Assoc Date: 2003-06-04 Impact factor: 4.497
Authors: Joel Saltz; Shannon Hastings; Stephen Langella; Scott Oster; Tahsin Kurc; Philip Payne; Renato Ferreira; Beth Plale; Carole Goble; David Ervin; Ashish Sharma; Tony Pan; Justin Permar; Peter Brezany; Frank Siebenlist; Ravi Madduri; Ian Foster; Krishnakant Shanbhag; Charlie Mead; Neil Chue Hong Journal: Stud Health Technol Inform Date: 2008