Data extraction method and system, terminal equipment, storage medium and computer product

By extracting data when it is ready, the problem of incomplete asset transaction data obtained by data users is solved, ensuring data consistency and integrity.

CN118916424APending Publication Date: 2024-11-08CHINA MERCHANTS BANK
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411072456.9
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-06
Publication Date
2024-11-08

AI Technical Summary

Technical Problem

When data users access the backup database, they perform data extraction without waiting for the asset transaction data to be ready, resulting in incomplete data and inconsistencies between the processed data and the original data.

Method used

By receiving data extraction instructions, reading the data readiness information of the standby database, determining whether the target operation is data extraction or a stop operation, and performing data extraction when the data is ready, the primary and standby databases are synchronized.

Benefits of technology

It enables data extraction when data is ready, ensuring the integrity of the acquired data and its consistency with the original data, thus solving the problem of incomplete data.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118916424A_ABST
    Figure CN118916424A_ABST
Patent Text Reader

Abstract

The invention discloses a data extraction method and system, terminal equipment, a storage medium and a computer product, and relates to the technical field of data processing.The data extraction method specifically comprises the steps that a data extraction instruction is received, and a standby database is accessed based on the data extraction instruction; reading first data ready information contained in the standby database, and determining a target operation needing to be executed according to the first data ready information; and under the condition that the target operation is the data extraction operation, extracting target data contained in the standby database. By adopting the method and the device, the technical effect of enabling the terminal equipment to obtain complete target data is achieved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a data extraction method, system, terminal device, storage medium and computer program product. Background Art

[0002] With the continuous development of the digital banking industry, more and more asset transaction data are generated in banking systems.

[0003] In the related art, data users usually use offline access to the standby database to obtain the asset transaction data stored in the standby database, so as to process and analyze the obtained asset transaction data. However, in the process of accessing the standby database, the data user usually directly performs the data extraction operation to obtain the asset transaction data when the asset transaction data is not ready.

[0004] This results in a technical problem that the asset transaction data obtained by the data user is incomplete, which in turn leads to inconsistencies between the asset transaction data processed by the data user and the asset transaction data stored in the backup database. Summary of the invention

[0005] The main purpose of this application is to provide a data extraction method, system, terminal device, storage medium and computer program product, aiming to solve the technical problem of incomplete asset transaction data obtained by data users in related technologies.

[0006] To achieve the above purpose, the present application proposes a data extraction method, which comprises:

[0007] receiving a data extraction instruction, and accessing a standby database based on the data extraction instruction;

[0008] Reading first data-ready information contained in the standby database, and determining a target operation to be performed according to the first data-ready information;

[0009] In the case where the target operation is a data extraction operation, the target data contained in the standby database is extracted.

[0010] In one embodiment, the step of determining a target operation to be performed according to the first data-ready information includes:

[0011] Acquire preset standard data-ready information, and compare the standard data-ready information with the first data-ready information to obtain a first comparison result;

[0012] If the first comparison result is that the standard data-ready information and the first data-ready information are consistent, determining that the target operation to be performed is a data extraction operation;

[0013] If the first comparison result is that the standard data-ready information and the first data-ready information are inconsistent, it is determined that the target operation is an extraction stop operation.

[0014] In one embodiment, before the step of receiving the data extraction instruction, the method further includes:

[0015] Reading a matter processing list, wherein the matter processing list includes initial data;

[0016] When it is detected that the matter processing list contains the data processing result corresponding to the initial data, the preset first data ready information is obtained;

[0017] Adding the first data-ready information and the initial data to a primary database corresponding to the standby database;

[0018] The initial data is processed by the primary database to generate target data, and the target data and the first data-ready information are synchronized to the standby database.

[0019] In one embodiment, the step of processing the initial data through the master database to generate target data includes:

[0020] Determine the order of processing matters corresponding to the initial data, and determine the system change number corresponding to the initial data based on the order of processing matters;

[0021] The system change number is added to the initial data to generate target data.

[0022] In one embodiment, before the step of accessing the standby database based on the data extraction instruction, the method further includes:

[0023] Determine a first system time corresponding to the data extraction instruction, and compare the first system time with a preset data extraction time to obtain a second comparison result;

[0024] When the second comparison result is that the first system time reaches the data extraction time, the step of accessing the standby database based on the data extraction instruction is performed.

[0025] In one embodiment, after the step of determining the target operation to be performed according to the first data-ready information, the method further includes:

[0026] In the case where the target operation is an extraction stop operation, receiving a repeat extraction instruction, and determining a second system time corresponding to the repeat extraction instruction;

[0027] Determine the interval duration between the second system time and the first system time, and compare the interval duration with a preset interval threshold to obtain a third comparison result;

[0028] If the third comparison result is that the interval duration reaches the interval threshold, reading the standby database to obtain second data ready information;

[0029] When it is determined according to the second data-ready information that the target operation to be executed is a data extraction operation, the target data contained in the standby database is extracted.

[0030] In addition, to achieve the above purpose, the present application also proposes a data extraction system, the system comprising:

[0031] A data access module, used for receiving a data extraction instruction and accessing a standby database based on the data extraction instruction;

[0032] an identification judgment module, configured to read the first data-ready information contained in the standby database, and determine a target operation to be performed according to the first data-ready information;

[0033] The data extraction module is used to extract the target data contained in the standby database when the target operation is a data extraction operation.

[0034] In addition, to achieve the above-mentioned purpose, the present application also proposes a terminal device, which includes: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program is configured to implement the steps of the data extraction method described above.

[0035] In addition, to achieve the above-mentioned purpose, the present application also proposes a storage medium, which is a computer-readable storage medium, and a computer program is stored on the storage medium. When the computer program is executed by a processor, the steps of the data extraction method described above are implemented.

[0036] In addition, to achieve the above-mentioned purpose, the present application also provides a computer program product, which includes a computer program, and when the computer program is executed by a processor, the steps of the data extraction method described above are implemented.

[0037] The data extraction method, system, terminal device, storage medium and computer program product provided in the embodiments of the present application receive a data extraction instruction and access a standby database based on the data extraction instruction; read first data ready information contained in the standby database, and determine a target operation to be performed based on the first data ready information; and extract the target data contained in the standby database when the target operation is a data extraction operation.

[0038] In this embodiment, during operation, the terminal device first receives a data extraction instruction sent by the banking business system, and accesses a standby database for extracting target data according to the data extraction instruction. After that, the terminal device reads the standby database to obtain first data ready information indicating whether the target data contained in the standby data is in a ready state, and determines the target operation that needs to be performed according to the first data ready information. Finally, when the terminal device determines that the target operation to be performed is a data extraction operation according to the first data ready information, the terminal device extracts each target data contained in the standby database, so as to enable the banking business system to process each target data.

[0039] In this way, the present application solves the technical problem in the related art that the data user has incomplete asset transaction data. That is, the present application determines whether the asset transaction data in the backup database and the asset transaction data in the main database are synchronized through data ready information, and then enables the terminal device to perform a data extraction operation to obtain the target data when the asset transaction data in the backup database and the main database are synchronized, thereby achieving the technical effect of enabling the terminal device to obtain complete target data and ensuring the consistency between the processed data and the original data. BRIEF DESCRIPTION OF THE DRAWINGS

[0040] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the present application.

[0041] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, for ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative labor.

[0042] Figure 1 A flowchart of the first embodiment of the data extraction method of this application is provided;

[0043] Figure 2 This is a brief flowchart of the data extraction method for this application;

[0044] Figure 3 A schematic diagram of a data synchronization process involved in an embodiment of a data extraction method of the present application;

[0045] Figure 4 This is a schematic diagram of the module structure of the data extraction system according to an embodiment of the present application;

[0046] Figure 5 Schematic diagram of the device structure of the hardware operating environment involved in the data extraction method in the embodiment of the present application.

[0047] The purpose, features and advantages of this application will be further described in conjunction with the embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION

[0048] It should be understood that the specific embodiments described herein are only used to explain the technical solutions of the present application and are not used to limit the present application.

[0049] In this embodiment, for the convenience of description, the following description is based on the terminal device with an Oracle database, an upstream data processing system, and a banking business system configured therein as the execution subject. It should be noted that the Oracle database includes an Oracle primary database and an Oracle standby database.

[0050] Based on the above-mentioned terminal device, the overall concept of the data extraction method of this application is proposed here.

[0051] With the continuous development of the digital banking industry, more and more asset transaction data are generated in the banking business system. In the relevant technology, the data user usually uses the method of offline access to the backup database to obtain the asset transaction data stored in the backup database, so as to process and analyze the obtained asset transaction data. However, in the process of accessing the backup database, the data user usually directly performs the data extraction operation to obtain the asset transaction data when the asset transaction data is not in a ready state. In this way, the data user has the technical problem of incomplete asset transaction data obtained, which leads to inconsistencies between the asset transaction data processed by the data user and the asset transaction data stored in the backup database.

[0052] In response to the above phenomenon, the present application provides a data extraction method, which includes: receiving a data extraction instruction, and accessing a standby database based on the data extraction instruction; reading first data ready information contained in the standby database, and determining a target operation to be performed based on the first data ready information; and when the target operation is a data extraction operation, extracting the target data contained in the standby database.

[0053] In this way, the present application solves the technical problem in the related art that the data user has incomplete asset transaction data. That is, the present application determines whether the asset transaction data in the backup database and the asset transaction data in the main database are synchronized through data ready information, and then enables the terminal device to perform a data extraction operation to obtain the target data when the asset transaction data in the backup database and the main database are synchronized, thereby achieving the technical effect of enabling the terminal device to obtain complete target data and ensuring the consistency between the processed data and the original data.

[0054] Based on the overall concept of the data extraction method of the present application, the embodiment of the present application provides a data extraction method, referring to Figure 1 , Figure 1 This is a flow chart of the first embodiment of the data extraction method of the present application.

[0055] In this embodiment, the data extraction method includes steps S10 to S30:

[0056] Step S10: receiving a data extraction instruction, and accessing a standby database based on the data extraction instruction;

[0057] It should be noted that the standby database may be an Oracle standby database included in an Oracle database. It is understandable that the Oracle database includes an Oracle master database and an Oracle standby database, wherein the Oracle master database often stores various types of data such as asset data and transaction data. In addition, the Oracle master database usually synchronizes the stored data to the Oracle standby database, and the data provider can obtain various data synchronized from the Oracle master database by accessing the Oracle standby database.

[0058] In this embodiment, when the terminal device is running, it first receives the data extraction instruction sent by the banking business system, and determines the target transaction data to be extracted and the upstream data processing system for processing the target transaction data based on the data extraction instruction. The terminal device then accesses the upstream data processing system to control the upstream data processing system to access the backup database for extracting the target transaction data.

[0059] Exemplarily, for example, when the banking business system needs to process the fund transaction data generated on that day, the banking business system generates a data extraction instruction for controlling the terminal device to extract the target fund transaction data, and sends the data extraction instruction to the terminal device. When the terminal device receives the data extraction instruction, it determines based on the data extraction instruction that the target data to be extracted is the target fund transaction data, and the upstream data processing system for processing the target fund transaction data is the fund data processing system. The terminal device accesses the fund data processing system to control the fund data processing system to access the Oracle standby database contained in the Oracle database for extracting the target fund transaction data.

[0060] Step S20: reading the first data-ready information contained in the standby database, and determining the target operation to be performed according to the first data-ready information;

[0061] It should be noted that the first data-ready information is identification information used to indicate that the target data contained in the standby database and the target data contained in the primary database are in a synchronized state. It can be understood that when there is erroneous data-ready information in the standby database, or there is no data-ready information in the standby database, the terminal device can determine that there are certain differences between the data in the standby database and the data in the primary database.

[0062] In this embodiment, after accessing the standby database, the upstream data processing system reads the first data ready information in the standby database, which is used to indicate whether the target transaction data is in a synchronized state, and sends the first data ready information to the terminal device. The terminal device thereby determines whether the first data ready information is correct, so as to determine whether the target operation it can adopt is a data extraction operation or an extraction stop operation.

[0063] Exemplarily, for example, after accessing the Oracle standby database, the fund data processing system reads the first data ready information contained in the Oracle standby database, which is used to indicate whether the target fund transaction data is in a synchronized state. The fund data processing system then uploads the first data ready information to the terminal device. The terminal device determines whether the first data ready information is correct, and determines whether the target fund transaction data in the Oracle standby database is consistent with the fund transaction data in the Oracle main database based on the determination result, and then determines based on the determination result whether the target operation that can be adopted by itself is a data extraction operation or an extraction stop operation.

[0064] In a feasible implementation manner, the step of “determining the target operation to be performed according to the first data ready information” in the above step S20 may specifically include steps S201 to S203:

[0065] Step S201: obtaining preset standard data-ready information, and comparing the standard data-ready information with the first data-ready information to obtain a first comparison result;

[0066] Step S202: if the first comparison result is that the standard data-ready information and the first data-ready information are consistent, determining that the target operation to be performed is a data extraction operation;

[0067] Step S203: If the first comparison result is that the standard data ready information and the first data ready information are inconsistent, determining that the target operation is an extraction stop operation.

[0068] In this embodiment, after reading the first data-ready information contained in the standby database, the upstream data processing system uploads the first data-ready information to the terminal device. At this time, the terminal device reads the storage device configured by itself to obtain the standard data-ready information used to indicate that the target transaction data is in a synchronized state. The terminal device then compares the first data-ready information with the standard data-ready information to obtain a first comparison result. Thereafter, when the terminal device determines that the first comparison result is that the first data-ready information and the standard data-ready information are consistent, it determines that the first data-ready information is correct, thereby determining that the target operation that can be executed by itself is a data extraction operation. When the terminal device determines that the first comparison result is that the first data-ready information and the standard data-ready information are inconsistent, it determines that the first data-ready information is wrong, thereby determining that the target operation that can be executed by itself is an extraction stop operation.

[0069] Exemplarily, for example, after the fund data processing system reads the first data-ready information contained in the Oracle standby database, the first data-ready information is uploaded to the terminal device. At this time, the terminal device reads the storage module configured by itself to obtain the standard data-ready information used to indicate that the fund transaction data is already in a synchronized state. The terminal device then compares the obtained first data-ready information with the standard data-ready information to obtain a first comparison result. Afterwards, if the terminal device determines that the first comparison result is that the first data-ready information is consistent with the standard data-ready information, it is determined that the target fund transaction data contained in the Oracle standby database at this time and the fund transaction data contained in the Oracle primary database are consistent. If the terminal device determines that the first comparison result is that the first data ready information is inconsistent with the standard data ready information, then it is determined that the target fund transaction data contained in the Oracle standby database is inconsistent with the fund transaction data contained in the Oracle main database, thereby determining that the first data ready information is wrong, and the terminal device further determines that the target fund transaction data cannot be extracted in the Oracle standby database at this time, and determines that the target operation to be executed is the extraction stop operation.

[0070] Step S30: when the target operation is a data extraction operation, extracting target data contained in the standby database;

[0071] In this embodiment, when the terminal device determines that the target operation to be performed is a data extraction operation, each target transaction data contained in the standby database is extracted, and each target transaction data is uploaded to the banking business system for the banking business system to process the target transaction data.

[0072] Exemplarily, for example, when the terminal device determines that the target operation it needs to perform is a data extraction operation, it extracts the target fund transaction data contained in the Oracle standby database, and the terminal device then sends the extracted target fund transaction data to the banking business system for the banking business system to process the target fund transaction data.

