Method, system and device for updating data in database and program product

Abstract

The invention discloses a method, a system and a device for updating data in a database and a program product. The method comprises the following steps: controlling a data synchronization module to generate a data acquisition request; in the first data processing area, in response to the data acquisition request, acquiring data to be supplemented from a first database corresponding to the first data processing area, and transmitting the data to be supplemented to a data synchronization module, and physical isolation does not exist between the first data processing area and the host system; the data synchronization module is controlled to synchronize the data to be supplemented into a second data processing area, and physical isolation exists between the second data processing area and the host system; and in the second data processing area, according to the to-be-supplemented data, updating the data in the second database corresponding to the second data processing area. The technical problem of low business data processing efficiency is solved.

Description

Technical Field

[0001] The present application relates to the field of computer software, and in particular to a method, system, device and program product for updating data in a database. Background Art

[0002] At present, in the current aviation operation system, some key business processes for flights at the departure stage are still highly dependent on the host system for processing. This situation directly determines that the continuous participation and collaboration of the host system are indispensable in the flight departure-related processes.

[0003] In related technologies, a partitioning architecture strategy is usually planned and implemented, and the partitioning results can include two modules: the general area and the drainage area. Among them, the drainage area is explicitly designed as a future-oriented de-hosted, low-coupling environment, aiming to gradually reduce direct dependence on the host system and achieve self-sustaining and efficient operation of business logic. Therefore, the drainage area established the principle of physical and logical isolation from the host system at the beginning of its design to ensure its independence and scalability. However, the key business data in the departing flights has a decisive impact on subsequent business verification, flight scheduling, and passenger services. Realizing the real-time and accurate synchronization of such data to the drainage area has become a key challenge and core requirement in the advancement of the project. However, in the above method, due to the physical isolation between the drainage area and the host system, the host cannot authenticate some business data, resulting in a technical problem of low efficiency in processing business data.

[0004] To address the above-mentioned problems, no effective solution has been proposed yet. Summary of the invention

[0005] The embodiments of the present application provide a method, system, device and program product for updating data in a database, so as to at least solve the technical problem of low processing efficiency of business data.

[0006] According to one aspect of an embodiment of the present application, a method for updating data in a database is provided, which may include: controlling a data synchronization module to generate a data acquisition request; in a first data processing area, in response to the data acquisition request, collecting data to be supplemented from a first database corresponding to the first data processing area, and transmitting the data to be supplemented to the data synchronization module, wherein there is no physical isolation between the first data processing area and the host system; controlling the data synchronization module to synchronize the data to be supplemented to a second data processing area, wherein there is a physical isolation between the second data processing area and the host system; in the second data processing area, updating the data in the second database corresponding to the second data processing area according to the data to be supplemented.

[0007] Optionally, in the second data processing area, the data in the second database corresponding to the second data processing area is updated according to the data to be supplemented, including: controlling the second data processing area to convert the data to be supplemented; supplementing the converted data to be supplemented into the second database to complete the update of the data in the second database.

[0008] Optionally, the method may also include: obtaining business data obtained by the first data processing area in response to the business request, and storing the business data in a first database corresponding to the first data processing area; and / or obtaining business data obtained by the second data processing area in response to the business request, and storing business data in the business data that does not require verification by the host system, wherein the business data at least includes business data that requires verification by the host system and / or business data that does not require verification by the host system.

[0009] Optionally, controlling the data synchronization module to generate a data collection request includes: in response to missing data in the second database, controlling the data synchronization module to generate a data collection request; the method also includes: transmitting the data collection request to the first data processing area.

[0010] Optionally, the method may further include: identifying the data in the second database at a preset time to obtain an identification result; and determining whether there is missing data in the second database based on the identification result.

[0011] According to another aspect of an embodiment of the present application, a system for updating data in a database is also provided, which system may include: a data synchronization module, used to generate a data collection request; a first data processing area, which is not physically isolated from the host system, and is used to obtain the data collection request, and in response to the data collection request, collect the data to be supplemented from the first database corresponding to the first data processing area, and transmit the data to be supplemented to the data synchronization module; a second data processing area, which is physically isolated from the host system, and is used to obtain the data to be supplemented synchronized by the data synchronization module, and update the data in the second database corresponding to the second data processing area according to the data to be supplemented.

[0012] Optionally, the first data processing area further includes: a data compensation component, which is used to convert the data to be supplemented and supplement the converted data to be supplemented into the second database.

[0013] Optionally, the first data processing area is further used to call the host system to verify the business data, and transmit the verified business data to the first database.

[0014] According to another aspect of an embodiment of the present application, a device for updating data in a database is also provided, which may include: a first control unit, used to control a data synchronization module to generate a data acquisition request; a processing unit, used to, in a first data processing area, in response to the data acquisition request, collect the data to be supplemented from a first database corresponding to the first data processing area, and transmit the data to be supplemented to the data synchronization module, wherein there is no physical isolation between the first data processing area and the host system; a second control unit, used to control the data synchronization module, to synchronize the data to be supplemented to the second data processing area, wherein there is a physical isolation between the second data processing area and the host system; an updating unit, used to update the data in the second database corresponding to the second data processing area according to the data to be supplemented in the second data processing area.

[0015] According to another aspect of an embodiment of the present application, a computer-readable storage medium is also provided, which includes a stored program, wherein when the program is running, the device where the computer-readable storage medium is located is controlled to execute the method for updating data in the database of an embodiment of the present application.

[0016] According to another aspect of an embodiment of the present application, a processor is further provided, the processor being used to run a program, wherein the program, when run by the processor, executes the method for updating data in a database of an embodiment of the present application.

[0017] According to another aspect of an embodiment of the present application, a computer program product is further provided. The computer program product includes computer instructions, wherein the computer instructions, when executed by a processor, implement the method for updating data in a database of an embodiment of the present application.

[0018] In the embodiment of the present application, the data synchronization module is controlled to generate a data acquisition request; in the first data processing area, in response to the data acquisition request, the data to be supplemented is collected from the first database corresponding to the first data processing area, and the data to be supplemented is transmitted to the data synchronization module, wherein there is no physical isolation between the first data processing area and the host system; the data synchronization module is controlled to synchronize the data to be supplemented to the second data processing area, wherein there is a physical isolation between the second data processing area and the host system; in the second data processing area, according to the data to be supplemented, the data in the second database corresponding to the second data processing area is updated. That is to say, in the embodiment of the present application, the data synchronization module is used to send a data acquisition request to the first data processing area, the first database corresponding to the first data processing area can store the data to be supplemented, the data to be supplemented is obtained from the first database, and the data synchronization module can be used to transfer the data to be supplemented to the second database corresponding to the second data area for storage, thereby achieving the purpose of supplementing the missing data in the second database, thereby solving the technical problem of low processing efficiency of business data and achieving the technical effect of improving the processing efficiency of business data. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] The drawings described herein are used to provide a further understanding of the present application and constitute a part of the present application. The illustrative embodiments of the present application and their descriptions are used to explain the present application and do not constitute an improper limitation on the present application. In the drawings:

[0020] Figure 1 is a flow chart of a method for updating data in a database according to an embodiment of the present application;

[0021] Figure 2 is a schematic diagram of a departure seat allocation system according to an embodiment of the present application;

[0022] Figure 3 is a schematic diagram of components in a drainage area according to an embodiment of the present application;

[0023] Figure 4 is a schematic diagram of supplementing drainage area data according to an embodiment of the present application;

[0024] Figure 5 is a schematic diagram of a system for updating data in a database according to an embodiment of the present application;

[0025] Figure 6 It is a schematic diagram of a flow chart of drainage area data processing and drainage area data compensation according to an embodiment of the present application;

[0026] Figure 7 is a schematic diagram of a device for updating data in a database according to an embodiment of the present application;

[0027] Figure 8 is a structural block diagram of a computer terminal according to an embodiment of the present application;

[0028] Fig. 9 The present invention is a block diagram of an electronic device for a method for updating data in a database according to an embodiment of the present application. DETAILED DESCRIPTION

[0029] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present application.

[0030] It should be noted that the terms "first", "second", etc. in the specification and claims of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0031] According to an embodiment of the present application, an embodiment of a method for updating data in a database is provided. The steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0032] In this embodiment, a method for updating data in a database is proposed. The method can use a data synchronization module to send a data collection request to a first data processing area. The first database corresponding to the first data processing area can store the data to be supplemented, and the data to be supplemented can be obtained from the first database. The data synchronization module can be used to transfer the data to be supplemented to a second database corresponding to the second data area for storage, thereby achieving the purpose of supplementing the missing data in the second database, thereby solving the technical problem of low processing efficiency of business data and achieving the technical effect of improving the processing efficiency of business data.

[0033] Figure 1is a flow chart of a method for updating data in a database according to an embodiment of the present application. Figure 1 As shown, the method may include the following steps:

[0034] Step S102: Control the data synchronization module to generate a data collection request.

[0035] In the technical solution provided in the above step S102 of the present application, the above data synchronization module can be a tool for data synchronization, and can be a data synchronization tool, which can be used to perform data synchronization operations from one area (for example, a general area) to another area (for example, a drainage area) according to a preset strategy, and can be used to perform necessary cleaning, conversion, verification and formatting processing on the collected data to ensure the quality and consistency of the data. The above data collection request can be a request to update data, for example, it can be a request to update the cabin number data (Cabin Number Data, referred to as CND), which can be used to request the first data processing area for supplementary data. It should be noted that this is only an example, and there is no specific limitation on the type of data collection request.

[0036] Optionally, the above preset strategy can be a pre-set strategy, which can be used to determine the sending object, generation timing, etc. of the data collection request. It should be noted that this is only an example and does not specifically limit the generation process of the data collection request.

[0037] Step S104, in the first data processing area, in response to a data collection request, collect the data to be supplemented from the first database corresponding to the first data processing area, and transmit the data to be supplemented to the data synchronization module, wherein there is no physical isolation between the first data processing area and the host system.

[0038] In the technical solution provided in the above step S104 of the present application, the above first data processor may be a general area, which may be an area that is not physically isolated from the host system. The first database corresponding to the above first data area may be a storage area of ​​the general area, which may store the business data of the host system confirmed by the host system and the non-host business data processed normally, for example, it may be used to store flight information, passenger details, seat allocation and other contents.

[0039] Optionally, the first data processing area may include a data acquisition module and a data reset module. The data acquisition module may be used to collect part of the business data missing from the drainage area (i.e., the second data processing area), and may be used for preliminary data integration. The data reset module may be used to retrieve part of the existing business data from the request periodically or according to trigger conditions, and prepare to reset it to the drainage area. Since the data in the general area is complete, the service in the general area may be grayed out.

[0040] Optionally, the system can control data synchronization to transmit the generated data collection request to the first data processing area. In the first data processing area, in response to the data collection request, the data to be supplemented can be collected from the first database corresponding to the first data processing area, and the data to be supplemented can be transmitted to the data synchronization module. The above-mentioned data to be supplemented can be business data, or data confirmed by the host system.

[0041] For example, the general area can accurately identify the key data items that are missing in the database corresponding to the drainage area (that is, the data to be supplemented), and return these data as a result set in a structured format to the data synchronization tool.

[0042] Step S106, controlling the data synchronization module to synchronize the data to be supplemented to the second data processing area, wherein the second data processing area is physically isolated from the host system.

[0043] In the technical solution provided in the above step S106 of the present application, after the data to be supplemented is transmitted to the data synchronization module, the data synchronization module can be controlled to synchronize the data to be supplemented to the second data processing area, wherein the above second data processing area can be a drainage area, and can include a data reset module, which can be used to retrieve part of the existing business data from the request periodically or according to trigger conditions, and prepare to reset it to this partition.

[0044] Optionally, the drainage area needs to reset the missing business data, so the data reset module needs to be enabled to provide the corresponding function.

[0045] Optionally, the data synchronization tool obtains the data to be supplemented, and can encapsulate the integrated data (i.e., the data to be supplemented) into a request format that meets the requirements of the drainage area service, and send a data request to the drainage area service through a secure communication protocol to achieve cross-system data transmission and sharing.

[0046] Step S108, in the second data processing area, according to the data to be supplemented, update the data in the second database corresponding to the second data processing area.

[0047] In the technical solution provided in the above step S108 of the present application, the above second database may be a target database, which may be a platform for storing and managing key business data, and may include but is not limited to flight, passenger and seat information.

[0048] Since the second database can only store business data that does not require host system authentication, there will be a problem of missing data. In this embodiment, in order to solve the above problem, the data to be supplemented can be obtained from the first database corresponding to the first data processing area, and the data to be supplemented can be used to supplement the missing data in the second database, thereby solving the problem of missing business data.

[0049] Figure 2 is a schematic diagram of a departure seat allocation system according to an embodiment of the present application, such as Figure 2 As shown, the system may include: a host system 201, an external system 202, a first data processing area 203, a second data processing area 204, a first database 205 corresponding to the first data processing area 203, a second database 206 corresponding to the second data processing area 204, and a data synchronization module 207. The first data processing area may be a common area, which may be an area that is not physically isolated from the host system, and the first data processing area may include a data acquisition module and a data reset module. The second data processing area may be a drainage area, which may be an area that is physically isolated from the host system, and the second data processing area may include a data acquisition and data reset area. The data synchronization module 207 may be a data synchronization tool, which may be used for data synchronization.

[0050] Optionally, the external system can be used to obtain a data source and provide original business request data. The original business request data can be data issued through a business request. The business data can be key data in a departing flight and can be used for subsequent business verification, flight scheduling, passenger service and other verifications.

[0051] Optionally, the above-mentioned host system can be used for data confirmation, and can be used to review and confirm some business request data that needs to be processed in the general area. Only business data confirmed by the host system can be stored in the first database (general area DataBase). Some data is also the root cause of the inconsistency between the general area and the drainage area data. Therefore, it is necessary to use the above-mentioned method of the present application to transfer the business data to be supplemented in the first database (that is, the data to be supplemented) to the second database to avoid the problem of missing data in the second database, thereby solving the technical problem of poor consistency of transaction data.

[0052] Optionally, the first storage area (general area DataBase) can be used to store host business data confirmed by the host system and non-host business data processed normally.

[0053] Optionally, the data collection module in the first data processing area can be used to collect some missing business data (ie, data to be supplemented) in the second data processing area (ie, drainage area), and perform preliminary data integration on multiple data to be supplemented.

[0054] Optionally, the data reset module in the first data processing area can be used to retrieve part of the existing business data from the request regularly or according to trigger conditions, and prepare to reset it to the drainage area. Since the data in the general area is complete, the service in the general area can be grayed out.

[0055] Optionally, the second database (the diversion area DataBase) can be used to store business data diverted from the general area for subsequent business analysis, processing, verification or decision support.

[0056] Optionally, the data reset module in the second data processing area can retrieve part of the existing business data from the request regularly or according to the trigger condition, and prepare to reset it to this partition. The drainage area needs to reset the missing business data, so the service needs to be enabled to provide the corresponding function.

[0057] Optionally, the data synchronization module can perform synchronization operations from the general area to the drainage area according to a preset strategy. The data synchronization module can perform necessary cleaning, conversion, verification and formatting on the collected data to ensure the quality and consistency of the data.

[0058] In this embodiment, the data to be supplemented is seamlessly synchronized from the first database corresponding to the first data processing area to the database corresponding to the second data processing area through the above steps, thereby supporting the normal development and efficient verification of various businesses in the second data processing area, thereby promoting the entire aviation operation system to be more autonomous, flexible and efficient.

[0059] At present, in the current aviation operation system, some key business processes for flights at the departure stage are still highly dependent on the host system for processing. This situation directly determines that the continuous participation and collaboration of the host system are indispensable in the flight departure-related processes. At the same time, the existing aviation operation system is facing the dual challenges of upgrading the technical architecture and optimizing business processes. In this process, the accuracy, real-time and security of some key data of departing flights have become key factors to ensure the smooth departure and efficient operation of flights.

[0060] With the open transformation of technical architecture and the need to enhance business autonomy, the DST system, as one of the core systems, has planned and implemented a partitioned architecture strategy, which is specifically divided into two modules: the general area and the drainage area. Among them, the drainage area is explicitly designed as a future-oriented de-hosted, low-coupling environment, aiming to gradually reduce direct dependence on the host system and achieve self-sustaining and efficient operation of business logic. Therefore, the drainage area established the principle of maintaining physical and logical isolation from the host system at the beginning of its design to ensure its independence and scalability.

[0061] At the same time, the key business data (that is, key data) in the departing flights has a decisive impact on subsequent business verification, flight scheduling and passenger services. Realizing the real-time and accurate synchronization of such data to the drainage area has become a key challenge and core requirement in the project advancement. Therefore, in this embodiment, a set of efficient and secure data synchronization mechanisms is constructed to ensure that all related business data can maintain business data consistency, and seamlessly synchronize the drainage area from the general area to support the normal development and efficient verification of various businesses in the drainage area, thereby promoting the entire aviation operation system to move towards a more autonomous, flexible and efficient direction.

[0062] In this embodiment, in order to solve the problem of synchronous processing of core business data in the current aviation operation system, especially the problem of data flow between the general area and the drainage area under the DST system partition architecture, the business data to be supplemented is transmitted from the general area of ​​the DST system to the drainage area, so that the drainage area can autonomously receive, verify and process the core business data from the general area, so as to reduce dependence on the host system and enhance the autonomy and flexibility of business processing.

[0063] In this embodiment, the traditional database data synchronization method is abandoned, and the synchronization mechanism at the application service level is adopted. A data collection request is sent to the general area service (that is, the first data processing area) through the data synchronization tool, and the returned drainage area missing data (that is, the data to be supplemented) is received, and then these data are integrated and sent to the drainage area service, so that the efficient flow of data in the application service layer is realized. This method not only improves the flexibility and response speed of the system, but also reduces the risks and complexity that may be caused by direct database operations.

[0064] Optionally, this embodiment performs data synchronization at the application service level, which provides higher security protection compared to directly operating the database. By defining strict interface permissions and encrypted transmission protocols, the security, integrity and reliability of data during transmission are ensured. In addition, this synchronization method also facilitates the implementation of data access auditing and monitoring, further improving the security and transparency of data management.

[0065] In addition, in the business process, this method uses sophisticated data comparison technology to enable the general area service to accurately identify the missing data items in the drainage area and return them to the tool client (that is, the data synchronization tool). When integrating this data, the tool client will perform strict data verification and cleaning to ensure the accuracy and consistency of the data. Subsequently, when the integrated data is sent to the drainage area service, necessary verification and confirmation will also be performed to ensure that the data remains consistent during the cross-system transmission process, providing strong support for the stable operation of the system and the accurate application of data.

[0066] In this embodiment, a relatively complete disaster recovery functional area is constructed for the DST drainage area through the above method. The drainage area can not only obtain real-time and accurate business data support, but also quickly isolate the ordinary area when encountering catastrophic events such as system failure or data loss, so that the drainage area can provide services for external systems. This ensures business continuity and data integrity, and greatly improves the reliability and risk resistance of the system.

[0067] Through the above steps S102 and S108 of the present application, the data synchronization module is controlled to generate a data acquisition request; in the first data processing area, in response to the data acquisition request, the data to be supplemented is collected from the first database corresponding to the first data processing area, and the data to be supplemented is transmitted to the data synchronization module, wherein there is no physical isolation between the first data processing area and the host system; the data synchronization module is controlled to synchronize the data to be supplemented to the second data processing area, wherein there is a physical isolation between the second data processing area and the host system; in the second data processing area, according to the data to be supplemented, the data in the second database corresponding to the second data processing area is updated. That is to say, in the embodiment of the present application, a data acquisition request is issued to the first data processing area by using the data synchronization module, and the data to be supplemented can be stored in the first database corresponding to the first data processing area, and the data to be supplemented can be obtained from the first database. The data synchronization module can be used to transfer the data to be supplemented to the second database corresponding to the second data area for storage, thereby achieving the purpose of supplementing the missing data in the second database, thereby solving the technical problem of low processing efficiency of business data and achieving the technical effect of improving the processing efficiency of business data.

[0068] The above method of this embodiment is further introduced below.

[0069] As an optional implementation, step S108, in the second data processing area, updates the data in the second database corresponding to the second data processing area according to the data to be supplemented, including: controlling the second data processing area to convert the data to be supplemented; supplementing the converted data to be supplemented into the second database to complete the update of the data in the second database.

[0070] In this embodiment, the data to be supplemented is transmitted to the second data processing area. The second data processing area can convert the data to be supplemented, and can supplement the converted data to be supplemented into the second database to complete the update of the data in the second database. The conversion may include verification, cleaning and other operations on the data to be supplemented. It should be noted that this is only an example and there is no specific limitation on the conversion method.

[0071] Figure 3 is a schematic diagram of a component in a drainage area according to an embodiment of the present application, such as Figure 3 As shown, the drainage area (performance, the second data processing area may include: data processing component 301, micro-component processing 302 and database 303 (for example, Oracle database).

[0072] Optionally, when the DST system receives a business request from the front end or other channels, the DST system can identify the request type based on keywords according to the pre-configured business rule set, and accurately call the corresponding microservice interface through the Application Programming Interface (API) mechanism. These microservice interfaces are highly modular and reusable components within the system, which are specifically responsible for processing different types of business data. During the microservice processing stage, the system can deeply analyze the specific content of the request to determine whether it needs to interact with the host system to complete the operation of updating business data. If data interaction or business data update is required, a response instruction can be sent to the data synchronization tool to control the data synchronization tool to obtain the response data to be supplemented from the general area.

[0073] Optionally, the drainage area in the DST system has established rules for logical and physical isolation from the host in the early stage of planning, so when the drainage area processes the same business data, the system can immediately trigger a set of error handling logic. The system can record the time, cause, and specific content of the request in detail in the error log to facilitate subsequent problem tracking and performance optimization. At the same time, the system can also construct a response body containing error information and return it to the front end or upstream through the API, clearly indicating the situation of "unable to update data successfully" and providing necessary error codes or descriptions so that the front end or upstream system can provide friendly user prompts.

[0074] In the above situation, since the drainage area cannot obtain the necessary business data updates from the host, other business requests that rely on this data may encounter obstacles in access, and cannot meet the drainage area's needs to verify related business logic or provide accurate services. In order to avoid this situation from having a negative impact on business continuity and user experience, the system can take some temporary measures, such as performing data compensation operations to supplement the missing data in the drainage area. For those business requests that can be completed without interacting with the host, they can be smoothly executed according to the established processing flow, including data verification, business logic processing, database operations (such as data warehousing), and other steps to ensure data consistency and integrity.

[0075] Optionally, the DST system can continuously monitor the processing progress and results to ensure that each step of the operation meets expectations and return a successful response to the front end or requester in a timely manner after the processing is completed.

[0076] As an optional implementation, the method may further include: obtaining business data obtained by the first data processing area in response to a business request, and storing the business data in a first database corresponding to the first data processing area; and / or obtaining business data obtained by the second data processing area in response to a business request, and storing business data in the business data that does not require verification by the host system, wherein the business data at least includes business data that requires verification by the host system, and / or business data that does not require verification by the host system.

[0077] In this embodiment, the first data processing area can obtain business data in response to the business request, and the business data can be stored in the first database corresponding to the first data processing area. And / or, the second data processing area can obtain business data in response to the business request. Since there is data isolation between the second data processing area and the host system, the second data processing area can store business data that does not require host system verification in the business data in the second database. The above-mentioned business data includes business data that requires host system verification and / or business data that does not require host system verification.

[0078] As an optional implementation, step S106, controlling the data synchronization module to generate a data collection request, includes: in response to missing data in the second database, controlling the data synchronization module to generate a data collection request; the method also includes: transmitting the data collection request to the first data processing area.

[0079] In this embodiment, by comparing the data in the second database with the data in the first database, it can be determined whether there is missing data in the second database. If there is missing data in the second database, the data synchronization module can be controlled to generate a data collection request and transmit the data collection request to the first data processing area.

[0080] Optionally, the data synchronization module responds to the data collection request and uses the data collection request to obtain the data to be supplemented in the second database, so as to supplement the missing data in the second database with the data to be supplemented.

[0081] As an optional implementation, the method may further include: identifying the data in the second database at a preset time to obtain an identification result; and determining whether there is missing data in the second database based on the identification result.

[0082] In this embodiment, a preset time can be set in advance, and the time can be a fixed time of a certain day, a fixed period, etc. It should be noted that this is only an example, and there is no specific limitation on the method of determining the preset time. In response to the current time being the preset time, the data in the second database can be identified to obtain an identification result. Based on the identification result, the missing state of the data in the second database can be determined to determine whether it is necessary to send a data synchronization instruction to the data synchronization module.

[0083] Figure 4 is a schematic diagram of supplementing drainage area data according to an embodiment of the present application, such as Figure 4 As shown, the data synchronization module can be a data synchronization tool, and can also be called a data supplement component. This module can send a request to the general area through a remote procedure call (RPC) interface, such as a data collection request. The request can include an identifier of the data to be collected. The general area can use the structured query language (SQL) to query and collect missing specified data from the database according to the parameters in the request. Then, the general area can package the collected data in the format of JavaScript Object Notation (JSON). At the same time, in order to ensure the integrity of data transmission, relevant checks are also added. Finally, the packaged data can be returned to the data synchronization tool.

[0084] After the data synchronization tool receives the data to be supplemented returned by the general area, it can forward it as a new request body to the data compensation component in the drainage area through the RPC interface. During the forwarding process, the data synchronization tool adds error handling and retry mechanisms to ensure that the data can be successfully transmitted to the drainage area.

[0085] Optionally, the data compensation component can be multiple microservices, each of which can be responsible for processing a specific type of data or business logic. It can perform business logic processing on the received data reset request, and the processed data can be written into the target Oracle database.

[0086] Optionally, for missing key business data (e.g., CND data), an example is given as follows: When a request to update CND data arrives at the general area, the data can be pre-processed and verified, and then the host system is called through the interface for processing and waits for its confirmation. Once successful confirmation from the host system is obtained, the CND data can be written into the database of the general area. Table 1 is a parameter table of key business data. As shown in Table 1, the relevant parameters of the data may include the following:

[0087] Table 1 Parameter table of key business data

[0088] Request Parameters illustrate Primary Key CND_ID Airline Code AIRLINE CND table number CND_NUMBER CND model information CND_EQT CND version number CND_VERSION J indicates jet type, otherwise it is empty CLASSIIFICATION Is it a wide-body aircraft? WIDE_BODY Large cabin and its capacity CLASS_CAPACITY Starting validity period, accurate to the day EFFECTIVE_DATA Expiration date, accurate to the day EXPIRY_DATE CND table sub-table serial number CND_SEQ Update Office information UPDATE_OFFICE Update Agent information UPDATE_AGENT Update user level UPDATE_USER_GROUP Updated PID number UPDATE_PID Update time, please refer to the message for details UPDATE_TIME Logical deletion flag MARK_FOR_DELETE

[0089] Optionally, in the data compensation process, the DST general area is mainly responsible for accurately collecting data from various data sources according to specific business needs. Specifically for this scenario, the general area can perform refined data collection tasks for special fields (for example, CND_ID and AIRLINE). Among them, the above CND_ID can be a unique identifier for CND business data, which can be used to distinguish data from different airlines, and can be used to ensure the accuracy and isolation of the data.

[0090] Optionally, the general area can obtain business data in advance and store the business data. When a data collection instruction is obtained, the data to be supplemented can be obtained from the first database based on the data collection instruction, so as to store the data in the second database using the data to be supplemented. Alternatively, when the first data processing area obtains the data collection instruction, it responds to the data collection instruction, determines the data to be supplemented, obtains the data to be supplemented, and authenticates the data to be supplemented using the host system, so as to supplement the authenticated data to be supplemented into the second database for storage.

[0091] Optionally, for each airline, its CND data usually contains a large amount of key information, ranging from about 1,000 to several thousand. In the process of encapsulating data into reply messages, DST fully considers the efficiency and reliability of data transmission. It uses appropriate compression algorithms to compress data according to data size, network conditions and the processing capacity of the target system to reduce transmission time and bandwidth usage. At the same time, in order to ensure the integrity and correctness of the data, the general area can also calculate the number of data and attach it to the data request. In this way, during the data synchronization process, the data synchronization tool can receive complete and reliable feedback.

[0092] Optionally, after the data synchronization tool obtains the data to be supplemented, it can unify and integrate the CND data returned by the general area as the request source for data reset, and then accurately transmit it to the drainage area through RPC calls to support the reset and processing of CND data in the drainage area. At the same time, to ensure the consistency and integrity of transaction data, related services have taken a series of rigorous measures at the database level. First, a comprehensive data cleansing step was performed, and all existing CND data records were completely deleted through the powerful functions of the database management system (DBMS). This operation ensures the purity and redundancy of the data environment. That is, the data synchronization module obtains the data to be supplemented, and can convert the data to be supplemented (for example, integration, cleaning, etc.), and transmit the converted data to the second data processing area for storage of the data to be supplemented.

[0093] Optionally, this embodiment also proposes a full data import strategy, that is, the CND data that has been strictly verified and pre-processed is processed by microservices and imported into the second database in batches. This process not only requires accurate matching of data formats, but also ensures the integrity and security of data during transmission to avoid any form of data loss or damage. At the same time, during the data import process, the relevant services use a transaction processing mechanism to ensure that all operations are either fully successful or rolled back when errors occur, thereby maintaining the consistency of the database.

[0094] In summary, compensation of CND-related data is achieved through data synchronization tools, microservices in the drainage area and the ordinary area, ensuring the high consistency and reliability of CND data in the ordinary area and the drainage area, and providing strong data support for the subsequent drainage area to continue to provide relevant services. It fundamentally solves the problem of inconsistent data between the drainage area and the ordinary area, thereby solving the technical problem of low efficiency in processing business data and achieving the technical effect of improving the efficiency of processing business data.

[0095] In an embodiment of the present application, a data synchronization module is controlled to generate a data collection request; in a first data processing area, in response to the data collection request, the data to be supplemented is collected from a first database corresponding to the first data processing area, and the data to be supplemented is transmitted to the data synchronization module, wherein there is no physical isolation between the first data processing area and the host system; the data synchronization module is controlled to synchronize the data to be supplemented to the second data processing area, wherein there is a physical isolation between the second data processing area and the host system; in the second data processing area, according to the data to be supplemented, the data in the second database corresponding to the second data processing area is updated, thereby solving the technical problem of low processing efficiency of business data and achieving the technical effect of improving processing efficiency of business data.

[0096] According to an embodiment of the present application, a system for updating data in a database is also provided. It should be noted that the system for updating data in a database of this embodiment can be used to execute the method for updating data in a database of embodiment 1 of the present application.

[0097] Figure 5 Schematic diagram of a system for updating data in a database according to an embodiment of the present application. Figure 5 As shown, the system 50 for updating data in the database may include: a data synchronization module 502 , a first data processing area 504 and a second data processing area 506 .

[0098] A data synchronization module 502, used to generate a data collection request;

[0099] The first data processing area 504 is not physically isolated from the host system, and is used to obtain a data collection request, collect the data to be supplemented from the first database corresponding to the first data processing area in response to the data collection request, and transmit the data to be supplemented to the data synchronization module;

[0100] The second data processing area 506 is physically isolated from the host system, and is used to obtain the data to be supplemented synchronized by the data synchronization module, and update the data in the second database corresponding to the second data processing area according to the data to be supplemented.

[0101] As an optional implementation, the first data processing area may further include: a data compensation component, which is used to convert the data to be supplemented and supplement the converted data to be supplemented into the second database.

[0102] In this embodiment, the first data processing area may also include a data supplement component, which can obtain the data to be supplemented transmitted by the data synchronization tool, convert the data to be supplemented, and use the converted data to be supplemented to update and supplement the data in the second database.

[0103] Optionally, after receiving the data to be supplemented returned by the general area, the data synchronization tool can use it as a new request body and forward the data to be supplemented to the data compensation component in the drainage area through the RPC interface. During the forwarding process, the data synchronization tool can add error handling and retry mechanisms to ensure that the data to be supplemented can be successfully transmitted to the drainage area.

[0104] Optionally, the data compensation component can be multiple microservices, each of which can be responsible for processing a specific type of data or business logic. It can perform business logic processing on the received data reset request, and the processed data can be written into the target Oracle database (that is, the second database).

[0105] As an optional implementation, the first data processing area is also used to call the host system to verify the business data, and transmit the verified business data to the first database.

[0106] In this embodiment, the first data processor is not isolated from the host system, so the first data processor can call the host system to verify the business data, and transfer the verified business data to the first database for storage and calling.

[0107] Figure 6 is a flow chart of drainage area data processing and drainage area data compensation according to an embodiment of the present application, such as Figure 6 As shown, the DST system may include a first data processing area 61 , a host system 62 , a data synchronization module 63 and a second data processing area 64 .

[0108] Optionally, the first data processing area 61 may be a common area, and may include common area services. The second data processing area 64 may be a drainage area, and may include drainage area services. The data synchronization tool may be a data synchronization module.

[0109] Optionally, the process of supplementing the data to be supplemented in the drainage area is as follows: Figure 6 As shown, the following steps may be included:

[0110] Step S601, receiving and identifying an external request.

[0111] In this embodiment, the diversion area service can receive a business request from an upstream system. The business request can include various data, such as user requests, check-in information, etc. It should be noted that this is only an example, and there is no specific limitation on the content included in the business request.

[0112] Step S602: determine whether the service request requires confirmation from the host system.

[0113] In this embodiment, after receiving these requests, the drainage area, in addition to conventional request parsing and verification, will also determine whether the request is a request that requires confirmation by the host system. If the judgment result is yes, the service can send the relevant data or information (that is, business data) in the request to the host system and wait for the confirmation response of the host system. Once the confirmation information of the host system is received, the service will continue to execute the subsequent business logic according to the confirmation result, process the request and put it into storage. However, since the drainage area is physically and logically isolated from the host system, this part of the business data related to the host cannot obtain the confirmation operation of the host, so it cannot be put into storage, which results in the data in the drainage area and the ordinary area being unable to maintain business data consistency.

[0114] Optionally, when it is determined that it is not related to the host, step S603 may be executed.

[0115] Step S603, the processing is completed and the goods are put into storage.

[0116] In this embodiment, the diversion area determines that the service request does not require confirmation from the host system, and the diversion area can forward the request to the corresponding service according to the preset routing rules to parse the request information, and finally record the processing result in the database of the diversion area.

[0117] Step S604: Send a data collection request.

[0118] In this embodiment, the data synchronization module can be triggered by the data reset module in the diversion according to the preset time and preset period, and a data collection request can be sent to the general area.

[0119] Optionally, the data synchronization module may use a standardized API calling method to send an accurate data collection request to the general zone service.

[0120] Step S605: the general area collects the data to be supplemented in response to the data collection request.

[0121] In this embodiment, after receiving the request, the general area service can immediately execute the data collection process to comprehensively collect relevant data to obtain the data to be supplemented.

[0122] Optionally, the general area can accurately identify key data items missing from the drainage area database through efficient data comparison and difference analysis technology, and return these data as a result set in a structured format to the data synchronization module.

[0123] Step S606: the data synchronization module performs data integration.

[0124] In this embodiment, after receiving the returned data, the data synchronization tool can use its built-in professional data processing and integration module to perform in-depth cleaning, verification and integration of the data to ensure the accuracy, consistency and integrity of the data.

[0125] Step S607, sending a reset request.

[0126] In this embodiment, after the data synchronization tool encapsulates the integrated data into a request format that meets the requirements of the drainage area service, it can send a data request to the drainage area service through a secure communication protocol to achieve cross-system data transmission and sharing.

[0127] Step S608, receiving a data reset request.

[0128] In this embodiment, after receiving the data reset request, the drainage area can first perform strict request verification to ensure that the format of the request is correct, the parameters are complete, and the requester has the corresponding authority. Subsequently, the data in the request is parsed and cleaned to prepare new data values ​​for database updates. Through database connection and transaction management, the drainage area writes the updated data to the specified database table to ensure data consistency and integrity. After the operation is completed, the drainage area will prepare and send a response to the requester to notify it of the operation results. At the same time, for subsequent audits, troubleshooting and performance optimization, the data synchronization tool will also record detailed operation logs to make operations safer.

[0129] In this embodiment, through the above steps, a data flow mechanism with fine control can be implemented at the application level, thereby achieving consistency in business data between the diversion area and the general area.

[0130] According to an embodiment of the present application, a device for updating data in a database is also provided. It should be noted that the device for updating data in a database of this embodiment can be used to execute the method for updating data in a database of embodiment 1 of the present application.

[0131] Figure 7 Schematic diagram of a device for updating data in a database according to an embodiment of the present application. Figure 7 As shown, the device 70 for updating data in the database may include: a first control unit 702 , a processing unit 704 , a second control unit 706 and an updating unit 708 .

[0132] The first control unit 702 is used to control the data synchronization module to generate a data collection request.

[0133] The processing unit 704 is used to collect the data to be supplemented from the first database corresponding to the first data processing area in response to the data collection request in the first data processing area, and transmit the data to be supplemented to the data synchronization module, wherein there is no physical isolation between the first data processing area and the host system.

[0134] The second control unit 706 is used to control the data synchronization module to synchronize the data to be supplemented to the second data processing area, wherein the second data processing area is physically isolated from the host system.

[0135] The updating unit 708 is used to update the data in the second database corresponding to the second data processing area according to the data to be supplemented in the second data processing area.

[0136] The device for updating data in the database of this embodiment controls the data synchronization module to generate a data collection request through the first control unit 702; collects the data to be supplemented from the first database corresponding to the first data processing area in response to the data collection request through the processing unit 704, and transmits the data to be supplemented to the data synchronization module, wherein there is no physical isolation between the first data processing area and the host system; controls the data synchronization module through the second control unit 706 to synchronize the data to be supplemented to the second data processing area, wherein there is a physical isolation between the second data processing area and the host system; and updates the data in the second database corresponding to the second data processing area according to the data to be supplemented in the second data processing area through the updating unit 708, thereby solving the technical problem of low processing efficiency of business data and achieving the technical effect of improving processing efficiency of business data.

[0137] The embodiment of the present application may provide a computer terminal, which may be any computer terminal device in a computer terminal group. Optionally, in this embodiment, the computer terminal may also be replaced by a terminal device such as a mobile terminal.

[0138] Optionally, in this embodiment, the computer terminal may be located in at least one network device among a plurality of network devices of the computer network.

[0139] In this embodiment, the above-mentioned computer terminal can execute the program code of the following steps in the method for updating data in the database: control the data synchronization module to generate a data acquisition request; in the first data processing area, in response to the data acquisition request, collect the data to be supplemented from the first database corresponding to the first data processing area, and transmit the data to be supplemented to the data synchronization module, wherein there is no physical isolation between the first data processing area and the host system; control the data synchronization module to synchronize the data to be supplemented to the second data processing area, wherein there is a physical isolation between the second data processing area and the host system; in the second data processing area, update the data in the second database corresponding to the second data processing area according to the data to be supplemented.

[0140] Optionally, Figure 8 is a structural block diagram of a computer terminal according to an embodiment of the present application, such as Figure 8 As shown, the computer terminal 808 may include: one or more (only one is shown in the figure) processors 802 , a memory 804 , and a transmission device 806 .

[0141] Among them, the memory can be used to store software programs and modules, such as the program instructions / modules corresponding to the method and device for updating data in the database in the embodiment of the present application. The processor executes various functional applications and data processing by running the software programs and modules stored in the memory, that is, realizing the method for updating data in the above-mentioned database. The memory may include a high-speed random access memory, and may also include a non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some instances, the memory may further include a memory remotely arranged relative to the processor, and these remote memories may be connected to the computer terminal 808 via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0142] The processor can call the information and application programs stored in the memory through the transmission device to perform the following steps: control the data synchronization module to generate a data acquisition request; in the first data processing area, in response to the data acquisition request, collect the data to be supplemented from the first database corresponding to the first data processing area, and transmit the data to be supplemented to the data synchronization module, wherein there is no physical isolation between the first data processing area and the host system; control the data synchronization module to synchronize the data to be supplemented to the second data processing area, wherein there is a physical isolation between the second data processing area and the host system; in the second data processing area, update the data in the second database corresponding to the second data processing area according to the data to be supplemented.

[0143] It can be understood by those skilled in the art that Figure 8 The structure shown is for illustration only, and the computer terminal 808 may also be a smart phone (such as an Android phone, an iOS phone, etc.), a tablet computer, a PDA, a mobile Internet device (Mobile Internet Devices, referred to as MID), a PAD, or other terminal devices. Figure 8 The structure of the computer terminal 808 is not limited. For example, the computer terminal 808 may also include Figure 8 More or fewer components (such as network interfaces, display devices, etc.) shown in, or having Figure 8 Different configurations are shown.

[0144] A person of ordinary skill in the art can understand that all or part of the steps in the various methods of the above embodiments can be completed by instructing the hardware related to the terminal device through a program, and the program can be stored in a computer-readable storage medium, and the storage medium may include: a flash drive, a read-only memory (ROM), a random access memory (RAM), a disk or an optical disk, etc.

[0145] According to an embodiment of the present application, a computer-readable storage medium is further provided, the computer-readable storage medium including a stored program, wherein the program executes the method for updating data in the database in the above embodiment.

[0146] Optionally, in this embodiment, the computer-readable storage medium may be located in any one of the computer terminals in a computer terminal group in a computer network, or in any one of the mobile terminals in a mobile terminal group.

[0147] Optionally, in this embodiment, the computer-readable storage medium is configured to store program codes for performing the following steps: controlling the data synchronization module to generate a data acquisition request; in the first data processing area, in response to the data acquisition request, collecting the data to be supplemented from the first database corresponding to the first data processing area, and transmitting the data to be supplemented to the data synchronization module, wherein there is no physical isolation between the first data processing area and the host system; controlling the data synchronization module to synchronize the data to be supplemented to the second data processing area, wherein there is a physical isolation between the second data processing area and the host system; in the second data processing area, updating the data in the second database corresponding to the second data processing area according to the data to be supplemented.

