Method and system for traffic data isolation

Abstract

The application discloses a kind of service data isolation method and system, applied to distributed technical field, wherein the method comprises: receiving the daily incremental service data of target object in the service data table of non-isolation library and isolated library that information integration device is transmitted;According to the daily incremental service data received, update the service data table in distributed storage device;Through the data access interface of information integration device, data processing instruction is sent to information integration device, and the processed service data fed back by information integration device is received, wherein information integration device carries out first type data processing according to the external component device preset requirement in the service data table of distributed storage device;Processed service data is collected by the authorized limit external component device through the subscription access interface of information integration device.The application can realize the rationalization of data storage space, data format unification, and the purpose of low cost, high accuracy, reducing redundant space.

Description

Technical Field

[0001] This invention relates to the field of distributed technology, and in particular to a method and system for isolating business data. Background Technology

[0002] This section is intended to provide background or context for the embodiments of the invention set forth in the claims. The description herein is not an admission that it is prior art simply because it is included in this section.

[0003] With the accelerated pace of information standardization, data governance has become a key focus across various industries, especially the banking system. Some business data requires separate isolation, necessitating the migration of data that meets isolation criteria. However, issues such as inappropriate data storage space selection, inconsistent data formats, and unclear access paths can lead to additional storage costs and increased error rates.

[0004] Currently, in the face of the system-level transformation to distributed database architecture, a new isolation mechanism is urgently needed to adapt to it. Summary of the Invention

[0005] This invention provides a business data isolation method applied to a distributed storage device to achieve rational data storage space, unified data format, low cost, high accuracy, and reduced redundant space. The method includes:

[0006] Receive daily incremental business data of the target object in the business data tables of the non-isolated and isolated databases, transmitted from the information integration device.

[0007] Update the service data table in the distributed storage device based on the received daily incremental service data;

[0008] Through the data access interface of the information integration device, data processing instructions are sent to the information integration device, and processed business data is received from the information integration device. The information integration device performs first-type data processing on the business data table of the distributed storage device according to the preset requirements of the external component device. The processed business data is available for collection by authorized external component devices through the subscription access interface of the information integration device.

[0009] This invention also provides a distributed storage device to achieve rational data storage space, unified data format, low cost, high accuracy, and reduced redundant space. The device includes:

[0010] The first data receiving module is used to receive daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database, and to transmit it to the distributed storage device. After receiving the daily incremental business data, the distributed storage device updates the business data table in the distributed storage device.

[0011] The first data processing module is used to process the business data in the business data table of the distributed storage device according to the preset requirements of the external component device after receiving the data processing instruction sent by the distributed storage device through the data access interface of the information integration device.

[0012] The data access module is used to obtain the processed business data in the distributed storage device and send it to the authorized external component device after receiving a subscription access instruction sent by the authorized external component device through the subscription access interface.

[0013] This invention also provides a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the above-described business data isolation method.

[0014] This invention also provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the aforementioned business data isolation method.

[0015] This invention also provides a computer program product, which includes a computer program that, when executed by a processor, implements the above-described business data isolation method.

[0016] In this embodiment of the invention, the system receives daily incremental business data from the target object's business data tables in both the isolated and non-isolated databases, transmitted from the information integration device. Based on the received daily incremental business data, the system updates the business data tables in the distributed storage device. Through the data access interface of the information integration device, the system sends data processing instructions to the information integration device and receives processed business data from the information integration device. The information integration device performs a first type of data processing on the business data in the distributed storage device's business data tables according to preset requirements from external component devices. The processed business data is then collected by authorized external component devices through the subscription access interface of the information integration device. In this process, the distributed storage device in this embodiment uses a single set of business data tables to store business data in both the isolated and non-isolated databases, reducing unnecessary storage space and offloading overhead, thereby achieving rationalization of data storage space and reducing unnecessary redundancy.

[0017] This invention also provides a business data isolation method applied to an information integration device to achieve rationalization of data storage space, standardization of data format, low cost, high accuracy, and reduction of redundant space. The method includes:

[0018] Receive daily incremental business data from the target object in the business data tables of the non-isolated database and the isolated database, and download it to the distributed storage device. After receiving the daily incremental business data, the distributed storage device updates the business data table in the distributed storage device.

[0019] After receiving the data processing instruction sent by the distributed storage device through the data access interface of the information integration device, the business data in the business data table of the distributed storage device is processed according to the preset requirements of the external component device for the first type of data processing.

[0020] After receiving a subscription access instruction sent by an authorized external component device through the subscription access interface, the system retrieves the processed business data from the distributed storage device and sends it to the authorized external component device.

[0021] This invention also provides an information integration device for achieving rational data storage space, unified data format, low cost, high accuracy, and reduced redundancy. The device includes:

[0022] The data receiving module is used to receive daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database, and to download it to the distributed storage device. After receiving the daily incremental business data, the distributed storage device updates the business data table in the distributed storage device.

[0023] The data processing module is used to perform first-type data processing on the business data in the business data table of the distributed storage device according to the preset requirements of the external component device after receiving the data processing instruction sent by the distributed storage device through the data access interface of the information integration device.

[0024] The data access module is used to obtain the processed business data in the distributed storage device and send it to the authorized external component device after receiving a subscription access instruction sent by the authorized external component device through the subscription access interface.

[0025] This invention also provides a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the above-described business data isolation method.

[0026] This invention also provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the aforementioned business data isolation method.

[0027] This invention also provides a computer program product, which includes a computer program that, when executed by a processor, implements the above-described business data isolation method.

[0028] In this embodiment of the invention, daily incremental business data from the target object's business data tables in both the non-isolated and isolated databases is received and transmitted to a distributed storage device. Upon receiving the daily incremental business data, the distributed storage device updates its business data tables. After receiving a data processing instruction from the distributed storage device via the data access interface of the information integration device, the business data in the distributed storage device's business data tables undergoes first-type data processing according to preset requirements of the external component device. Upon receiving a subscription access instruction from an authorized external component device via a subscription access interface, the processed business data from the distributed storage device is retrieved and sent to the authorized external component device. In this process, the information integration device in this embodiment of the invention implements code conversion and data format unification functions, reducing the error rate caused by direct transmission of business data, thereby achieving the goal of reducing data storage costs and improving data storage accuracy.

[0029] This invention also provides a business data isolation method applied to external component devices to achieve rationalization of data storage space, standardization of data format, low cost, high accuracy, and reduction of redundant space. The method includes:

[0030] According to the subscription requirements, a registration instruction is sent to the information integration device through the subscription access interface of the information integration device, and the right to access the business data of the distributed storage device is obtained.

[0031] Send a subscription access command to the subscription access interface of the information integration device;

[0032] Retrieve processed business data from a distributed storage device;

[0033] The processed business data is obtained by the information integration device after processing the business data in the business data table of the distributed storage device according to the preset requirements of the external component device.

[0034] The business data in the business data table of the distributed storage device is obtained by the information integration device after receiving the daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database and then transmitting it to the distributed storage device, and then updating the business data table in the distributed storage device.

[0035] This invention also provides an external component device for achieving rationalization of data storage space, standardization of data format, low cost, high accuracy, and reduction of redundant space. The device includes:

[0036] The data subscription module, according to subscription requirements, sends a registration instruction to the information integration device through the subscription access interface of the information integration device, and obtains the permission to access the business data of the distributed storage device;

[0037] The data access module is used to send subscription access instructions to the subscription access interface of the information integration device;

[0038] The data acquisition module is used to acquire processed business data from the distributed storage device;

[0039] The processed business data is obtained by the information integration device after processing the business data in the business data table of the distributed storage device according to the preset requirements of the external component device.

[0040] The business data in the business data table of the distributed storage device is obtained by the information integration device after receiving the daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database and then transmitting it to the distributed storage device, and then updating the business data table in the distributed storage device.

[0041] This invention also provides a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the above-described business data isolation method.

[0042] This invention also provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the aforementioned business data isolation method.

[0043] This invention also provides a computer program product, which includes a computer program that, when executed by a processor, implements the above-described business data isolation method.

[0044] In this embodiment of the invention, a registration instruction is sent to the information integration device through the subscription access interface of the information integration device according to the subscription requirements, and the permission to access the business data of the distributed storage device is obtained; a subscription access instruction is sent to the subscription access interface of the information integration device; and the processed business data in the distributed storage device is obtained. The processed business data is obtained by the information integration device after performing a first type of data processing on the business data table of the distributed storage device according to the preset requirements of the external component device. The business data in the business data table of the distributed storage device is downloaded to the distributed storage device by the information integration device after receiving the daily incremental business data of the target object in the non-isolated and isolated database business data tables. In the above process, in this embodiment of the invention, the external component device accesses the distributed storage device's business data by calling the subscription access interface of the information integration device. All access paths are registered in the subscription access interface, thereby achieving a clear access path and facilitating problem localization and troubleshooting. Attached Figure Description

