A method and system for classifying and managing titles of charts and graphs in bidding documents

By building an index based on chart title, attributes and content, the problem of low chart management efficiency in bidding documents is solved, and rapid query and efficient update of bidding documents are realized, and management efficiency and accuracy are improved.

CN117235010BActive Publication Date: 2024-12-27ZHEJIANG ZHAOTIANXIA BIDDING TRADING PLATFORM CO LTD
View PDF 1 Cites 0 Cited by

Patent Information

Application Number
CN202311263917.6
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2023-09-27
Publication Date
2024-12-27
Estimated Expiration
2043-09-27

AI Technical Summary

Technical Problem

The existing bidding documents chart management methods are single, and the lack of specialized management for charts is possible, which takes a lot of time to find and update chart content, and electronic documents have not effectively improved management efficiency.

Method used

By building an index based on the title, attribute and content of the chart, establishing a key-value pair mapping relationship, and achieving efficient query and update of bidding documents charts, using TextRank or TF-IDF algorithm to extract keywords, establish an index maintenance table, and update the index in real time Data and adjust index terms based on hit rate.

Benefits of technology

It realizes rapid query and efficient management of bidding documents and charts, reduces the production and update workload, and improves management efficiency and accuracy.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN117235010B_ABST
    Figure CN117235010B_ABST
Patent Text Reader

Abstract

The present invention provides a method and system for classifying and managing chart titles of bidding documents, the method comprising the following steps: obtaining chart information of a bidding document, wherein the chart information comprises a chart title, chart attributes and chart data, obtaining the bidding document location where the chart information is located, and obtaining context information of the bidding document location; extracting a corresponding first keyword from the context information corresponding to the chart information, and using the first keyword as a bidding document content keyword corresponding to the chart information; obtaining a second keyword from the chart data, using the second keyword as the chart information keyword itself, using the chart title, chart attributes and second keyword as key names, and using the chart data and the first keyword as key values ​​to establish a key-value pair index; establishing an index maintenance table, obtaining the chart information corresponding to the bidding document in real time, and updating the index data in the index maintenance table.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of bidding management, and in particular to a bidding document table title classification management method and system. Background Art

[0002] At present, with the competition and standardization of various projects, the use of bidding documents will increase. In order to better and more intuitively display the strength and needs of enterprises, more and more bidding documents are displayed in the form of charts. However, the charts in existing bidding documents are usually paper-based, and it is necessary to look through a lot of content to find the corresponding charts. Even if there is an index, the index is based on the content classification of the bidding itself rather than the chart type classification. There is a lot of text content under each index, and the charts are inserted into the text content. Therefore, it takes a lot of time to find the corresponding charts according to the index. Even the current electronic version of bidding documents does not currently have a special management for the charts in the bidding documents. Therefore, the existing bidding documents are usually produced in a single way, and some chart contents require additional manual management. Chart update operations also require manual participation, which greatly increases the workload of re-production of bidding documents. Summary of the invention

[0003] One of the inventive objectives of the present invention is to provide a method and system for classification management of chart titles in bidding documents, wherein the method and system separately construct an index for the chart titles of the bidding documents according to the document content, chart content, and title content, and searches and updates the chart content and document content through the index, thereby realizing efficient management of the chart titles of the bidding documents.

[0004] Another inventive object of the present invention is to provide a method and system for classifying and managing chart titles in bidding documents, wherein the method and system establish a mapping relationship between chart titles, chart contents and bidding contents, so that the required charts can be quickly searched according to the chart titles, and the charts can be quickly queried, thereby effectively improving the efficient extraction and management of the core content of bidding documents.

[0005] Another object of the present invention is to provide a method and system for classifying and managing chart titles in bidding documents, wherein the method and system establish key name and key value pairs including titles and contents based on the chart titles, wherein the key names include chart titles, chart attributes, chart content keywords, etc., and the key values ​​include complete chart data, mapping data such as the bidding content block where the chart is located, etc. Therefore, the present invention can realize efficient and accurate query of chart contents in bidding, and the query is more matched and more in line with the corresponding bidding content.

[0006] Another object of the present invention is to provide a method and system for classifying and managing chart titles in bidding documents. The method and system of the present invention further manage the hit rate of the chart title index. If the hit rate is too low, additional item maintenance of the chart title index is performed by adding corresponding chart attribute content or chart content keywords to the corresponding key name, or re-adding the key name and key-value pair corresponding to the new chart title.

[0007] In order to achieve at least one of the above-mentioned invention objects, the present invention further provides a method for classifying and managing chart titles in bidding documents, the method comprising the following steps:

[0008] Obtaining chart information of a bidding document, wherein the chart information includes a chart title, chart attributes, and chart data, obtaining a position of the bidding document where the chart information is located, and obtaining context information of the position of the bidding document;

[0009] Extracting a corresponding first keyword from the context information corresponding to the chart information, and using the first keyword as a content keyword of the bidding document corresponding to the chart information;

[0010] Acquire a second keyword from the chart data, use the second keyword as the keyword of the chart information itself, use the chart title, chart attributes, and the second keyword as key names, and use the chart data and the first keyword as key values ​​to establish a key-value pair index;

[0011] An index maintenance table is established to obtain the chart information corresponding to the bidding document in real time, and the index data in the index maintenance table is updated.

[0012] According to one of the preferred embodiments of the present invention, the chart attributes include chart type, chart coverage time, chart maker and the bidding document location where the chart is located, and the chart type, chart coverage time, chart maker and the bidding document location where the chart is located are used as key names for the chart index.

[0013] According to another preferred embodiment of the present invention, the chart information is located according to the position of the chart in the chart attributes in the bidding document, and further the context information corresponding to the chart is obtained according to the located bidding document position, and the first keyword in the chart context information is extracted, and the first keyword is used as the index key value.

[0014] According to another preferred embodiment of the present invention, after acquiring the chart attribute data, keywords are extracted from the text content in the chart attributes to obtain chart attribute keywords, which are used as the key name of the current index.

[0015] According to another preferred embodiment of the present invention, the text content of the chart in the chart information is obtained, the chart text content includes the text of the internal data items of the chart except the chart title, a second keyword is extracted from the data item text, and the second keyword is used as the index key name; wherein the chart title is subjected to keyword extraction, and the extracted title keyword is used as the key name of the current index.

[0016] According to another preferred embodiment of the present invention, the method includes: after obtaining the chart attribute keyword, the second keyword and the chart title keyword, further deduplicating all the extracted keywords to obtain each unique keyword, using the unique keyword as the index key value, and configuring the corresponding second keyword and the corresponding complete chart data as the key value of the current index, wherein multiple key names correspond to one key value.

[0017] According to another preferred embodiment of the present invention, the index maintenance table contains index items of keyword information of multiple key names and key values, and a maintenance period is set. During the maintenance period, all query times are counted and the index hit probability is calculated; an index hit probability threshold is set. If all hit probabilities during the maintenance period are less than the hit probability threshold, index items are re-added to the index maintenance table, and the key name-key value pairs of the index are added according to the newly added index items.

[0018] According to another preferred embodiment of the present invention, it is periodically or in real time to query whether the content in the bidding document where the current index key name is located is the same as the content stored in the index key value. If they are the same, the index key value content is not updated. If they are different, the first keyword and complete chart data are re-extracted to update the corresponding index key value.

[0019] In order to achieve at least one of the above-mentioned invention purposes, the present invention further provides a bidding document chart title classification management system, and the system executes the above-mentioned bidding document chart title classification management method.

[0020] The present invention further provides a computer-readable storage medium, which stores a computer program, and the computer program is executed by a processor to implement the above-mentioned method for classifying and managing titles of charts in bidding documents. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] Figure 1 Shown is a flow chart of a method for classifying and managing titles of charts and graphs in bidding documents according to the present invention. DETAILED DESCRIPTION

[0022] The following description is used to disclose the present invention so that those skilled in the art can implement the present invention. The preferred embodiments described below are only examples, and those skilled in the art can think of other obvious variations. The basic principles of the present invention defined in the following description can be applied to other embodiments, variations, improvements, equivalents, and other technical solutions that do not deviate from the spirit and scope of the present invention.

[0023] It is to be understood that the term "one" should be understood as "at least one" or "one or more", that is, in one embodiment, the number of an element may be one, while in another embodiment, the number of the element may be multiple, and the term "one" should not be understood as a limitation on the quantity.

