基于Web的用户自适应关系模型的设计及应用

Design and Application of User-Adaptive Relationship Model Based on Web

Web开发过程中,固定的数据库关系模型设计往往难以满足数据库应用系统中多变的用户需求;本文提出一种用户自适应关系模型,利用主、从两个静态关系表来实现数据库动态表结构,主表用于存储用户自定义关系表信息,从表则用于存储所有用户自定义数据;利用该关系模型设计的数据库应用系统中,用户仅通过Web浏览器即可自定义数据类型和动态管理数据,从而在一定程度上实现了用户需求变化的自适应;以烟草业的数据共享平台为例,说明了模型的使用方法,实际应用结果表明该模型显著提高了数据库应用系统的用户适应性,改善了Web站点的性能。

During the process of WEB development,the fixed database relational model often struggles to meet the changing needs of users in database application system(DAS).To achieve the dynamic structure of DB table,we present a user-adaptive relational model which adopts two static DB tables– master and slave.In this structure,the master table is used to store the user custom relational table information,while the slave to store all user-defined data.In the DAS which exploits this relational model,users can customize the data type and perform dynamic data management.Thus it,to some extent,realizes the adaptation of users’changing needs.We illustrate the use of this model with the Data Sharing Platform in tobacco industry.The practical results show that the user adaptability to DAS and the performance of WEB sites have obvious improvement.