Study On Control Technology Of Resources And Services Of E-commerce Platform

E-commerce typically facing the multi-user, via the Internet to provide users with a variety of applications software and services, its architecture is distributed, complex, most people use multiple database systems. In this context, resources refers to the database of the e-commerce platform, and services mainly refer to application services. Because of the complex database applications environment, and monitoring capabilities of the DBMS itself cannot meet the needs of applications, so the study of database system monitoring technology for this type of application is significant.The research is based on the small business inventory management platform, this is a B2B e-commerce platform, Users through the platform for goods and inventory management and related business, the information of a series of orders generated in the process are stored in the enterprise database. For the centralized monitoring of the operation of the database systems, they need to be unified monitoring, therefore the project need to study a multi-point monitoring programme, realize database monitoring for multiple database systems and application monitoring software, providing technical support for running the platform.The main work of database and application monitoring in the environment of multiple database systems include:(1) database monitoring:a, all database node of run situation monitoring. b, user monitoring, c, tablespace monitoring, d, the database file I/O read and write monitoring. e, database tablespace lock monitoring. f, database objects monitoring. g, alarm log.(2) application software monitoring:application software log monitoring.Database monitoring section realize by reading the routing tables, system tables, system views, and saving the read data in related tables at the specified time, display to user by organization charts, or pie charts, line graphs, and other forms. Cross-database across multiple database operations primarily implemented through DBLINK, in order to achieve simultaneous monitoring of multiple database performance.Application software monitoring section realize by reading the application system log after a simple analysis and sorted out the SQL statement that failed, in order to make backstage management personnel to easily view the operation of the software. This monitoring system provides a security measure for the normal running of small business invoicing management platform in a cloud environment. Detecting each database performance timely in multi-database environment makes it easy for the system administrator to view the running status of each database. By closely monitoring the individual operation of the database allows the system administrator to deal with common problems of database performance and management at the right time. The system administrator can also monitor the application software’s running, discover common problems during operation, find ways to resolve these problems.