[0073] In this embodiment, when the terminal device is running, it first receives the data extraction instruction sent by the banking business system, and determines the target transaction data to be extracted and the upstream data processing system for processing the target transaction data based on the data extraction instruction. The terminal device then accesses the upstream data processing system to control the upstream data processing system to access the standby database for extracting the target transaction data. After that, the upstream data processing system reads the first data ready information in the standby database for indicating whether the target transaction data is in a synchronized state, and sends the first data ready information to the terminal device. The terminal device then determines whether the first data ready information is correct to determine whether the target operation it can adopt is a data extraction operation or an extraction stop operation. Finally, when the terminal device determines that the target operation to be executed is a data extraction operation, it extracts each target transaction data contained in the standby database, and uploads each target transaction data to the banking business system for the banking business system to process each target transaction data.

[0074] In this way, the present application solves the technical problem in the related art that the data user has incomplete asset transaction data. That is, the present application determines whether the asset transaction data in the backup database and the asset transaction data in the main database are synchronized through data ready information, and then enables the terminal device to perform a data extraction operation to obtain the target data when the asset transaction data in the backup database and the main database are synchronized, thereby achieving the technical effect of enabling the terminal device to obtain complete target data and ensuring the consistency between the processed data and the original data.

[0075] Based on the first embodiment of the present application, a second embodiment of the present application is proposed. In the second embodiment of the present application, the same or similar contents as those of the above-mentioned embodiment 1 can be referred to the above introduction and will not be repeated later. On this basis, before the above-mentioned step S10, the data extraction method of the present application can also include steps A10 to A40:

[0076] Step A10: Reading a list of items to be processed, wherein the list of items to be processed contains initial data;

[0077] Step A20: when it is detected that the matter processing list contains the data processing result corresponding to the initial data, obtaining preset first data ready information;

[0078] Step A30: adding the first data-ready information and the initial data to the primary database corresponding to the standby database;

[0079] Step A40: Processing the initial data through the primary database to generate target data, and synchronizing the target data and the first data-ready information to the standby database.

[0080] In this embodiment, before receiving the data extraction instruction sent by the banking business system, the terminal device first receives the initial transaction data to be processed sent by the banking business system, and inputs the obtained initial transaction data into the upstream data processing system used to process the initial transaction data. The upstream system processing system then adds the initial transaction data to the matter processing list, and processes the multiple initial transaction data contained in the matter list in sequence to generate data processing results corresponding to each of the multiple initial transaction data. Afterwards, the upstream processor system traverses the multiple initial transaction data contained in the matter processing list, and when it is determined that each of the multiple initial transaction data has a corresponding data processing result, obtains the preset first data ready information used to indicate that the transaction data is in a synchronized state. Afterwards, the upstream data processing system inputs the first data ready information and each initial transaction data into a main database used to store data. Finally, the main database reads each initial transaction data for processing to generate target transaction data, and synchronizes the target transaction data and the first data ready information to the standby database.

[0081] Exemplarily, for example, the banking business system generates initial fund transaction data during operation, and inputs each initial fund transaction data into the terminal device, and the terminal device then inputs each acquired initial fund transaction data into the above-mentioned fund data processing system, and the fund data processing system adds each acquired initial fund transaction data to the event processing list. After that, the fund data processing system performs batch processing operations on each initial fund transaction data included in the event processing list, and in the process of executing the batch processing operation, generates corresponding data processing results for the processed initial transaction data. At the same time, the fund data processing system traverses the event processing list, and when it detects that the event processing list contains the initial fund transaction data, the fund data processing system generates corresponding data processing results for the processed initial transaction data. When the data processing result corresponding to the initial fund transaction data is obtained, the above-mentioned storage module is read to obtain the first data ready information used to indicate that the fund transaction data is in a synchronized state. After that, the fund data processing system inputs the multiple initial fund transaction data and the first data ready information into the Oracle master database in the Oracle database for storing data. Finally, the Oracle master database sorts the obtained initial fund transaction data, and adds a system change number to each initial fund transaction data to generate multiple target fund transaction data. The Oracle master database thereby synchronizes the multiple target fund transaction data and the first data ready information to the Oracle standby database.

[0082] Please note that, please refer to Figure 3 , Figure 3 This is a schematic diagram of the data synchronization process involved in an embodiment of the data extraction method of this application, such as Figure 3As shown, the specific process of the Oracle main database synchronizing the target fund transaction data and the first data-ready information to the Oracle standby database can be: the Oracle main database writes the target fund transaction data and the first data-ready information into the synchronization configuration file Redo File configured by itself, thereby sending the synchronization configuration file Redo File to the Oracle standby database, and the Oracle standby database reads the change number sequence corresponding to the system change number SCN contained in the synchronization configuration file Redo File, and calls the LogMiner tool configured by itself to convert each target fund transaction data into an SQL statement, and then converts each SQL statement according to the change number sequence to complete the data synchronization operation.

[0083] In this way, after the terminal device detects that the matter corresponding to the initial data is completed through the upstream data processing system, the initial data and data-ready information can be written into the main database, and the main database processes the initial data to generate target data, and then synchronizes the target data and data-ready information to the backup database to ensure that the data in the backup database and the main database are consistent.

[0084] In a feasible implementation manner, the step of "processing the initial data by the master database to generate target data" in the above step A40 may specifically include steps A401 to A402:

[0085] Step A401: determining the order of processing items corresponding to the initial data, and determining the system change number corresponding to the initial data based on the order of processing items;

[0086] Step A402: Add the system change number to the initial data to generate target data.

[0087] In this embodiment, after the upstream data processing system inputs the initial transaction data and the first data-ready information into the main database, the main database first determines the data processing results corresponding to each of the multiple initial transaction data, and determines the matter processing order corresponding to the multiple initial transaction data based on the data processing results. The main database then obtains the system change number corresponding to each of the multiple initial transaction data based on the matter processing order. Afterwards, the main database adds the system change number to the corresponding initial transaction data to generate the target transaction data.

[0088] Exemplarily, for example, after the fund data processing system receives the initial fund transaction data and the first data-ready information into the Oracle master database, the Oracle master database first reads the event processing results corresponding to the initial fund transaction data, and thereby determines the event processing order corresponding to multiple initial fund transaction data according to the event processing results. The Oracle master database then determines the initial fund transaction data that is processed first among the multiple initial fund transaction data according to the event processing order, and determines that the system change number corresponding to the initial fund transaction data that is processed first is SCN-1. The Oracle master database determines that the system change numbers corresponding to the multiple initial fund transaction data are SCN-2, SCN-3, SCN-4, ..., SCN-N according to the event processing order. Afterwards, the Oracle master database adds the multiple system change numbers to the initial fund transaction data that correspond to each other to generate target fund transaction data carrying the system change number SCN.

[0089] In this way, after the terminal device detects that the matter corresponding to the initial data is completed through the upstream data processing system, it can write the initial data and data-ready information into the main database, and the main database processes the initial data to generate target data.

[0090] Based on the first embodiment and / or the second embodiment of the present application, the third embodiment of the present application is proposed here. In the third embodiment of the present application, the same or similar contents as the above embodiments can be referred to the above introduction, and will not be repeated later. On this basis, before the step of "accessing the standby database based on the data extraction instruction" in the above step S10, the data extraction method of the present application can also include steps B10 to B20:

[0091] Step B10: determining a first system time corresponding to the data extraction instruction, and comparing the first system time with a preset data extraction time to obtain a second comparison result;

[0092] Step B20: When the second comparison result is that the first system time has reached the data extraction time, the step of accessing the standby database based on the data extraction instruction is executed.

[0093] In this embodiment, after receiving the data extraction instruction sent by the banking business system, the terminal device determines the first system time when the data extraction instruction is received, and obtains the preset data extraction time that can perform the data extraction operation. The terminal device then compares the first system time and the data extraction time to obtain a second comparison result. Thereafter, when the terminal device determines that the second comparison result is that the first system time reaches the data extraction time, it controls the above-mentioned upstream data processing system to access the backup database for extracting target transaction data in accordance with the data extraction instruction.

[0094] Exemplarily, for example, after receiving the data extraction instruction sent by the banking business system, the terminal device first records the system time when the data extraction instruction is received, and determines the system time when the data extraction instruction is received as the first system time. At the same time, the terminal device determines that the data extraction time at which data extraction can be performed is 0 o'clock, and the terminal device compares the obtained first system time with the data extraction time to obtain a second comparison result. Afterwards, if the terminal device determines that the second comparison result is that the first system time reaches 0 o'clock, it determines that the target fund transaction data can be extracted in the Oracle standby database at the current moment, and the terminal device controls the above-mentioned fund data processing system to access the Oracle standby database to extract the target fund transaction data. If the terminal device determines that the first system time has not reached 0 o'clock, it determines that the target fund transaction data cannot be extracted in the Oracle standby database at the current moment, and thus stops accessing the Oracle standby database.

[0095] In this way, the terminal device can access the standby database in a fixed time period, thereby extracting a large amount of target data contained in the standby database at one time, avoiding the situation where the terminal device extracts target data multiple times in a certain time period.

[0096] Based on the various embodiments of the present application, a fourth embodiment of the present application is proposed here. In the fourth embodiment of the present application, the same or similar contents as the above embodiments can be referred to the above introduction, and will not be repeated later. On this basis, after the above step S20, the data extraction method of the present application can also include steps C10 to C40:

[0097] Step C10: When the target operation is an extraction stop operation, receiving a repeat extraction instruction, and determining a second system time corresponding to the repeat extraction instruction;

[0098] Step C20: determining the interval duration between the second system time and the first system time, and comparing the interval duration with a preset interval threshold to obtain a third comparison result;

[0099] Step C30: If the third comparison result is that the interval duration reaches the interval threshold, reading the standby database to obtain second data ready information;

[0100] Step C40: when it is determined according to the second data-ready information that the target operation to be executed is a data extraction operation, extract the target data contained in the standby database.

[0101] It should be noted that the second data-ready information is data-ready information synchronized to the standby database after the primary database performs the data synchronization operation again.

