CN115099922B - Financial data query method, system, readable storage medium and computer equipment - Google Patents
Financial data query method, system, readable storage medium and computer equipment Download PDFInfo
- Publication number
- CN115099922B CN115099922B CN202211037353.XA CN202211037353A CN115099922B CN 115099922 B CN115099922 B CN 115099922B CN 202211037353 A CN202211037353 A CN 202211037353A CN 115099922 B CN115099922 B CN 115099922B
- Authority
- CN
- China
- Prior art keywords
- query
- data
- financial
- title
- financial data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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
- G06F16/2455—Query execution
Abstract
The invention provides a financial data query method, a system, a readable storage medium and computer equipment, wherein the method comprises the following steps: acquiring a financial data query request sent by a user; checking the data title according to the current time to judge whether the data title is a time title or not; if the data title is the time title, taking the data title as the financial title; if the data title is not the time title, combining the current time and the data title to obtain a financial title; performing preliminary query based on the financial title and the target object to obtain a preliminary result; performing data screening on the financial data content based on the query weight rule to obtain a first financial data content; and inputting the first financial data content into the screened financial data report in the financial database to generate a financial query report. The invention ensures the efficiency of identifying and/or processing the financial data query request by the processor by carrying out multi-level analysis on the financial data query request, and reduces the risk of misjudgment and/or misprocessing.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a financial data query method, a system, a readable storage medium and computer equipment.
Background
With the rapid development of various enterprises, the requirement of financial informatization is continuously improved, the overall planning and processing requirements of various enterprises on financial data are higher and higher, and the rapid development and application of financial management software are greatly promoted.
When a user uses financial management software, the most common operation is to perform financial data query, the financial data query usually outputs a corresponding financial query result in a data table manner according to a query request input by the user, however, for the query request input by a financial professional, the financial management software can effectively identify, but for the query request input by a non-financial professional, the financial management software may have certain misjudgment and/or misprocessing risks in identification and processing, so that a certain error exists in the financial data query, and as the data amount of financial data increases, there are more influencing factors in the identification or processing process of the query request input by the non-financial staff, for example: non-financial terms, etc., which also results in increased processor burden during the query, affecting query efficiency.
Disclosure of Invention
Based on this, the present invention provides a method, a system, a readable storage medium and a computer device for querying financial data, so as to solve at least the deficiencies of the above technologies.
The invention provides a financial data query method, which is characterized by comprising the following steps:
the method comprises the steps of obtaining a financial data query request sent by a user, wherein the financial data query request comprises current time, a target object and at least one data title;
checking the data title according to the current time to judge whether the data title is a time title or not;
if the data title is a time title, taking the data title as a financial title;
if the data title is not the time title, combining the current time and the data title by using a preset combination rule to obtain a combined title, and taking the combined title as a financial title;
performing a preliminary query based on the financial title and the target object to obtain a corresponding preliminary result, wherein the preliminary result at least comprises financial data content;
acquiring a query weight rule corresponding to the financial data query request, and performing data screening on the financial data content based on the query weight rule to obtain first financial data content;
and acquiring the financial data type of the first financial data content, screening a financial data report corresponding to the financial data type and the target object from a financial database, and inputting the first financial data content into the financial data report to generate a financial query report.
Further, the step of obtaining the financial data query request sent by the user comprises:
acquiring a query request sent by a user through an equipment terminal, and extracting key information of the query request to obtain a plurality of corresponding key data;
and performing semantic recognition on each key data, and combining each key data based on the result of the semantic recognition to obtain a financial data query request.
Further, the step of obtaining the query weight rule corresponding to the financial data query request includes:
analyzing a plurality of query condition information in the financial data query request by using a data analysis rule, and calculating a priority coefficient and a weight value of each query condition information;
and constructing a query weight rule based on the priority coefficient of each piece of query condition information and the weight value of each piece of query condition information.
Further, the method further comprises:
when acquiring a query change request sent by the user, acquiring the change content of the query change request, and judging whether the change content is object change;
if the changed content is the object change, regenerating a financial data query request according to the changed content, and querying the financial data according to the regenerated financial data query request;
and if the change content is not the object change, performing secondary query on the primary result according to the change content to obtain a secondary query result based on the change content.
The invention also provides a financial data query system, which is characterized by comprising the following components:
the query request acquisition module is used for acquiring a financial data query request sent by a user, wherein the financial data query request comprises current time, a target object and at least one data title;
the data checking module is used for checking the data title according to the current time so as to judge whether the data title is a time title or not;
the first data processing module is used for taking the data title as a financial title if the data title is a time title;
the second data processing module is used for combining the current time and the data title by using a preset combination rule to obtain a combined title if the data title is not the time title, and taking the combined title as a financial title;
a preliminary query module, configured to perform a preliminary query based on the financial title and the target object to obtain a corresponding preliminary result, where the preliminary result at least includes financial data content;
the rule obtaining module is used for obtaining a query weight rule corresponding to the financial data query request and carrying out data screening on the financial data content based on the query weight rule to obtain a first financial data content;
and the report generation module is used for acquiring the financial data type of the first financial data content, screening the financial data report corresponding to the financial data type and the target object in a financial database, and inputting the first financial data content into the financial data report so as to generate a financial query report.
Further, the query request obtaining module includes:
the device comprises a key information extraction unit, a key information extraction unit and a data processing unit, wherein the key information extraction unit is used for acquiring a query request sent by a user through a device terminal and extracting key information of the query request to obtain a plurality of corresponding key data;
and the data combination unit is used for performing semantic recognition on each piece of key data and combining each piece of key data based on the result of the semantic recognition to obtain the financial data query request.
Further, the rule obtaining module includes:
the condition analysis unit is used for analyzing a plurality of query condition information in the financial data query request by using a data analysis rule and calculating a priority coefficient and a weight value of each query condition information;
and the rule construction unit is used for constructing a query weight rule based on the priority coefficient of each query condition information and the weight value of each query condition information.
Further, the system further comprises:
the query change module is used for acquiring the change content of the query change request and judging whether the change content is the object change or not when the query change request sent by the user is acquired;
the request generation module is used for regenerating a financial data query request according to the changed content if the changed content is the object change, and querying financial data according to the regenerated financial data query request;
and the secondary query module is used for carrying out secondary query on the primary result according to the change content if the change content is not the object change, so as to obtain a secondary query result based on the change content.
The present invention also proposes a readable storage medium, on which a computer program is stored, which, when executed by a processor, implements the above-mentioned financial data query method.
The invention also provides a computer device, which comprises a memory, a processor and a computer program stored in the memory and capable of running on the processor, wherein the processor executes the computer program to realize the financial data query method.
According to the financial data query method, the financial data query system, the readable storage medium and the computer equipment, the financial data query request is subjected to multi-level analysis, so that the efficiency of identifying and/or processing the financial data query request by a processor is ensured, the risk of misjudgment and/or misprocessing is reduced, and specifically, a data title is verified to reduce the risk of query abnormity caused by data title error; data screening is carried out on financial data contents through preliminary query and query weight rules, so that query results obtained through financial data query can better meet user requirements, and the problem that the query results are abnormal due to the fact that a plurality of influences exist in query requests input by non-financial personnel is avoided.
Drawings
FIG. 1 is a flow chart of a financial data query method according to a first embodiment of the present invention;
FIG. 2 is a detailed flowchart of step S101 in FIG. 1;
FIG. 3 is a detailed flowchart of step S106 in FIG. 1;
FIG. 4 is a flowchart of a financial data query method according to a second embodiment of the present invention;
FIG. 5 is a block diagram of a financial data query system according to a third embodiment of the present invention;
fig. 6 is a block diagram showing a configuration of a computer apparatus according to a fourth embodiment of the present invention.
The following detailed description will further illustrate the invention in conjunction with the above-described figures.
Detailed Description
To facilitate an understanding of the invention, the invention will now be described more fully hereinafter with reference to the accompanying drawings. Several embodiments of the invention are shown in the drawings. This invention may, however, be embodied in many different forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete.
It will be understood that when an element is referred to as being "secured to" another element, it can be directly on the other element or intervening elements may also be present. When an element is referred to as being "connected" to another element, it can be directly connected to the other element or intervening elements may also be present. The terms "vertical," "horizontal," "left," "right," and the like as used herein are for illustrative purposes only.
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 invention belongs. The terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used herein, the term "and/or" includes any and all combinations of one or more of the associated listed items.
Example one
Referring to fig. 1, a financial data query method according to a first embodiment of the present invention is shown, where the financial data query method specifically includes steps S101 to S107:
s101, acquiring a financial data query request sent by a user, wherein the financial data query request comprises current time, a target object and at least one data title;
further, referring to fig. 2, the step S101 specifically includes steps S1011 to S1012:
s1011, acquiring a query request sent by a user through an equipment terminal, and extracting key information of the query request to obtain a plurality of corresponding key data;
s1012, performing semantic recognition on each key data, and combining each key data based on the result of the semantic recognition to obtain a financial data query request.
In specific implementation, the device terminal may be a mobile phone, a computer, or other devices with a communication function, taking the mobile phone as an example, a user inputs a content to be queried in a corresponding query program through the mobile phone, where the content is a query request, and after receiving the query request, the server identifies the content and extracts key information from the content to obtain a plurality of key data. The key information may be a keyword having a special meaning in the text information, or a speech fragment having a special meaning in the speech information, for example: when the query request input by the user in 2022, 8, month and 10 is "whether the enterprise a in 2022 earns money", the key information is extracted according to the query request, and then a plurality of key data "2022, enterprise a", "earning money" and the like are obtained.
Furthermore, after a plurality of key data are obtained, syntax check and semantic check are required to be performed on each key data, that is, language correctness of each key data is required to be performed, semantics of the key data are checked to ensure that no error exists in the logic of the query request, if no abnormality exists in the result of semantic recognition, each key data is combined, and if the result of semantic recognition is abnormal, prompt information is sent to prompt a user to re-input the query request, or the abnormal key data is corrected by using a key data information table. For example: by performing semantic recognition on the plurality of key data "2022 years", "enterprise a" and "earning money", it can be known that the user wants to know the operation condition of enterprise a (i.e. annual financial statement) in 2022 years, but since "earning money" in the key data does not belong to the term of financial staff, the plurality of key data are modified into "2022 years", "enterprise a" and "annual financial statement" by using the key data information table. And combining the modified key data into a financial data query request, namely 'annual financial statement of 2022 year A enterprise'.
Note that, the financial data query request includes the current time when the user inputs, the target object, and a data title, for example: in the financial data query request "annual financial statement of enterprise a in 2022, the target object is" enterprise a ", the data is entitled" 2022 years ", and the current time is" 8 months and 10 days in 2022. Typically, financial data has a plurality of data headings, such as "month, quarter, year" etc. for describing a time period, "contract amount, purchase amount" etc. for describing an amount of money, and "contracting party, transferor" etc. for describing a specific direction. In specific implementation, various data titles are stored in a database, and the data titles in the information input by the user are identified in a semantic identification mode.
S102, verifying the data title according to the current time to judge whether the data title is a time title or not;
s103, if the data title is a time title, taking the data title as a financial title;
s104, if the data title is not the time title, combining the current time and the data title by using a preset combination rule to obtain a combined title, and taking the combined title as a financial title;
in specific implementation, when the data title is a time title, it means that the data title can represent a time period, that is, a user wants to query a financial data situation that is a target object in the time period, at this time, the data title is used as a financial title, when the data title is not the time title, a prompt message is sent first to prompt the user to confirm whether the time title is not input, after a first time (10 s in this embodiment) elapses, a combination rule is called in a combination rule base to combine the current time with the data title, and the combined title is used as the financial title.
It can be understood that the combination rule base stores combination rules corresponding to various data titles, and when a data title is not a time title, the corresponding combination rule is called according to the type of the data title, and then the data title is combined with the current time through the combination rule. For example: when the financial data query request received at 8/10/2022 is "annual financial statement of 2022 year a corporation", the target object is "corporation a", and the data title is "2022 year", which means that the user wants to query the financial data of the corporation 2022 year a, so "2022 year" is used as the financial title of the financial data query; when the query request of the financial data received at 8/10 th of 2022 is "contract amount of enterprise a", the target object is "enterprise a", the data is titled "contract amount", and not time title, at this time, the current time is preliminarily verified, when the current time is at the end of quarter, the current time is divided into a plurality of time data, respectively "year", "month", and "quarter", and the current time is taken as an example of "8/10 th of 2022 years", and belongs to the initial stage of the third quarter, so that the current time is divided into "8/2022 years", and the time data and the data title are combined to obtain the corresponding financial title, "contract amount before 8/2022 years" and/or "contract amount of 2022 years 8/months".
S105, performing preliminary query based on the financial title and the target object to obtain a corresponding preliminary result, wherein the preliminary result at least comprises financial data content;
in specific implementation, a preliminary query is performed in the server based on the obtained financial title and the query direction of the target object, so as to obtain a corresponding preliminary result, where the preliminary result includes the financial title and financial data content corresponding to the target object, for example, if the financial title is "contract amount of 8 months in 2022", and the target object is "enterprise a", the financial data content is specific content corresponding to "contract amount of 8 months in 2022 years in enterprise a".
S106, acquiring a query weight rule corresponding to the financial data query request, and performing data screening on the financial data content based on the query weight rule to obtain a first financial data content;
further, referring to fig. 3, the step S106 specifically includes steps S1061 to S1062:
s1061, analyzing a plurality of query condition information in the financial data query request by using a data analysis rule, and calculating a priority coefficient and a weight value of each query condition information;
s1062, constructing a query weight rule based on the priority coefficient of each query condition information and the weight value of each query condition information.
In specific implementation, when a user carries out a financial data query request, a plurality of query conditions are input, the plurality of query conditions in the financial query request are analyzed by using corresponding data analysis rules, and the priority coefficient and the weight value of each query condition are calculated;
in this embodiment, a hierarchical structure model is constructed, and various query conditions input by a user are input into the hierarchical structure model, so that the hierarchical structure model divides various query conditions into principal components and multiple factors, and performs query retrieval on the principal components of the query conditions, thereby obtaining principal component scores of the query conditions, when the principal component score of a certain query condition exceeds a preset principal component score (in this embodiment, the preset principal component score is 70), it means that the priority coefficient of the query condition is higher, the more the exceeded score is, the higher the priority coefficient of the query condition is, that is, the more accurate the query result obtained by the query condition is, the query conditions are sorted by the principal component scores, and then a principal component score table is obtained;
it should be noted that the main component of the query condition is query information obtained by extracting information amount from the query condition, that is, the query information can completely represent the query condition; the factors are scattered query data in the query condition, and the query condition can be represented by combining a plurality of factors.
When the principal component score of a certain query condition is lower than the preset principal component score, performing secondary query retrieval on the factor of the query condition to obtain the factor score of the query condition, when the factor score of the query condition is lower than the preset factor score (in the embodiment, the preset factor score is 85), discarding the query condition, namely removing the query condition from the principal component score table, when the factor score of the query condition is higher than the preset factor score, sorting the query conditions with the principal component scores lower than the preset principal component score according to the factor scores, and displaying the factor scores of the query conditions in the principal component score table.
In this embodiment, by means of pre-constructing a priority coefficient-weight value mapping table, after the priority coefficient of the query condition is obtained, the weight value corresponding to each query condition can be obtained by means of table lookup; in other embodiments, the weight value of each query condition in the financial data query request can be calculated through a weight formula; the higher the weight value of the query condition is, the higher the importance degree of the query condition in the financial data query request is, and the maximum enthusiasm of the user wanting to query the part is also means that the priority coefficient of the query condition is higher.
Further, after the priority coefficient and the weighted value of each query condition are obtained, the query conditions are sorted according to the weighted value and the priority coefficient, a corresponding query weight rule table is generated, and data screening is performed on the financial data content according to the query weight rule table to obtain first financial data content.
It can be understood that, in the first financial data content, there are financial data corresponding to a plurality of query conditions, where the financial data are distributed according to the order in the query weight rule table.
S107, the financial data type of the first financial data content is obtained, a financial data report corresponding to the financial data type and the target object is screened out from a financial database, and the first financial data content is input into the financial data report to generate a financial inquiry report.
In specific implementation, financial data reports corresponding to different financial data types and different target objects are stored in the financial database in advance, different financial data types need to adopt different financial data reports, and the difference between different target objects is to better present a query result to a user according to the difference between different target objects so as to accurately display the content corresponding to the financial data types.
In summary, the financial data query method in the above embodiment of the present invention performs multi-level analysis on the financial data query request, so as to ensure the efficiency of identifying and/or processing the financial data query request by the processor, and reduce the risk of misjudgment and/or misprocessing, specifically, checks the data title, so as to reduce the risk of query abnormality caused by a data title error; data screening is carried out on financial data contents through preliminary query and query weight rules, so that query results obtained through financial data query can better meet user requirements, and the problem that the query results are abnormal due to the fact that a plurality of influences exist in query requests input by non-financial personnel is avoided.
Example two
Referring to fig. 4, a financial data query method according to a second embodiment of the present invention is shown, the method specifically includes steps S201 to S210:
s201, acquiring a financial data query request sent by a user, wherein the financial data query request comprises current time, a target object and at least one data title;
in specific implementation, the device terminal may be a mobile phone, a computer, or other device with a communication function, taking a mobile phone as an example, a user inputs a content to be queried in a corresponding query program through the mobile phone, where the content is a query request, and after receiving the query request, the server identifies the content and extracts key information from the content to obtain a plurality of key data. The key information may be a keyword having a special meaning in the text information, or may also be a speech fragment having a special meaning in the speech information, for example: when the query request input by the user in 2022, 8, month and 10 is "whether the enterprise a in 2022 earns money", the key information is extracted according to the query request, and then a plurality of key data "2022, enterprise a", "earning money" and the like are obtained.
Furthermore, after a plurality of key data are acquired, syntax verification and semantic verification need to be performed on each key data, that is, language correctness needs to be performed on each key data, semantics of the key data are checked to ensure that no error exists logically in the query request, if no abnormality exists in the result of semantic recognition, each key data is combined, and if the result of semantic recognition is abnormal, prompt information is sent to prompt a user to re-input the query request, or a key data information table is used for correcting the abnormal key data. For example: the semantic recognition of the key data "2022 years", "enterprise a" and "money earning" can make sure that the user wants to know the operation condition of enterprise a in 2022 years (namely annual financial statement), but because "money earning" in the key data does not belong to the term of financial staff, the key data information table is used to modify the key data into "2022 years", "enterprise a" and "annual financial statement". And combining the modified key data into a financial data query request, namely 'annual financial statement of 2022 year A enterprise'.
The financial data query request includes the current time when the user input, the target object, and a data title, for example: in the financial data query request "annual financial statement of enterprise a in 2022, the target object is" enterprise a ", the data is entitled" 2022 years ", and the current time is" 8 months and 10 days in 2022. Typically, financial data has a plurality of data headings, such as "month, quarter, year" etc. for describing a time period, "contract amount, purchase amount" etc. for describing an amount of money, and "contracting party, transferor" etc. for describing a specific direction. In the specific implementation, various data titles are stored in the database, and the data title in the information input by the user is identified in a semantic identification mode.
S202, checking the data title according to the current time to judge whether the data title is a time title or not;
s203, if the data title is a time title, taking the data title as a financial title;
s204, if the data title is not the time title, combining the current time and the data title by using a preset combination rule to obtain a combined title, and taking the combined title as a financial title;
in specific implementation, when the data title is a time title, it means that the data title can represent a time slot, that is, a user wants to query a certain financial data condition that is a target object in the time slot, at this time, the data title is used as a financial title, when the data title is not the time title, a prompt message is sent first to prompt the user to confirm whether the time title is not input, after a first time (10 s in this embodiment) elapses, a combination rule is called in a combination rule base to combine the current time with the data title, and the combined title is used as a financial title.
It can be understood that the combination rule base stores combination rules corresponding to various data titles, and when a data title is not a time title, the corresponding combination rule is called according to the type of the data title, and then the data title is combined with the current time through the combination rule. For example: when the financial data query request received at 8/10/2022 is "annual financial statement of 2022 year a corporation", the target object is "corporation a", and the data title is "2022 year", which means that the user wants to query the financial data of the corporation 2022 year a, so "2022 year" is used as the financial title of the financial data query; when the query request of the financial data received at 8/10 th of 2022 is "contract amount of enterprise a", the target object is "enterprise a", the data is titled "contract amount", and not time title, at this time, the current time is preliminarily verified, when the current time is at the end of quarter, the current time is divided into a plurality of time data, respectively "year", "month", and "quarter", and the current time is taken as an example of "8/10 th of 2022 years", and belongs to the initial stage of the third quarter, so that the current time is divided into "8/2022 years", and the time data and the data title are combined to obtain the corresponding financial title, "contract amount before 8/2022 years" and/or "contract amount of 2022 years 8/months".
S205, performing preliminary query based on the financial title and the target object to obtain a corresponding preliminary result, wherein the preliminary result at least comprises financial data content;
in specific implementation, based on the obtained financial title and the query direction of the target object, a preliminary query is performed in the server to obtain a corresponding preliminary result, where the preliminary result includes the financial title and financial data content corresponding to the target object, for example, if the financial title is "contract amount of 8 months in 2022," and the target object is "enterprise a," the financial data content is specific content corresponding to "contract amount of 8 months in 2022 of enterprise a.
S206, acquiring a query weight rule corresponding to the financial data query request, and performing data screening on the financial data content based on the query weight rule to obtain a first financial data content;
in specific implementation, when a user carries out a financial data query request, a plurality of query conditions are input, the plurality of query conditions in the financial query request are analyzed by using corresponding data analysis rules, and the priority coefficient and the weight value of each query condition are calculated;
in this embodiment, a hierarchical structure model is constructed, various query conditions input by a user are input into the hierarchical structure model, so that the hierarchical structure model splits the various query conditions into principal components and multiple factors, query retrieval is performed on the principal components of the query conditions, and then principal component scores of the query conditions are obtained, when the principal component score of a certain query condition exceeds a preset principal component score (in this embodiment, the preset principal component score is 70), it means that the priority coefficient of the query condition is higher, the more the exceeded score is, the higher the priority coefficient of the query condition is, that is, the more accurate the query result obtained by the query condition is, the query conditions are ranked by the principal component scores, and then a principal component score table is obtained;
it should be noted that the main component of the query condition is query information obtained by extracting information amount from the query condition, that is, the query information can completely represent the query condition; the factors are scattered query data in the query condition, and the query condition can be represented by combining a plurality of factors.
When the principal component score of a certain query condition is lower than the preset principal component score, performing secondary query retrieval on the factor of the query condition to obtain the factor score of the query condition, when the factor score of the query condition is lower than the preset factor score (in the embodiment, the preset factor score is 85), discarding the query condition, namely removing the query condition from the principal component score table, when the factor score of the query condition is higher than the preset factor score, sorting the query conditions with the principal component scores lower than the preset principal component score according to the factor scores, and displaying the factor scores of the query conditions in the principal component score table.
In this embodiment, by means of pre-constructing a priority coefficient-weight value mapping table, after the priority coefficient of the query condition is obtained, the weight value corresponding to each query condition can be obtained by means of table lookup; in other embodiments, the weight value of each query condition in the financial data query request can be calculated through a weight formula; the higher the weight value of the query condition is, the higher the importance degree of the query condition in the financial data query request is, and the maximum enthusiasm of the user wanting to query the part is also means that the priority coefficient of the query condition is higher.
Further, after the priority coefficient and the weight value of each query condition are obtained, the query conditions are sorted according to the weight value and the priority coefficient, a corresponding query weight rule table is generated, and data screening is performed on the financial data content according to the query weight rule table to obtain first financial data content.
It can be understood that, in the first financial data content, there are financial data corresponding to a plurality of query conditions, where the financial data are distributed according to the sequence in the query weight rule table.
S207, acquiring the financial data type of the first financial data content, screening a financial data report corresponding to the financial data type and the target object from a financial database, and inputting the first financial data content into the financial data report to generate a financial query report;
in specific implementation, financial data reports corresponding to different financial data types and different target objects are stored in the financial database in advance, different financial data types need to adopt different financial data reports, and the difference between different target objects is to better present a query result to a user according to the difference between different target objects so as to accurately display the content corresponding to the financial data types.
S208, when acquiring the query change request sent by the user, acquiring the change content of the query change request, and judging whether the change content is the object change;
in specific implementation, when a query change request sent by a user for changing query content is acquired, the change content corresponding to the query change request is acquired, whether the change content is an object change is analyzed, if the change content is the object change, it means that an object of a previous query is changed, the query needs to be performed according to a new object, and if the change content is not the object change, it means that the object of the previous query is not changed, the query is continued in the preliminary query result.
S209, if the changed content is the object change, regenerating a financial data query request according to the changed content, and querying the financial data according to the regenerated financial data query request;
in a specific implementation, if the change content is an object change, which means that the object to be queried is changed, the query needs to be performed according to a new object, the financial data query request is regenerated by using the change content, and the financial data query is performed according to the new financial data query request.
And S210, if the changed content is not the object change, performing secondary query on the primary result according to the changed content to obtain a secondary query result based on the changed content.
In a specific implementation, if the modified content is not the object modification, which means that the object of the previous query is not modified, the secondary query is continued in the preliminary query result, and a secondary query result based on the modified content can be obtained.
Compared with the financial data query method in the first embodiment, the financial data query method in the embodiment increases the verification process of query request change, when the user does not change the object, the user does not need to perform integral query again, and only needs to perform secondary query on the basis of the result of the primary query, so that the processing steps are reduced, and the processing efficiency is improved.
EXAMPLE III
In another aspect, referring to fig. 5, a financial data query system according to a third embodiment of the present invention is further provided, where the system includes:
the query request acquiring module 11 is configured to acquire a financial data query request sent by a user, where the financial data query request includes a current time, a target object, and at least one data title;
further, the query request obtaining module 11 includes:
the key information extraction unit is used for acquiring a query request sent by a user through an equipment terminal and extracting key information of the query request to obtain a plurality of corresponding key data;
and the data combination unit is used for performing semantic recognition on each piece of key data and combining each piece of key data based on the result of the semantic recognition to obtain the financial data query request.
The data checking module 12 is configured to check the data title according to the current time to determine whether the data title is a time title;
a first data processing module 13, configured to use the data title as a financial title if the data title is a time title;
the second data processing module 14 is configured to, if the data title is not a time title, combine the current time and the data title by using a preset combination rule to obtain a combined title, and use the combined title as a financial title;
a preliminary query module 15, configured to perform a preliminary query based on the financial title and the target object to obtain a corresponding preliminary result, where the preliminary result at least includes financial data content;
a rule obtaining module 16, configured to obtain a query weight rule corresponding to the financial data query request, and perform data screening on the financial data content based on the query weight rule to obtain a first financial data content;
further, the rule obtaining module 16 includes:
the condition analysis unit is used for analyzing a plurality of query condition information in the financial data query request by using a data analysis rule and calculating a priority coefficient and a weight value of each query condition information;
and the rule construction unit is used for constructing a query weight rule based on the priority coefficient of each query condition information and the weight value of each query condition information.
And the report generation module 17 is configured to acquire the financial data type of the first financial data content, screen out a financial data report corresponding to the financial data type and the target object from a financial database, and input the first financial data content into the financial data report to generate a financial query report.
In some optional embodiments, the system further comprises:
the query change module is used for acquiring the change content of the query change request and judging whether the change content is the object change or not when the query change request sent by the user is acquired;
the request generation module is used for regenerating a financial data query request according to the changed content if the changed content is the object change, and querying financial data according to the regenerated financial data query request;
and the secondary query module is used for carrying out secondary query on the primary result according to the change content if the change content is not the object change so as to obtain a secondary query result based on the change content.
The functions or operation steps of the modules and units when executed are substantially the same as those of the method embodiments, and are not described herein again.
The financial data query system provided by the embodiment of the invention has the same implementation principle and technical effect as the method embodiment, and for brief description, reference may be made to corresponding contents in the method embodiment where no part of the device embodiment is mentioned.
Example four
Referring to fig. 6, a computer device according to a fourth embodiment of the present invention is shown, which includes a memory 10, a processor 20, and a computer program 30 stored in the memory 10 and executable on the processor 20, where the processor 20 implements the above-mentioned financial data query method when executing the computer program 30.
The memory 10 includes at least one type of storage medium including a flash memory, a hard disk, a multimedia card, a card type memory (e.g., SD or DX memory, etc.), a magnetic memory, a magnetic disk, an optical disk, and the like. The memory 10 may in some embodiments be an internal storage unit of the computer device, for example a hard disk of the computer device. The memory 10 may also be an external storage device in other embodiments, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like. Further, the memory 10 may also include both an internal storage unit and an external storage device of the computer apparatus. The memory 10 may be used not only to store application software installed in the computer device and various kinds of data, but also to temporarily store data that has been output or will be output.
In some embodiments, the processor 20 may be an Electronic Control Unit (ECU), a Central Processing Unit (CPU), a controller, a microcontroller, a microprocessor or other data Processing chip, and is configured to run program codes stored in the memory 10 or process data, such as executing an access restriction program.
It should be noted that the configuration shown in fig. 6 does not constitute a limitation of the computer device, and in other embodiments the computer device may include fewer or more components than those shown, or some components may be combined, or a different arrangement of components.
An embodiment of the present invention further provides a readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the above financial data query method.
Those of skill in the art will understand that the logic and/or steps represented in the flowcharts or otherwise described herein, e.g., an ordered listing of executable instructions that can be viewed as implementing logical functions, can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. For the purposes of this description, a "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device.
More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). Additionally, the computer-readable medium could even be paper or another suitable medium upon which the program is printed, as the program can be electronically captured, via for instance optical scanning of the paper or other medium, then compiled, interpreted or otherwise processed in a suitable manner if necessary, and then stored in a computer memory.
It should be understood that portions of the present invention may be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, the various steps or methods may be implemented in software or firmware stored in memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, any one or combination of the following technologies, which are well known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.
The technical features of the embodiments described above may be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the embodiments described above are not described, but should be considered as being within the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is specific and detailed, but not to be understood as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent application shall be subject to the appended claims.
Claims (8)
1. A financial data query method, comprising:
the method comprises the steps of obtaining a financial data query request sent by a user, wherein the financial data query request comprises current time, a target object and at least one data title;
checking the data title according to the current time to judge whether the data title is a time title or not;
if the data title is a time title, taking the data title as a financial title;
if the data title is not a time title, combining the current time and the data title by using a preset combination rule to obtain a combined title, and taking the combined title as a financial title;
performing a preliminary query based on the financial title and the target object to obtain a corresponding preliminary result, wherein the preliminary result at least comprises financial data content;
acquiring a query weight rule corresponding to the financial data query request, and performing data screening on the financial data content based on the query weight rule to obtain a first financial data content;
acquiring the financial data type of the first financial data content, screening out a financial data report corresponding to the financial data type and the target object from a financial database, and inputting the first financial data content into the financial data report to generate a financial query report;
the method comprises the following steps of obtaining a query weight rule corresponding to the financial data query request, and performing data screening on the financial data content based on the query weight rule to obtain a first financial data content:
analyzing a plurality of query condition information in the financial data query request by using a data analysis rule, and calculating a priority coefficient and a weight value of each query condition information;
sorting the query conditions based on the priority coefficient of each query condition information and the weight value of each query condition information to generate a corresponding query weight rule table;
and performing data screening on the financial data content according to the query weight rule table to obtain a first financial data content.
2. A financial data query method as claimed in claim 1 wherein the step of obtaining a financial data query request sent by a user comprises:
acquiring a query request sent by a user through an equipment terminal, and extracting key information of the query request to obtain a plurality of corresponding key data;
and performing semantic recognition on each key data, and combining each key data based on the result of the semantic recognition to obtain a financial data query request.
3. The financial data query method of claim 1, further comprising:
when an inquiry change request sent by the user is obtained, obtaining the change content of the inquiry change request, and judging whether the change content is the object change;
if the changed content is the object change, regenerating a financial data query request according to the changed content, and querying financial data according to the regenerated financial data query request;
and if the change content is not the object change, performing secondary query on the primary result according to the change content to obtain a secondary query result based on the change content.
4. A financial data query system, comprising:
the query request acquisition module is used for acquiring a financial data query request sent by a user, wherein the financial data query request comprises current time, a target object and at least one data title;
the data checking module is used for checking the data title according to the current time so as to judge whether the data title is a time title or not;
the first data processing module is used for taking the data title as a financial title if the data title is a time title;
the second data processing module is used for combining the current time and the data title by using a preset combination rule to obtain a combined title if the data title is not the time title, and taking the combined title as a financial title;
a preliminary query module, configured to perform a preliminary query based on the financial title and the target object to obtain a corresponding preliminary result, where the preliminary result at least includes financial data content;
the rule obtaining module is used for obtaining a query weight rule corresponding to the financial data query request and carrying out data screening on the financial data content based on the query weight rule to obtain a first financial data content;
a report generation module, configured to obtain a financial data type of the first financial data content, screen out a financial data report corresponding to the financial data type and the target object from a financial database, and input the first financial data content into the financial data report to generate a financial query report;
wherein the rule obtaining module comprises:
the condition analysis unit is used for analyzing a plurality of query condition information in the financial data query request by using a data analysis rule and calculating a priority coefficient and a weight value of each query condition information;
the rule construction unit is used for sequencing the query conditions based on the priority coefficient of each query condition information and the weight value of each query condition information to generate a corresponding query weight rule table;
and performing data screening on the financial data content according to the query weight rule table to obtain a first financial data content.
5. The financial data query system of claim 4 wherein the query request acquisition module comprises:
the key information extraction unit is used for acquiring a query request sent by a user through an equipment terminal and extracting key information of the query request to obtain a plurality of corresponding key data;
and the data combination unit is used for performing semantic recognition on each piece of key data and combining each piece of key data based on the result of the semantic recognition to obtain the financial data query request.
6. The financial data query system of claim 4, further comprising:
the query change module is used for acquiring the change content of the query change request and judging whether the change content is the object change or not when the query change request sent by the user is acquired;
the request generation module is used for regenerating a financial data query request according to the changed content if the changed content is the object change, and querying financial data according to the regenerated financial data query request;
and the secondary query module is used for carrying out secondary query on the primary result according to the change content if the change content is not the object change, so as to obtain a secondary query result based on the change content.
7. A readable storage medium on which a computer program is stored, the computer program, when executed by a processor, implementing a financial data querying method according to any one of claims 1 to 3.
8. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor when executing the computer program implements the financial data query method of any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211037353.XA CN115099922B (en) | 2022-08-29 | 2022-08-29 | Financial data query method, system, readable storage medium and computer equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211037353.XA CN115099922B (en) | 2022-08-29 | 2022-08-29 | Financial data query method, system, readable storage medium and computer equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115099922A CN115099922A (en) | 2022-09-23 |
| CN115099922B true CN115099922B (en) | 2022-11-08 |
Family
ID=83301563
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211037353.XA Active CN115099922B (en) | 2022-08-29 | 2022-08-29 | Financial data query method, system, readable storage medium and computer equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115099922B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112149387A (en) * | 2020-09-28 | 2020-12-29 | 深圳壹账通智能科技有限公司 | Visualization method and device for financial data, computer equipment and storage medium |
| CN112380278A (en) * | 2020-11-17 | 2021-02-19 | 平安普惠企业管理有限公司 | Financial data report generation method, device, equipment and storage medium |
| CN114780601A (en) * | 2022-04-25 | 2022-07-22 | 中译语通科技股份有限公司 | Data query method and device, electronic equipment and storage medium |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2004070406A (en) * | 2002-08-01 | 2004-03-04 | Daido Life Insurance Co | Financial data management system and method, and computer |
| US8504552B2 (en) * | 2007-03-26 | 2013-08-06 | Business Objects Software Ltd. | Query based paging through a collection of values |
| CN103984713B (en) * | 2014-05-07 | 2017-05-31 | 珠海横琴跨境说网络科技有限公司 | A kind of financial data querying method based on cloud computing |
| CN110413634B (en) * | 2019-06-27 | 2022-03-29 | 北京奇艺世纪科技有限公司 | Data query method, system, device and computer readable storage medium |
| CN113326285B (en) * | 2021-08-03 | 2021-11-12 | 北京轻松筹信息技术有限公司 | Database table query method and device |
| CN113515549B (en) * | 2021-09-14 | 2021-12-10 | 江西科技学院 | Financial data query method and device and readable storage medium |
| CN114547069A (en) * | 2022-01-27 | 2022-05-27 | 北京百度网讯科技有限公司 | Data query method and device, electronic equipment and storage medium |
-
2022
- 2022-08-29 CN CN202211037353.XA patent/CN115099922B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112149387A (en) * | 2020-09-28 | 2020-12-29 | 深圳壹账通智能科技有限公司 | Visualization method and device for financial data, computer equipment and storage medium |
| CN112380278A (en) * | 2020-11-17 | 2021-02-19 | 平安普惠企业管理有限公司 | Financial data report generation method, device, equipment and storage medium |
| CN114780601A (en) * | 2022-04-25 | 2022-07-22 | 中译语通科技股份有限公司 | Data query method and device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115099922A (en) | 2022-09-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11429878B2 (en) | Cognitive recommendations for data preparation | |
| CN107819627B (en) | System fault processing method and server | |
| CN110309125B (en) | Data verification method, electronic device and storage medium | |
| CN110489415B (en) | Data updating method and related equipment | |
| CN112445875B (en) | Data association and verification method and device, electronic equipment and storage medium | |
| US9691065B2 (en) | Automated transactions clearing system and method | |
| CN110674360B (en) | Tracing method and system for data | |
| CN111553137B (en) | Report generation method and device, storage medium and computer equipment | |
| CN112989990B (en) | Medical bill identification method, device, equipment and storage medium | |
| CN110413569A (en) | Archives of paper quality electronization archiving method, device and terminal device | |
| CN110598996A (en) | Risk processing method and device, electronic equipment and storage medium | |
| CN110471912B (en) | Employee attribute information verification method and device and terminal equipment | |
| US10782942B1 (en) | Rapid onboarding of data from diverse data sources into standardized objects with parser and unit test generation | |
| CN110489434B (en) | Information processing method and related equipment | |
| CN110489416B (en) | Information storage method based on data processing and related equipment | |
| CN115099922B (en) | Financial data query method, system, readable storage medium and computer equipment | |
| CN109710626B (en) | Data warehousing management method and device, electronic equipment and storage medium | |
| CN110795308A (en) | Server inspection method, device, equipment and storage medium | |
| CN115762704A (en) | Prescription auditing method, device, equipment and storage medium | |
| CN113626558B (en) | Intelligent recommendation-based field standardization method and system | |
| CN111857721B (en) | SQL statement verification method, data acquisition method, equipment and storage device | |
| CN115221936A (en) | Record matching in a database system | |
| CN111127043A (en) | Credit scoring method, credit scoring device, computer equipment and storage medium | |
| CN110909538A (en) | Question and answer content identification method and device, terminal equipment and medium | |
| CN111427571A (en) | Data verification method and device |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |