Study And Design On Rolling Date MIS In Tandem Cold Rolling

Enterprise Management Information System (MIS) is one of the new technologies developed rapidly in the computer area in resent years. MIS plays a crucial part in making corporation key decisions, daily work and basic control. The real-time management in produce process is the important part of MIS. Based on the 1370 five-stand pickled tandem cold rolling mills of a certain accurate strip steel Cor., this paper studies the data steam and relationship of the produce process and founds a produce process data management information system.After understanding the produce states of the 1370 five-stand pickled tandem cold rolling mills, this paper studies the data steam and relationship of the produce process; analyses two database research models which are client/server and browser/server comparably. The client/server model MIS design scheme is proposed and the functions of client/server are determined. Analyzing the data steam and relationship in rolling, the database conception model is built. Abstract and Change the exact data collected from rolling process into substance and property of information world, and display them by E-R charts. By studying the logic structure of database and substance of as well as transform of relationship in E-R charts, a way to build database logic model that setting auto-add field as substance code in the substance is put forward. On this basis, the database store method and store structure are analyzed and database structure for application is founded.Using VB language and ADO technique, the function blocks of rolling data management are realized. And the system is tested by practice. Steel thickness data recorded in the database is analyzed into mathematical statistics and printed by normal distribution. By this statistical regulation a real-time data collecting method is proposed, which is prepared for the rolling mill model self-study.