[0102] In this embodiment, when the terminal device determines that the target operation that it can adopt is an extraction stop operation according to the first data ready information, the terminal device further receives a repeated extraction instruction sent by the banking business system, and determines the second system time when the repeated extraction instruction is received. Thereafter, the terminal device calculates the interval duration between the second system time and the above-mentioned first system time, and obtains a preset interval threshold. The terminal device compares the interval duration with the interval threshold to obtain a third comparison result. Thereafter, if the terminal device determines that the third comparison result is that the interval duration reaches the interval threshold, the above-mentioned upstream data processing system is controlled to access the standby database again to obtain the updated second data ready information in the standby database. Finally, when the terminal device determines that the second data ready information is correct, it determines that the target operation that it can adopt is a data extraction operation, and extracts the target transaction data contained in the standby database.

[0103] Exemplarily, for example, after the terminal device determines that the target operation that it can perform is an extraction stop operation, when it receives a repeated extraction instruction sent by the banking business system, it records the second system time when the repeated extraction instruction is received. Thereafter, the terminal device calculates the interval duration generated between the second system time and the first system time. At the same time, the terminal device determines that the preset interval threshold for extracting the target fund transaction data from the Oracle standby database again is 30 minutes. The terminal device then compares the interval duration with the interval threshold to obtain a third comparison result. Thereafter, if the terminal device determines that the third comparison result is that the interval duration reaches 30 minutes, it determines that the Oracle standby database can be accessed to perform the data extraction operation at this time. The terminal device thus calls the above-mentioned fund data processing system to access the Oracle standby database to obtain the second data ready information. Finally, when the terminal device determines that the second data ready information is correct, it determines that the target operation that it can adopt is the data extraction operation, and accesses the Oracle standby database to extract the target fund data.

[0104] In this way, when the terminal device determines that the data is not ready, it can re-extract the target data from the standby database after a certain interval, thereby avoiding the situation where the terminal device continuously accesses the standby database in a short period of time.

[0105] In addition, in this embodiment and another embodiment, after obtaining the second system time, the terminal device may further compare the second system time with a preset latest time point that is preset to indicate the latest time when the terminal device can extract the target data in the standby database to obtain a fourth comparison result. When the terminal device determines that the fourth comparison result is that the second system time reaches the preset latest time, it determines that the standby database cannot be accessed to extract the target fund transaction data on that day. The terminal device generates an extraction failure message and sends the prompt message to the mobile terminal device used by the user, so that the extraction failure message is displayed to the user through the mobile terminal device, thereby informing the user that the system cannot extract the target data.

[0106] For example, to help understand the implementation process of the interface call type detection method obtained by combining this embodiment with the above embodiments, please refer to Figure 2 , Figure 2 A brief flowchart of a method for detecting an interface call type is provided, specifically:

[0107] In this embodiment, the banking business system generates initial fund transaction data during operation, and inputs each initial fund transaction data into the terminal device, and the terminal device then inputs each acquired initial fund transaction data into the fund data processing system configured by itself, and the fund data processing system inputs the acquired initial fund transaction data into a preset event processing list, and performs batch processing operations on multiple initial fund transaction data in the event processing list, thereby generating data processing results corresponding to the processed initial fund transaction data, and at the same time, the fund data processing system traverses the event processing table, and when it is detected that the event processing table contains data processing results, it obtains the preset first data ready information, and then sends multiple initial fund transaction data and the first data ready information to the Oracle main database, the Oracle main database sorts the acquired initial fund transaction data, and adds the system change number SCN to each initial fund transaction data according to the sorting result to obtain multiple target fund transaction data, and the Oracle main database then synchronizes the multiple target fund transaction data and the first data ready information to the Oracle standby database;

[0108] Afterwards, when the bank business system needs to process the fund transaction data, it generates a data extraction instruction for controlling the terminal device to extract the target fund transaction data, and sends the data extraction instruction to the terminal device. When the terminal device receives the data extraction instruction, it controls the fund data processing system to access the Oracle standby database to obtain the first data ready information contained in the Oracle standby database. When the terminal device detects that the obtained first data ready information is correct, it determines that the data in the Oracle standby database is synchronized with the data in the Oracle main database. The terminal device extracts the target fund transaction data in the Oracle standby database, and uploads the target fund transaction data to the banking business system for the banking business system to process the target fund transaction data.

[0109] It should be noted that the above examples are only used to understand the present application and do not constitute a limitation on the data extraction method of the present application. More simple transformations based on this technical concept are all within the scope of protection of the present application.

[0110] This application also provides a data extraction system, please refer to Figure 4 , the data extraction system comprises:

[0111] The data access module 10 is used to receive a data extraction instruction and access the standby database based on the data extraction instruction;

[0112] The identification judgment module 20 is used to read the first data-ready information contained in the standby database, and determine the target operation to be performed according to the first data-ready information;

[0113] The data extraction module 30 is used to extract the target data contained in the standby database when the target operation is a data extraction operation.

[0114] In a feasible implementation manner, the identification determination module 20 is further configured to:

[0115] Acquire preset standard data-ready information, and compare the standard data-ready information with the first data-ready information to obtain a first comparison result;

[0116] If the first comparison result is that the standard data-ready information and the first data-ready information are consistent, determining that the target operation to be performed is a data extraction operation;

[0117] If the first comparison result is that the standard data-ready information and the first data-ready information are inconsistent, it is determined that the target operation is an extraction stop operation.

[0118] In a feasible implementation manner, the data access module 10 is further used for:

[0119] Reading a matter processing list, wherein the matter processing list includes initial data;

[0120] When it is detected that the matter processing list contains the data processing result corresponding to the initial data, the preset first data ready information is obtained;

[0121] Adding the first data-ready information and the initial data to a primary database corresponding to the standby database;

[0122] The initial data is processed by the primary database to generate target data, and the target data and the first data-ready information are synchronized to the standby database.

[0123] In a feasible implementation manner, the data access module 10 is further used for:

[0124] Determine the order of processing matters corresponding to the initial data, and determine the system change number corresponding to the initial data based on the order of processing matters;

[0125] The system change number is added to the initial data to generate target data.

[0126] In a feasible implementation manner, the data access module 10 is further used for:

[0127] Determine a first system time corresponding to the data extraction instruction, and compare the first system time with a preset data extraction time to obtain a second comparison result;

[0128] When the second comparison result is that the first system time reaches the data extraction time, the step of accessing the standby database based on the data extraction instruction is performed.

[0129] In a feasible implementation manner, the identification determination module 20 is further configured to:

[0130] In the case where the target operation is an extraction stop operation, receiving a repeat extraction instruction, and determining a second system time corresponding to the repeat extraction instruction;

[0131] Determine the interval duration between the second system time and the first system time, and compare the interval duration with a preset interval threshold to obtain a third comparison result;

[0132] If the third comparison result is that the interval duration reaches the interval threshold, reading the standby database to obtain second data ready information;

[0133] When it is determined according to the second data-ready information that the target operation to be executed is a data extraction operation, the target data contained in the standby database is extracted.

[0134] The data extraction system provided by the present application adopts the data extraction method in the above embodiment, which can solve the technical problem of incomplete asset transaction data obtained by the data user in the related technology. Compared with the prior art, the beneficial effects of the data extraction system provided by the present application are the same as the beneficial effects of the data extraction method provided by the above embodiment, and the other technical features of the data extraction system are the same as the features disclosed in the above embodiment method, which will not be repeated here.

[0135] The present application provides a terminal device, which includes: at least one processor; and a memory that is communicatively connected to the at least one processor; wherein the memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the data extraction method in the above-mentioned embodiment one.

[0136] Reference below Figure 5 , which shows a schematic diagram of the structure of a terminal device suitable for implementing the embodiment of the present application. The terminal device in the embodiment of the present application may include but is not limited to a terminal device such as a terminal device with an Oracle database, an upstream data processing system, and a banking system configured therein. Figure 5 The terminal device shown is merely an example and should not bring any limitation to the functions and scope of use of the embodiments of the present application.

[0137] like Figure 5As shown, the terminal device may include a processing device 1001 (e.g., a central processing unit, a graphics processor, etc.), which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM: Read Only Memory) 1002 or a program loaded from a storage device 1003 to a random access memory (RAM: Random Access Memory) 1004. In RAM1004, various programs and data required for the operation of the terminal device are also stored. The processing device 1001, ROM1002, and RAM1004 are connected to each other through a bus 1005. An input / output (I / O) interface 1006 is also connected to the bus. Generally, the following systems can be connected to the I / O interface 1006: an input device 1007 including, for example, a touch screen, a touch pad, a keyboard, a mouse, an image sensor, a microphone, an accelerometer, a gyroscope, etc.; an output device 1008 including, for example, a liquid crystal display (LCD: Liquid Crystal Display), a speaker, a vibrator, etc.; a storage device 1003 including, for example, a magnetic tape, a hard disk, etc.; and a communication device 1009. The communication device 1009 can allow the terminal device to communicate with other devices wirelessly or by wire to exchange data. Although the figure shows a terminal device with various systems, it should be understood that it is not required to implement or have all the systems shown. More or fewer systems can be implemented or have alternatively.

[0138] In particular, according to the embodiments disclosed in the present application, the process described above with reference to the flowchart can be implemented as a computer software program. For example, the embodiments disclosed in the present application include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes a program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network through a communication device, or installed from a storage device 1003, or installed from a ROM 1002. When the computer program is executed by the processing device 1001, the above-mentioned functions defined in the method of the embodiment disclosed in the present application are executed.

[0139] The terminal device provided by this application adopts the data extraction method in the above embodiment, which can solve the technical problem that the data user in the related technology has incomplete asset transaction data. Compared with the prior art, the beneficial effects of the terminal device provided by this application are the same as the beneficial effects of the data extraction method provided by the above embodiment, and the other technical features in the terminal device are the same as the features disclosed in the method of the previous embodiment, which will not be repeated here.

[0140] It should be understood that the various parts disclosed in this application can be implemented by hardware, software, firmware or a combination thereof. In the description of the above embodiments, specific features, structures, materials or characteristics can be combined in any one or more embodiments or examples in a suitable manner.

[0141] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any person skilled in the art who is familiar with the present technical field can easily think of changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.

[0142] The present application provides a computer-readable storage medium having computer-readable program instructions (ie, computer programs) stored thereon, wherein the computer-readable program instructions are used to execute the data extraction method in the above-mentioned embodiment.

[0143] The computer-readable storage medium provided in the present application may be, for example, a USB flash drive, but is not limited to electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems, systems or devices, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, 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 above. In this embodiment, the computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, system or device. The program code contained on the computer-readable storage medium may be transmitted using any appropriate medium, including but not limited to: wires, optical cables, RF (Radio Frequency), etc., or any suitable combination of the above.

