A method, device and electronic device for recommending reference documents of a project management system

Abstract

The present invention belongs to the technical field of project management systems, and provides a method, device and electronic device for recommending reference documents for a project management system. The recommended method includes the following steps: S1: Extract the project task content, and obtain a number of keywords by processing the project task content based on natural language processing tools; S2: Search for files in a pre-established knowledge base according to the number of keywords; S3: Sort the searched files, and respectively establish corresponding file links in the project tasks. The recommended method analyzes the task content based on natural language processing technology, automatically extracts the key task content, assists users in understanding the key points of the tasks, and actively searches for and provides corresponding file resources, improving resource utilization and enhancing the efficiency of users to complete tasks.

Description

Technical Field

[0001] The present invention relates to the technical field of project management systems, and particularly to a method, device and electronic device for recommending reference documents in a project management system. Background Art

[0002] A project management system is an information-based software used by project managers to manage projects. Under limited resource constraints, it effectively manages all the work involved in a project by applying systematic viewpoints, methods and theories. It plans, organizes, commands, coordinates, controls and evaluates the whole process of a project from investment decision-making to project completion to achieve the project goals. The users of a project management system are not only managers but also other stakeholders of the project. In the task management part of project management, managers assign tasks to project members through the project management system, and project members complete tasks according to task requirements by using a series of resources such as tools, knowledge, documents related to the tasks.

[0003] In current project management systems, although a large number of resources such as tools, knowledge, documents, etc. are provided in the form of a repository, project members need to query and obtain them by indexing or searching, and the system does not have the ability to actively push to project members. There are often the following three problems for project members in the process of querying and obtaining relevant resources: (1) not knowing what resources to search for; (2) not knowing where to search; (3) not knowing whether the searched documents match the tasks.

[0004] Therefore, even if an organization has accumulated a lot of resources, it is difficult to utilize them, resulting in low resource utilization rate. Tasks are also difficult to complete due to lack of available resources, ultimately leading to difficulty in improving the completion efficiency of the entire project. Summary of the Invention

[0005] In view of this, embodiments of the present invention provide a method, device and electronic device for recommending reference documents in a project management system to solve or partially solve the above problems.

[0006] In a first aspect, an embodiment of the present invention provides a method for recommending reference documents in a project management system, including the following steps:

[0007] S1: Extract the project task content, and obtain a number of keywords by processing the project task content based on natural language processing tools;

[0008] S2: Search for files in a pre-established knowledge base according to the number of the keywords;

[0009] S3: Sort the searched files and establish corresponding file links in the project tasks respectively.

[0010] The beneficial effects of the above embodiments are as follows: By analyzing the task content based on natural language processing technology, the key content of the task is automatically extracted to assist the user in understanding the key points of the task, and corresponding file resources are actively searched for and provided, improving resource utilization and enhancing the user's task completion efficiency.

[0011] According to a specific implementation manner of an embodiment of the present invention, in the step S1, the project task content includes: project information content and task information content. The task information content includes current task information and parent task information, making the retrieved and recommended file resources more in line with the user's needs.

[0012] According to a specific implementation manner of an embodiment of the present invention, in the step S2, the architecture of the knowledge base includes a display layer, an API interface layer, a service layer, a data layer, and a running environment layer; the display layer is used to implement the front-end interface display of the system, the API interface layer is used to implement front-end and back-end communication, the service layer is used to implement file management, the data layer is used to implement the storage and search of data and files, and the running environment layer includes a host and a network. A dedicated knowledge base is established, and the reserve resources are pre-processed into text content in advance, which is convenient for subsequent retrieval and search, improves resource utilization, and enhances the project completion efficiency.

[0013] According to a specific implementation manner of an embodiment of the present invention, the data layer includes Mysql, MongoDB, Redis, MinIO, and Elasticsearch. Mysql is used for relational data, including user information, file information, browsing records, etc.; MongoDB is used to store files; Redis is used to record statistical data; MinIO stores the pictures converted from files; Elasticsearch is used to implement the global search function.

[0014] According to a specific implementation manner of an embodiment of the present invention, the method for establishing the knowledge base in the step S2 is as follows:

[0015] Build the knowledge base according to the architecture, and the knowledge base is used to store files and record data;

[0016] Upload files to the knowledge base, including: parsing the names and contents of the files, and storing the text content of the files in MongoDB;

[0017] Asynchronous file processing, including: reading the text content of the stored file in MongoDB, writing the text content to Elasticsearch, extracting the internal title and page numbers of the file, and storing the internal title, page numbers and file information of the file in Mysql. When uploading a document, store the document information in Elasticsearch to establish a full-text index for subsequent user access. When Elasticsearch establishes an index, it is necessary to perform word segmentation processing on the file content based on a tokenizer.

[0018] According to a specific implementation manner of an embodiment of the present invention, before storing the internal title, page numbers and file name information of the file in Mysql, it further includes converting the file into pictures page by page and storing them in MinIO.

[0019] According to a specific implementation manner of an embodiment of the present invention, in step S3, sorting the searched files specifically includes: sorting the searched files in descending order according to the number of times they are searched. If the number of times multiple files are searched is the same, then sort according to the keyword source corresponding to the file. The keyword source priority is current task information > parent task information > project information, and sorting according to the matching degree improves the usage efficiency of the recommended files.

[0020] In a second aspect, an embodiment of the present invention provides a reference file recommendation device for a project management system, including:

[0021] An acquisition module, which is used to extract project task content and obtain several keywords by processing the project task content based on natural language processing tools;

[0022] A search module, which is used to search for files in a pre-established knowledge base according to several keywords;

[0023] A recommendation module, which is used to sort the searched files and establish corresponding file links in the project tasks respectively.

[0024] In a third aspect, an embodiment of the present invention further provides an electronic device, which includes a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the program, it implements the steps of the recommendation method in the foregoing first aspect or any implementation manner of the first aspect.

[0025] In a fourth aspect, an embodiment of the present invention further provides a non-transitory computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, it implements the steps of the item recommendation method in the foregoing first aspect or any implementation manner of the first aspect.

[0026] The project management system reference file recommendation method, device, electronic device, and non-transitory computer-readable storage medium provided by the embodiments of the present invention provide a way to actively provide file resources corresponding to tasks for users. The embodiments of the present invention have at least the following technical effects:

[0027] First, analyze the task content based on natural language processing technology, automatically extract the key content of the task, assist users in understanding the key points of the task, and actively search for and provide corresponding file resources, improving resource utilization and enhancing the efficiency of users to complete tasks.

[0028] Second, establish a dedicated knowledge base, pre-process the reserve resources into text content, facilitate subsequent retrieval and search, improve resource utilization, and enhance the project completion efficiency.

[0029] Third, the recommended file resources are sorted according to the matching degree, improving the usage rate of the recommended files. Description of the Drawings

[0030] In order to more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the following will briefly introduce the drawings required for the description of the specific embodiments or the prior art. In all the drawings, similar elements or parts are generally identified by similar reference numerals. In the drawings, the elements or parts do not necessarily draw according to the actual scale.

[0031] Figure 1 Shows a flowchart of a project management system reference file recommendation method provided by an embodiment of the present invention;

[0032] Figure 2 Shows a structural block diagram of a project management system reference file recommendation device provided by an embodiment of the present invention;

[0033] Figure 3 Shows a structural schematic diagram of an electronic device provided by an embodiment of the present invention. Detailed Embodiments

[0034] The following will combine the drawings to describe the embodiments of the technical solutions of the present invention in detail. The following embodiments are only used to more clearly illustrate the technical solutions of the present invention, so they are only examples and cannot be used to limit the protection scope of the present invention.

[0035] It should be noted that unless otherwise specified, the technical terms or scientific terms used in this application should have the general meaning understood by those skilled in the art to which the present invention belongs.

[0036] Figure 1 For the step flowchart of a project management system reference file recommendation method provided by an embodiment of the present invention, see Figure 1 , the method includes the following steps:

[0037] S1: Extract the project task content, and obtain a number of keywords by processing the project task content based on natural language processing tools.

[0038] The project task content includes project information content and task information content. The task information content includes current task information and parent task information. The project information content includes the project name, project summary introduction, etc. For example: Project Name: Project A, Project Description: Project A comes from a major special project, and the project goal is to complete the electronic structure design of Product X and realize related products. For task information, read the parent task information sequentially upward from the current task information. For example: Review of Scientific Research Task Book - Review of Industrial APP - Department-level Review. Based on natural language processing tools, perform word segmentation on natural sentences, retain meaningful keywords, and remove prepositions, conjunctions, and general words such as project and product. For example, the split words include: Scientific Research Task Book, Review, Industry, APP, Department-level, A, a major special project, X, electronic structure design, etc. The natural language processing tool can use the ik word segmenter.

[0039] S2: Search for files in the pre-established knowledge base according to a number of keywords.

[0040] Among them, the method for establishing the pre-established knowledge base is as follows:

[0041] S0.1: Build the knowledge base according to the architecture. The knowledge base is used to store files and record data;

[0042] The architecture of the knowledge base includes a presentation layer, an API interface layer, a service layer, a data layer, and a running environment layer. Among them, the presentation layer is based on the vue.js framework and uses the ant design vue standard component library to implement the front-end interface display of the web-based system. The API interface layer realizes the front-end and back-end communication based on the RestfulAPI / https and websocket protocols. The https protocol is mainly used for the presentation layer to access the service layer, and the socket protocol is mainly used for the service layer to access the presentation layer. The service layer is used to implement file management, data statistics, etc. The interaction between the service layer and the data layer is realized based on two middleware, SqlAlchemy and pymysql, and user, file, statistics and other functional services are realized based on the FastAPI framework. The service runs on the uvicorn server, and at the same time, multi-process is realized based on gunicorn+gevent to enhance the service's ability to support concurrency. Finally, the reverse proxy of the service interface is realized based on nginx. The data layer includes five parts: Mysql, MongoDB, Redis, MinIO, and Elasticsearch. Mysql is used for relational data, including user information, file information, browsing records, etc.; MongoDB is used to store files; Redis is used to record statistical data; MinIO stores the pictures converted from files; Elasticsearch is used to implement the global search function. The running environment layer includes a private cloud host and a dedicated network. The operating system is CentOS, and the NAS storage is mounted. On this basis, the docker container engine is installed, and the file browsing system runs in the docker container environment.

[0043] S0.2: Upload files to the knowledge base;

[0044] Parse the name and content of the file, store the file text content in MongoDB, and add the file to the task queue to be processed. quotarz checks whether the current number of concurrent threads is less than the set threshold (the threshold is: CPU core number * 2 + 1). If it is less than the threshold, a processing task is started. If it is greater than or equal to the threshold, the task is queued until the upload process ends.

[0045] If it is necessary to upload files in batches, the process is as follows: traverse the folder, read the names of all folders and files, and establish the parent-child relationship between nodes, and then send them to the server backend for creation from high to low in turn, and obtain the id after creation returned as the parent node parameter for the next file upload.

[0046] S0.3: Asynchronously process files.

[0047] Read the text content of the stored file in MongoDB, write the text content to Elasticsearch, then parse the title and page numbers in the file, store the title and its corresponding page numbers in Mysql, then convert the file into images page by page and store them in MinIO, and finally store the file information in Mysql. When uploading a document, store the document information in Elasticsearch to build a full-text index for subsequent user reference. When Elasticsearch builds an index, it is necessary to perform word segmentation on the file content based on a word segmenter. Here, the ik word segmenter can be used. Further, the ik_max_word mode is adopted.

[0048] It should be noted that the information of a document consists of three parts. One is the basic description information of the document, the second is the table of contents information such as the title and corresponding page numbers of the document, and the third is the content of the document itself and the full-text index information of the content. The basic description information of the document is stored in the doc table, including name, type, sort number, level, and parent document id, etc. Among them, the name is the name of the document; the type is divided into two types: file or folder, which are represented by the numbers 0 or 1 respectively; the sort number is used to arrange the display order of the documents; the level represents the hierarchical information of the document in the global directory, and the root directory is the 0th level; the parent document id is used to record the association relationship between documents (or folders). Here, it is a one-to-many association, that is, a document can be the parent document of multiple documents, but can only be the sub-document of one document. The title and table of contents information of the document are stored in the doc_catlog table. The purpose of storing the title information is to store the information of the page numbers corresponding to the title in the document. When the administrator uploads a document, store the document information in Elasticsearch to build a full-text index. In addition, other data is stored according to the call frequency. For example, data such as the statistics of document reading times and user reading times needs to be written frequently, and this type of data is written to Redis. Data with a lower write frequency, such as user information, is written to Mysql.

[0049] S3: Sort the searched files and establish corresponding file links in the project tasks respectively.

[0050] Sort the searched files in descending order according to the number of times they are searched. If multiple files are searched the same number of times, sort them according to the keyword source corresponding to the files. The source priority is: current task information > parent task information > project information. Example of the sorting result:

[0051] CCC Project Research Task Book Department-Level Review Materials (10 times);

[0052] DDD Project Research Task Book Department-Level Review Materials (7 times);

[0053] Company Major Special Project Department-Level Review System (7 times).

[0054] Figure 2 The following is a structural block diagram of a reference file recommendation device for a project management system provided by an embodiment of the present invention. The device includes:

[0055] An acquisition module, which is used to extract project task content and obtain a number of keywords by processing the project task content based on natural language processing tools;

[0056] A search module, which is used to search for files in a pre-established knowledge base according to the number of keywords;

[0057] A recommendation module, which is used to sort the searched files and establish corresponding file links in the project tasks respectively.

[0058] Figure 2 The functions of the modules in the embodiment correspond to the content in the corresponding method embodiments, and will not be elaborated here.

[0059] Figure 3 The following shows a schematic structural diagram of an electronic device 30 provided by an embodiment of the present invention. The electronic device 30 includes at least one processor 301 (such as a CPU), at least one input / output interface 304, a memory 302, and at least one communication bus 303 for realizing the connection and communication between these components. At least one processor 301 is used to execute computer instructions stored in the memory 302 so that the at least one processor 301 can execute the embodiments of any of the foregoing recommendation methods. The memory 302 is a non-transitory memory, which may include volatile memory, such as high-speed random access memory (RAM: Random Access Memory), and may also include non-volatile memory, such as at least one disk memory. The communication connection with at least one other device or unit is realized through at least one input / output interface 304 (which may be a wired or wireless communication interface).

[0060] In some embodiments, the memory 302 stores a program 3021, and the processor 301 executes the program 3021 to execute the content in any of the foregoing sub-table method embodiments.

[0061] The electronic device may exist in various forms, including but not limited to:

[0062] (1) Mobile communication devices: These devices are characterized by having mobile communication functions and mainly aiming to provide voice and data communication. Such terminals include: smart phones (such as iPhone), multimedia phones, functional phones, and low-end phones, etc.

[0063] (2) Ultra-mobile personal computer devices: Such devices fall within the category of personal computers, have computing and processing capabilities, and generally also have the characteristic of mobile Internet access. Such terminals include: PDA, MID, and UMPC devices, etc., such as the iPad.

[0064] (3) Portable entertainment devices: Such devices can display and play multimedia content. Such devices include: audio and video players (such as the iPod), handheld game consoles, e-books, as well as smart toys and portable in-vehicle navigation devices.

[0065] (4) Specific servers: Devices that provide computing services. The composition of a server includes a processor, hard disk, memory, system bus, etc. Servers are similar to general computer architectures, but due to the need to provide highly reliable services, they have higher requirements in terms of processing power, stability, reliability, security, scalability, manageability, etc.

[0066] (5) Other electronic devices with data interaction functions.

[0067] It should be noted that in this article, relational terms such as first and second are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variant thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements not only includes those elements, but also includes other elements not expressly listed, or also includes elements inherent to such process, method, article or device. Without further limitation, an element defined by the statement "including one..." does not exclude the existence of additional identical elements in the process, method, article or device including the said element.

[0068] Each embodiment in this specification is described in a related manner. The same or similar parts between each embodiment can be referred to each other, and the differences between each embodiment and other embodiments are emphasized.

[0069] In particular, for the device embodiments, since they are basically similar to the method embodiments, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiments.

[0070] The above is only the specific implementation manner of the present invention, but the protection scope of the present invention is not limited thereto. Any changes or substitutions that can be easily thought of by those skilled in the art within the technical scope disclosed by the present invention should be covered by the protection scope of the present invention. Therefore, the protection scope of the present invention should be subject to the protection scope of the claims.

Claims

1. A method for recommending reference documents of a project management system, characterized in that It includes the following steps: S1: Extract the project task content, which includes the current task information, parent task information, and project information content. Based on the natural language processing tool, process the project task content to obtain several keywords. The natural language processing tool uses the ik tokenizer for word segmentation, retains the keywords, and removes prepositions, conjunctions, and common words; S2: Search for files in the pre-established knowledge base according to several of the keywords. The architecture of the knowledge base includes a presentation layer, an API interface layer, a service layer, a data layer, and a running environment layer. The data layer includes Mysql, MongoDB, Redis, MinIO, and Elasticsearch. When uploading a file, the text content is written into Elasticsearch asynchronously, and the internal title and page number in the file are extracted and stored in Mysql. At the same time, the file is converted into images page by page and stored in MinIO; S3: Sort the searched files. The sorting rule is: sort from largest to smallest according to the number of search times. If the number of times is the same, sort according to the keyword source priority, where the priority is current task information > parent task information > project information, and corresponding file links are established respectively in the project task; Among them, the method for establishing the knowledge base is as follows: Build the knowledge base according to the architecture. The knowledge base is used to store files and record data; Upload files to the knowledge base, including: parsing the file name and content, storing the file text content in MongoDB, and adding the file to the task queue to be processed. Check whether the current number of concurrent threads is less than the set threshold through quotarz. The threshold is set to CPU core number * 2 + 1. If it is less than the threshold, start a processing task. If it is greater than or equal to the threshold, queue the task until the upload process ends; when uploading a document, store the document information in Elasticsearch to establish a full-text index. When Elasticsearch builds an index, it is necessary to perform word segmentation on the file content based on the tokenizer; Asynchronously process files.

2. The recommendation method according to claim 1, characterized in that: In step S2, the presentation layer is used to implement the front-end interface display of the system. The API interface layer is used to implement the communication between the front-end and the back-end. The service layer is used to implement file management. The data layer is used to implement the storage and search of data and files. The running environment layer includes a host and a network; the presentation layer of the knowledge base is based on the vue.js framework to implement the front-end interface. The API interface layer uses the RestfulAPI / https and WebSocket protocols. The service layer is based on the FastAPI framework to implement file management. The running environment layer includes a private cloud host and a dedicated network, and is deployed through docker containers.

3. A reference document recommendation device for a project management system, characterized in that, Adopt the recommendation method as described in any one of claims 1-2, including: An acquisition module, which is used to extract the project task content and obtain several keywords based on the natural language processing tool to process the project task content; A search module, which is used to search for files in the pre-established knowledge base according to several of the keywords; A recommendation module, which is used to sort the searched files and establish corresponding file links in the project tasks respectively.

4. An electronic device, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein, When the processor executes the program, the steps of the recommendation method according to any one of claims 1-2 are implemented.

5. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by the processor, the steps of the recommendation method according to any one of claims 1-2 are implemented.

Images