Abstract: The transition in the treatment and the hospitals care from a single process into continuous and recorded progress has highlighted the importance of the clinical management systems. Although, the paper-based recording operations can manage clinical data and save them they are complicated and unreliable. Therefore, computerizing these processes in a central database is crucial in order to extract beneficial information and follow the patients status. The difficulty in defining requirements of the medical organization previously has brought a difficulty in building a stable system with the conventional database schemas. In this regard, the proposed system challenges these difficulties through presenting a reliable and flexible solution for such organizations to manage their data efficiently by a dynamic database schema that can manage multiple hospitals centrally with high flexibility. For this purpose, Entity-Attribute-Value (EAV) modeling technique has been adopted to build a flexible database with the schema that satisfying demands of the hospitals and their ever-changing requirements. In this approach, data from unlimited number of organizations (hospitals or medical centers) can be added to the system with different entities in the same database. Moreover, centralizing the data repositories of clinical operations has a significant role in enhancing the hospitals care and improving the treatments quality in different ways. This research introduces a flexible system that is capable of overcoming the requirements variation and supporting the research field via building a practical and central data repository for the researchers.
Ali H. Al- Fatlawi, Basheer A. Al- Assadi and Mohammed H. Jabardi, 2015. Dynamic Database Schema for Hospital Management System. Asian Journal of Information Technology, 14: 122-128.