Metadata-driven Software Systems in Biomedicine: Designing Systems that can adapt to Changing Knowledge [Hardcover]

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.

1. What is metadata? Types of metadata.- Descriptive (interpreted by humans).- Technical (utilized by software).- Some metadata shows characteristics of both.- How metadata is represented.- Why use metadata to build biomedical systems? Caveat: Metadata-driven systems are initially harder to build, Building for change: flexibility and maintainability, Elimination of repetitious coding tasks, Case Study: Table-driven approaches to software design.- 2. Metadata for supporting electronic medical records.- The Entity-Attribute-Value (EAV) data model:.- Why EAV is problematic without metadata-editing capabilities:l#*