CN111666291A

CN111666291A - Financial tool accounting processing method and device, electronic equipment and medium

Info

Publication number: CN111666291A
Application number: CN202010528783.6A
Authority: CN
Inventors: 迟立辉; 刘智; 黄杰
Original assignee: Beijing Kaike Weizhi Technology Co ltd
Current assignee: Beijing Kaike Weizhi Technology Co ltd
Priority date: 2020-06-11
Filing date: 2020-06-11
Publication date: 2020-09-15

Abstract

The application provides a financial tool accounting processing method, a financial tool accounting processing device, an electronic device and a medium, wherein the method comprises the following steps: acquiring transaction data of different financial instruments; distributing the transaction data to independent accounting service modules of different financial instruments according to the categories of the financial instruments; all services related to the accounting business of the financial tool are integrated in the independent accounting service module of the financial tool; and carrying out accounting processing on the transaction data of each financial tool by utilizing the independent accounting service module of the financial tool. The embodiment of the application can reduce the accounting coupling degree of the financial tool and reduce the dependence on physical environment performance.

Description

Financial tool accounting processing method and device, electronic equipment and medium

Technical Field

The present application relates to the field of financial instrument accounting technologies, and in particular, to a financial instrument accounting processing method and apparatus, an electronic device, and a medium.

Background

The financial instrument accounting scheme of the existing investment transaction system mainly adopts the following modes: the accounting of the financial tool is realized by a hard coding method, all financial accounting work is integrated in one accounting service for processing, and meanwhile, the performance is improved by a load balancing mode.

The applicant finds in research that the following disadvantages exist in the prior art: the performance which is too dependent on the physical environment and the accounting coupling degree of the financial tool are high.

Disclosure of Invention

In view of the above, an object of the present application is to provide a financial instrument accounting processing method, apparatus, electronic device and medium, so as to reduce the accounting coupling degree of the financial instrument and reduce the dependence on the physical environment performance.

In a first aspect, an embodiment of the present application provides a financial instrument accounting processing method, which may include:

acquiring transaction data of different financial instruments;

distributing the transaction data to independent accounting service modules of different financial instruments according to the categories of the financial instruments; all services related to the accounting business of the financial tool are integrated in the independent accounting service module of the financial tool;

and carrying out accounting processing on the transaction data of each financial tool by utilizing the independent accounting service module of the financial tool.

With reference to the first aspect, the present application provides a first possible implementation manner of the first aspect, where, with an independent accounting service module of each financial instrument, the following accounting processes may be performed on the asset data of the financial instrument:

grouping the transaction data of each financial tool according to the service type of the financial tool to obtain a plurality of groups of transaction data;

and carrying out multi-thread batch running processing on each group of transaction data to obtain batch running result data.

With reference to the first possible implementation manner of the first aspect, an embodiment of the present application provides a second possible implementation manner of the first aspect, where performing multi-thread batch processing on each set of transaction data to obtain batch result data may include:

carrying out multi-thread batch processing on each group of transaction data;

setting a redis distributed lock for transaction data in each thread;

and when the transaction data in the thread is batched and finished or the batch is wrong, releasing the set redis distributed lock and outputting batch result data.

With reference to the second possible implementation manner of the first aspect, an embodiment of the present application provides a third possible implementation manner of the first aspect, where the method may further include:

and when the transaction data in the thread is finished or the running batch is wrong, the information of the transaction data in the thread that the running batch is finished or the running batch is wrong is issued to a specified channel by using an independent accounting service module of a corresponding financial tool, and the information on the specified channel is read by using a transfer station and fed back to a display interface.

With reference to the first aspect, an embodiment of the present application provides a fourth possible implementation manner of the first aspect, where the method may further include:

reading out the transaction data of different financial instruments from the database and storing the transaction data into a redis cache;

the acquiring transaction data of different financial instruments may include:

and acquiring transaction data of different financial instruments from the redis cache.

With reference to the fourth possible implementation manner of the first aspect, an embodiment of the present application provides a fifth possible implementation manner of the first aspect, where the method may further include:

setting at least two databases as a master database and a slave database; the master database is used for writing data, and the slave database is used for reading data;

periodically synchronizing data from the master database to the slave database;

when the master database has a problem, one slave database of at least two slave databases is set as the master database.

With reference to the first aspect, an embodiment of the present application provides a sixth possible implementation manner of the first aspect, where the method may further include:

and after receiving the adjusting instruction, adjusting all financial attribute parameters and accounting service rules in the independent accounting service module of the financial tool in any one mode of importing an excel configuration table, an execution script table and interface entry.

In a second aspect, an embodiment of the present application provides a financial instrument accounting processing apparatus, which may include:

the acquisition module is used for acquiring transaction data of different financial instruments;

the transfer module is used for distributing the transaction data to independent accounting service modules of different financial instruments according to the types of the financial instruments; all services related to the accounting business of the financial tool are integrated in the independent accounting service module of the financial tool;

and the accounting module is used for carrying out accounting processing on the transaction data of each financial tool by utilizing the independent accounting service module of each financial tool.

In a third aspect, an embodiment of the present application further provides an electronic device, including: a processor, a memory and a bus, the memory storing machine-readable instructions executable by the processor, the processor and the memory communicating via the bus when the electronic device is running, the machine-readable instructions when executed by the processor performing the steps of the first aspect described above, or any possible implementation of the first aspect.

In a fourth aspect, this application further provides a computer-readable storage medium, on which a computer program is stored, where the computer program is executed by a processor to perform the steps in the first aspect or any one of the possible implementation manners of the first aspect.

According to the financial tool accounting processing method provided by the embodiment of the application, all services related to the accounting business of each financial tool are integrated in the independent accounting service module of each financial tool, and the acquired transaction data of different financial tools are delivered to the independent accounting service modules of different financial tools for accounting processing according to the types of the financial tools, so that the accounting coupling degree of the financial tools can be reduced, and the dependence on physical environment performance is reduced.

Further, according to the financial tool accounting processing method provided by the embodiment of the application, when the attribute parameters and the accounting service rules of the financial tool change and develop along with financial research and supervision requirements, all the financial attribute parameters and the accounting service rules in the independent accounting service module of the financial tool are adjusted only by any one of importing an excel configuration entry table, executing a script entry table and interface entry, so that the optimization and upgrade of the financial tool are completed quickly, and the imperceptible upgrade of a user is realized in the optimization and upgrade process.

In order to make the aforementioned objects, features and advantages of the present application more comprehensible, preferred embodiments accompanied with figures are described in detail below.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are required to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained from the drawings without inventive effort.

FIG. 1 is a flow chart illustrating a method of financial instrument accounting processing provided by an embodiment of the present application;

FIG. 2 illustrates a batch flow diagram provided by an embodiment of the present application;

FIG. 3 is a schematic diagram illustrating an exemplary financial instrument accounting processing apparatus according to an embodiment of the present disclosure;

fig. 4 shows a schematic structural diagram of an electronic device provided in an embodiment of the present application.

Detailed Description

In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all the embodiments. The components of the embodiments of the present application, generally described and illustrated in the figures herein, can be arranged and designed in a wide variety of different configurations. Thus, the following detailed description of the embodiments of the present application, presented in the accompanying drawings, is not intended to limit the scope of the claimed application, but is merely representative of selected embodiments of the application. All other embodiments, which can be derived by a person skilled in the art from the embodiments of the present application without making any creative effort, shall fall within the protection scope of the present application.

In consideration of the fact that the financial tool accounting scheme of the existing investment transaction system realizes accounting of financial tools through a hard coding method, all financial accounting work is integrated in one accounting service to be processed, and meanwhile performance is improved through a load balancing mode, so that the performance which is too dependent on a physical environment and the accounting coupling degree of the financial tools are high. Based on this, embodiments of the present application provide a financial instrument accounting processing method, apparatus, electronic device, and medium, which are described below by way of embodiments.

To facilitate understanding of the present embodiment, a detailed description will be given of a financial instrument accounting processing method disclosed in the embodiments of the present application.

Referring to fig. 1, fig. 1 is a flowchart illustrating a financial instrument accounting processing method according to an embodiment of the present disclosure. As shown in fig. 1, the method mainly comprises the following steps:

s101, acquiring transaction data of different financial instruments;

step S102, distributing the transaction data to independent accounting service modules of different financial instruments according to the types of the financial instruments; all services related to the accounting business of the financial tool are integrated in the independent accounting service module of the financial tool;

and step S103, utilizing the independent accounting service module of each financial tool to perform accounting processing on the transaction data of the financial tool.

In step S101, financial instruments such as fund, bond, stock, futures, gold, foreign exchange, policy, and so on are also called financial products, financial assets, securities. Specifically, the transaction data of different financial instruments are read out from the database and stored in a redis cache, and the transaction data of different financial instruments such as fund, bond, stock, futures, gold, foreign exchange, insurance policy and the like are obtained from the redis cache.