[0024] Please combine Figure 1 The present invention discloses a method for classifying and managing the chart titles of bidding documents. The method mainly includes the following steps: first, it is necessary to obtain bidding document data, which can be a Word document or other readable document data type, and the bidding document data includes text information and chart information, wherein the chart information includes chart title, chart data, chart attributes, etc., wherein the chart attribute data includes information such as chart type, chart coverage time, chart maker, and bidding document location where the chart is located, wherein the chart data is composed of at least one data item, and the chart type includes but is not limited to pie charts, bar charts, line charts, scatter charts, bubble charts, etc., and the chart type can also include but is not limited to excel tables, Word tables, etc. The data items in the chart data include but are not limited to various types of data items required for bidding, such as the scope of project quotation, personnel qualification configuration type, etc. The present invention extracts keywords for the above-mentioned chart title, chart data, and chart attributes respectively; further constructs an index including chart title content and complete chart data, wherein the chart title content can be used as the key name of the index, and the corresponding complete chart data is used as the key value to establish a corresponding mapping relationship.

[0025] An index maintenance table is further established, through which the key name and key value of each index are automatically updated and maintained according to the changes in the relevant data charts of the bidding documents, and the addition and deletion of index content can be achieved by deleting or adding the form of the index maintenance table. The index content is kept relatively novel and the overall hit effect of the index is increased. Therefore, the technical solution of the present invention can effectively and conveniently update and manage the charts in the bidding documents. The core technical means of the present invention is to construct the index content of a separate bidding document chart, and to establish an index key name and key value that conforms to the corresponding position of the chart in the bidding document in combination with the attributes, type and content information of the chart in the bidding document. Therefore, the chart information corresponding to the bidding document can be quickly extracted without a large amount of reading of the document content, and the chart can be conveniently used to introduce the bidding document or reproduce the bidding document.

[0026] Specifically, in one of the preferred embodiments of the present invention, the present invention needs to perform keyword extraction on the chart title, chart attributes and chart data. It should be noted that since the chart title contains text content, and the text content may contain multiple keyword information, the present invention can use, including but not limited to, the TextRank algorithm or the TF-IDF algorithm to extract keywords from the chart title to obtain chart title keywords, and the chart title keywords can be used to construct the key name of the chart index. For example, the title of the chart is: "Real Estate Development Project Financing Project Investor Type Chart". The above title can use the TextRank algorithm or TF-IDF algorithm to obtain related keywords including: "Real Estate Development", "Financing", "Investors" and other keywords. The above keywords are used as candidate key names for the current chart.

[0027] Furthermore, since the chart information contains chart data and chart attributes in addition to the chart title, the chart attributes include but are not limited to the chart type, chart coverage time, chart maker, and the bidding document location where the chart is located, for example, the chart type in the chart attributes can be a pie chart, and the chart coverage time is the recording time of the chart corresponding to the current bidding project, for example, the covered time period can be half a year according to the project time period, etc. The chart maker records the name, age, position and other information of the maker of the chart, and the chart attributes also record the location information in the bidding project document where the current chart is located. This information can be used to record the document information content referenced by the current chart. In one of the preferred embodiments of the present invention, the chart type, maker and chart coverage, the bidding document location information where the chart is located, etc. in the chart attributes can be obtained by text or chart recognition, and the corresponding chart attribute text content is further obtained, and the chart attribute text content is further subjected to keyword extraction by the above-mentioned TextRank algorithm or TF-IDF algorithm to extract the corresponding chart attribute keyword information. The chart attribute keywords can be used as key name candidate keywords for the current chart index. For example, the chart attribute content includes: 2020-2022; pie chart; bidding document location: (real estate development, financing, investor); producer XXX, project manager, 31 years old. The above keyword extraction algorithm can be used to obtain the corresponding chart attribute candidate keywords. In one of the preferred embodiments of the present invention, in addition to the keywords extracted by the keyword algorithm, the corresponding phrases can also be actively classified into candidate keywords for key names or key values ​​according to actual needs.

