Data management method and device of security business management system, and storage medium

Abstract

The invention discloses a data management method and device of a security business management system and a storage medium, and relates to the technical field of query languages. According to the method and the device, the original query request language is processed in a manner of adding a plurality of headers and a plurality of expanded table contents corresponding to each header, so that the expanded table can cover more meaning expressions, then a plurality of initial LINQ query statements are generated according to the plurality of meaning expressions, and the query efficiency is improved. And determining a credibility parameter corresponding to each initial LINQ query statement according to the number of repetition times of each initial LINQ query statement. When the final LINQ query statement is determined, the LINQ query statement corresponding to the query request is screened out from the multiple initial LINQ query statements, and the final LINQ query statement meets the preset parameter screening condition, so that the query request given by the operation object is accurately converted into the corresponding LINQ query statement. And finally, the LINQ query statement can accord with the characteristics of data of the security business management system, and query operation can be completed more efficiently.

Description

Technical Field

[0001] The present invention relates to the technical field of query languages, and in particular, to a data management method, device, and storage medium for a securities business management system. Background Art

[0002] A securities business management system is a key platform for securities companies to manage and operate their core businesses. It covers multiple aspects such as customer information management, transaction execution, risk management, compliance monitoring, financial accounting, and report generation, providing support for the daily operations and decision-making of securities companies. With the development of the financial market and the increasing complexity of business, the amount and types of data that the securities business management system needs to process are constantly increasing, posing higher requirements for the efficiency and accuracy of data management.

[0003] In traditional securities business management systems, data management mainly relies on relational databases and SQL query languages. However, with the diversification of business and the explosion of data volume, this traditional data management method faces many challenges. For example, complex business logics and diverse data query requirements make SQL queries cumbersome and difficult to maintain; the integration of different data sources is difficult, resulting in prominent data island problems; and the need for real-time and high-performance data queries is difficult to meet.

[0004] LINQ (Language Integrated Query) is a query technology integrated into programming languages, mainly used for data query in.NET languages such as C# and VB.NET. By providing a unified query syntax and rich standard query operators, LINQ enables developers to query and operate on various data sources (such as in-memory collections, XML documents, relational databases, etc.) in an intuitive and type-safe manner.

[0005] In a securities business management system, the application of LINQ query statements can bring improvements in many aspects. First, it can simplify the code for data query and operation, improving development efficiency and code maintainability. Second, through the type-safe feature of LINQ, errors in data query can be reduced, improving the stability of the system. In addition, the rich operators of LINQ enable complex business queries to be expressed more intuitively, helping to meet the diverse data query requirements in the securities business.

[0006] However, users of the securities business management system or upstream and downstream devices cannot directly give query languages in the LINQ form. At this time, it is necessary to accurately convert the query requests given by the operation objects into corresponding LINQ query languages. Therefore, a new data management method for a securities business management system is needed to accurately convert the query requests given by the operation objects into corresponding LINQ query languages. Summary of the Invention

[0007] The present invention provides a data management method, device, and storage medium for a securities business management system, which are used to accurately convert a query request given by an operation object into a corresponding LINQ query language.

[0008] To solve the above technical problems, a first aspect of the present invention discloses a data management method for a securities business management system, and the method includes:

[0009] Receiving a query request output by an operation object based on a securities business management system;

[0010] Filling the query request into a preset form template to obtain a form-based language; wherein, the form template is pre-determined for data operations of the securities business management system, and the form-based language includes multiple table headers for indicating an operation object or operation content and table contents corresponding to each table header;

[0011] Expanding the table contents corresponding to each table header of the form-based language to obtain an expanded form;

[0012] Generating a plurality of initial LINQ query statements according to the expanded form, and determining a credibility parameter corresponding to each initial LINQ query statement according to the repetition times of each initial LINQ query statement;

[0013] Screening out the LINQ query statement corresponding to the query request from the plurality of initial LINQ query statements, wherein the credibility parameter corresponding to the LINQ query statement corresponding to the query request satisfies a preset parameter screening condition;

[0014] Obtaining a query result from a database corresponding to the securities business management system according to the LINQ query statement corresponding to the query request.

[0015] As an optional implementation manner, in the first aspect of the present invention, the screening out the LINQ query statement corresponding to the query request from the plurality of initial LINQ query statements includes:

[0016] Screening out a to-be-confirmed LINQ query statement from the plurality of initial LINQ query statements, and the credibility parameter corresponding to the to-be-confirmed LINQ query statement is greater than or equal to a preset credibility threshold;

[0017] If the number of the to-be-confirmed LINQ query statements is only 1, then confirming the to-be-confirmed LINQ query statement as the LINQ query statement corresponding to the query request;

[0018] If the number of LINQ query statements to be confirmed is greater than or equal to 2, it is determined that the query request does not have a corresponding LINQ query statement, and a corresponding prompt message is output to the operation object.

[0019] As an optional implementation manner, in the first aspect of the present invention, generating a plurality of initial LINQ query statements according to the extended table, and determining a credibility parameter corresponding to each initial LINQ query statement according to the repetition times of each initial LINQ query statement includes:

[0020] Generating a plurality of derived statements corresponding to the query request according to the extended table;

[0021] Inputting all the derived statements into a pre-trained conversion model to obtain the initial LINQ query statement corresponding to each derived statement output by the conversion model, and counting the repetition times of each initial LINQ query statement;

[0022] Determining a credibility parameter corresponding to each initial LINQ query statement according to the repetition times of each initial LINQ query statement, wherein the credibility parameter corresponding to each initial LINQ query statement is proportional to the repetition times.

[0023] As an optional implementation manner, in the first aspect of the present invention, before inputting all the derived statements into a pre-trained conversion model, the method further includes:

[0024] Obtaining a training data set, where the training data set includes a plurality of initial instructions in the form of query requests and the target LINQ query statement corresponding to each initial instruction;

[0025] For each initial instruction, generating a derivative instruction semantically equivalent to the initial instruction according to the initial instruction;

[0026] For each target LINQ query statement, generating derivative LINQ query statements of various structures based on the target LINQ query statement according to the target LINQ query statement;

[0027] Obtaining a training instruction set, where the training instruction set includes all the initial instructions and all the derivative instructions;

[0028] Obtaining a training LINQ query statement set matching the training instruction set, where the LINQ query statement set includes all the target LINQ query statements and all the derivative LINQ query statements;

[0029] Train a preset initial conversion model according to the training instruction set and a set of training LINQ query statements matching the training instruction set to obtain a trained conversion model.

[0030] As an optional implementation manner, in the first aspect of the present invention, the method further includes:

[0031] Receive a LINQ query statement to be converted for a securities business management system, and generate extended LINQ query statements of multiple structures based on the LINQ query statement to be converted.

[0032] Determine an initial table corresponding to the LINQ query statement to be converted according to the LINQ query statement to be converted, where the initial table includes multiple table headers for indicating operation objects or operation contents.

[0033] Input all the extended LINQ query statements into a pre-trained conversion model to obtain an initial query request corresponding to each of the extended LINQ query statements output by the conversion model.

[0034] Fill all the initial query requests into the initial table to obtain multiple table contents corresponding to each table header in the initial table.

[0035] For each table header in the initial table, determine a weight parameter corresponding to each table content according to the repetition times of each table content corresponding to the table header; and determine the table content with the largest weight parameter corresponding to the table header as the target table content.

[0036] Construct a query request corresponding to the LINQ query statement to be converted according to the target table contents corresponding to all the table headers in the initial table.

[0037] As an optional implementation manner, in the first aspect of the present invention, for each table header in the initial table, determining the table content with the largest weight parameter corresponding to the table header as the target table content includes:

[0038] For each table header in the initial table, screen out the table contents to be confirmed from the multiple table contents corresponding to the table header, where the weight parameters corresponding to the table contents to be confirmed are greater than or equal to a preset weight threshold; if the number of the table contents to be confirmed is only one, confirm the table content to be confirmed as the target table content.

[0039] As an optional implementation manner, in the first aspect of the present invention, the method further includes:

[0040] For all the table headers in the initial table, if the number of the table contents to be confirmed corresponding to any table header in the initial table is greater than or equal to 2, it is determined that the LINQ query statement to be converted does not have a corresponding query request.

[0041] The second aspect of the present invention discloses a data management device for a securities business management system. The device includes:

[0042] A request receiving module, configured to receive a query request output by an operation object based on the securities business management system;

[0043] A first table filling module, configured to fill the query request into a preset table template to obtain a table form language; wherein, the table template is pre-determined for data operations of the securities business management system, and the table form language includes a plurality of table headers for indicating operation objects or operation contents and the table contents corresponding to each table header;

[0044] A table expansion module, configured to expand the table contents corresponding to each table header of the table form language to obtain an expanded table;

[0045] A language conversion module, configured to generate a plurality of initial LINQ query statements according to the expanded table, and determine a credibility parameter corresponding to each initial LINQ query statement according to the repetition times of each initial LINQ query statement;

[0046] A statement screening module, configured to screen out the LINQ query statement corresponding to the query request from a plurality of initial LINQ query statements, wherein the credibility parameter corresponding to the LINQ query statement corresponding to the query request meets a preset parameter screening condition;

[0047] A query execution module, configured to obtain a query result from a database corresponding to the securities business management system according to the LINQ query statement corresponding to the query request.

[0048] As an optional implementation manner, in the second aspect of the present invention, the specific operation manner of the statement screening module for screening out the LINQ query statement corresponding to the query request from a plurality of initial LINQ query statements includes:

[0049] Screen out a to-be-confirmed LINQ query statement from a plurality of initial LINQ query statements, and the credibility parameter corresponding to the to-be-confirmed LINQ query statement is greater than or equal to a preset credibility threshold;

[0050] If the number of the to-be-confirmed LINQ query statements is only 1, confirm that the to-be-confirmed LINQ query statement is the LINQ query statement corresponding to the query request;

[0051] If the number of LINQ query statements to be confirmed is greater than or equal to 2, it is determined that the query request does not have a corresponding LINQ query statement, and a corresponding prompt message is output to the operating object.

[0052] As an alternative implementation, in the second aspect of the present invention, the specific operation method of the language conversion module for generating a plurality of initial LINQ query statements according to the extended table and determining the credibility parameter corresponding to each initial LINQ query statement according to the repetition times of each initial LINQ query statement includes:

[0053] Generating a plurality of derived statements corresponding to the query request according to the extended table;

[0054] Inputting all the derived statements into a pre-trained conversion model to obtain the initial LINQ query statements corresponding to each of the derived statements output by the conversion model, and counting the repetition times of each initial LINQ query statement;

[0055] Determining the credibility parameter corresponding to each initial LINQ query statement according to the repetition times of each initial LINQ query statement, wherein the credibility parameter corresponding to each initial LINQ query statement is proportional to the repetition times.

[0056] As an alternative implementation, in the second aspect of the present invention, the device further includes:

[0057] A data acquisition module, configured to acquire a training data set before the language conversion module inputs all the derived statements into a pre-trained conversion model, where the training data set includes a plurality of initial instructions in the form of query requests and the target LINQ query statements corresponding to each of the initial instructions;

[0058] An instruction extension module, configured to generate a derivative instruction semantically equivalent to each initial instruction according to the initial instruction;

[0059] A statement extension module, configured to generate derivative LINQ query statements of various structures based on each target LINQ query statement according to the target LINQ query statement;

[0060] A data integration module, configured to obtain a training instruction set, where the training instruction set includes all the initial instructions and all the derivative instructions; and obtain a training LINQ query statement set matching the training instruction set, where the LINQ query statement set includes all the target LINQ query statements and all the derivative LINQ query statements;

[0061] A model training module, configured to train a preset initial conversion model according to the training instruction set and a set of training LINQ query statements matching the training instruction set, so as to obtain a trained conversion model.

[0062] As an optional implementation manner, in the second aspect of the present invention, the apparatus further includes:

[0063] A query receiving module, configured to receive a LINQ query statement to be converted for a securities business management system, and generate a set of extended LINQ query statements with various structures based on the LINQ query statement to be converted;

[0064] A table analysis module, configured to determine an initial table corresponding to the LINQ query statement to be converted according to the LINQ query statement to be converted, where the initial table includes a plurality of table headers for indicating operation objects or operation contents;

[0065] A model analysis module, configured to input all the extended LINQ query statements into a pre-trained conversion model, so as to obtain an initial query request corresponding to each of the extended LINQ query statements output by the conversion model;

[0066] A second table filling module fills all the initial query requests into the initial table, so as to obtain a plurality of table contents corresponding to each table header in the initial table;

[0067] A table determination module, for each table header in the initial table, determining a weight parameter corresponding to each table content according to the repetition times of each table content corresponding to the table header; and determining the table content with the largest weight parameter corresponding to the table header as the target table content;

[0068] A query analysis module, configured to construct a query request corresponding to the LINQ query statement to be converted according to the target table contents corresponding to all the table headers in the initial table.

[0069] As an optional implementation manner, in the second aspect of the present invention, the specific operation manner of the table determination module for determining the table content with the largest weight parameter corresponding to each table header in the initial table as the target table content includes:

[0070] For each table header in the initial table, screening out the table content to be confirmed from the multiple table contents corresponding to the table header, where the weight parameter corresponding to the table content to be confirmed is greater than or equal to a preset weight threshold; if the number of the table contents to be confirmed is only one, then confirming the table content to be confirmed as the target table content.

[0071] As an optional implementation manner, in the second aspect of the present invention, the table determination module is further configured to:

[0072] For all the table headers in the initial table, if the number of table contents to be confirmed corresponding to any table header in the initial table is greater than or equal to 2, it is determined that the LINQ query statement to be converted does not have a corresponding query request.

[0073] The third aspect of the present invention discloses another data management system of a securities business management system, and the system includes:

[0074] A memory storing executable program code;

[0075] A processor coupled to the memory;

[0076] The processor calls the executable program code stored in the memory and executes the data management method of the securities business management system disclosed in the first aspect of the present invention.

[0077] The fourth aspect of the present invention discloses a computer storage medium, and the computer storage medium stores computer instructions, which are used to execute the data management method of the securities business management system disclosed in the first aspect of the present invention when called.

[0078] Compared with the prior art, the present invention has the following beneficial effects:

[0079] The present invention can process the original query request language by means of multiple table headers plus multiple extended table contents corresponding to each table header. This processing enables the extended table to cover more meaning expressions. Then, according to the multiple meaning expressions contained in the extended table, multiple initial LINQ query statements are generated, and the credibility parameter corresponding to each initial LINQ query statement is determined according to the repetition times of each initial LINQ query statement. When determining the final LINQ query statement, the LINQ query statement corresponding to the query request is screened out from multiple initial LINQ query statements. The final LINQ query statement meets the preset parameter screening conditions, indicating that its accuracy is relatively high, so as to accurately convert the query request given by the operation object into the corresponding LINQ query statement. Finally, using the LINQ query statement can meet the characteristics of diverse data and high requirements for data security and stability in the securities business management system, and can complete the query operation more efficiently. BRIEF DESCRIPTION OF THE DRAWINGS

[0080] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following will briefly introduce the drawings required for the description of the embodiments. Obviously, the following drawings are only some embodiments of the present invention. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative efforts.

[0081] Figure 1 It is a schematic flowchart of a data management method for a securities business management system disclosed in an embodiment of the present invention;

[0082] Figure 2 It is a schematic structural diagram of a data management device for a securities business management system disclosed in an embodiment of the present invention;

[0083] Figure 3 It is a schematic structural diagram of a data management system for a securities business management system disclosed in an embodiment of the present invention. Specific embodiments

[0084] In order to enable those skilled in the art to better understand the solution of the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

[0085] The terms "first", "second", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish different objects, rather than to describe a specific order. In addition, the terms "comprising" and "having" and any variations thereof are intended to cover non-exclusive inclusion. For example, a process, method, device, product or terminal including a series of steps or units is not limited to the listed steps or units, but may optionally further include steps or units not listed, or may optionally further include other steps or units inherent to these processes, methods, products or terminals.

[0086] Referring to "embodiment" herein means that a specific feature, structure or characteristic described in connection with the embodiment may be included in at least one embodiment of the present invention. The phrase appears in various places in the specification does not necessarily refer to the same embodiment, nor is it an independent or alternative embodiment mutually exclusive with other embodiments. Those skilled in the art will explicitly and implicitly understand that the embodiments described herein may be combined with other embodiments.

[0087] The present invention discloses a data management method, device and storage medium for a securities business management system, which are used to accurately convert a query request given by an operation object into a corresponding LINQ query language.

[0088] Embodiment 1

[0089] Please refer to Figure 1 , Figure 1 which is a schematic flowchart of a data management method for a securities business management system disclosed in an embodiment of the present invention. Among them, Figure 1The data management method of the described securities business management system can be implemented in the data management device of the securities business management system. The data management device of the securities business management system can be integrated in a cloud server or a local server, which can be servers used by a securities company or servers used by other companies providing services for the securities public. The embodiments of the present invention do not make any limitations. As Figure 1 shown, the data management method of the securities business management system may include the following operations:

[0090] Step 101, receive a query request output by an operation object based on the securities business management system.

[0091] In the embodiments of the present invention, the securities business management system is a key platform for a securities company to manage and operate its core business. It covers multiple aspects such as customer information management, transaction execution, risk management, compliance monitoring, financial accounting, and report generation, providing support for the daily operation and decision-making of the securities company.

[0092] In the embodiments of the present invention, the operation object can be a user of the securities business management system or upstream and downstream devices, and the query request is used to represent various operation requests initiated by the operation object for the database of the securities business management system, such as basic business questions and answers, basic database operation requirements, addition, deletion, modification, query, multi-table association, and partition establishment operations. Optionally, the query request refers to a request sent by a user or a system to the system to obtain specific securities business-related information. These query requests are usually used to obtain account information, transaction records, market data, etc. For example, the query request can be used for account information query, transaction record query, held securities query, market data query, fund flow query, risk assessment query, order query, dividend distribution query, basic securities information query, user permission query, etc. It can also be a combination of the above various queries.

[0093] Step 102, fill the query request into a preset form template to obtain a form-based language.

[0094] In the embodiment of the present invention, the table template is a method disclosed by the present invention for disassembling and analyzing the language corresponding to the query request. The query request is proposed by the operation object, which is often a query description or an operation instruction similar to the query request. The table template in this embodiment can be set according to the different characteristics of the query request. For example, the table template is established according to the grammatical role (subject, predicate, object, etc.) of each word in the query request; for another example, the table template is established according to the part of speech (verb, noun, adjective, etc.) of different words in the query request. Among them, the table template is predetermined for the data operation of the securities business management system, and the table form language may include multiple table headers for indicating the operation object or operation content and the table content corresponding to each table header; for example, the table header is a different grammatical role or part of speech, and the table content corresponding to the table header is a specific word. Through the table form language, the query request can be analyzed more systematically and accurately, which is conducive to the subsequent recognition and conversion operations.

[0095] In the embodiment of the present invention, different table templates can be optionally set for different operation purposes, so as to provide more accurate and reasonable customized table templates. For example, different table templates are set in advance according to basic business questions and answers, basic database operation requirements, addition, deletion, modification, query, multi-table association, and partition establishment operations. Before filling the query request into the table template, the operation purpose of the query request is first determined, and the corresponding table template is found.

[0096] Step 103: Expand the table content corresponding to each table header of the table format language to obtain an extended table.

[0097] In the embodiment of the present invention, the optional extension methods are:

[0098] (1) Synonym expansion method, including:

[0099] Dictionary search method: search for synonyms or near-synonyms of the word in the preset vocabulary library;

[0100] Contextual replacement method: Find synonyms or near-synonyms based on the context of the query request;

[0101] Root-affix method: Analyze the roots and affixes of words, and find words with the same or similar roots according to the meaning of the roots;

[0102] Antonym method: first find the antonym of the word, then find the antonym of the antonym, you may get a new synonym;

[0103] (2) Semantic expansion method, including:

[0104] Hyponym and hyponym: Find the hypernym and hyponym of the word to expand its semantic scope. A hypernym is a broader word, while a hyponym is a more specific and narrower word.

[0105] Semantic extension method: Based on the literal meaning of a word, extend its metaphorical meaning, symbolic meaning, etc.;

[0106] Collocation expansion method: Analyze the words that a word is often collocated with to expand its semantics.

[0107] Lexical background method: Combine the background of the securities industry where the word is located to understand its specific indicative connotation and thus expand its semantics;

[0108] (3) Lexical association method

[0109] Correlative word method: Expand according to the correlation between words. For example, "ocean" is associated with "ship", "navigation", "marine life", etc.;

[0110] Situational association: Imagine a specific situation and think about the words related to this word that may appear in this situation. For example, in the situation of "risky operation", words such as "money laundering", "high frequency", "cross-border" may come to mind.

[0111] (4) Semantic discrimination method

[0112] Comparison and discrimination method: Compare this word with other similar words to find the subtle differences between them, so as to understand and expand its semantics more accurately;

[0113] Context discrimination method: Analyze the meaning of this word in different contexts to see how it changes in different situations, so as to expand its semantics.

[0114] Step 104: Generate multiple initial LINQ query statements according to the expansion table, and determine the credibility parameter corresponding to each initial LINQ query statement according to the repetition times of each initial LINQ query statement.

[0115] Step 104: Generate multiple initial LINQ query statements according to the expansion table, and determine the credibility parameter corresponding to each initial LINQ query statement according to the repetition times of each initial LINQ query statement.

[0116] In the embodiments of the present invention, the extended table does not simply transform a query request statement into multiple statements that may indicate the same or similar meanings. Instead, the original query request statement is processed by adding multiple table headers and multiple extended table contents corresponding to each table header. This processing enables the extended table to cover more meaning expressions. Then, based on the multiple meaning expressions contained in the extended table, using language conversion technology, multiple initial LINQ query statements are generated, and the repetition times of each LINQ query statement are counted. The repetition times actually indicate the number of times of the same meaning expression in the extended table. The more the repetition times, the more important a corresponding meaning expression is. Therefore, the credibility parameter corresponding to each initial LINQ query statement can be determined according to the repetition times of each initial LINQ query statement.

[0117] In the embodiments of the present invention, optionally, the specific operations of step 104 may include:

[0118] According to the extended table, generate multiple derived statements corresponding to the query request; for example, different meaning expressions can be formed according to the extended table by means of permutation and combination, and each meaning expression corresponds to a derived statement.

[0119] Input all the derived statements into a pre-trained conversion model to obtain the initial LINQ query statements corresponding to each derived statement output by the conversion model, and count the repetition times of each initial LINQ query statement;

[0120] Determine the credibility parameter corresponding to each initial LINQ query statement according to the repetition times of each initial LINQ query statement, where the credibility parameter corresponding to each initial LINQ query statement is proportional to the repetition times.

[0121] Step 105: Screen out the LINQ query statement corresponding to the query request from multiple initial LINQ query statements.

[0122] In the embodiments of the present invention, the credibility parameter of the LINQ query statement corresponding to the query request satisfies a preset parameter screening condition; the credibility parameter measures the accuracy of a LINQ query statement through the repetition times. Therefore, it is necessary to screen out the most accurate LINQ query statement from multiple initial LINQ query statements. Among them, the preset parameter screening condition may be that the credibility parameter is the largest, the credibility parameter exceeds a certain threshold, or the credibility parameter is within a certain numerical range, etc.

[0123] In an optional embodiment, screening out the LINQ query statement corresponding to the query request from multiple initial LINQ query statements may include:

[0124] Filter out the LINQ query statements to be confirmed from multiple initial LINQ query statements, where the credibility parameter corresponding to the LINQ query statement to be confirmed is greater than or equal to a preset credibility threshold; if the number of LINQ query statements to be confirmed is only 1, then confirm that this LINQ query statement to be confirmed is the LINQ query statement corresponding to the query request.

[0125] In this optional embodiment, for a query request of a securities business management system, whether it can be converted into a corresponding LINQ query statement actually also needs to consider whether the query request is accurate and whether it has convertibility. When there are multiple credibility parameters of the initial LINQ query statements corresponding to the original query request language that are close and there are no extreme values, it indicates that the original query request language cannot be converted into a LINQ query statement due to reasons such as ambiguity. Therefore, when determining the final LINQ query statement, it is first necessary to filter out the initial LINQ query statements with credibility parameters exceeding a certain value as the LINQ query statements to be confirmed. If the number of LINQ query statements to be confirmed is only 1, it means that there is a LINQ query statement with a relatively high matching degree in the original query request and there is no other ambiguity. So it can be confirmed that this LINQ query statement to be confirmed is the LINQ query statement corresponding to the query request.

[0126] In an embodiment of the present invention, optionally, if the number of LINQ query statements to be confirmed is greater than or equal to 2, it means that there is more than one LINQ query statement with a relatively high matching degree in the original query request, indicating that there may be ambiguity. Then it is determined that the query request does not have a corresponding LINQ query statement, and a corresponding prompt message is output to the operation object.

[0127] Step 106: Obtain a query result from the database corresponding to the securities business management system according to the LINQ query statement corresponding to the query request.

[0128] In an embodiment of the present invention, LINQ (Language Integrated Query) is a query technology integrated in programming languages, mainly used for data query in.NET languages such as C# and VB.NET. LINQ provides a unified query syntax and rich standard query operators. In a securities business management system, the application of LINQ query statements can bring improvements in many aspects. First, it can simplify the code for data query and operation, improving development efficiency and code maintainability. Second, through the type safety feature of LINQ, errors in data query can be reduced, improving the stability of the system. In addition, the rich operators of LINQ enable complex business queries to be expressed more intuitively, helping to meet the diverse data query needs in the securities business.

[0129] It can be seen that the embodiments of the present invention can process the original query request language by means of multiple headers plus multiple extended table contents corresponding to each header. This processing enables the extended table to cover more meaning expressions. Then, according to the multiple meaning expressions contained in the extended table, multiple initial LINQ query statements are generated, and the credibility parameter corresponding to each initial LINQ query statement is determined according to the repetition times of each initial LINQ query statement. When determining the final LINQ query statement, the LINQ query statement corresponding to the query request is filtered out from multiple initial LINQ query statements. The final LINQ query statement meets the preset parameter filtering conditions, indicating that its accuracy is relatively high, so as to accurately convert the query request given by the operation object into the corresponding LINQ query statement. Finally, using the LINQ query statement can meet the characteristics of diverse data and high requirements for data security and stability in the securities business management system, and can complete the query operation more efficiently.

[0130] In an optional embodiment, before inputting all the derived statements into the pre-trained conversion model, the method may further include:

[0131] Obtain a training data set, which may include multiple initial instructions in the form of query requests and the target LINQ query statements corresponding to each initial instruction;

[0132] For each initial instruction, according to the initial instruction, generate a derivative instruction semantically equivalent to the initial instruction; for example, for the same query request, multiple query request expression methods are used. For example, for the query "obtain the dividend distribution of customer A", it can be expanded to different expressions such as "query the equity information of customer A", "query the profit distribution information of customer A", and dividend distribution, bonus issue, shareholder dividend, cash dividend, stock dividend, equity distribution, dividend distribution, bonus share issue, bonus share distribution, etc., so as to increase the diversity of data and help the model better understand the semantics.

[0133] For each target LINQ query statement, according to the target LINQ query statement, generate derivative LINQ query statements with multiple structures based on the target LINQ query statement; optionally, for the target LINQ query statement, multiple structures of derivative LINQ query statements can be generated from a basic target LINQ query statement by adding conditions, returning different attributes, performing aggregation, sorting, restricting results, matching relationships, using optional matching, merging results, performing subqueries, and parameterized queries, etc.

[0134] Obtain a training instruction set, which may include all the initial instructions and all the derivative instructions;

[0135] Obtain a set of training LINQ query statements that match the training instruction set. The set of LINQ query statements can include all target LINQ query statements and all derived LINQ query statements;

[0136] Train a preset initial conversion model according to the training instruction set and the set of training LINQ query statements that match the training instruction set to obtain a trained conversion model. This conversion model is used to implement the conversion between query requests and LINQ query statements, including outputting corresponding LINQ query statements according to the input query requests, and also including outputting corresponding query requests according to the input LINQ query statements. Since the training data set used by this conversion model includes the training instruction set and the set of training LINQ query statements that match the training instruction set, the conversion model can better understand the semantics and can adapt to more complex query requirements, thereby improving the accuracy of the conversion process.

[0137] In an optional embodiment, since the function of the conversion model includes both outputting corresponding LINQ query statements according to the input query requests and outputting corresponding query requests according to the input LINQ query statements, the method may further include:

[0138] Receive a LINQ query statement to be converted for the securities business management system, and generate extended LINQ query statements with multiple structures based on the LINQ query statement to be converted; for example, according to the LINQ query statement to be converted, add more LINQ query statements with different structures, such as by adding conditions, returning different attributes, performing aggregations, sorting, restricting results, matching relationships, using optional matches, merging results, performing subqueries, and parameterized queries, etc., so as to generate extended LINQ query statements with multiple structures based on the LINQ query statement to be converted. These extended LINQ query statements are all related to the LINQ query statement to be converted, so they will include the meaning expression of the LINQ query statement to be converted in multiple forms. Triggering the conversion of the conversion model with the meaning expression carried by the LINQ query statements in multiple forms can determine the most reasonable conversion result through multiple verifications.

[0139] According to the LINQ query statement to be converted, determine the initial table corresponding to the LINQ query statement to be converted. Among them, the initial table can include multiple headers for indicating operation objects or operation contents; among them, the contents of the headers are not filled in temporarily. Here, it is equivalent to establishing a table template for the LINQ query statement to be converted. Subsequently, filling multiple initial query requests into the table template can obtain query requests in table form.

[0140] Input all extended LINQ query statements into a pre-trained conversion model to obtain the initial query requests corresponding to each extended LINQ query statement output by the conversion model; fill all the initial query requests into an initial table to obtain multiple table contents corresponding to each table header in the initial table; among them, during the process of filling the initial query requests into the initial table, if some content cannot correspond to the table header, no filling operation will be performed. For example, some extended LINQ query statements actually add statements of other structures on the basis of the LINQ query statement to be converted, so they not only contain the meaning expression of the query request to be converted itself, but also include other extended meaning expressions, and these extended meaning expressions are exactly excluded during the process of filling the initial table.

[0141] For each table header in the initial table, determine the weight parameter corresponding to each table content according to the repetition times of each table content corresponding to the table header; and determine the table content with the largest weight parameter corresponding to the table header as the target table content; construct the query request corresponding to the LINQ query statement to be converted according to the target table contents corresponding to all table headers in the initial table.

[0142] In this optional embodiment, the corresponding query request is analyzed through the LINQ query statement. The application scenario can be: for the LINQ query statements triggered internally by the computer or sent by upstream and downstream devices, since the whole process is operated inside the computer, it is difficult for users or managers to intuitively see the situation of the query requests. Therefore, converting these internal LINQ query statements into corresponding query requests can meet the intuitive viewing needs of users or managers.

[0143] In this optional embodiment, all the initial query requests are filled into the initial table to obtain multiple table contents corresponding to each table header in the initial table. For the multiple table contents corresponding to each table header, this optional embodiment believes that the table content with more repetition times has a larger weight parameter, and the table content with a larger weight parameter should be determined as the final table content. Finally, construct the query request corresponding to the LINQ query statement to be converted according to the target table contents corresponding to all table headers in the initial table. This optional embodiment generates extended LINQ query statements of multiple structures based on the LINQ query statement to be converted, so that the conversion model can convert the LINQ query statement to be converted under different circumstances, improving the recognition range of the model. Finally, irrelevant information is excluded through the initial table, and the conversion results with higher weights are highlighted to finally determine a relatively accurate conversion result.

[0144] In this optional embodiment, further optionally, for each table header in the initial table, determining the table content with the largest weight parameter corresponding to the table header as the target table content may include:

[0145] For each table header in the initial table, the table content to be confirmed is screened out from the multiple table contents corresponding to the table header, and the weight parameter corresponding to the table content to be confirmed is greater than or equal to the preset weight threshold; if there is only one table content to be confirmed, the table content to be confirmed is confirmed as the target table content. Among them, if there is only one table content to be confirmed, it means that there is a table content with the highest matching degree with the LINQ query statement under the table header, and there is no other ambiguity, so it can be confirmed that the only table content to be confirmed is the final target table content. In this optional embodiment, it is further optional that for all the table headers in the initial table, if the number of table contents to be confirmed corresponding to any table header in the initial table is greater than or equal to 2, it is determined that the LINQ query statement to be converted does not have a corresponding query request. Among them, as long as there is more than one table content to be confirmed corresponding to any table header, it means that there is no table content with the highest matching degree with the LINQ query statement under the table header, and there may be other ambiguities. At this time, there is no need to consider the situation of other table headers, and it can be directly determined that the LINQ query statement to be converted does not have a corresponding query request.

[0146] Embodiment 2

[0147] See also Figure 2 , Figure 2 Schematic diagram of the structure of a data management device for a securities business management system disclosed in an embodiment of the present invention. Figure 2 As shown, the data management device of the securities business management system may include:

[0148] The request receiving module 201 is used to receive the query request output by the operation object based on the securities business management system;

[0149] The first table filling module 202 is used to fill the query request into a preset table template to obtain a table form language; wherein the table template is predetermined for data operations of the securities business management system, and the table form language may include a plurality of table headers for indicating operation objects or operation contents and table contents corresponding to each table header;

[0150] A table expansion module 203, used to expand the table content corresponding to each table header of the table formal language to obtain an expanded table;

[0151] The language conversion module 204 is used to generate a plurality of initial LINQ query statements according to the extended table, and determine the credibility parameter corresponding to each of the initial LINQ query statements according to the number of repetitions of each of the initial LINQ query statements;

[0152] A statement screening module 205, configured to screen out the LINQ query statement corresponding to the query request from multiple initial LINQ query statements, where the credibility parameter corresponding to the LINQ query statement corresponding to the query request meets a preset parameter screening condition;

[0153] A query execution module 206, configured to obtain a query result from the database corresponding to the securities business management system according to the LINQ query statement corresponding to the query request.

[0154] In an alternative embodiment, the specific operation mode of the statement screening module 205 to screen out the LINQ query statement corresponding to the query request from multiple initial LINQ query statements may include:

[0155] Screen out the LINQ query statements to be confirmed from multiple initial LINQ query statements, where the credibility parameter corresponding to the LINQ query statements to be confirmed is greater than or equal to a preset credibility threshold;

[0156] If the number of the LINQ query statements to be confirmed is only 1, confirm that the LINQ query statement to be confirmed is the LINQ query statement corresponding to the query request;

[0157] If the number of the LINQ query statements to be confirmed is greater than or equal to 2, determine that the query request does not have a corresponding LINQ query statement, and output a corresponding prompt message to the operation object.

[0158] In another alternative embodiment, the specific operation mode of the language conversion module 204 to generate multiple initial LINQ query statements according to the extended table and determine the credibility parameter corresponding to each initial LINQ query statement according to the repetition times of each initial LINQ query statement may include:

[0159] Generate multiple derived statements corresponding to the query request according to the extended table;

[0160] Input all the derived statements into a pre-trained conversion model to obtain the initial LINQ query statement corresponding to each derived statement output by the conversion model, and count the repetition times of each initial LINQ query statement;

[0161] Determine the credibility parameter corresponding to each initial LINQ query statement according to the repetition times of each initial LINQ query statement, where the credibility parameter corresponding to each initial LINQ query statement is proportional to the repetition times.

[0162] In yet another alternative embodiment, the apparatus may further include:

[0163] A data acquisition module, configured to acquire a training data set before the language conversion module 204 inputs all derived statements into a pre-trained conversion model, where the training data set may include multiple initial instructions in the form of query requests and target LINQ query statements corresponding to each of the initial instructions;

[0164] An instruction extension module, configured to generate, for each of the initial instructions, a derivative instruction that is semantically equivalent to the initial instruction according to the initial instruction;

[0165] A statement extension module, configured to generate, for each target LINQ query statement, derivative LINQ query statements of multiple structures based on the target LINQ query statement according to the target LINQ query statement;

[0166] A data integration module, configured to obtain a training instruction set, where the training instruction set may include all the initial instructions and all the derivative instructions; obtain a training LINQ query statement set that matches the training instruction set, where the LINQ query statement set may include all the target LINQ query statements and all the derivative LINQ query statements;

[0167] A model training module, configured to train a preset initial conversion model according to the training instruction set and the training LINQ query statement set that matches the training instruction set to obtain a trained conversion model.

[0168] In yet another alternative embodiment, the device may further include:

[0169] A query receiving module, configured to receive a to-be-converted LINQ query statement for a securities business management system, and generate extended LINQ query statements of multiple structures based on the to-be-converted LINQ query statement according to the to-be-converted LINQ query statement;

[0170] A table analysis module, configured to determine an initial table corresponding to the to-be-converted LINQ query statement according to the to-be-converted LINQ query statement, where the initial table may include multiple table headers for indicating operation objects or operation contents;

[0171] A model analysis module, configured to input all the extended LINQ query statements into a pre-trained conversion model to obtain an initial query request corresponding to each of the extended LINQ query statements output by the conversion model;

[0172] A second table filling module fills all the initial query requests into the initial table to obtain multiple table contents corresponding to each table header in the initial table;

[0173] A table determination module, configured to determine, for each table header in the initial table, a weight parameter corresponding to each table content according to the repetition times of each table content corresponding to the table header; and determine the table content with the largest weight parameter corresponding to the table header as the target table content;

[0174] A query analysis module, configured to construct a query request corresponding to the to-be-converted LINQ query statement according to the target table contents corresponding to all the table headers in the initial table.

[0175] In another optional embodiment, the specific operation method for the table determination module to determine, for each table header in the initial table, the table content with the largest weight parameter corresponding to the table header as the target table content may include:

[0176] For each table header in the initial table, screen out the to-be-confirmed table contents from the multiple table contents corresponding to the table header, where the weight parameter corresponding to the to-be-confirmed table content is greater than or equal to a preset weight threshold; if the number of the to-be-confirmed table contents is only one, confirm the to-be-confirmed table content as the target table content.

[0177] In another optional embodiment, the table determination module is further configured to:

[0178] For all the table headers in the initial table, if the number of the to-be-confirmed table contents corresponding to any table header in the initial table is greater than or equal to 2, determine that the to-be-converted LINQ query statement does not have a corresponding query request.

[0179] Embodiment III

[0180] Please refer to Figure 3 , Figure 3 which is a schematic structural diagram of a data management system of a securities business management system disclosed in an embodiment of the present invention. As Figure 3 shown, the data management system of the securities business management system may include:

[0181] A memory 301 storing executable program code;

[0182] A processor 302 coupled to the memory 301;

[0183] The processor 302 calls the executable program code stored in the memory 301 and executes the steps in the data management method of the securities business management system described in Embodiment I of the present invention.

[0184] Embodiment IV

[0185] An embodiment of the present invention discloses a computer storage medium. The computer storage medium stores computer instructions, which when called, are used to execute the steps in the data management method of the securities business management system described in Embodiment 1 of the present invention.

[0186] Embodiment 5

[0187] An embodiment of the present invention discloses a computer program product. The computer program product includes a non-transitory computer-readable storage medium storing a computer program, and the computer program is operable to cause a computer to execute the steps in the data management method of the securities business management system described in Embodiment 1.

[0188] The device embodiments described above are merely illustrative. The modules described as separate components may or may not be physically separated, and the components shown as modules may or may not be physical modules, that is, they may be located in one place or distributed to multiple network modules. Some or all of the modules can be selected according to actual needs to achieve the purpose of the solution of this embodiment. Those of ordinary skill in the art can understand and implement it without creative labor.

[0189] Through the specific descriptions of the above embodiments, those skilled in the art can clearly understand that each embodiment can be implemented by means of software plus a necessary general hardware platform, and of course, it can also be implemented by hardware. Based on such an understanding, the above technical solution, in essence, or the part that contributes to the prior art, can be embodied in the form of a software product. The computer software product can be stored in a computer-readable storage medium, including read-only memory (ROM), random access memory (RAM), programmable read-only memory (PROM), erasable programmable read-only memory (EPROM), one-time programmable read-only memory (OTPROM), electrically-erasable programmable read-only memory (EEPROM), compact disc read-only memory (CD-ROM) or other optical disc memories, magnetic disk memories, tape memories, or any other computer-readable medium capable of carrying or storing data.