[0045] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort. In the drawings:

[0046] Figure 1 This is a flowchart of a distributed storage device in an embodiment of the present invention;

[0047] Figure 2 This is a flowchart of the information integration device in an embodiment of the present invention;

[0048] Figure 3 This is a flowchart of the external component device in an embodiment of the present invention;

[0049] Figure 4 This is a schematic diagram of a distributed storage device in an embodiment of the present invention;

[0050] Figure 5 This is a schematic diagram of the information integration device in an embodiment of the present invention;

[0051] Figure 6 This is a schematic diagram of the external component device in an embodiment of the present invention;

[0052] Figure 7 This is a structural diagram of the business data isolation system in an embodiment of the present invention;

[0053] Figure 8 This is a schematic diagram of a computer device in an embodiment of the present invention. Detailed Implementation

[0054] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the embodiments of the present invention will be further described in detail below with reference to the accompanying drawings. Here, the illustrative embodiments of the present invention and their descriptions are used to explain the present invention, but are not intended to limit the present invention.

[0055] Figure 1 A flowchart of a distributed storage device according to an embodiment of the present invention includes:

[0056] Step 101: Receive daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database, transmitted by the information integration device;

[0057] Step 102: Update the service data table in the distributed storage device based on the received daily incremental service data;

[0058] Step 103: Send a data processing instruction to the information integration device through the data access interface of the information integration device, and receive the processed business data fed back by the information integration device. The information integration device performs first-type data processing on the business data table of the distributed storage device according to the preset requirements of the external component device. The processed business data is available for collection by authorized external component devices through the subscription access interface of the information integration device.

[0059] Depend on Figure 1 As shown, in this embodiment of the invention, the daily incremental business data of the target object in the business data tables of the non-isolated and isolated databases is received from the information integration device; the business data tables in the distributed storage device are updated according to the received daily incremental business data; data processing instructions are sent to the information integration device through the data access interface of the information integration device, and the processed business data fed back by the information integration device is received. The information integration device performs first-type data processing on the business data in the business data tables of the distributed storage device according to the preset requirements of the external component device; the processed business data is collected by authorized external component devices through the subscription access interface of the information integration device. In the above process, in this embodiment of the invention, the distributed storage device uses a set of business data tables to store the business data of the isolated and non-isolated databases, reducing unnecessary storage space and offloading overhead, thereby achieving the purpose of rationalizing data storage space and reducing unnecessary redundant space.

[0060] The following is a detailed analysis of each step.

[0061] In step 101, the daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database is received from the information integration device.

[0062] Distributed storage devices contain tables with the same structure as isolated and non-isolated databases.

[0063] In one embodiment, receiving daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database, transmitted by the information integration device, includes:

[0064] The daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database is transmitted down after the information integration device performs the second type of data processing;

[0065] When the information integration device performs the second type of data processing, if the formats of the business data in the non-isolated database and the isolated database business data tables are different, it will process the data according to the format of the business data in the non-isolated database.

[0066] In practice, the daily incremental business data in the business data tables of the non-isolated database and the isolated database is downloaded to the information integration device in the form of files, and is finally managed by the distributed storage device.

[0067] Among them, the non-isolated database and the isolated database store multiple business data tables of different types;

[0068] The non-isolated database stores business data tables related to business data, including: a deposit master table, a document information table, a card information table, etc.

[0069] In the isolated database, business data tables related to business data are stored, and the scope and data structure of the tables are consistent with those in the non-isolated database.

[0070] In step 102, the service data table in the distributed storage device is updated based on the received daily incremental service data.

[0071] In one embodiment, updating the service data table in the distributed storage device based on the received daily incremental service data includes:

[0072] When the daily incremental business data in the isolated database is empty, but the daily incremental business data in the non-isolated database is not empty, the daily incremental business data in the non-isolated database is synchronized to the business data table in the distributed storage device.

[0073] When the daily incremental business data in the non-isolated database is empty, but the daily incremental business data in the isolated database is not empty, the daily incremental business data in the isolated database is synchronized to the business data table in the distributed storage device.

[0074] In practice, if business data is deleted in the non-isolated database, the incremental business data for that day will be empty. If business data is written to the isolated database on the same day, the incremental business data for that day will be the data newly written to the incremental business table.

