采用动态数据库结构的产品管理技术

A Manage Technology of Product that Based on the Dynamic Database Structure

本文提出采用树状关系组织产品分类和建立产品数据库关系模型,按照无穷级概括映射规则设计产品分类的超类表和子类表,在防止约束循环的前提下建立约束关系等规则,并按上述规则开发动态数据处理器,通过Web方式操作动态数据处理器来设计、修改产品数据库结构和管理产品数据。在用户通过Web按自己的实际需求管理产品分类和产品数据的同时,动态数据处理器同时完成数据库结构的改动和处理所有的数据,完全实现通过Web方式管理产品;从而解决在电子商务网站及基于Web的PDM设计中,用固定的数据库结构难以适应产品种类的改变,难以详尽反映产品特征,数据库维护难度大的问题,使数据冗余更少,适用范围更广,用户界面更加良好。

This paper puts forward organizing products＇ class and establishing relation model of product database based on the tree structure, designs superclass table and childclass table of products＇ class according to mapping rule of infinite tier generalizing, restrict relation on the basis of avoiding restrict circle used these rules to developing dynamic database processor, realizes design, modification and data＇s management of product database structure by operating dynamic data processor through Web mode.Dynamic Data Processor completing modification of database structure and handling all of the datum When the customers managing products＇ class and product datum in the light of their practical need through Web mode, The method realizes to manage product by Web mode entirely, and resolves the problems caused by the static database structure such as： difficult to suit for the change of the products＇ class, difficult to represent the products＇ details and difficult to maintenance or manage the database in e-commerce website or PDM design based on Web. Consequently the software contains more efficiency; more suitability and the User Interface are more favorable.