[0144] The computer-readable storage medium may be included in the terminal device; or may exist independently without being installed in the terminal device.

[0145] The above-mentioned computer-readable storage medium carries one or more programs. When the above-mentioned one or more programs are executed by a terminal device, the terminal device: receives a data extraction instruction, and accesses a standby database based on the data extraction instruction; reads the first data ready information contained in the standby database, and determines the target operation to be performed based on the first data ready information; and extracts the target data contained in the standby database when the target operation is a data extraction operation.

[0146] Computer program code for performing the operations of the present application may be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, C++, and conventional procedural programming languages ​​such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0147] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present application. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0148] The modules involved in the embodiments described in this application may be implemented by software or hardware, wherein the name of the module does not constitute a limitation on the unit itself in some cases.

[0149] The readable storage medium provided in this application is a computer-readable storage medium, which stores computer-readable program instructions (i.e., computer programs) for executing the above-mentioned data extraction method, and can solve the technical problem of incomplete asset transaction data obtained by data users in related technologies. Compared with the prior art, the beneficial effects of the computer-readable storage medium provided in this application are the same as the beneficial effects of the data extraction method provided in the above-mentioned embodiment, and will not be repeated here.

[0150] The present application also provides a computer program product, including a computer program, which implements the steps of the above-mentioned data extraction method when executed by a processor.

[0151] The computer program product provided by this application can solve the technical problem that the asset transaction data obtained by the data user in the related technology is incomplete. Compared with the prior art, the beneficial effects of the computer program product provided by this application are the same as the beneficial effects of the data extraction method provided by the above embodiment, which will not be repeated here.

[0152] The above descriptions are only some embodiments of the present application, and are not intended to limit the patent scope of the present application. All equivalent structural changes made using the contents of the present application specification and drawings under the technical concept of the present application, or direct / indirect applications in other related technical fields are included in the patent protection scope of the present application.

Claims

1. A data extraction method, characterized in that: The method comprises: receiving a data extraction instruction, and accessing a standby database based on the data extraction instruction; Reading first data-ready information contained in the standby database, and determining a target operation to be performed according to the first data-ready information; In the case where the target operation is a data extraction operation, the target data contained in the standby database is extracted.

2. The method according to claim 1, characterized in that The step of determining a target operation to be performed according to the first data-ready information includes: Acquire preset standard data-ready information, and compare the standard data-ready information with the first data-ready information to obtain a first comparison result; If the first comparison result is that the standard data-ready information and the first data-ready information are consistent, determining that the target operation to be performed is a data extraction operation; If the first comparison result is that the standard data-ready information and the first data-ready information are inconsistent, it is determined that the target operation is an extraction stop operation.

3. The method according to claim 1, characterized in that Before the step of receiving the data extraction instruction, the method further includes: Reading a matter processing list, wherein the matter processing list includes initial data; When it is detected that the matter processing list contains the data processing result corresponding to the initial data, the preset first data ready information is obtained; Adding the first data-ready information and the initial data to a primary database corresponding to the standby database; The initial data is processed by the primary database to generate target data, and the target data and the first data-ready information are synchronized to the standby database.

4. The method according to claim 3, characterized in that The step of processing the initial data through the master database to generate target data includes: Determine a processing order of items corresponding to the initial data, and determine a system change number corresponding to the initial data based on the processing order of items; The system change number is added to the initial data to generate target data.

5. The method according to claim 1, characterized in that Before the step of accessing the standby database based on the data extraction instruction, the method further includes: Determine a first system time corresponding to the data extraction instruction, and compare the first system time with a preset data extraction time to obtain a second comparison result; When the second comparison result is that the first system time reaches the data extraction time, the step of accessing the standby database based on the data extraction instruction is performed.

6. The method according to any one of claims 1 to 5, characterized in that After the step of determining the target operation to be performed according to the first data-ready information, the method further includes: In the case where the target operation is an extraction stop operation, receiving a repeat extraction instruction, and determining a second system time corresponding to the repeat extraction instruction; Determine the interval duration between the second system time and the first system time, and compare the interval duration with a preset interval threshold to obtain a third comparison result; If the third comparison result is that the interval duration reaches the interval threshold, reading the standby database to obtain second data ready information; When it is determined according to the second data-ready information that the target operation to be executed is a data extraction operation, the target data contained in the standby database is extracted.

7. A data extraction system, characterized in that: The system comprises: A data access module, used for receiving a data extraction instruction and accessing a standby database based on the data extraction instruction; an identification judgment module, configured to read the first data-ready information contained in the standby database, and determine a target operation to be performed according to the first data-ready information; The data extraction module is used to extract the target data contained in the standby database when the target operation is a data extraction operation.

8. A terminal device, characterized in that: The device comprises: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the computer program is configured to implement the steps of the data extraction method according to any one of claims 1 to 6.

9. A storage medium, characterized in that: The storage medium is a computer-readable storage medium, and a computer program is stored on the storage medium. When the computer program is executed by a processor, the steps of the data extraction method according to any one of claims 1 to 6 are implemented.

10. A computer program product, characterized in that The computer program product comprises a computer program, and when the computer program is executed by a processor, the steps of the data extraction method according to any one of claims 1 to 6 are implemented.