[0075] In step 103, a data processing instruction is sent to the information integration device through the data access interface of the information integration device, and the processed business data fed back by the information integration device is received. The information integration device performs first-type data processing on the business data table of the distributed storage device according to the preset requirements of the external component device. The processed business data is available for collection by authorized external component devices through the subscription access interface of the information integration device.

[0076] External component devices access business data uniformly through the information integration device, which acts as a link between the distributed storage device and the external component devices. The information integration device provides a subscription access interface for business data. External component devices need to subscribe to the required information from it and then collect business data from the distributed storage device through the information integration device.

[0077] In one embodiment, the preset requirements for external component devices include encoding conversion requirements and data format requirements:

[0078] The information integration device performs first-type data processing on the business data table of the distributed storage device according to the preset requirements of the external component device, including:

[0079] Convert the code format of the business data in the business data table to the required code format.

[0080] Convert the data format of the business data in the business data table to the required data format.

[0081] In practical implementation, the information integration device performs three functions, including:

[0082] Code conversion: The code system in the distributed storage device is different from the code system required by the external component device. For example, the code system in the distributed storage device is UTF-8, while the external component device wants to obtain GBK code. The code conversion can be completed by the information integration device.

[0083] It provides a subscription access interface for external components and devices to subscribe to the business data they need, and the subscription information can be flexibly adjusted.

[0084] A unified data format is essential. Distributed storage devices contain numerous business data tables, and external component devices also have various requirements for the business data of the target objects. Data flowing between the two needs to be standardized and organized according to the preset requirements of the external component devices before being transmitted to the subscribed external component devices. This facilitates the standardized use of data and controls the data error rate.

[0085] Figure 2The flowchart of the information integration device in this embodiment of the invention includes:

[0086] Step 201: Receive daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database, and download it to the distributed storage device. After receiving the daily incremental business data, the distributed storage device updates the business data table in the distributed storage device.

[0087] Step 202: After receiving the data processing instruction sent by the distributed storage device through the data access interface of the information integration device, the business data in the business data table of the distributed storage device is processed according to the preset requirements of the external component device for the first type of data processing.

[0088] Step 203: After receiving the subscription access instruction sent by the authorized external component device through the subscription access interface, the processed business data in the distributed storage device is obtained and sent to the authorized external component device.

[0089] like Figure 2 As shown, in this embodiment of the invention, daily incremental business data from the target object's business data tables in both the non-isolated and isolated databases is received and transmitted to the distributed storage device. Upon receiving the daily incremental business data, the distributed storage device updates its business data tables. After receiving a data processing instruction from the distributed storage device via the data access interface of the information integration device, the business data in the distributed storage device's business data tables undergoes first-type data processing according to the preset requirements of the external component device. Upon receiving a subscription access instruction from an authorized external component device via the subscription access interface, the processed business data in the distributed storage device is retrieved and sent to the authorized external component device. In this process, the information integration device in this embodiment of the invention implements code conversion and data format unification functions, reducing the error rate caused by direct transmission of business data, thereby achieving the goal of reducing data storage costs and improving data storage accuracy.

[0090] The following is a detailed analysis of each step.

[0091] In step 201, the daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database is received and transmitted to the distributed storage device. After receiving the daily incremental business data, the distributed storage device updates the business data table in the distributed storage device.

[0092] In one embodiment, after receiving the daily incremental business data of the target object in the non-isolated database and the isolated database business data tables, the method further includes:

[0093] When the formats of business data in the non-isolated database and the isolated database business data tables are different, the daily incremental business data shall be processed according to the format of the business data in the non-isolated database.

[0094] The daily incremental business data after the second type of data processing is downloaded to the distributed storage device.

[0095] In one embodiment, after receiving daily incremental service data, the distributed storage device updates the service data table in the distributed storage device, including:

[0096] When the daily incremental business data in the isolated database is empty, but the daily incremental business data in the non-isolated database is not empty, the distributed storage device will synchronize the daily incremental business data in the non-isolated database to the business data table in the distributed storage device.

[0097] When the daily incremental business data in the non-isolated database is empty, but the daily incremental business data in the isolated database is not empty, the daily incremental business data in the distributed storage device is synchronized to the business data table in the distributed storage device.

[0098] In step 202, after receiving the data processing instruction sent by the distributed storage device through the data access interface of the information integration device, the business data in the business data table of the distributed storage device is processed according to the preset requirements of the external component device for the first type of data processing.

[0099] In one embodiment, the preset requirements for external component devices include code conversion requirements and data format requirements;

[0100] The business data in the business data table of the distributed storage device is processed according to the preset requirements of the external component device, including:

[0101] Convert the code format of the business data in the business data table to the required code format.

[0102] Convert the data format of the business data in the business data table to the required data format.

[0103] In step 203, after receiving a subscription access instruction sent by an authorized external component device through the subscription access interface, the processed business data in the distributed storage device is obtained and sent to the authorized external component device.

[0104] In practice, after the external component device successfully subscribes, it automatically collects target business data through the information integration device at regular intervals, and then uses the target business data as a data source for batch processing.

[0105] Figure 3 A flowchart of an external component device in an embodiment of the present invention includes:

[0106] Step 301: According to the subscription requirements, send a registration instruction to the information integration device through the subscription access interface of the information integration device, and obtain the permission to access the business data of the distributed storage device.

[0107] Step 302: Send a subscription access command to the subscription access interface of the information integration device;

[0108] Step 303: Obtain the processed business data from the distributed storage device. The processed business data is obtained by the information integration device after performing the first type of data processing on the business data table of the distributed storage device according to the preset requirements of the external component device. The business data in the business data table of the distributed storage device is obtained by the information integration device after receiving the daily incremental business data of the target object in the non-isolated database and the isolated database business data table and then downloading it to the distributed storage device, and then updating the business data table in the distributed storage device.

[0109] like Figure 3 As can be seen, in this embodiment of the invention, by sending a registration instruction to the information integration device through the subscription access interface of the information integration device according to the subscription requirements, the user obtains the permission to access the business data of the distributed storage device; a subscription access instruction is sent to the subscription access interface of the information integration device; and processed business data is obtained from the distributed storage device. The processed business data is obtained by the information integration device after performing first-type data processing on the business data table of the distributed storage device according to the preset requirements of the external component device. The business data in the business data table of the distributed storage device is downloaded to the distributed storage device by the information integration device after receiving the daily incremental business data of the target object in the non-isolated and isolated database business data tables. In the above process, in this embodiment of the invention, the external component device accesses the distributed storage device's business data by calling the subscription access interface of the information integration device. All access paths are registered in the subscription access interface, thereby achieving a clear access path and facilitating problem localization and troubleshooting.

[0110] The following is a detailed analysis of each step.

[0111] In step 301, according to the subscription requirements, a registration instruction is sent to the information integration device through the subscription access interface of the information integration device, and the right to access the business data of the distributed storage device is obtained.

[0112] External component devices subscribe to data according to their own needs. Only after a successful subscription is the external component device authorized to use the business data in the distributed storage device.

[0113] In one embodiment, it further includes:

[0114] When the isolation status of business data is unknown, access the isolation list table of the non-isolated database to obtain the isolation status of the business data, and process the isolated business data and the non-isolated business data respectively.

[0115] When the external component device is aware of the isolation status of the business data, a subscription access command is sent to the subscription access interface of the information integration device.

[0116] The isolation list table includes isolation status data items, where an isolation status of 0 indicates that the business data of the target object has been isolated, and an isolation status of 1 indicates that the business data of the target object has not been isolated.

[0117] In one embodiment, the information integration device, after receiving daily incremental business data of the target object in the non-isolated and isolated database business data tables, downloads it to the distributed storage device, including:

[0118] When the formats of business data in the non-isolated database and the isolated database business data tables differ, the information integration device performs second-type data processing on the daily incremental business data according to the format of the business data in the non-isolated database.

[0119] The daily incremental business data after the second type of data processing is downloaded to the distributed storage device.

[0120] In one embodiment, updating a business data table in a distributed storage device includes:

[0121] When the daily incremental business data in the isolated database is empty, but the daily incremental business data in the non-isolated database is not empty, the distributed storage device will synchronize the daily incremental business data in the non-isolated database to the business data table in the distributed storage device.

[0122] When the daily incremental business data in the non-isolated database is empty, but the daily incremental business data in the isolated database is not empty, the daily incremental business data in the distributed storage device is synchronized to the business data table in the distributed storage device.

[0123] In one embodiment, the preset requirements for external component devices include code conversion requirements and data format requirements;

[0124] The business data in the business data table of the distributed storage device is processed according to the preset requirements of the external component device, including:

[0125] Convert the code format of the business data in the business data table to the required code format.

[0126] Convert the data format of the business data in the business data table to the required data format.

[0127] In step 303, the processed business data in the distributed storage device is obtained. The processed business data is obtained by the information integration device after performing the first type of data processing on the business data table of the distributed storage device according to the preset requirements of the external component device. The business data in the business data table of the distributed storage device is downloaded to the distributed storage device by the information integration device after receiving the daily incremental business data of the target object in the non-isolated database and the isolated database business data table.

[0128] In practice, after the external component device successfully subscribes, an associated path is established to obtain the target business data from the information integration device, and the external component device is granted the permission to use the business data in batches.

[0129] This invention also proposes a business data isolation device, the principle of which is similar to the business data isolation method, and will not be described in detail here. Figure 4 The distributed storage device proposed in the embodiments of the present invention includes:

[0130] The first data receiving module 401 is used to receive daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database transmitted by the information integration device.

[0131] The data update module 402 is used to update the business data table in the distributed storage device based on the received daily incremental business data.

[0132] The data processing module 403 is used to send data processing instructions to the information integration device through the data access interface of the information integration device, and to receive the processed business data fed back by the information integration device. The information integration device performs first-type data processing on the business data table of the distributed storage device according to the preset requirements of the external component device. The processed business data is available for collection by authorized external component devices through the subscription access interface of the information integration device.

[0133] This invention also proposes a business data isolation device, the principle of which is similar to the business data isolation method, and will not be described in detail here. Figure 5 The information integration device proposed in the embodiments of the present invention includes:

[0134] The second data receiving module 501 is used to receive daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database, and to transmit it to the distributed storage device. After receiving the daily incremental business data, the distributed storage device updates the business data table in the distributed storage device.

[0135] The second data processing module 502 is used to process the business data in the business data table of the distributed storage device according to the preset requirements of the external component device after receiving the data processing instruction sent by the distributed storage device through the data access interface of the information integration device.

[0136] The data access module 503 is used to obtain the processed business data in the distributed storage device and send it to the authorized external component device after receiving a subscription access instruction sent by the authorized external component device through the subscription access interface.

[0137] This invention also proposes a business data isolation device, the principle of which is similar to the business data isolation method, and will not be described in detail here. Figure 6 An external component device proposed in an embodiment of the present invention includes:

[0138] The data subscription module 601, according to the subscription requirements, sends a registration instruction to the information integration device through the subscription access interface of the information integration device, and obtains the permission to access the business data of the distributed storage device.

[0139] Data access module 602 is used to send subscription access instructions to the subscription access interface of the information integration device;

[0140] Data acquisition module 603 is used to acquire processed business data from the distributed storage device;

[0141] The processed business data is obtained by the information integration device after processing the business data in the business data table of the distributed storage device according to the preset requirements of the external component device.

[0142] The business data in the business data table of the distributed storage device is obtained by the information integration device after receiving the daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database and then transmitting it to the distributed storage device, and then updating the business data table in the distributed storage device.

[0143] Based on the same inventive concept, embodiments of the present invention also provide a business data isolation system, as described in the following embodiments. Since the principles underlying these solutions are similar to those of the business data isolation method, the implementation of the system can be referred to the implementation of the method, and repeated details will not be elaborated further.

[0144] Figure 7 This is a structural diagram of the business data isolation system in an embodiment of the present invention, as shown below. Figure 7 As shown, the system includes: the aforementioned distributed storage device 400, the aforementioned information integration device 500, and the aforementioned external component device 600.

[0145] In summary, in the apparatus proposed in this embodiment of the invention, the daily incremental business data of the target object in the business data tables of the non-isolated and isolated databases is received from the information integration device; the business data tables in the distributed storage device are updated according to the received daily incremental business data; data processing instructions are sent to the information integration device through the data access interface of the information integration device, and the processed business data fed back by the information integration device is received. The information integration device performs first-type data processing on the business data in the business data tables of the distributed storage device according to the preset requirements of the external component device; the processed business data is available for collection by authorized external component devices through the subscription access interface of the information integration device. In the above process, the distributed storage device in this embodiment of the invention uses a set of business data tables to store business data in both the isolated and non-isolated databases, reducing unnecessary storage space and offloading overhead, thereby achieving the purpose of rationalizing data storage space and reducing unnecessary redundant space.

[0146] This invention also provides a computer device. Figure 8 This is a schematic diagram of a computer device in an embodiment of the present invention. The computer device 800 includes a memory 810, a processor 820, and a computer program 830 stored in the memory 810 and executable on the processor 820. When the processor 820 executes the computer program 830, it implements the above-mentioned business data isolation method.

