E-commerce System Database Design And Dataaccess Optimization Technology Research

This article is based on “Donghua-Ciiigo Electronic business platform jointlaboratory” project—“Ciiigo electronic commerce system”, from system requirementsanalysis,system analysis,database analysis and design,data access flow analysis anddesign, data access technology optimization, describes the Ciiigo electronic businesssystem from design to implementation to optimization process, mainly talking aboutthe generation process of database and data access optimization based on SpringMVC framework.The innovation point of this article lie in: in the widely used electroniccommerce system, because the user query condition is very broad, and there are manyfuzzy query, so there will be lots of eligible query results. In order to quickly respondto user query, in the process of database design and access, in addition to establishreasonable indexing mechanism, also need paging processing of query results. Theelectronic commerce system development in this article is based on traditional SpringMVC framework, directly through the improvement of the framework for theimplementation of paging display, add the Bo layer on the traditional framework, itsmain role as the parameter package, to realize fast data transfer. In addition, this paperfrom the generation process of database, the business logic configuration, Dao layer,Service layer, Controller layer, Bo layer and Jsp layer and so on to specificallyelaborated the optimization of data access. Through the experimental analysis, compared with the traditional paging method, the method in this article has obviousadvantages in average response time, and relying on a good level of the structure, ithas strong portability advantages.As a member of the laboratory, I take part in the design and development work ofthe project, my main work in the project and the later stage research are summarizedas follows:1、Refer to the software development cycle, firstly, analyze the business modelof Ciiigo, and then design the requirement analysis, the outline design and the detaileddesign, complete the corresponding document for the reference of development. Secondly, carry on the system feasibility analysis, and determine the softwareenvironment and hardware environment of software development. Finally, overalldesign the system framework and code framework.2、Design the E-commerce system database, including use Rational Rose tools togenerate the system use case diagram, class diagram, sequence diagram and stagediagram and so on, a clear correlation between the entity classes and each classinvolved in the system, and then draw the system E-R diagram (entity relationshipdiagram), and then use database software Power Designer generates databaseconceptual model diagram, the physical model diagram, and ultimately generate SQLstatement, eventually running the SQL statement in the MySQL visualization tools,for generating system database.3、 Electric systems generally have a large amount of data, data accessrequirement of the character of high, combined the procurement network e-commercesystem, I put forward the improvement scheme, including (1) constructs a pictureserver through the NFS mode and Apache combination, and assigns domain names, sothat multiple Web servers can share pictures resources, ease of management;(2) makethe improvement to the traditional Spring MVC framework, adding Bo layer, its mainfunction is the data package, and for each design to achieve paging display method.Combination of the above two methods, to achieve efficient access to the data,compared with the traditional data access, data access time is shortened obviously.The electric system involved in network engineering, software development,software project management, database development, data access and other relatedknowledge, is a comprehensive use of various computer professional knowledge.The system has realized the online shopping and payment, and to continue toexplore new business models, to study the integration of cloud computing, the nextgeneration of e-commerce platform intelligence, logistics, mobile payments and othernew technologies to provide a relatively complete basic platform. Exploration for thedata access optimization technology of late, theoretical research combined with theactual development, has the instruction significance to continue to study the actualdevelopment of small and medium-sized electrical system.