Design And Implementation Of The Data Service System For Production Management

With the increasing number of business types and the continuous expansion of business processing,the company has several kinds of client applications to handle different business processes on the current P3 production management platform(P3 platform is a business processing platform which integrates personalized custom product sales,production,delivery and financial processing).Each application queries data from the different background database or file server,and some file-based databases' data acquisition processes are slow,which seriously hinders the sharing efficiency of the background data,the efficient and flexible expansion of the company's business and the unified verification management of client programs.In this paper,a data service based on P3 platform was designed and implemented.Through this data service system,each client application can obtain all kinds of data in the background via a unified data access process.And this system is able to server client efficiently and make sure providing data service for a long time even if there are tens of thousands of clients connecting and requesting data concurrently.In order to solve the current problem of P3 production management platform in enterprise,after fully understood domestic and foreign researching status and analyzed related technologies,the targets of this data service was determined.Firstly,a high concurrent I/O event handling module was designed by using Windows kernel IOCP mechanism,which can respond quickly for the network or the file I/O events.The module has a thread pool with configurable thread number to handle the business workflow in parallel for the completed I/O event.Secondly,the data cache module was designed to cache the database query records for the client applications.When the cache exceeded the setting value or a cache item was got invalid,this module will use the corresponding strategy to clear the cache records in real time.Thirdly,the unified data process module was designed.This module uses a unified interface to access the data of the background database or the file server,so that the client can obtain the background data in a unified way.Finally,the master and standby service module was designed for this system.Normally,the master service provides the data service for the client applications,and the standby service periodically checks the availability of the master service.When the master service is not available,the standby service will switch to the master service in time and provides the data service for all clients.Each design module was implemented by using object-oriented C++ language,and then some tests were done for this implemented service system.The client applications can access all kinds of background data in a unified way.And for the cached data query,the response speed of the requested data is significantly faster than that of the query without the cache.When the system has 12,000 simulated clients requesting data concurrently,this service can still provide the service to the clients efficiently and quickly.When the network of master service is disconnected or the master service is shut down,the standby service can immediately switch to the master service state and provide stable service to the clients.Through the research and application of the hot technologies,this research not only solves the problems of P3 production management platform,but also provides a good support for the expansion of business in the future.