A data management method and device of a securities business management system, and a storage medium

Abstract

The application discloses a data management method and device of a securities business management system and a storage medium, and relates to the technical field of query languages.The original query request language is processed in a manner that multiple table headers are added with multiple extended table contents corresponding to each table header, so that the extended table can cover more meaning expressions, then multiple initial LINQ query statements are generated according to the multiple meaning expressions, and the credibility parameters corresponding to each initial LINQ query statement are determined according to the repetition times of each initial LINQ query statement.In determining the final LINQ query statement, 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 satisfies the preset parameter screening condition, so that the query request given by the operation object can be accurately converted into the corresponding LINQ query statement.Finally, the LINQ query statement can match the characteristics of the securities business management system data, and the query operation can be more efficiently completed.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of query language, and particularly relates to a data management method and device of a securities business management system and a storage medium. BACKGROUND

[0002] The securities business management system is a key platform for securities companies to manage and operate their core business. It covers customer information management, transaction execution, risk management, compliance monitoring, financial accounting and report generation, and other aspects, providing support for the daily operation and decision-making of securities companies. With the development of the financial market and the increasing complexity of business, the amount and type of data that the securities business management system needs to handle continue to increase, and higher requirements are placed on 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 explosive growth of data, this traditional data management approach faces many challenges. For example, complex business logic and diverse data query requirements make SQL queries cumbersome and difficult to maintain; integration between different data sources is difficult, leading to prominent data silo 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 in programming languages, mainly used for data queries in.NET languages such as C# and VB.NET. LINQ provides a unified query syntax and rich standard query operators, allowing developers to query and manipulate various data sources (such as in-memory collections, XML documents, relational databases, etc.) in an intuitive and type-safe manner.

[0005] In the securities business management system, the application of LINQ query statements can bring many improvements. First, it can simplify the code for data queries and operations, improving development efficiency and code maintainability. Second, through the type safety features of LINQ, errors in data queries can be reduced, improving system stability. In addition, the rich operators of LINQ make complex business queries more intuitive, helping to meet the diverse data query needs in securities business.

[0006] However, users or upstream devices of the securities business management system cannot directly give LINQ-form query language, so it is necessary to accurately convert the query request given by the operation object into the corresponding LINQ query language, therefore, a new data management method for the securities business management system is needed to accurately convert the query request given by the operation object into the corresponding LINQ query language. SUMMARY

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

[0008] To solve the above technical problems, the application discloses a data management method of a securities business management system, which comprises the following steps:

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

[0010] filling the query request into a preset table template to obtain a table form language; wherein the table template is determined in advance for data operation of the securities business management system, and the table form language comprises a plurality of table headers for indicating the operation object or operation content and table content corresponding to each table header;

[0011] extending the table content corresponding to each table header of the table form language to obtain an extended table;

[0012] 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 number of repetitions of each initial LINQ query statement;

[0013] screening a 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, in the first aspect of the application, the screening of the LINQ query statement corresponding to the query request from the plurality of initial LINQ query statements comprises:

[0016] screening a to-be-confirmed LINQ query statement from the plurality of initial LINQ query statements, wherein 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 statement is only one, confirming the to-be-confirmed LINQ query statement as the LINQ query statement corresponding to the query request;

[0018] If the number of the 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 corresponding prompt information is output to the operation object.

[0019] As an optional implementation, in the first aspect of the present application, the generating a plurality of initial LINQ query statements according to the extension table and determining a confidence parameter corresponding to each of the initial LINQ query statements according to the repetition number of each of the initial LINQ query statements comprises:

[0020] generating a plurality of derivative statements corresponding to the query request according to the extension table;

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

[0022] determining a confidence parameter corresponding to each of the initial LINQ query statements according to the repetition number of each of the initial LINQ query statements, wherein the confidence parameter corresponding to each of the initial LINQ query statements is directly proportional to the repetition number.

[0023] As an optional implementation, in the first aspect of the present application, before the inputting all the derivative statements into the pre-trained conversion model, the method further comprises:

[0024] obtaining a training data set, wherein the training data set comprises a plurality of initial instructions in the form of query requests and a target LINQ query statement corresponding to each of the initial instructions;

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

[0026] for each of the target LINQ query statements, generating a plurality of derivative LINQ query statements of different structures based on the target LINQ query statement according to the target LINQ query statement;

[0027] obtaining a training instruction set, wherein the training instruction set comprises all the initial instructions and all the derivative instructions;

[0028] obtaining a training LINQ query statement set matched with the training instruction set, wherein the LINQ query statement set comprises all the target LINQ query statements and all the derivative LINQ query statements;

[0029] According to the training instruction set and the training LINQ query statement set matched with the training instruction set, an initial conversion model is trained to obtain a trained conversion model.

[0030] As an optional implementation form, in the first aspect of the present application, the method further comprises:

[0031] receiving a to-be-converted LINQ query statement for a securities business management system, and generating extended LINQ query statements of multiple structures based on the to-be-converted LINQ query statement;

[0032] determining an initial table corresponding to the to-be-converted LINQ query statement according to the to-be-converted LINQ query statement, wherein the initial table comprises a plurality of table headers for indicating operation objects or operation contents;

[0033] inputting 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] filling all the initial query requests into the initial table to obtain a plurality of table contents corresponding to each table header in the initial table;

[0035] for each table header in the initial table, determining a weight parameter corresponding to each table content according to the number of repetitions of each table content, and determining a target table content corresponding to the table header as the table content with the maximum weight parameter;

[0036] constructing 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.

[0037] As an optional implementation form, in the first aspect of the present application, the method further comprises:

[0038] for each table header in the initial table, screening a to-be-confirmed table content from the plurality of table contents corresponding to the table header, wherein the weight parameter corresponding to the to-be-confirmed table content is greater than or equal to a preset weight threshold; and if the number of the to-be-confirmed table contents is only one, confirming the to-be-confirmed table content as the target table content.

[0039] As an optional implementation form, in the first aspect of the present application, the method further comprises:

[0040] For all table headers in the initial table, if the number of table contents corresponding to any table header in the initial table to be confirmed 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 application discloses a data management device of a securities business management system, the device comprising:

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

[0043] A first table filling module is configured to fill the query request into a preset table template to obtain a table form language; wherein the table template is determined in advance for data operation of the securities business management system, and the table form language comprises a plurality of table headers for indicating an operation object or operation content and table contents corresponding to each table header;

[0044] A table expansion module is 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 is 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 a repetition number of each initial LINQ query statement;

[0046] A statement screening module is configured to screen a 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;

[0047] A query execution module is 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, in the second aspect of the present application, the specific operation mode of the statement screening module for screening the LINQ query statement corresponding to the query request from the plurality of initial LINQ query statements comprises:

[0049] Screening a to-be-confirmed LINQ query statement from the plurality of initial LINQ query statements, wherein 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 statement is only one, the to-be-confirmed LINQ query statement is confirmed as the LINQ query statement corresponding to the query request;

[0051] If the number of the 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 corresponding prompt information is output to the operation object.

[0052] As an optional implementation, in the second aspect of the present application, the language conversion module generates a plurality of initial LINQ query statements according to the extension table, and determines the specific operation mode of the confidence parameter corresponding to each initial LINQ query statement according to the repetition number of each initial LINQ query statement, which includes:

[0053] According to the extension table, a plurality of derivative statements corresponding to the query request are generated;

[0054] All derivative statements are input into a pre-trained conversion model to obtain the initial LINQ query statement corresponding to each derivative statement output by the conversion model, and the repetition number of each initial LINQ query statement is counted;

[0055] According to the repetition number of each initial LINQ query statement, the confidence parameter corresponding to each initial LINQ query statement is determined, wherein the confidence parameter corresponding to each initial LINQ query statement is directly proportional to the repetition number.

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

[0057] The data acquisition module is configured to acquire a training data set before the language conversion module inputs all derivative statements into a pre-trained conversion model, wherein 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;

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

[0059] The statement extension module is configured to generate, for each target LINQ query statement, a plurality of derivative LINQ query statements of different structures based on the target LINQ query statement according to the target LINQ query statement;

[0060] The data integration module is configured to obtain a training instruction set including all the initial instructions and all the derivative instructions, and obtain a training LINQ query statement set matched with the training instruction set, wherein the LINQ query statement set includes all the target LINQ query statements and all the derivative LINQ query statements;

[0061] The model training module is configured to train a preset initial conversion model according to the training instruction set and the training LINQ query statement set matched with the training instruction set, to obtain a trained conversion model.

[0062] As an optional implementation form, in the second aspect, the device further comprises:

[0063] The query receiving module is configured to receive a to-be-converted LINQ query statement for the securities business management system, and generate extended LINQ query statements of multiple structures based on the to-be-converted LINQ query statement.

[0064] The table analysis module is configured to determine an initial table corresponding to the to-be-converted LINQ query statement according to the to-be-converted LINQ query statement, wherein the initial table comprises a plurality of table headers for indicating operation objects or operation contents.

[0065] The model analysis module is configured to input all the extended LINQ query statements into a pre-trained conversion model, to obtain initial query requests corresponding to each of the extended LINQ query statements output by the conversion model.

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

[0067] The table determination module is configured to, for each table header in the initial table, determine a weight parameter corresponding to each table content according to a repetition number of each table content corresponding to the table header, and determine a target table content corresponding to a weight parameter of the table header being the largest.

[0068] The query analysis module is 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.

[0069] As an optional implementation form, in the second aspect, the table determination module is configured to, for each table header in the initial table, determine a target table content corresponding to a weight parameter of the table header being the largest in the following manner:

[0070] For each table header in the initial table, the table determination module is configured to filter out a to-be-confirmed table content from a plurality of table contents corresponding to the table header, wherein the to-be-confirmed table content corresponds to a weight parameter being greater than or equal to a preset weight threshold; and if the number of the to-be-confirmed table contents is only one, the to-be-confirmed table content is confirmed as the target table content.

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

[0072] For all 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 application discloses another data management system of a securities business management system, and the system comprises:

[0074] a memory storing executable program codes;

[0075] a processor coupled with the memory;

[0076] The processor invokes the executable program codes stored in the memory to execute the data management method of the securities business management system disclosed in the first aspect of the present application.

[0077] The fourth aspect of the present application discloses a computer storage medium storing computer instructions, which are invoked to execute the data management method of the securities business management system disclosed in the first aspect of the present application.

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

[0079] The present application can process the original query request language by means of multiple table headers and multiple extended table contents corresponding to each table header, which enables the extended table to cover more meaning expressions, and then generates multiple initial LINQ query statements according to the multiple meaning expressions contained in the extended table, and determines the credibility parameters corresponding to each initial LINQ query statement according to the repetition number of each initial LINQ query statement. When determining the final LINQ query statement, the LINQ query statement corresponding to the query request is screened from the multiple initial LINQ query statements, and the final LINQ query statement meets the preset parameter screening condition, indicating that its accuracy is high, so that the query request given by the operation object can be accurately converted into the corresponding LINQ query statement. Finally, the LINQ query statement can meet the characteristics of diversified data, safe and stable data requirements and the like of the securities business management system, and can more efficiently complete the query operation. BRIEF DESCRIPTION OF DRAWINGS

[0080] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed in the embodiment description will be briefly introduced. Obviously, the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative labor.

[0081] Figure 1 is a flow diagram of a data management method of a securities business management system disclosed by an embodiment of the present application;

[0082] Figure 2 is a structural diagram of a data management device of a securities business management system disclosed by an embodiment of the present application;

[0083] Figure 3 is a structural diagram of a data management system of a securities business management system disclosed by an embodiment of the present application. DETAILED DESCRIPTION

[0084] In order to make the personnel in the art better understand the present application scheme, the technical scheme in the embodiment of the present application will be described clearly and completely below in combination with the drawings in the embodiment of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by the person skilled in the art without creative labor are within the scope of protection of the present application.

[0085] The terms "first", "second", and the like in the specification and claims of the present application and the above-mentioned drawings are used to distinguish different objects, not to describe a specific order. In addition, the terms "include" and "have" and any variations thereof are intended to cover non-exclusive inclusion. For example, a process, method, device, product or end including a series of steps or units is not limited to the listed steps or units, but can optionally include steps or units not listed, or can optionally include other steps or units inherent to the process, method, product or end.

[0086] In this paper, the phrase "embodiment" means that the specific features, structures or characteristics described in combination with the embodiment can be included in at least one embodiment of the present application. The appearance of this phrase in various places in the specification does not necessarily refer to the same embodiment, nor is it an independent or alternative embodiment to other embodiments. The person skilled in the art explicitly and implicitly understands that the embodiments described herein can be combined with other embodiments.

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

[0088] Embodiment one

[0089] Please refer to Figure 1 , Figure 1 is a flow diagram of a data management method of a securities business management system disclosed by an embodiment of the present application. Among them, Figure 1The data management method of the securities business management system can be used 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. The server can be a server used by a securities company or a server used by another company providing services for securities. The embodiment of the present application is not limited. As shown in the figure, the data management method of the securities business management system can include the following operations: Figure 1 The data management method of the securities business management system can include the following operations:

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

[0091] In the embodiment of the present application, the securities business management system is a key platform used by a securities company to manage and operate its core business. It covers customer information management, transaction execution, risk management, compliance monitoring, financial accounting and report generation, and other aspects, and provides support for the daily operation and decision-making of the securities company.

[0092] In the embodiment of the present application, the operation object can be a user or an upstream and downstream device of the securities business management system. The query request is used to represent various operation requests initiated by the operation object to the database of the securities business management system, such as basic business question and answer, basic database operation demand, add, delete, modify and query, multi-table association and partition establishment, etc. Alternatively, the query request refers to a request sent by a user or a system to the system in order 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, holding securities query, market data query, fund flow query, risk assessment query, order query, dividend distribution query, securities basic information query, user permission query, etc. It can also be a combination of the above various queries.

[0093] Step 102, filling the query request into a preset table template to obtain a table form language.

[0094] In the embodiment of the present application, the table template is a method for analyzing the language corresponding to the query request, which is proposed by the operation object, and is often a query description or similar query request operation instruction. The table template in the embodiment can set the table template according to different characteristics of the query request, for example, the establishment of the table template according to the grammatical role (subject, predicate, object, etc.) of each vocabulary in the query request; for another example, the establishment of the table template according to the part of speech (verb, noun, adjective, etc.) of different vocabularies in the query request. The table template is determined in advance for the data operation of the securities business management system, and the table form language can include a plurality of table headers for indicating the operation object or operation content and table contents corresponding to each table header; for example, the table header is different grammatical role or part of speech, and the table content corresponding to the table header is a specific vocabulary. Through the table form language, the query request can be analyzed more systematically and accurately, which is beneficial to subsequent recognition and conversion operations.

