Adaptive changes in product attribute database design and access of goods
Sun Ren-peng · Jisuanji gongcheng yu sheji · 2011
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.