A method, apparatus, medium, and equipment for performance enhancement based on a dual-active system

Abstract

This application relates to the field of information system data management technology, and discloses a performance improvement method, apparatus, medium, and device based on a dual-active system. The performance improvement method includes: acquiring a primary production database; building a backup production database based on the primary production database; synchronizing data entry and / or modification operations in the primary production database to the backup production database in real time; acquiring a primary system for accessing the primary production database; building a backup system based on the primary system, the backup system being used to access the backup production database; and deleting data from the primary production database down to a second preset value when the data volume in the primary production database exceeds a first preset value. This application, through a dual-active design of the primary and backup production databases, can reduce the data storage volume of the primary production database and improve its system performance.

Description

Technical Field

[0001] This application relates to the field of information system data management technology, and in particular, to a method, apparatus, medium and equipment for performance improvement based on a dual-active system. Background Technology

[0002] As people's living standards continue to improve, steel consumption is also increasing. The consumption of steel for automobiles, home appliances, bridges, and pipelines continues to rise, and steel companies are constantly expanding their production scale. This expansion of production scale and the increasing efficiency of production lines are placing higher demands on the responsiveness of information systems.

[0003] The integrated production and sales localized deployment system (manufacturing management, in-plant logistics, production and sales equipment, energy management), including steelmaking PES, LIMS, hot rolling PES, tearing line PES, cold rolling PES, medium and heavy plate PES, feeding PES, material metering, energy metering, ironmaking MES, and labor protection systems, has experienced continuous growth in stored data, storage space usage, and performance degradation since its launch. The overall system response efficiency is declining, and the number of performance-related repair requests received by system maintenance personnel is continuously increasing, causing significant inconvenience to production and impacting efficiency. Therefore, it is imperative to utilize information technology to improve system operating efficiency, reduce the number of performance-related repair requests, and provide stable and efficient information system support for on-site production. Summary of the Invention

[0004] The purpose of this application is to provide a method, apparatus, medium and equipment for improving the performance of a dual-active system. The dual-active design of the primary production database and the backup production database can reduce the data storage volume of the primary production database and improve the system performance of the primary production database.

[0005] Other features and advantages of this application will become apparent from the following detailed description, or may be learned in part from practice of this application.

[0006] According to one aspect of the embodiments of this application, a performance improvement method based on a dual-active system is provided. The performance improvement method includes: obtaining a primary production database and building a backup production database based on the primary production database; synchronizing data entry and / or modification operations in the primary production database to the backup production database in real time; obtaining a primary system for accessing the primary production database and building a backup system based on the primary system, the backup system being used to access the backup production database; and deleting data from the primary production database to a second preset value when the amount of data in the primary production database exceeds a first preset value.

[0007] In some embodiments, when the operation of entering and / or modifying data in the primary production database is synchronized to the alternative production database in real time, the method includes: copying all data in the primary production database to the alternative production database; when the operation of entering and / or modifying data in the primary production database is executed, the alternative production database performs the same operation as the primary production database, so that the data entered and / or modified in the alternative production database is the same as the data entered and / or modified in the primary production database.

[0008] In some embodiments, when the primary production database performs data entry and / or modification operations, the alternative production database performs the same operations as the primary production database. The method includes: using data synchronization software GoldenGate to synchronize the data entry and / or modification operations of the primary production database to the alternative production database in real time.

[0009] In some embodiments, when the amount of data in the primary production database exceeds a first preset value, the amount of data in the primary production database is deleted to a second preset value. The method includes: when the amount of data entered into the primary production database exceeds the first preset value, stopping the entry of data into the primary production database and saving the data already entered into the alternative production database; deleting data in the primary production database in order from longest to shortest entry time; when the amount of data in the primary production database is the second preset value, stopping the deletion operation and continuing to enter data into the primary production database, while the alternative production database performs the same data entry operation as the primary production database.

