CN117725270A - Financial data processing query method, device, medium and computing equipment - Google Patents
Financial data processing query method, device, medium and computing equipment Download PDFInfo
- Publication number
- CN117725270A CN117725270A CN202311723707.0A CN202311723707A CN117725270A CN 117725270 A CN117725270 A CN 117725270A CN 202311723707 A CN202311723707 A CN 202311723707A CN 117725270 A CN117725270 A CN 117725270A
- Authority
- CN
- China
- Prior art keywords
- query
- financial data
- data processing
- data
- request
- 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
- 238000012545 processing Methods 0.000 title claims abstract description 204
- 238000000034 method Methods 0.000 title claims abstract description 46
- 238000012795 verification Methods 0.000 claims abstract description 82
- 238000006243 chemical reaction Methods 0.000 claims description 8
- 230000004044 response Effects 0.000 claims description 8
- 238000004590 computer program Methods 0.000 claims description 5
- 238000004806 packaging method and process Methods 0.000 claims description 4
- 238000007781 pre-processing Methods 0.000 claims description 4
- 230000000875 corresponding effect Effects 0.000 description 14
- 238000004364 calculation method Methods 0.000 description 10
- 230000008569 process Effects 0.000 description 9
- 230000010354 integration Effects 0.000 description 8
- 238000005192 partition Methods 0.000 description 8
- 230000003287 optical effect Effects 0.000 description 6
- 230000006870 function Effects 0.000 description 5
- 238000004891 communication Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 238000000638 solvent extraction Methods 0.000 description 4
- 230000001960 triggered effect Effects 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000002596 correlated effect Effects 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000013507 mapping Methods 0.000 description 2
- 230000009467 reduction Effects 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 230000008859 change Effects 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Classifications
-
- 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
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a financial data processing query method, a device, a medium and a computing device, which comprise the following steps: receiving a financial data processing query request; the financial data processing inquiry request carries data request inquiry time and data request inquiry user information; carrying out security check on the data request inquiry time and the data request inquiry user information to obtain a security check result; if the security check result is that the verification is passed, responding to the financial data processing inquiry request, and determining a target table in which target financial data is located; the target financial data is stored in association with the data request inquiry time and the data request inquiry user information; performing financial data processing inquiry in the target table to obtain a financial data processing inquiry result; and outputting the financial data processing query result. Therefore, the invention can improve the safety of the financial data processing inquiry and the data processing inquiry efficiency.
Description
Technical Field
The invention relates to the technical field of financial data processing, in particular to a financial data processing query method, a financial data processing query device, a financial data processing query medium and a financial data processing computing device.
Background
Currently, in the financial industry, related financial data is often required to be processed and queried when transacting financial business. For example, in the course of financial transactions, financial point of sale information such as quotation data, financial data, etc. needs to be queried in real time.
In practice, the current financial data processing query mode needs to be highly dependent on the data interface for importing, however, the data security hidden danger and the low data reading efficiency exist in the data interface importing process.
In view of the above problems, no effective solution has been proposed at present.
Disclosure of Invention
The embodiment of the invention provides a financial data processing query method, a financial data processing query device, a financial data processing query medium and a financial data processing query computing device, which can improve the security of financial data processing query and the data processing query efficiency.
According to an aspect of an embodiment of the present invention, there is provided a financial data processing query method including:
receiving a financial data processing query request; the financial data processing inquiry request carries data request inquiry time and data request inquiry user information;
Carrying out security check on the data request inquiry time and the data request inquiry user information to obtain a security check result;
if the security check result is that the verification is passed, responding to the financial data processing inquiry request, and determining a target table in which target financial data is located; the target financial data is stored in association with the data request inquiry time and the data request inquiry user information;
performing financial data processing inquiry in the target table to obtain a financial data processing inquiry result;
and outputting the financial data processing query result.
As an optional implementation manner, performing security check on the data request query time and the data request query user information to obtain a security check result, including:
performing security check on the data request inquiry time to obtain a first check result;
carrying out security check on the data request inquiring user information to obtain a second check result;
splicing the data request query time and the data request query user information to obtain a spliced character string, converting the spliced character string into a hash value, and performing security check on the hash value to obtain a third check result;
And obtaining the security check result based on the first check result, the second check result and the third check result.
As an alternative embodiment, the method further comprises:
and if the first verification result is verification passing, the second verification result is verification passing and the third verification result is verification passing, determining that the security verification result is verification passing.
As an optional implementation manner, performing a financial data processing query in the target table to obtain a financial data processing query result, including:
performing data preprocessing on various types of financial data in the target table to obtain preprocessed various types of financial data;
converting the preprocessed various types of financial data into binary sequence data;
packaging the binary sequence data into a universal query interface;
querying target data from the binary sequence data in response to a call operation to the universal query interface;
and determining binary pre-conversion data corresponding to the target data as the financial data processing query result.
As an alternative embodiment, the method further comprises:
Acquiring a query field set associated with the financial data processing query request;
determining a query relation network matched with the query field set and a query dimension;
and, in response to a call operation to the generic query interface, querying target data from the binary sequence data, comprising:
and responding to the calling operation of the general query interface, and querying the target data from the binary sequence data based on the query relation network and the query dimension.
According to another aspect of the embodiment of the present invention, there is also provided a financial data processing query device, including:
a request receiving unit for receiving a financial data processing inquiry request; the financial data processing inquiry request carries data request inquiry time and data request inquiry user information;
the verification unit is used for carrying out security verification on the data request inquiry time and the data request inquiry user information to obtain a security verification result;
the table determining unit is used for responding to the financial data processing inquiry request and determining a target table where target financial data is located if the security check result is that the security check result passes the check; the target financial data is stored in association with the data request inquiry time and the data request inquiry user information;
The data processing unit is used for carrying out financial data processing inquiry in the target table to obtain a financial data processing inquiry result;
and the result output unit is used for outputting the financial data processing query result.
As an alternative embodiment, the verification unit is specifically configured to:
performing security check on the data request inquiry time to obtain a first check result;
carrying out security check on the data request inquiring user information to obtain a second check result;
splicing the data request query time and the data request query user information to obtain a spliced character string, converting the spliced character string into a hash value, and performing security check on the hash value to obtain a third check result;
and obtaining the security check result based on the first check result, the second check result and the third check result.
As an alternative embodiment, the apparatus further comprises:
and the verification result determining unit is used for determining that the security verification result is verification passing if the first verification result is verification passing, the second verification result is verification passing and the third verification result is verification passing.
According to yet another aspect of an embodiment of the present invention, there is also provided a computing device including: at least one processor, memory, and input output unit; the memory is used for storing a computer program, and the processor is used for calling the computer program stored in the memory to execute the financial data processing query method.
According to yet another aspect of an embodiment of the present invention, there is also provided a computer-readable storage medium including instructions that, when executed on a computer, cause the computer to perform the above-described financial data processing query method.
In the embodiment of the invention, a financial data processing query request is received; the financial data processing inquiry request carries data request inquiry time and data request inquiry user information; carrying out security check on the data request inquiry time and the data request inquiry user information to obtain a security check result; if the security check result is that the verification is passed, responding to the financial data processing inquiry request, and determining a target table in which target financial data is located; the target financial data is stored in association with the data request inquiry time and the data request inquiry user information; performing financial data processing inquiry in the target table to obtain a financial data processing inquiry result; and outputting the financial data processing query result. Therefore, the invention can improve the safety of the financial data processing inquiry and the data processing inquiry efficiency.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiments of the invention and together with the description serve to explain the invention and do not constitute a limitation on the invention. In the drawings:
FIG. 1 is a flow chart of an alternative method of querying financial data processing according to an embodiment of the invention;
FIG. 2 is a schematic diagram of an alternative financial data processing query device, according to an embodiment of the present invention;
FIG. 3 schematically illustrates a schematic structural diagram of a medium according to an embodiment of the present invention;
FIG. 4 schematically illustrates a structural diagram of a computing device in accordance with embodiments of the present invention.
Detailed Description
In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and the claims of the present invention and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the invention described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Referring to fig. 1, fig. 1 is a flowchart of a financial data processing query method according to an embodiment of the invention. It should be noted that embodiments of the present invention may be applied to any scenario where applicable.
Fig. 1 shows a flow of a financial data processing query method according to an embodiment of the present invention, including:
Step S101, receiving a financial data processing inquiry request; the financial data processing query request carries data request query time and data request query user information.
In this embodiment, the execution body may be an electronic device such as a terminal device or a server.
The financial data processing query request is used for requesting query of various financial data pre-stored in the database, and can include direct query reading of the financial data, or data processing of the financial data, such as query reading after data classification. And, the financial data processing inquiry request can also carry the inquiry time of the data request and the inquiry user information of the data request. The data request query time may be a time when a financial data processing query request is issued, and the financial data processing query request may be triggered by man-machine interaction of related personnel. The data request query user information may be related information of the user who issues the financial data processing query request, and may include, but is not limited to, a user name, user authority configuration information, financial institution data associated with the user, and the like, which is not limited in this embodiment.
Step S102, carrying out security check on the data request query time and the data request query user information to obtain a security check result.
In this embodiment, after obtaining the data request query time and the data request query user information, the execution body may perform security check on the data request query time and the data request query user information to obtain a security check result. The security check result is that the check passes or the check fails.
Specifically, the execution body may verify the validity of the data request query time, match the data request query time with a preset valid data request query time, and if the data request query time is legal, determine that the validity verification of the data request query time passes. In addition, the execution body can also check the validity of the data request query user information, match the financial institution data associated with the user in the data request query user information with preset legal financial institution data, match the user authority configuration information with preset legal authority request data, and if the matching is successful, determine that the validity check of the data request query user information is passed.
Step S103, if the security check result is that the verification is passed, responding to the financial data processing inquiry request, and determining a target table in which target financial data is located; and storing the target financial data in association with the data request inquiry time and the data request inquiry user information.
In this embodiment, if the security check result is that the check is passed, a subsequent data processing query operation may be performed. Specifically, the financial data processing query request can be responded, the financial data type of the query requested by the financial data processing query request can be determined, and then the target table where the target financial data corresponding to the financial data type is located can be further determined. Wherein different financial data categories are stored using different table partitions. And, the target financial data can be stored in association with the data request inquiry time, the data request inquiry user information. The target financial data is the financial data which is requested to be inquired and processed by the user. For example, the target financial data may be some type of financial data statistics under the target financial business. When the financial data processing query request is triggered, the data query condition of the target financial data, the data request query time and the data request query user information can be stored in a correlated mode. In this case, preferably, in the process of performing the security check, the validity of the data processing query can be determined in combination with the data query condition of the target financial data, the data request query time, and the data request query user information. For example, in combination with the data query condition corresponding to the target financial data, whether the user has authority to view the financial data is judged, if not, illegal verification is determined, and the verification is not passed.
Wherein, for each financial business, the data types of various categories can be divided in advance. Data for the same financial service may be stored in the same partition. For the same financial business, and different types of data types, different tables may be stored in the same partition. By the data partitioning method for partitioning the table, the data processing query efficiency can be further improved in the data processing query process.
Step S104, performing financial data processing inquiry in the target table to obtain a financial data processing inquiry result.
In this embodiment, after determining the target table in which the target financial data to be queried is located, the executing body may directly obtain the target financial data to be queried from the target table, as a result of processing the query by the financial data.
Optionally, the executing body may directly acquire the target financial data to be queried in the target table, then integrate the target financial data, and use the integrated target financial data as the query result of the financial data processing. The integration process herein may include, but is not limited to, target value calculation, statistical table generation, predicted value calculation, etc., which is not limited in this embodiment.
As an optional implementation manner, performing the financial data processing query in the target table to obtain the financial data processing query result may include: acquiring original financial data from a target table; determining an integrated processing category for the raw financial data; if the integration processing category is target value calculation, calculating to obtain target financial data based on the original financial data and a preset calculation formula, wherein the target financial data is used as a financial data processing query result; if the integration processing category is generated by a statistical form, a financial data query form can be generated based on the original financial data and used as a financial data processing query result; if the integration processing category is the predicted value calculation, the target financial data can be predicted and obtained based on the original financial data and a pre-trained financial trend prediction model, and the target financial data can be used as a financial data processing query result.
Step S105, outputting the financial data processing query result.
As an optional implementation manner, performing security check on the data request query time and the data request query user information to obtain a security check result, including:
Performing security check on the data request inquiry time to obtain a first check result;
carrying out security check on the data request inquiring user information to obtain a second check result;
splicing the data request query time and the data request query user information to obtain a spliced character string, converting the spliced character string into a hash value, and performing security check on the hash value to obtain a third check result;
and obtaining the security check result based on the first check result, the second check result and the third check result.
In this embodiment, the execution body may match the data request query time with a preset legal query time, to obtain a first verification result. If the data request inquiry time falls into the preset legal inquiry time, determining that the first check result is the check passing. And the execution main body can also match the data request query user information with preset legal user information to obtain a second check result. If the data request inquiring user information is the preset legal user information, determining that the second checking result is the checking pass. If the information of the data request query user is not the preset legal user information, determining that the second checking result is that the checking is not passed. And the execution body can also convert the data request inquiry time into a standard time format, convert the data request inquiry user information into a standard user information format, and splice the standard time format and the standard user information format to obtain a spliced character string. And converting the spliced character strings into hash values, and carrying out security verification on the hash values. And if the hash value is matched with the preset legal hash value, determining that the third check result is passing. If the hash value is not matched with the preset legal hash value, determining that the third check result is that the check fails. And then, the execution body can integrate the first check result, the second check result and the third check result to obtain a final security check result.
As an alternative embodiment, the method further comprises:
and if the first verification result is verification passing, the second verification result is verification passing and the third verification result is verification passing, determining that the security verification result is verification passing.
In this embodiment, if the first check result is a check pass, the second check result is a check pass, and the third check result is a check pass, it is determined that the security check result is a check pass. And if any check result is that the check fails, determining that the security check result is that the check fails. And for the case that the security check result is that the check fails, the subsequent data processing query operation is not executed, and the security risk prompt information is output.
As an optional implementation manner, performing a financial data processing query in the target table to obtain a financial data processing query result, including:
performing data preprocessing on various types of financial data in the target table to obtain preprocessed various types of financial data;
converting the preprocessed various types of financial data into binary sequence data;
Packaging the binary sequence data into a universal query interface;
querying target data from the binary sequence data in response to a call operation to the universal query interface;
and determining binary pre-conversion data corresponding to the target data as the financial data processing query result.
In this embodiment, the executing body may perform binary conversion on each type of financial data of the same financial data category under the same financial service in the target table, to obtain binary sequence data. And packages the binary sequence data into a generic query interface. Based on the invocation of the generic query interface, the target data may be queried from the binary sequence data. The target data is in a binary form, so that the target data can be subjected to data reduction to obtain final target financial data, and the final target financial data is used as a financial data processing query result. By the implementation mode, binary conversion can be further introduced to perform financial data processing inquiry on the basis of the storage of the partition table, and the efficiency of the financial data processing inquiry is further improved.
As an alternative embodiment, the method further comprises:
Acquiring a query field set associated with the financial data processing query request;
determining a query relation network matched with the query field set and a query dimension;
and, in response to a call operation to the generic query interface, querying target data from the binary sequence data, comprising:
and responding to the calling operation of the general query interface, and querying the target data from the binary sequence data based on the query relation network and the query dimension.
In this embodiment, the executing entity may also obtain a set of query fields associated with the financial data processing query request. Wherein each query field in the set of query fields is used to indicate a data characteristic of the target financial data that the user needs to request a query. Wherein the number of query fields in the set of query fields is typically a plurality.
And, after obtaining the set of query fields, the executing body may further determine a query relationship net and a query dimension that match the set of query fields. Wherein the query relationship network is used for indicating the association network among the query fields. The execution body stores a total association network among the query fields in advance. After obtaining each query field in the query field set, network interception can be performed from the total associated network to obtain a query relationship network matched with the query field set. The query relation network is used for describing the association network among the query fields in the query field set. And, the executing body can also determine the query dimension of the financial data processing query based on each query field in the query field set, wherein the query dimension can comprise the query granularity of the financial data processing query and the financial data category of the query.
And the execution body can determine target data to be queried from the binary sequence data by calling the universal query interface according to query granularity for performing data processing query, financial data type of query and query relation network. Specifically, the execution body may establish a mapping relationship between binary sequence data and the query relationship network. And determining and obtaining binary sequence data corresponding to each query field node in the query relation network. And then, calculating the data intersection between binary sequence data corresponding to each query field node. And determining target data from binary sequence data corresponding to the data intersection according to query granularity of the financial data processing query and the type of the financial data.
In the embodiment of the invention, a financial data processing query request is received; the financial data processing inquiry request carries data request inquiry time and data request inquiry user information; carrying out security check on the data request inquiry time and the data request inquiry user information to obtain a security check result; if the security check result is that the verification is passed, responding to the financial data processing inquiry request, and determining a target table in which target financial data is located; the target financial data is stored in association with the data request inquiry time and the data request inquiry user information; performing financial data processing inquiry in the target table to obtain a financial data processing inquiry result; and outputting the financial data processing query result. Therefore, the invention can improve the safety of the financial data processing inquiry and the data processing inquiry efficiency.
Having described the method of an exemplary embodiment of the present invention, next, referring to fig. 2, a financial data processing query device of an exemplary embodiment of the present invention includes:
a request receiving unit 201 for receiving a financial data processing inquiry request; the financial data processing inquiry request carries data request inquiry time and data request inquiry user information;
a verification unit 202, configured to perform security verification on the data request query time and the data request query user information, to obtain a security verification result;
a table determining unit 203, configured to determine a target table in which target financial data is located, in response to the financial data processing query request if the security check result is that the security check result is passed; the target financial data is stored in association with the data request inquiry time and the data request inquiry user information;
a data processing unit 204, configured to perform a financial data processing query in the target table, so as to obtain a financial data processing query result;
and a result output unit 205, configured to output the financial data processing query result.
The financial data processing query request is used for requesting query of various financial data pre-stored in the database, and can include direct query reading of the financial data, or data processing of the financial data, such as query reading after data classification. And, the financial data processing inquiry request can also carry the inquiry time of the data request and the inquiry user information of the data request. The data request query time may be a time when a financial data processing query request is issued, and the financial data processing query request may be triggered by man-machine interaction of related personnel. The data request query user information may be related information of the user who issues the financial data processing query request, and may include, but is not limited to, a user name, user authority configuration information, financial institution data associated with the user, and the like, which is not limited in this embodiment.
In this embodiment, after obtaining the data request query time and the data request query user information, the execution body may perform security check on the data request query time and the data request query user information to obtain a security check result. The security check result is that the check passes or the check fails.
Specifically, the execution body may verify the validity of the data request query time, match the data request query time with a preset valid data request query time, and if the data request query time is legal, determine that the validity verification of the data request query time passes. In addition, the execution body can also check the validity of the data request query user information, match the financial institution data associated with the user in the data request query user information with preset legal financial institution data, match the user authority configuration information with preset legal authority request data, and if the matching is successful, determine that the validity check of the data request query user information is passed.
In this embodiment, if the security check result is that the check is passed, a subsequent data processing query operation may be performed. Specifically, the financial data processing query request can be responded, the financial data type of the query requested by the financial data processing query request can be determined, and then the target table where the target financial data corresponding to the financial data type is located can be further determined. Wherein different financial data categories are stored using different table partitions. And, the target financial data can be stored in association with the data request inquiry time, the data request inquiry user information. The target financial data is the financial data which is requested to be inquired and processed by the user. For example, the target financial data may be some type of financial data statistics under the target financial business. When the financial data processing query request is triggered, the data query condition of the target financial data, the data request query time and the data request query user information can be stored in a correlated mode. In this case, preferably, in the process of performing the security check, the validity of the data processing query can be determined in combination with the data query condition of the target financial data, the data request query time, and the data request query user information. For example, in combination with the data query condition corresponding to the target financial data, whether the user has authority to view the financial data is judged, if not, illegal verification is determined, and the verification is not passed.
Wherein, for each financial business, the data types of various categories can be divided in advance. Data for the same financial service may be stored in the same partition. For the same financial business, and different types of data types, different tables may be stored in the same partition. By the data partitioning method for partitioning the table, the data processing query efficiency can be further improved in the data processing query process.
In this embodiment, after determining the target table in which the target financial data to be queried is located, the executing body may directly obtain the target financial data to be queried from the target table, as a result of processing the query by the financial data.
Optionally, the executing body may directly acquire the target financial data to be queried in the target table, then integrate the target financial data, and use the integrated target financial data as the query result of the financial data processing. The integration process herein may include, but is not limited to, target value calculation, statistical table generation, predicted value calculation, etc., which is not limited in this embodiment.
As an optional implementation manner, performing the financial data processing query in the target table to obtain the financial data processing query result may include: acquiring original financial data from a target table; determining an integrated processing category for the raw financial data; if the integration processing category is target value calculation, calculating to obtain target financial data based on the original financial data and a preset calculation formula, wherein the target financial data is used as a financial data processing query result; if the integration processing category is generated by a statistical form, a financial data query form can be generated based on the original financial data and used as a financial data processing query result; if the integration processing category is the predicted value calculation, the target financial data can be predicted and obtained based on the original financial data and a pre-trained financial trend prediction model, and the target financial data can be used as a financial data processing query result.
As an alternative embodiment, the verification unit 202 is specifically configured to:
performing security check on the data request inquiry time to obtain a first check result;
carrying out security check on the data request inquiring user information to obtain a second check result;
splicing the data request query time and the data request query user information to obtain a spliced character string, converting the spliced character string into a hash value, and performing security check on the hash value to obtain a third check result;
and obtaining the security check result based on the first check result, the second check result and the third check result.
In this embodiment, the execution body may match the data request query time with a preset legal query time, to obtain a first verification result. If the data request inquiry time falls into the preset legal inquiry time, determining that the first check result is the check passing. And the execution main body can also match the data request query user information with preset legal user information to obtain a second check result. If the data request inquiring user information is the preset legal user information, determining that the second checking result is the checking pass. If the information of the data request query user is not the preset legal user information, determining that the second checking result is that the checking is not passed. And the execution body can also convert the data request inquiry time into a standard time format, convert the data request inquiry user information into a standard user information format, and splice the standard time format and the standard user information format to obtain a spliced character string. And converting the spliced character strings into hash values, and carrying out security verification on the hash values. And if the hash value is matched with the preset legal hash value, determining that the third check result is passing. If the hash value is not matched with the preset legal hash value, determining that the third check result is that the check fails. And then, the execution body can integrate the first check result, the second check result and the third check result to obtain a final security check result.
As an alternative embodiment, the apparatus further comprises:
and the verification result determining unit is used for determining that the security verification result is verification passing if the first verification result is verification passing, the second verification result is verification passing and the third verification result is verification passing.
In this embodiment, if the first check result is a check pass, the second check result is a check pass, and the third check result is a check pass, it is determined that the security check result is a check pass. And if any check result is that the check fails, determining that the security check result is that the check fails. And for the case that the security check result is that the check fails, the subsequent data processing query operation is not executed, and the security risk prompt information is output.
As an alternative embodiment, the data processing unit 204 is specifically configured to:
performing data preprocessing on various types of financial data in the target table to obtain preprocessed various types of financial data;
converting the preprocessed various types of financial data into binary sequence data;
packaging the binary sequence data into a universal query interface;
Querying target data from the binary sequence data in response to a call operation to the universal query interface;
and determining binary pre-conversion data corresponding to the target data as the financial data processing query result.
In this embodiment, the executing body may perform binary conversion on each type of financial data of the same financial data category under the same financial service in the target table, to obtain binary sequence data. And packages the binary sequence data into a generic query interface. Based on the invocation of the generic query interface, the target data may be queried from the binary sequence data. The target data is in a binary form, so that the target data can be subjected to data reduction to obtain final target financial data, and the final target financial data is used as a financial data processing query result. By the implementation mode, binary conversion can be further introduced to perform financial data processing inquiry on the basis of the storage of the partition table, and the efficiency of the financial data processing inquiry is further improved.
As an alternative embodiment, the apparatus further comprises:
the query parameter determining unit is used for acquiring a query field set associated with the financial data processing query request; determining a query relation network matched with the query field set and a query dimension;
And, the data processing unit 204 is specifically configured to:
and responding to the calling operation of the general query interface, and querying the target data from the binary sequence data based on the query relation network and the query dimension.
In this embodiment, the executing entity may also obtain a set of query fields associated with the financial data processing query request. Wherein each query field in the set of query fields is used to indicate a data characteristic of the target financial data that the user needs to request a query. Wherein the number of query fields in the set of query fields is typically a plurality.
And, after obtaining the set of query fields, the executing body may further determine a query relationship net and a query dimension that match the set of query fields. Wherein the query relationship network is used for indicating the association network among the query fields. The execution body stores a total association network among the query fields in advance. After obtaining each query field in the query field set, network interception can be performed from the total associated network to obtain a query relationship network matched with the query field set. The query relation network is used for describing the association network among the query fields in the query field set. And, the executing body can also determine the query dimension of the financial data processing query based on each query field in the query field set, wherein the query dimension can comprise the query granularity of the financial data processing query and the financial data category of the query.
And the execution body can determine target data to be queried from the binary sequence data by calling the universal query interface according to query granularity for performing data processing query, financial data type of query and query relation network. Specifically, the execution body may establish a mapping relationship between binary sequence data and the query relationship network. And determining and obtaining binary sequence data corresponding to each query field node in the query relation network. And then, calculating the data intersection between binary sequence data corresponding to each query field node. And determining target data from binary sequence data corresponding to the data intersection according to query granularity of the financial data processing query and the type of the financial data.
In the embodiment of the invention, a financial data processing query request is received; the financial data processing inquiry request carries data request inquiry time and data request inquiry user information; carrying out security check on the data request inquiry time and the data request inquiry user information to obtain a security check result; if the security check result is that the verification is passed, responding to the financial data processing inquiry request, and determining a target table in which target financial data is located; the target financial data is stored in association with the data request inquiry time and the data request inquiry user information; performing financial data processing inquiry in the target table to obtain a financial data processing inquiry result; and outputting the financial data processing query result. Therefore, the invention can improve the safety of the financial data processing inquiry and the data processing inquiry efficiency.
Having described the method and apparatus of the exemplary embodiments of the present invention, reference will now be made to FIG. 3 for an illustration of a computer readable storage medium of the exemplary embodiments of the present invention, and reference will now be made to FIG. 3 which shows a computer readable storage medium, an optical disc 30, having a computer program (i.e., program product) stored thereon that, when executed by a processor, performs the steps described in the above-described method embodiments, such as receiving a financial data processing query request; the financial data processing inquiry request carries data request inquiry time and data request inquiry user information; carrying out security check on the data request inquiry time and the data request inquiry user information to obtain a security check result; if the security check result is that the verification is passed, responding to the financial data processing inquiry request, and determining a target table in which target financial data is located; the target financial data is stored in association with the data request inquiry time and the data request inquiry user information; performing financial data processing inquiry in the target table to obtain a financial data processing inquiry result; outputting the financial data processing query result; the specific implementation of each step is not repeated here.
It should be noted that examples of the computer readable storage medium may also include, but are not limited to, a phase change memory (PRAM), a Static Random Access Memory (SRAM), a Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), a Read Only Memory (ROM), an Electrically Erasable Programmable Read Only Memory (EEPROM), a flash memory, or other optical or magnetic storage medium, which will not be described in detail herein.
Having described the methods, media, and apparatus of exemplary embodiments of the present invention, next, a computing device for financial data processing queries of exemplary embodiments of the present invention is described with reference to FIG. 4.
FIG. 4 illustrates a block diagram of an exemplary computing device 40 suitable for use in implementing embodiments of the invention, the computing device 40 may be a computer system or a server. The computing device 40 shown in fig. 4 is merely an example and should not be taken as limiting the functionality and scope of use of embodiments of the present invention.
As shown in fig. 4, components of computing device 40 may include, but are not limited to: one or more processors or processing units 401, a system memory 402, a bus 403 that connects the various system components (including the system memory 402 and the processing units 401).
Computing device 40 typically includes a variety of computer system readable media. Such media can be any available media that is accessible by computing device 40 and includes both volatile and nonvolatile media, removable and non-removable media.
The system memory 402 may include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM) 4021 and/or cache memory 4022. Computing device 40 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, ROM4023 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 4 and commonly referred to as a "hard disk drive"). Although not shown in fig. 4, a magnetic disk drive for reading from and writing to a removable non-volatile magnetic disk (e.g., a "floppy disk"), and an optical disk drive for reading from or writing to a removable non-volatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media), may be provided. In such cases, each drive may be coupled to bus 403 through one or more data medium interfaces. The system memory 402 may include at least one program product having a set (e.g., at least one) of program modules configured to carry out the functions of the embodiments of the invention.
A program/utility 4025 having a set (at least one) of program modules 4024 may be stored, for example, in system memory 402, and such program modules 4024 include, but are not limited to: an operating system, one or more application programs, other program modules, and program data, each or some combination of which may include an implementation of a network environment. Program modules 4024 generally perform the functions and/or methodologies of the described embodiments of the present invention.
Computing device 40 may also communicate with one or more external devices 404 (e.g., keyboard, pointing device, display, etc.). Such communication may occur through an input/output (I/O) interface 405. Moreover, computing device 40 may also communicate with one or more networks such as a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network, such as the Internet, through network adapter 406. As shown in fig. 4, network adapter 406 communicates with other modules of computing device 40, such as processing unit 401, etc., over bus 403. It should be appreciated that although not shown in fig. 4, other hardware and/or software modules may be used in connection with computing device 40.
The processing unit 401 executes various functional applications and data processing by running programs stored in the system memory 402, for example, receives a financial data processing inquiry request; the financial data processing inquiry request carries data request inquiry time and data request inquiry user information; carrying out security check on the data request inquiry time and the data request inquiry user information to obtain a security check result; if the security check result is that the verification is passed, responding to the financial data processing inquiry request, and determining a target table in which target financial data is located; the target financial data is stored in association with the data request inquiry time and the data request inquiry user information; performing financial data processing inquiry in the target table to obtain a financial data processing inquiry result; and outputting the financial data processing query result. The specific implementation of each step is not repeated here. It should be noted that although in the above detailed description several units/modules or sub-units/sub-modules of a financial data processing query device are mentioned, such a division is merely exemplary and not mandatory. Indeed, the features and functionality of two or more units/modules described above may be embodied in one unit/module in accordance with embodiments of the present invention. Conversely, the features and functions of one unit/module described above may be further divided into ones that are embodied by a plurality of units/modules.
In the description of the present invention, it should be noted that the terms "first," "second," and "third" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance.
It will be clear to those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described systems, apparatuses and units may refer to corresponding procedures in the foregoing method embodiments, and are not repeated herein.
In the several embodiments provided by the present invention, it should be understood that the disclosed systems, devices, and methods may be implemented in other manners. The above-described apparatus embodiments are merely illustrative, for example, the division of the units is merely a logical function division, and there may be other manners of division in actual implementation, and for example, multiple units or components may be combined or 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 communication interface, device or unit indirect coupling or communication connection, which may be in electrical, mechanical or other form.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in the embodiments of the present invention 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 functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a non-volatile computer readable storage medium executable by a processor. Based on this understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-only memory (ROM), a random access memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
Finally, it should be noted that: the above examples are only specific embodiments of the present invention, and are not intended to limit the scope of the present invention, but it should be understood by those skilled in the art that the present invention is not limited thereto, and that the present invention is described in detail with reference to the foregoing examples: any person skilled in the art may modify or easily conceive of the technical solution described in the foregoing embodiments, or perform equivalent substitution of some of the technical features, while remaining within the technical scope of the present disclosure; such modifications, changes or substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention, and are intended to be included in the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Furthermore, although the operations of the methods of the present invention are depicted in the drawings in a particular order, this is not required to either imply that the operations must be performed in that particular order or that all of the illustrated operations be performed to achieve desirable results. Additionally or alternatively, certain steps may be omitted, multiple steps combined into one step to perform, and/or one step decomposed into multiple steps to perform.
Claims (10)
1. A financial data processing query method, comprising:
receiving a financial data processing query request; the financial data processing inquiry request carries data request inquiry time and data request inquiry user information;
carrying out security check on the data request inquiry time and the data request inquiry user information to obtain a security check result;
if the security check result is that the verification is passed, responding to the financial data processing inquiry request, and determining a target table in which target financial data is located; the target financial data is stored in association with the data request inquiry time and the data request inquiry user information;
performing financial data processing inquiry in the target table to obtain a financial data processing inquiry result;
and outputting the financial data processing query result.
2. The financial data processing query method according to claim 1, wherein performing security check on the data request query time and the data request query user information to obtain a security check result, comprises:
performing security check on the data request inquiry time to obtain a first check result;
Carrying out security check on the data request inquiring user information to obtain a second check result;
splicing the data request query time and the data request query user information to obtain a spliced character string, converting the spliced character string into a hash value, and performing security check on the hash value to obtain a third check result;
and obtaining the security check result based on the first check result, the second check result and the third check result.
3. The financial data processing query method of claim 2, further comprising:
and if the first verification result is verification passing, the second verification result is verification passing and the third verification result is verification passing, determining that the security verification result is verification passing.
4. The method of claim 1, wherein performing a financial data processing query in the target table to obtain a financial data processing query result, comprises:
performing data preprocessing on various types of financial data in the target table to obtain preprocessed various types of financial data;
Converting the preprocessed various types of financial data into binary sequence data;
packaging the binary sequence data into a universal query interface;
querying target data from the binary sequence data in response to a call operation to the universal query interface;
and determining binary pre-conversion data corresponding to the target data as the financial data processing query result.
5. The financial data processing query method of claim 4, further comprising:
acquiring a query field set associated with the financial data processing query request;
determining a query relation network matched with the query field set and a query dimension;
and, in response to a call operation to the generic query interface, querying target data from the binary sequence data, comprising:
and responding to the calling operation of the general query interface, and querying the target data from the binary sequence data based on the query relation network and the query dimension.
6. A financial data processing inquiry apparatus, comprising:
a request receiving unit for receiving a financial data processing inquiry request; the financial data processing inquiry request carries data request inquiry time and data request inquiry user information;
The verification unit is used for carrying out security verification on the data request inquiry time and the data request inquiry user information to obtain a security verification result;
the table determining unit is used for responding to the financial data processing inquiry request and determining a target table where target financial data is located if the security check result is that the security check result passes the check; the target financial data is stored in association with the data request inquiry time and the data request inquiry user information;
the data processing unit is used for carrying out financial data processing inquiry in the target table to obtain a financial data processing inquiry result;
and the result output unit is used for outputting the financial data processing query result.
7. The financial data processing query device of claim 6, wherein the verification unit is specifically configured to:
performing security check on the data request inquiry time to obtain a first check result;
carrying out security check on the data request inquiring user information to obtain a second check result;
splicing the data request query time and the data request query user information to obtain a spliced character string, converting the spliced character string into a hash value, and performing security check on the hash value to obtain a third check result;
And obtaining the security check result based on the first check result, the second check result and the third check result.
8. The financial data processing query device of claim 7, wherein said device further comprises:
and the verification result determining unit is used for determining that the security verification result is verification passing if the first verification result is verification passing, the second verification result is verification passing and the third verification result is verification passing.
9. A computing device, the computing device comprising:
at least one processor, memory, and input output unit;
wherein the memory is for storing a computer program and the processor is for invoking the computer program stored in the memory to perform the method of any of claims 1-5.
10. A computer readable storage medium comprising instructions which, when run on a computer, cause the computer to perform the method of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311723707.0A CN117725270A (en) | 2023-12-15 | 2023-12-15 | Financial data processing query method, device, medium and computing equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311723707.0A CN117725270A (en) | 2023-12-15 | 2023-12-15 | Financial data processing query method, device, medium and computing equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117725270A true CN117725270A (en) | 2024-03-19 |
Family
ID=90201032
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311723707.0A Pending CN117725270A (en) | 2023-12-15 | 2023-12-15 | Financial data processing query method, device, medium and computing equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117725270A (en) |
-
2023
- 2023-12-15 CN CN202311723707.0A patent/CN117725270A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10509779B2 (en) | Self-cleaning token vault | |
| CN109474578B (en) | Message checking method, device, computer equipment and storage medium | |
| CN108595157B (en) | Block chain data processing method, device, equipment and storage medium | |
| CN111274045B (en) | Multi-platform docking method and device, computer equipment and readable storage medium | |
| JP2017514218A (en) | Running third-party applications | |
| US9513997B2 (en) | Test data management | |
| CN110851298B (en) | Abnormality analysis and processing method, electronic device and storage medium | |
| CN111242462B (en) | Data processing method and device, computer storage medium and electronic equipment | |
| CN114612103B (en) | Method, device, system, medium and electronic equipment for cross-block chain transaction | |
| CN112507212A (en) | Intelligent return visit method and device, electronic equipment and readable storage medium | |
| US20230014318A1 (en) | System and method using zero knowledge proofs for alert sharing | |
| CN114549068A (en) | Short link generation method, equipment, device and computer readable storage medium | |
| US11379191B2 (en) | Presentation oriented rules-based technical architecture display framework | |
| CN115080537A (en) | Multi-tenant data partitioning method, program product and electronic device | |
| CN112613288B (en) | Method, device, computer equipment and storage medium for generating bill | |
| CN109271564A (en) | Declaration form querying method and equipment | |
| CN110991992B (en) | Processing method and device of business process information, storage medium and electronic equipment | |
| CN112396315A (en) | Method, device, equipment and storage medium for distributing business money strategy | |
| CN117725270A (en) | Financial data processing query method, device, medium and computing equipment | |
| CN106528718B (en) | Method and apparatus for processing data from third party | |
| CN110555763A (en) | financial data processing method and device based on block chain | |
| CN106569791B (en) | Data object processing method and device | |
| US11768819B2 (en) | Data unblocking in application platforms | |
| CN113641362A (en) | Client portrait updating method, device, equipment and storage medium | |
| CN114240436A (en) | Electronic certificate verification and cancellation method and device, computer 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 |