Research And Implementation Of Hybrid Data Storage Scheme For E-Commerce Platform

The development of network and the popularization of Internet application promote the rapid development of e-commerce platform.People are inured to useing e-commerce platform.With more and more users,the access speed of the platform begins to decline.In order to improve the performance of e-commerce platform,many e-commerce platform not only use relational database,but also use non relational database for data storage.In view of this situation,this topic proposes a hybrid storage scheme for e-commerce platform,which has certain practical significance for multi database access and heterogeneous data storage and access of e-commerce platform.First of all,this paper describes the development status of data storage in e-commerce platform at home and abroad,and summarizes the problems caused by the mixed use of relational and non relational databases.Therefore,the technical characteristics and visitor mode of relational database and non relational database are studied.At the same time,this paper analyzes three ways of heterogeneous data source query,and points out that independent middle tier is more suitable for e-commerce platform.Secondly,the storage characteristics of e-commerce platform are analyzed,and the principle of hybrid storage of e-commerce data is proposed.According to this principle,the hybrid storage model of e-commerce platform is designed,and a hybrid storage software model is established.The design of SQL parsing module,SQL routing module,data execution module,result set merging module and metadata module of the software model are introduced in detail.Thirdly,combined with the mixed storage model of e-commerce platform,the mixed storage scheme of e-commerce platform is realized.Then,the main functions of SQL parsing module,SQL routing module,database executor module,result set merging module and metadata module are realized,and the implementation ideas and key functions are given.The implementation of syntax tree module and parsing module in SQL parsing are introduced in detail.Finally,according to the hybrid storage model,the data storage layer of Shengle ticketing platform is modified.Taking the related functions of enterprise as an example,this paper summarizes the different types of SQL statements generated by different functions in the execution process,the API called,the intermediate results of execution,and the processing and merging results,and verifies the superiority of the hybrid storage scheme compared with the original Shengle ticketing platform.