Informatization system building method for improving system safety and reducing system load

Abstract

The invention relates to an informatization system building method for improving system safety and reducing system load, and the method comprises the steps: building a real-time synchronization database of an informatization production system through employing a database one-way real-time synchronization technology; establishing application systems, such as data reports, analysis, mining and APPs, which do not need to modify business data on the basis of the synchronous database; and the production database only serves business personnel operating business data, other business systems having data exchange with the production system and a production line automation system having data exchange with the production system, so that the data processing pressure of the informatization production database is shared, and meanwhile, because the synchronous database is a one-way read-only database, the data processing efficiency is greatly improved. The system not only can be used as a real-time backup system of the production database, but also can be quickly put into use as a standby database when the production database breaks down, the availability and safety of an informatization system are improved, finally, the safety of the enterprise informatization system is improved, and the system load is reduced.

Description

Technical Field

[0001] This patent application belongs to the field of information technology in the metallurgical industry, and more specifically, it relates to a method for building an information system that improves system security and reduces system load. Background Art

[0002] In the steel manufacturing industry, with the deepening of intelligent manufacturing construction, the number of enterprise information systems is increasing, the amount of data stored and processed by information systems is growing rapidly, and the role of information systems in enterprise production and operation is becoming more and more important. If the information system service is abnormally terminated, stuck, or data is lost, it will cause huge losses to the production and operation activities of the enterprise, and even production and operation activities will be forced to stop, which is an unbearable price. How to ensure the data security and efficient operation of important enterprise information systems has become a problem that enterprises must solve in intelligent manufacturing construction and digital transformation. Summary of the invention

[0003] The technical problem to be solved by the present invention is to provide an information system construction method that improves system security and reduces system load, which can improve the availability and security of the information system, ultimately improve the security of the enterprise information system and achieve the goal of reducing system load.

[0004] In order to solve the above problems, the technical solution adopted by the present invention is: A method for building an information system to improve system security and reduce system load, comprising the following steps: Step S1, while building the production database of the enterprise information system, use the database real-time synchronization technology to build a synchronization database that synchronizes data with the enterprise information system in real time and in one direction; Step S2, multiple sets of information systems related to the enterprise information system need to be classified, and the data sources of the enterprise information systems that do not need to add, delete, or modify the production database are directed to the synchronization database; Step S3, directly pointing the data communication port of the enterprise information system or automation system that needs to add, delete, or modify data in the production database to the production database; Step S4, when a failure occurs in the production database of the enterprise information system causing data loss, the data in the synchronization database can be used as backup data of the production database of the information system; Step S5: When the production database of the enterprise information system fails and cannot provide external services, the synchronization database can be used as a backup database of the enterprise information system to replace the production database to provide services.

[0005] Furthermore, in step S1, the synchronization database is built using the ADG technology of the ORACLE database, the synchronization method uses the performance priority mode, and the synchronization database is in read-only mode.

[0006] Further, in step S2, the classification basis for the classification of the multiple information systems is: The first type of information system is the information system responsible for the company's main production and operation business, including: ERP (Enterprise Resource Planning) system, production and sales system, MES (Manufacturing Execution System), QMS (Quality Management System), logistics management system, and energy management system; The second type of information system is other application systems developed on the basis of production and operation data as raw data, including: various reporting systems, cost analysis systems, quality analysis systems, large-screen monitoring systems, quality assurance systems, various data query systems, and various mobile phone APP systems for data query and analysis; The data communication ports involved in data exchange between the first type of information systems directly point to the production database and are not carried out in the synchronization database; The second type of information system can point the data source to a synchronous database, and regularly extract relevant production and operation original data from the synchronous database and write it into their respective databases according to various business needs. The original data can then be processed and displayed to relevant users based on the functional requirements to be implemented.

[0007] Furthermore, when the second type of information system periodically extracts data from the synchronous database, the extraction frequency and the amount of data extracted are restricted, and the extraction frequency is hourly (extracted once every hour), class (extracted once every 8 hours) or daily (extracted once every 24 hours).

[0008] Further, in step S3, the database interface method involved in the data communication between the production databases is carried out in the form of an intermediate table or a message; When actual changes occur in the production database and a redo log is generated, it is sent to the synchronization database for data synchronization.

[0009] Further, step S4 includes the following steps: Step S401: When the software or hardware of the production database is damaged, resulting in the loss of all or part of the data, the lost data can be found in the synchronization database and re-imported into the production database; Step S402: If the data in the production database is lost due to an erroneous operation, the data in the synchronization database may have been deleted synchronously due to the real-time data synchronization method, and data recovery is impossible.

