E-commerce System is an enormous and complex system, constituted by manysub systems. Include Front-end Selling System, Storage Management System, ERPSystem etc. and as users’ number is huge, all back-end databases is mainly deployedby Master-Slave architecture. As the website is running, many of issues just as wareslacking, wares oversell, storage lacking will appear, these issues hide in different subsystems and different databases. And in many situations, we must direct check andalter website`s real running data, but these data is very confidential and related withsystem’s stability. We can’t just grant these privileges to the common employees. So,in such situation, how to find the issues by monitoring the database’s data to noticethe employees, and how to make the employees can check and alter the running datain the premise of ensuring the security of database to find the issues and solve theseissues, is becoming a very valuable research subject.JM is a B2C company selling female cosmetics and luxury. this paper make JMcompany as an example of case, by analyzing e-commerce system’s sub systems andthe company`s departments, by analyzing the actual requirements and the website`srunning status, designed this data monitoring system. This system can monitor manydifferent data sources and different type of databases, when the data is not normal,this system will notice employees by sending emails and mobile messages. At thesame time, by limiting the row number of query results, special query and write SQLmust be approved and all of the operation will be logged, the system achieved the goalof ensuring the data security and satisfying the actual requirements.This system is based on Python Django framework and Linux Crontab. And beadopted in JM Company, by using this system, solved many issues such as stock out,not stable, response slow etc. improved user experience and the company`s revenue. |