Taylor D, Naguib R N G, Boulton S
BIOCORE, School of Mathematical and Information Sciences, Coventry University, Coventry CV1 5FB, U.K.
IEEE Trans Inf Technol Biomed. 2004 Sep;8(3):298-305. doi: 10.1109/titb.2004.832541.
The traditional approach to relational database design is based on the logical organization of data into a number of related normalized tables. One assumption is that the nature and structure of the data is known at the design stage. In the case of designing a relational database to store historical dental epidemiological data from individual clinical surveys, the structure of the data is not known until the data is presented for inclusion into the database. This paper addresses the issues concerned with the theoretical design of a clinical dynamic database capable of adapting the internal table structure to accommodate clinical survey data, and presents a prototype database application capable of processing, displaying, and querying the dental data.
关系型数据库设计的传统方法是基于将数据逻辑组织成多个相关的规范化表。一个假设是在设计阶段数据的性质和结构是已知的。在设计一个关系型数据库来存储来自个体临床调查的历史牙科流行病学数据的情况下,直到数据被提交以纳入数据库时,数据的结构才会知晓。本文讨论了与能够调整内部表结构以适应临床调查数据的临床动态数据库的理论设计相关的问题,并展示了一个能够处理、显示和查询牙科数据的原型数据库应用程序。