[0095] In the embodiment of the present application, optionally, different table templates can be 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 question and answer, basic database operation demand, addition, deletion, modification and query, multi-table association and partition establishment, before the query request is filled into the table template, the operation purpose of the query request is judged, and the corresponding table template is found.

[0096] Step 103, the table content corresponding to each table header of the table form language is expanded to obtain an expanded table.

[0097] In the embodiment of the present application, the optional expansion method includes:

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

[0099] Dictionary lookup method: finding the synonyms or synonyms of the vocabulary in the preset vocabulary library;

[0100] Context replacement method: finding synonyms or synonyms in combination with the context of the query request;

[0101] Root and affix method: analyzing the root and affix of the vocabulary, and finding the one with the same or similar root according to the meaning of the root;

[0102] Antonym method: first finding the antonym of the vocabulary, and then finding the antonym of the antonym, which may obtain new synonyms;

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

[0104] Superior and inferior word method: finding the superior word and inferior word of the vocabulary, so as to expand its semantic range. The superior word is a more general word, and the inferior word is a more specific and narrower word.

[0105] Word Sense Extension: According to the literal meaning of the word, extend its metaphorical meaning, symbolic meaning, etc.

[0106] Collocation Extension: Analyze the words commonly collocated with the word to expand its semantics.

[0107] Vocabulary Context Method: Combine the background of the securities industry where the word is located to understand its specific indicative connotation and expand its semantics.

[0108] (3) Word Association Method

[0109] Association Word Method: According to the relevance between words, such as "ocean" associated with "ships" "navigation" "marine life" etc.

[0110] Contextual Association: Imagine a specific context and think about the words related to the word that may appear in this context. For example, in the context of "risk operation", you may think of "money laundering" "high frequency" "cross-border" and other words.

[0111] (4) Word Sense Discrimination Method

[0112] Comparative Discrimination Method: Compare the word with other similar words, find out the subtle differences between them, and more accurately understand and expand its semantics.

[0113] Contextual Discrimination Method: Analyze the meaning of the word in different contexts and see how it changes in different situations to expand its semantics.

[0114] Step 104, according to the extension table, generate a plurality of initial LINQ query statements, and determine the credibility parameter corresponding to each initial LINQ query statement according to the repetition number of each initial LINQ query statement.

[0115] Step 104, according to the extension table, generate a plurality of initial LINQ query statements, and determine the credibility parameter corresponding to each initial LINQ query statement according to the repetition number of each initial LINQ query statement.

[0116] In the embodiment of the present application, the extension table is not simply to change one query request statement into multiple possible statements indicating the same or similar meaning, but to process the original query request statement by multiple table headers and multiple extended table contents corresponding to each table header. This processing enables the extension table to cover more meaning expressions. Then, according to the multiple meaning expressions contained in the extension table, multiple initial LINQ query statements are generated by using language conversion technology, and the repetition number of each LINQ query statement is counted. The repetition number actually indicates the number of the same meaning expression in the extension table. The more the repetition number, the more important the corresponding meaning expression. Therefore, the credibility parameter corresponding to each initial LINQ query statement can be determined according to the repetition number of each initial LINQ query statement.

[0117] In the embodiment of the present application, the specific operation of step 104 can include:

[0118] According to the extension table, multiple derived statements corresponding to the query request are generated. For example, different meaning expressions can be formed according to the extension table by permutation and combination, and each meaning expression corresponds to a derived statement.

[0119] All the derived statements are input into the pre-trained conversion model to obtain the initial LINQ query statement corresponding to each derived statement output by the conversion model, and the repetition number of each initial LINQ query statement is counted.

[0120] The credibility parameter corresponding to each initial LINQ query statement is determined according to the repetition number of each initial LINQ query statement, wherein the credibility parameter corresponding to each initial LINQ query statement is proportional to the repetition number.

[0121] Step 105, filtering the LINQ query statement corresponding to the query request from the multiple initial LINQ query statements.

[0122] In the embodiment of the present application, the credibility parameter corresponding to the LINQ query statement corresponding to the query request satisfies the preset parameter filtering condition. The credibility parameter measures the accuracy of a certain LINQ query statement through the repetition number, so it is necessary to filter the most accurate LINQ query statement from the multiple initial LINQ query statements. The preset parameter filtering condition can 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.

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

[0124] Filter the to-be-confirmed LINQ query statement from the plurality of initial LINQ query statements, the to-be-confirmed LINQ query statement corresponding to a credibility parameter greater than or equal to a preset credibility threshold; if the number of to-be-confirmed LINQ query statements is only one, the to-be-confirmed LINQ query statement is confirmed as the LINQ query statement corresponding to the query request.