[0010] Further, step S5 includes the following steps: Step S501: If the production server cannot resume service in a short time due to software or hardware failure or virus infection, the synchronization database can be used as a standby database to replace the production database to quickly resume the application; Step S502: If the production database system needs to be repaired, patched, upgraded, etc., in order to avoid the application system being out of service for too long, the synchronization database can be temporarily switched to the production database to provide services during the production database maintenance period; Step S503, when switching the synchronization database to the production database, it is necessary to first stop the data synchronization service between the production database and the synchronization database, and then change the synchronization database from read-only mode to read-write mode; Step S504, the database connection address of the application server, interface server, and real-time communication server needs to be changed from the production server to the address of the synchronization database; Step S505: After the production database server completes the maintenance and recovery of the database function, a time period is selected in which the application can be stopped, and the services of the production database and the synchronization database and the data synchronization service between them are stopped at the same time. The production database is changed to read-write mode, the synchronization database is changed to read-only mode, and the one-way data synchronization service from the production database to the synchronization database is started, so that the production database and the synchronization database maintain data consistency; Step S506, start the external services of the production database and the synchronization database, and redirect the database connections of the application server, the interface server, and the real-time communication server to the address of the production database.

[0011] Due to the adoption of the above technical solution, the beneficial effects achieved by the present invention are: The present invention uses database unidirectional real-time synchronization technology to build a real-time synchronization database for the information production system, and then uses the synchronization database as a basis to build application systems such as data reporting, analysis, mining, and mobile APP that do not require modification of business data. The production database can only serve business personnel who operate business data, other business systems that exchange data with the production system, and production line automation systems that interact with the production system. Therefore, the synchronization database can share the data query, extraction and processing pressure of the production database. At the same time, since the synchronization database is a unidirectional read-only database, the synchronization database can become a real-time backup system for the production database, and can also be quickly put into use as a standby database when a production database fails, thereby improving the availability and security of the information system, and ultimately improving the security of the enterprise information system and achieving the goal of reducing the system load. BRIEF DESCRIPTION OF THE DRAWINGS

[0012] Figure 1 is a system architecture diagram of the present invention; Figure 2 It is a flowchart of switching the synchronous database to the production database; Figure 3 Is a flowchart for restoring a production database. DETAILED DESCRIPTION

[0013] The present invention is further described in detail below with reference to the embodiments.

[0014] A method for building an information system to improve system security and reduce system load, specifically comprising the following steps: Step S1, while building the production database of the enterprise information system, use the database real-time synchronization technology to build a database system that is synchronized with the enterprise information system in real time and in one direction; Step S2, the information systems related to the information system need to be classified, and the data sources of the information systems that do not need to add, delete, or modify the production database are directed to the synchronization database; Step S3, directly pointing the data communication port of the information system or automation system that needs to add, delete, or modify data in the production database to the production database; Step S4, when a failure occurs in the production database of the information system causing data loss, the data in the synchronization database system can be used as backup data of the production database of the information system; Step S5: When the production database of the information system fails and cannot provide external services, the synchronization database can be used as a backup database of the information system to replace the production database to provide services; The step S1 includes the following steps: Step S101, this method is mainly applicable to information systems with large business data volume, busy transaction processing, frequent data interaction with external systems, important system data, and high data mining value. Small-scale information systems generally do not use this method; Step S102, when building a synchronization database, a one-way data synchronization technology is generally used (this method uses the ADG technology of the ORACLE database in actual application), and the synchronization method selects the performance priority mode to ensure that the performance of the production database will not affect the data processing efficiency due to data; Step S103, the synchronization database is in read-only mode, and other systems or users are not allowed to modify, add, or delete data in the database. The synchronization database provides data extraction and query services to the outside.

[0015] like Figure 1, showing multiple user terminals, an application publishing server connected to the multiple user terminals, a production database connected to the application publishing server, a data interface server and a real-time communication server connected to the production database, other business systems connected to the data interface server, and an automation PLC connected to the real-time communication server.

[0016] In addition, there is also a synchronization database that provides real-time one-way data synchronization services with the production database. The synchronization database is connected to reporting services, WEB data publishing services, data mining services, mobile APP services, etc.

[0017] The step S2 includes the following steps: Note: In each sub-step of step S2, it is assumed that the enterprise has built multiple information systems according to the needs of business management, and has achieved the interconnection between various information systems, and the interconnection between the information system and the automation system; Step S201, the main basis for system classification is: the first category is the information system responsible for the company's main production and operation business, mainly including: ERP (Enterprise Resource Planning) system, production and sales system, MES (Manufacturing Execution System), QMS (Quality Management System), Logistics Management System, Energy Management System, etc. The second category is other application systems developed on the basis of production and operation data as original data, mainly including: various reporting systems, cost analysis systems, quality analysis systems, large-screen monitoring systems, quality assurance systems, various data query systems, various mobile APP systems for data query and analysis, etc.; Step S202, wherein the second type of information system can point the data source to the synchronization database, regularly extract relevant production and operation raw data from the synchronization database according to various business needs, write it into their own database, and then process and display the raw data to relevant users according to the functional requirements to be implemented; Step S203: In order to ensure the performance and security of the synchronization database, the second type of information system should try to reduce the extraction frequency and the amount of data extracted when extracting data to meet business needs; according to actual needs, the general extraction frequency is hourly (extract once every hour), class (extract once every 8 hours), daily (extract once every 24 hours), etc. Step S204: The synchronization database is in read-only mode, and the second type of information system should not attempt to modify, add or delete the data in the synchronization database.

[0018] The step S3 includes the following steps: Step S301, data exchange between the first type of information systems will generally affect each other's business data. For example, the order data of the ERP system will be converted into production orders in the production and marketing system, and the production orders of the production and marketing system will be decomposed into the MES system of each production line to form a production plan and save it in the MES system database. The MES system will feed back the production performance data of the production line to the production and marketing system and store it in the production and marketing system database. This type of communication mode requires the establishment of a communication interface between the production databases of each information system, and the data in each other's production databases are modified to truly record the actual business operations in the database. This type of data communication cannot be performed in a synchronous database; Step S302: Data communication between production databases is generally completed regularly by interface services according to business needs. The database interface can be carried out in the form of intermediate tables or messages. The communication frequency should not be too high, and the amount of data transmitted should not be too large. It is sufficient to meet business needs to reduce the load on the production database. Step S303: Data communication between production databases should not be sent to the synchronization database. Only when actual changes occur in the production database and redo logs are generated, data will be sent to the synchronization database for data synchronization. The step S4 includes the following steps: Step S401: When the software or hardware of the production database is damaged, resulting in the loss of all or part of the data, the lost data can be found in the synchronization database and re-imported into the production database; Step S402: If the data in the production database is lost due to misoperation, the data in the synchronization database may have been deleted synchronously due to the real-time data synchronization method, and data recovery is impossible. The step S5 includes the following steps: Step S501: If the production server cannot resume service in a short time due to software or hardware failure or virus infection, the synchronization database can be used as a standby database to replace the production database to quickly resume the application; Step S502: If the production database system needs to be repaired, patched, upgraded, etc., in order to avoid the application system being out of service for too long, the synchronization database can be temporarily switched to the production database to provide services during the production database maintenance period; Step S503, when switching the synchronization database to the production database, it is necessary to first stop the data synchronization service between the production database and the synchronization database, and then change the synchronization database from read-only mode to read-write mode; Step S504: Change the database connection address of the application server, interface server, and real-time communication server from the production server to the address of the synchronization database. The overall process is as follows: Figure 2 As shown; exist Figure 2 In the process, first shut down the external service of the production database, then shut down the one-way database synchronization service, change the synchronization database mode from read-only mode to read-write mode, and finally change the database connection address of the application server, interface server, and communication server to the address of the synchronization database.

[0019] Step S505: After the production database server completes the maintenance and recovery of the database function, a time period is selected in which the application can be stopped, and the services of the production database and the synchronization database and the data synchronization service between them are stopped at the same time. The production database is changed to read-write mode, the synchronization database is changed to read-only mode, and the one-way data synchronization service from the production database to the synchronization database is started, so that the production database and the synchronization database maintain data consistency; Step S506, start the external services of the production database and the synchronization database, and redirect the database connections of the application server, interface server, and real-time communication server to the address of the production database. The overall process is as follows: Figure 3 shown.