In step S102, each financial instrument corresponds to an independent accounting service module, and all services related to the accounting service of the financial instrument are integrated in the independent accounting service module of each financial instrument, so as to achieve high cohesion of the independent accounting service module. The independent accounting service module of each financial instrument only needs to be responsible for the related business of the financial instrument, for example, the independent accounting service module corresponding to the fund only needs to be responsible for the related business of the fund, the independent accounting service module corresponding to the bond only needs to be responsible for the related business of the bond, the independent accounting service module corresponding to the stock only needs to be responsible for the related business of the stock, and the like, thereby realizing the single duty of the independent accounting service module.

And distributing the transaction data to independent accounting service modules of different financial instruments according to the categories of the financial instruments. For example, the bond transaction data, the stock transaction data, and the fund transaction data are distributed to the independent accounting service module corresponding to the bond, the independent accounting service module corresponding to the stock, and the independent accounting service module corresponding to the fund according to the category of the financial instrument.

In step S103, with the independent accounting service module of each financial instrument, the following accounting processing is performed on the asset data of the financial instrument: firstly, according to the service type of each financial tool, grouping the transaction data of the financial tool to obtain a plurality of groups of transaction data; and secondly, carrying out multi-thread batch running processing on each group of transaction data to obtain batch running result data.

In the second step, each group of transaction data is processed in a multithread batch running mode, and a redis distributed lock is set for the transaction data in each thread. Resource sharing is realized by using the redis as a distributed lock, so that the problem that transaction data in threads cannot run repeatedly can be solved. redis supports five data types: string, hash, list, set, and zset. In this embodiment, the String type is used to indicate that the transaction data is running by storing the object to be run into a serialized object as a key value and setting a lock (which can prevent other threads from using the key). And when the transaction data in the thread is batched and finished or the batched data is wrong, releasing the set redis distributed lock and outputting the batched result data so as to ensure that no deadlock phenomenon occurs.

And, the information transmission between the processes is realized by using the 'publish/subscribe' mode of the redis (the mode is actually a set of redis operation instructions). The "publish/subscribe" schema of redis contains two roles: a publisher and a subscriber. Subscribers may subscribe to multiple channels, while publishers send information to channels. Each individual financial accounting service is counted as a publisher and the subscribers are the integrated services (transit stations for distributing services). And when the transaction data in the thread is finished in batch or has errors, the independent accounting service module of the corresponding financial tool is used for issuing the information of the transaction data in the thread that the batch is finished or the batch is wrong to a specified channel. And the subscriber can receive the information, read the information on the appointed channel and feed back the information to the display interface, so that the user can more directly find the problem.

In the second step, the transaction data is used in the redis cache, and the main function is that when the user finds that the result data after batch running is wrong, the transaction data needs to be rerun, at this time, the transaction data is directly taken from the redis cache instead of directly rechecking the database from the database, so that the access amount of the database is reduced. Data caching, such as asset and transaction caching, is achieved by utilizing redis efficiency, and interaction with a database is reduced. In order to prevent the avalanche effect, a fixed value + random number rule is adopted when the time effect is set for the redis cache. Furthermore, the problem of data bulkiness and accuracy can be handled by using redis as a message queue.

With respect to the databases, at least two databases are set as a master database for writing data and a slave database for reading data. Periodically synchronizing data from the master database to the slave database, thereby ensuring data consistency. When the master database has problems, one slave database of at least two slave databases is set as the master database, the contention of a shared lock and an exclusive lock is greatly relieved, and the slave database can be configured with a myisam engine, so that the query performance is improved and the system overhead is saved. In this embodiment, a read-write separation mode is adopted for the database, so that the throughput of the database can be improved, and the data consistency is ensured by adopting a final consistency (based on the last piece of data). A plurality of slave databases (backup database files) are provided to ensure the integrity of data.

The batch process of the transaction data will be described in detail below.

Referring to fig. 2, fig. 2 is a schematic view of a batch process according to an embodiment of the present disclosure. The batch process, as shown in FIG. 2, may include the following steps:

step S201, starting batch running;

step S202, judging whether the transaction data is occupied, if not, turning to step S203; if yes, go to step S222;

step S203, verifying whether the storage data table is filled, and if so, turning to step S204; if not, go to step S223;

step S204, setting a custom factory function;

step S205, initializing a profit-and-loss table field;

step S206, judging whether the field of the loss and benefit table is initialized successfully, if so, turning to step S207; if not, go to step S224;

step S207, acquiring an initial object;

step S208, loading evaluation value parameters;

step S209, judging whether the loading of the evaluation value parameters is successful, if so, turning to step S210; if not, go to step S225;

step S210, establishing asset change data;

step S211, judging whether the asset change data is successfully established, if so, turning to step S212; if not, go to step S226;

step S212, calculating profit and loss data;

step S213, judging whether the calculation of the profit-and-loss data is successful, if so, turning to step S214; if not, go to step S227;