[0010] In some embodiments, the primary production database includes multiple secondary primary production databases; the primary system includes multiple secondary primary production systems corresponding to the multiple secondary primary production databases; the alternative production database includes multiple secondary alternative production databases corresponding to the multiple secondary primary production databases; and the alternative system includes multiple secondary alternative systems corresponding to the multiple secondary alternative production databases.

[0011] In some embodiments, the plurality of sub-primary production databases are distinguished by entry time, by material type, or by contract specifications.

[0012] In some embodiments, when the amount of data in the primary production database exceeds a first preset value, the method further includes deleting the amount of data in the primary production database to a second preset value, and then using the alternative system to query the production data through the alternative production database.

[0013] According to one aspect of the embodiments of this application, a performance enhancement device based on a dual-active system is provided. The performance enhancement device includes: a backup production database module, used to acquire a primary production database and build a backup production database based on the primary production database; a real-time synchronization module, used to synchronize data entry and / or modification operations in the primary production database to the backup production database in real time; a backup system module, used to acquire a primary system for accessing the primary production database and build a backup system based on the primary system, the backup system being used to access the backup production database; and a storage space control module, used to delete data in the primary production database down to a second preset value when the amount of data in the primary production database exceeds a first preset value.

[0014] According to one aspect of the embodiments of this application, a computer-readable medium is provided having a computer program stored thereon, which, when executed by a processor, implements the performance improvement method as described in the above embodiments.

[0015] According to one aspect of the embodiments of this application, an electronic device is provided, including: one or more processors; and a memory for storing executable instructions of the processors, which, when executed by the one or more processors, cause the one or more processors to implement the performance improvement method as described in the above embodiments.

[0016] Compared with existing technologies, the significant advantages of the technical solution described in this application are as follows: This application deletes the data with the longest entry time in the primary production database and saves the same data in the backup production database, thereby improving the operating efficiency of the primary production database. Simultaneously, a supporting backup system is built for users to query and use in the backup production database. Through system dual-active operation, under the same conditions, the single-table query efficiency of 15 sets of system key business interfaces is improved by an average of 25%; the multi-table joint query efficiency is improved by an average of 13%, with an overall improvement of over 15%. It reduces the space resources of the primary production database by 1.2T, saving 200G of space resources per month in the future, improving the overall operating efficiency of the primary production database while saving on hardware expansion costs.

[0017] It should be understood that the above general description and the following detailed description are exemplary and explanatory only, and do not limit this application. Attached Figure Description

[0018] The above and other features and advantages of this application will become more apparent from a detailed description of exemplary embodiments thereof with reference to the accompanying drawings.

[0019] Figure 1 A flowchart of a performance improvement method according to an embodiment of this application is shown;

[0020] Figure 2 A simplified diagram of a performance enhancement device according to an embodiment of this application is shown;

[0021] Figure 3 A schematic diagram of the structure of a computer system suitable for implementing the embodiments of this application is shown;

[0022] Figure 4 A schematic diagram of a dual-active system architecture according to an embodiment of this application is shown. Detailed Implementation

[0023] Exemplary embodiments will now be described more fully with reference to the accompanying drawings. However, these exemplary embodiments can be implemented in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided to make this application more comprehensive and complete, and to fully convey the concept of the exemplary embodiments to those skilled in the art.

[0024] Furthermore, the described features, structures, or characteristics can be combined in any suitable manner in one or more embodiments. Numerous specific details are provided in the following description to give a thorough understanding of embodiments of this application. However, those skilled in the art will recognize that the technical solutions of this application can be practiced without one or more of the specific details, or other methods, components, apparatuses, steps, etc., can be employed. In other instances, well-known methods, apparatuses, implementations, or operations are not shown or described in detail to avoid obscuring various aspects of this application.

[0025] The block diagrams shown in the accompanying drawings are merely functional entities and do not necessarily correspond to physically independent entities. That is, these functional entities can be implemented in software, in one or more hardware modules or integrated circuits, or in different network and / or processor devices and / or microcontroller devices.

[0026] The flowcharts shown in the accompanying drawings are merely illustrative and do not necessarily include all content and operations / steps, nor do they necessarily have to be performed in the described order. For example, some operations / steps can be broken down, while others can be combined or partially combined; therefore, the actual execution order may change depending on the specific circumstances.

[0027] The technical solutions of the embodiments of this application are briefly described below:

[0028] According to some embodiments, such as Figure 1 As shown, this application provides a performance improvement method based on a dual-active system, the performance improvement method including:

[0029] Step 101: Obtain the primary production database and build a backup production database based on the primary production database;

[0030] Step 102: Synchronize the data entry and / or modification operations in the primary production database to the alternative production database in real time;

[0031] Step 103: Obtain the primary system for accessing the primary production database, and build a backup system based on the primary system. The backup system is used to access the backup production database.

[0032] Step 104: When the amount of data in the primary production database exceeds the first set value, the amount of data in the primary production database is deleted down to the second set value.

[0033] Based on the above embodiments, while the primary production database is entering data, the backup production database also synchronously enters the same data in real time. Similarly, while the primary production database is modifying data, the backup production database also synchronously modifies the same data in real time. When the amount of data in the primary production database exceeds a first preset value—meaning the primary production database is running out of storage—the amount of data in the primary production database is reduced to only a second preset value. When the primary production database deletes data, the backup production database does not delete data synchronously; instead, it saves all the entered data. The second preset value is less than the first preset value. Both the first and second preset values ​​can be set according to actual needs. In some embodiments, the second preset value is 30% of the total storage capacity, and the first preset value is 80% of the total storage capacity; in other embodiments, other settings may be used. When querying data, production data can be obtained by querying the backup production database. This application, through the active-active design of the primary and backup production databases, can reduce the data storage volume of the primary production database and improve its system performance.

[0034] To enable those skilled in the art to better understand this application, the following will be combined with Figure 1 The details of this application are described in detail.

[0035] According to some embodiments, in step 102, the operations of entering and / or modifying data in the primary production database are synchronized in real time to the alternative production database, the method includes:

[0036] Step 1021: Copy all data from the primary production database to the alternative production database;

[0037] Step 1022: When the data entry and / or modification operation of the primary production database is executed, the alternative production database performs the same operation as the primary production database, so that the data entered and / or modified in the alternative production database is the same as the data entered and / or modified in the primary production database.

[0038] According to some embodiments, in step 1022, when the data entry and / or modification operation of the primary production database is performed, the alternative production database performs the same operation as the primary production database. The method includes:

[0039] The data synchronization software Golden Gate is used to synchronize the data entry and / or modification operations of the primary production database to the alternative production database in real time.

[0040] According to some embodiments, in step 104, when the amount of data in the primary production database exceeds a first preset value, the amount of data in the primary production database is deleted to a second preset value. The method includes:

[0041] Step 1041: When the amount of data entered into the primary production database exceeds the first set value, stop entering data into the primary production database and save the data already entered into the alternative production database.

[0042] Step 1042: Delete the data in the primary production database in order from the longest entry time to the shortest entry time;

[0043] Step 1043: When the amount of data in the primary production database reaches the second set value, the deletion operation is stopped, and data continues to be entered into the primary production database. The alternative production database performs the same data entry operation as the primary production database.

[0044] Based on the above embodiments, when the amount of data entered into the primary production database exceeds the first set value, it means that the amount of data in the primary production database is too large and the primary production database is about to run out of storage. At this time, data entry into the primary production database is stopped, and the alternative production database also stops entering data along with the primary production database. At the same time, the alternative production database saves the data that has been entered.

[0045] When the primary production database contains too much data and is about to run out of storage, it is necessary to delete data from the primary production database until only a second set value remains. This application deletes data from the primary production database in descending order of entry time. However, when data is deleted from the primary production database, the alternative production databases are not deleted simultaneously.

[0046] The deletion operation stops when the amount of data in the primary production database is reduced to only the second set value. At this point, data can continue to be entered into the primary production database, or other operations can be performed, while the alternative production database performs the same operations as the primary production database.

[0047] According to some embodiments, such as Figure 4 As shown, the primary production database includes multiple secondary production databases;

