Integrating terminologies into standard SQL: a new approach for research on routine data

Background Most electronic medical records still contain large amounts of free-text data. Semantic evaluation of such data requires the data to be encoded with sufficient classifications or transformed into a knowledge-based database.