While the use of database technology is ubiquitous throughout IT (and health IT in particular), it is not generally appreciated that, as a database increases in scope, certain designs are far superior to others. In biomedical domains, new knowledge is being generated continually, and the databases that must support areas such as clinical care and research must also be able to evolve while requiring minimal or no logical / physical redesign. Appropriately designed metadata, and software designed to utilize it effectively, can provide significant insulation against change. Many of the larger EMR or clinical research database vendors have realized this, but their designs are proprietary and not described in the literature. Consequently, numerous misconceptions abound among individuals who have not had to work with large-scale biomedical systems, and graduates of a health or bioinformatics program may find that they need to unlearn what they were taught in database and software design classes in order to work productively with such systems. A working knowledge of such systems is also important for individuals who are not primarily software developers, such as health informaticians, medical information officers and data analysts. This book is, in a sense, intended to prepare all of the above individuals for the real world.

While the use of database technology is ubiquitous throughout IT (and health IT in particular), it is not generally appreciated that, as a database increases in scope, certain designs are far superior to others. In biomedical domains, new knowledge is being generated continually, and the databases that must support areas such as clinical care and research must also be able to evolve while requiring minimal or no logical / physical redesign. Appropriately designed metadata, and software designed to utilize it effectively, can provide significant insulation against change. Many of the larger EMR or clinical research database vendors have realized this, but their designs are proprietary and not described in the literature. Consequently, numerous misconceptions abound among individuals who have not had to work with large-scale biomedical systems, and graduates of a health or bioinformatics program may find that they need to unlearn what they were taught in database and software design classes in order to work productively with such systems. A working knowledge of such systems is also important for individuals who are not primarily software developers, such as health informaticians, medical information officers and data analysts. This book is, in a sense, intended to prepare all of the above individuals for the real world.