CN116049138A - Transaction data tracing method, tracing device and tracing system - Google Patents
Transaction data tracing method, tracing device and tracing system Download PDFInfo
- Publication number
- CN116049138A CN116049138A CN202211676779.XA CN202211676779A CN116049138A CN 116049138 A CN116049138 A CN 116049138A CN 202211676779 A CN202211676779 A CN 202211676779A CN 116049138 A CN116049138 A CN 116049138A
- Authority
- CN
- China
- Prior art keywords
- transaction data
- target transaction
- target
- database
- data set
- 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.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Computing Systems (AREA)
- Computational Linguistics (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application provides a data tracing method, a tracing device and a tracing system of transaction data, wherein the method comprises the following steps: under the condition that the front end is detected to start a target transaction flow, receiving a target transaction data set from the front end, and storing the target transaction data set into a first database, wherein the target transaction data set is a transaction data set carrying first identification information; determining whether the target transaction data set carries second identification information, wherein the second identification information is a payment bill number corresponding to the target transaction flow; under the condition that any target transaction data set carries second identification information, all target transaction data sets are migrated from the first database to the second database; in the event that a targeted query request is received from the query system, all targeted transaction data sets in the second database are sent to the query system. The method solves the problem of low transaction data backtracking efficiency caused by searching target transaction data in redundant transaction data in the prior art.
Description
Technical Field
The present invention relates to the field of computer data processing technologies, and in particular, to a data tracing method, a tracing device, a computer readable storage medium, and a tracing system for transaction data.
Background
Along with the development of mobile interconnection, mobile banking is an important channel for selling financial products, and when the basic function purchasing function is completed, the information backtracking of corresponding purchasing behavior is required to be completed so as to ensure the user permission and meet the supervision requirement. The financial product purchasing process is very complex, the traditional buried point mode is simple and rough in processing the financial product purchasing process, data cleaning and arrangement are difficult, and effective information backtracking cannot be carried out on a large amount of redundant dot data. Meanwhile, the traditional frame based on the storage of the embedded point back end of the page is used for backtracking of financial products, so that redundant and massive useless operations are caused, meanwhile, storage space is wasted, and backtracking efficiency is low. Meanwhile, a large amount of punctiform data is buried, all operation behaviors of a user are difficult to be associated by an authentication system based on time stamps, and meanwhile, the tracing efficiency is low and the tracing cost is high due to the fact that a large amount of redundant data are searched.
Disclosure of Invention
The main objective of the present application is to provide a data tracing method, a tracing device, a computer readable storage medium and a tracing system for transaction data, so as to solve the problem of low tracing efficiency of transaction data caused by searching target transaction data in redundant transaction data in the prior art.
According to an aspect of the embodiments of the present application, there is provided a data tracing method of transaction data, where the data tracing method is applied to a back end, a front end is communicatively connected to the back end, a query system is communicatively connected to the back end, the query system is used for querying the transaction data, and the back end is communicatively connected to a first database and a second database respectively, and the method includes: under the condition that the front end is detected to start a target transaction flow, receiving a target transaction data set from the front end, and storing the target transaction data set into the first database, wherein the target transaction data set is a transaction data set carrying first identification information, the first identification information is a serial number corresponding to the target transaction flow, the target transaction flow is any one of transaction flows, and the transaction flows are in one-to-one correspondence to the serial number; determining whether the target transaction data set carries second identification information, wherein the second identification information is a payment bill number corresponding to the target transaction flow, and the payment bill number corresponds to the transaction flow one by one; migrating all the target transaction data sets from the first database to the second database under the condition that any one of the target transaction data sets carries the second identification information; and under the condition that a target query request from the query system is received, all target transaction data sets in the second database are sent to the query system, wherein the target query request is a query request corresponding to the target transaction flow, and the query request corresponds to the transaction flow one by one.
Optionally, before receiving the target transaction data set from the front end and storing the target transaction data set in the first database, the method further comprises: generating the first identification information according to the target transaction request under the condition that the front end receives the target transaction request; and sending the first identification information to the front end, so that the front end adopts the first identification information to identify the target transaction data set acquired by the front end in the target transaction flow.
Optionally, receiving a target transaction data set from the front end and storing the target transaction data set in the first database, including: receiving a target message from the front end, wherein the content of the target message is the target transaction data set; analyzing the target message to obtain the target transaction data set, and storing the target transaction data set in the first database.
Optionally, before migrating all of the target transaction data sets from the first database into the second database, the method further comprises: acquiring target warehousing time, wherein the target warehousing time is the time when the target transaction data set enters the first database; calculating the difference between the current time and the warehouse-in time to obtain storage time, and determining whether the storage time is greater than a preset time; and deleting all the target transaction data sets in the first database under the condition that the storage time is longer than the preset time.
Optionally, migrating all of the target transaction data sets from the first database into the second database includes: extracting all target transaction data sets from the first database according to the first identification information; and storing all the extracted target transaction data sets into the second database.
Optionally, the target transaction data set includes a plurality of the transaction data, and sending all the target transaction data sets in the second database to the query system includes: calling all target transaction data sets from the second database according to the first identification information; filling all the transaction data of the target transaction data set into a first preset template to obtain a first target transaction data file; and sending the first target transaction data file to the query system.
Optionally, the target transaction data set at least includes the transaction data collected by the front end from a second target transaction data file, where the second target transaction data file is a file formed by filling a second preset template with user information and service information related to the target transaction flow.
According to another aspect of the embodiments of the present application, there is further provided a data tracing device for transaction data, where the data tracing device is applied to a back end, a front end is communicatively connected to the back end, a query system is communicatively connected to the back end, the query system is used for querying the transaction data, and the back end is communicatively connected to a first database and a second database respectively, and the device includes: the receiving unit is used for receiving a target transaction data set from the front end under the condition that the front end is detected to open a target transaction flow, and storing the target transaction data set into the first database, wherein the target transaction data set is a transaction data set carrying first identification information, the first identification information is a serial number corresponding to the target transaction flow, the target transaction flow is any one of transaction flows, and the transaction flow is in one-to-one correspondence with the serial number; the determining unit is used for determining whether the target transaction data set carries second identification information or not, wherein the second identification information is a payment bill number corresponding to the target transaction flow, and the payment bill number corresponds to the transaction flow one by one; a migration unit, configured to migrate all the target transaction data sets from the first database to the second database when any one of the target transaction data sets carries the second identification information; and the sending unit is used for sending all the target transaction data sets in the second database to the query system under the condition of receiving a target query request from the query system, wherein the target query request is a query request corresponding to the target transaction flow, and the query request corresponds to the transaction flow one by one.
According to still another aspect of the embodiments of the present application, there is further provided a computer-readable storage medium including a stored program, wherein the program, when executed by a processor, performs any one of the data trace back methods of transaction data.
According to still another aspect of the embodiments of the present application, there is also provided a data trace back system for transaction data, including: the system comprises one or more processors, a memory, a display device and one or more programs, wherein the one or more programs are stored in the memory and configured to be executed by the one or more processors, and the one or more programs comprise a data tracing method for executing any one of the transaction data.
In the data tracing method of the transaction data, firstly, when the front end is detected to start a target transaction flow, a target transaction data set from the front end is received and stored in the first database, wherein the target transaction data set is a transaction data set carrying first identification information, the first identification information is a serial number corresponding to the target transaction flow, the target transaction flow is any one of transaction flows, and the transaction flow and the serial number are in one-to-one correspondence; then, determining whether the target transaction data set carries second identification information, wherein the second identification information is a payment bill number corresponding to the target transaction flow, and the payment bill number corresponds to the transaction flow one by one; then, if any one of the target transaction data sets carries the second identification information, all the target transaction data sets are migrated from the first database to the second database; and finally, under the condition that a target query request from the query system is received, all the target transaction data sets in the second database are sent to the query system, wherein the target query request is a query request corresponding to the target transaction flow, and the query request corresponds to the transaction flow one by one. Under the condition that the front end starts the target transaction flow, the target transaction data set in the target transaction flow is stored in the first database, the first database is a temporary database, under the condition that any one target transaction data set is determined to carry second identification information, the target transaction flow is determined to have completed a payment link, at the moment, all the target transaction data sets in the first database are migrated to the second database, the second database is used for storing transaction data related to the transaction flow for completing the payment link, under the condition that a target query request of a query system is received, the target transaction data set in the second database is sent to the query system, the query system can check all the transaction data related to the target transaction flow, thereby completing the data of all the transaction data related to the target transaction flow, only the transaction data related to the payment link need to be traced in the transaction data supervision process.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this application, illustrate embodiments of the application and together with the description serve to explain the application and do not constitute an undue limitation to the application. In the drawings:
FIG. 1 illustrates a flow chart of a data trace-back method of transaction data according to one embodiment of the present application;
FIG. 2 illustrates a schematic diagram of a technical framework implementing a data trace-back method of transaction data according to one embodiment of the present application;
fig. 3 shows a schematic diagram of a data trace back device of transaction data according to one embodiment of the present application.
Detailed Description
It should be noted that the following detailed description is illustrative and is intended to provide further explanation of the present application. Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs.
It is noted that the terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of example embodiments in accordance with the present application. As used herein, the singular is also intended to include the plural unless the context clearly indicates otherwise, and furthermore, it is to be understood that the terms "comprises" and/or "comprising" when used in this specification are taken to specify the presence of stated features, steps, operations, devices, components, and/or combinations thereof.
It will be understood that when an element such as a layer, film, region, or substrate is referred to as being "on" another element, it can be directly on the other element or intervening elements may also be present. Furthermore, in the description and in the claims, when an element is described as being "connected" to another element, the element may be "directly connected" to the other element or "connected" to the other element through a third element.
For convenience of description, the following will describe some terms or terms related to the embodiments of the present application:
and (3) backtracking insurance: the bank, the insurance company and the insurance agency record the process of purchasing the financial products by the clients for inquiring by the silver-guard congress.
As described in the background art, in order to solve the above problem, in a typical embodiment of the present application, a data tracing method, a tracing device, a computer readable storage medium and a tracing system for transaction data are provided in the prior art, which are low in tracing efficiency caused by searching for target transaction data in redundant transaction data.
According to an embodiment of the application, a data tracing method of transaction data is provided.
Fig. 1 is a flow chart of a data trace back method of transaction data according to an embodiment of the present application. As shown in fig. 1, the method comprises the steps of:
Step S101, when the front end opening target transaction flow is detected, a target transaction data set from the front end is received and stored in the first database, wherein the target transaction data set is a transaction data set carrying first identification information, the first identification information is a serial number corresponding to the target transaction flow, the target transaction flow is any one of transaction flows, and the transaction flow is in one-to-one correspondence with the serial number;
in order to avoid storing redundant transaction data, in an optional implementation manner, the target transaction data set at least includes the transaction data collected by the front end from a second target transaction data file, where the second target transaction data file is a file formed by filling a second preset template with user information and service information related to the target transaction flow.
In the above embodiment, for the key transaction data, such as the key user information and the key business information, which need to be recorded in the insurance backtracking process, a second preset template is designed at the front end, and in the transaction process, the customer fills the user information, such as the name, the identification card number, and the business information, such as the type of the purchased financial product, in the second preset template to form a second target transaction data file, and the front end only collects the transaction data in the second target transaction data file, that is, the front end only collects the key transaction data, which need to be recorded in the insurance backtracking process, that is, the first database only stores the key transaction data, which need to be recorded in the insurance backtracking process, so that the storage of redundant transaction data is avoided.
In order to correlate transaction data together in the same transaction flow, in an alternative embodiment, prior to step S101, the method further comprises:
step S201, when detecting that the front end receives a target transaction request, generating the first identification information according to the target transaction request;
step S202, transmitting the first identification information to the front end, so that the front end uses the first identification information to identify the target transaction data set collected by the front end in the target transaction flow.
In the above embodiment, as shown in fig. 2, before the front end receives the target transaction request, the monitoring component button is pre-embedded in the front end to monitor the target transaction request from the client, and once the front end receives the target transaction request from the client, the front end sends the target transaction request to the back end through the back end service interface, the back end generates globally unique first identification information for the target transaction request and sends the globally unique first identification information to the front end through the back end service interface, and the front end adopts the first identification information to identify all target transaction data sets in the target transaction flow, and connects in series the transaction data of the whole target transaction flow through the unique first identification information, that is, the irrelevant point-shaped transaction data in the target transaction flow is opened through the unique first identification information.
Optionally, the specific process of receiving the target transaction data set from the front end and storing the target transaction data set in the first database is not limited, and any feasible manner falls within the scope of protection of the present application.
In an alternative embodiment, the step S101 includes:
step S1011, receiving a target message from the front end, wherein the content of the target message is the target transaction data set;
step S1012, parsing the target message to obtain the target transaction data set, and storing the target transaction data set in the first database.
In the above embodiment, the front end collects the transaction data in the second target transaction data file to obtain the target transaction data set, and then packages the target transaction data set into the target message, as shown in fig. 2, the front end transmits the target message to the back end through the back end service interface, and after the back end analyzes the target message to obtain the target transaction data set, the target transaction data set is stored in the first database, so that the front end critical transaction data is migrated to the first database.
Step S102, determining whether the target transaction data set carries second identification information, wherein the second identification information is a payment bill number corresponding to the target transaction flow, and the payment bill number corresponds to the transaction flow one by one;
The transaction flow is a financial product purchasing process, and there is a situation that a customer may only temporarily browse a financial product and does not pay fees, but only need to trace transaction data related to the transaction flow for completing a payment link in a security tracing process, and does not need to trace temporary browsing data, so that second identification information, namely a payment list number, is designed as a key index to distinguish purchasing financial product data from temporary browsing data, and when a target transaction data set carries the second identification information, it is determined that the transaction flow completes the payment link, and final recording is needed for the transaction data related to the target transaction flow.
Step S103, when any one of the target transaction data sets carries the second identification information, all the target transaction data sets are migrated from the first database to the second database;
the first database is used for storing temporary browsing data of clients, the second database is used for storing data of purchasing financial products, as shown in fig. 2, a trigger is arranged on the first database, the trigger monitors whether key indexes are generated, namely, a target transaction data set carries second identification information, when the target transaction data set carries the second identification information, it is determined that the transaction process finishes a payment link, final recording is needed for transaction data related to the transaction process, and at the moment, the target transaction data set is migrated from the first database to the second database.
In order to further reduce the storage of redundant transaction data, in another alternative embodiment, prior to step S103, the method further comprises:
step S301, obtaining target warehousing time, wherein the target warehousing time is the time when the target transaction data set enters the first database;
step S302, calculating the difference between the current time and the warehouse-in time to obtain storage time, and determining whether the storage time is larger than a preset time;
step S303, deleting all the target transaction data sets in the first database when the storage time is longer than the preset time.
In the above embodiment, a timer is provided on the first database, and the timer is used for determining the storage time of the target transaction data set in the first database, when the storage time is greater than the preset time, it can be determined that the transaction data in the target transaction data set is temporary browsing data, and the customer does not purchase a financial product, at this time, all the target transaction data sets in the target transaction process are deleted to complete the cleaning of the redundant transaction data, and further reduce the storage of the redundant transaction data.
Optionally, the present application is not limited to a specific process of migrating all the target transaction data sets from the first database to the second database, and any feasible manner falls within the scope of protection of the present application.
In an alternative embodiment, the step S103 includes:
step S1031, extracting all the target transaction data sets from the first database according to the first identification information;
step S1032, storing all the extracted target transaction data sets into the second database.
In the above embodiment, the front end adopts the first identification information to identify all the target transaction data sets in the target transaction flow, so that not only is the transaction data of the whole target transaction flow connected in series, but also the transaction data of the target transaction flow is integrally migrated from the first database to the second database according to the first identification information, and the transaction data migration efficiency is improved.
Step S104, when a target query request from the query system is received, all the target transaction data sets in the second database are sent to the query system, wherein the target query request is a query request corresponding to the target transaction flow, and the query request corresponds to the transaction flow one by one.
Optionally, the specific process of sending all the target transaction data sets in the second database to the query system is not limited, and any feasible manner falls within the scope of protection of the present application.
In an alternative embodiment, the target transaction data set includes a plurality of the transaction data, and the step S104 includes:
step S1041, calling all the target transaction data sets from the second database according to the first identification information;
step S1042, filling all the transaction data of the target transaction data set into a first preset template to obtain a first target transaction data file;
step S1043, transmitting the first target transaction data file to the query system.
In the above embodiment, the inquiry system is a certification system, and the silver-insurance prison inquires the transaction data related to the target transaction flow through the certification system, and when the certification system receives the target inquiry request, the target transaction data set is called out from the second database and filled into the first preset template, and the first preset template and the second preset template are generally the same template, so as to realize the return display of the transaction data related to the target transaction flow in the certification system, thereby realizing the tracing of the transaction data.
In the data tracing method of the transaction data, firstly, when the front end is detected to start a target transaction flow, a target transaction data set from the front end is received and stored in the first database, wherein the target transaction data set is a transaction data set carrying first identification information, the first identification information is a serial number corresponding to the target transaction flow, the target transaction flow is any one of transaction flows, and the transaction flow and the serial number are in one-to-one correspondence; then, determining whether the target transaction data set carries second identification information, wherein the second identification information is a payment bill number corresponding to the target transaction flow, and the payment bill number corresponds to the transaction flow one by one; then, if any one of the target transaction data sets carries the second identification information, all the target transaction data sets are migrated from the first database to the second database; and finally, under the condition that a target query request from the query system is received, all the target transaction data sets in the second database are sent to the query system, wherein the target query request is a query request corresponding to the target transaction flow, and the query request corresponds to the transaction flow one by one. Under the condition that the front end starts the target transaction flow, the target transaction data set in the target transaction flow is stored in the first database, the first database is a temporary database, under the condition that any one target transaction data set is determined to carry second identification information, the target transaction flow is determined to have completed a payment link, at the moment, all the target transaction data sets in the first database are migrated to the second database, the second database is used for storing transaction data related to the transaction flow for completing the payment link, under the condition that a target query request of a query system is received, the target transaction data set in the second database is sent to the query system, the query system can check all the transaction data related to the target transaction flow, thereby completing the data of all the transaction data related to the target transaction flow, only the transaction data related to the payment link need to be traced in the transaction data supervision process.
It should be noted that the steps illustrated in the flowcharts of the figures may be performed in a computer system such as a set of computer executable instructions, and that although a logical order is illustrated in the flowcharts, in some cases the steps illustrated or described may be performed in an order other than that illustrated herein.
The embodiment of the application also provides a data tracing device for transaction data, and it should be noted that the data tracing device for transaction data in the embodiment of the application can be used for executing the data tracing method for transaction data provided in the embodiment of the application. The following describes a data tracing device for transaction data provided in the embodiment of the present application.
Fig. 3 is a schematic diagram of a data trace back device for transaction data according to an embodiment of the present application. As shown in fig. 3, the apparatus includes:
a receiving unit 10, configured to receive a target transaction data set from the front end and store the target transaction data set in the first database when the front end is detected to open a target transaction flow, where the target transaction data set is a transaction data set carrying first identification information, the first identification information is a serial number corresponding to the target transaction flow, the target transaction flow is any one of transaction flows, and the transaction flow corresponds to the serial number one by one;
In order to avoid storing redundant transaction data, in an optional implementation manner, the target transaction data set at least includes the transaction data collected by the front end from a second target transaction data file, where the second target transaction data file is a file formed by filling a second preset template with user information and service information related to the target transaction flow.
In the above embodiment, for the key transaction data, such as the key user information and the key business information, which need to be recorded in the insurance backtracking process, a second preset template is designed at the front end, and in the transaction process, the customer fills the user information, such as the name, the identification card number, and the business information, such as the type of the purchased financial product, in the second preset template to form a second target transaction data file, and the front end only collects the transaction data in the second target transaction data file, that is, the front end only collects the key transaction data, which need to be recorded in the insurance backtracking process, that is, the first database only stores the key transaction data, which need to be recorded in the insurance backtracking process, so that the storage of redundant transaction data is avoided.
In order to correlate transaction data together in the same transaction flow, in an alternative embodiment, the apparatus further comprises:
A generating unit, configured to generate the first identification information according to the target transaction request when it is detected that the front end receives the target transaction request;
and the transmission unit is used for transmitting the first identification information to the front end so that the front end adopts the first identification information to identify the target transaction data set acquired by the front end in the target transaction flow.
In the above embodiment, as shown in fig. 2, before the front end receives the target transaction request, the monitoring component button is pre-embedded in the front end to monitor the target transaction request from the client, and once the front end receives the target transaction request from the client, the front end sends the target transaction request to the back end through the back end service interface, the back end generates globally unique first identification information for the target transaction request and sends the globally unique first identification information to the front end through the back end service interface, and the front end adopts the first identification information to identify all target transaction data sets in the target transaction flow, and connects in series the transaction data of the whole target transaction flow through the unique first identification information, that is, the irrelevant point-shaped transaction data in the target transaction flow is opened through the unique first identification information.
Optionally, the specific process of receiving the target transaction data set from the front end and storing the target transaction data set in the first database is not limited, and any feasible manner falls within the scope of protection of the present application.
In an alternative embodiment, the receiving unit includes:
the receiving module is used for receiving a target message from the front end, wherein the content of the target message is the target transaction data set;
the analysis module is used for analyzing the target message to obtain the target transaction data set, and storing the target transaction data set in the first database.
In the above embodiment, the front end collects the transaction data in the second target transaction data file to obtain the target transaction data set, and then packages the target transaction data set into the target message, as shown in fig. 2, the front end transmits the target message to the back end through the back end service interface, and after the back end analyzes the target message to obtain the target transaction data set, the target transaction data set is stored in the first database, so that the front end critical transaction data is migrated to the first database.
A determining unit 20, configured to determine whether the target transaction data set carries second identification information, where the second identification information is a payment bill number corresponding to the target transaction flow, and the payment bill number corresponds to the transaction flow one by one;
The transaction flow is a financial product purchasing process, and there is a situation that a customer may only temporarily browse a financial product and does not pay fees, but only need to trace transaction data related to the transaction flow for completing a payment link in a security tracing process, and does not need to trace temporary browsing data, so that second identification information, namely a payment list number, is designed as a key index to distinguish purchasing financial product data from temporary browsing data, and when a target transaction data set carries the second identification information, it is determined that the transaction flow completes the payment link, and final recording is needed for the transaction data related to the target transaction flow.
A migration unit 30, configured to migrate all the target transaction data sets from the first database to the second database when any one of the target transaction data sets carries the second identification information;
the first database is used for storing temporary browsing data of clients, the second database is used for storing data of purchasing financial products, as shown in fig. 2, a trigger is arranged on the first database, the trigger monitors whether key indexes are generated, namely, a target transaction data set carries second identification information, when the target transaction data set carries the second identification information, it is determined that the transaction process finishes a payment link, final recording is needed for transaction data related to the transaction process, and at the moment, the target transaction data set is migrated from the first database to the second database.
In order to further reduce the storage of redundant transaction data, in another alternative embodiment, the apparatus further comprises:
the acquisition unit is used for acquiring target warehousing time, wherein the target warehousing time is the time when the target transaction data set enters the first database;
the calculating unit is used for calculating the difference value between the current time and the warehouse-in time to obtain storage time and determining whether the storage time is larger than preset time or not;
and a deleting unit configured to delete all the target transaction data sets in the first database when the storage time is longer than the preset time.
In the above embodiment, a timer is provided on the first database, and the timer is used for determining the storage time of the target transaction data set in the first database, when the storage time is greater than the preset time, it can be determined that the transaction data in the target transaction data set is temporary browsing data, and the customer does not purchase a financial product, at this time, all the target transaction data sets in the target transaction process are deleted to complete the cleaning of the redundant transaction data, and further reduce the storage of the redundant transaction data.
Optionally, the present application is not limited to a specific process of migrating all the target transaction data sets from the first database to the second database, and any feasible manner falls within the scope of protection of the present application.
In an alternative embodiment, the migration unit includes:
the extraction module is used for extracting all the target transaction data sets from the first database according to the first identification information;
and the storage module is used for storing all the extracted target transaction data sets into the second database.
In the above embodiment, the front end adopts the first identification information to identify all the target transaction data sets in the target transaction flow, so that not only is the transaction data of the whole target transaction flow connected in series, but also the transaction data of the target transaction flow is integrally migrated from the first database to the second database according to the first identification information, and the transaction data migration efficiency is improved.
And a sending unit 40, configured to send, to the query system, all the target transaction data sets in the second database when receiving a target query request from the query system, where the target query request is a query request corresponding to the target transaction flow, and the query request corresponds to the transaction flow one by one.
Optionally, the specific process of sending all the target transaction data sets in the second database to the query system is not limited, and any feasible manner falls within the scope of protection of the present application.
In an alternative embodiment, the target transaction data set includes a plurality of the transaction data, and the transmitting unit includes:
the calling module is used for calling all the target transaction data sets from the second database according to the first identification information;
the filling module is used for filling all the transaction data of the target transaction data set into a first preset template to obtain a first target transaction data file;
and the sending module is used for sending the first target transaction data file to the query system.
In the above embodiment, the inquiry system is a certification system, and the silver-insurance prison inquires the transaction data related to the target transaction flow through the certification system, and when the certification system receives the target inquiry request, the target transaction data set is called out from the second database and filled into the first preset template, and the first preset template and the second preset template are generally the same template, so as to realize the return display of the transaction data related to the target transaction flow in the certification system, thereby realizing the tracing of the transaction data.
In the data tracing device of the transaction data, a receiving unit is configured to receive a target transaction data set from the front end when the front end is detected to open a target transaction flow, and store the target transaction data set in the first database, where the target transaction data set is a transaction data set carrying first identification information, the first identification information is a serial number corresponding to the target transaction flow, the target transaction flow is any one of transaction flows, and the transaction flow is in one-to-one correspondence with the serial number; the determining unit is used for determining whether the target transaction data set carries second identification information, wherein the second identification information is a payment bill number corresponding to the target transaction flow, and the payment bill number corresponds to the transaction flow one by one; a migration unit, configured to migrate all the target transaction data sets from the first database to the second database when any one of the target transaction data sets carries the second identification information; and the sending unit is used for sending all the target transaction data sets in the second database to the query system under the condition of receiving a target query request from the query system, wherein the target query request is a query request corresponding to the target transaction flow, and the query request corresponds to the transaction flow one by one. Under the condition that the front end starts the target transaction flow, the device stores a target transaction data set in the target transaction flow in a first database, the first database is a temporary database, under the condition that any one target transaction data set is determined to carry second identification information, the fact that the target transaction flow has completed a payment link is determined, at this time, all the target transaction data sets in the first database are migrated to a second database, the second database is used for storing transaction data related to the transaction flow for completing the payment link, when a target query request of a query system is received, the target transaction data set in the second database is sent to the query system, the query system can check all the transaction data related to the target transaction flow, thereby completing data of all the transaction data related to the target transaction flow, only transaction data related to the transaction flow for completing the payment link need to be traced in the transaction data supervision process.
The data tracing device for the transaction data comprises a processor and a memory, wherein the receiving unit, the determining unit, the migration unit, the sending unit and the like are all stored in the memory as program units, and the processor executes the program units stored in the memory to realize corresponding functions.
The processor includes a kernel, and the kernel fetches the corresponding program unit from the memory. The kernel can be provided with one or more than one kernel, and the problem of low transaction data backtracking efficiency caused by searching target transaction data in redundant transaction data in the prior art is solved by adjusting kernel parameters.
The memory may include volatile memory, random Access Memory (RAM), and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM), among other forms in computer readable media, the memory including at least one memory chip.
The embodiment of the application provides the computer readable storage medium comprising a stored program, wherein when the program is executed by a processor, the processor executes the data tracing method of the transaction data.
The embodiment of the application provides a data tracing system of transaction data, which comprises the following steps: the system comprises one or more processors, a memory, and one or more programs, wherein the one or more programs are stored in the memory and configured to be executed by the one or more processors, and the one or more programs comprise a data trace back system for executing the transaction data.
The embodiment of the application provides equipment, which comprises a processor, a memory and a program stored on the memory and capable of running on the processor, wherein the processor executes the program to realize at least the following steps:
step S101, when the front end opening target transaction flow is detected, a target transaction data set from the front end is received and stored in the first database, wherein the target transaction data set is a transaction data set carrying first identification information, the first identification information is a serial number corresponding to the target transaction flow, the target transaction flow is any one of transaction flows, and the transaction flow is in one-to-one correspondence with the serial number;
step S102, determining whether the target transaction data set carries second identification information, wherein the second identification information is a payment bill number corresponding to the target transaction flow, and the payment bill number corresponds to the transaction flow one by one;
step S103, when any one of the target transaction data sets carries the second identification information, all the target transaction data sets are migrated from the first database to the second database;
Step S104, when a target query request from the query system is received, all the target transaction data sets in the second database are sent to the query system, wherein the target query request is a query request corresponding to the target transaction flow, and the query request corresponds to the transaction flow one by one.
The device herein may be a server, PC, PAD, cell phone, etc.
The present application also provides a computer program product adapted to perform a program initialized with at least the following method steps when executed on a data processing device:
step S101, when the front end opening target transaction flow is detected, a target transaction data set from the front end is received and stored in the first database, wherein the target transaction data set is a transaction data set carrying first identification information, the first identification information is a serial number corresponding to the target transaction flow, the target transaction flow is any one of transaction flows, and the transaction flow is in one-to-one correspondence with the serial number;
step S102, determining whether the target transaction data set carries second identification information, wherein the second identification information is a payment bill number corresponding to the target transaction flow, and the payment bill number corresponds to the transaction flow one by one;
Step S103, when any one of the target transaction data sets carries the second identification information, all the target transaction data sets are migrated from the first database to the second database;
step S104, when a target query request from the query system is received, all the target transaction data sets in the second database are sent to the query system, wherein the target query request is a query request corresponding to the target transaction flow, and the query request corresponds to the transaction flow one by one.
In the foregoing embodiments of the present application, the descriptions of the embodiments are emphasized, and for a portion of this disclosure that is not described in detail in this embodiment, reference is made to the related descriptions of other embodiments.
In the several embodiments provided in the present application, it should be understood that the disclosed technology content may be implemented in other manners. The above-described embodiments of the apparatus are merely exemplary, and the division of the units may be a logic function division, and there may be another division manner when actually implemented, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be through some interfaces, units or modules, or may be in electrical or other forms.
The units described above as separate components may or may not be physically separate, and components shown as units may or may not be physical units, may be located in one place, or may be distributed over a plurality of units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in each embodiment of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units described above, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer-readable storage medium. Based on such understanding, the technical solution of the present application may be embodied essentially or in part or all of the technical solution that contributes to the prior art, or in the form of a software product, which is stored in a computer readable storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server or a network device, etc.) to perform all or part of the steps of the above-mentioned method of the various embodiments of the present application. And the aforementioned computer-readable storage medium includes: a U-disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a removable hard disk, a magnetic disk, or an optical disk, or other various media capable of storing program codes.
From the above description, it can be seen that the above embodiments of the present application achieve the following technical effects:
1) In the data tracing method of the transaction data, firstly, under the condition that the front end is detected to start a target transaction flow, a target transaction data set from the front end is received, the target transaction data set is stored in the first database, the target transaction data set is a transaction data set carrying first identification information, the first identification information is a serial number corresponding to the target transaction flow, the target transaction flow is any one of transaction flows, and the transaction flow and the serial number are in one-to-one correspondence; then, determining whether the target transaction data set carries second identification information, wherein the second identification information is a payment bill number corresponding to the target transaction flow, and the payment bill number corresponds to the transaction flow one by one; then, if any one of the target transaction data sets carries the second identification information, all the target transaction data sets are migrated from the first database to the second database; and finally, under the condition that a target query request from the query system is received, all the target transaction data sets in the second database are sent to the query system, wherein the target query request is a query request corresponding to the target transaction flow, and the query request corresponds to the transaction flow one by one. Under the condition that the front end starts the target transaction flow, the target transaction data set in the target transaction flow is stored in the first database, the first database is a temporary database, under the condition that any one target transaction data set is determined to carry second identification information, the target transaction flow is determined to have completed a payment link, at the moment, all the target transaction data sets in the first database are migrated to the second database, the second database is used for storing transaction data related to the transaction flow for completing the payment link, under the condition that a target query request of a query system is received, the target transaction data set in the second database is sent to the query system, the query system can check all the transaction data related to the target transaction flow, thereby completing the data of all the transaction data related to the target transaction flow, only the transaction data related to the payment link need to be traced in the transaction data supervision process.
2) In the data tracing device of transaction data of the application, the receiving unit is used for receiving a target transaction data set from the front end and storing the target transaction data set into the first database when the front end is detected to open a target transaction flow, wherein the target transaction data set is a transaction data set carrying first identification information, the first identification information is a serial number corresponding to the target transaction flow, the target transaction flow is any one of transaction flows, and the transaction flow and the serial number are in one-to-one correspondence; the determining unit is used for determining whether the target transaction data set carries second identification information, wherein the second identification information is a payment bill number corresponding to the target transaction flow, and the payment bill number corresponds to the transaction flow one by one; a migration unit, configured to migrate all the target transaction data sets from the first database to the second database when any one of the target transaction data sets carries the second identification information; and the sending unit is used for sending all the target transaction data sets in the second database to the query system under the condition of receiving a target query request from the query system, wherein the target query request is a query request corresponding to the target transaction flow, and the query request corresponds to the transaction flow one by one. Under the condition that the front end starts the target transaction flow, the device stores a target transaction data set in the target transaction flow in a first database, the first database is a temporary database, under the condition that any one target transaction data set is determined to carry second identification information, the fact that the target transaction flow has completed a payment link is determined, at this time, all the target transaction data sets in the first database are migrated to a second database, the second database is used for storing transaction data related to the transaction flow for completing the payment link, when a target query request of a query system is received, the target transaction data set in the second database is sent to the query system, the query system can check all the transaction data related to the target transaction flow, thereby completing data of all the transaction data related to the target transaction flow, only transaction data related to the transaction flow for completing the payment link need to be traced in the transaction data supervision process.
3) The data tracing system of the transaction data of the application comprises: the system comprises one or more processors, a memory, and one or more programs, wherein the one or more programs are stored in the memory and configured to be executed by the one or more processors, and the one or more programs comprise a data trace back system for executing the transaction data. Under the condition that the front end starts the target transaction flow, the system stores a target transaction data set in the target transaction flow in a first database, the first database is a temporary database, under the condition that any one target transaction data set is determined to carry second identification information, the system determines that the target transaction flow has completed a payment link, at this time, all target transaction data sets in the first database are migrated to a second database, the second database is used for storing transaction data related to the transaction flow for completing the payment link, under the condition that a target query request of a query system is received, the target transaction data set in the second database is sent to the query system, the query system can check all transaction data related to the target transaction flow, thereby completing the data of all transaction data related to the target transaction flow, only the transaction data related to the payment link need to be traced in the transaction data supervision process, the system stores the temporary transaction data in the first database based on whether the second identification information is carried, only the transaction data related to the transaction flow is stored in the second database, the transaction data related to the transaction flow of the transaction flow is completed, the transaction efficiency is reduced when the target transaction data related to the transaction flow is traced back, and the transaction data related to the transaction data is found in the prior art, and the transaction efficiency is low, and the problem related to the transaction data is solved.
The foregoing description is only of the preferred embodiments of the present application and is not intended to limit the same, but rather, various modifications and variations may be made by those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principles of the present application should be included in the protection scope of the present application.
Claims (10)
1. The data tracing method of transaction data is characterized in that the data tracing method is applied to a rear end, the front end is in communication connection with the rear end, a query system is in communication connection with the rear end, the query system is used for querying the transaction data, the rear end is in communication connection with a first database and a second database respectively, and the method comprises the following steps:
under the condition that the front end is detected to start a target transaction flow, receiving a target transaction data set from the front end, and storing the target transaction data set into the first database, wherein the target transaction data set is a transaction data set carrying first identification information, the first identification information is a serial number corresponding to the target transaction flow, the target transaction flow is any one of transaction flows, and the transaction flows are in one-to-one correspondence to the serial number;
Determining whether the target transaction data set carries second identification information, wherein the second identification information is a payment bill number corresponding to the target transaction flow, and the payment bill number corresponds to the transaction flow one by one;
migrating all the target transaction data sets from the first database to the second database under the condition that any one of the target transaction data sets carries the second identification information;
and under the condition that a target query request from the query system is received, all target transaction data sets in the second database are sent to the query system, wherein the target query request is a query request corresponding to the target transaction flow, and the query request corresponds to the transaction flow one by one.
2. The method of claim 1, wherein prior to receiving a target transaction data set from the front end and storing the target transaction data set in the first database, the method further comprises:
generating the first identification information according to the target transaction request under the condition that the front end receives the target transaction request;
And sending the first identification information to the front end, so that the front end adopts the first identification information to identify the target transaction data set acquired by the front end in the target transaction flow.
3. The method of claim 1, wherein receiving a target transaction data set from the front end and storing the target transaction data set in the first database comprises:
receiving a target message from the front end, wherein the content of the target message is the target transaction data set;
analyzing the target message to obtain the target transaction data set, and storing the target transaction data set in the first database.
4. The method of claim 1, wherein prior to migrating all of the target transaction data sets from the first database into the second database, the method further comprises:
acquiring target warehousing time, wherein the target warehousing time is the time when the target transaction data set enters the first database;
calculating the difference between the current time and the warehouse-in time to obtain storage time, and determining whether the storage time is greater than a preset time;
And deleting all the target transaction data sets in the first database under the condition that the storage time is longer than the preset time.
5. The method of any one of claims 1 to 4, wherein migrating all of the target transaction data sets from the first database into the second database comprises:
extracting all target transaction data sets from the first database according to the first identification information;
and storing all the extracted target transaction data sets into the second database.
6. The method of claim 1, wherein the target transaction data set includes a plurality of the transaction data, and wherein transmitting all of the target transaction data sets in the second database to the query system comprises:
calling all target transaction data sets from the second database according to the first identification information;
filling all the transaction data of the target transaction data set into a first preset template to obtain a first target transaction data file;
and sending the first target transaction data file to the query system.
7. The method of claim 1, wherein the target transaction data set includes at least the transaction data collected by the front end from a second target transaction data file, the second target transaction data file being a file formed by filling a second preset template with user information and business information related to the target transaction process.
8. The utility model provides a data traceability device of transaction data, its characterized in that, data traceability device is applied to the rear end, the front end with rear end communication connection, query system is used for querying transaction data, the rear end is connected with first database and second database communication respectively, the device includes:
the receiving unit is used for receiving a target transaction data set from the front end under the condition that the front end is detected to open a target transaction flow, and storing the target transaction data set into the first database, wherein the target transaction data set is a transaction data set carrying first identification information, the first identification information is a serial number corresponding to the target transaction flow, the target transaction flow is any one of transaction flows, and the transaction flow is in one-to-one correspondence with the serial number;
The determining unit is used for determining whether the target transaction data set carries second identification information or not, wherein the second identification information is a payment bill number corresponding to the target transaction flow, and the payment bill number corresponds to the transaction flow one by one;
a migration unit, configured to migrate all the target transaction data sets from the first database to the second database when any one of the target transaction data sets carries the second identification information;
and the sending unit is used for sending all the target transaction data sets in the second database to the query system under the condition of receiving a target query request from the query system, wherein the target query request is a query request corresponding to the target transaction flow, and the query request corresponds to the transaction flow one by one.
9. A computer-readable storage medium, characterized in that the computer-readable storage medium comprises a stored program, wherein the program, when executed by a processor, performs the data trace-back method of transaction data according to any one of claims 1 to 7.
10. A data trace back system for transaction data, comprising: one or more processors, a memory, a display device, and one or more programs, wherein the one or more programs are stored in the memory and configured to be executed by the one or more processors, the one or more programs comprising a data trace back method for performing the transaction data of any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211676779.XA CN116049138A (en) | 2022-12-26 | 2022-12-26 | Transaction data tracing method, tracing device and tracing system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211676779.XA CN116049138A (en) | 2022-12-26 | 2022-12-26 | Transaction data tracing method, tracing device and tracing system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116049138A true CN116049138A (en) | 2023-05-02 |
Family
ID=86124774
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211676779.XA Pending CN116049138A (en) | 2022-12-26 | 2022-12-26 | Transaction data tracing method, tracing device and tracing system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116049138A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116629718A (en) * | 2023-07-24 | 2023-08-22 | 清华四川能源互联网研究院 | Industrial data backtracking method and device, electronic equipment and storage medium |
-
2022
- 2022-12-26 CN CN202211676779.XA patent/CN116049138A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116629718A (en) * | 2023-07-24 | 2023-08-22 | 清华四川能源互联网研究院 | Industrial data backtracking method and device, electronic equipment and storage medium |
| CN116629718B (en) * | 2023-07-24 | 2023-09-29 | 清华四川能源互联网研究院 | Industrial data backtracking method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| USRE47896E1 (en) | System and method for tracking web interactions with real time analytics | |
| CN101222348B (en) | Method and system for calculating number of website real user | |
| EP2748781B1 (en) | Multi-factor identity fingerprinting with user behavior | |
| US20160134716A1 (en) | Method and system for collecting and providing application usage analytics | |
| CN106295382B (en) | A kind of Information Risk preventing control method and device | |
| CA2990101A1 (en) | Systems and methods for detecting resources responsible for events | |
| CN110442712B (en) | Risk determination method, risk determination device, server and text examination system | |
| CN101345751B (en) | Identifying application user as source of database activity | |
| CN106981017A (en) | A kind of big data precision marketing device and marketing method based on face recognition technology | |
| US8301506B2 (en) | Method and system for managing categories of an electronic commerce website | |
| CN104182900A (en) | Business data processing method, device and system | |
| CN112348005A (en) | Double-record auditing method and device, client equipment and storage medium | |
| CN106096926B (en) | Event processing method, device, electronic device and storage medium | |
| CN112492533A (en) | 5G rich media message pushing method and device based on block chain technology | |
| CN112561565A (en) | User demand identification method based on behavior log | |
| CN116049138A (en) | Transaction data tracing method, tracing device and tracing system | |
| CN114840527A (en) | Data processing method, device and computer readable storage medium | |
| CN114895879B (en) | Management system design scheme determining method, device, equipment and storage medium | |
| CN111144987A (en) | Abnormal shopping behavior limiting method, limiting assembly and shopping system | |
| CN107294766B (en) | Centralized control method and system | |
| CN110020166A (en) | A kind of data analysing method and relevant device | |
| CN108364219A (en) | A kind of single monitoring method of record and terminal | |
| CN114170741A (en) | Transaction efficiency monitoring method, ATM front-end system and self-service business control and management system | |
| CN108073638A (en) | Data diagnosis method and device | |
| CN114168632A (en) | Abnormal data identification method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |