CN111160388A - Data matching method in material bidding process - Google Patents
Data matching method in material bidding process Download PDFInfo
- Publication number
- CN111160388A CN111160388A CN201911196821.6A CN201911196821A CN111160388A CN 111160388 A CN111160388 A CN 111160388A CN 201911196821 A CN201911196821 A CN 201911196821A CN 111160388 A CN111160388 A CN 111160388A
- Authority
- CN
- China
- Prior art keywords
- matching
- data
- file
- mapping
- bidding
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Withdrawn
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F18/00—Pattern recognition
- G06F18/20—Analysing
- G06F18/22—Matching criteria, e.g. proximity measures
Landscapes
- Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Theoretical Computer Science (AREA)
- Computer Vision & Pattern Recognition (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Bioinformatics & Computational Biology (AREA)
- Artificial Intelligence (AREA)
- Evolutionary Biology (AREA)
- Evolutionary Computation (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Life Sciences & Earth Sciences (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data matching method in a material bidding process, which comprises the following steps: preparing all files to be subjected to data matching according to template requirements; extracting fields needing to be subjected to association mapping in a plurality of files to form an association mapping file, wherein the association mapping file is used as an intermediate relation role of the files needing to be processed, and when data matching is carried out, the mapping fields in one main file acquire the mapping fields in the other file through the field association mapping file, so that the data needing to be matched in the two files are matched; and importing the file to be subjected to data matching and the field association mapping file into the gadget to obtain a final matching result. The invention can lead all the document data needing manual matching into the system at one time and complete matching within 1 minute, thereby saving the data matching time and improving the fine level of the material bidding service.
Description
Technical Field
The invention relates to a data matching method in a material bidding process, and belongs to the technical field of material bidding.
Background
In recent years, after a bidding project is started, all process operations are manually executed, so that the method has the advantages of more data, large data volume, time-consuming data processing and high error probability, data generated in the process are stored in an office document form, and the storage, migration, association lookup and association analysis of the data have higher difficulty. Under the background, constructing a bidding data unified management, analysis and bidding process data matching automation system becomes the most important target of imperative.
Disclosure of Invention
In order to solve the problems of time consumption and easy error of the existing manual matching of data in the bidding process, the invention provides a data matching method in the material bidding process,
in order to achieve the above object, the present invention adopts the following technical solutions:
a data matching method in a material bidding process comprises the following steps:
preparing all bidding documents to be subjected to data matching according to the requirements of the document template;
marking the relation between fields in the bidding document to generate an associated mapping document;
and importing the bidding document and the associated mapping document which are prepared to be subjected to data matching into a bidding gadget to obtain a final matching result.
Further, the preparing of all files to be subjected to data matching according to the file template requirement includes:
in the file template, the name of the sheet page and the list head list name are in fixed format and can not be changed, and the data content of the corresponding area of the list head list is filled according to the content of the bidding document;
the file template is presented in EXCEL format, and the name of the file template is composed of the former identifier used as the program reading judgment data flow direction and the name after the identifier.
Further, the marking the relationship between the fields in the generated file and generating an association mapping file includes:
and selecting a mapping principle to mark the relation between different fields in different files according to actual business requirements, and generating an associated mapping file.
Further, the mapping principle includes:
completely matching character strings of different fields;
and matching the corresponding relation of different field contents.
Further, the association mapping file exists in an excel table form in a file template needing association mapping.
Further, two mapping relations of one-to-one and one-to-many exist between the fields.
Further, the importing the bidding document and the associated mapping document to be subjected to data matching into a bidding widget to obtain a final matching result includes:
and acquiring the mapping field of one bidding document to be subjected to data matching by associating the mapping field of the other bidding document, and comparing and calculating to obtain a matching result.
Further, the method also comprises the following steps: all bidding documents ready for data matching are simultaneously matched with the associated mapping document by using parallel flow in JAVA 8.
The invention has the beneficial effects that:
the method can replace manual data matching, greatly reduce data matching time and matching errors and improve the working efficiency of bidding full time.
Drawings
FIG. 1 is a flow chart of the method of the present invention.
Detailed Description
The invention is further described below. The following examples are only for illustrating the technical solutions of the present invention more clearly, and the protection scope of the present invention is not limited thereby.
Referring to fig. 1, the present invention provides a data matching method in a material bidding process, which specifically includes:
firstly, filling related data in a template, and preparing all files to be subjected to data matching according to the requirements of the template. In the embodiment of the invention, the file template is dynamically configured according to the business process, and the bidding data is standardized.
The file template is specifically presented in EXCEL format, the foremost identifier in the file template name is used as a program reading judgment data flow direction, such as "1-" and "2-", and the name behind the identifier can be changed freely. In the file template, the name of the sheet page and the list head list name are in a fixed format and cannot be changed, and other areas are filled as data contents.
Then, the relation between different fields of a plurality of files is marked, and a plurality of files which are not related to each other are related, so that the automatic matching of data is achieved. The method comprises the following steps: extracting fields needing to be subjected to association mapping in a plurality of files to form an association mapping file,
the associated mapping file exists in an excel form, a data source is derived from bidding document data, and the bidding professional fills the associated mapping file according to the field relation of the bidding data to be matched at this time.
The relationship between different fields in different files has different mapping principles according to actual business requirements, including but not limited to the following principles: completely matching character strings of different fields; and matching the corresponding relation of different field contents. There are two kinds of mapping relations of oneToOne (one-to-one) and oneToMany (one-to-many) between fields.
According to business requirements, a plurality of associated mapping files exist in a template needing associated mapping in the form of a relation table sheet page.
And according to the business requirement, one or more fields are extracted from the template file to form an association mapping.
The fields in each file have an associated mapping relationship, and a plurality of files are associated according to different relationships.
The associated mapping file is used as an intermediate relation role of a plurality of files needing to be processed, when data matching is carried out, a mapping field in one main file obtains a mapping field in another file through the field associated mapping file, and therefore the data needing to be matched in the two files are matched.
And finally, importing the bidding document to be subjected to data matching and the field association mapping document into a widget (bidding widget. exe) to obtain a final matching result.
In the embodiment of the invention, an automatic multithreading matching technology is adopted, and all bidding documents to be subjected to data matching are simultaneously matched and calculated with the field association mapping document to obtain a final matching result.
The data matching process uses parallel streams in JAVA8 to implement multi-thread matching. Parallel flow is a flow in which data to be processed is divided into a plurality of data blocks and each data block is processed by a different thread. Therefore, the program can automatically distribute the workload of given operation to all the cores of the multi-core processor to make the cores busy, and the number of threads distributed by the parallel flow is the number of the body processors, so that the performance is obviously improved when the machine with more processor cores runs.
And the matching result is obtained by extracting useful items in each bidding document according to the association mapping relation, displaying result items obtained by calculation of money amount, scores and the like, and finally aggregating and summarizing the matching result according to the requirement of bidding full time.
The data matching method can completely replace manual processing of data in the whole bidding process, greatly reduce data matching time and matching errors and improve the working efficiency of full job bidding.
The above description is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, several modifications and variations can be made without departing from the technical principle of the present invention, and these modifications and variations should also be regarded as the protection scope of the present invention.
Claims (8)
1. A data matching method in a material bidding process is characterized by comprising the following steps:
preparing all bidding documents to be subjected to data matching according to the requirements of the document template;
marking the relation between fields in the bidding document to generate an associated mapping document;
and importing the bidding document and the associated mapping document which are prepared to be subjected to data matching into a bidding gadget to obtain a final matching result.
2. The method for matching data in the material bidding process according to claim 1, wherein the step of preparing all the documents to be subjected to data matching according to the document template requirement comprises:
in the file template, the name of the sheet page and the list head list name are in fixed format and can not be changed, and the data content of the corresponding area of the list head list is filled according to the content of the bidding document;
the file template is presented in EXCEL format, and the name of the file template is composed of the former identifier used as the program reading judgment data flow direction and the name after the identifier.
3. The method of claim 1, wherein the marking of the relationship between the fields in the generated file to generate the association mapping file comprises:
and selecting a mapping principle to mark the relation between different fields in different files according to actual business requirements, and generating an associated mapping file.
4. The method for matching data in a material bidding process according to claim 3, wherein the mapping principle comprises:
completely matching character strings of different fields;
and matching the corresponding relation of different field contents.
5. The method of claim 3, wherein the association mapping file exists in the form of excel table in the file template requiring association mapping.
6. The method as claimed in claim 3, wherein the fields have one-to-one and one-to-many mapping relationships.
7. The method for matching data in a material tendering process according to claim 1, wherein the importing the tendering file prepared for data matching and the associated mapping file into a tendering and bidding gadget to obtain a final matching result comprises:
and acquiring the mapping field of one bidding document to be subjected to data matching by associating the mapping field of the other bidding document, and comparing and calculating to obtain a matching result.
8. The method for matching data in a material tender process of claim 1, further comprising: all bidding documents ready for data matching are simultaneously matched with the associated mapping document by using parallel flow in JAVA 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911196821.6A CN111160388A (en) | 2019-11-29 | 2019-11-29 | Data matching method in material bidding process |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911196821.6A CN111160388A (en) | 2019-11-29 | 2019-11-29 | Data matching method in material bidding process |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111160388A true CN111160388A (en) | 2020-05-15 |
Family
ID=70556269
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911196821.6A Withdrawn CN111160388A (en) | 2019-11-29 | 2019-11-29 | Data matching method in material bidding process |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111160388A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113781187A (en) * | 2021-07-22 | 2021-12-10 | 国网物资有限公司 | Sub-packaging method and sub-packaging tool suitable for bidding purchase of electric power materials |
| CN114881545A (en) * | 2022-07-07 | 2022-08-09 | 国网浙江省电力有限公司 | Automatic material matching method and device based on cooperative interconnection |
-
2019
- 2019-11-29 CN CN201911196821.6A patent/CN111160388A/en not_active Withdrawn
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113781187A (en) * | 2021-07-22 | 2021-12-10 | 国网物资有限公司 | Sub-packaging method and sub-packaging tool suitable for bidding purchase of electric power materials |
| CN114881545A (en) * | 2022-07-07 | 2022-08-09 | 国网浙江省电力有限公司 | Automatic material matching method and device based on cooperative interconnection |
| CN114881545B (en) * | 2022-07-07 | 2022-09-23 | 国网浙江省电力有限公司 | Automatic material matching method and device based on cooperative interconnection |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110292775B (en) | Method and device for acquiring difference data | |
| CN103984734B (en) | Cloud service message transmission method orienting high-performance computation | |
| CN107784026B (en) | ETL data processing method and device | |
| CN111160388A (en) | Data matching method in material bidding process | |
| CN111813963A (en) | Knowledge graph construction method and device, electronic equipment and storage medium | |
| CN109298861A (en) | A kind of method and device automatically generating file according to interface document | |
| CN108229614A (en) | Label generating method, computer readable storage medium and system | |
| CN112115145A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN115358204A (en) | Report generation method and device, electronic equipment and storage medium | |
| CN111061743A (en) | Data processing method and device and electronic equipment | |
| WO2022048362A1 (en) | Data storage method and apparatus, electronic device, and storage medium | |
| CN106875146A (en) | The method and device that a kind of grain storage goods yard is reviewed | |
| CN107562808B (en) | Method for verifying heterogeneous double-chain automatic data | |
| CN112948380A (en) | Data storage method and device based on big data, electronic equipment and storage medium | |
| CN111401023B (en) | Report generation method, report generation device, server and storage medium | |
| CN106445897A (en) | Method for automatically filling data information and automatically judging product grade | |
| CN111709221A (en) | Document generation method and system | |
| CN116822054A (en) | Finite element model automatic processing method for rapidly establishing statistical energy subsystem | |
| CN103530436B (en) | Tooling layout drawing parameterization generation method based on AUTOCAD. NET API | |
| CN105955940A (en) | Automatic generation of Word report through Java-based data analysis system | |
| CN113436298B (en) | Method and device for automatically generating Chinese character stroke order animation and related components thereof | |
| CN109446201A (en) | A kind of method for sorting, device and the equipment of Excel table endorsement information | |
| CN105243490B (en) | A kind of statistical system and method based on git software | |
| CN106570004B (en) | Data management method and device | |
| CN116956838A (en) | Project determining method and device for engineering quantity list |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20200515 |
|
| WW01 | Invention patent application withdrawn after publication |