CN106503974B - Transaction data processing method and device - Google Patents
Transaction data processing method and device Download PDFInfo
- Publication number
- CN106503974B CN106503974B CN201710007486.5A CN201710007486A CN106503974B CN 106503974 B CN106503974 B CN 106503974B CN 201710007486 A CN201710007486 A CN 201710007486A CN 106503974 B CN106503974 B CN 106503974B
- Authority
- CN
- China
- Prior art keywords
- data
- transaction
- information
- information data
- transaction information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/38—Payment protocols; Details thereof
- G06Q20/382—Payment protocols; Details thereof insuring higher security of transaction
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/02—Payment architectures, schemes or protocols involving a neutral party, e.g. certification authority, notary or trusted third party [TTP]
- G06Q20/023—Payment architectures, schemes or protocols involving a neutral party, e.g. certification authority, notary or trusted third party [TTP] the neutral party being a clearing house
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/04—Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
Abstract
The disclosure relates to a transaction data processing method and device. The method comprises the following steps: acquiring original transaction information data of different business systems, and storing the original transaction information data of the different business systems into a local data table on the fund management server; uniformly converting at least part of preset data in the original transaction information data of the different business systems stored in the local data table into first transaction information data which can be recognized by the fund management server according to a data conversion configuration table; and adding preset transaction data to each first transaction information data to form second transaction information data which can be identified by a bank system, and sending the second transaction information data to the bank system. The method and the device can reduce the influence on the service system when the data falls to the ground and reduce the code redundancy.
Description
Technical Field
The present disclosure relates to the field of data processing technologies, and in particular, to a transaction data processing method and a transaction data processing apparatus.
Background
At present, the capital platform has a series of advantages and characteristics that the capital platform can conveniently manage the fund flow and the like because the capacity of external receipt and payment is higher and higher. Therefore, many business systems tend to send the payment and receipt work to the fund platform for unified processing, so that each business system reduces a large amount of manual payment and receipt work and improves business capacity.
In the related technology, because the fund platform is usually connected with each business system, and many related transaction information storage fields and the like in each business system are different and cannot be unified, the fund management platform is inconvenient to process and has low efficiency. This further results in that when the capital platform accesses each service system to obtain data, the connection time is too long, which affects the normal operation of each service system. In addition, when a new transaction type of a service is newly added to the service system, codes need to be rewritten at the fund platform end, and the method is complex, large in development workload and high in development cost.
Therefore, there is a need to provide a new technical solution to improve one or more of the problems in the above solutions.
It is to be noted that the information disclosed in the above background section is only for enhancement of understanding of the background of the present disclosure, and thus may include information that does not constitute prior art known to those of ordinary skill in the art.
Disclosure of Invention
An object of the present disclosure is to provide a transaction data processing method and a transaction data processing apparatus, which overcome one or more of the problems due to the limitations and disadvantages of the related art, at least to some extent.
Additional features and advantages of the disclosure will be set forth in the detailed description which follows, or in part will be obvious from the description, or may be learned by practice of the disclosure.
According to a first aspect of the embodiments of the present disclosure, there is provided a transaction data processing method applied to a fund management server, the method including:
acquiring original transaction information data of different business systems, and storing the original transaction information data of the different business systems into a local data table on the fund management server;
uniformly converting at least part of preset data in the original transaction information data of the different business systems stored in the local data table into first transaction information data which can be recognized by the fund management server according to a data conversion configuration table;
and adding preset transaction data to each first transaction information data to form second transaction information data which can be identified by a bank system, and sending the second transaction information data to the bank system.
In an exemplary embodiment of the present disclosure, the method further includes:
checking whether the obtained original transaction information data of each service system in the different service systems has repeated data;
and when the original transaction information data of each service system in the different service systems has no repeated data, storing the original transaction information data of the different service systems into the local data table.
In an exemplary embodiment of the present disclosure, the preset data in each of the original transaction information data includes transaction related information recorded in a business system;
the data conversion configuration table comprises a corresponding relation table of transaction associated information recorded in each service system and transaction associated information on the fund management server;
the step of uniformly converting part of preset data in the original transaction information data of the different business systems stored in the local data table into first transaction information data recognizable by the fund management server according to a data conversion configuration table comprises the following steps:
and acquiring the transaction associated information in each original transaction information data, and then finding the corresponding transaction associated information on the fund management server according to the corresponding relation table to serve as the first transaction information data.
In an exemplary embodiment of the present disclosure, the preset transaction data includes one or more of receipt and payment channel information, receipt and payment direction information, customer information, and bank information.
In an exemplary embodiment of the present disclosure, the adding of the preset transaction data to each of the first transaction information data includes:
grouping all the first transaction information data according to the payment and receipt channel information corresponding to each first transaction information data or the transaction amount information in the original transaction information data;
and carrying out batch processing on each group of grouped first transaction information data and adding the preset transaction data.
In an exemplary embodiment of the present disclosure, the grouping all the first transaction information data according to the transaction amount information in the original transaction information data corresponding to each of the first transaction information data includes:
dividing the first transaction information data of which the transaction amount in the transaction amount information is greater than or equal to a preset amount threshold value in all the first transaction information data into a group;
and dividing the first transaction information data of which the transaction amount in the transaction amount information is smaller than the preset amount threshold value in all the first transaction information data into a group.
In an exemplary embodiment of the present disclosure, the method further includes:
acquiring transaction result information from the bank system in an asynchronous task mode; the transaction result information is obtained after the bank system carries out transaction processing according to the second transaction information data;
and packaging the transaction result information into a message queue MQ message and storing the message in a sending queue, so that each service system acquires corresponding transaction result information from the sending queue, and updating corresponding original transaction information data in each service system after acquiring the transaction result information.
According to a second aspect of the embodiments of the present disclosure, there is provided a transaction data processing apparatus applied to a fund management server, the apparatus including:
the data acquisition module is used for acquiring original transaction information data of different business systems and storing the original transaction information data of the different business systems into a local data table on the fund management server;
the data conversion module is used for uniformly converting at least part of preset data in the original transaction information data of the different business systems stored in the local data table into first transaction information data which can be recognized by the fund management server according to a data conversion configuration table; and
and the data adding module is used for adding preset transaction data to each first transaction information data to form second transaction information data which can be identified by the bank system and sending the second transaction information data to the bank system.
In an exemplary embodiment of the present disclosure, the apparatus further includes a data checking module, configured to:
checking whether the obtained original transaction information data of each service system in the different service systems has repeated data;
the data acquisition module is further configured to store the original transaction information data of the different service systems into the local data table when the original transaction information data of each service system of the different service systems has no duplicate data.
In an exemplary embodiment of the present disclosure, the preset data in each of the original transaction information data includes transaction related information recorded in a business system;
the data conversion configuration table comprises a corresponding relation table of transaction associated information recorded in each service system and transaction associated information on the fund management server;
the data conversion module is configured to obtain the transaction related information in each original transaction information data, then find the corresponding transaction related information on the fund management server according to the correspondence table, and use the transaction related information as the first transaction information data.
In an exemplary embodiment of the present disclosure, the preset transaction data includes one or more of receipt and payment channel information, receipt and payment direction information, customer information, and bank information.
In an exemplary embodiment of the present disclosure, the data adding module is configured to:
grouping all the first transaction information data according to the payment and receipt channel information corresponding to each first transaction information data or the transaction amount information in the original transaction information data;
and carrying out batch processing on each group of grouped first transaction information data and adding the preset transaction data.
In an exemplary embodiment of the present disclosure, the data adding module includes a data grouping module configured to:
dividing the first transaction information data of which the transaction amount in the transaction amount information is greater than or equal to a preset amount threshold value in all the first transaction information data into a group;
and dividing the first transaction information data of which the transaction amount in the transaction amount information is smaller than the preset amount threshold value in all the first transaction information data into a group.
In an exemplary embodiment of the present disclosure, the apparatus further includes a transaction result interaction module, configured to:
acquiring transaction result information from the bank system in an asynchronous task mode; the transaction result information is obtained after the bank system carries out transaction processing according to the second transaction information data;
and packaging the transaction result information into a message queue MQ message and storing the message in a sending queue, so that each service system acquires corresponding transaction result information from the sending queue, and updating corresponding original transaction information data in each service system after acquiring the transaction result information.
The technical scheme provided by the embodiment of the disclosure can have the following beneficial effects:
in an embodiment of the disclosure, through the transaction data processing method and the transaction data processing device, original transaction data from different business systems are stored locally in a fund management server, then the original transaction information data are converted into transaction information data which can be identified by the fund management server, and then the converted transaction information data are added with preset transaction data to complement necessary transaction information; therefore, on one hand, the data is stored in the local fund management server and then processed, the problem of the service system caused by overlong connection time is prevented, and the influence on the service system is reduced. In addition, the data conversion adopts a configuration table mode, so that the code does not need to be rewritten at the fund management server end when the service system newly adds a new service transaction type every time, and the code redundancy is reduced; on the other hand, because the code does not need to be rewritten when a new transaction type of the service is newly added every time, only the configuration table needs to be modified, the method is simple and convenient, the workload of system development is reduced, and the cost of manpower and financial resources is saved.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and together with the description, serve to explain the principles of the disclosure. It is to be understood that the drawings in the following description are merely exemplary of the disclosure, and that other drawings may be derived from those drawings by one of ordinary skill in the art without the exercise of inventive faculty.
FIG. 1 schematically illustrates a first transaction data processing method flow diagram in an exemplary embodiment of the disclosure;
FIG. 2 schematically illustrates a second transaction data processing method flow diagram in an exemplary embodiment of the disclosure;
FIG. 3 schematically illustrates a third transaction data processing method flow diagram in an exemplary embodiment of the disclosure;
FIG. 4 schematically illustrates a fourth transaction data processing method flow diagram in an exemplary embodiment of the disclosure;
FIG. 5 schematically illustrates a fifth transactional data processing method flow diagram in an exemplary embodiment of the disclosure;
FIG. 6 schematically illustrates a block diagram of a transaction data processing device in an exemplary embodiment of the disclosure;
fig. 7 schematically illustrates another transaction data processing apparatus in an exemplary embodiment of the disclosure.
Detailed Description
Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many different forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.
Furthermore, the drawings are merely schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus their repetitive description will be omitted. Some of the block diagrams shown in the figures are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities may be implemented in the form of software, or in one or more hardware modules or integrated circuits, or in different networks and/or processor devices and/or microcontroller devices.
The exemplary embodiment first provides a transaction data processing method, which may be applied to a fund management server. In this example embodiment, the fund management server may be communicatively coupled to a banking system and a different business system. The fund management server and the bank system can be in communication connection with the bank enterprise platform server to realize information interaction. The banking system may also be a third party transaction platform system. Referring to fig. 1, the transaction data processing method may include:
step S101: acquiring original transaction information data of different business systems, and storing the original transaction information data of the different business systems into a local data table on the fund management server;
step S102: uniformly converting at least part of preset data in the original transaction information data of the different business systems stored in the local data table into first transaction information data which can be recognized by the fund management server according to a data conversion configuration table;
step S103: and adding preset transaction data to each first transaction information data to form second transaction information data which can be identified by a bank system, and sending the second transaction information data to the bank system.
Through the transaction data processing method, on one hand, the data is stored in the local fund management server and then processed, so that the problem of the service system caused by overlong connection time is prevented, and the influence on the service system is reduced. In addition, the data conversion adopts a configuration table mode, so that the code does not need to be rewritten at the fund management server end when the service system newly adds a new service transaction type every time, and the code redundancy is reduced; on the other hand, because the code does not need to be rewritten when a new transaction type of the service is newly added every time, only the configuration table needs to be modified, the method is simple and convenient, the workload of system development is reduced, and the cost of manpower and financial resources is saved.
Hereinafter, the respective steps of the above-described method in the present exemplary embodiment will be described in more detail with reference to fig. 1 to 6.
In step S101, original transaction information data of different business systems is obtained, and stored in a local data table on the fund management server.
In this exemplary embodiment, the business system may be an insurance business system, and the different business systems may include different insurance business systems, such as company systems of insurance, personal insurance, group insurance, and bank insurance. The raw transaction information data may include data source system codes, data transaction associated information, and the like, and the data transaction associated information may be, for example, a customer number, a different bank code, a transaction amount, and the like. Because each company system independently self-defines the data format, the original transaction information data recorded and stored in the company systems are different at many times and are difficult to be effectively unified.
In this exemplary embodiment, the fund management server may adopt a database link DBLINK mode to drop the data batch query in different business systems to local storage and insert the data batch query into the local data table, so as to prevent the problem that the business system and the fund management server have too long connection time. Therefore, the problem that the data is connected with the service system data table within a long time when the data is stored on the ground is solved, and the influence on the service system is reduced, so that the service system can normally and stably work.
In step S102, at least a part of preset data in the original transaction information data of the different business systems stored in the local data table is uniformly converted into first transaction information data recognizable by the fund management server according to a data conversion configuration table.
In an exemplary embodiment, the preset data in each of the original transaction information data may include transaction-related information recorded in a business system, such as a different bank code, a data source company organization code, and the like.
The data conversion configuration table may include a correspondence table of transaction-related information recorded in each business system and transaction-related information on the fund management server.
That is, different codes recorded in different business systems, for example, different codes of the same bank, are unified and a corresponding relation table is established on the fund management server, so that different codes in different business systems, for example, different codes of the same bank, are unified, and other information can also be unified based on the same processing mode.
Referring to fig. 2, on the basis of the above embodiment, in the present exemplary embodiment, the step S102 in the transaction data processing method may include:
step S1021: and acquiring the transaction associated information in each original transaction information data, and then finding the corresponding transaction associated information on the fund management server according to the corresponding relation table to serve as the first transaction information data.
In the exemplary embodiment, the data conversion is performed to convert some basic transaction information data from different business systems into data information that can be uniformly recognized by the fund platform. The conversion mode can be realized by splicing an SQL statement to search a corresponding relation table. The converted information data is mainly some basic data, such as organization codes (different codes represent different insurance company systems), bank names, bank short names, and the like. The conversion configuration of the data is finished by a data conversion configuration table on the fund management server platform, and the data is in one-to-one correspondence with different business systems. Therefore, the trouble that the new transaction type of each newly added service of the service system needs to rewrite the code is solved, and the code redundancy is reduced. Because the code does not need to be rewritten when a new transaction type of the service is newly added every time, only the configuration table needs to be modified, the method is simple and convenient, the workload of system development is reduced, and a large amount of development cost is saved.
In step S103, adding preset transaction data to each first transaction information data to form second transaction information data recognizable by a banking system, and sending the second transaction information data to the banking system.
In an exemplary embodiment, the second transaction information data may also be received by the bank-enterprise platform server and then sent to the banking system or the third-party transaction platform system. The preset transaction data may include one or more of payment and receipt channel information (such as guangzhou union of bank, insurance, union of gold, and the like), payment and receipt direction information (such as collection and payment), customer information (such as customer number and bill number), and bank information (such as bank code, bank name or abbreviation). Of course, other information, such as company information, etc., may be used, and the exemplary embodiment is not particularly limited thereto.
Referring to fig. 3, in the present exemplary embodiment, the adding of the preset transaction data to each of the first transaction information data may include the following steps S301 to S302. Wherein:
step S301: and grouping all the first transaction information data according to the payment and receipt channel information corresponding to each first transaction information data or the transaction amount information in the original transaction information data.
For example, the first transaction information data of the payment direction may be divided into one group and the first transaction information data of the payment direction may be divided into another group according to the information of the payment direction.
For example, in step S301, grouping all the first transaction information data according to the transaction amount information in the original transaction information data corresponding to each of the first transaction information data may include:
step 3011: and dividing the first transaction information data of which the transaction amount is greater than or equal to a preset amount threshold in the transaction amount information in all the first transaction information data into a group. For example, the first transaction information data having the transaction amount of 10000 yuan or more is divided into one group, i.e., a large amount group.
Step 3012: and dividing the first transaction information data of which the transaction amount in the transaction amount information is smaller than the preset amount threshold value in all the first transaction information data into another group. For example, the first transaction information data having the transaction amount less than 10000 yuan is divided into one group, i.e., a small amount group.
Step S302: and carrying out batch processing on each group of grouped first transaction information data and adding the preset transaction data. For example, different payment and receipt channel information may be added according to the size of the batch, for example, a large amount group corresponds to one payment and receipt channel and a small amount group corresponds to another payment and receipt channel. Therefore, the data packet can be converted in batch, and the data processing efficiency is improved.
In the exemplary embodiment, the process of adding the preset transaction data, that is, the process of complementing the data information, is to convert the unified data information format of the fund management server platform into an information format that can be recognized by a corresponding third party or a bank. The data complemented by the complementing mode is mainly necessary information of a series of transactions such as banks, names, client numbers, account numbers, receiving and paying channels and the like of the banks or third-party systems, wherein the most important is the conversion of the receiving and paying channels, the conversion process mainly adopts a grouping strategy, the data are grouped according to keywords, and for the data of the same keyword, the information of the channels and the like is the same and is converted in batches. For example, the fund management server platform may divide the group into groups according to the size, and when the group is currently divided, the large and small amount marks are obtained and the group is divided, so that the large amount and the small amount are taken through different payment channels. The data grouping completion determines the specific three-party flow direction of the receipt and payment data, namely, the transaction is carried out through what three-party channel, and the process is closely related to accounting finance, so that the transaction data can be safely, reliably and quickly processed.
Referring to fig. 4, based on the above embodiment, in an exemplary embodiment, the transaction data processing method may further include the following steps 401 to 402. Wherein:
step 401: and checking whether the obtained original transaction information data of each service system in the different service systems has repeated data.
In the exemplary embodiment, in the data landing storage process, after the data of the business system lands on the fund management server, a verification process for preventing the system from retransmitting the data is started, which is implemented in the storage process and mainly performs comparison according to the business information, and the verification mode mainly adopts SQL statement logic main keys for comparison and judges whether the sent transaction information has repeated data or not by comparing whether the data is the same or not. If so, the data may be retrieved.
Step 402: and when the original transaction information data of each service system in the different service systems has no repeated data, storing the original transaction information data of the different service systems into the local data table. That is, when the acquired data has no error of repeating data, the data is stored to be processed locally, and the error of the transaction data is avoided.
Referring to fig. 5, based on the above embodiment, in an exemplary embodiment, the transaction data processing method further includes the following steps 501 to 502. Wherein:
step 501: acquiring transaction result information from the bank system in an asynchronous task mode; and the transaction result information is obtained after the bank system carries out transaction processing according to the second transaction information data. For example, the transaction result information may be prompt information such as "transaction success", "transaction failure", and the like.
Step 502: and packaging the transaction result information into a message queue MQ message and storing the message in a sending queue, so that each service system acquires corresponding transaction result information from the sending queue, and updating corresponding original transaction information data in each service system after acquiring the transaction result information. For example, when the transaction is successful, the business system may update the corresponding original transaction information data.
For example, fig. 5 above shows a data rollback mode, which mainly adopts an MQ message mechanism to process, after a banking system processes a transaction result, for example, a banking platform server may automatically query the transaction result from the banking system or a third-party system according to a schedule through an asynchronous task. After the transaction result is obtained, the transaction result of the data on the fund management server platform is updated, then the information is packaged into MQ messages, the MQ messages are sent to the MQ message server and stored in a sending queue, the business system can fetch the data from the sending queue at regular time, and the transaction information of the data corresponding to the business system is updated after the data is obtained.
The above-described transaction information data processing method in the present exemplary embodiment may include the following technical advantages: firstly, the data consistency of both parties can be kept by adopting a DBLINK data query mode; the adoption of the mode of landing first and then processing can shorten the connection time of the service system database and prevent the influence on the service system. Secondly, in the data translation process, a configuration table or a data dictionary mode is adopted, so that the reusability of codes is enhanced, the code redundancy is reduced, and the expandability of the system is improved; each time a bank or channel is newly added, the method can be realized only by configuring the background logic code into the corresponding relation table without adjusting the background logic code. Thirdly, the data disk returning mode of the MQ message mechanism is asynchronous operation, so that the relevance of the two systems is reduced, and the service stop of one party cannot influence the service of the other party.
It should be noted that although the various steps of the methods of the present disclosure are depicted in the drawings in a particular order, this does not require or imply that these steps must be performed in this particular order, or that all of the depicted steps must be performed, to achieve desirable results. Additionally or alternatively, certain steps may be omitted, multiple steps combined into one step execution, and/or one step broken down into multiple step executions, etc. Additionally, it will also be readily appreciated that the steps may be performed synchronously or asynchronously, e.g., among multiple modules/processes/threads.
Further, in the present exemplary embodiment, a transaction data processing apparatus is also provided. Referring to fig. 6, the apparatus 100 may include a data acquisition module 101, a data conversion module 102, and a data addition module 103. Wherein:
the data acquisition module 101 is configured to acquire original transaction information data of different service systems, and store the original transaction information data of the different service systems in a local data table on the fund management server;
the data conversion module 102 is configured to uniformly convert at least part of preset data in the original transaction information data of the different business systems stored in the local data table into first transaction information data that can be recognized by the fund management server according to a data conversion configuration table; and
the data adding module 103 is configured to add preset transaction data to each first transaction information data to form second transaction information data that can be recognized by a bank system, and send the second transaction information data to the bank system.
In an exemplary embodiment of the present disclosure, the apparatus 100 may further include a data checking module, configured to check whether duplicate data exists in the obtained original transaction information data of each of the different business systems. The data acquisition module is further configured to store the original transaction information data of the different service systems into the local data table when the original transaction information data of each service system of the different service systems has no duplicate data.
In an exemplary embodiment of the present disclosure, the preset data in each of the original transaction information data may include transaction related information recorded in a service system; the first data conversion configuration table may include a correspondence table between transaction-related information recorded in each business system and transaction-related information on the fund management server.
The data conversion module 102 may be configured to obtain the transaction related information in each original transaction information data, and then find the corresponding transaction related information on the fund management server according to the corresponding relationship table and use the transaction related information as the first transaction information data.
In an exemplary embodiment of the present disclosure, the preset transaction data may include one or more of receipt and payment channel information, receipt and payment direction information, customer information, and bank information. Of course, other information, such as company information, etc., may be used, and the exemplary embodiment is not particularly limited thereto.
In an exemplary embodiment of the disclosure, the data adding module 103 may be configured to:
grouping all the first transaction information data according to the payment and receipt channel information corresponding to each first transaction information data or the transaction amount information in the original transaction information data;
and carrying out batch processing on each group of grouped first transaction information data and adding the preset transaction data.
In an exemplary embodiment of the present disclosure, the data adding module 103 may include a data grouping module configured to: dividing the first transaction information data of which the transaction amount in the transaction amount information is greater than or equal to a preset amount threshold value in all the first transaction information data into a group; and dividing the first transaction information data of which the transaction amount in the transaction amount information is smaller than the preset amount threshold value in all the first transaction information data into a group.
In an exemplary embodiment of the present disclosure, the apparatus 100 may further include a transaction result interaction module, configured to obtain transaction result information from the banking system in an asynchronous task manner; and the transaction result information is obtained after the bank system carries out transaction processing according to the second transaction information data. And after the transaction result interaction module acquires the transaction result information, packaging the transaction result information into a message queue MQ message and storing the message queue MQ message to a sending queue, so that each service system acquires corresponding transaction result information from the sending queue, and updates corresponding original transaction information data in each service system after acquiring the transaction result information.
With regard to the apparatus in the above-described embodiment, the specific manner in which each module performs the operation has been described in detail in the embodiment related to the method, and will not be elaborated here.
It should be noted that although in the above detailed description several modules or units of the device for action execution are mentioned, such a division is not mandatory. Indeed, the features and functionality of two or more modules or units described above may be embodied in one module or unit, according to embodiments of the present disclosure. Conversely, the features and functions of one module or unit described above may be further divided into embodiments by a plurality of modules or units. The components shown as modules or units may or may not be physical units, i.e. may be located in one place or may also be distributed over a plurality of network units. Some or all of the modules can be selected according to actual needs to achieve the purpose of the wood-disclosed scheme. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will readily understand that the exemplary embodiments described herein may be implemented by software, or by software in combination with necessary hardware. Therefore, the technical solution according to the embodiments of the present disclosure may be embodied in the form of a software product, which may be stored in a non-volatile storage medium (which may be a CD-ROM, a usb disk, a removable hard disk, etc.) or on a network, and includes several instructions to make a computing device (which may be a personal computer, a server, or a network device, etc.) execute the method according to the embodiments of the present disclosure.
Fig. 7 shows a schematic diagram of a transaction data device 400 according to an example embodiment of the present disclosure. For example, the apparatus 400 may be provided as a server. Referring to fig. 7, apparatus 400 includes a processing component 422, which further includes one or more processors, and memory resources, represented by memory 432, for storing instructions, such as applications, that are executable by processing component 422. The application programs stored in memory 432 may include one or more modules that each correspond to a set of instructions. Further, the processing component 422 is configured to execute instructions to perform the above-described methods.
The apparatus 400 may also include a power component 426 configured to perform power management of the apparatus 400, a wired or wireless network interface 450 configured to connect the apparatus 400 to a network, and an input output (I/O) interface 458. The apparatus 400 may operate based on an operating system stored in the memory 432, such as Windows Server, Mac OS XTM, UnixTM, LinuxTM, FreeBSDTM, or the like.
Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This application is intended to cover any variations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.
Claims (14)
1. A transaction data processing method applied to a fund management server is characterized by comprising the following steps:
acquiring original transaction information data of different business systems, and storing the original transaction information data of the different business systems into a local data table on the fund management server;
uniformly converting at least part of preset data in the original transaction information data of the different business systems stored in the local data table into first transaction information data which can be recognized by the fund management server according to a data conversion configuration table;
adding preset transaction data to each first transaction information data to form second transaction information data which can be identified by a bank system, and sending the second transaction information data to the bank system;
the fund management server adopts a database link mode to carry out batch query on data in different business systems, and inserts the data into the local data table after the data is stored locally;
the preset transaction data comprises information of a payment and receipt channel; the adding of the preset transaction data to each of the first transaction information data includes:
grouping all the first transaction information data according to the keywords of the payment and receipt channel information corresponding to each first transaction information data;
and carrying out batch processing on each group of grouped first transaction information data and adding the preset transaction data so as to carry out conversion of the information of the collection and payment channel.
2. The transaction data processing method of claim 1, wherein the method further comprises:
checking whether the obtained original transaction information data of each service system in the different service systems has repeated data;
and when the original transaction information data of each service system in the different service systems has no repeated data, storing the original transaction information data of the different service systems into the local data table.
3. The transaction data processing method according to claim 1, wherein the preset data in each of the original transaction information data includes transaction-related information recorded in a business system;
the data conversion configuration table comprises a corresponding relation table of transaction associated information recorded in each service system and transaction associated information on the fund management server;
the step of uniformly converting part of preset data in the original transaction information data of the different business systems stored in the local data table into first transaction information data recognizable by the fund management server according to a data conversion configuration table comprises the following steps:
and acquiring the transaction associated information in each original transaction information data, and then finding the corresponding transaction associated information on the fund management server according to the corresponding relation table to serve as the first transaction information data.
4. The transaction data processing method according to any one of claims 1 to 3, wherein the preset transaction data further includes one or more of receipt and payment direction information, customer information, and bank information.
5. The transaction data processing method according to claim 4, wherein the adding of the preset transaction data to each of the first transaction information data comprises:
grouping all the first transaction information data according to transaction amount information in the original transaction information data corresponding to each first transaction information data;
and carrying out batch processing on each group of grouped first transaction information data and adding the preset transaction data.
6. The transaction data processing method of claim 5, wherein the grouping all of the first transaction information data according to the transaction amount information in the original transaction information data corresponding to each of the first transaction information data comprises:
dividing the first transaction information data of which the transaction amount in the transaction amount information is greater than or equal to a preset amount threshold value in all the first transaction information data into a group;
and dividing the first transaction information data of which the transaction amount in the transaction amount information is smaller than the preset amount threshold value in all the first transaction information data into a group.
7. The transaction data processing method of claim 5, wherein the method further comprises:
acquiring transaction result information from the bank system in an asynchronous task mode; the transaction result information is obtained after the bank system carries out transaction processing according to the second transaction information data;
and packaging the transaction result information into a message queue MQ message and storing the message in a sending queue, so that each service system acquires corresponding transaction result information from the sending queue, and updating corresponding original transaction information data in each service system after acquiring the transaction result information.
8. A transaction data processing apparatus applied to a fund management server, the apparatus comprising:
the data acquisition module is used for acquiring original transaction information data of different business systems and storing the original transaction information data of the different business systems into a local data table on the fund management server;
the data conversion module is used for uniformly converting at least part of preset data in the original transaction information data of the different business systems stored in the local data table into first transaction information data which can be recognized by the fund management server according to a data conversion configuration table; and
the data adding module is used for adding preset transaction data to each first transaction information data to form second transaction information data which can be recognized by a bank system and sending the second transaction information data to the bank system;
the fund management server adopts a database link mode to carry out batch query on data in different business systems, and inserts the data into the local data table after the data is stored locally;
the preset transaction data comprises information of a payment and receipt channel; the data adding module is used for:
grouping all the first transaction information data according to the keywords of the payment and receipt channel information corresponding to each first transaction information data;
and carrying out batch processing on each group of grouped first transaction information data and adding the preset transaction data so as to carry out conversion of the information of the collection and payment channel.
9. The apparatus of claim 8, further comprising a data verification module configured to:
checking whether the obtained original transaction information data of each service system in the different service systems has repeated data;
the data acquisition module is further configured to store the original transaction information data of the different service systems into the local data table when the original transaction information data of each service system of the different service systems has no duplicate data.
10. The apparatus according to claim 8, wherein the preset data in each of the original transaction information data includes transaction related information recorded in a business system;
the data conversion configuration table comprises a corresponding relation table of transaction associated information recorded in each service system and transaction associated information on the fund management server;
the data conversion module is configured to obtain the transaction related information in each original transaction information data, then find the corresponding transaction related information on the fund management server according to the correspondence table, and use the transaction related information as the first transaction information data.
11. The apparatus of any one of claims 8 to 10, wherein the predetermined transaction data further comprises one or more of payment and receipt direction information, customer information and bank information.
12. The apparatus of claim 11, wherein the data adding module is configured to:
grouping all the first transaction information data according to transaction amount information in the original transaction information data corresponding to each first transaction information data;
and carrying out batch processing on each group of grouped first transaction information data and adding the preset transaction data.
13. The apparatus of claim 12, wherein the data adding module comprises a data grouping module configured to:
dividing the first transaction information data of which the transaction amount in the transaction amount information is greater than or equal to a preset amount threshold value in all the first transaction information data into a group;
and dividing the first transaction information data of which the transaction amount in the transaction amount information is smaller than the preset amount threshold value in all the first transaction information data into a group.
14. The apparatus of claim 11, further comprising a transaction result interaction module configured to:
acquiring transaction result information from the bank system in an asynchronous task mode; the transaction result information is obtained after the bank system carries out transaction processing according to the second transaction information data;
and packaging the transaction result information into a message queue MQ message and storing the message in a sending queue, so that each service system acquires corresponding transaction result information from the sending queue, and updating corresponding original transaction information data in each service system after acquiring the transaction result information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710007486.5A CN106503974B (en) | 2017-01-04 | 2017-01-04 | Transaction data processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710007486.5A CN106503974B (en) | 2017-01-04 | 2017-01-04 | Transaction data processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106503974A CN106503974A (en) | 2017-03-15 |
| CN106503974B true CN106503974B (en) | 2020-03-17 |
Family
ID=58345010
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710007486.5A Active CN106503974B (en) | 2017-01-04 | 2017-01-04 | Transaction data processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106503974B (en) |
Families Citing this family (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108334614B (en) * | 2018-02-07 | 2020-11-24 | 中国平安人寿保险股份有限公司 | Data updating method, system and storage medium |
| CN108876590A (en) * | 2018-05-24 | 2018-11-23 | 中国银行股份有限公司 | The group technology and system of night transaction amended record |
| CN109409821A (en) * | 2018-09-21 | 2019-03-01 | 中国联合网络通信集团有限公司 | Liquidation method, device and equipment |
| CN109495575B (en) * | 2018-11-30 | 2022-03-04 | 金蝶软件（中国）有限公司 | Service configuration method, system and ERP server |
| CN110458680A (en) * | 2019-08-15 | 2019-11-15 | 中国银行股份有限公司 | Fund pool management control method, system and core banking system |
| CN111143295B (en) * | 2019-11-14 | 2024-01-30 | 泰康保险集团股份有限公司 | Policy information processing method, device, equipment and storage medium |
| CN111239529A (en) * | 2020-03-05 | 2020-06-05 | 西南交通大学 | Excitation test method and system supporting predictive maintenance of electromechanical equipment |
| CN111652729B (en) * | 2020-07-06 | 2023-10-24 | 中国银行股份有限公司 | Method and device for reporting transaction information |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1987925A (en) * | 2006-12-29 | 2007-06-27 | 中国建设银行股份有限公司 | Complex front platform of financial system and transfering method transaction data |
| CN101554005A (en) * | 2006-10-11 | 2009-10-07 | 国际签证服务协会 | Method and system for processing micropayment transactions |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2624177B2 (en) * | 1994-05-31 | 1997-06-25 | 日本電気株式会社 | Batch daily book table creation processing method of banking system |
| CN101334887B (en) * | 2008-08-07 | 2012-05-30 | 金蝶软件（中国）有限公司 | Financial data-handling process and bank enterprise platform device |
| CN102156944A (en) * | 2010-02-11 | 2011-08-17 | 中国工商银行股份有限公司 | Data processing method and system for realizing bank-enterprise interconnection |
| CN101877158A (en) * | 2010-03-23 | 2010-11-03 | 苏州德融嘉信信用管理技术有限公司 | Front service platform of bank and operation processing method thereof |
| CN102546833A (en) * | 2012-03-05 | 2012-07-04 | 浪潮集团山东通用软件有限公司 | Bank enterprise interconnection uniform access platform |
| CN106210109B (en) * | 2016-07-26 | 2021-07-13 | 通联支付网络服务股份有限公司 | Product system for comprehensive payment |
| CN106209911B (en) * | 2016-08-30 | 2019-05-21 | 北京仁聚汇通信息科技有限责任公司 | A kind of data processing method and system of unified payment message |
-
2017
- 2017-01-04 CN CN201710007486.5A patent/CN106503974B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101554005A (en) * | 2006-10-11 | 2009-10-07 | 国际签证服务协会 | Method and system for processing micropayment transactions |
| CN1987925A (en) * | 2006-12-29 | 2007-06-27 | 中国建设银行股份有限公司 | Complex front platform of financial system and transfering method transaction data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106503974A (en) | 2017-03-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106503974B (en) | Transaction data processing method and device | |
| US20200167344A1 (en) | Method and device for writing service data in block chain system | |
| US9020949B2 (en) | Method and system for centralized issue tracking | |
| CN105988862B (en) | Distributed transaction processing method and device | |
| WO2020000720A1 (en) | Server, packet processing method, program, and computer-readable storage medium | |
| CN111277639B (en) | Method and device for maintaining data consistency | |
| CN106445644A (en) | Distributed transaction processing method and device based on improved one-phase commit | |
| CN111522631A (en) | Distributed transaction processing method, device, server and medium | |
| CN113157710B (en) | Block chain data parallel writing method and device, computer equipment and storage medium | |
| CN112559140B (en) | Transaction control method, system, equipment and storage medium for data consistency | |
| CN113051102B (en) | File backup method, device, system, storage medium and computer equipment | |
| CN112835885A (en) | Processing method, device and system for distributed table storage | |
| CN111831536A (en) | Automatic testing method and device | |
| CN111711512B (en) | Message sending method and device | |
| CN116644122A (en) | Data transaction processing method, device, computer equipment and storage medium | |
| US8229946B1 (en) | Business rules application parallel processing system | |
| CN112037003A (en) | File account checking processing method and device | |
| CN111767126A (en) | System and method for distributed batch processing | |
| CN115422225A (en) | Distributed transaction processing method, transaction manager, middleware and system | |
| CN111061576B (en) | Method and system for creating entity object | |
| CN113342774A (en) | Data processing method and device, computer readable medium and electronic equipment | |
| CN111752911A (en) | Data transmission method, system, terminal and storage medium based on Flume | |
| US20190303193A1 (en) | Computing system including enhanced application performance based on last completed operation sequence value | |
| CN113076331B (en) | Method, device, equipment, storage medium and program product for processing middle-stage data | |
| CN112910950B (en) | Uplink method and device for data to be uplink and block link point equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |