title: Integration of Web-based and PC-based clinical research databases.
abstract: We have created a Web-based repository or data library of information about measurement instruments used in studies of multi-factorial geriatric health conditions (the Geriatrics Research Instrument Library - GRIL) based upon existing features of two separate clinical study data management systems. GRIL allows browsing, searching, and selecting measurement instruments based upon criteria such as keywords and areas of applicability. Measurement instruments selected can be printed and/or included in an automatically generated standalone microcomputer database application, which can be downloaded by investigators for use in data collection and data management.
  
  
  METHODS
  Integration of database applications requires the creation of a common semantic model, and mapping from each system to this model. Various database schema conflicts at the table and attribute level must be identified and resolved prior to integration. Using a conflict taxonomy and a mapping schema facilitates this process.
  
  
  RESULTS
  Critical conflicts at the table level that required resolution included name and relationship differences.
  
  
  CONCLUSIONS
  A major benefit of integration efforts is the sharing of features and cross-fertilization of applications created for similar purposes in different operating environments. Integration of applications mandates some degree of metadata model unification.
authors.affiliation: Center for Medical Informatics, Yale University School of Medicine, 300 George St, Suite 501, New Haven, CT 06511, USA. cynthia.brandt@yale.edu
authors.forename: C A
authors.initials: CA
authors.lastname: Brandt
authors.forename: K
authors.initials: K
authors.lastname: Sun
authors.forename: P
authors.initials: P
authors.lastname: Charpentier
authors.forename: P M
authors.initials: PM
authors.lastname: Nadkarni
mesh_terms: D000368:Aged; D035843:Biomedical Research / Q000458:organization & administration*; D003628:Database Management Systems; D005853:Geriatrics; D006801:Humans; D016247:Information Storage and Retrieval; D020407:Internet; D008838:Microcomputers; D018511:Systems Integration; D017432:Unified Medical Language System; D014481:United States; D014584:User-Computer Interface