自适应商品属性变化的商品库设计与访问研究

Adaptive changes in product attribute database design and access of goods

为了使系统能够适应因商品种类的变化而带来的商品属性的变化,提出了动态生成自适应的商品表和动态生成数据访问SQL语句的设计思路。在深入研究江苏苏泽电子商务业务需求的基础上,将不同种类商品表的具体设计交给用户完成,系统只需提供统一的商品表结构设计的客户端界面,而商品数据录入界面将根据对应表结构动态生成,软件与具体的商品表结构相分离,不会因为商品属性的变化而需要进行系统的维护,相对通用。对商品表的访问采用动态SQL语句,所需的主要参数从界面和用户数据字典中提取。该研究在实践中得到良好的应用,节省了大量后期维护成本。

In order to make system adapt the change for commodity characteristic caused by the type, design ideas about dynamically generated commodity list and dynamic adaptive data access SQL statement are presented. A depth study is made in accordance with the e-commerce business requirements for Jiangsu Suze Co., Ltd. detailed design about different commodity can be finished by user, and client interface shall be provided by the system, yet inputting data interface for commodity property can be dynamically generated in ac- cordance with corresponding database structure, thus software and detailed database structure are divided, and system needn＇t be main- tained if there is any change for commodity property because of its relatively general function. The dynamic SQL statement is used for database access, and the required parameters can be got from user＇ s data dictionary. This research has been successfully put into service, and lots of post-maintenance costs are reduced.