[0125] In the optional embodiment, for the query request of the securities business management system, whether it can be converted into the corresponding LINQ query statement actually also needs to consider whether the query request is accurate and whether it has convertibility. When the credibility parameters of the initial LINQ query statements corresponding to the original query request language have multiple close values and no extreme value, it indicates that the original query request language cannot be converted into the LINQ query statement because of ambiguity and the like. Therefore, when determining the final LINQ query statement, the initial LINQ query statements with credibility parameters exceeding a certain value are first filtered as to-be-confirmed LINQ query statements, and if the number of to-be-confirmed LINQ query statements is only one, it indicates that the original query request has one LINQ query statement with a higher matching degree and no other ambiguity. Therefore, the to-be-confirmed LINQ query statement can be confirmed as the LINQ query statement corresponding to the query request.

[0126] In the embodiment of the application, optionally, if the number of to-be-confirmed LINQ query statements is greater than or equal to two, it indicates that the original query request has more than one LINQ query statement with a higher matching degree, indicating that there may be ambiguity, and it is determined that the query request does not have the corresponding LINQ query statement, and the corresponding prompt information is output to the operation object.

[0127] Step 106, obtaining the 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 the embodiment of the application, LINQ (Language Integrated Query) is a query technology integrated in a programming language, 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 the securities business management system, the application of LINQ query statements can bring many improvements. First, it can simplify the code of data query and operation, improve the development efficiency and code maintainability. Secondly, through the type safety feature of LINQ, errors in data query can be reduced, and the stability of the system can be improved. In addition, the rich operators of LINQ make complex business queries more intuitive, which helps to meet the diversified data query needs in securities business.

[0129] It can be seen that the embodiment of the present application can process the original query request language by means of multiple table headers and multiple extended table contents corresponding to each table header, which makes the extended table cover more meaning expressions, and then generates multiple initial LINQ query statements according to the multiple meaning expressions contained in the extended table, and determines the credibility parameters corresponding to each initial LINQ query statement 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 from the multiple initial LINQ query statements, and the final LINQ query statement meets the preset parameter screening condition, which indicates that its accuracy is higher, so that the query request given by the operation object can be accurately converted into the corresponding LINQ query statement. Finally, the LINQ query statement can meet the characteristics of diversified data, safe and stable data requirements and the like of the securities business management system, and can more efficiently complete the query operation.

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

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

[0132] For each initial instruction, a derived instruction semantically equivalent to the initial instruction is generated according to the initial instruction; for example, for the same query request, multiple query request expression forms are used. For example, for the query "get the bonus dividend of customer A", it can be expanded to "query the equity information of customer A", "query the profit distribution information of customer A", and different expression forms such as dividend distribution, dividend payment, shareholder dividend, cash dividend, stock dividend, equity distribution, dividend distribution, dividend distribution, and red stock payment, in order to increase the diversity of data and help the model better understand the semantics.

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

[0134] Obtaining a training instruction set, the training instruction set can include all initial instructions and all derived instructions;

[0135] obtaining a training LINQ query statement set matched with the training instruction set, the LINQ query statement set can include all target LINQ query statements and all derived LINQ query statements;

[0136] training a preset initial conversion model according to the training instruction set and the training LINQ query statement set matched with the training instruction set, to obtain a trained conversion model. The conversion model is used to realize conversion between a query request and a LINQ query statement, including outputting a corresponding LINQ query statement according to an input query request, and also including outputting a corresponding query request according to an input LINQ query statement. Since the training data set used by the conversion model includes the training instruction set and the training LINQ query statement set matched with the training instruction set, the conversion model can better understand 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 a corresponding LINQ query statement according to an input query request and outputting a corresponding query request according to an input LINQ query statement, the method can further include:

[0138] receiving a to-be-converted LINQ query statement for the securities business management system, and generating extended LINQ query statements of multiple structures based on the to-be-converted LINQ query statement. For example, according to the to-be-converted LINQ query statement, more LINQ query statements of different structures are added, such as adding conditions, returning different attributes, performing aggregation, sorting, limiting results, matching relationships, using optional matching, merging results, performing subqueries, and parameterized queries, so as to generate extended LINQ query statements of multiple structures based on the to-be-converted LINQ query statement. These extended LINQ query statements are all related to the to-be-converted LINQ query statement, and therefore contain the meaning expression of the to-be-converted LINQ query statement in multiple forms. Triggering the conversion of the conversion model by the meaning expression carried by the LINQ query statements in multiple forms can determine the most reasonable conversion result through multiple verifications.

[0139] determining an initial table corresponding to the to-be-converted LINQ query statement according to the to-be-converted LINQ query statement, wherein the initial table can include multiple table headers for indicating operation objects or operation contents; and the content of the table header is not filled in at this time, which is equivalent to establishing a table template for the to-be-converted LINQ query statement. Subsequently, multiple initial query requests can be filled into the table template to obtain a table form query request.