[0147] This invention also provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the aforementioned business data isolation method.

[0148] This invention also provides a computer program product, which includes a computer program that, when executed by a processor, implements the above-described business data isolation method.

[0149] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, systems, or computer program products. Therefore, the present invention can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention can take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0150] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0151] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0152] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0153] The specific embodiments described above further illustrate the purpose, technical solution, and beneficial effects of the present invention. It should be understood that the above descriptions are merely specific embodiments of the present invention and are not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention.

Claims

1. A business data isolation method, characterized in that, Applications in distributed storage devices, including: Receive daily incremental business data of the target object in the business data tables of the non-isolated and isolated databases, transmitted from the information integration device. Update the service data table in the distributed storage device based on the received daily incremental service data; Through the data access interface of the information integration device, data processing instructions are sent to the information integration device, and processed business data is received from the information integration device. The information integration device performs first-type data processing on the business data table of the distributed storage device according to the preset requirements of the external component device. The processed business data is available for collection by authorized external component devices through the subscription access interface of the information integration device. The preset requirements of the external component device include code conversion requirements and data format requirements. Receive daily incremental business data from the target object's business data tables in both the non-isolated and isolated databases, transmitted from the information integration device, including: The daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database is transmitted down after the information integration device performs the second type of data processing; When the information integration device performs the second type of data processing, if the formats of the business data in the business data tables of the non-isolated database and the isolated database are different, it will process the data according to the preset code system requirements of the distributed storage device. Based on the received daily incremental service data, update the service data table in the distributed storage device, including: When the daily incremental business data in the isolated database is empty, but the daily incremental business data in the non-isolated database is not empty, the daily incremental business data in the non-isolated database is synchronized to the business data table in the distributed storage device. When the daily incremental business data in the non-isolated database is empty, but the daily incremental business data in the isolated database is not empty, the daily incremental business data in the isolated database is synchronized to the business data table in the distributed storage device.

2. The method as described in claim 1, characterized in that, The preset requirements for external component devices include code conversion requirements and data format requirements: The information integration device performs first-type data processing on the business data table of the distributed storage device according to the preset requirements of the external component device, including: Convert the code format of the business data in the business data table to the required code format. Convert the data format of the business data in the business data table to the required data format.

3. A business data isolation method, characterized in that, Applied to information integration devices, including: Receive daily incremental business data from the target object in the business data tables of the non-isolated database and the isolated database, and download it to the distributed storage device. After receiving the daily incremental business data, the distributed storage device updates the business data table in the distributed storage device. After receiving the data processing instruction sent by the distributed storage device through the data access interface of the information integration device, the business data in the business data table of the distributed storage device is processed according to the preset requirements of the external component device for the first type of data processing. After receiving a subscription access instruction sent by an authorized external component device through the subscription access interface, the system retrieves the processed business data from the distributed storage device and sends it to the authorized external component device; the preset requirements of the external component device include code conversion requirements and data format requirements. After receiving the daily incremental business data of the target object in the non-isolated and isolated database business data tables, it also includes: When the formats of business data in the non-isolated database and the isolated database business data tables are different, the daily incremental business data shall be processed according to the format of the business data in the non-isolated database. The daily incremental business data after the second type of data processing is downloaded to the distributed storage device; After receiving daily incremental service data, the distributed storage device updates the service data table in the distributed storage device, including: When the daily incremental business data in the isolated database is empty, but the daily incremental business data in the non-isolated database is not empty, the distributed storage device will synchronize the daily incremental business data in the non-isolated database to the business data table in the distributed storage device. When the daily incremental business data in the non-isolated database is empty, but the daily incremental business data in the isolated database is not empty, the daily incremental business data in the distributed storage device is synchronized to the business data table in the distributed storage device.

4. The method as described in claim 3, characterized in that, The preset requirements for external component devices include code conversion requirements and data format requirements; The business data in the business data table of the distributed storage device is processed according to the preset requirements of the external component device, including: Convert the code format of the business data in the business data table to the required code format. Convert the data format of the business data in the business data table to the required data format.

