CN114461785A - Method and device for recommending reference file of project management system and electronic equipment - Google Patents

Abstract

The invention belongs to the technical field of project management systems, and provides a method and a device for recommending a reference file of a project management system and electronic equipment. The recommendation method comprises the following steps: s1: extracting project task content, and processing the project task content based on a natural language processing tool to obtain a plurality of keywords; s2: searching files in a pre-established knowledge base according to a plurality of key words; s3: and sequencing the searched files, and respectively establishing corresponding file links in the project task. The recommendation method analyzes the task content based on the natural language processing technology, automatically extracts the task key content, assists the user to know the key points of the task, actively searches and provides corresponding file resources, improves the resource utilization rate and improves the task completion efficiency of the user.

Description

Method and device for recommending reference file of project management system and electronic equipment

Technical Field

The invention relates to the technical field of project management systems, in particular to a method and a device for recommending a reference file of a project management system and electronic equipment.

Background

A project management system is information software for managing projects by a project manager, and effectively manages all works related to a project by using viewpoints, methods and theories of the system under limited resource constraints. The method carries out planning, organization, command, coordination, control and evaluation in the whole process from the investment decision of the project to the project end so as to achieve the goal of the project. The user of the project management system includes not only the manager but also other affiliates of the project. In the task management part of the project management, a manager distributes tasks to project members through a project management system, and the project members complete the tasks by using a series of resources such as tools, knowledge, documents and the like related to the tasks according to the task requirements.

Although the current project management system provides a large amount of resources such as tools, knowledge, documents and the like in the form of a warehouse, project members are required to be queried and obtained in an index or search mode, and the system does not have the capability of actively pushing the project members. The project member often has the following three problems in the process of inquiring and acquiring related resources: (1) it is not known what resources to search; (2) it is not known where to search; (3) the searched documents do not know whether the documents match the task.

Therefore, even if the organization accumulates a plurality of resources, the resources are difficult to be utilized, so that the utilization rate of the resources is low, the task is difficult to be completed because no resources are available, and finally the completion efficiency of the whole project is difficult to be improved.

Disclosure of Invention

In view of the above, embodiments of the present invention provide a method, an apparatus, and an electronic device for recommending a reference file of a project management system, so as to solve or partially solve the above problems.

In a first aspect, an embodiment of the present invention provides a method for recommending a reference file in an item management system, including the following steps:

s1: extracting project task content, and processing the project task content based on a natural language processing tool to obtain a plurality of keywords;

s2: searching files in a pre-established knowledge base according to a plurality of keywords;

s3: and sequencing the searched files, and respectively establishing corresponding file links in the project task.

The beneficial effects of the above embodiment are: the method has the advantages that task contents are analyzed based on a natural language processing technology, task key contents are automatically extracted, users are assisted to know key points of tasks, corresponding file resources are actively searched and provided, resource utilization rate is improved, and task completion efficiency of the users is improved.

According to a specific implementation manner of the 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 comprises current task information and parent task information, so that the file resources recommended by retrieval are more in line with the needs of users.

According to a specific implementation manner of the embodiment of the present invention, in the step S2, the framework of the knowledge base includes a presentation layer, an API interface layer, a service layer, a data layer, and a runtime environment layer; the display layer is used for realizing system front-end interface display, the API interface layer is used for realizing front-end and back-end communication, the service layer is used for realizing file management, the data layer is used for realizing storage and search of data and files, and the operation environment layer comprises a host and a network. A special knowledge base is established, and the reserved resources are processed into text contents in advance, so that subsequent retrieval and searching are facilitated, the resource utilization rate is improved, and the project completion efficiency is improved.

According to a specific implementation manner of the embodiment of the present invention, the data layer includes Mysql, MongoDB, Redis, MinIO, and elastic search. Mysql is used for relational data including user information, file information, browsing records, and the like; the MongoDB is used for storing files; redis is used to record statistical data; MinIO stores the converted picture of the file; the Elasticsearch is used to implement a global search function.

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

building a knowledge base according to the framework, wherein the knowledge base is used for storing files and recording data;

uploading a file to a knowledge base, comprising: analyzing the name and content of the file, and storing the text content of the file in MongoDB;

asynchronously processing a file, comprising: reading the stored text content of the file in the MongoDB, writing the text content into an elastic search, extracting the internal title and page number of the file, and storing the internal title and page number of the file and file information into Mysql. When a document is uploaded, document information is stored in an Elasticissearch to establish a full-text index, so that a subsequent user can conveniently look up the document information.

According to a specific implementation manner of the embodiment of the invention, before storing the internal title, the page number and the file name information of the file into the Mysql, the method further comprises the steps of converting the file into pictures page by page and storing the pictures into the MinIO.

According to a specific implementation manner of the embodiment of the present invention, the sorting the searched files in step S3 specifically includes: and sorting the searched files from large to small according to the searched times, and if the searched times of the files are the same, sorting the files according to the keyword sources corresponding to the files. The source priority of the keywords is that the current task information is greater than the parent task information is greater than the project information, and the keywords are sorted according to the matching degree, so that the use efficiency of the recommended files is improved.

In a second aspect, an embodiment of the present invention provides an item management system reference file recommendation apparatus, including:

the acquisition module is used for extracting project task content and processing the project task content based on a natural language processing tool to acquire a plurality of keywords;

the search module is used for searching files in a pre-established knowledge base according to a plurality of keywords;

and the recommending module is used for sequencing the searched files and respectively establishing corresponding file links in the project tasks.

In a third aspect, an embodiment of the present invention further provides an electronic device, where the electronic device includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and the processor, when executing the program, implements the steps of the method in the foregoing first aspect or any implementation manner of the first aspect.

In a fourth aspect, the present invention further provides a non-transitory computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the steps of the recommendation method in the first aspect or any implementation manner of the first aspect.

The method and the device for recommending the reference file of the project management system, the electronic equipment and the non-transitory computer readable storage medium provided by the embodiment of the invention provide a mode for actively providing the file resource corresponding to the task for the user. The embodiment of the invention at least has the following technical effects:

firstly, task contents are analyzed based on a natural language processing technology, task key contents are automatically extracted, a user is assisted in knowing key points of a task, corresponding file resources are actively searched and provided, the resource utilization rate is improved, and the task completion efficiency of the user is improved.

Secondly, a special knowledge base is established, and reserved resources are processed into text contents in advance, so that subsequent retrieval and searching are facilitated, the resource utilization rate is improved, and the project completion efficiency is improved.

Thirdly, the recommended file resources are sorted according to the matching degree, and the utilization rate of the recommended files is improved.

Drawings

In order to more clearly illustrate the detailed description of the invention or the technical solutions in the prior art, the drawings that are needed in the detailed description of the invention or the prior art will be briefly described below. Throughout the drawings, like elements or portions are generally identified by like reference numerals. In the drawings, elements or portions are not necessarily drawn to scale.

FIG. 1 is a flow chart illustrating a reference file recommendation method for a project management system according to an embodiment of the present invention;

FIG. 2 is a block diagram illustrating a reference file recommending apparatus of a project management system according to an embodiment of the present invention;

fig. 3 shows a schematic structural diagram of an electronic device according to an embodiment of the present invention.

Detailed Description

Embodiments of the present invention will be described in detail below with reference to the accompanying drawings. The following examples are only for illustrating the technical solutions of the present invention more clearly, and therefore are only examples, and the protection scope of the present invention is not limited thereby.

It is to be noted that, unless otherwise specified, technical or scientific terms used herein shall have the ordinary meaning as understood by those skilled in the art to which the invention pertains.

Fig. 1 is a flowchart illustrating steps of a reference file recommendation method for a project management system according to an embodiment of the present invention, and referring to fig. 1, the method includes the following steps:

s1: and extracting project task content, and processing the project task content based on a natural language processing tool to obtain a plurality of keywords.

The project task content comprises project information content and task information content, and the task information content comprises current task information and parent task information. The item information content includes item name, item summary introduction, etc., such as: item name: item A, item description: the project A is from a certain important special project, and the project aims to complete the electronic structure design of the product X and realize related products. And task information, reading parent task information from the current task information upwards in sequence, such as: scientific research mission book review-industrial APP review-department level review. The natural language processing tool is used for carrying out word segmentation processing on natural sentences, keeping meaningful keywords, and removing prepositions, conjunctions and words with general meanings, such as projects, products and the like. For example, the disjointed words include: scientific research mission book, review, industry, APP, department level, A, a certain important special item, X, electronic structure design and the like. The natural language processing tool may employ an ik tokenizer.

S2: and searching files in a pre-established knowledge base according to a plurality of key words.

The pre-established knowledge base establishing method comprises the following steps:

s0.1: building a knowledge base according to the architecture, wherein the knowledge base is used for storing files and recording data;

the framework of the knowledge base comprises a display layer, an API (application program interface) layer, a service layer, a data layer and an operation environment layer; js frame, and adopting an ant design vue standard component library to realize the front-end interface display of the system based on the web. The API layer realizes front-end and back-end communication based on restful API/https and a websocket protocol, the https protocol is mainly used for a presentation layer to access a service layer, and the socket protocol is mainly used for the service layer to access the presentation layer. The service layer is used for achieving file management, data statistics and the like, interaction between the service layer and the data layer is achieved based on two middleware of SqlAlchemy and pymysql, functional services such as users, files and statistics are achieved based on a FastAPI framework, the services run on a uvicorn server, multiple processes are achieved based on guincern + getent, the capability of the services for supporting concurrency is enhanced, and finally reverse proxy of a service interface is achieved based on nginx. The data layer comprises five parts, namely Mysql, MongoDB, Redis, MinIO and Elasticissearch, wherein the Mysql is used for relational data and comprises user information, file information, browsing records and the like; the MongoDB is used for storing files; redis is used to record statistical data; MinIO stores the converted picture of the file; the Elasticsearch is used to implement a global search function. The operating environment layer comprises a private cloud host and a private network, the operating system is a CentOS, the NAS storage is mounted, a docker container engine is installed on the operating system, and the file browsing system operates in a docker container environment.

S0.2: uploading the file to a knowledge base;

and analyzing the name and the content of the file, storing the text content of the file in the MongoDB, and adding the file into a task queue to be processed. And (2) checking whether the number of the current concurrent threads is smaller than a set threshold (the threshold is CPU core number multiplied by 2+1), if so, starting a processing task, and if not, queuing the task into a task queue until the uploading process is finished.

If the files need to be uploaded in batches, the process is as follows: traversing the folders, reading the names of all the folders and files, establishing parent-child relationships among the nodes, sequentially sending the names to the back end of the server from high to low for creation, and acquiring returned id after creation to be used as a parent node parameter when a next file is uploaded.

S0.3: the files are processed asynchronously.

Reading the stored text content of the file in the MongoDB, writing the text content into an elastic search, analyzing a title and a page number in the file, storing the title and the page number corresponding to the title into Mysql, converting the file page by page into a picture, storing the picture into MinIO, and storing the file information into Mysql. When a document is uploaded, document information is stored in an Elasticissearch to establish a full-text index, so that a subsequent user can conveniently look up the full-text index, when the Elasticissearch establishes the index, word segmentation processing needs to be carried out on the content of the document based on a word segmenter, an ik word segmenter can be adopted, and further, an ik _ max _ word mode is adopted.

It should be noted that information of a document is composed of three parts, namely, basic description information of the document, directory information such as a title and a corresponding page number of the document, and content of the document and full-text index information of the content. The basic description information of the document is stored in the doc table and comprises name, type, sequence number, hierarchical level, parent document id and the like. Wherein the name is the name of the document; the types are divided into two types of files or folders, and are respectively represented by a numeral 0 or 1; the sequencing number is used for arranging the display sequence of the documents; the hierarchy represents the hierarchical information of the document in the global directory, and the root directory is the 0 th layer; the parent document id is used to record the association relationship between documents (or folders), here, one-to-many association, that is, one document may be a parent document of multiple documents, but may be a child document of only one document. The title and directory information of the document are stored in the doc _ catalog table, and the purpose of storing the title information is to store information of the page number of the document corresponding to the title. When the administrator uploads the document, the document information is stored in the Elasticissearch to establish a full-text index. In addition, other data are stored according to the calling frequency, for example, data for counting the reading times of the document and the reading times of the user need to be written frequently, the data are written into Redis, and for example, data with low writing frequency such as user information are written into Mysql.

S3: and sequencing the searched files, and respectively establishing corresponding file links in the project task.

And sequencing the searched files from large to small according to the searched times, and sequencing the files according to the keyword sources corresponding to the files if the searched times of the files are the same. The source priority is: current task information > parent task information > project information. Example of the ranking results:

CCC project scientific research mission book department gate level review material (10 times);

the DDD project scientific research mission book department gate level review material (7 times);

department level review system (7 times) of the company major department.

Fig. 2 is a block diagram of a reference file recommendation apparatus of an item management system according to an embodiment of the present invention, where the apparatus includes:

the acquisition module is used for extracting project task content and processing the project task content based on a natural language processing tool to acquire a plurality of keywords;

the search module is used for searching files in a pre-established knowledge base according to a plurality of key words;

and the recommending module is used for sequencing the searched files and respectively establishing corresponding file links in the project task.

The functions of the modules in the embodiment of fig. 2 correspond to the contents in the corresponding method embodiment, and are not described again here.

Fig. 3 shows a schematic structural diagram of an electronic device 30 according to an embodiment of the present invention, where the electronic device 30 includes at least one processor 301 (e.g., a CPU), at least one input/output interface 304, a memory 302, and at least one communication bus 303, and is used for implementing connection communication among these components. The at least one processor 301 is adapted to execute computer instructions stored in the memory 302 to enable the at least one processor 301 to perform any of the proposed method embodiments described above. The Memory 302 is a non-transitory Memory (non-transitory Memory), which may include a volatile Memory such as a high-speed Random Access Memory (RAM) and a non-volatile Memory such as at least one disk Memory. A communication connection with at least one other device or unit is made through at least one input-output interface 304, which may be a wired or wireless communication interface.

In some embodiments, the memory 302 stores a program 3021, and the processor 301 executes the program 3021 to perform the contents of any of the above-described embodiments of the table splitting method.

The electronic device may exist in a variety of forms, including but not limited to:

(1) a mobile communication device: such devices are characterized by mobile communications capabilities and are primarily targeted at providing voice, data communications. Such terminals include: smart phones (e.g., iphones), multimedia phones, functional phones, and low-end phones, among others.

(2) Ultra mobile personal computer device: the equipment belongs to the category of personal computers, has calculation and processing functions and generally has the characteristic of mobile internet access. Such terminals include: PDA, MID, and UMPC devices, etc., such as ipads.

(3) A portable entertainment device: such devices can display and play multimedia content. This type of device comprises: audio, video players (e.g., ipods), handheld game consoles, electronic books, and smart toys and portable car navigation devices.

(4) The specific server: the device for providing the computing service comprises a processor, a hard disk, a memory, a system bus and the like, and the server is similar to a general computer architecture, but has higher requirements on processing capacity, stability, reliability, safety, expandability, manageability and the like because of the need of providing high-reliability service.

(5) And other electronic equipment with data interaction function.

It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.

All the embodiments in the present specification are described in a related manner, and the same and similar parts among the embodiments may be referred to each other, and each embodiment focuses on the differences from the other embodiments.

In particular, as for the apparatus embodiment, since it is substantially similar to the method embodiment, the description is relatively simple, and for the relevant points, reference may be made to the partial description of the method embodiment.

The above description is only for the specific embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present invention are included in the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.

Claims (10)

1. A recommendation method for a reference file of a project management system is characterized by comprising the following steps:

s1: extracting project task content, and processing the project task content based on a natural language processing tool to obtain a plurality of keywords;

s2: searching files in a pre-established knowledge base according to a plurality of keywords;

s3: and sequencing the searched files, and respectively establishing corresponding file links in the project task.

2. The recommendation method according to claim 1, characterized in that: in the step S1, the project task content includes: project information content and task information content.

3. The recommendation method according to claim 1, characterized in that: in the step S2, the framework of the knowledge base includes a presentation layer, an API interface layer, a service layer, a data layer, and a runtime environment layer; the display layer is used for realizing system front-end interface display, the API interface layer is used for realizing front-end and back-end communication, the service layer is used for realizing file management, the data layer is used for realizing storage and search of data and files, and the operation environment layer comprises a host and a network.

4. The recommendation method according to claim 3, characterized in that: the data layers include Mysql, MongoDB, Redis, MinIO, and elastic search.

5. The recommendation method according to claim 4, characterized in that: in step S2, the knowledge base establishing method is as follows:

building a knowledge base according to the framework, wherein the knowledge base is used for storing files and recording data;

uploading a file to a knowledge base, comprising: analyzing the name and content of the file, and storing the text content of the file in MongoDB;

asynchronously processing a file, comprising: reading the stored text content of the file in the MongoDB, writing the text content into an elastic search, extracting the internal title and page number of the file, and storing the internal title and page number of the file and file information into Mysql.

6. The recommendation method according to claim 5, characterized in that: before storing the internal title, page number and file name information of the file into Mysql, the method also comprises the steps of converting the file into pictures page by page and storing the pictures into MinIO.

7. The recommendation method according to claim 1, characterized in that: in step S3, the sorting the searched files specifically includes: and sorting the searched files from large to small according to the searched times, and if the searched times of the files are the same, sorting the files according to the keyword sources corresponding to the files.

8. An item management system reference file recommendation device, comprising:

the acquisition module is used for extracting project task content and processing the project task content based on a natural language processing tool to acquire a plurality of keywords;

the search module is used for searching files in a pre-established knowledge base according to a plurality of keywords;

and the recommending module is used for sequencing the searched files and respectively establishing corresponding file links in the project tasks.

9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method as claimed in any one of claims 1 to 7 are implemented when the program is executed by the processor.

10. A non-transitory computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the recommendation method according to any one of claims 1 to 6.

Images