Designing And Implementation Of Data Persistent Layer Frame Orient Manufacturing Execution System

Manufacturing Execution System is the basic technical skills implementing the agile manufacturing strategy and realizing the agile shop production. To distinguish with the general system, the process of constructing MES followed three design points: (1) a huge amount of data processing, real-time high performance requirements of extremely harsh. Through highly optimized SQL statements (or stored procedure) in order to achieve design performance targets.(2) diversification of the sources of data, different data, it should be able to provide a unified invoking interface, Maintain the portability and scalability of the system .(3) The data model of the system is rather complicated , under normal circumstances, not its arbitrary changes. In light of the three principles, based on the improved DAO design pattern of the SQL level mapping persistence layer framework is given out by this paper. This frame is better solving the MES Construction Data Acquisition and the exchange of system bottlenecks; improve the system's real-time performance; System scalability and maintenance management has been upgraded.Aiming at the particular industry application background of MES, this dissertation firstly analyzes and compares the various solving approaches of persistent layer in the current application. Then make a deep research for the methods of object relational mapping and its relevant mechanism of ORM, which refers to the existing outstanding persistent frame. The ORM implementing mechanism combined with the reference of the characteristics of the MES are used for reference by this paper. Then a persistent framework based on the SQL mapping is given out.Compare with the Hibernate, which provide a automatic ORM, realizing the mapping of POJO and database table and the auto-generation of SQL and implementation is concerned.The focus point of this paper lie on the mapping relation of pojo and SQL. Database operation in mapping documents to be defined so as the data storage logic can be independent from the top logic code, and the bottom of the SQL data manipulation can be configurable.This allows us to control the ultimate data operation.The best performance can be obtained through SQL optimazation.This reliance on automatic SQL generation which is refered to as automatic ORM mechanish is elusive. To improve the portability and scalability of the system, this paper introduced an improved DAO design pattern. Finally, the entire framework of achieving specific design for a detailed analysis. Some research results of the model of persistent framework orient Manufacturing Execution System has been put into practice in a manufacturing company.By improvement and optimization in practice, results are satisfactory. Our system's success can be used as referee in other enterprise. Practice also proved that the persistent layer framework based on sql mapping is valuable in practicability and valuable for further research and popularize.