Data processing methods, apparatus, devices and readable storage media

By automatically calculating the available positions for combined transactions, the problem of delays caused by insufficient positions in transactions for financial institutions has been solved, enabling efficient troubleshooting of transaction issues and reducing manual intervention and time costs.

CN116485532BActive Publication Date: 2026-11-10INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202310263697.0
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2023-03-10
Publication Date
2026-11-10
Estimated Expiration
2043-03-10

AI Technical Summary

Technical Problem

In existing technologies, financial institutions face delays in transactions due to insufficient portfolio positions, requiring significant manpower and time for manual investigation, which cannot meet business needs.

Method used

By acquiring transaction data and transaction details of combined transactions, and utilizing preset packaging tools, triggers, materialized views, and other technologies, the available positions of combined transactions are automatically calculated, and problems are investigated, reducing manual intervention.

Benefits of technology

It enables automatic screening of combined transaction issues, improves transaction efficiency, reduces manual screening costs, and enhances transaction timeliness.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN116485532B_ABST
    Figure CN116485532B_ABST
Patent Text Reader

Abstract

This application provides a data processing method, apparatus, device, and readable storage medium, relating to financial technology or other related fields. The method includes: acquiring transaction data and transaction details data of combined transactions, wherein the transaction data includes combined transactions resulting from combinations of at least two types of transactions; determining the transaction details of each transaction in the combined transactions under different transaction directions based on the transaction details data; determining the available positions of the combined transactions based on the transaction details of each transaction under different transaction directions; and troubleshooting the combined transactions based on the available positions. This technology, by collecting transaction data and calculating the available positions of combined transactions, and by analyzing the available positions of combined transactions, can automatically troubleshoot problems, improving trading efficiency and reducing manual troubleshooting costs.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This application relates to financial technology or other related fields, and in particular to a data processing method, apparatus, device and readable storage medium. Background Technology

[0002] Position is a term in the fintech field used to describe the funds held by financial institutions, etc. Currently, there are often combination trades in trading, which are composed of multiple different types of trades. However, there may be insufficient positions when trading combination trades. In this case, a prompt message is usually output, which will cause trading delays.

[0003] In the current technology, to avoid such a situation of insufficient funds, it is usually the business personnel and technical personnel of financial institutions who jointly conduct a large-scale investigation of transaction data.

[0004] However, as the volume of transactions continues to increase, the current method of manually checking position issues by technical personnel can no longer meet business needs, and it requires huge manpower and time costs. Summary of the Invention

[0005] This application provides a data processing method, apparatus, device, and readable storage medium to address the problem that manual troubleshooting is costly when issues arise in existing transactions.

[0006] In a first aspect, embodiments of this application provide a data processing method, including:

[0007] Acquire transaction data and transaction details of combined transactions, wherein the transaction data includes combined transactions obtained by combining at least two types of transactions;

[0008] Based on the transaction details data, determine the transaction details of each transaction in the combined transaction under different transaction directions;

[0009] Based on the transaction details of each transaction under different transaction directions, determine the available positions of the combined transactions;

[0010] Based on the available positions of the combined trades, troubleshoot the combined trades.

[0011] In one possible design of the first aspect, acquiring transaction data includes:

[0012] The system is packaged using a preset packaging tool to obtain a first file structure, a second file structure, and a third file structure. The first file structure is used to store command files, the second file structure is used to store configuration files, and the third file structure is used to store program files.

[0013] The transaction data is obtained based on the files stored in the first file structure, the files stored in the second file structure, and the files stored in the third file structure.

[0014] In another possible design of the first aspect, the first file structure stores a first command file and a second command file. The first command file is used to start and initialize the data synchronization environment, which includes creating a program, a stored procedure, a materialized view, and a trigger. The second command file is used to clear the data synchronization environment, which includes deleting a program, a stored procedure, a materialized view, and a trigger. Obtaining the transaction data based on the files stored in the first file structure, the second file structure, and the third file structure includes:

[0015] The transaction data details table to be synchronized is determined based on the configuration file.

[0016] Create a materialized view and triggers for the transaction data details table to be synchronized based on the first command file;

