Data management method, device and storage medium of employee collaboration platform

Abstract

The present invention discloses a data management method and device, and a storage medium for an employee collaboration platform, and relates to the technical field of query language. The present invention processes the original query request language by means of multiple table headers plus multiple extended table contents corresponding to each table header, so that the extended table can cover more meaning expressions, and then generates multiple initial Cypher query statements based on the multiple meaning expressions, and determines the credibility parameter corresponding to each initial Cypher query statement based on the number of repetitions of each initial Cypher query statement. When determining the final Cypher query statement, the Cypher query statement corresponding to the query request is screened out from the multiple initial Cypher query statements, and the final Cypher query statement meets the preset parameter screening conditions, thereby accurately converting the query request given by the operation object into the corresponding Cypher query language. Finally, the use of the Cypher query language can well meet the query requirements of the graph structure database, and can efficiently and accurately complete the query operation.

Description

Technical Field

[0001] The present invention relates to the field of query language technology, and in particular to a data management method and device, and a storage medium for an employee collaboration platform. Background Art

[0002] The employee collaboration platform is an important tool for modern enterprises to improve team collaboration efficiency and promote information sharing. It provides employees with a centralized digital workspace that supports multiple functions such as task assignment, project management, file sharing, instant messaging and video conferencing. Through the platform, employees can understand project progress, assign tasks, share files, and communicate and collaborate efficiently in real time. This not only helps improve work efficiency, but also promotes information flow and knowledge sharing among team members, and enhances team cohesion and project execution.

[0003] In the employee collaboration platform, the relationships between data are intricate, and traditional relational databases have performance bottlenecks when processing such complex relational data. Graph-structured databases (such as Neo4j) came into being. They store data in the form of graphs, mainly composed of nodes, relationships, and properties. Nodes represent data entities, such as employees, projects, tasks, etc.; relationships represent connections between nodes, such as the collaborative relationship between employees, the relationship between employees and projects, etc.; properties are descriptions of nodes and relationships, which exist in the form of key-value pairs. For example, the properties of employee nodes can include name, position, etc.

[0004] Cypher is a declarative graph query language that can be used in Neo4j graph databases, etc. It describes the pattern and query conditions of graph data in an intuitive way, simplifying the query and operation of complex relational data. If the data in the employee collaboration platform is a graph structure, then the use of Cypher query language can well meet the query requirements of the graph structure database. However, the users or upstream and downstream devices of the employee collaboration platform cannot directly give a query language in the form of Cypher. At this time, it is necessary to accurately convert the query request given by the operation object into the corresponding Cypher query language. Therefore, it is necessary to propose a new data management method for the employee collaboration platform to accurately convert the query request given by the operation object into the corresponding Cypher query language. Summary of the invention

[0005] The present invention provides a data management method and device of an employee collaboration platform, and a storage medium, which are used to accurately convert a query request given by an operation object into a corresponding Cypher query language.

[0006] In order to solve the above technical problems, the first aspect of the present invention discloses a data management method for an employee collaboration platform, the method comprising:

[0007] Receive query requests output by the operation object based on the employee collaboration platform;

[0008] Filling the query request into a preset table template to obtain a table language; wherein the table template is predetermined for data operations on the employee collaboration platform, and the table language includes a plurality of table headers for indicating operation objects or operation contents and table contents corresponding to each table header;

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

[0010] Generate multiple initial Cypher query statements according to the extended table, and determine the credibility parameter corresponding to each initial Cypher query statement according to the number of repetitions of each initial Cypher query statement;

[0011] Filtering out a Cypher query statement corresponding to the query request from the multiple initial Cypher query statements, wherein a credibility parameter corresponding to the Cypher query statement corresponding to the query request satisfies a preset parameter screening condition;

[0012] A query result is obtained from a database corresponding to the employee collaboration platform according to a Cypher query statement corresponding to the query request, wherein the database corresponding to the employee collaboration platform is a graph structure database.

[0013] As an optional implementation, in the first aspect of the present invention, the filtering out the Cypher query statement corresponding to the query request from the multiple initial Cypher query statements includes:

[0014] Filtering out a Cypher query statement to be confirmed from the multiple initial Cypher query statements, wherein a credibility parameter corresponding to the Cypher query statement to be confirmed is greater than or equal to a preset credibility threshold;

[0015] If the number of the Cypher query statements to be confirmed is only one, confirming that the Cypher query statement to be confirmed is the Cypher query statement corresponding to the query request;

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

[0017] As an optional implementation, in the first aspect of the present invention, generating multiple initial Cypher query statements according to the extended table, and determining the credibility parameter corresponding to each initial Cypher query statement according to the number of repetitions of each initial Cypher query statement, includes:

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

[0019] Input all derived statements into a pre-trained conversion model, obtain an initial Cypher query statement corresponding to each derived statement output by the conversion model, and count the number of repetitions of each initial Cypher query statement;

[0020] The credibility parameter corresponding to each of the initial Cypher query statements is determined according to the number of repetitions of each of the initial Cypher query statements, wherein the credibility parameter corresponding to each of the initial Cypher query statements is proportional to the number of repetitions.

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

[0022] Acquire a training data set, wherein the training data set includes a plurality of initial instructions in the form of query requests and a target Cypher query statement corresponding to each of the initial instructions;

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

[0024] For each target Cypher query statement, generating, according to the target Cypher query statement, derivative Cypher query statements of multiple structures based on the target Cypher query statement;

[0025] Obtaining a training instruction set, wherein the training instruction set includes all the initial instructions and all the derived instructions;

[0026] Obtaining a training Cypher query statement set that matches the training instruction set, wherein the Cypher query statement set includes all the target Cypher query statements and all the derived Cypher query statements;

[0027] The preset initial conversion model is trained according to the training instruction set and the training Cypher query statement set matching the training instruction set to obtain a trained conversion model.

[0028] As an optional embodiment, in the first aspect of the present invention, the method further comprises:

[0029] Receiving a Cypher query statement to be converted for an employee collaboration platform, and generating, according to the Cypher query statement to be converted, extended Cypher query statements of multiple structures based on the Cypher query statement to be converted;

[0030] Determining an initial table corresponding to the Cypher query statement to be converted according to the Cypher query statement to be converted, wherein the initial table includes a plurality of table headers for indicating an operation object or an operation content;

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

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

[0033] For each table header in the initial table, determine the weight parameter corresponding to each table content according to the number of repetitions 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;

[0034] According to the target table contents corresponding to all the table headers in the initial table, a query request corresponding to the Cypher query statement to be converted is constructed.

[0035] 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:

[0036] For each table header in the initial table, filter out the table content to be confirmed 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, confirm that the table content to be confirmed is the target table content.

[0037] As an optional embodiment, in the first aspect of the present invention, the method further comprises:

[0038] 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 Cypher query statement to be converted does not have a corresponding query request.

[0039] A second aspect of the present invention discloses a data management device for an employee collaboration platform, the device comprising:

[0040] A request receiving module is used to receive a query request output by an operation object based on the employee collaboration platform;

[0041] A first table filling 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 on the employee collaboration platform, and the table form language includes a plurality of table headers for indicating operation objects or operation contents and table contents corresponding to each table header;

[0042] A table expansion module, used for expanding the table content corresponding to each table header of the table form language to obtain an extended table;

[0043] A language conversion module, used to generate a plurality of initial Cypher query statements according to the extended table, and determine a credibility parameter corresponding to each of the initial Cypher query statements according to the number of repetitions of each of the initial Cypher query statements;

[0044] A statement screening module, used to screen out a Cypher query statement corresponding to the query request from the multiple initial Cypher query statements, wherein the credibility parameter corresponding to the Cypher query statement corresponding to the query request satisfies a preset parameter screening condition;

[0045] The query execution module is used to obtain query results from the database corresponding to the employee collaboration platform according to the Cypher query statement corresponding to the query request, wherein the database corresponding to the employee collaboration platform is a graph structure database.

[0046] As an optional implementation, in the second aspect of the present invention, the specific operation mode of the statement screening module screening out the Cypher query statement corresponding to the query request from the multiple initial Cypher query statements includes:

[0047] Filtering out a Cypher query statement to be confirmed from the multiple initial Cypher query statements, wherein a credibility parameter corresponding to the Cypher query statement to be confirmed is greater than or equal to a preset credibility threshold;

[0048] If the number of the Cypher query statements to be confirmed is only one, confirming that the Cypher query statement to be confirmed is the Cypher query statement corresponding to the query request;

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

[0050] As an optional implementation, in the second aspect of the present invention, the language conversion module generates multiple initial Cypher query statements according to the extended table, and determines the specific operation mode of the credibility parameter corresponding to each initial Cypher query statement according to the number of repetitions of each initial Cypher query statement, including:

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

[0052] Input all derived statements into a pre-trained conversion model, obtain an initial Cypher query statement corresponding to each derived statement output by the conversion model, and count the number of repetitions of each initial Cypher query statement;

[0053] The credibility parameter corresponding to each of the initial Cypher query statements is determined according to the number of repetitions of each of the initial Cypher query statements, wherein the credibility parameter corresponding to each of the initial Cypher query statements is proportional to the number of repetitions.

[0054] As an optional embodiment, in the second aspect of the present invention, the device further includes:

[0055] A data acquisition module, used for acquiring a training data set before the language conversion module inputs all derived 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 a target Cypher query statement corresponding to each of the initial instructions;

[0056] An instruction extension module, for generating, for each of the initial instructions, a derivative instruction semantically equivalent to the initial instruction according to the initial instruction;

[0057] A statement extension module, for generating, for each target Cypher query statement, derived Cypher query statements of various structures based on the target Cypher query statement according to the target Cypher query statement;

[0058] A data integration module is used to obtain a training instruction set, wherein the training instruction set includes all the initial instructions and all the derived instructions; obtain a training Cypher query statement set matching the training instruction set, wherein the Cypher query statement set includes all the target Cypher query statements and all the derived Cypher query statements;

[0059] The model training module is used to train the preset initial conversion model according to the training instruction set and the training Cypher query statement set matching the training instruction set to obtain a trained conversion model.

[0060] As an optional embodiment, in the second aspect of the present invention, the device further includes:

[0061] A query receiving module, used for receiving a Cypher query statement to be converted for the employee collaboration platform, and generating, according to the Cypher query statement to be converted, an extended Cypher query statement of multiple structures based on the Cypher query statement to be converted;

[0062] A table analysis module, used for determining an initial table corresponding to the Cypher query statement to be converted according to the Cypher query statement to be converted, wherein the initial table includes a plurality of table headers for indicating an operation object or an operation content;

[0063] A model analysis module, used for inputting all the extended Cypher query statements into a pre-trained conversion model, and obtaining an initial query request corresponding to each of the extended Cypher query statements output by the conversion model;

[0064] The 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;

[0065] A table determination module is used to determine, for each table header in the initial table, a weight parameter corresponding to each table content according to the number of repetitions 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;

[0066] The query analysis module is used to construct a query request corresponding to the Cypher query statement to be converted according to the target table content corresponding to all the table headers in the initial table.

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

[0068] For each table header in the initial table, filter out the table content to be confirmed 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, confirm that the table content to be confirmed is the target table content.

[0069] As an optional implementation, in the second aspect of the present invention, the table determination module is further used for:

[0070] 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 Cypher query statement to be converted does not have a corresponding query request.

[0071] A third aspect of the present invention discloses another data management system for an employee collaboration platform, the system comprising:

[0072] A memory storing executable program code;

[0073] a processor coupled to the memory;

[0074] The processor calls the executable program code stored in the memory to execute the data management method for the employee collaboration platform disclosed in the first aspect of the present invention.

[0075] A fourth aspect of the present invention discloses a computer storage medium, wherein the computer storage medium stores computer instructions, and when the computer instructions are called, they are used to execute the data management method of the employee collaboration platform disclosed in the first aspect of the present invention.

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

[0077] The present invention can process the original query request language by adding multiple table headers to each table header corresponding to multiple extended table contents. This processing enables the extended table to cover more meaning expressions, and then generates multiple initial Cypher query statements based on the multiple meaning expressions contained in the extended table, and determines the credibility parameter corresponding to each initial Cypher query statement based on the number of repetitions of each initial Cypher query statement. When determining the final Cypher query statement, the Cypher query statement corresponding to the query request is screened out from the multiple initial Cypher query statements. The final Cypher query statement meets the preset parameter screening conditions, indicating that it has high accuracy, thereby accurately converting the query request given by the operation object into the corresponding Cypher query language. Finally, the use of the Cypher query language can well meet the query requirements of the graph structure database, and can efficiently and accurately complete the query operation. BRIEF DESCRIPTION OF THE DRAWINGS

[0078] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0079] Figure 1 It is a flow chart of a data management method for an employee collaboration platform disclosed in an embodiment of the present invention;

[0080] Figure 2 It is a structural schematic diagram of a data management device for an employee collaboration platform disclosed in an embodiment of the present invention;

[0081] Figure 3 It is a structural diagram of a data management system of an employee collaboration platform disclosed in an embodiment of the present invention. DETAILED DESCRIPTION

[0082] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0083] 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 "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions. 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 may optionally include steps or units that are not listed, or may optionally include other steps or units inherent to these processes, methods, products or ends.

[0084] Reference to "embodiments" herein means that a particular feature, structure, or characteristic described in conjunction with the embodiments may be included in at least one embodiment of the present invention. The appearance of the phrase in various places in the specification does not necessarily refer to the same embodiment, nor is it an independent or alternative embodiment that is mutually exclusive with other embodiments. It is explicitly and implicitly understood by those skilled in the art that the embodiments described herein may be combined with other embodiments.

[0085] The invention discloses a data management method and device of an employee collaboration platform, and a storage medium, which are used for accurately converting a query request given by an operation object into a corresponding Cypher query language.

[0086] Embodiment 1

[0087] See also Figure 1 , Figure 1 It is a flow chart of a data management method of an employee collaboration platform disclosed in an embodiment of the present invention. Figure 1 The data management method of the employee collaboration platform described can be used in the data management device of the employee collaboration platform. The data management device of the employee collaboration platform can be integrated in a cloud server or a local server. These servers can be servers used by securities companies or servers used by other companies that provide services to securities companies. The embodiments of the present invention are not limited thereto. Figure 1 As shown, the data management method of the employee collaboration platform may include the following operations:

[0088] Step 101: Receive a query request output by an operation object based on an employee collaboration platform.

[0089] In the embodiment of the present invention, the employee collaboration platform provides employees with a centralized digital workspace that supports multiple functions such as task assignment, project management, file sharing, instant messaging, and video conferencing. Through the platform, employees can understand project progress, assign tasks, share files, and communicate and collaborate efficiently in real time. In the employee collaboration platform, the relationship between data is intricate, and traditional relational databases have performance bottlenecks when processing such complex relational data. Therefore, in the embodiment of the present invention, the database corresponding to the employee collaboration platform is a graph structure database, which stores data in the form of a graph and is mainly composed of nodes, relationships, and properties. Nodes represent data entities, such as employees, projects, tasks, etc.; relationships represent connections between nodes, such as collaborative relationships between employees, relationships between employees and projects, etc.; properties are descriptions of nodes and relationships, which exist in the form of key-value pairs. For example, the properties of employee nodes can include name and position.

[0090] In an embodiment of the present invention, the operation object may be a user or upstream and downstream device of the employee collaboration platform, and the query request is used to represent various operation requests initiated by the operation object against the database of the employee collaboration platform, such as basic business questions and answers, basic database operation requirements, addition, deletion, modification, query, multi-table association, and partition establishment. Optionally, the query request may be any data query-related request output by the user through the interface or API of the employee collaboration platform. These requests are usually for obtaining specific information or data for analysis, decision-making, or execution of certain operations. For example, the query request may be used for the following operations: (1) Finding information about a specific employee; (2) Finding participants in a project; (3) Finding the completion status of tasks within a certain time period; (5) Finding the collaborative relationship of an employee; (6) Finding the task dependencies of a project; (7) Finding the skills and certifications of an employee; (8) Finding the budget usage of a department.

[0091] Step 102: Fill the query request into a preset table template to obtain a table form language.

[0092] In an embodiment of the present invention, a table template is a method disclosed in the present invention for disassembling and analyzing the language corresponding to a query request. The query request is proposed by an operation object, which is often a query description or an operation instruction similar to a query request. The table template in this embodiment can be set according to different characteristics of the query request. For example, a table template is established according to the grammatical function (subject, predicate, object, etc.) of each word in the query request; for another example, a 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 data operations on the employee collaboration platform, and the table form language may include multiple table headers for indicating the operation object or operation content and table contents corresponding to each table header; for example, the table header is a different grammatical function or part of speech, and the table content corresponding to the table header is a specific word. Through the table form language, a more systematic and accurate analysis of the query request can be performed, which is conducive to subsequent recognition and conversion operations.

[0093] 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.

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

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

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

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

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

[0099] 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;

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

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

[0102] 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.

[0103] Extended meaning: Based on the literal meaning of a word, its metaphorical meaning, symbolic meaning, etc. are extended;

[0104] Collocation expansion method: Analyze the words that are often collocated with each other to expand their semantics.

[0105] Lexical background method: Combine the industry background of the vocabulary to understand its specific connotation and thus expand its semantics;

[0106] (3) Vocabulary Association Method

[0107] Relational vocabulary: expand based on the relevance between words, such as "ocean" is related to "ship", "sailing", "marine life", etc.;

[0108] Situational association: Imagine a specific situation and think about the words related to the word that may appear in this situation. For example, in the context of "project settlement", you may think of words such as "summary", "conclusion", and "liquidation".

[0109] (4) Word meaning analysis

[0110] Comparative analysis: compare the word with other similar words to find out the subtle differences between them, so as to understand and expand its meaning more accurately;

[0111] Contextual analysis method: Analyze the meaning of the word in different contexts to see how it changes in different situations, thereby expanding its semantics.

[0112] Step 104: Generate multiple initial Cypher query statements according to the extended table, and determine the credibility parameter corresponding to each initial Cypher query statement according to the number of repetitions of each initial Cypher query statement.

[0113] In the embodiment 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, but processes the original query request statement by adding multiple table headers and multiple table contents corresponding to each table header. This processing enables the extended table to cover more meaning expressions, and then, based on the multiple meaning expressions contained in the extended table, a language conversion technology is used to generate multiple initial Cypher query statements, and the number of repetitions of each Cypher query statement is counted. The number of repetitions actually indicates the number of times the same meaning expression is used in the extended table. The more repetitions, the more important the corresponding meaning expression is. Therefore, the credibility parameter corresponding to each initial Cypher query statement can be determined according to the number of repetitions of each initial Cypher query statement.

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

[0115] According to the extended table, multiple derived statements corresponding to the query request are generated; for example, different meaning expressions can be formed according to the extended table in a permutation and combination manner, and each meaning expression corresponds to a derived statement.

[0116] Input all derived statements into the pre-trained conversion model, obtain the initial Cypher query statement corresponding to each derived statement output by the conversion model, and count the number of repetitions of each initial Cypher query statement;

[0117] A credibility parameter corresponding to each initial Cypher query statement is determined according to the number of repetitions of each initial Cypher query statement, wherein the credibility parameter corresponding to each initial Cypher query statement is proportional to the number of repetitions.

[0118] Step 105: Filter out a Cypher query statement corresponding to the query request from the multiple initial Cypher query statements.

[0119] In the embodiment of the present invention, the credibility parameter corresponding to the Cypher query statement corresponding to the query request satisfies the preset parameter screening condition; the credibility parameter measures the accuracy of a Cypher query statement by the number of repetitions, therefore, it is necessary to screen out the most accurate Cypher query statement from multiple initial Cypher query statements. 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 value range.

[0120] In an optional embodiment, filtering out a Cypher query statement corresponding to the query request from a plurality of initial Cypher query statements may include:

[0121] A Cypher query statement to be confirmed is screened out from multiple initial Cypher query statements, and a credibility parameter corresponding to the Cypher query statement to be confirmed is greater than or equal to a preset credibility threshold; if the number of the Cypher query statement to be confirmed is only one, the Cypher query statement to be confirmed is confirmed to be the Cypher query statement corresponding to the query request.

[0122] In this optional embodiment, whether the query request for the employee collaboration platform can be converted into a corresponding Cypher query statement actually also needs to consider whether the query request is accurate and whether it is convertible. When the credibility parameters of the initial Cypher query statement corresponding to the original language have multiple close values ​​and no extreme values, it means that the original natural statement cannot be converted into a Cypher query statement due to ambiguity and other reasons. Therefore, when determining the final Cypher query statement, it is first necessary to screen out the initial Cypher query statements whose credibility parameters exceed a certain value as the Cypher query statements to be confirmed. If the number of Cypher query statements to be confirmed is only 1, it means that the original query request has a Cypher query statement with a higher matching degree, and there is no other ambiguity. Therefore, it can be confirmed that the Cypher query statement to be confirmed is the Cypher query statement corresponding to the query request.

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

[0124] Step 106: Obtain query results from a database corresponding to the employee collaboration platform according to the Cypher query statement corresponding to the query request.

[0125] In the embodiment of the present invention, the database corresponding to the employee collaboration platform is a graph structure database. Cypher is a declarative graph query language that can be used in Neo4j graph databases, etc. It describes the pattern and query conditions of graph data in an intuitive way, simplifying the query and operation of complex relational data. In the embodiment of the present invention, the data in the employee collaboration platform is a graph structure, so the use of Cypher query language can well meet the query requirements of the graph structure database, and can complete the query operation very efficiently and accurately to obtain the query (including obtaining data and performing operations) results.

[0126] It can be seen that the embodiment of 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, and then generates multiple initial Cypher query statements based on the multiple meaning expressions contained in the extended table, and determines the credibility parameter corresponding to each initial Cypher query statement based on the number of repetitions of each initial Cypher query statement. When determining the final Cypher query statement, the Cypher query statement corresponding to the query request is screened out from the multiple initial Cypher query statements. The final Cypher query statement meets the preset parameter screening conditions, indicating that it has a high accuracy, thereby accurately converting the query request given by the operation object into the corresponding Cypher query language. Finally, the use of the Cypher query language can well meet the query requirements of the graph structure database, and can efficiently and accurately complete the query operation.

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

[0128] Obtain a training data set, where the training data set may include multiple initial instructions in the form of query requests and a target Cypher query statement corresponding to each initial instruction;

[0129] For each initial instruction, a derivative instruction with semantic equivalent to the initial instruction is generated based on the initial instruction; for example, for the same query request, multiple query request expressions are used. For example, for the query "obtain the task dependency of project A", it can be expanded to "query the task allocation of project A" and "query the personnel division of project A" and other different expressions to increase the diversity of data and help the model better understand semantics.

[0130] For each target Cypher query statement, generate derivative Cypher query statements of various structures based on the target Cypher query statement according to the target Cypher query statement; optionally, for the target Cypher query statement, generate derivative Cypher query statements of various structures from a basic target Cypher query statement by adding conditions, returning different attributes, aggregating, sorting, limiting results, matching relationships, using optional matching, merging results, performing subqueries and parameterized queries, etc.

[0131] Obtaining a training instruction set, which may include all initial instructions and all derived instructions;

[0132] Obtaining a training Cypher query statement set that matches the training instruction set, where the Cypher query statement set may include all target Cypher query statements and all derived Cypher query statements;

[0133] The preset initial conversion model is trained according to the training instruction set and the training Cypher query statement set matching the training instruction set to obtain a trained conversion model. The conversion model is used to realize the conversion between the query request and the Cypher query statement, including outputting the corresponding Cypher query statement according to the input query request, and also including outputting the corresponding query request according to the input Cypher query statement. Since the training data set used by the conversion model includes the training instruction set and the training Cypher query statement set matching 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.

[0134] In an optional embodiment, since the function of the conversion model includes both outputting a corresponding Cypher query statement according to an input query request and outputting a corresponding query request according to an input Cypher query statement, the method may further include:

[0135] Receive a Cypher query statement to be converted for the employee collaboration platform, and generate, based on the Cypher query statement to be converted, a plurality of extended Cypher query statements of structures based on the Cypher query statement to be converted; for example, based on the Cypher query statement to be converted, add more Cypher query statements of different structures, such as by adding conditions, returning different attributes, performing aggregation, sorting, limiting results, matching relationships, using optional matching, merging results, performing subqueries and parameterized queries, etc., thereby generating a plurality of extended Cypher query statements of structures based on the Cypher query statement to be converted, and these extended Cypher query statements are all related to the Cypher query statement to be converted, and therefore contain the meaning expression of the Cypher query statement to be converted in a plurality of forms. By triggering the conversion of the conversion model with the meaning expression carried by the Cypher query statements in a plurality of forms, the most reasonable conversion result can be determined through multiple verifications.

[0136] According to the Cypher query statement to be converted, an initial table corresponding to the Cypher query statement to be converted is determined, wherein the initial table may include multiple table headers for indicating operation objects or operation contents; wherein the contents of the table headers are not filled in temporarily, which is equivalent to establishing a table template for the Cypher query statement to be converted, and subsequently filling multiple initial query requests into the table template to obtain query requests in a table form.

[0137] Input all extended Cypher query statements into the pre-trained conversion model to obtain the initial query request corresponding to each extended Cypher query statement output by the conversion model; fill all the 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, if a part of the content cannot correspond to the table header, the filling operation is not performed. For example, some extended Cypher query statements are actually statements with other structures added on the basis of the Cypher query statement to be converted, which not only contain the meaning expression of the query request to be converted itself, but also include other extended meaning expressions, which are just eliminated in the process of filling in the initial table.

[0138] For each table header in the initial table, determine the weight parameter corresponding to each table content according to the number of repetitions of each table content corresponding to the table header; and determine that the table content with the largest weight parameter corresponding to the table header is the target table content; and construct a query request corresponding to the Cypher query statement to be converted according to the target table content corresponding to all the table headers in the initial table.

[0139] In this optional embodiment, the corresponding query request is analyzed by Cypher query statements. The application scenario may be: for Cypher query statements triggered inside the computer or sent by upstream and downstream devices, since the entire operation is performed inside the computer, it is difficult for users or managers to intuitively see the query request. Therefore, converting these internal Cypher query statements into corresponding query requests can meet the intuitive viewing needs of users or managers.

[0140] In this optional embodiment, all initial query requests are filled into the initial table to obtain multiple table contents corresponding to each table header in the initial table. For each table header, the multiple table contents corresponding to each table header are considered to be the table contents with greater weight parameters. The table contents with greater weight parameters should be determined as the final table contents. Finally, the query request corresponding to the Cypher query statement to be converted is constructed according to the target table contents corresponding to all table headers in the initial table. This optional embodiment generates extended Cypher query statements of various structures based on the Cypher query statement to be converted according to the Cypher query statement to be converted, so that the conversion model converts the Cypher query statement to be converted under different circumstances, thereby improving the recognition range of the model. Finally, irrelevant information is eliminated through the initial table, and conversion results with higher weights are highlighted, so as to finally determine a more accurate conversion result.

[0141] 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:

[0142] 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 Cypher 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 Cypher 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 Cypher 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 Cypher query statement to be converted does not have a corresponding query request.

[0143] Embodiment 2

[0144] See also Figure 2 , Figure 2 Schematic diagram of a data management device for an employee collaboration platform disclosed in an embodiment of the present invention. Figure 2 As shown, the data management device of the employee collaboration platform may include:

[0145] The request receiving module 201 is used to receive the query request output by the operation object based on the employee collaboration platform;

[0146] The first form filling module 202 is used to fill the query request into a preset form template to obtain a form language; wherein the form template is predetermined for data operations on the employee collaboration platform, and the form language may include multiple table headers for indicating operation objects or operation contents and table contents corresponding to each table header;

[0147] Table expansion module 203, used to expand the table content corresponding to each table header of the table form language to obtain an expanded table;

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

[0149] A statement screening module 205 is used to screen out a Cypher query statement corresponding to the query request from the multiple initial Cypher query statements, wherein the credibility parameter corresponding to the Cypher query statement corresponding to the query request satisfies a preset parameter screening condition;

[0150] The query execution module 206 is used to obtain query results from a database corresponding to the employee collaboration platform according to a Cypher query statement corresponding to the query request, wherein the database corresponding to the employee collaboration platform is a graph structure database.

[0151] In an optional embodiment, the specific operation of the statement screening module 205 screening out the Cypher query statement corresponding to the query request from the multiple initial Cypher query statements may include:

[0152] Filtering out a Cypher query statement to be confirmed from the multiple initial Cypher query statements, where a credibility parameter corresponding to the Cypher query statement to be confirmed is greater than or equal to a preset credibility threshold;

[0153] If the number of Cypher query statements to be confirmed is only one, confirm that the Cypher query statement to be confirmed is the Cypher query statement corresponding to the query request;

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

[0155] In another optional embodiment, the language conversion module 204 generates multiple initial Cypher query statements according to the extended table, and determines the specific operation mode of the credibility parameter corresponding to each initial Cypher query statement according to the number of repetitions of each initial Cypher query statement, which may include:

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

[0157] Input all derived statements into the pre-trained conversion model, obtain the initial Cypher query statement corresponding to each derived statement output by the conversion model, and count the number of repetitions of each initial Cypher query statement;

[0158] A credibility parameter corresponding to each initial Cypher query statement is determined according to the number of repetitions of each initial Cypher query statement, wherein the credibility parameter corresponding to each initial Cypher query statement is proportional to the number of repetitions.

[0159] In yet another optional embodiment, the device may further include:

[0160] A data acquisition module, used for acquiring a training data set before the language conversion module 204 inputs all derived statements into the pre-trained conversion model, wherein the training data set may include a plurality of initial instructions in the form of query requests and a target Cypher query statement corresponding to each initial instruction;

[0161] An instruction extension module, for generating, for each initial instruction, a derivative instruction semantically equivalent to the initial instruction according to the initial instruction;

[0162] A statement extension module, for generating, for each target Cypher query statement, derived Cypher query statements of various structures based on the target Cypher query statement according to the target Cypher query statement;

[0163] The data integration module is used to obtain a training instruction set, which may include all initial instructions and all derived instructions; obtain a training Cypher query statement set matching the training instruction set, which may include all target Cypher query statements and all derived Cypher query statements;

[0164] The model training module is used to train the preset initial conversion model according to the training instruction set and the training Cypher query statement set matching the training instruction set to obtain the trained conversion model.

[0165] In yet another optional embodiment, the device may further include:

[0166] A query receiving module, used for receiving a Cypher query statement to be converted for the employee collaboration platform, and generating, according to the Cypher query statement to be converted, an extended Cypher query statement of multiple structures based on the Cypher query statement to be converted;

[0167] A table analysis module, used to determine an initial table corresponding to the Cypher query statement to be converted according to the Cypher query statement to be converted, wherein the initial table may include a plurality of table headers for indicating an operation object or operation content;

[0168] The model analysis module is used to input all extended Cypher query statements into the pre-trained conversion model to obtain the initial query request corresponding to each extended Cypher query statement output by the conversion model;

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

[0170] A table determination module is used to determine, for each table header in the initial table, a weight parameter corresponding to each table content according to the number of repetitions 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;

[0171] The query analysis module is used to construct a query request corresponding to the Cypher query statement to be converted according to the target table content corresponding to all the table headers in the initial table.

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

[0173] For each table header in the initial table, filter out the table content to be confirmed 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, confirm that the table content to be confirmed is the target table content.

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

[0175] 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 Cypher query statement to be converted does not have a corresponding query request.

[0176] Embodiment 3

[0177] See also Figure 3 , Figure 3 Schematic diagram of the structure of a data management system of an employee collaboration platform disclosed in an embodiment of the present invention. Figure 3 As shown, the data management system of the employee collaboration platform may include:

[0178] A memory 301 storing executable program codes;

[0179] a processor 302 coupled to the memory 301;

[0180] The processor 302 calls the executable program code stored in the memory 301 to execute the steps of the data management method of the employee collaboration platform described in the first embodiment of the present invention.

[0181] Embodiment 4

[0182] An embodiment of the present invention discloses a computer storage medium, which stores computer instructions. When the computer instructions are called, they are used to execute the steps in the data management method of the employee collaboration platform described in the first embodiment of the present invention.

[0183] Embodiment 5

[0184] An embodiment of the present invention discloses a computer program product, which includes a non-transitory computer-readable storage medium storing a computer program, and the computer program is operable to enable a computer to execute the steps in the data management method for an employee collaboration platform described in Embodiment 1.

[0185] The device embodiments described above are only illustrative, wherein the modules described as separate components may or may not be physically separated, and the components displayed as modules may or may not be physical modules, i.e., they may be located in one place, or they may be distributed on multiple network modules. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Those of ordinary skill in the art may understand and implement it without creative work.

[0186] Through the specific description of the above embodiments, those skilled in the art can clearly understand that each implementation method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be implemented by hardware. Based on such an understanding, the above technical solution can be essentially or the part that contributes to the prior art can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, and the storage medium includes a read-only memory (ROM), a random access memory (RAM), a programmable read-only memory (PROM), an erasable programmable read-only memory (EPROM), a one-time programmable read-only memory (OTPROM), an electronically erasable programmable read-only memory (EEPROM), a compact disc (CD-ROM) or other optical disc storage, magnetic disk storage, magnetic tape storage, or any other computer-readable medium that can be used to carry or store data.

[0187] Finally, it should be noted that the data management method, device, and storage medium of an employee collaboration platform disclosed in the embodiments of the present invention disclose only the preferred embodiments of the present invention, which are only used to illustrate the technical solution of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features may be replaced by equivalents. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A data management method for an employee collaboration platform, characterized in that: The method comprises: Receive query requests output by the operation object based on the employee collaboration platform; Filling the query request into a preset table template to obtain a table language; wherein the table template is predetermined for data operations on the employee collaboration platform, and the table language includes a plurality of table headers for indicating operation objects or operation contents and table contents corresponding to each table header; Expanding the table content corresponding to each table header of the table form language to obtain an extended table; Generate multiple initial Cypher query statements according to the extended table, and determine the credibility parameter corresponding to each initial Cypher query statement according to the number of repetitions of each initial Cypher query statement; Filtering out a Cypher query statement corresponding to the query request from the multiple initial Cypher query statements, wherein a credibility parameter corresponding to the Cypher query statement corresponding to the query request satisfies a preset parameter screening condition; A query result is obtained from a database corresponding to the employee collaboration platform according to a Cypher query statement corresponding to the query request, wherein the database corresponding to the employee collaboration platform is a graph structure database.

2. The data management method of the employee collaboration platform according to claim 1 is characterized in that: The step of filtering out a Cypher query statement corresponding to the query request from the plurality of initial Cypher query statements includes: Filtering out a Cypher query statement to be confirmed from the multiple initial Cypher query statements, wherein a credibility parameter corresponding to the Cypher query statement to be confirmed is greater than or equal to a preset credibility threshold; If the number of the Cypher query statements to be confirmed is only one, confirming that the Cypher query statement to be confirmed is the Cypher query statement corresponding to the query request; If the number of the Cypher query statements to be confirmed is greater than or equal to 2, it is determined that the query request does not have a corresponding Cypher query statement, and corresponding prompt information is output to the operation object.

3. The data management method of the employee collaboration platform according to claim 1, characterized in that: The step of generating a plurality of initial Cypher query statements according to the extended table, and determining a credibility parameter corresponding to each initial Cypher query statement according to the number of repetitions of each initial Cypher query statement, includes: Generating a plurality of derived statements corresponding to the query request according to the extended table; Input all derived statements into a pre-trained conversion model, obtain an initial Cypher query statement corresponding to each derived statement output by the conversion model, and count the number of repetitions of each initial Cypher query statement; The credibility parameter corresponding to each of the initial Cypher query statements is determined according to the number of repetitions of each of the initial Cypher query statements, wherein the credibility parameter corresponding to each of the initial Cypher query statements is proportional to the number of repetitions.

4. The data management method of the employee collaboration platform according to claim 3 is characterized in that: Before inputting all derived sentences into the pre-trained conversion model, the method further includes: Acquire a training data set, wherein the training data set includes a plurality of initial instructions in the form of query requests and a target Cypher query statement corresponding to each of the initial instructions; For each of the initial instructions, generating a derivative instruction semantically equivalent to the initial instruction according to the initial instruction; For each target Cypher query statement, generating, according to the target Cypher query statement, derivative Cypher query statements of multiple structures based on the target Cypher query statement; Obtaining a training instruction set, wherein the training instruction set includes all the initial instructions and all the derived instructions; Obtaining a training Cypher query statement set that matches the training instruction set, wherein the Cypher query statement set includes all the target Cypher query statements and all the derived Cypher query statements; The preset initial conversion model is trained according to the training instruction set and the training Cypher query statement set matching the training instruction set to obtain a trained conversion model.

5. The data management method of the employee collaboration platform according to claim 3 is characterized in that: The method further comprises: Receiving a Cypher query statement to be converted for an employee collaboration platform, and generating, according to the Cypher query statement to be converted, extended Cypher query statements of multiple structures based on the Cypher query statement to be converted; Determining an initial table corresponding to the Cypher query statement to be converted according to the Cypher query statement to be converted, wherein the initial table includes a plurality of table headers for indicating an operation object or an operation content; Input all the extended Cypher query statements into a pre-trained conversion model to obtain an initial query request corresponding to each of the extended Cypher 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 table header in the initial table; For each table header in the initial table, determine the weight parameter corresponding to each table content according to the number of repetitions 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; According to the target table contents corresponding to all the table headers in the initial table, a query request corresponding to the Cypher query statement to be converted is constructed.

6. The data management method of the employee collaboration platform according to claim 5 is characterized in that: 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: For each table header in the initial table, filter out the table content to be confirmed 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, confirm that the table content to be confirmed is the target table content.

7. The data management method of the employee collaboration platform according to claim 6, characterized in that: The method further comprises: 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 Cypher query statement to be converted does not have a corresponding query request.

8. A data management device for an employee collaboration platform, characterized in that: The device includes: A request receiving module is used to receive a query request output by an operation object based on the employee collaboration platform; A first table filling 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 on the employee collaboration platform, and the table form language includes a plurality of table headers for indicating operation objects or operation contents and table contents corresponding to each table header; A table expansion module, used for expanding the table content corresponding to each table header of the table form language to obtain an extended table; A language conversion module, used to generate a plurality of initial Cypher query statements according to the extended table, and determine a credibility parameter corresponding to each of the initial Cypher query statements according to the number of repetitions of each of the initial Cypher query statements; A statement screening module, used to screen out a Cypher query statement corresponding to the query request from the multiple initial Cypher query statements, wherein the credibility parameter corresponding to the Cypher query statement corresponding to the query request satisfies a preset parameter screening condition; The query execution module is used to obtain query results from the database corresponding to the employee collaboration platform according to the Cypher query statement corresponding to the query request, wherein the database corresponding to the employee collaboration platform is a graph structure database.

9. A data management system for an employee collaboration platform, characterized in that: The system includes: a memory storing executable program code; a processor coupled to the memory; the processor calls the executable program code stored in the memory to execute the data management method of the employee collaboration platform as described in any one of claims 1-7.

10. A computer storage medium, characterized in that: The computer storage medium stores computer instructions, and when the computer instructions are called, they are used to execute the data management method for the employee collaboration platform as described in any one of claims 1-7.

Images