个人健康管理系统数据库的设计与实现

Design and Realization of Database for Personal Health Management System

摘要:

个人健康管理系统能够帮助人们获得大量有价值的健康信息,为了实现一款安全、高效的个人健康管理系统,在充分考虑用户实际需求的前提下,对该系统数据库进行了设计与实现；首先对系统数据库进行了全面的需求分析,然后进行概念结构设计,形成实体联系(E-R)图,并将(E-R)图进行逻辑结构的转换,根据三范式的要求形成数据关系表,同时,在设计过程中通过牺牲一定存储空间的反范式操作,来换取更加快速的查询速度；通过上述方法,最终设计并实现了一款个人健康信息数据库；该数据库能够满足个人健康管理系统的实际开发需求,并且保证系统的查询运行效率,让用户能够更加方便,快捷的使用该系统对健康数据进行管理,达到帮助用户获得更多、更有价值的健康信息的目的。

Abstract:

Personal health management system can help people get a lot of valuable health information. In order to design a safe and efficient personal health management system, the paper designs and implements a database by giving full consideration to the actual needs of the users .The paper first analyses the demand of the system database and then devises the structures of concept and gets the entity relation diagram(E-R).Through the conversion of logical structure and according to the requirements of the 3 model to form a data relationship table. At the same time, in the design process, through the sacrifice of a certain storage space of the counter paradigm operation, in exchange for a more rapid query speed. Finally, a personal health information database is designed and implemented. The database can meet the actual development needs of personal health management system, and ensure the system query efficiency. Allowing users to more convenient and efficient use of the system to the management of health data and get more valuable health information.