step S214, generating entry data;

step S215, judging whether the generation of the entry data is successful, if so, turning to step S216; if not, go to step S228;

step S216, storing core data and a calculation log;

step S217, judging whether the core data and the calculation log are successfully stored, if so, turning to step S218; if not, go to step S229;

step S218, updating the batch running log;

step S219, setting a return information set;

step S220, clearing cache data;

step S221, finishing batch running;

step S222, popping up a notice of 'in the course of collection, please try again later', and turning to step S218;

step S223, popping up a notification that 'the necessary table parameters do not exist and the check is performed again', and turning to step S218;

step S224, popping up a notification of 'abnormal database and failed initialization', and switching to step S218;

step S225, popping up a notification that the loading fails and the account number is not detected, and turning to step S218;

step S226, popping up a notification of 'failure of establishment and error of system', and switching to step S218;

step S227, pop up the "calculation failed, system error" notification, go to step S218;

step S228, popping up a notification of 'failure to generate entry data', and switching to step S218;

step S229, pop up "save failed, system error", and proceed to step S218.

In the above step S202, the running batch data refers to transaction data to be subjected to accounting, such as a bond transaction, which is the running batch data.

In step S203, storing the data table means: and (4) specifying the position of the data storage table, and storing the batched result data into the specified table.

In step S204, the custom factory function refers to: the auxiliary classes defined by developers mainly comprise complex algorithms and can play a role in auxiliary trial calculation.

In step S205, the profit-and-loss table refers to a table that can reflect the profit situation of the asset.

In step S207, the initial object refers to: the object contains profit-and-loss data associated with the lot data.

In step S208, the estimation parameter refers to: the method is suitable for parameters required by different scenes, and different expected effects can be achieved according to the selected parameter types.

In step S210, the asset transition data: refers to a data set containing asset change events over a period of time, such as events like point-to-point, interest-receiving, and cost-returning.

In step S212, the profit-and-loss data includes: result data calculated by the system from the asset transition data.

In step S214, the entry data includes: data for billing subjects.

In the above step S216, the core data: the loss and benefit data and the entry data. The calculation log refers to a log file for recording a calculation process and can reflect the calculation process.

In step S218, the run batch log refers to: and recording the result of the whole batch running process, and accurately searching the log file of the problem.

In step S219, the set of returned information is data returned to the front end, which reflects the execution result of the whole batch process, and includes other prompt information such as the number of pieces of batch data, the success amount, and the failure data.

Through the above steps S201 to S229, the batching process of the transaction data is completed.

Further, the embodiment of the application further comprises the step of adjusting all financial attribute parameters and accounting service rules in the independent accounting service module of the financial tool only by any one of importing an excel configuration table, executing a script table and interface entry when the attribute parameters and the accounting service rules of the financial tool change and develop along with financial research and supervision requirements (namely after receiving an adjustment instruction), so that the optimization and upgrade of the financial tool are completed quickly, and the user-friendly upgrade is realized in the optimization and upgrade process.

By importing the excel configuration table, POI is mainly used for analyzing and supporting the formats of xls and xlsx, data is input into the table, and then the JDK1.8 characteristic Stream is used for swiping the data. Interface entry refers to operation on configuration by using an interface function, interface entry is realized by reading data by a background, and the pressure of a database is reduced by using a database index.

It should be noted that, the accounting processing process of the financial tool is recorded in the form of log files, and the accounting result in the accounting process is recorded and displayed through batch running logs, so that the accounting process is simple and transparent, and is convenient to track. And, optionally, the accounting results are both in chinese.

In summary, according to the financial instrument accounting processing method provided by the embodiment of the present application, all services related to the accounting business of the financial instrument are integrated in the independent accounting service module of each financial instrument, and according to the type of the financial instrument, the acquired transaction data of different financial instruments are delivered to the independent accounting service modules of different financial instruments for accounting processing, so that the accounting coupling degree of the financial instrument can be reduced, and the dependence on the physical environment performance is reduced.

Based on the same technical concept, embodiments of the present application further provide a financial instrument accounting processing apparatus, an electronic device, a computer storage medium, and the like, which can be seen in the following embodiments.

Referring to fig. 3, fig. 3 is a schematic structural diagram of a financial instrument accounting processing device according to an embodiment of the present disclosure. As shown in fig. 3, the apparatus may include:

an obtaining module 301, configured to obtain transaction data of different financial instruments;

the transfer module 302 is used for distributing the transaction data to independent accounting service modules of different financial instruments according to the types of the financial instruments; all services related to the accounting business of the financial tool are integrated in the independent accounting service module of the financial tool;