[0028] For the chart data in the chart information, since each chart data contains at least one chart data item, each chart data item contains text, numerical values ​​corresponding to the text, and rendered image information, each chart data item combination constitutes a complete chart data. The present invention further performs keyword extraction on the chart data. The process of extracting keywords from the chart data includes: using technologies including but not limited to text recognition and image recognition to recognize the text content in the chart, and extracting different data items from the text content. The data items can be identified based on existing deep learning image recognition technology. The present invention does not improve the image recognition technology method. The present invention only uses the existing model to recognize the chart data range corresponding to the text in different charts. For example, different rendering blocks in the histogram correspond to different numerical types and text blocks, and different text blocks and corresponding numerical types constitute a complete data item. Since different data items contain different text contents, and these text contents may also need to be queried, the present invention further performs keyword extraction on the text contents in the different data items, thereby obtaining the second keyword of the chart data as a candidate keyword. For example, the data items of the chart data include: 1. State-owned enterprise investor-value (2), individual investor-value (30), public institution investor-value (5), private enterprise investor-value (3). The above-mentioned TextRank algorithm or TF-IDF algorithm is further used to extract the second keyword from the text data of the chart data. The second keywords that can be extracted include: state-owned enterprises, individuals, public institutions, private enterprises and investors, etc. The second keywords of the chart data extracted above are used as candidate keywords for the current chart index.

[0029] After respectively obtaining the above-mentioned chart attribute candidate keywords, chart title candidate keywords and chart data second keywords, the above three keywords are further deduplicated to obtain unique keywords. For example, chart attribute candidate keywords include: (real estate development, financing, investor, project manager, pie chart), chart title candidate keywords include: (real estate development, financing, investor), etc., chart data candidate keywords include: (state-owned enterprises, individuals, public institutions, private enterprises and investors). After deduplication, the unique keyword group is obtained: (real estate development, financing, investor, project manager, pie chart, state-owned enterprises, individuals, public institutions, private enterprises), and the above-mentioned unique keywords after deduplication are used as index key names.

[0030] The corresponding index key value is the first keyword of the positional context keyword in the bidding document where the complete chart data and the chart data are located. It should be noted that in the chart attributes, the positional information of the chart in the bidding document includes the page number and chapter content of the bidding document where the chart data is located. The key value contains the first keyword of the positional context in the bidding document where the chart data is located, which is used to prompt the bidding explanation content corresponding to the current chart. When the positional context in the bidding document of the corresponding chart is obtained according to the chart position information in the chart attributes, the TextRank algorithm or TF-IDF algorithm is further used to extract keywords from the corresponding position bidding document context to obtain the first keyword of the bidding chart explanation that meets the current position chart explanation. The first keyword of the bidding chart explanation is used as the key value of the index.

[0031] In one of the preferred embodiments of the present invention, the corresponding chart information in the bidding document is searched periodically or in real time according to the key name, and the corresponding chart information is compared with the key value stored in the memory index to determine whether to send changes. If changes occur, the corresponding chart information in the bidding document is synchronously updated to the key value of the corresponding memory, thereby achieving periodic or real-time update of the index. The update method may include but is not limited to re-searching the location context in the bidding document and extracting the corresponding keywords. The newly extracted keywords are stored in the key value of the corresponding key name. In another preferred embodiment of the present invention, if there is a keyword corresponding to the key name in the current index and the corresponding chart information cannot be found in the bidding document, the chart may be deleted and the corresponding key name is deleted synchronously. If the current key name and the corresponding key value are in a one-to-one mapping relationship, the key value is deleted synchronously.

[0032] It should be noted that in one of the preferred embodiments of the present invention, the present invention further configures an index maintenance table, and different key names and corresponding key values ​​are configured in the index maintenance table. The index maintenance table is used to record the hit records of each query, and the index maintenance table contains index items of keyword information of multiple key names and key values. A maintenance cycle is set. During the maintenance cycle, all query times are counted and the index hit probability is calculated; an index hit probability threshold is set. If all hit probabilities during the maintenance cycle are less than the hit probability threshold, index items are re-added to the index maintenance table, and the key name-key value pairs of the index are added according to the newly added index items.

[0033] The embodiments disclosed in the present invention, the process described above with reference to the flowchart can be implemented as a computer software program. The embodiments disclosed in the present invention include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program contains a program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from the network through the communication part, and / or installed from a removable medium. When the computer program is executed by the central processing unit (CPU), the above-mentioned functions defined in the method of the present application are executed. It should be noted that the above-mentioned computer-readable medium of the present application can be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium can be, for example, but not limited to, a system, device or device of an electrical, magnetic, optical, electromagnetic, infrared segment, or semiconductor, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to, an electrical connection with one or more wire segments, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present application, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. In the present application, a computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, which carries a computer-readable program code. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. A computer-readable signal medium may also be any computer-readable medium other than a computer-readable storage medium, which may send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device. The program code embodied on the computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, electrical wire, optical cable, RF, etc., or any suitable combination of the foregoing.

[0034] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present invention. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs the specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0035] Those skilled in the art should understand that the embodiments of the present invention described above and shown in the accompanying drawings are only examples and do not limit the present invention. The objectives of the present invention have been fully and effectively achieved. The functional and structural principles of the present invention have been demonstrated and explained in the embodiments. Without departing from the principles, the implementation methods of the present invention may be deformed or modified in any way.

Claims

1. A method for classifying and managing titles of charts and graphs in bidding documents, characterized in that: The method comprises the following steps: Obtaining chart information of a bidding document, wherein the chart information includes a chart title, chart attributes, and chart data, obtaining a position of the bidding document where the chart information is located, and obtaining context information of the position of the bidding document; Extracting a corresponding first keyword from the context information corresponding to the chart information, and using the first keyword as a content keyword of the bidding document corresponding to the chart information; Acquire a second keyword from the chart data, use the second keyword as the chart information keyword itself, use the chart title keyword, chart attribute keyword, and the second keyword as key names, and use the chart data keyword and the first keyword as key values ​​to establish a key-value pair index; Establish an index maintenance table, obtain the chart information corresponding to the bidding document in real time, and update the index data in the index maintenance table; The index maintenance table contains index items of keyword information of multiple key names and key values, sets a maintenance period, counts all query times during the maintenance period, and calculates the index hit probability; sets an index hit probability threshold, and if all hit probabilities during the maintenance period are less than the hit probability threshold, re-adds index items to the index maintenance table, and adds index key name-key value pairs according to the newly added index items; Regularly or in real time, check whether the content in the bidding document where the current index key name is located is the same as the content stored in the index key value. If they are the same, the index key value content will not be updated. If they are different, the first keyword and complete chart data will be re-extracted to update the corresponding index key value.

2. A method for classifying and managing titles of charts and graphs in bidding documents according to claim 1, characterized in that: The chart attributes include chart type, chart coverage time, chart maker and the bidding document location where the chart is located. The chart type, chart coverage time, chart maker and the bidding document location where the chart is located are used as the key name of the chart index.

3. A method for classifying and managing titles of charts and graphs in bidding documents according to claim 1, characterized in that: The chart information is located according to the position of the chart in the chart attributes in the bidding document, and the context information corresponding to the chart is further obtained according to the located bidding document position, the first keyword in the chart context information is extracted, and the first keyword is used as the index key value.

4. A method for classifying and managing titles of charts and graphs in bidding documents according to claim 1, characterized in that: After acquiring the chart attribute data, keywords are extracted from the text content in the chart attributes to obtain chart attribute keywords, which are used as the key names of the current index.

5. A method for classifying and managing titles of charts and graphs in bidding documents according to claim 1, characterized in that: Obtain the text content of the chart in the chart information, wherein the text content of the chart includes the text of the internal data items of the chart except the chart title, extract a second keyword from the data item text, and use the second keyword as the index key name; wherein the chart title is subjected to keyword extraction, and the extracted title keyword is used as the key name of the current index.

6. A method for classifying and managing titles of bidding documents charts according to claim 1, characterized in that: The method includes: after obtaining the chart attribute keyword, the second keyword and the chart title keyword, further deduplication processing is performed on all the extracted keywords to obtain each unique keyword, the unique keyword is used as the index key value, and the corresponding second keyword and the corresponding complete chart data are configured as the key value of the current index, wherein multiple key names correspond to one key value.

7. A computer-readable storage medium storing a computer program, wherein the computer program is executed by a processor to implement a method for classifying and managing chart titles in bidding documents as described in any one of claims 1 to 6.

Citation Information

Patent Citations

  • Information extraction method and device, equipment and storage medium

    CN114444465A