[0140] The input all extended LINQ query statements into the pre-trained conversion model, obtain the initial query request corresponding to each extended LINQ query statement output by the conversion model; fill all initial query requests into the initial table to obtain multiple table contents corresponding to each table header in the initial table; wherein, in the process of filling the initial query request into the initial table, a part of the content cannot be corresponded to the table header, then the filling operation is not performed, for example, some extended LINQ query statements actually add other structure statements on the basis of the to-be-converted LINQ query statement, so that the to-be-converted query request itself not only includes the meaning expression, but also includes other extended meaning expressions, and these extended meaning expressions are just eliminated in 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 number of each table content corresponding to the table header; and determine the table content corresponding to the maximum weight parameter of the table header as the target table content; according to the target table content corresponding to all table headers in the initial table, construct the query request corresponding to the to-be-converted LINQ query statement.

[0142] In this optional embodiment, the query request corresponding to the LINQ query statement is analyzed, and the application scenario can be: for the LINQ query statement triggered in the computer or sent by the upstream and downstream devices, since the whole operation is in the computer, it is difficult for the user or the management personnel to intuitively see the query request, therefore, converting these internal LINQ query statements into corresponding query requests can meet the intuitive viewing demand of the user or the management personnel.

[0143] In this optional embodiment, all initial query requests are filled into the initial table to obtain multiple table contents corresponding to each table header, for each table header corresponding to multiple table contents, this optional embodiment considers that the more the repetition number of the table content, the greater the weight parameter, and the table content with the greater weight parameter should be determined as the final table content, and finally the query request corresponding to the to-be-converted LINQ query statement is constructed according to the target table content corresponding to all table headers in the initial table. According to the to-be-converted LINQ query statement, this optional embodiment generates extended LINQ query statements of multiple structures based on the to-be-converted LINQ query statement, so that the conversion model converts the to-be-converted LINQ query statement in different situations, improves the recognition range of the model, and finally eliminates irrelevant information through the initial table and highlights the conversion result with higher weight, and finally determines the more accurate conversion result.

[0144] In this optional embodiment, further optionally, for each table header in the initial table, the table content corresponding to the maximum weight parameter of the table header is determined as the target table content, which can include: In this optional embodiment, further optionally, for each table header in the initial table, the table content corresponding to the maximum weight parameter of the table header is determined as the target table content, which can include:

[0145] For each table header in the initial table, the to-be-confirmed table content corresponding to the table header is screened out from the plurality of table contents corresponding to the table header, and the weight parameter corresponding to the to-be-confirmed table content is greater than or equal to the preset weight threshold. If the number of to-be-confirmed table contents is only one, the to-be-confirmed table content is confirmed as the target table content. Wherein, the number of to-be-confirmed table contents is only one, which means that there is only one table content with the highest matching degree with the LINQ query statement under the table header, and there is no other ambiguity, so the unique to-be-confirmed table content can be confirmed as the final target table content. In this optional embodiment, further optionally, for all table headers in the initial table, if the number of to-be-confirmed table contents corresponding to any table header in the initial table is greater than or equal to 2, it is determined that the to-be-converted LINQ query statement does not have a corresponding query request. Wherein, as long as the number of to-be-confirmed table contents corresponding to any table header is more than one, 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, so it is not necessary to consider the case of other table headers, and the to-be-converted LINQ query statement can be directly determined as not having a corresponding query request.

[0146] Embodiment two

[0147] Please refer to Figure 2 , Figure 2 is a structural schematic diagram of a data management device of a securities business management system disclosed by the embodiment of the present application. As shown in Figure 2 , the data management device of the securities business management system can include:

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

[0149] The first table filling module 202 is configured to fill the query request into a preset table template to obtain a table form language. The table template is determined in advance for data operation of the securities business management system, and the table form language can include a plurality of table headers for indicating operation objects or operation contents and table contents corresponding to each table header.

[0150] The table expansion module 203 is configured to expand the table contents corresponding to each table header of the table form language to obtain an expanded table.

[0151] The language conversion module 204 is configured to generate a plurality of initial LINQ query statements according to the expanded table, and determine a confidence parameter corresponding to each initial LINQ query statement according to the number of repetitions of each initial LINQ query statement.

[0152] The sentence screening module 205 is configured to screen the LINQ query statement corresponding to the query request from the plurality of initial LINQ query statements, wherein the LINQ query statement corresponding to the query request satisfies the preset parameter screening condition in terms of the credibility parameter.

[0153] The query execution module 206 is 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 optional embodiment, the specific operation mode of the sentence screening module 205 for screening the LINQ query statement corresponding to the query request from the plurality of initial LINQ query statements can include:

[0155] screening a to-be-confirmed LINQ query statement from the plurality of initial LINQ query statements, wherein the to-be-confirmed LINQ query statement satisfies the preset credibility threshold in terms of the credibility parameter;

[0156] if the number of the to-be-confirmed LINQ query statement is only one, confirming the to-be-confirmed LINQ query statement as the LINQ query statement corresponding to the query request;

[0157] if the number of the to-be-confirmed LINQ query statement is greater than or equal to two, determining that the query request does not have a corresponding LINQ query statement, and outputting corresponding prompt information to the operation object.

[0158] In another optional embodiment, the specific operation mode of the language conversion module 204 for generating the plurality of initial LINQ query statements according to the extension table and determining the credibility parameter corresponding to each initial LINQ query statement according to the repetition number of each initial LINQ query statement can include:

[0159] generating a plurality of derived sentences corresponding to the query request according to the extension table;

[0160] inputting all the derived sentences into a pre-trained conversion model to obtain the initial LINQ query statement corresponding to each derived sentence output by the conversion model, and counting the repetition number of each initial LINQ query statement;

[0161] determining the credibility parameter corresponding to each initial LINQ query statement according to the repetition number of each initial LINQ query statement, wherein the credibility parameter corresponding to each initial LINQ query statement is directly proportional to the repetition number.

[0162] In yet another optional embodiment, the device can further include:

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

[0164] an instruction expansion module, configured to generate, for each of the initial instructions, a derived instruction semantically equivalent to the initial instruction according to the initial instruction;

[0165] a statement expansion module, configured to generate, for each of the target LINQ query statements, a plurality of derived LINQ query statements of different 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, the training instruction set can include all the initial instructions and all the derived instructions; and obtain a training LINQ query statement set matched with the training instruction set, the LINQ query statement set can include all the target LINQ query statements and all the derived 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 matched with the training instruction set, to obtain a trained conversion model.

[0168] In yet another optional embodiment, the apparatus can 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 a plurality of expanded LINQ query statements of different structures based on 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, wherein the initial table can include a plurality of table headers for indicating operation objects or operation contents;

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

[0172] a second table filling module, configured to fill all the initial query requests into the initial table, to obtain a plurality of table contents corresponding to each of the table headers in the initial table;

[0173] The table determining module is configured to determine, for each table header in the initial table, a weight parameter corresponding to each table content according to a repetition number of the table content, and determine a table content with a maximum weight parameter corresponding to the table header as a target table content.

[0174] The query analysis module is 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.

[0175] In yet another optional embodiment, the specific operation manner of the table determining module for determining, for each table header in the initial table, a target table content with a maximum weight parameter corresponding to the table header can include:

[0176] For each table header in the initial table, the table determining module screens out a table content to be confirmed from the multiple table contents corresponding to the table header, the table content to be confirmed corresponding to a weight parameter greater than or equal to a preset weight threshold, and if the number of the table contents to be confirmed is only one, the table content to be confirmed is determined as the target table content.

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

[0178] 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 two, it is determined that the LINQ query statement to be converted does not have a corresponding query request.

[0179] Embodiment Three

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

[0181] a memory 301 storing executable program codes;

[0182] a processor 302 coupled with the memory 301;

[0183] The processor 302 invokes the executable program codes stored in the memory 301 to execute the steps in the data management method of the securities business management system described in Embodiment One of the present application.

[0184] Embodiment Four

[0185] The embodiment of the present application discloses a computer storage medium, which stores computer instructions, and the computer instructions are used to execute the steps in the data management method of the securities business management system described in the embodiment one when being invoked.

[0186] Embodiment five

[0187] The embodiment of the present application discloses a computer program product, which comprises a non-transitory computer readable storage medium storing a computer program, and the computer program is operable to make a computer execute the steps in the data management method of the securities business management system described in the embodiment one.

[0188] The above described device embodiments are only schematic, wherein the modules described as separated components may or may not be physically separated, and the components shown as modules may or may not be physical modules, i.e., may be located in one place or distributed on multiple network modules. Part or all of the modules can be selected according to actual needs to achieve the purpose of the embodiment scheme. Those skilled in the art can understand and implement without creative labor.

[0189] Through the specific description of the above embodiments, those skilled in the art can clearly understand that each embodiment can be realized by means of software and necessary general hardware platform, and of course can also be realized by hardware. Based on such understanding, the above technical solutions can be embodied in the form of software product, and the computer software product can be stored in a computer readable storage medium, and the storage medium includes read-only memory (Read-Only Memory, ROM), random access memory (Random Access Memory, RAM), programmable read-only memory (Programmable Read-only Memory, PROM), erasable programmable read-only memory (Erasable Programmable Read Only Memory, EEPROM), one-time programmable read-only memory (One-time Programmable Read-Only Memory, OTPROM), electrically erasable programmable read-only memory (Electrically-Erasable Programmable Read-Only Memory, EEPROM), compact disc read-only memory (Compact Disc Read-Only Memory, CD-ROM) or other optical disk storage, magnetic disk storage, magnetic tape storage, or any other computer readable medium capable of carrying or storing data.

[0190] Finally, it should be noted that the data management method and device of the security business management system, and the storage medium disclosed in the embodiments of the present application are only the preferred embodiments of the present application, and are used to illustrate the technical solutions of the present application, but not to limit them. Although the present application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that the technical solutions recorded in the foregoing embodiments can be modified, or some technical features can be replaced by equivalents. The modifications or replacements do not make the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present application.

Claims

1. A data management method for a securities business management system, characterized in that, The method includes: Receive query requests from the securities business management system based on the operation object; The query request is filled into a preset table template to obtain a tabular language; wherein the table template is predetermined for data operations of the securities business management system, and the tabular language includes multiple table headers for indicating the operation object or operation content and table content corresponding to each table header; Expand the table content corresponding to each header of the tabular form language to obtain an expanded table; Based on the extended table, multiple initial LINQ query statements are generated, and the confidence parameter corresponding to each initial LINQ query statement is determined according to the number of times each initial LINQ query statement is repeated. The LINQ query statement corresponding to the query request is selected from multiple initial LINQ query statements, wherein the confidence parameter of the LINQ query statement corresponding to the query request meets the preset parameter selection conditions. The query results are obtained from the database corresponding to the securities business management system based on 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 step of filtering the LINQ query statement corresponding to the query request from the plurality of initial LINQ query statements includes: LINQ query statements to be confirmed are selected from multiple initial LINQ query statements, wherein the confidence parameter of the LINQ query statement to be confirmed is greater than or equal to a preset confidence threshold. If there is only one LINQ query statement to be confirmed, then the LINQ query statement to be confirmed is the LINQ query statement corresponding to the query request. 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 the corresponding prompt information is output to the operation object.

3. The data management method of the securities business management system according to claim 1, characterized in that, The step of generating multiple initial LINQ query statements based on the expanded table, and determining the confidence parameter corresponding to each initial LINQ query statement based on the number of times each initial LINQ query statement is repeated, includes: Based on the extended table, generate multiple derived statements corresponding to the query request; Input all derived statements into the pre-trained transformation model to obtain the initial LINQ query statement corresponding to each derived statement output by the transformation model, and count the number of repetitions of each initial LINQ query statement; The confidence parameter corresponding to each initial LINQ query statement is determined based on the number of times each initial LINQ query statement is repeated, wherein the confidence parameter corresponding to each initial LINQ query statement is proportional to the number of repetitions.

4. The data management method of the securities business management system according to claim 3, characterized in that, Before inputting all derived statements into the pre-trained transformation model, the method further includes: Obtain a training dataset, which includes multiple initial instructions in the form of query requests and a target LINQ query statement corresponding to each initial instruction; For each initial instruction, a derived instruction semantically equivalent to the initial instruction is generated based on the initial instruction; For each target LINQ query, generate derived LINQ query statements with various structures based on the target LINQ query statement. A training instruction set is obtained, the training instruction set including all the initial instructions and all the derived instructions; A training LINQ query statement set matching the training instruction set is obtained, the LINQ query statement set including all the target LINQ query statements and all the derived LINQ query statements; The preset initial conversion model is trained based on the training instruction set and the training LINQ query statement set that matches the training instruction set, so as to obtain the 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: Receives a LINQ query statement to be converted for a securities business management system, and generates extended LINQ query statements with various structures based on the LINQ query statement to be converted. Based on the LINQ query statement to be converted, determine the initial table corresponding to the LINQ query statement to be converted, wherein the initial table includes multiple table headers for indicating the operation object or operation content; Input all the extended LINQ query statements into the pre-trained transformation model to obtain the initial query request corresponding to each of the extended LINQ query statements output by the transformation model; Fill all the initial query requests into the initial table to obtain the contents of multiple tables corresponding to each header in the initial table; For each header in the initial table, the weight parameter corresponding to each table content is determined based on the number of repetitions of each table content corresponding to that header; and the table content with the largest weight parameter corresponding to that header is determined as the target table content. Based on the target table content corresponding to all the headers in the initial table, construct the query request corresponding to the LINQ query statement to be converted.

6. The data management method of the securities business management system according to claim 5, characterized in that, The step of determining the content of the target table with the largest weight parameter corresponding to each header in the initial table includes: For each header in the initial table, select the table content to be confirmed from the multiple table contents corresponding to that header. The weight parameter corresponding to the table content to be confirmed is greater than or equal to a preset weight threshold. If there is only one table content to be confirmed, then confirm that 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 headers in the initial table, if there are two or more headers in the initial table corresponding to the content to be confirmed, then it is determined 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: The request receiving module is used to receive query requests from the operation object based on the securities business management system. The first table entry module 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 includes multiple table headers for indicating the operation object or operation content and table content corresponding to each table header; The table extension module is used to extend the table content corresponding to each table header of the table formal language to obtain an extended table; The language conversion module is used to generate multiple initial LINQ query statements based on the extended table, and to determine the confidence parameter corresponding to each initial LINQ query statement based on the number of repetitions of each initial LINQ query statement. The statement filtering module is used to filter out the LINQ query statement corresponding to the query request from multiple initial LINQ query statements, wherein the confidence parameter of the LINQ query statement corresponding to the query request meets the preset parameter filtering conditions. The query execution module is used to obtain query results from the database corresponding to the securities business management system based on 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 code; a processor coupled to the memory; the processor calling the executable program code stored in the memory to execute the data management method of the securities business management system as described in any one of claims 1-7.

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

Images