[0148] Optionally, the computer-readable storage medium may also execute program codes of the following steps: controlling the second data processing area to convert the data to be supplemented; supplementing the converted data to be supplemented into the second database to complete the update of the data in the second database.

[0149] Optionally, the computer-readable storage medium can also execute program codes for the following steps: obtaining business data obtained by the first data processing area in response to a business request, and storing the business data in a first database corresponding to the first data processing area; and / or obtaining business data obtained by the second data processing area in response to a business request, and storing business data in the business data that does not require verification by the host system, wherein the business data at least includes business data that requires verification by the host system, and / or business data that does not require verification by the host system.

[0150] Optionally, the computer-readable storage medium may also execute program code of the following steps: in response to missing data in the second database, controlling the data synchronization module to generate a data collection request; the method further includes: transmitting the data collection request to the first data processing area.

[0151] Optionally, the computer-readable storage medium may also execute program code for the following steps: identifying data in the second database at a preset time to obtain an identification result; and determining whether there is missing data in the second database based on the identification result.

[0152] In this embodiment, a data synchronization module is used to issue a data collection request to the first data processing area. The first database corresponding to the first data processing area can store the data to be supplemented, and the data to be supplemented is obtained from the first database. The data synchronization module can be used to transfer the data to be supplemented to the second database corresponding to the second data area for storage, thereby achieving the purpose of supplementing the missing data in the second database, thereby solving the technical problem of low processing efficiency of business data and achieving the technical effect of improving the processing efficiency of business data.