[0017] In response to the trigger, the transaction data details table is asynchronously pushed through the program file to obtain the transaction data.

[0018] In another possible design of the first aspect, the transaction details data of the combined transaction are obtained, including:

[0019] Obtain the transaction approval type for the combined transaction;

[0020] Based on the transaction approval type, obtain the transaction details data of the combined transaction from the transaction data.

[0021] In another possible design of the first aspect, determining the transaction details of each transaction in the combined transaction under different transaction directions based on the transaction detail data includes:

[0022] Based on the transaction details data, determine the transaction details for each type of transaction in the combined transaction under the data purchase direction and the transaction details under the data sale direction;

[0023] Correspondingly, determining the available position of the combined trade based on the transaction details of each trade under different trading directions includes:

[0024] Based on the transaction details for each type of transaction under the data purchase direction and the transaction details under the data sale direction, the available position of the combined transaction is calculated by summarizing the details.

[0025] In another possible design of the first aspect, the troubleshooting of the portfolio trade based on the available positions of the portfolio trade includes:

[0026] The available positions of the combined trades are compared with a preset threshold.

[0027] If the available position is less than a preset threshold, then the combined transaction is determined to have a problem.

[0028] In yet another possible design of the first aspect, the method further includes:

[0029] When a problem occurs in the combined transaction, a prompt message is sent to the transaction monitoring center.

[0030] In yet another possible design of the first aspect, the method further includes:

[0031] Push the available positions of the combined trades to the data lake;

[0032] The available positions are displayed through the platform associated with the data lake tables of the data lake.

[0033] Secondly, embodiments of this application provide a data processing apparatus, including:

[0034] The data acquisition module is used to acquire transaction data and transaction details of combined transactions, wherein the transaction data includes combined transactions obtained by combining at least two types of transactions;

[0035] The details determination module is used to determine the transaction details of each transaction in the combined transaction under different transaction directions based on the transaction details data.

[0036] The position determination module is used to determine the available position of the combined transaction based on the transaction details of each transaction under different transaction directions;

[0037] The problem-solving module is used to troubleshoot problems in the combined transactions based on the available positions of the combined transactions.

[0038] Thirdly, embodiments of this application provide a computer device, including: a processor, and a memory communicatively connected to the processor; the memory stores computer execution instructions; the processor executes the computer execution instructions stored in the memory to implement the above-described method.

[0039] Fourthly, embodiments of this application provide a computer-readable storage medium storing computer instructions that, when executed by a processor, are used to implement the above-described method.

[0040] Fifthly, embodiments of this application provide a computer program product, including computer instructions that, when executed by a processor, implement the above-described method.

[0041] The data processing method, apparatus, device, and readable storage medium provided in this application can automatically identify problems by collecting transaction data and calculating the available positions of combined transactions, and by analyzing the available positions of combined transactions, thereby improving transaction efficiency and reducing manual investigation costs. Attached Figure Description

[0042] The accompanying drawings, which are incorporated in and form part of this specification, illustrate embodiments consistent with this application and, together with the description, serve to explain the principles of this application;

[0043] Figure 1 A schematic diagram of a scenario for the data processing method provided in the embodiments of this application;

[0044] Figure 2 A flowchart illustrating the data processing method provided in an embodiment of this application;

[0045] Figure 3 This is a schematic diagram of a data processing method provided in another embodiment of this application;

[0046] Figure 4 A schematic flowchart illustrating a data processing method provided in yet another embodiment of this application;

[0047] Figure 5 This is a schematic diagram of the structure of the data processing apparatus provided in the embodiments of this application;

[0048] Figure 6 A schematic diagram of the structure of a computer device provided in an embodiment of this application;

[0049] The accompanying drawings illustrate specific embodiments of this application, which will be described in more detail below. These drawings and descriptions are not intended to limit the scope of the concept in any way, but rather to illustrate the concept of this application to those skilled in the art through reference to particular embodiments. Detailed Implementation

[0050] To make the objectives, technical solutions, and advantages of the embodiments of this application clearer, the technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, not all embodiments. Based on the embodiments of this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0051] It should be noted that the data processing method, apparatus, device, and readable storage medium disclosed herein can be used in the financial field. They can also be used in any field other than finance. The application areas of the data processing method, apparatus, device, and readable storage medium disclosed herein are not limited.

[0052] First, let me explain the terms used in this application:

[0053] Position: is a financial term that specifically refers to the funds held by a financial institution or individual.

[0054] A trigger is a program block that runs implicitly and automatically when an event occurs. It cannot receive parameters and cannot be called.

[0055] Kafka is a high-throughput distributed publish-subscribe messaging system that can handle streams of action data from all consumers on a website. These actions (web browsing, searching, and other user actions) are a key element of many social functions on the modern web. This data is typically handled through log processing and log aggregation due to throughput requirements.

[0056] Materialized Views: Materialized views are also a type of view. In Oracle, a materialized view is a database object that includes the results of a query. It is a local copy of remote data or used to generate summary tables based on the summation of data tables. Materialized views store data based on remote tables and can also be called snapshots.

[0057] Figure 1 This is a schematic diagram of a scenario for the data processing method provided in the embodiments of this application, such as... Figure 1 As shown, terminal device 11 can be a computer, tablet, personal computer, etc. Various transactions can be initiated through terminal device 11, and server-side 10 generates corresponding transaction data based on the initiated transactions. Currently, in the fintech field, there are various combined transactions composed of different types of transactions. These transactions involve complex approval processes and involve massive amounts of transaction data. When business personnel process these combined transactions, insufficient balance prompts for combined transaction positions occur frequently, leading to delays in transaction timeliness. Faced with this situation, business personnel need to contact technical personnel to conduct extensive checks on transaction data, verifying transaction approval history and transaction data. This consumes significant manpower and time costs and greatly reduces transaction timeliness.

[0058] To address the aforementioned issues, this application provides a data processing method, apparatus, device, and readable storage medium. Based on the integration of transaction flow and batch processing, it collects transaction data and calculates the available positions of combined transactions through processing jobs. Based on the available positions of combined transactions, it enables automatic problem identification, thereby improving transaction efficiency and reducing manual identification costs.

[0059] The technical solution of this application will now be described in detail through specific embodiments. It should be noted that the following specific embodiments can be combined with each other, and the same or similar concepts or processes may not be described again in some embodiments.

[0060] Figure 2 This is a flowchart illustrating the data processing method provided in an embodiment of this application. The execution subject of this method can be the aforementioned terminal device. Figure 2 As shown, the method may specifically include the following steps: Step S201, obtaining transaction data and transaction details data of combined transactions. The transaction data includes combined transactions obtained by combining at least two types of transactions.

[0061] In this embodiment, a combined transaction can be considered as a combination of multiple different types of transactions. For example, a combined transaction may include both physical goods transactions and virtual product transactions. When initiating a combined transaction, the complexity and variety of transaction types involved often lead to a complex transaction approval process and a huge amount of transaction data.

[0062] In this embodiment, the transaction data can be full data, such as all transaction data within a certain time period. The transaction details of a combined transaction can include the transaction amount, transaction time, transaction location, and traded items involved in each type of transaction within the combined transaction. For example, the data source of a relational database management system (such as an Oracle database) can be configured through a configuration file, and transaction data can be obtained based on incremental data collection from Oracle.

[0063] Step S202: Based on the transaction details data, determine the transaction details of each type of transaction in the combined transaction under different transaction directions.

[0064] In this embodiment, the transaction details data includes transaction details for each type of transaction under different transaction directions. For example, taking virtual product transactions in a combination transaction as an example, the transaction details may include the quantity of virtual products under the transaction selling direction and the quantity of virtual products under the transaction buying direction.

[0065] Step S203: Determine the available positions for the combined trade based on the transaction details of each trade under different trading directions.

[0066] In this embodiment, the transaction details of each type of transaction in different transaction directions can be summarized to finally determine the available position of the combined transaction. For example, taking a combined transaction that includes both virtual product transactions and physical goods transactions as an example, if the quantity of virtual products in the buy direction is 10 and the quantity in the sell direction is 5, and the quantity of physical goods in the buy direction is 20 and the quantity in the sell direction is 10, then after summarizing the transaction details of virtual product transactions and physical goods transactions in different transaction directions, the resulting position is: 10-5+20-10=15.

[0067] Step S204: Based on the available positions of the portfolio trades, troubleshoot any issues with the portfolio trades.

[0068] In this embodiment, when the available position for a combined transaction is insufficient, it indicates a problem with the combined transaction and that it may not be able to be completed. For example, if the available position for a combined transaction is 10, and the quantity of physical goods transactions on the sell side is 20 and on the buy side is 0, and the quantity of virtual product transactions on the buy side is 20 and on the buy side is 0, then the available position is insufficient. When the available position is insufficient, an event monitoring message can be sent to a monitoring center (which can be integrated into the terminal device), and business personnel can be alerted via email.

[0069] This application embodiment collects transaction data during the trading process and calculates the available positions of combined transactions. It can analyze the available positions of combined transactions and automatically identify problems of insufficient available positions during the trading process, eliminating the need for manual investigation and reducing labor costs.

[0070] In other embodiments, the above steps for obtaining transaction data can be implemented through the following steps: packaging the data using a preset packaging tool to obtain a first file structure, a second file structure, and a third file structure. The first file structure is used to store command files, the second file structure is used to store configuration files, and the third file structure is used to store program files. Transaction data is obtained based on the files stored in the first file structure, the second file structure, and the third file structure.

[0071] In this embodiment, the default packaging tool can be the maven-assembly-plugin, a Maven plugin that packages a project into a single executable file. It bundles all dependency files together for easy deployment and execution in other environments. The first, second, and third file structures can be three different folder directories. For example, the first file structure could be represented by `bin`, the second by `conf`, and the third by `lib`. The first file structure contains command files, the second by configuration files, and the third by program files.

[0072] In this embodiment, incremental data can be collected and transaction data obtained by sending triggers, materialized views, stored procedures, and programs (such as JAVA programs) to the message queue of a message middleware (such as Kafka message middleware).

[0073] This application embodiment uses a preset packaging tool to package data into a first file structure, a second file structure, and a third file structure. Corresponding files are stored in the first file structure, the second file structure, and the third file structure. Incremental data collection is performed to obtain transaction data, which facilitates subsequent analysis of available positions in combined transactions. No manual intervention is required for position analysis of combined transactions, reducing the time cost of manual investigation and improving the real-time performance of transactions.

[0074] Furthermore, based on the above embodiments, in some other embodiments, the first file structure stores a first command file and a second command file. The first command file is used to start and initialize the data synchronization environment, which includes creating a program, a stored procedure, a materialized view, and a trigger. The second command file is used to clear the data synchronization environment, which includes deleting the program, the stored procedure, the materialized view, and the trigger. The above step of "obtaining transaction data according to the files stored in the first file structure, the second file structure, and the third file structure" can be implemented through the following steps: determining the transaction data detail table to be synchronized according to the configuration file; creating a materialized view and a trigger for the transaction data detail table to be synchronized according to the first command file; and asynchronously pushing the transaction data detail table through the program file in response to the trigger to obtain the transaction data.

[0075] In this embodiment, the first command file can be represented as start.sh, which is used to start and initialize the data synchronization environment, including creating programs (e.g., JAVA programs), stored procedures, materialized views, and triggers. The second command file can be represented as clear.sh, which is used to clear the data synchronization environment, including deleting programs (e.g., JAVA programs), stored procedures, materialized views, and triggers.

[0076] The trigger can be an Oracle trigger, a block of code that runs implicitly and automatically when an event occurs; it cannot receive parameters and cannot be invoked. The materialized view can be an Oracle materialized view, a database object that includes the results of a query; it can be a local copy of remote data or used to generate a summary table based on the sum of data tables. Materialized views store data based on remote tables and can also be called snapshots.

[0077] In this embodiment, the configuration file can specify the transaction data detail table that needs to be synchronized, and automatically create materialized views and triggers for the transaction data detail table by executing the first command file start.sh. The JAVA program can push the transaction data detail table to the message queue of the Kafka message middleware through an asynchronous sending mechanism to provide basic transaction data for subsequent processing jobs.

[0078] For example, Figure 3 This is a schematic flowchart of a data processing method provided in another embodiment of this application, as shown below. Figure 3 As shown, it includes the following steps: Step S301, configuring the data source in the configuration file. Step S302, initializing the environment in the first command file. Step S303, the program created by the first command file asynchronously pushes messages. Step S304, the message queue of the message middleware receives the pushed messages. The pushed messages can be basic transaction data, such as the transaction data detail table mentioned above.

[0079] This application embodiment obtains transaction data details through incremental data collection using triggers, materialized views, stored procedures, and Java programs, and pushes them asynchronously through a Kafka message queue. This provides a data foundation for analyzing the available positions of subsequent combined transactions and promptly identifies whether there are insufficient available positions in the combined transactions.

[0080] In some embodiments, the step of "obtaining transaction details data of the combined transaction" mentioned above can be implemented through the following steps: obtaining the transaction approval type of the combined transaction; and obtaining the transaction details data of the combined transaction from the transaction data according to the transaction approval type.

[0081] In this embodiment, a first processing job, denoted as Prepare, can be created. This job can obtain transaction detail data based on the transaction approval type. Different types of transactions may correspond to different approval types. For example, for physical item transactions, the corresponding approval type is "Physical Item Approval," while for virtual product transactions, the approval type is "Virtual Product Approval." When approving a transaction, the required transaction detail data also differs depending on the approval type. For instance, for physical item transactions, the corresponding approval type is "Physical Item Approval," and the required transaction detail data may include basic attributes such as the physical item's appearance and performance. For virtual product transactions, the corresponding approval type is "Virtual Item Approval," and the required transaction detail data mainly includes the quantity of the virtual item.

[0082] In this embodiment, based on the transaction approval type of the combined transaction, the data required for approval can be determined and used as the transaction details data of the combined transaction.

[0083] This application embodiment filters and transforms the transaction data pushed in the Kafka message queue and obtains the transaction details data of the combined transactions through processing jobs. This enables a thorough analysis of the available positions of the combined transactions, reducing the time and manpower costs required for manual investigation and improving transaction efficiency.

[0084] In some embodiments, step S202 can be implemented as follows: based on the transaction details data, determine the transaction details for each type of transaction in the data purchase direction and the transaction details for each type of transaction in the data sale direction. Correspondingly, step S203 can be implemented as follows: based on the transaction details for each type of transaction in the data purchase direction and the transaction details for each type of transaction in the data sale direction, calculate the available position of the combined transaction.

[0085] In this embodiment, the newly created Prepare processing job in the above embodiments can calculate combined transaction position details based on the buy and sell transaction directions in the transaction details data and push them to the message queue of the message middleware (e.g., Kafka). Here, the data purchase direction refers to the transaction buy direction, and the data sell direction refers to the transaction sell direction.

[0086] Alternatively, a second processing job can be created, denoted by Process. This Process job consumes transaction position details from the message queue and, based on the dimension of transaction combination, summarizes transaction data of various types to calculate the available position of the entire combination transaction.

[0087] For example, taking a combined transaction that includes both virtual product transactions and physical item transactions as an example, if the quantity of virtual products in the buy direction is 10 and the quantity in the sell direction is 5, and the quantity of physical items in the buy direction is 20 and the quantity in the sell direction is 10, then after summarizing the transaction details of virtual product transactions and physical item transactions under different transaction directions, the available position is calculated as: 10-5+20-10=15.

[0088] This application embodiment determines the available positions of a combined transaction by analyzing the buy and sell directions in the transaction details data. It can analyze the available positions of the combined transaction, monitor in real time whether the available positions are insufficient, and understand the calculation source of the available positions. This analysis of available positions avoids manual investigation when available positions are insufficient, reduces the cost of manual investigation, improves investigation efficiency, and thus further improves transaction efficiency.

[0089] In other embodiments, step S204 can be implemented by the following steps: comparing the available position of the combined transaction with a preset threshold; if the available position is less than the preset threshold, it is determined that there is a problem with the combined transaction.

[0090] In this embodiment, the newly created Process job in the above embodiments can also determine whether the number of available positions is sufficient. If the number of available positions is insufficient, it can be determined that there is a problem with the current portfolio transaction, which may lead to transaction delays. For example, in other embodiments, when there is a problem with the portfolio transaction, a prompt message can be sent to the transaction monitoring center (which can be a terminal device or a cloud server) and an email reminder can be sent to business personnel, thereby eliminating the need for manual troubleshooting and reducing labor costs. The preset threshold can be set according to actual conditions, for example, set to 0.

[0091] This application embodiment monitors the available positions of combined transactions, enabling business personnel to promptly understand the transaction status, quickly troubleshoot current transactions, ensure timely problem response, and improve transaction efficiency.

[0092] In other embodiments, the method may further include the following steps: pushing available positions of the combined trades to the data lake; and displaying the available positions through the platform associated with the data lake table of the data lake.

[0093] In this embodiment, a third processing job, denoted as BatchProcee, can be created. This BatchProcee job consumes transaction position details from the message queue, calculates available positions at the transaction combination level, and pushes the available positions and other related transaction data to the data lake. The data lake tables can be associated with a display platform to display the available position details of the combined transactions. For example, the current available positions of the combined transactions, the positions required for the transactions to be executed, and historical position data can be displayed.

[0094] For example, Figure 4 A flowchart illustrating a data processing method provided in another embodiment of this application is shown below. Figure 4 As shown, the method may include the following steps: Step S401, a first processing job filters and transforms the detailed data of combined trading positions. Step S402, a second processing job calculates available positions based on the combined trading dimension and monitors whether available positions are insufficient. Step S403, a third processing job pushes the data to the data lake. Step S404, the display platform displays the data lake table.

[0095] This application embodiment pushes data to a data lake and displays it on the platform through data lake tables, which allows business personnel to intuitively understand position details and achieve position analysis of portfolio transactions. This avoids large-scale manual screening of transaction data, improves the efficiency of problem investigation, and avoids transaction delays.

[0096] The following are embodiments of the apparatus described in this application, which can be used to execute the embodiments of the method described in this application. For details not disclosed in the apparatus embodiments of this application, please refer to the embodiments of the method described in this application.

[0097] Figure 5 This is a schematic diagram of the structure of a data processing apparatus provided in an embodiment of this application. This data processing apparatus can be integrated into a terminal device (e.g., a computer device), such as... Figure 5 As shown, the data processing device 500 includes a data acquisition module 510, a detail determination module 520, a position determination module 530, and a problem investigation module 540. The data acquisition module 510 acquires transaction data and transaction detail data of combined transactions, including combined transactions resulting from combinations of at least two types of transactions. The detail determination module 520 determines the transaction details of each type of transaction in the combined transactions under different trading directions based on the transaction detail data. The position determination module 530 determines the available position of the combined transactions based on the transaction details of each type of transaction under different trading directions. The problem investigation module 540 performs problem investigation on the combined transactions based on the available position.

[0098] Optionally, the data acquisition module can be used to: package the data using a preset packaging tool to obtain a first file structure, a second file structure, and a third file structure. The first file structure is used to store command files, the second file structure is used to store configuration files, and the third file structure is used to store program files; and acquire transaction data based on the files stored in the first file structure, the second file structure, and the third file structure.

[0099] Optionally, the first file structure contains a first command file and a second command file. The first command file is used to start and initialize the data synchronization environment, which includes creating programs, stored procedures, materialized views, and triggers. The second command file is used to clear the data synchronization environment, which includes deleting programs, stored procedures, materialized views, and triggers. Specifically, the data acquisition module can be used to: determine the transaction data detail table to be synchronized based on the configuration file; create a materialized view and triggers for the transaction data detail table to be synchronized based on the first command file; and, in response to the triggers, asynchronously push the transaction data detail table through the program file to obtain the transaction data.

[0100] Optionally, the data acquisition module can be used to: obtain the transaction approval type of the combined transaction; and, based on the transaction approval type, obtain the transaction details data of the combined transaction from the transaction data.

[0101] Optionally, the details determination module can be used to: determine the transaction details for each type of transaction in the combined transaction under the data purchase direction and the data sale direction, based on the transaction details data. Correspondingly, the position determination module can be used to: calculate the available position of the combined transaction based on the transaction details for each type of transaction under the data purchase direction and the data sale direction.

[0102] Optionally, the problem-solving module can be used to: compare the available positions of the portfolio trade with a preset threshold; if the available positions are less than the preset threshold, then it is determined that there is a problem with the portfolio trade.

[0103] Optionally, the data processing device may also include a prompting module, which is used to send a prompt message to the transaction monitoring center when there is a problem with the combined transaction.

[0104] Optionally, the aforementioned data processing device may further include a position display module for pushing available positions of combined transactions to the data lake; and displaying available positions through the platform associated with the data lake table of the data lake.

[0105] The apparatus provided in this application embodiment can be used to execute the methods in the above embodiments, and its implementation principle and technical effect are similar, so they will not be described again here.

[0106] It should be noted that the division of the various modules in the above device is merely a logical functional division. In actual implementation, they can be fully or partially integrated into a single physical entity, or they can be physically separated. Furthermore, these modules can be implemented entirely in software via processing elements; they can be fully implemented in hardware; or some modules can be implemented by processing elements calling software, while others are implemented in hardware. For example, the data acquisition module can be a separate processing element, or it can be integrated into a chip in the above device. Alternatively, it can be stored as program code in the memory of the above device, and its functions can be called and executed by a processing element. The implementation of other modules is similar. Moreover, these modules can be fully or partially integrated together, or they can be implemented independently. The processing element here can be an integrated circuit with signal processing capabilities. In the implementation process, each step of the above method or each of the above modules can be completed through integrated logic circuits in the hardware of the processor element or through software instructions.

[0107] Figure 6 A schematic diagram of the structure of a computer device provided in an embodiment of this application. For example... Figure 6 As shown, the computer device 600 includes at least one processor 601, a memory 602, a bus 603, and a communication interface 604.

[0108] The processor 601, communication interface 604, and memory 602 communicate with each other via bus 603. Communication interface 604 is used to communicate with other devices. This communication interface includes a communication interface for data transmission and a display interface or operation interface for human-computer interaction. The processor 601 executes computer execution instructions stored in the memory, specifically performing the relevant steps in the methods described in the above embodiments.

[0109] The processor may be a central processing unit, an application-specific integrated circuit (ASIC), or one or more integrated circuits configured to implement embodiments of the present invention. The computer device includes one or more processors, which may be processors of the same type, such as one or more CPUs; or processors of different types, such as one or more CPUs and one or more ASICs. The memory is used to store instructions executed by the computer. The memory may include high-speed RAM, and may also include non-volatile memory, such as at least one disk storage device.

[0110] This embodiment also provides a computer-readable storage medium storing computer instructions, which, when executed by at least one processor of a computer device, enable the computer device to perform the methods provided in the various embodiments described above.

[0111] This embodiment also provides a computer program product including computer instructions stored in a readable storage medium. At least one processor of a computer device can read the computer instructions from the readable storage medium, and the at least one processor executes the computer instructions to cause the computer device to perform the methods provided in the various embodiments described above.

[0112] In this application, "at least one" means one or more, and "more than one" means two or more. "And / or" describes the relationship between related objects, indicating that three relationships can exist. For example, A and / or B can represent: A alone, A and B simultaneously, or B alone, where A and B can be singular or plural. The character " / " generally indicates an "or" relationship between the preceding and following related objects; in formulas, the character " / " indicates a "division" relationship. "At least one of the following" or similar expressions refer to any combination of these items, including any combination of single or plural items. For example, at least one of a, b, or c can represent: a, b, c, ab, ac, bc, or abc, where a, b, and c can be single or multiple.

[0113] It is understood that the various numerical designations used in the embodiments of this application are merely for descriptive convenience and are not intended to limit the scope of the embodiments of this application. In the embodiments of this application, the order of the above-mentioned process numbers does not imply the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of this application.

[0114] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of this application, and are not intended to limit them. Although this application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some or all of the technical features therein. Such modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of this application.

Claims

