Data processing method and device, electronic equipment and storage medium

Abstract

The present disclosure provides a data processing method and device, electronic equipment and storage medium, relating to the technical field of computer, the method comprising: in response to a data processing request, associating the registration information table and the issuance information table of the to-be-processed bond to construct a basic information table, and based on the basic information table, obtaining the issuance start time, issuance end time and first issuance amount of each issuance of the to-be-processed bond, and determining the issuance amount time interval according to the issuance start time and the issuance end time, and determining the issuance amount quota occupied by the issuance amount time interval according to the first issuance amount, which can process the data table related to the bond to construct the issuance amount time interval and determine the occupied issuance amount quota. Since there is no overlapping time between the issuance amount time intervals, the quota occupation of the bond in any time interval can be accurately calculated, which is beneficial for subsequent related personnel to conduct risk monitoring and avoid compliance risks.

Description

TECHNICAL FIELD

[0001] The present disclosure relates to the technical field of computer, and particularly relates to a data processing method and device, electronic equipment and storage medium. BACKGROUND

[0002] When a commercial bank assists an enterprise to issue bonds as an underwriter, the enterprise can issue bonds for financing one or more times according to its own needs within a specified time interval. When the commercial bank underwrites and issues these bonds, it needs to ensure compliance and ensure that the total amount of each outstanding bond does not exceed the registered amount at any time point within the specified time interval. Since multiple issuances may overlap in time, the issuance start and end times cannot accurately calculate the bond amount usage within the specified time interval. In addition, the amount usage in the prior art is mainly calculated manually by manpower. In the face of thousands of bonds, the commercial bank needs to invest a lot of manpower and resources to check the status of each bond, which is time-consuming and laborious, and is prone to errors or omissions, causing compliance risks, customer bond issuance failures and other problems. SUMMARY

[0003] The present disclosure proposes a data processing method, device, electronic equipment and storage medium, aiming to at least solve one of the technical problems in the related art to some extent.

[0004] The first aspect embodiment of the present disclosure proposes a data processing method, comprising: in response to a data processing request, associating a registration information table and an issuance information table of a to-be-processed bond to construct a basic information table; based on the basic information table, obtaining an issuance start time, an issuance end time and a first issuance amount of each issuance of the to-be-processed bond; determining issuance amount time intervals according to the issuance start time and the issuance end time, wherein there is no overlapping time between the issuance amount time intervals; and determining an issuance amount occupied by the issuance amount time intervals according to the first issuance amount.

[0005] The second aspect embodiment of the present disclosure proposes a data processing device, comprising: a construction module configured to, in response to a data processing request, associate a registration information table and an issuance information table of a to-be-processed bond to construct a basic information table; a first obtaining module configured to, based on the basic information table, obtain an issuance start time, an issuance end time and a first issuance amount of each issuance of the to-be-processed bond; a first determining module configured to determine issuance amount time intervals according to the issuance start time and the issuance end time, wherein there is no overlapping time between the issuance amount time intervals; and a second determining module configured to determine an issuance amount occupied by the issuance amount time intervals according to the first issuance amount.

[0006] The third aspect of the present disclosure provides an electronic device, comprising: a processor; a memory for storing processor-executable instructions; wherein the processor is configured to execute the instructions to implement the data processing method.

[0007] The fourth aspect of the present disclosure provides a computer-readable storage medium, when the instructions in the computer-readable storage medium are executed by the processor of the electronic device, the electronic device can execute the data processing method.

[0008] The fifth aspect of the present disclosure provides a computer program product, comprising a computer program, characterized in that the computer program is executed by the processor to execute the data processing method or the file providing method.

[0009] In the embodiment, by responding to the data processing request, the registration information table and the issuance information table of the to-be-processed bond are associated to construct the basic information table, and based on the basic information table, the issuance start time, the issuance end time and the first issuance amount of each issuance of the to-be-processed bond are obtained, and according to the issuance start time and the issuance end time, the issuance amount time interval is determined, and according to the first issuance amount, the issuance amount time interval occupied by the issuance amount is determined. The data table related to the bond can be processed to construct the issuance amount time interval and determine the occupied issuance amount. Since there is no overlapping time between the determined issuance amount time intervals, the quota occupation situation of the bond at any time interval can be accurately calculated, which is beneficial to subsequent risk monitoring by related personnel. In addition, the embodiment can reduce the time and labor cost and improve the calculation accuracy, thereby avoiding compliance risks, customer bond issuance failures and the like.

[0010] The additional aspects and advantages of the present disclosure will be partially given in the following description, partially will become obvious from the following description, or will be understood by practicing the present disclosure. BRIEF DESCRIPTION OF DRAWINGS

[0011] The above and / or additional aspects and advantages of the present disclosure will become apparent and more readily understood from the following description, taken in conjunction with the accompanying drawings, in which:

[0012] Figure 1 is a flowchart of a data processing method according to the first embodiment of the present disclosure;

[0013] Figure 2 is a flowchart of a data processing method according to the second embodiment of the present disclosure;

[0014] Figure 3 is a flowchart of a data processing method according to the third embodiment of the present disclosure;

[0015] Figure 4is a data processing process schematic diagram according to an embodiment of the present disclosure;

[0016] Figure 5 is a block diagram of a data processing device according to the present disclosure;

[0017] Figure 6 A block diagram of an exemplary electronic device suitable for implementing embodiments of the present disclosure is shown. DETAILED DESCRIPTION

[0018] Embodiments of the present disclosure are described in detail below with reference to the accompanying drawings, examples of which are shown in the drawings, wherein the same or similar notations represent the same or similar elements or elements having the same or similar functions throughout. The embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the present disclosure and cannot be understood as a limitation of the present disclosure. On the contrary, embodiments of the present disclosure include all changes, modifications and equivalents falling within the spirit and scope of the appended claims.

[0019] It should be noted that the execution subject of the data processing method of the present embodiment can be a data processing device, which can be implemented by software and / or hardware, and the device can be configured in an electronic device, which can include but is not limited to a terminal, a server, etc.

[0020] Figure 1 is a flowchart of a data processing method according to the first embodiment of the present disclosure, as shown in Figure 1 The method comprises:

[0021] S101: In response to a data processing request, associating the registration information table and the issuance information table of the bond to be processed to construct a basic information table.

[0022] In the present embodiment, when the bank needs to calculate the bond quota occupation, the bank personnel can send a data processing request to the bank background system through the client, wherein the data processing request can include the information of the bond to be processed. In this case, the background system can determine the registration information table and the issuance information table according to the information of the bond to be processed, wherein the registration information table is used to record the registration information of the bond to be processed, and the issuance information table is used to record the issuance information of each issuance of the bond to be processed. Further, the background system can associate the registration information table and the issuance information table to construct the basic information table of the bond to be processed, as shown in Table 1 below:

[0023] Table 1

[0024]

[0025] S102: Obtain, based on the basic information table, the issuance start time, the issuance end time, and the first issuance amount of each issuance of the to-be-processed bond.

[0026] That is, the embodiment can perform a query operation based on the basic information table of the to-be-processed bond to obtain the issuance start time, the issuance end time, and the first issuance amount of each issuance of the to-be-processed bond.

[0027] The start time of each issuance of the bond by the bank can be referred to as the issuance start time, the end time of each issuance can be referred to as the issuance end time, and the amount of the bond issued from the start time to the end time of each issuance can be referred to as the first issuance amount.

[0028] For example, the issuance numbers 01, 02, and 03 in Table 1 represent three issuance information of the 001 bond, and the embodiment can perform a query operation on Table 1 to obtain the issuance start time, the issuance end time, and the first issuance amount (the issuance amount in Table 1) of the three issuances. Some embodiments can perform a horizontal operation on the issuance start time and the issuance end time through two query operations; further, if the issuance start time or the issuance end time of multiple issuances is the same, a union function can be used to perform a de-duplication process and only one piece of data is retained.

[0029] S103: Determine the issuance amount time interval according to the issuance start time and the issuance end time.

[0030] After obtaining the issuance start time and the issuance end time, further, the embodiment of the disclosure can determine one or more issuance amount time intervals according to the issuance start time and the issuance end time.

[0031] The issuance amount time interval is used to describe the amount occupancy of different time intervals during bond issuance, and there is no overlapping time between the issuance amount time intervals.

[0032] Some embodiments, if there is no overlapping time between the issuance start time and the issuance end time of any issuance number and the issuance start time and the issuance end time of other issuance numbers, the issuance start time and the issuance end time can be taken as an issuance amount time interval. For example, there is no overlapping time between the issuance start time and the issuance end time of the issuance number 01 and the issuance start time and the issuance end time of the issuance numbers 02 and 03, and the embodiment can take the issuance start time and the issuance end time of the issuance number 01 as an issuance amount time interval, that is, 2021.1.1-2021.1.15 is an issuance amount time interval.

[0033] Some embodiments, if there is an overlapping time between the issuance start time to issuance end time of any issuance number and the issuance start time to issuance end time of other issuance number, the issuance amount time interval can be determined according to the issuance start time to issuance end time and the issuance start time to issuance end time that exist overlap. For example, there is an overlapping time 2021.1.20-2021.1.31 between the issuance start time to issuance end time of issuance number 02 and the issuance start time to issuance end time of issuance number 03, in this case, the present embodiment can determine the issuance amount time interval according to 2021.1.16, 2021.1.31, 2021.1.20, 2021.2.28, some embodiments, 2021.1.16-2021.1.19, 2021.1.20-2021.1.31, 2021.2.1-2021.2.28 can be used as the issuance amount time interval.

[0034] That is to say, for the issuance start time and issuance end time of the above-mentioned three issuances of issuance number 01, 02, 03, the present embodiment can determine four issuance amount time intervals 2021.1.1-2021.1.15, 2021.1.16-2021.1.19, 2021.1.20-2021.1.31, 2021.2.1-2021.2.28.

[0035] S104: Determine the issuance amount of the issuance amount time interval according to the first issuance amount.

[0036] After determining the issuance amount time interval, further, the present embodiment can determine the issuance amount of the issuance amount time interval according to the first issuance amount, that is to say, determine the issuance amount of the above-mentioned four issuance amount time intervals 2021.1.1-2021.1.15, 2021.1.16-2021.1.19, 2021.1.20-2021.1.31, 2021.2.1-2021.2.28.

[0037] Some embodiments, if any issuance amount time interval is located between the issuance start time to issuance end time of an issuance, the first issuance amount of the issuance start time to issuance end time is used as the issuance amount of the issuance amount time interval.

[0038] For example, the issuance amount time interval 2021.1.1-2021.1.15 is only located between the issuance start time and the issuance end time of the issuance number 01, and thus the first issuance amount of the issuance number 01 can be directly used as the issuance quota of the issuance amount time interval 2021.1.1-2021.1.15, i.e., the issuance quota is 1 million; similarly, the issuance amount time interval 2021.1.16-2021.1.19 is located between the issuance start time and the issuance end time of the issuance number 02, and thus the first issuance amount of the issuance number 02 can be used as the issuance quota occupied by the issuance amount time interval 2021.1.16-2021.1.19, i.e., the issuance quota is 2 million; similarly, the issuance amount time interval 2021.2.1-2021.2.28 is only located between the issuance start time and the issuance end time of the issuance number 03, and thus the first issuance amount of the issuance number 03 can be directly used as the issuance quota of the issuance amount time interval 2021.2.1-2021.2.28, i.e., the issuance quota is 5 million.

[0039] In some other embodiments, if any issuance amount time interval is located between the issuance start time and the issuance end time of at least two issuances, the first issuance amounts of the at least two issuances are added to obtain the issuance quota occupied by the issuance amount time interval.

[0040] For example, the issuance amount time interval 2021.1.20-2021.1.31 is located between the issuance start time and the issuance end time of the issuance numbers 02 and 03, i.e., the issuance start time and the issuance end time of the issuance numbers 02 and 03 overlap, and thus the first issuance amounts of the issuance numbers 02 and 03 are added to obtain the issuance quota occupied by the issuance amount time interval 2021.1.20-2021.1.31, i.e., the issuance quota is 7 million.

[0041] In actual applications, the present embodiment can construct an issuance amount interval information table according to the issuance amount time interval and the corresponding issuance quota, as shown in Table 2:

[0042] Table 2

[0043]

[0044] In the embodiment, by associating the registration information table and the issuance information table of the to-be-processed bond to construct a basic information table in response to a data processing request, and based on the basic information table, the issuance start time, the issuance end time and the first issuance amount of each issuance of the to-be-processed bond are acquired, and according to the issuance start time and the issuance end time, the issuance amount time interval is determined, and according to the first issuance amount, the issuance amount time interval occupied issuance amount is determined. The data table related to the bond can be processed to construct the issuance amount time interval and determine the occupied issuance amount. Since there is no overlapping time between the issuance amount time intervals, the quota occupation situation of the bond at any time interval can be accurately calculated, which is beneficial for subsequent personnel to monitor the issuance risk. In addition, the embodiment can reduce the time and labor cost and improve the calculation accuracy, thereby avoiding compliance risks, customer bond issuance failures and the like.

[0045] It should be noted that in the technical solutions of the present disclosure, the acquisition, storage and application of the financial data related to bond issuance comply with relevant laws and regulations and do not violate public order and good customs.

[0046] Figure 2 is a flowchart of a data processing method according to the second embodiment of the present disclosure, as shown in Figure 2 , the method comprises:

[0047] S201: In response to a data processing request, associating the registration information table and the issuance information table of the to-be-processed bond to construct a basic information table.

[0048] S202: Based on the basic information table, acquiring the issuance start time, the issuance end time and the first issuance amount of each issuance of the to-be-processed bond.

[0049] The specific description of S201-S202 can be referred to the above embodiment, which will not be repeated here.

[0050] S203: Respectively determining the time identifiers corresponding to the issuance start time and the issuance end time.

[0051] In the operation of determining the issuance amount time interval according to the issuance start time and the issuance end time, the time identifier corresponding to the issuance start time and the time identifier corresponding to the issuance end time can be determined first, that is, the issuance start time and the issuance end time are time labeled.

[0052] For example, the time identifier of the issuance start time of the present embodiment can be "1", and the time identifier of the issuance end time can be "2", or other arbitrary identifiers can be used to label the issuance start time and the issuance end time, which is not limited.

[0053] S204: Sort the issuance start time and issuance end time in ascending order to obtain a time sequence.

[0054] Further, the embodiment of the present disclosure can unify the issuance start time and issuance end time as issuance start and end time, for example: the issuance start and end time of the embodiment includes 2021.1.1, 2021.1.15, 2021.1.16, 2021.1.31, 2021.1.20, and 2021.2.28. Further, the issuance start and end time is sorted in ascending order, that is, sorted in order from early to late, to obtain a time sequence. In actual application, the row_number analysis function can be used to construct a time sorting number (i.e., a time sequence), and a bond issuance time sorting table can be constructed according to the time sequence, the issuance start and end time, and the time identifier. The issuance time sorting table is shown in Table 3:

[0055] Table 3

[0056]

[0057] S205: Traverse the time sequence and take the traversed time as the issuance amount start time and issuance amount end time in turn.

[0058] That is, the issuance start and end time is traversed according to the time sorting number, and the traversed issuance start and end time is taken as the issuance amount start time and issuance amount end time in turn. It should be noted that the issuance start and end time with the time sorting number 1 is only taken as the issuance amount start time.

[0059] For example, when the issuance start and end time is 2021.1.1, 2021.1.1 can be taken as the issuance amount start time; when the issuance start and end time is 2021.1.15, 2021.1.15 can be taken as the issuance amount end time of the last issuance (2021.1.1 issuance amount start time) and the issuance amount start time of the next issuance in turn; similarly, the issuance start and end time of 2021.1.16, 2021.1.20, 2021.1.31, and 2021.2.28 can be taken as the issuance amount end time of the last issuance and the issuance amount start time of the next issuance in turn. Thus, the continuous issuance amount start time and issuance amount end time can be obtained.

[0060] In actual application, each data in the issuance time sorting table (Table 3) can be offset to make the adjacent two data spliced into a row of data to obtain Table 2, wherein each row of data can represent an issuance amount start time and a corresponding issuance amount end time.

[0061] Some embodiments, if the time identifier corresponding to the iteration of the issuance amount start time indicates the issuance end time, add one day to the issuance amount start time, and if the time identifier corresponding to the issuance amount start time indicates the issuance start time, directly take the issuance amount start time as the issuance amount start time.

[0062] For example, when 2021.1.16 is iterated as the issuance amount start time, the time identifier 1 indicates the issuance start time, and 2021.1.16 can be directly taken as an issuance amount start time; for example, when 2021.1.31 is iterated as the issuance amount start time, the time identifier 2 indicates the issuance end time, and in this case, 2021.1.31 as an issuance amount start time needs to be processed by adding one day, i.e., the issuance amount start time is 2021.2.1.

[0063] Some embodiments, if the time identifier corresponding to the iteration of the issuance amount end time indicates the issuance start time, subtract one day from the issuance amount end time, and if the time identifier corresponding to the issuance amount end time indicates the issuance end time, directly take the issuance amount end time as the issuance amount end time.

[0064] For example, when 2021.1.31 is iterated as the issuance amount end time, the time identifier 2 indicates the issuance start time, and 2021.1.31 can be directly taken as an issuance amount end time; for example, when 2021.1.20 is iterated as the issuance amount end time, the time identifier 1 indicates the issuance start time, and in this case, 2021.1.20 as an issuance amount end time needs to be processed by subtracting one day, i.e., the issuance amount start time is 2021.1.19.

[0065] S206: Determine the issuance amount time interval according to the issuance amount start time and the issuance amount end time.

[0066] After determining the continuous issuance amount start time and the issuance amount end time, further, the issuance amount time interval can be determined according to the issuance amount start time and the issuance amount end time, as shown in Table 2, the amount start time (issuance amount start time) to the amount end time (issuance amount end time) of each row corresponds to an issuance amount time interval.

[0067] Therefore, the embodiments of the disclosure can mark the issuance start time and the issuance end time, and according to the mark, the issuance start time and the issuance end time can be quickly determined, and according to the time identifier, the specific issuance amount start time and the issuance amount end time can be determined, so as to facilitate accurate determination of the issuance amount time interval and ensure that there is no overlapping time between the issuance amount time intervals.

[0068] S207: Determine the issuance quota occupied by the issuance amount time interval according to the first issuance amount.

[0069] The specific description of S207 can be referred to the above embodiments, which will not be repeated here.

[0070] In this embodiment, by responding to the data processing request, the registration information table and the issuance information table of the to-be-processed bond are associated to construct a basic information table, and based on the basic information table, the issuance start time, the issuance end time and the first issuance amount of each issuance of the to-be-processed bond are obtained, and according to the issuance start time and the issuance end time, the issuance amount time interval is determined, and according to the first issuance amount, the issuance quota occupied by the issuance amount time interval is determined. The data table related to the bond can be processed to construct the issuance amount time interval and determine the occupied issuance quota. Since there is no overlapping time between the issuance amount time intervals, the quota occupation of the bond in any time interval can be accurately calculated, which is beneficial for subsequent personnel to monitor the issuance risk. In addition, the embodiment can reduce the time and labor cost and improve the calculation accuracy, thereby avoiding compliance risks, customer bond issuance failures and other problems. In addition, the issuance start time and the issuance end time can be marked according to the embodiment of the disclosure. According to the mark, the issuance start and end time can be quickly determined, and according to the time mark, the specific issuance amount start time and the issuance amount end time can be determined, so as to accurately determine the issuance amount time interval and ensure that there is no overlapping time between the issuance amount time intervals.

[0071] Figure 3 is a flow diagram of a data processing method according to the third embodiment of the disclosure, as shown in Figure 3 , the method comprises:

[0072] S301: In response to a data processing request, the registration information table and the issuance information table of the to-be-processed bond are associated to construct a basic information table.

[0073] S302: Based on the basic information table, the issuance start time, the issuance end time and the first issuance amount of each issuance of the to-be-processed bond are obtained.

[0074] S303: Determine the time mark corresponding to the issuance start time and the issuance end time, respectively.

[0075] S304: Sort the issuance start time and the issuance end time in ascending order to obtain a time sequence.

[0076] S305: Traverse the time sequence, and take the traversed time as the issuance amount start time and the issuance amount end time in turn.

[0077] S306: Determine the issuance amount time interval according to the issuance amount start time and the issuance amount end time.

[0078] S307: Determine the issuance amount quota occupied by the issuance amount time interval according to the first issuance amount.

[0079] The specific description of S301-307 can be referred to the above embodiments, which will not be repeated here.

[0080] S308: Determine the remaining quota of the issuance amount time interval according to the issuance quota and the registration amount of the to-be-processed bond.

[0081] After determining the issuance amount quota occupied by the issuance amount time interval, the disclosure embodiments further determine the remaining quota of the issuance amount time interval.

[0082] The remaining quota is used to describe the maximum quota that can be continued to be issued in the issuance amount time interval, and the registration amount of the to-be-processed bond minus the issuance quota can obtain the remaining quota of the issuance amount time interval.

[0083] For example, the registration amount of the above bond is 10 million, and the remaining quota of each issuance amount time interval is shown in Table 4:

[0084] Table 4

[0085]

[0086] S309: Obtain the planned issuance start time and the planned issuance end time input by the user.

[0087] After determining the remaining quota of the to-be-processed bond in each issuance amount time interval, the disclosure embodiments can construct a bond issuance plan model, and the user can determine the maximum issuance amount or the issuance time interval by using the bond issuance plan model.

[0088] Specifically, the disclosure embodiments can obtain the planned issuance start time and the planned issuance end time input by the user.

[0089] The start time of the user's planned bond issuance can be referred to as the planned issuance start time, and the end time of the user's planned bond issuance can be referred to as the planned issuance end time. For example, the planned issuance start time and the planned issuance end time are 2021.1.25 and 2021.3.15, respectively. In actual application, the user can input the planned issuance start time and the planned issuance end time on the client of the bank system.

[0090] S310: Determine a first target interval from the issuance amount time intervals that satisfies the condition that the issuance amount end time is greater than or equal to the planned issuance start time and the issuance amount start time is less than or equal to the planned issuance end time.

[0091] Further, the bond issuance plan model can determine an issuance amount time interval that satisfies the requirement according to the planned issuance start time and the planned issuance end time input by the user, which can be referred to as a first target interval. The first target interval can be one or more, which can be determined according to actual data, and there is no limitation thereto.

[0092] Some embodiments can set a constraint condition when determining the target interval, for example, the condition that the issuance amount end time is greater than or equal to the planned issuance start time and the issuance amount start time is less than or equal to the planned issuance end time. In this case, the embodiment can compare the planned issuance start time and the planned issuance end time with the issuance amount end time and the issuance amount start time of the plurality of issuance amount time intervals described above to determine the first target interval that satisfies the condition.

[0093] For example, the planned issuance start time and the planned issuance end time of the embodiment of the present disclosure are 2021.1.25 and 2021.3.15, and the first target interval of the four issuance amount time intervals described above that satisfies the constraint condition is 2021.1.20-2021.1.31 and 2021.2.1-2021.2.28.

[0094] S311: Determine the maximum remaining quota in the first target interval as the planned issuance maximum quota.

[0095] That is, the maximum remaining quota (i.e., 5 million) is determined from the two intervals 2021.1.20-2021.1.31 and 2021.2.1-2021.2.28, and the maximum remaining quota is taken as the planned issuance maximum quota of the user's current planned issuance, that is, the user can issue a maximum of 5 million quota of bonds within the planned issuance start time and the planned issuance end time.

[0096] Some other embodiments, the user can also input the issuance amount of the planned issuance, i.e., a second issuance amount, on the client side. In this case, the embodiment can obtain the second issuance amount; further, the embodiment can calculate an issuance amount time interval that satisfies the second issuance amount using the bond issuance plan model, which can be referred to as a second target interval.

[0097] Specifically, in the calculation process of the bond issuance plan model, a time interval with a remaining quota greater than or equal to the second issuance amount can be queried as the second target interval. For example, if the second issuance amount input by the user is 5 million, an interval with a remaining quota greater than or equal to 5 million can be queried as the second target interval, that is, the second target interval of the embodiment can include three intervals: 2021.1.1-2021.1.15, 2021.1.16-2021.1.19, and 2021.2.1-2021.2.28, that is, the user's current plan issuance can be issued in any of the above three second target intervals.

[0098] Therefore, the embodiment of the present disclosure can accurately calculate the maximum issuance amount or the issuance time interval of the planned issuance according to the user's needs, support the user to flexibly configure the issuance time and issuance amount of the bond, help business development, and improve the user experience effect.

[0099] In the embodiment, by responding to the data processing request, the registration information table and the issuance information table of the to-be-processed bond are associated to construct a basic information table, and based on the basic information table, the issuance start time, the issuance end time, and the first issuance amount of each issuance of the to-be-processed bond are obtained, and according to the issuance start time and the issuance end time, the issuance amount time interval is determined, and according to the first issuance amount, the issuance amount time interval has occupied issuance quota is determined. The data table related to the bond can be processed to construct the issuance amount time interval and determine the occupied issuance quota. Since there is no overlapping time between the issuance amount time intervals, the quota occupation situation of the bond in any time interval can be accurately calculated, which is beneficial for subsequent personnel to monitor the issuance risk. In addition, the embodiment can reduce the time and labor costs and improve the accuracy of the calculation, thereby avoiding compliance risks, customer bond issuance failures, and the like. In addition, the embodiment of the present disclosure can accurately calculate the maximum issuance amount or the issuance time interval of the planned issuance according to the user's needs, thereby supporting the user to flexibly configure the issuance time and issuance amount of the bond, helping business development, and improving the user experience effect.

[0100] In one specific example, Figure 4 is a data processing process schematic diagram according to the embodiment of the present disclosure, as Figure 4 shown, in actual application, the data processing process includes the following steps:

[0101] (1) constructing bond registration and issuance basic information;

[0102] Specifically, the bond registration information table and the bond issuance information table are associated to construct the required bond basic data of the present disclosure, and the obtained bond basic information is shown in Table 1 above.

[0103] (2) The start and end time of each issuance of the bond is transposed, marked, de-duplicated, and sorted in ascending order;

[0104] Specifically, by the bond basic information table, the start time and the end time of each issuance of the bond are transposed, and it is marked whether the transposed time is the start time or the end time, while the repeated cases are removed. Among them, the transposition is realized by two queries, the start time is marked as '1', and the end time is marked as '2'. Then the de-duplication is realized by union: in the case of multiple issuances, if there are the same issuance start time or the same issuance end time, only one data is retained. Then the row_number analysis function is used to construct the "time sorting number", and the time points of each bond are sorted in order from early to late, and finally the bond issuance time sorting table is constructed, as shown in Table 3 above.

[0105] (3) Construct the issuance amount interval of the bond

[0106] Specifically, after the issuance time of each bond is sorted, the present application re-constructs the issuance amount interval of the bond according to the sorting result, and obtains the start and end time of each issuance amount. By the offset function, each data of the "bond issuance time sorting table" is offset, so that the two adjacent data are spliced into one row of data. Among them, the start and end time of the bond issuance can be the same time point, but for the issuance amount interval, the start and end time of each issuance amount is required to be different, so the start and end time of the bond issuance is converted to the start and end time of the issuance amount interval, and it is required to judge whether the time value needs to be added or subtracted one day according to the "time point identifier" and the "adjacent next time point identifier": if the start time of an issuance amount interval corresponds to the "time point identifier" of the issuance start and end time as '2' (issuance end time), then the start time of this issuance amount interval is "issuance start and end time" + 1 day, otherwise directly use "issuance start and end time"; if the end time of an issuance amount interval corresponds to the "adjacent next time point identifier" of the issuance start and end time as '1' (issuance start time), then the end time of this issuance amount interval is "adjacent next issuance start and end time" - 1 day, otherwise directly use "adjacent next issuance start and end time". At the same time, the records with "adjacent next issuance start and end time" as empty are filtered out, and then all the issuance amounts falling in the time interval are added up, so as to construct the issuance amount interval information table, which is shown in Table 2 above.

[0107] (4) The bond basic information table and the issuance amount interval information table are associated to obtain the maximum "issuance amount" in the bond issuance interval, that is, the maximum amount occupied by the bond during this issuance period. Then, the registered amount is reduced by the maximum amount occupied to obtain the remaining available amount of the bond. The details of the amount occupied and the remaining available amount of each bond in each issuance interval are obtained to assist the client manager and the management personnel to quickly obtain the amount occupied and the remaining available amount of each bond, thereby facilitating the related management work of the bond.

[0108] (5) Construction of a bond issuance plan model

[0109] Through the issuance amount interval information table, a bond issuance plan model is constructed: the customer inputs the planned issuance interval to obtain the maximum issuance amount, and inputs the planned issuance amount to obtain the issuance time interval. Whether the input planned issuance interval and issuance amount is out of limit can be detected, and an alarm is given once it is out of limit. Thus, the customer can flexibly configure the issuance time and issuance amount of the bond, which helps the business development and avoids compliance risks.

[0110] Figure 5 is a block diagram of a data processing apparatus according to the present disclosure, as shown in Figure 5 , the data processing apparatus 50 comprises:

[0111] The construction module 501 is configured to, in response to a data processing request, associate the registration information table and the issuance information table of the bond to be processed to construct a basic information table.

[0112] The first acquisition module 502 is configured to acquire, based on the basic information table, the issuance start time, the issuance end time and the first issuance amount of each issuance of the bond to be processed.

[0113] The first determination module 503 is configured to determine the issuance amount time interval according to the issuance start time and the issuance end time, wherein there is no overlapping time between the issuance amount time intervals; and

[0114] The second determination module 504 is configured to determine the issuance amount occupied by the issuance amount time interval according to the first issuance amount.

[0115] In some embodiments, the first determination module 503 comprises:

[0116] The sorting submodule is configured to sort the issuance start time and the issuance end time in ascending order to obtain a time sequence.

[0117] The traversal submodule is configured to traverse the time sequence and sequentially take the traversed time as the issuance amount start time and the issuance amount end time; and

[0118] The determining sub-module is configured to determine the issuance amount time interval according to the issuance amount start time and the issuance amount end time.

[0119] In some embodiments, the apparatus 50 further comprises:

[0120] The marking module is configured to determine the time identifiers corresponding to the issuance start time and the issuance end time, respectively.

[0121] In some embodiments, the traversing sub-module is specifically configured to:

[0122] If the time identifier corresponding to the traversed issuance amount start time indicates the issuance end time, the issuance amount start time is incremented by one day;

[0123] and / or

[0124] If the time identifier corresponding to the traversed issuance amount end time indicates the issuance start time, the issuance amount end time is decremented by one day.

[0125] In some embodiments, the second determining module 504 is specifically configured to:

[0126] If the issuance amount time interval is located between the issuance start time and the issuance end time of one issuance, the first issuance amount from the issuance start time to the issuance end time is taken as the issuance quota of the issuance amount time interval;

[0127] If the issuance amount time interval is located between the issuance start time and the issuance end time of at least two issuances, the first issuance amounts of the at least two issuances are accumulated as the issuance quota occupied by the issuance amount time interval.

[0128] In some embodiments, the apparatus 50 further comprises a third determining module configured to determine a remaining quota of the issuance amount time interval according to the issuance quota and the registration amount of the to-be-processed bond.

[0129] In some embodiments, the apparatus 50 further comprises a second obtaining module configured to obtain a planned issuance start time and a planned issuance end time input by a user;

[0130] A fourth determining module is configured to determine a first target interval in the issuance amount time interval that satisfies the issuance amount end time being greater than or equal to the planned issuance start time and the issuance amount start time being less than or equal to the planned issuance end time; and

[0131] A fifth determining module is configured to determine the maximum remaining quota in the first target interval as a planned issuance maximum quota.

[0132] In some embodiments, the apparatus 50 further comprises:

[0133] The third obtaining module is configured to obtain a second issuance amount of the planned issuance input by the user; and

[0134] The sixth determining module is configured to determine a second target interval in which the remaining quota in the issuance amount time interval is greater than or equal to the second issuance amount.

[0135] In the embodiment, the registration information table and the issuance information table of the to-be-processed bond are associated to construct the basic information table in response to the data processing request, and based on the basic information table, the issuance start time, the issuance end time and the first issuance amount of each issuance of the to-be-processed bond are obtained, and according to the issuance start time and the issuance end time, the issuance amount time interval is determined, and according to the first issuance amount, the issuance quota occupied by the issuance amount time interval is determined. The data table related to the bond can be processed to construct the issuance amount time interval and determine the occupied issuance quota. Since there is no overlapping time between the issuance amount time intervals, the quota occupation of the bond in any time interval can be accurately calculated, which is beneficial for subsequent personnel to monitor the issuance risk. In addition, the embodiment can reduce the time and labor cost and improve the calculation accuracy, thereby avoiding compliance risks, customer bond issuance failures and the like.

[0136] According to embodiments of the present disclosure, the present disclosure further provides an electronic device, a readable storage medium and a computer program product.

[0137] Figure 6 is a block diagram of an electronic device according to the present disclosure. For example, the electronic device 600 can be a mobile phone, a computer, a digital broadcast terminal, a messaging device, a game console, a tablet device, a medical device, a fitness device, a personal digital assistant, etc.

[0138] Referring to Figure 6 , the electronic device 600 can include one or more of the following components: a processing component 602, a memory 604, a power supply component 606, a multimedia component 608, an audio component 610, an input / output (I / O) interface 612, a sensor component 614, and a communication component 616.

[0139] The processing component 602 usually controls the overall operation of the electronic device 600, such as operations associated with displaying, making phone calls, data communications, camera operations and recording operations. The processing component 602 can include one or more processors 620 to execute instructions to complete all or part of the steps of the methods described above. In addition, the processing component 602 can include one or more modules to facilitate interaction between the processing component 602 and other components. For example, the processing component 602 can include a multimedia module to facilitate interaction between the multimedia component 608 and the processing component 602.

[0140] The memory 604 is configured to store various types of data to support operations of the electronic device 600. Examples of such data include instructions for any application or method operating on the electronic device 600, contact data, phonebook data, messages, pictures, videos, and the like. The memory 604 can be implemented by any type of volatile or nonvolatile memory, or a combination thereof such as static random access memory (SRAM), electrically erasable programmable read only memory (EEPROM), erasable programmable read only memory (EPROM), programmable read only memory (PROM), read only memory (ROM), magnetic memory, flash memory, magnetic disc or optical disc.

[0141] The power supply component 606 supplies power to various components of the electronic device 600. The power supply component 606 can include a power management system, one or more power supplies, and other components associated with generating, managing, and distributing power for the electronic device 600.

[0142] The multimedia component 608 includes a touch display screen providing an output interface between the electronic device 600 and a user. In some embodiments, the touch display screen can include a liquid crystal display (LCD) and a touch panel (TP). The touch panel includes one or more touch sensors to sense a touch, a slide, and a gesture on the touch panel. The touch sensor can not only sense a boundary of a touch or a slide action, but also detect duration and pressure related to the touch or slide operation. In some embodiments, the multimedia component 608 includes a front-facing camera and / or a rear-facing camera. The front-facing camera and / or the rear-facing camera can receive external multimedia data when the electronic device 600 is in an operation mode such as a photographing mode or a video mode. Each of the front-facing camera and the rear-facing camera can be a fixed optical lens system or have a focal length and optical zoom capability.

[0143] The audio component 610 is configured to output and / or input an audio signal. For example, the audio component 610 includes a microphone (MIC) configured to receive an external audio signal when the electronic device 600 is in an operation mode such as a call mode, a recording mode, and a voice recognition mode. The received audio signal can be further stored in the memory 604 or transmitted via the communication component 616.

[0144] In some embodiments, the audio component 610 also includes a speaker for outputting an audio signal.

[0145] The I / O interface 612 provides an interface between the processing component 602 and peripheral interface modules, which can be a keyboard, a click wheel, a button, and the like. The buttons can include, but are not limited to, a home button, a volume button, a start button, and a lock button.

[0146] The sensor component 614 includes one or more sensors for providing status assessments for various aspects of the electronic device 600. For example, the sensor component 614 can detect an open / closed position of the electronic device 600, relative positioning of components, such as a display and keypad of the electronic device 600, a change in position of the electronic device 600 or a component of the electronic device 600, presence or absence of user contact with the electronic device 600, orientation or acceleration / deceleration of the electronic device 600, and temperature changes of the electronic device 600. The sensor component 614 can include an optical sensor for detecting ambient light, a proximity sensor configured to detect proximity of an object, a motion sensor configured to detect motion of the electronic device 600, a temperature sensor configured to detect temperature changes of the electronic device 600, a humidity sensor configured to detect humidity changes of the electronic device 600, an acceleration sensor configured to detect an acceleration of the electronic device 600, a gyroscope sensor configured to detect a rotation of the electronic device 600, a magnetic sensor configured to detect a magnetic field of the electronic device 600, a pressure sensor configured to detect a pressure of the electronic device 600, or a chemical sensor configured to detect a chemical of the electronic device 600.

[0147] The communication component 616 is configured to facilitate wired or wireless communication between the electronic device 600 and other devices. The electronic device 600 can access a wireless network based on a communication standard, such as WiFi, 2G, or 3G, or a combination thereof. In an exemplary embodiment, the communication component 616 receives a broadcast signal or broadcast-related information from an external broadcast management system via a broadcast channel. In an exemplary embodiment, the communication component 616 further includes a Near Field Communication (NFC) module to facilitate short-range communication. For example, the NFC module can be implemented based on Radio Frequency Identification (RFID) technology, infrared data association (IrDA) technology, ultra-wideband (UWB) technology, Bluetooth (BT) technology, and other technology.

[0148] In an exemplary embodiment, the electronic device 600 can be implemented using one or more application-specific integrated circuits (ASICs), digital signal processors (DSPs), digital signal processing devices (DSPDs), programmable logic devices (PLDs), field programmable gate arrays (FPGAs), controllers, micro-controllers, microprocessors, or other electronic elements for performing the above-described data processing methods.

[0149] In an exemplary embodiment, a computer-readable storage medium including instructions, such as the memory 604 including instructions, is also provided, which can be executed by the processor 620 of the electronic device 600 to implement the above-described methods. Alternatively, the computer-readable storage medium can be a ROM, a random access memory (RAM), a CD-ROM, a magnetic tape, a floppy disc, and an optical data storage device, etc.

[0150] Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the features disclosed herein. It is intended that the disclosure be construed as including any paterns of this disclosure that can be derived from the description and illustrations presented herein without departing from the scope and spirit of the disclosure. The specification and examples are exemplary only, with the true scope and spirit of the disclosure being indicated by the following claims.

[0151] It is to be understood that the disclosure is not limited to the precise construction here described and illustrated and that various modifications and changes can be made without departing from the scope thereof. The only scope of the disclosure is to be determined by the appended claims.

Claims

1. A data processing method, characterized by, The method comprises: in response to a data processing request, associating a registration information table and an issuance information table of a to-be-processed bond to construct a basic information table; based on the basic information table, obtaining issuance start time, issuance end time and a first issuance amount of each issuance of the to-be-processed bond; sorting the issuance start time and the issuance end time in ascending order to obtain a time sequence; traversing the time sequence and taking the traversed time as issuance amount start time and issuance amount end time in turn; and determining issuance amount time intervals according to the issuance amount start time and the issuance amount end time, wherein there is no overlapping time between the issuance amount time intervals; and determining an issuance quota occupied by the issuance amount time intervals according to the first issuance amount, comprising: if the issuance amount time interval is located between the issuance start time and the issuance end time of an issuance, taking the first issuance amount of the issuance start time to the issuance end time as the issuance quota of the issuance amount time interval.

2. The method of claim 1, wherein, Before the sorting the issuance start time and the issuance end time in ascending order to obtain a time sequence, the method further comprises: determining time identifiers corresponding to the issuance start time and the issuance end time respectively.

3. The method of claim 2, wherein, The taking the traversed time as issuance amount start time and issuance amount end time in turn comprises: if the time identifier corresponding to the traversed issuance amount start time indicates the issuance end time, adding one day to the issuance amount start time; and / or if the time identifier corresponding to the traversed issuance amount end time indicates the issuance start time, subtracting one day from the issuance amount end time. The determining an issuance quota occupied by the issuance amount time intervals according to the first issuance amount further comprises:

4. The method of claim 1, wherein, if the issuance amount time interval is located between the issuance start time and the issuance end time of at least two issuances, accumulating the first issuance amounts of the at least two issuances as the issuance quota occupied by the issuance amount time interval. After the determining an issuance quota occupied by the issuance amount time intervals according to the first issuance amount, the method further comprises:

5. The method of claim 1, wherein, determining a remaining quota of the issuance amount time interval according to the issuance quota and a registration amount of the to-be-processed bond. After the determining a remaining quota of the issuance amount time interval, the method further comprises:

6. The method of claim 5, wherein, obtaining a planned issuance start time and a planned issuance end time input by a user; determining a first target interval in the issuance amount time interval that satisfies issuance amount end time greater than or equal to the planned issuance start time and issuance amount start time less than or equal to the planned issuance end time; and determining a maximum remaining quota in the first target interval as a planned issuance maximum quota. After the determining a remaining quota of the issuance amount time interval, the method further comprises:

7. The method of claim 5, wherein, obtaining a second issuance amount of a planned issuance input by a user; and determining a second target interval in the issuance amount time interval that has a remaining quota greater than or equal to the second issuance amount. The method comprises:

8. A data processing apparatus, characterized by, ​ The construction module is configured to associate a registration information table and an issuance information table of a bond to be processed to construct a basic information table in response to a data processing request; The first acquisition module is configured to acquire an issuance start time, an issuance end time and a first issuance amount of each issuance of the bond to be processed based on the basic information table; The first determination module is configured to determine issuance amount time intervals according to the issuance start time and the issuance end time, wherein there is no overlapping time between the issuance amount time intervals; and The second determination module is configured to determine an issuance quota occupied by the issuance amount time intervals according to the first issuance amount. The first determination module comprises: The sorting submodule is configured to sort the issuance start time and the issuance end time in ascending order to obtain a time sequence; The traversal submodule is configured to traverse the time sequence and sequentially take the traversed time as an issuance amount start time and an issuance amount end time; and The determination submodule is configured to determine the issuance amount time intervals according to the issuance amount start time and the issuance amount end time. The second determination module is specifically configured to: If the issuance amount time interval is located between the issuance start time and the issuance end time of one issuance, take the first issuance amount of the issuance start time to the issuance end time as the issuance quota of the issuance amount time interval.

9. The apparatus of claim 8, wherein, The device further comprises: The marking module is configured to determine time identifiers corresponding to the issuance start time and the issuance end time, respectively.

10. The apparatus of claim 9, wherein, The traversal submodule is specifically configured to: If the issuance amount start time corresponding to the traversed time identifier indicates the issuance end time, add one day to the issuance amount start time; And / or If the issuance amount end time corresponding to the traversed time identifier indicates the issuance start time, subtract one day from the issuance amount end time.

11. The apparatus of claim 8, wherein, The second determination module is further configured to: If the issuance amount time interval is located between the issuance start time and the issuance end time of at least two issuances, accumulate the first issuance amounts of the at least two issuances as the issuance quota occupied by the issuance amount time interval.

12. The apparatus of claim 8, wherein, The device further comprises: The third determination module is configured to determine a remaining quota of the issuance amount time interval according to the issuance quota and a registration amount of the bond to be processed.

13. The apparatus of claim 12, wherein, The device further comprises: The second acquisition module is configured to acquire a planned issuance start time and a planned issuance end time input by a user; The fourth determination module is configured to determine a first target interval in the issuance amount time interval that satisfies an issuance amount end time greater than or equal to the planned issuance start time and an issuance amount start time less than or equal to the planned issuance end time; and The fifth determination module is configured to determine a maximum remaining quota in the first target interval as a planned issuance maximum quota.

14. The apparatus of claim 12, wherein, The device further comprises: The third acquisition module is configured to acquire a second issuance amount of a planned issuance input by a user; and The sixth determination module is configured to determine a second target interval in the issuance amount time interval that has a remaining quota greater than or equal to the second issuance amount.

15. An electronic device, comprising: Comprises: a processor; a memory for storing instructions executable by the processor; wherein the processor is configured to execute the instructions to implement the method of any one of claims 1-7.

16. A computer-readable storage medium storing instructions that, when executed by a processor of an electronic device, enable the electronic device to perform the method of any one of claims 1-7.

17. A computer program product comprising a computer program, characterized in that, The computer program, which when executed by a processor implements the method of any one of claims 1-7.

Images