[0153] According to an embodiment of the present application, a processor is further provided, which is used to run a program, wherein the method for updating data in the database in the above embodiment is executed when the program is run by the processor.

[0154] Optionally, in this embodiment, the computer terminal may be located in at least one network device among a plurality of network devices of the computer network.

[0155] In this embodiment, the above-mentioned computer terminal can execute the program code of the following steps in the method for updating data in the database: control the data synchronization module to generate a data acquisition request; in the first data processing area, in response to the data acquisition request, collect the data to be supplemented from the first database corresponding to the first data processing area, and transmit the data to be supplemented to the data synchronization module, wherein there is no physical isolation between the first data processing area and the host system; control the data synchronization module to synchronize the data to be supplemented to the second data processing area, wherein there is a physical isolation between the second data processing area and the host system; in the second data processing area, update the data in the second database corresponding to the second data processing area according to the data to be supplemented.

[0156] Among them, the memory can be used to store software programs and modules, such as the program instructions / modules corresponding to the method and device for updating data in the database in the embodiment of the present application. The processor executes various functional applications and data processing by running the software programs and modules stored in the memory, that is, realizing the method for updating data in the above-mentioned database. The memory may include a high-speed random access memory, and may also include a non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some instances, the memory may further include a memory remotely arranged relative to the processor, and these remote memories may be connected to the computer terminal via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0157] The processor can call the information and application programs stored in the memory through the transmission device to perform the following steps: control the data synchronization module to generate a data acquisition request; in the first data processing area, in response to the data acquisition request, collect the data to be supplemented from the first database corresponding to the first data processing area, and transmit the data to be supplemented to the data synchronization module, wherein there is no physical isolation between the first data processing area and the host system; control the data synchronization module to synchronize the data to be supplemented to the second data processing area, wherein there is a physical isolation between the second data processing area and the host system; in the second data processing area, update the data in the second database corresponding to the second data processing area according to the data to be supplemented.

[0158] Optionally, the processor may also execute program codes of the following steps: controlling the second data processing area to convert the data to be supplemented; and supplementing the converted data to be supplemented into the second database to complete the update of the data in the second database.

[0159] Optionally, the processor may also execute program code for the following steps: obtaining business data obtained by the first data processing area in response to a business request, and storing the business data in a first database corresponding to the first data processing area; and / or obtaining business data obtained by the second data processing area in response to a business request, and storing business data in the business data that does not require verification by the host system, wherein the business data at least includes business data that requires verification by the host system, and / or business data that does not require verification by the host system.

[0160] Optionally, the processor may also execute program code of the following steps: in response to missing data in the second database, controlling the data synchronization module to generate a data collection request; the method further includes: transmitting the data collection request to the first data processing area.

[0161] Optionally, the processor may also execute program codes of the following steps: identifying the data in the second database at a preset time to obtain an identification result; and determining whether there is missing data in the second database based on the identification result.

[0162] By adopting the embodiment of the present application, a data collection request is issued to the first data processing area by using a data synchronization module. The data to be supplemented can be stored in a first database corresponding to the first data processing area, and the data to be supplemented is obtained from the first database. The data synchronization module can be used to transfer the data to be supplemented to a second database corresponding to the second data area for storage, thereby achieving the purpose of supplementing the missing data in the second database, thereby solving the technical problem of low processing efficiency of business data and achieving the technical effect of improving the processing efficiency of business data.

[0163] According to an embodiment of the present application, a computer program product is further provided. The computer program product includes computer instructions, wherein the computer instructions, when executed by a processor, implement the method for updating data in the database in the above embodiment.

[0164] An embodiment of the present application may provide an electronic device, which may include a memory and a processor.

[0165] Fig. 9 It is a block diagram of an electronic device according to a method for updating data in a database according to an embodiment of the present application. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workbenches, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present application described and / or required herein.

[0166] like Fig. 9 As shown, the device 900 includes a computing unit 901, which can perform various appropriate actions and processes according to a computer program stored in a read-only memory (ROM) 902 or a computer program loaded from a storage unit 908 to a random access memory (RAM) 903. In the RAM 903, various programs and data required for the operation of the device 900 can also be stored. The computing unit 901, the ROM 902, and the RAM 903 are connected to each other via a bus 904. An input / output (I / O) interface 905 is also connected to the bus 904.

