| An increasing number of enterprises open online stores on different electronic commerce websites, and they need a management platform to provide a unified interface on reviewing the orders and arranging the delivery of goods. The systems of traditional ERP (Enterprise Resource Planning) providers are too complex and thus have long response time and low efficiency, which cannot meet the needs of the management of electronic commerce. On the other side, many new small-scale management systems designed for online stores cannot provide fast and efficient services for the merchants having a large number of orders because of the drawbacks in design.This thesis focused on the problems caused by the conflict and inconsistency of data in frequent concurrent database operations, and the problem that the pagination of large amounts of data is slow. The researches on the guarantee of the consistency of database operations, the optimization of data pagination, and the performance comparison tests in the electronic commerce operations were conducted. The main work was:(1) For the frequent pagination operations in the system, this thesis proposed the measure indicators to evaluate different database pagination methods, based on which the comparison among several typical pagination methods was conducted. Then this thesis proposed a pagination method based on equal join, which has outstanding performance on each of the indicators.(2) According to the use cases of the system, this thesis built a model to speed up the data access based on read/write separation, and applied it to the query and review of the orders and the display of the volume of sales.As for the synchronization issue, this thesis presented a two-phase check method to guarantee the consistency of data.(3) Based on the above theories, a real electronic commerce management platform was implemented, which provides functionalities such as reviewing orders, delivering goods optimally, generating electronic waybill, displaying the volume of sales and so on.By using the real order data to test the performance, this thesis proved that the equal-join-based pagination method and the read-write-separation-based data access model can bring remarkable performance improvements in the system with large amounts of data, so that the system can serve the users with high efficiency and low latency.Therefore, the management platform implemented based on these methods can meet the needs of the online retailers, and is highly valuable and promising for the future use. |