[0190] Finally, it should be noted that: The data management method, device, and storage medium of a securities business management system disclosed in the embodiments of the present invention only disclose the preferred embodiments of the present invention, and are only used to illustrate the technical solutions of the present invention, rather than limiting them; Although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that they can still modify the technical solutions recorded in the foregoing embodiments, or perform equivalent replacements for some of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A data management method for a securities business management system, characterized in that, The method includes: Receiving a query request output by an operation object based on a securities business management system; Filling the query request into a preset form template to obtain a form-based language; wherein, the form template is pre-determined for data operations of the securities business management system, and the form-based language includes multiple headers for indicating operation objects or operation contents and table contents corresponding to each header; Expanding the table contents corresponding to each header of the form-based language to obtain an expanded form; Generating a plurality of initial LINQ query statements according to the expanded form, and determining a credibility parameter corresponding to each initial LINQ query statement according to the repetition times of each initial LINQ query statement; Filtering out the LINQ query statement corresponding to the query request from the plurality of initial LINQ query statements, wherein the credibility parameter corresponding to the LINQ query statement corresponding to the query request meets a preset parameter filtering condition; Obtaining a query result from a database corresponding to the securities business management system according to the LINQ query statement corresponding to the query request.

2. The data management method of the securities business management system according to claim 1, characterized in that, The filtering out the LINQ query statement corresponding to the query request from the plurality of initial LINQ query statements includes: Filtering out a to-be-confirmed LINQ query statement from the plurality of initial LINQ query statements, and the credibility parameter corresponding to the to-be-confirmed LINQ query statement is greater than or equal to a preset credibility threshold; If the number of the to-be-confirmed LINQ query statements is only 1, confirming the to-be-confirmed LINQ query statement as the LINQ query statement corresponding to the query request; If the number of the to-be-confirmed LINQ query statements is greater than or equal to 2, determining that the query request does not have a corresponding LINQ query statement, and outputting a corresponding prompt message to the operation object.

3. The data management method of the securities business management system according to claim 1, characterized in that The generating a plurality of initial LINQ query statements according to the expanded form, and determining a credibility parameter corresponding to each initial LINQ query statement according to the repetition times of each initial LINQ query statement includes: Generating a plurality of derived statements corresponding to the query request according to the expanded form; Inputting all the derived statements into a pre-trained conversion model to obtain the initial LINQ query statements corresponding to each of the derived statements output by the conversion model, and counting the repetition times of each initial LINQ query statement; Determining a credibility parameter corresponding to each initial LINQ query statement according to the repetition times of each initial LINQ query statement, wherein the credibility parameter corresponding to each initial LINQ query statement is proportional to the repetition times.

4. The data management method of the securities business management system according to claim 3, characterized in that, Before inputting all the derived statements into the pre-trained conversion model, the method further includes: Obtaining a training data set, where the training data set includes a plurality of initial instructions in the form of query requests and target LINQ query statements corresponding to each initial instruction; For each of the initial instructions, generating a derivative instruction semantically equivalent to the initial instruction according to the initial instruction; For each target LINQ query statement, based on the target LINQ query statement, generate derivative LINQ query statements of various structures based on the target LINQ query statement; Obtain a training instruction set, where the training instruction set includes all the initial instructions and all the derivative instructions; Obtain a training LINQ query statement set that matches the training instruction set, where the LINQ query statement set includes all the target LINQ query statements and all the derivative LINQ query statements; Train a preset initial conversion model according to the training instruction set and the training LINQ query statement set that matches the training instruction set to obtain a trained conversion model.

5. The data management method of the securities business management system according to claim 3, characterized in that, The method further includes: Receive a LINQ query statement to be converted for a securities business management system, and based on the LINQ query statement to be converted, generate extended LINQ query statements of various structures based on the LINQ query statement to be converted; Based on the LINQ query statement to be converted, determine an initial table corresponding to the LINQ query statement to be converted, where the initial table includes multiple headers for indicating operation objects or operation contents; Input all the extended LINQ query statements into a pre-trained conversion model to obtain an initial query request corresponding to each of the extended LINQ query statements output by the conversion model; Fill all the initial query requests into the initial table to obtain multiple table contents corresponding to each header in the initial table; For each header in the initial table, determine a weight parameter corresponding to each table content according to the repetition times of each table content corresponding to the header; and determine the table content with the largest weight parameter corresponding to the header as the target table content; Construct a query request corresponding to the LINQ query statement to be converted according to the target table contents corresponding to all the headers in the initial table.

6. The data management method of the securities business management system according to claim 5, characterized in that, The determining, for each header in the initial table, the table content with the largest weight parameter corresponding to the header as the target table content includes: For each header in the initial table, filter out the table content to be confirmed from the multiple table contents corresponding to the header, where the weight parameter corresponding to the table content to be confirmed is greater than or equal to a preset weight threshold; if the number of the table contents to be confirmed is only one, confirm the table content to be confirmed as the target table content.

7. The data management method of the securities business management system according to claim 6, characterized in that The method further includes: For all the headers in the initial table, if the number of the table contents to be confirmed corresponding to any header in the initial table is greater than or equal to 2, determine that the LINQ query statement to be converted does not have a corresponding query request.

8. A data management device for a securities business management system, characterized in that, The device includes: A request receiving module, configured to receive a query request output by an operation object based on a securities business management system; A first table filling module, configured to fill the query request into a preset table template to obtain a table form language; where the table template is pre-determined for data operations of a securities business management system, and the table form language includes multiple headers for indicating operation objects or operation contents and table contents corresponding to each header; A table expansion module, which is used to expand the table content corresponding to each table header of the table-form language to obtain an expanded table; A language conversion module, which is used to generate a plurality of initial LINQ query statements according to the expanded table, and determine a credibility parameter corresponding to each initial LINQ query statement according to the repetition times of each initial LINQ query statement; A statement screening module, which is used to screen out the LINQ query statement corresponding to the query request from a plurality of the initial LINQ query statements, wherein the credibility parameter corresponding to the LINQ query statement corresponding to the query request meets a preset parameter screening condition; A query execution module, which is used to obtain a query result from a database corresponding to the securities business management system according to the LINQ query statement corresponding to the query request.

9. A data management system for a securities business management system, characterized in that, The system includes: a memory storing executable program codes; a processor coupled to the memory; the processor calls the executable program codes stored in the memory to execute the data management method of the securities business management system according to any one of claims 1-7.

10. A computer storage medium, characterized in that, The computer storage medium stores computer instructions, which are used to execute the data management method of the securities business management system according to any one of claims 1-7 when the computer instructions are called.

Images