and the accounting module 303 is used for performing accounting processing on the transaction data of each financial instrument by using the independent accounting service module of the financial instrument.

In one possible implementation, the accounting module 303 may utilize an independent accounting service module of each financial instrument to perform the following accounting process on the asset data of the financial instrument:

In one possible implementation, the accounting module 303 may perform multi-threaded batching on each set of transaction data using an independent accounting service module of each financial instrument; setting a redis distributed lock for transaction data in each thread; and when the transaction data in the thread is batched and finished or the batch is wrong, releasing the set redis distributed lock and outputting batch result data.

In one possible implementation, the accounting module 303 may issue information of the transaction data batch ending or batch running error in the thread to a specified channel by using an independent accounting service module of a corresponding financial tool when the transaction data batch ending or batch running error in the thread occurs, and read the information on the specified channel by using a transfer station and feed the information back to the display interface.

In one possible implementation, the obtaining module 301 may include:

the storage unit is used for reading out the transaction data of different financial instruments from the database and storing the transaction data into the redis cache;

and the acquisition unit is used for acquiring the transaction data of different financial instruments from the redis cache.

In a possible implementation, the obtaining module 301 further includes:

a first setting unit for setting at least two of the databases as a master database and a slave database; the master database is used for writing data, and the slave database is used for reading data;

a synchronization unit for periodically synchronizing data from the master database to the slave database;

and the second setting unit is used for setting one slave database of the at least two slave databases as the master database when the master database has problems.

In a possible implementation, the apparatus may further include a configuration module 304, where the configuration module 304 is configured to: and after receiving the adjusting instruction, adjusting all financial attribute parameters and accounting service rules in the independent accounting service module of the financial tool in any one mode of importing an excel configuration table, an execution script table and interface entry.

An embodiment of the present application discloses an electronic device, as shown in fig. 4, including: a processor 401, a memory 402, and a bus 403, the memory 402 storing machine-readable instructions executable by the processor 401, the processor 401 and the memory 402 communicating via the bus 403 when the electronic device is operating. The machine readable instructions, when executed by the processor 401, perform the method described in the foregoing method embodiment, and specific implementation may refer to the method embodiment, which is not described herein again.

The computer program product for performing financial instrument accounting processing provided in the embodiment of the present application includes a computer-readable storage medium storing non-volatile program code executable by a processor, where instructions included in the program code may be used to execute the method described in the foregoing method embodiment, and specific implementation may refer to the method embodiment, and is not described herein again.

It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.

In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one logical division, and there may be other divisions when actually implemented, and for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection of devices or units through some communication interfaces, and may be in an electrical, mechanical or other form.

The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.

In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.

The functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a non-volatile computer-readable storage medium executable by a processor. Based on such understanding, the technical solution of the present application or portions thereof that substantially contribute to the prior art may be embodied in the form of a software product stored in a storage medium and including instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.

Finally, it should be noted that: the above-mentioned embodiments are only specific embodiments of the present application, and are used for illustrating the technical solutions of the present application, but not limiting the same, and the scope of the present application is not limited thereto, and although the present application is described in detail with reference to the foregoing embodiments, those skilled in the art should understand that: any person skilled in the art can modify or easily conceive the technical solutions described in the foregoing embodiments or equivalent substitutes for some technical features within the technical scope disclosed in the present application; such modifications, changes or substitutions do not depart from the spirit and scope of the exemplary embodiments of the present application, and are intended to be covered by the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.

Claims

1. A financial instrument accounting processing method, comprising:

acquiring transaction data of different financial instruments;

2. The method of claim 1, wherein the asset data of each financial instrument is subject to the following accounting process using its independent accounting service module:

3. The method of claim 2, wherein performing multi-threaded batch processing on each set of transaction data to obtain batch result data comprises:

carrying out multi-thread batch processing on each group of transaction data;

setting a redis distributed lock for transaction data in each thread;

4. The method of claim 3, further comprising:

5. The method of claim 1, further comprising:

the acquiring transaction data of different financial instruments comprises:

6. The method of claim 5, further comprising:

periodically synchronizing data from the master database to the slave database;

7. The method of claim 1, further comprising:

8. A financial instrument accounting processing apparatus, comprising:

9. An electronic device, comprising: a processor, a storage medium and a bus, the storage medium storing machine-readable instructions executable by the processor, the processor and the storage medium communicating via the bus when the electronic device is operating, the processor executing the machine-readable instructions to perform the steps of the method according to any one of claims 1 to 7.

10. A computer-readable storage medium, having stored thereon a computer program which, when being executed by a processor, is adapted to carry out the steps of the method according to any one of claims 1 to 7.