An Applicaton And Research Of Relational Database And NoSQL In E-commerce Platform

All along,the data storage and operating e-commerce platform is occupied by a relational database.But the rapid development of Internet technology is accompanied by massive data growth,vast amounts of data so that the handling of data,processing speed have undergone tremendous changes,e-commerce site is heavily influenced by big data,the traditional relational database In the face of mass data storage inquiries already looks bloated.For lack of a traditional relational database applications in modern e-commerce platform,the paper proposes a relational database and non-relational databases(NoSQL)work together,ananize the feasibility of this approach and to design database based on MySQL and MongoDB e-commerce system.According to the test and operation indicates that the e-commerce system performance and stability,high concurrent load views,query rates than traditional relational database is high,easy to expand,basically meet the design requirements.The paper mainly do the following:Firstly,compared to the traditional features of a relational database and NoSQL databases,analyze their data storage capacity and the ability to failover extended partition copy.Second,e-commerce system,for example,are designed for storage MySQL relational databases and non-relational database MongoDB product attributes,comparative analysis of the advantages and disadvantages of both stores.Third,Comparative analysis of different databases and MySQL MongoDB database transaction in the electricity business platform and explain for relatively high demand in transactional systems,MongoDB is not the best choice.Forth,test MySQL database and MongoDB performance data in different circumstances query,concluded that large amounts of data under circumstances,MongoDB query efficiency higher than many MySQL.