[0020] exist Figure 3 In the process, first change the production data to read-only mode, establish a one-way data synchronization server from the synchronization database to the production database, and achieve data consistency between the synchronization database and the production database. Then choose the right time to stop the application, close the external services of the production database and the synchronization database, change the status of the synchronization database to read-only mode, and change the status of the production database to read-write mode, thereby establishing a one-way database synchronization service from the production database to the synchronization database, and finally enable the external services of the production database and the synchronization database.

Claims

1. A method for building an information system to improve system security and reduce system load, characterized in that The following steps are involved: Step S1, while building the production database of the enterprise information system, use the database real-time synchronization technology to build a synchronization database that synchronizes data with the enterprise information system in real time and in one direction; Step S2, classifying multiple sets of information systems related to the enterprise information system, and directing the data sources of the enterprise information systems that do not need to add, delete, or modify the production database to the synchronization database; Step S3, directly pointing the data communication port of the enterprise information system or automation system that needs to add, delete, or modify data in the production database to the production database; Step S4, when a failure occurs in the production database of the enterprise information system causing data loss, the data in the synchronization database can be used as backup data of the production database of the information system; Step S5: When the production database of the enterprise information system fails and cannot provide external services, the synchronization database can be used as a backup database of the enterprise information system to replace the production database to provide services.

2. The method for building an information system for improving system security and reducing system load according to claim 1, characterized in that: In step S1, the synchronization database is built using the ADG technology of the ORACLE database, the synchronization method uses the performance priority mode, and the synchronization database is in read-only mode.

3. The method for building an information system for improving system security and reducing system load according to claim 1, characterized in that: In step S2, the classification basis for the multiple information systems is: The first type of information system is the information system responsible for the company's main production and operation business, including: ERP system, production and sales system, MES, QMS, logistics management system, energy management system; The second type of information system is other application systems developed on the basis of production and operation data as raw data, including: various reporting systems, cost analysis systems, quality analysis systems, large-screen monitoring systems, quality assurance systems, various data query systems, and various mobile phone APP systems for data query and analysis; The data communication ports involved in data exchange between the first type of information systems directly point to the production database and are not carried out in the synchronization database; The second type of information system can point the data source to a synchronous database, and regularly extract relevant production and operation original data from the synchronous database and write it into their respective databases according to various business needs. The original data can then be processed and displayed to relevant users based on the functional requirements to be implemented.

4. The method for building an information system for improving system security and reducing system load according to claim 3, characterized in that: When the second type of information system extracts data from the synchronous database regularly, the extraction frequency and the amount of data extracted are limited, and the extraction frequency is at the hourly, class or daily level.

5. The method for building an information system for improving system security and reducing system load according to claim 1, characterized in that: In step S3, the database interface mode involved in the data communication between the production databases is carried out in the form of an intermediate table or a message; When actual changes occur in the production database and a rewrite log is generated, it is sent to the synchronization database for data synchronization.

6. A method for building an information system for improving system security and reducing system load according to any one of claims 1 to 5, characterized in that: Step S4 includes the following steps: Step S401: When the software or hardware of the production database is damaged, resulting in the loss of all or part of the data, the lost data can be found in the synchronization database and re-imported into the production database; Step S402: If the data in the production database is lost due to an erroneous operation, the data in the synchronization database may have been deleted synchronously due to the real-time data synchronization method, and data recovery is impossible.

7. The method for building an information system for improving system security and reducing system load according to claim 6, characterized in that: Step S5 includes the following steps: Step S501: If the production server cannot resume service in a short time due to software or hardware failure or virus infection, the synchronization database can be used as a standby database to replace the production database to quickly resume the application; Step S502: If the production database system needs to be repaired, patched, upgraded, etc., in order to avoid the application system being out of service for too long, the synchronization database can be temporarily switched to the production database to provide services during the production database maintenance period; Step S503, when switching the synchronization database to the production database, it is necessary to first stop the data synchronization service between the production database and the synchronization database, and then change the synchronization database from read-only mode to read-write mode; Step S504, the database connection address of the application server, interface server, and real-time communication server needs to be changed from the production server to the address of the synchronization database; Step S505: After the production database server completes the maintenance and recovery of the database function, a time period is selected in which the application can be stopped, and the services of the production database and the synchronization database and the data synchronization service between them are stopped at the same time. The production database is changed to read-write mode, the synchronization database is changed to read-only mode, and the one-way data synchronization service from the production database to the synchronization database is started, so that the production database and the synchronization database maintain data consistency; Step S506, start the external services of the production database and the synchronization database, and redirect the database connections of the application server, the interface server, and the real-time communication server to the address of the production database.

Images