[0048] The primary selection system includes multiple secondary primary selection systems corresponding to multiple secondary primary selection production databases;

[0049] The alternative production database includes multiple alternative production databases corresponding to multiple primary alternative production databases;

[0050] The alternative system includes multiple sub-alternative systems corresponding to multiple sub-alternative production databases.

[0051] Furthermore, the multiple primary production databases are differentiated based on entry time, material type, or contract specifications.

[0052] Based on the above embodiments, the multiple primary production databases can be respectively manufacturing management, in-plant logistics, steelmaking database, hot rolling database, cold rolling database, medium and heavy plate database, ironmaking database, LIMS, material metering database, feeding database, production and sales equipment, occupational safety equipment, occupational safety system, energy management, and energy metering, etc. The number of primary production databases can be set according to actual needs. The number of alternative production databases is the same as the number of primary production databases.

[0053] According to some embodiments, after deleting data from the primary production database to a second preset value when the data volume in the primary production database exceeds a first preset value, the method further includes:

[0054] The alternative system is used to query production data through an alternative production database.

[0055] Based on the above embodiments, when it is necessary to query historical data of the hot-rolled database, the corresponding alternative production database and the corresponding alternative system are located, and the alternative system is used to query the alternative production database. This method is also used to query the cold-rolled database, medium and heavy plate database, and ironmaking database.

[0056] This application deletes the oldest data entries in the primary production database and saves the same data in the backup production database, improving the operational efficiency of the primary production database. Simultaneously, a supporting backup system is built for users to query and access data from the backup production database. Through this dual-active system approach, under the same conditions, the single-table query efficiency of 15 sets of system key business interfaces is improved by an average of 25%; the multi-table join query efficiency is improved by an average of 13%, resulting in an overall improvement of over 15%. This reduces the primary production database's space requirements by 1.2TB, saving 200GB of space per month in the future, improving the overall operational efficiency of the primary production database while saving on hardware expansion costs.

[0057] The following describes an apparatus embodiment of this application, which can be used to execute the performance improvement method described in the above embodiments of this application.

[0058] Figure 2 A simplified diagram of a system active-active performance enhancement device 200 based on one embodiment of this application is shown. The performance enhancement device 200 includes:

[0059] The alternative production database module 201 is used to obtain the primary production database and build an alternative production database based on the primary production database.

[0060] The real-time synchronization module 202 is used to synchronize the data entry and / or data modification operations of the primary production database to the alternative production database in real time.

[0061] Alternate system module 203 obtains the primary system for accessing the primary production database, and builds an alternative system based on the primary system. The alternative system is used to access the alternative production database.

[0062] The storage space control module 204 is used to delete the amount of data in the primary production database down to a second set value when the amount of data in the primary production database exceeds a first set value.

[0063] Based on the above embodiments, while the primary production database is entering data, the backup production database also synchronously enters the same data in real time. Similarly, while the primary production database is modifying data, the backup production database also synchronously modifies the same data in real time. When the amount of data in the primary production database exceeds a first preset value—meaning the primary production database is running out of storage—the amount of data in the primary production database is reduced to only a second preset value. When the primary production database deletes data, the backup production database does not delete data synchronously; instead, it saves all the entered data. The second preset value is less than the first preset value. Both the first and second preset values ​​can be set according to actual needs. In some embodiments, the second preset value is 30% of the total storage capacity, and the first preset value is 80% of the total storage capacity; in other embodiments, other settings may be used. When querying data, production data can be obtained by querying the backup production database. This application, through the active-active design of the primary and backup production databases, can reduce the data storage volume of the primary production database and improve its system performance.

[0064] Figure 3 A schematic diagram of the structure of a computer system suitable for implementing the electronic device of the present application is shown.

[0065] It should be noted that, Figure 3 The computer system 300 of the electronic device shown is merely an example and should not impose any limitation on the functionality and scope of use of the embodiments of this application.

[0066] like Figure 3 As shown, the computer system 300 includes a Central Processing Unit (CPU) 301, which can perform various appropriate actions and processes based on programs stored in Read-Only Memory (ROM) 302 or programs loaded from storage portion 308 into Random Access Memory (RAM) 303, such as executing the performance enhancement methods described in the above embodiments. The RAM 303 also stores various programs and data required for system operation. The CPU 301, ROM 302, and RAM 303 are interconnected via a bus 304. An input / output (I / O) interface 305 is also connected to the bus 304.

[0067] The following components are connected to I / O interface 305: an input section 306 including a keyboard, mouse, etc.; an output section 307 including a cathode ray tube (CRT), liquid crystal display (LCD), etc., and speakers, etc.; a storage section 308 including a hard disk, etc.; and a communication section 309 including a network interface card such as a LAN (Local Area Network) card, modem, etc. The communication section 309 performs communication processing via a network such as the Internet. A drive 310 is also connected to I / O interface 305 as needed. Removable media 311, such as a disk, optical disk, magneto-optical disk, semiconductor memory, etc., are installed on drive 310 as needed so that computer programs read from them can be installed into storage section 308 as needed.

[0068] Specifically, according to embodiments of this application, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments of this application include a computer program product comprising a computer program carried on a computer-readable medium, the computer program containing program code for performing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via communication section 309, and / or installed from removable medium 311. When the computer program is executed by central processing unit (CPU) 301, it performs various functions defined in the system of this application.

[0069] It should be noted that the computer-readable medium shown in the embodiments of this application can be a computer-readable signal medium or a computer-readable storage medium, or any combination of the two. A computer-readable storage medium can be, for example,—but not limited to—an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of a computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM), flash memory, optical fiber, portable compact disc read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In this application, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. In this application, a computer-readable signal medium can include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such transmitted data signals can take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. The computer-readable signal medium can also be any computer-readable medium other than a computer-readable storage medium, which can send, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. The program code contained on the computer-readable medium can be transmitted using any suitable medium, including but not limited to wireless, wired, etc., or any suitable combination thereof.

[0070] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this application. Each block in a flowchart or block diagram may represent a module, segment, or portion of code, which contains one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in a block diagram or flowchart, and combinations of blocks in a block diagram or flowchart, can be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.

[0071] The modules described in the embodiments of this application can be implemented in software or hardware, and can also be located in a processor. The names of these modules do not necessarily limit the module itself.

[0072] In another aspect, this application also provides a computer program product or computer program including computer instructions stored in a computer-readable storage medium. A processor of an electronic device reads the computer instructions from the computer-readable storage medium and executes the computer instructions, causing the electronic device to perform the performance improvement method described in the above embodiments.

[0073] In another aspect, this application also provides a computer-readable medium, which may be included in the electronic device described in the above embodiments; or it may exist independently and not assembled into the electronic device. The computer-readable medium carries one or more programs, which, when executed by the electronic device, cause the electronic device to implement the performance improvement method described in the above embodiments.

[0074] It should be noted that although several modules or units for the device used to perform actions have been mentioned in the detailed description above, this division is not mandatory. In fact, according to the embodiments of this application, the features and functions of two or more modules or units described above can be embodied in one module or unit. Conversely, the features and functions of one module or unit described above can be further divided and embodied by multiple modules or units.

[0075] Through the above description of the embodiments, those skilled in the art will readily understand that the exemplary embodiments described herein can be implemented by software or by combining software with necessary hardware. Therefore, the technical solutions according to the embodiments of this application can be embodied in the form of a software product. This software product can be stored in a non-volatile storage medium (such as a CD-ROM, USB flash drive, external hard drive, etc.) or on a network, and includes several instructions to cause a computing device (such as a personal computer, server, touch terminal, or network device, etc.) to execute the performance improvement method described in the above embodiments.

[0076] Other embodiments of this application will readily occur to those skilled in the art upon consideration of the specification and practice of the embodiments disclosed herein. This application is intended to cover any variations, uses, or adaptations of this application that follow the general principles of this application and include common knowledge or customary techniques in the art not disclosed herein.

[0077] It should be understood that this application is not limited to the precise structure described above and shown in the accompanying drawings, and various modifications and changes can be made without departing from its scope. The scope of this application is limited only by the appended claims.

Claims

1. A performance improvement method based on system dual-active, characterized in that, The performance improvement method comprises: obtaining a main production database, and building a backup production database according to the main production database; synchronizing the operation of entering and / or modifying data in the main production database to the backup production database in real time; obtaining a main system for accessing the main production database, and building a backup system according to the main system, wherein the backup system is used for accessing the backup production database; when the data amount in the main production database exceeds a first set value, deleting the data amount in the main production database to a second set value; when the data amount in the main production database exceeds the first set value, deleting the data amount in the main production database to the second set value, the method comprising: when the data amount in the main production database exceeds the first set value, stopping entering data into the main production database, and saving the data already entered in the backup production database; deleting the data in the main production database in the order from the longest entry time to the shortest entry time; when the data amount in the main production database is the second set value, stopping the deleting operation, and continuing to enter data into the main production database, and the backup production database performs the same data entering operation as the main production database; wherein the second set value is less than the first set value.

2. The performance improvement method of claim 1, wherein, In the step of synchronizing the operation of entering and / or modifying data in the main production database to the backup production database in real time, the method comprises: copying all data in the main production database to the backup production database; when the operation of entering and / or modifying data in the main production database is performed, the backup production database performs the same operation as the main production database, so that the data entered and / or modified in the backup production database is the same as the data entered and / or modified in the main production database.

3. The performance enhancement method of claim 2, wherein, In the step of when the operation of entering and / or modifying data in the main production database is performed, the backup production database performs the same operation as the main production database, the method comprises: using data synchronization software golden gate to synchronize the operation of entering and / or modifying data in the main production database to the backup production database in real time.

4. The performance improvement method of claim 1, wherein, The main production database comprises a plurality of sub-main production databases; The main system comprises a plurality of sub-main systems corresponding to the plurality of sub-main production databases; The backup production database comprises a plurality of sub-backup production databases corresponding to the plurality of sub-main production databases; The backup system comprises a plurality of sub-backup systems corresponding to the plurality of sub-backup production databases.

5. The performance enhancement method of claim 4, wherein, The plurality of sub-main production databases are distinguished according to entry time, or according to material type, or according to contract specifications.

6. The performance improvement method of claim 4, wherein, After the step of when the data amount in the main production database exceeds the first set value, deleting the data amount in the main production database to the second set value, the method further comprises: using the backup system to query production data through the backup production database.

7. A performance improvement device based on system dual-active, characterized in that, The performance improvement device comprises: An alternative production database module is configured to obtain a main production database, and build an alternative production database according to the main production database; A real-time synchronization module is configured to synchronize the operation of entering and / or modifying data in the main production database into the alternative production database in real time; An alternative system module is configured to obtain a main system for accessing the main production database, and build an alternative system according to the main system, wherein the alternative system is configured to access the alternative production database; A storage space control module is configured to delete data in the main production database to a second set value when the amount of data in the main production database exceeds a first set value; The storage space control module is specifically configured to: stop entering data into the main production database when the amount of data entered in the main production database exceeds the first set value, and save the data already entered in the alternative production database; delete data in the main production database in the order from the longest entry time to the shortest entry time; stop the deletion operation when the amount of data in the main production database is the second set value, and continue to enter data into the main production database, wherein the alternative production database performs the same data entering operation as the main production database; The second set value is less than the first set value.

8. An electronic device, comprising: The electronic device comprises one or more processors and one or more memories, and at least one program code is stored in the one or more memories, wherein the at least one program code is loaded and executed by the one or more processors to realize the operation performed by the performance improvement method according to any one of claims 1 to 6.

9. A computer-readable storage medium, characterized in that, The computer readable storage medium stores at least one program code, and the at least one program code is loaded and executed by the processor to realize the operation performed by the performance improvement method according to any one of claims 1 to 6.

Images