5. A business data isolation method, characterized in that, Applied to external component devices, including: According to the subscription requirements, a registration instruction is sent to the information integration device through the subscription access interface of the information integration device, and the right to access the business data of the distributed storage device is obtained. Send a subscription access command to the subscription access interface of the information integration device; Retrieve processed business data from a distributed storage device; The processed business data is obtained by the information integration device after processing the business data in the business data table of the distributed storage device according to the preset requirements of the external component device. The preset requirements of the external component device include code conversion requirements and data format requirements. The business data in the business data table of the distributed storage device is obtained by the information integration device after receiving the daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database and then transmitting it to the distributed storage device to update the business data table in the distributed storage device. The business data isolation method further includes: When the isolation status of business data is unknown, access the isolation list table of the non-isolated database to obtain the isolation status of the business data, and process the isolated business data and the non-isolated business data respectively. When the external component device is aware of the isolation status of the business data, a subscription access command is sent to the subscription access interface of the information integration device. Update the business data tables in the distributed storage device, including: When the daily incremental business data in the isolated database is empty, but the daily incremental business data in the non-isolated database is not empty, the distributed storage device will synchronize the daily incremental business data in the non-isolated database to the business data table in the distributed storage device. When the daily incremental business data in the non-isolated database is empty, but the daily incremental business data in the isolated database is not empty, the daily incremental business data in the distributed storage device is synchronized to the business data table in the distributed storage device.

6. The method as described in claim 5, characterized in that, The isolation list table includes isolation status data items, where an isolation status of 0 indicates that the business data of the target object has been isolated, and an isolation status of 1 indicates that the business data of the target object has not been isolated.

7. The method as described in claim 5, characterized in that, After receiving the daily incremental business data of the target object in the non-isolated and isolated database business data tables, the information integration device downloads it to the distributed storage device, including: When the formats of business data in the non-isolated database and the isolated database business data tables differ, the information integration device performs second-type data processing on the daily incremental business data according to the format of the business data in the non-isolated database. The daily incremental business data after the second type of data processing is downloaded to the distributed storage device.

8. The method as described in claim 5, characterized in that, The preset requirements for external component devices include code conversion requirements and data format requirements; The business data in the business data table of the distributed storage device is processed according to the preset requirements of the external component device, including: Convert the code format of the business data in the business data table to the required code format. Convert the data format of the business data in the business data table to the required data format.

9. A distributed storage device applied to the method of any one of claims 1-2, characterized in that, include: The first data receiving module is used to receive daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database, which are transmitted by the information integration device. The data update module is used to update the business data table in the distributed storage device based on the received daily incremental business data. The first data processing module is used to send data processing instructions to the information integration device through the data access interface of the information integration device, and to receive the processed business data fed back by the information integration device. The information integration device performs the first type of data processing on the business data table of the distributed storage device according to the preset requirements of the external component device. The processed business data is available for collection by authorized external component devices through the subscription access interface of the information integration device.

10. An information integration apparatus applied to the method of any one of claims 3-4, characterized in that, include: The second data receiving module is used to receive the daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database, and to download it to the distributed storage device. After receiving the daily incremental business data, the distributed storage device updates the business data table in the distributed storage device. The second data processing module is used to process the business data in the business data table of the distributed storage device according to the preset requirements of the external component device after receiving the data processing instruction sent by the distributed storage device through the data access interface of the information integration device. The data access module is used to obtain the processed business data in the distributed storage device and send it to the authorized external component device after receiving a subscription access instruction sent by the authorized external component device through the subscription access interface.

11. An external component device for use in the method of any one of claims 5-8, characterized in that, include: The data subscription module, according to subscription requirements, sends a registration instruction to the information integration device through the subscription access interface of the information integration device, and obtains the permission to access the business data of the distributed storage device; The data access module is used to send subscription access instructions to the subscription access interface of the information integration device; The data acquisition module is used to acquire processed business data from the distributed storage device; The processed business data is obtained by the information integration device after processing the business data in the business data table of the distributed storage device according to the preset requirements of the external component device. The business data in the business data table of the distributed storage device is obtained by the information integration device after receiving the daily incremental business data of the target object in the business data tables of the non-isolated database and the isolated database and then transmitting it to the distributed storage device, and then updating the business data table in the distributed storage device.

12. A business data isolation system, characterized in that, include: The distributed storage device of claim 9, the information integration device of claim 10, and the external component device of claim 11.

13. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the computer program, it implements the method of any one of claims 1 to 8.

14. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program that, when executed by a processor, implements the method of any one of claims 1 to 8.

15. A computer program product, characterized in that, The computer program product includes a computer program that, when executed by a processor, implements the method of any one of claims 1 to 8.

Images