[0167] A number of components in the device 900 are connected to the I / O interface 905, including: an input unit 906, such as a keyboard, a mouse, etc.; an output unit 907, such as various types of displays, speakers, etc.; a storage unit 908, such as a disk, an optical disk, etc.; and a communication unit 909, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 909 allows the device 900 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks.

[0168] The computing unit 901 may be a variety of general and / or special processing components with processing and computing capabilities. Some examples of the computing unit 901 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various dedicated artificial intelligence (AI) computing chips, various computing units running machine learning model algorithms, a digital signal processor (DSP), and any appropriate processor, controller, microcontroller, etc. The computing unit 901 performs the various methods and processes described above, such as a verification method for data. For example, in some embodiments, the verification method for data may be implemented as a computer software program, which is tangibly contained in a machine-readable medium, such as a storage unit 908. In some embodiments, part or all of the computer program may be loaded and / or installed on the device 900 via the ROM 902 and / or the communication unit 909. When the computer program is loaded into RAM 903 and executed by the computing unit 901, one or more steps of the data verification method described above may be performed. Alternatively, in other embodiments, the computing unit 901 may be configured to perform the data verification method in any other appropriate manner (e.g., by means of firmware).

[0169] According to an embodiment of the present application, a method for updating data in a database is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0170] Various embodiments of the systems and techniques described above herein may be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on a chip (SOCs), complex programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various embodiments may include: being implemented in one or more computer programs that are executable and / or interpreted on a programmable system that includes at least one programmable processor that may be a dedicated or general purpose programmable processor that may receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0171] The program code for implementing the method of the present application can be written in any combination of one or more programming languages. These program codes can be provided to a processor or controller of a general-purpose computer, a special-purpose computer or other programmable data processing device, so that the program code, when executed by the processor or controller, enables the functions / operations specified in the flow chart and / or block diagram to be implemented. The program code can be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.

[0172] In the context of the present application, a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or equipment. A machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or equipment, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0173] To provide interaction with a user, the systems and techniques described herein may be implemented on a computer having: a display device (e.g., a CRT (cathode ray tube) or an LCD (liquid crystal display, monitor) for displaying information to the user; and a keyboard and a pointing device (e.g., a mouse or a path ball) through which the user can provide input to the computer. Other types of devices may also be used to provide interaction with the user; for example, the feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form (including acoustic input, voice input, or tactile input).

[0174] The systems and techniques described herein can be implemented in a computing system that includes back-end components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes front-end components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such back-end components, middleware components, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a Local Area Network (LAN), a Wide Area Network (WAN), and the Internet.

[0175] A computer system may include a client and a server. The client and the server are generally remote from each other and usually interact through a communication network. The relationship of client and server is generated by computer programs running on respective computers and having a client-server relationship with each other. The server may be a cloud server, a server of a distributed system, or a server combined with a blockchain.

[0176] The serial numbers of the above-mentioned embodiments of the present application are for description only and do not represent the advantages or disadvantages of the embodiments.

[0177] In the above embodiments of the present application, the description of each embodiment has its own emphasis. For parts that are not described in detail in a certain embodiment, please refer to the relevant description of other embodiments.

[0178] In the several embodiments provided in this application, it should be understood that the disclosed technical content can be implemented in other ways. Among them, the device embodiments described above are only schematic. For example, the division of units can be a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of units or modules, which can be electrical or other forms.

[0179] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed over multiple units. Some or all of the units may be selected according to actual needs to achieve the purpose of the present embodiment.

[0180] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0181] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art or all or part of the technical solution, can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, server or network device, etc.) to perform all or part of the steps of each embodiment method of the present application. The aforementioned storage medium includes: U disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk, disk or optical disk, etc. Various media that can store program codes.

[0182] The above are only preferred implementations of the present application. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles of the present application. These improvements and modifications should also be regarded as the scope of protection of the present application.

Claims

1. A method for updating data in a database, characterized in that: include: Control the data synchronization module to generate data collection requests; In the first data processing area, in response to the data collection request, the data to be supplemented is collected from the first database corresponding to the first data processing area, and the data to be supplemented is transmitted to the data synchronization module, wherein there is no physical isolation between the first data processing area and the host system; Controlling the data synchronization module to synchronize the data to be supplemented to a second data processing area, wherein the second data processing area is physically isolated from the host system; In the second data processing area, data in a second database corresponding to the second data processing area is updated according to the data to be supplemented.

2. The method according to claim 1, characterized in that The updating of the data in the second database corresponding to the second data processing area according to the data to be supplemented in the second data processing area includes: Controlling the second data processing area to convert the data to be supplemented; The converted data to be supplemented is supplemented into the second database to complete the update of the data in the second database.

3. The method according to claim 1, characterized in that The method further comprises: Acquire the business data acquired by the first data processing area in response to the business request, and store the business data in a first database corresponding to the first data processing area; and / or Obtain the business data obtained by the second data processing area in response to the business request, and store the business data that does not require verification by the host system among the business data, wherein the business data at least includes the business data that requires verification by the host system and / or the business data that does not require verification by the host system.

4. The method according to claim 1, characterized in that: The control data synchronization module generates a data acquisition request, including: In response to the presence of missing data in the second database, controlling the data synchronization module to generate the data collection request; The method further includes: transmitting the data collection request to the first data processing area.

5. The method according to claim 4, characterized in that The method further comprises: According to a preset time, identifying the data in the second database to obtain an identification result; Based on the identification result, it is determined whether the missing data exists in the second database.

6. A system for updating data in a database, characterized in that: include: A data synchronization module, used to generate data collection requests; The first data processing area is not physically isolated from the host system, and is used to obtain the data collection request, collect the data to be supplemented from the first database corresponding to the first data processing area in response to the data collection request, and transmit the data to be supplemented to the data synchronization module; The second data processing area is physically isolated from the host system, and is used to obtain the data to be supplemented synchronized by the data synchronization module, and update the data in the second database corresponding to the second data processing area according to the data to be supplemented.

7. The system according to claim 6, characterized in that The first data processing area also includes: The data compensation component is used to convert the data to be supplemented and supplement the converted data to be supplemented into the second database.

8. The system according to claim 6, characterized in that The first data processing area is also used to call the host system to verify the business data, and transmit the verified business data to the first database.

9. A device for updating data in a database, characterized in that: include: A first control unit, used for controlling the data synchronization module to generate a data collection request; a processing unit, configured to, in a first data processing area, collect the data to be supplemented from a first database corresponding to the first data processing area in response to the data collection request, and transmit the data to be supplemented to the data synchronization module, wherein there is no physical isolation between the first data processing area and the host system; A second control unit is used to control the data synchronization module to synchronize the data to be supplemented to a second data processing area, wherein the second data processing area is physically isolated from the host system; An updating unit is used to update the data in the second database corresponding to the second data processing area according to the data to be supplemented in the second data processing area.

10. A computer program product, characterized in that The invention comprises a computer program which, when executed by a processor, implements the method according to any one of claims 1 to 5.

Images