Research And Development Of Data Platform In Manufacturing Informationalization Based On Domestic Database Systems

This thesis analyzes the development course and state of art of data platform at home and abroad at first, then describes the current status of the application of general data platform in the field of manufacturing informationalization based on domestic database systems. The author digs deeply into the survey and characteristic of relevant technology and products. Development trend in new technology goes on and studies at the same time, such as idea of software platform, new data processing methods in the field of manufacturing informationalization, development and maturity of domestic database systems, which exert the new influence to the framework of general platform. After analyzing and describing overall function goal and capability target of the general data platform in manufacturing informationalization based on domestic database systems, this thesis puts forward a set of solution for general data platform. The platform framework is based on platform engine, and adopts general data template in memory to implement the management and operation of heterogeneous database systems. General data template which is implemented in memory to promote efficiency of data processing is designed to eliminate the differences of heterogeneous database systems. The conversion of stored procedure of heterogeneous database systems is put forward, which is based on a kind of neutral language called KMSQL. KMSQL is designed to support conversion of stored procedure of heterogeneous database systems. Data file template is implemented to store and transform data of heterogeneous database systems. The two-tier privilege administration architecture: user--privilege is not adapted to manufacturing enterprises, because there are too users and privileges to maintain, so the three-tire architecture: user—role—privilege is adopted ease the redundant and bored privilege configuration. Prototype of the general data platform is implemented and the general data platform software has been used in several manufacturing enterprises, which verifies the feasibility of the systematic framework and realization tactics presented before. At last, development of the subject is looked forwarded to and the research focal point in the future is put forward.