1. A data processing method, characterized in that, include: Acquire transaction data and transaction details of combined transactions, wherein the transaction data includes combined transactions obtained by combining at least two types of transactions; Based on the transaction details data, determine the transaction details of each transaction in the combined transaction under different transaction directions; Based on the transaction details of each transaction under different transaction directions, determine the available positions of the combined transactions; Based on the available positions of the combined trades, troubleshoot the combined trades. The acquisition of transaction data includes: The system is packaged using a preset packaging tool to obtain a first file structure, a second file structure, and a third file structure. The first file structure is used to store command files, the second file structure is used to store configuration files, and the third file structure is used to store program files. The first file structure contains a first command file and a second command file. The first command file is used to start and initialize the data synchronization environment, which includes creating a program, a stored procedure, a materialized view, and a trigger. The second command file is used to clear the data synchronization environment, which includes deleting a program, a stored procedure, a materialized view, and a trigger. The transaction data details table to be synchronized is determined based on the configuration file. Create a materialized view and triggers for the transaction data details table to be synchronized based on the first command file; In response to the trigger, the transaction data details table is asynchronously pushed through the program file to obtain the transaction data.

2. The method according to claim 1, characterized in that, Obtain detailed transaction data for portfolio trades, including: Obtain the transaction approval type for the combined transaction; Based on the transaction approval type, obtain the transaction details data of the combined transaction from the transaction data.

3. The method according to claim 1, characterized in that, The step of determining the transaction details of each transaction in the combined transaction under different transaction directions based on the transaction detail data includes: Based on the transaction details data, determine the transaction details for each type of transaction in the combined transaction under the data purchase direction and the transaction details under the data sale direction; Correspondingly, determining the available position of the combined trade based on the transaction details of each trade under different trading directions includes: Based on the transaction details for each type of transaction under the data purchase direction and the transaction details under the data sale direction, the available position of the combined transaction is calculated by summarizing the details.

4. The method according to claim 1, characterized in that, The step of troubleshooting the combined trades based on available positions includes: The available positions of the combined trades are compared with a preset threshold. If the available position is less than a preset threshold, then the combined transaction is determined to have a problem.

5. The method according to claim 4, characterized in that, The method further includes: When a problem occurs in the combined transaction, a prompt message is sent to the transaction monitoring center.

6. The method according to claim 1, characterized in that, The method further includes: Push the available positions of the combined trades to the data lake; The available positions are displayed through the platform associated with the data lake tables of the data lake.

7. A data processing apparatus, characterized in that, include: The data acquisition module is used to acquire transaction data and transaction details of combined transactions, wherein the transaction data includes combined transactions obtained by combining at least two types of transactions; The details determination module is used to determine the transaction details of each transaction in the combined transaction under different transaction directions based on the transaction details data. The position determination module is used to determine the available position of the combined transaction based on the transaction details of each transaction under different transaction directions; The problem-solving module is used to troubleshoot problems in the combined transaction based on the available positions of the combined transaction. The data acquisition module is specifically used to package data using a preset packaging tool to obtain a first file structure, a second file structure, and a third file structure. The first file structure stores command files, the second file structure stores configuration files, and the third file structure stores program files. The first file structure contains a first command file and a second command file. The first command file is used to start and initialize the data synchronization environment, which includes creating programs, stored procedures, materialized views, and triggers. The second command file is used to clear the data synchronization environment, which includes deleting programs, stored procedures, materialized views, and triggers. The module determines the transaction data detail table to be synchronized based on the configuration file. The first command file creates the materialized view and triggers for the transaction data detail table to be synchronized. In response to the trigger, the transaction data details table is asynchronously pushed through the program file to obtain the transaction data.

8. A computer device, characterized in that, include: A processor, and a memory communicatively connected to the processor; The memory stores computer-executed instructions; The processor executes computer execution instructions stored in the memory to implement the method as described in any one of claims 1-6.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer instructions that, when executed by a processor, are used to implement the method as described in any one of claims 1-6.

10. A computer program product comprising computer instructions, characterized in that, When executed by a processor, the computer instructions implement the method described in any one of claims 1-6.

Citation Information

Patent Citations

  • Bank position monitoring method and device, and fund position management system

    CN108446972A

  • Fund position real-time monitoring method and device, electronic equipment and storage medium

    CN112634046A