International Journal of Engineering and Manufacturing (IJEM)
IJEM Vol. 1, No. 2, 8 Apr. 2011
Cover page and Table of Contents: PDF (size: 147KB)
Database Design of a General Data Analysis System of Commodity Sales Information
Full Text (PDF, 147KB), PP.21-27
Views: 0 Downloads: 0
Author(s)
Wang Guan
1,*
Wang Xiaolu
1
Index Terms
Database design, data analysis, user customization
Abstract
A data analysis system for the general commodity sales information is researched on and further designed. The key problems of designing this system are that, it should enable the system to adjust to user-data with different structures, enable users to define or change data structures as well as retrieval methods. Through the research on the general structure and retrieval method of the commodity sales data, the system realizes users' customization of the database, thus is applicable to sales data with different structures. This paper focuses on the structure of the database, the creation method and process of the database by the user, the structure of the data dictionary and data exchange between database and software, with case examples in the final illustration.
Cite This Paper
Wang Guan, Wang Xiaolu,"Database Design of a General Data Analysis System of Commodity Sales Information", IJEM, vol.1, no.2, pp.21-27, 2011. DOI: 10.5815/ijem.2011.02.04
Reference
[1] Shari Lawrence Pfleeger, “Software engineering theory and practice”, 2001, pp195.
[2] Chun-ji Hao, “Converting a relation database into object automabily”, Microcomputer information[J], 2007,4-3，pp192-194.(in Chinese)
[3] Ren-peng Sun, “Design and implementation of universal dynamic query system based on system table” [J],Computer Engineering and Design, 2007,28-23，pp5819-582.(in Chinese)