CN105488210B - A kind of batch data matching process and device - Google Patents
A kind of batch data matching process and device Download PDFInfo
- Publication number
- CN105488210B CN105488210B CN201510923726.7A CN201510923726A CN105488210B CN 105488210 B CN105488210 B CN 105488210B CN 201510923726 A CN201510923726 A CN 201510923726A CN 105488210 B CN105488210 B CN 105488210B
- Authority
- CN
- China
- Prior art keywords
- matching
- data
- matched
- batch
- template
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/335—Filtering based on additional data, e.g. user or group profiles
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a kind of batch data matching process and devices, this method comprises: establishing matching template, the matching template includes the customized element information of multiple unique identifications as matched data；Current data to be matched corresponding with the customized element information in listings data to be matched are imported in the matching template；Automatic batch matching is carried out to the current data to be matched, and searches corresponding business paper data in the matching template；After the completion of the batch matching, batch matching result collection information is generated.Batch data matching process and device provided by the present invention, it is no longer necessary to manually enter filter condition, be matched by file, Auto-matching finds user data, so that the process of user filtering data more precise and high efficiency.
Description
Technical field
The present invention relates to technical field of data processing, more particularly to a kind of batch data matching process and device.
Background technique
In existing financial software, the lookup of business paper is matched and is completed usually using the mode of filter condition.
By taking some element " business paper number " in business paper as an example.Business paper provides filter condition, provided in filter condition " from
Definition condition " query function；In " custom condition " query function successively manually enter " business paper number " be equal to 001,
005,007 ... data, and be the relationship of "or" between condition, N item is inputted, after the completion of filter condition manually enters, i.e.,
It may filter that out corresponding N data.
Existing technical solution needs to manually enter filter condition before query traffic data.Manually enter filtering rod piece
Number is almost the same with the business datum item number for needing to filter.User's craft service speed is slow, " measures big and item for what needs filtered
Part is complicated " business datum it is very inconvenient, while it is not high to manually enter accuracy, is easy error.
Summary of the invention
The object of the present invention is to provide a kind of batch data matching process and devices, it is therefore intended that solution needs in the prior art
Manually enter the problem that filter condition, efficiency are lower and accuracy is not high.
In order to solve the above technical problems, the present invention provides a kind of batch data matching process, comprising:
Matching template is established, the matching template includes that the customized element of multiple unique identifications as matched data is believed
Breath；
It will be described in current data importing to be matched corresponding with the customized element information in listings data to be matched
In matching template；
Automatic batch matching is carried out to the current data to be matched, and searches corresponding business sheet in the matching template
According to data；
After the completion of the batch matching, batch matching result collection information is generated.
Optionally, the matching template supports the export of a variety of file format templates.
Optionally, described by current number to be matched corresponding with the customized element information in listings data to be matched
Include: according to importing in the matching template
When the customized element information in the matching template be it is multiple when, by the listings data to be matched with it is multiple
In the customized element information corresponding column whole importing to be matched matching template.
It is optionally, described that automatic batch matching is carried out to the current data to be matched further include:
In Auto-matching provide Data Matching log management, when exist can not matched data when, generation error prompt
Information.
Optionally, after the generation batch matching result collection information further include:
The business paper data found are shown to user.
The present invention also provides a kind of batch data coalignments, comprising:
Module is established, for establishing matching template, the matching template includes multiple unique identifications as matched data
Customized element information；
Import modul, being used for will be corresponding with the customized element information current to be matched in listings data to be matched
Data import in the matching template；
Matching module for carrying out automatic batch matching to the current data to be matched, and searches the matching template
In corresponding business paper data；
Generation module generates batch matching result collection information after the completion of batch matching.
Optionally, the import modul is specifically used for:
When the customized element information in the matching template be it is multiple when, by the listings data to be matched with it is multiple
In the customized element information corresponding column whole importing to be matched matching template.
Optionally, the matching module is also used to:
In Auto-matching provide Data Matching log management, when exist can not matched data when, generation error prompt
Information.
Optionally, further includes:
Display module, for showing the business found to user after generating batch matching result collection information
Bills data.
Batch data matching process and device provided by the present invention include multiple conducts by establishing matching template
The customized element information of unique identification with data；Work as corresponding with customized element information in listings data to be matched
Preceding data to be matched import in matching template；Automatic batch matching is carried out to current data to be matched, and is searched in matching template
Corresponding business paper data；After the completion of batch matches, batch matching result collection information is generated.Lot number provided by the present invention
According to matching process and device, it is no longer necessary to filter condition is manually entered, is matched by file, Auto-matching finds user data,
So that the process of user filtering data more precise and high efficiency.
Detailed description of the invention
It, below will be to embodiment or existing for the clearer technical solution for illustrating the embodiment of the present invention or the prior art
Attached drawing needed in technical description is briefly described, it should be apparent that, the accompanying drawings in the following description is only this hair
Bright some embodiments for those of ordinary skill in the art without creative efforts, can be with root
Other attached drawings are obtained according to these attached drawings.
Fig. 1 is a kind of flow chart of specific embodiment of batch data matching process provided by the present invention；
Fig. 2 is the flow chart of another specific embodiment of batch data matching process provided by the present invention；
Fig. 3 is the flow chart of another specific embodiment of batch data matching process provided by the present invention；
Fig. 4 is the structural block diagram of batch data coalignment provided by the embodiment of the present invention.
Specific embodiment
In order to enable those skilled in the art to better understand the solution of the present invention, with reference to the accompanying drawings and detailed description
The present invention is described in further detail.Obviously, described embodiments are only a part of the embodiments of the present invention, rather than
Whole embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art are not making creative work premise
Under every other embodiment obtained, shall fall within the protection scope of the present invention.
A kind of flow chart of specific embodiment of batch data matching process provided by the present invention was as shown in Figure 1, should
Method includes:
Step S101: establishing matching template, and the matching template includes oneself of multiple unique identifications as matched data
Define element information；
It should be pointed out that matching template is to make matched mould using metadata and Object-Relation Mapping in the application
Plate data.Specifically, the column in template can be bound with entity.
Matching template can inquire needs according to user itself, and progress is customized, and the template defined is for all users
It is shared to use.Matching template once may be repeated use as basic set content, setting.By on certain documents element or
Person's factor combination is arranged to filter condition, as customized element information.
Field element in matching template is the field element on business paper, and every template data and business paper number
According to one-to-one can matching.
Matching template can support the export of a variety of file format templates, such as txt, csv, xml, xls or xlsx, after export
File is entitled " matching template ".
Step S102: by current data to be matched corresponding with the customized element information in listings data to be matched
It imports in the matching template；
Step S103: carrying out automatic batch matching to the current data to be matched, and search it is right in the matching template
The business paper data answered；
Step S104: after the completion of the batch matching, batch matching result collection information is generated.
Batch data matching process and device provided by the present invention include multiple conducts by establishing matching template
The customized element information of unique identification with data；Work as corresponding with customized element information in listings data to be matched
Preceding data to be matched import in matching template；Automatic batch matching is carried out to current data to be matched, and is searched in matching template
Corresponding business paper data；After the completion of batch matches, batch matching result collection information is generated.Lot number provided by the present invention
According to matching process and device, it is no longer necessary to filter condition is manually entered, is matched by file, Auto-matching finds user data,
So that the process of user filtering data more precise and high efficiency.
Below by taking business paper number as an example, to the implementation process of batch data matching process provided by the present invention carry out into
The description of one step.As shown in the flow chart of another specific embodiment of Fig. 2 batch data matching process provided by the present invention,
The process includes:
Step S201: matching template is pre-established；
Step S202: the directly duplication of matched listings data " business paper number " column will be needed to affix to right in matching template
" business paper number " is answered to arrange；
If the customized element defined on matching template during this be it is N number of, by value corresponding in listings data duplication
Corresponding element column are affixed to, are then saved；
Step S203: the instruction that user selects corresponding matching template in business paper list interface is received, to data
Carry out automatic batch matching.
Specifically, " batch matches " function can be increased in business paper list interface, batch can pass through selection when matching
After corresponding matching template, system carries out automatic batch matching.
Further, on the basis of the above embodiments, Data Matching log pipe can also be provided during Auto-matching
Reason, if it exists can not matched data when, generation error prompt information.
Based on any of the above embodiments, the present invention can further include: generate batch matching result collection
After information, the business paper data found are shown to user.
The present invention utilizes metadata and Object-Relation Mapping (ormapping), makes matched data template, in template
Column and entity bind.Template file is uploaded, according to different File Format Analysis data, verifies whether data match, if matching
Matching result collection is then returned, the query interface of business is called according to the matching result collection, matched data exhibiting is arranged to inquiry
On table.
The applicable scene of technical solution of the present invention is more, and business has intercommunity.Non-traffic code is abstracted, is sealed
Dress.Relate generally to three links: matching files parsing, log management, matched data inquiry.
The flow chart of another specific embodiment of batch data matching process provided by the present invention referring to figure 3.,
The realization process of matching process provided by the present embodiment is explained in further detail below.
Step S301: the file comprising matching template is uploaded, file data is parsed according to the format of file；
The format of file can be specially txt, xls etc., this does not influence realization of the invention.
Step S302: file data is read, file object is obtained；
Specifically, which can be obtained by FMTaskExternalCodeRunner.onInitResources () method
To file object reader.
Step S303: carrying out circulation matching to file object by the method for traversal, is put into matching result collection if matching
Otherwise object matching error information is recorded in log object.
As a kind of specific embodiment, execution can be passed through
FMTaskRecordRunnerAdapter.onMainRunningProcess () method traverses reader pairs of previous step
As, it is called in FMTaskExternalCodeRunner.onEachRunningLoop () method, what business needed to realize
IFMDataTransmission.isMatch () interface method is put into matching knot to verify whether data match if matching
Fruit collects object, conversely, then record matching error message is to log object.
Step S304: the query interface of business is called according to matching result collection, matched data result is presented to inquiry
In list.
Batch data coalignment provided in an embodiment of the present invention is introduced below, batch data described below
Reference can be corresponded to each other with above-described batch data matching process with device.
Fig. 4 is the structural block diagram of batch data coalignment provided in an embodiment of the present invention, is matched referring to Fig. 4 batch data
Device may include:
Module 100 is established, for establishing matching template, the matching template includes multiple unique marks as matched data
The customized element information known；
Import modul 200, for by listings data to be matched it is corresponding with the customized element information currently to
Matched data imports in the matching template；
Matching module 300 for carrying out automatic batch matching to the current data to be matched, and searches the matching mould
Corresponding business paper data in plate；
Generation module 400 generates batch matching result collection information after the completion of batch matching.
As a kind of specific embodiment, in batch data coalignment provided by the present invention, import modul 200 can be with
It is specifically used for:
When the customized element information in the matching template be it is multiple when, by the listings data to be matched with it is multiple
In the customized element information corresponding column whole importing to be matched matching template.
As a kind of specific embodiment, in batch data coalignment provided by the present invention, matching module 300 can be with
It is further used for:
In Auto-matching provide Data Matching log management, when exist can not matched data when, generation error prompt
Information.
As a kind of specific embodiment, batch data coalignment provided by the present invention be can further include:
Display module, for showing the business found to user after generating batch matching result collection information
Bills data.
Batch data coalignment provided by the present invention is used as matched data comprising multiple by establishing matching template
Unique identification customized element information；By in listings data to be matched it is corresponding with customized element information currently to
It is imported in matching template with data；Automatic batch matching is carried out to current data to be matched, and is searched corresponding in matching template
Business paper data；After the completion of batch matches, batch matching result collection information is generated.Batch data matching provided by the present invention
Device is searched by system and is searched instead of artificial, automatically so that the efficiency of user's processing business significantly improves, and due to template number
According to can direct copying generate, match come data error rate be almost reduced to 0.In addition, the application development process is simple, scalability
By force, the exploitation at the end GUI, Web is supported.
Each embodiment in this specification is described in a progressive manner, the highlights of each of the examples are with it is other
The difference of embodiment, same or similar part may refer to each other between each embodiment.For being filled disclosed in embodiment
For setting, since it is corresponded to the methods disclosed in the examples, so being described relatively simple, related place is referring to method part
Explanation.
Professional further appreciates that, unit described in conjunction with the examples disclosed in the embodiments of the present disclosure
And algorithm steps, can be realized with electronic hardware, computer software, or a combination of the two, in order to clearly demonstrate hardware and
The interchangeability of software generally describes each exemplary composition and step according to function in the above description.These
Function is implemented in hardware or software actually, the specific application and design constraint depending on technical solution.Profession
Technical staff can use different methods to achieve the described function each specific application, but this realization is not answered
Think beyond the scope of this invention.
The step of method described in conjunction with the examples disclosed in this document or algorithm, can directly be held with hardware, processor
The combination of capable software module or the two is implemented.Software module can be placed in random access memory (RAM), memory, read-only deposit
Reservoir (ROM), electrically programmable ROM, electrically erasable ROM, register, hard disk, moveable magnetic disc, CD-ROM or technology
In any other form of storage medium well known in field.
Batch data matching process provided by the present invention and device are described in detail above.It is used herein
A specific example illustrates the principle and implementation of the invention, and the above embodiments are only used to help understand
Method and its core concept of the invention.It should be pointed out that for those skilled in the art, not departing from this
, can be with several improvements and modifications are made to the present invention under the premise of inventive principle, these improvement and modification also fall into the present invention
In scope of protection of the claims.
Claims (9)
1. a kind of batch data matching process characterized by comprising
Matching template is established, the matching template includes the customized element information of multiple unique identifications as matched data；
Current data to be matched corresponding with the customized element information in listings data to be matched are imported into the matching
In template；
Automatic batch matching is carried out to the current data to be matched, and searches corresponding business paper number in the matching template
According to；
After the completion of the batch matching, batch matching result collection information is generated.
2. batch data matching process as described in claim 1, which is characterized in that the matching template supports a variety of trays
The export of formula template.
3. batch data matching process as described in claim 1, which is characterized in that it is described by listings data to be matched with institute
It states the corresponding current data to be matched of customized element information and imports in the matching template and include:
When the customized element information in the matching template be it is multiple when, by the listings data to be matched with it is multiple described
In the customized element information corresponding column whole importing to be matched matching template.
4. batch data matching process as claimed in claim 3, which is characterized in that it is described to the current data to be matched into
The matching of row automatic batch further include:
In Auto-matching provide Data Matching log management, when exist can not matched data when, generation error prompt information.
5. such as the described in any item batch data matching process of Claims 1-4, which is characterized in that in the generation batch
After result set information further include:
The business paper data found are shown to user.
6. a kind of batch data coalignment characterized by comprising
Module is established, for establishing matching template, the matching template includes oneself of multiple unique identifications as matched data
Define element information；
Import modul is used for current data to be matched corresponding with the customized element information in listings data to be matched
It imports in the matching template；
Matching module, for carrying out automatic batch matching to the current data to be matched, and search it is right in the matching template
The business paper data answered；
Generation module generates batch matching result collection information after the completion of batch matching.
7. batch data coalignment as claimed in claim 6, which is characterized in that the import modul is specifically used for:
When the customized element information in the matching template be it is multiple when, by the listings data to be matched with it is multiple described
In the customized element information corresponding column whole importing to be matched matching template.
8. batch data coalignment as claimed in claim 7, which is characterized in that the matching module is also used to:
In Auto-matching provide Data Matching log management, when exist can not matched data when, generation error prompt information.
9. such as the described in any item batch data coalignments of claim 6 to 8, which is characterized in that further include:
Display module, for showing the business paper found to user after generating batch matching result collection information
Data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510923726.7A CN105488210B (en) | 2015-12-11 | 2015-12-11 | A kind of batch data matching process and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510923726.7A CN105488210B (en) | 2015-12-11 | 2015-12-11 | A kind of batch data matching process and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105488210A CN105488210A (en) | 2016-04-13 |
| CN105488210B true CN105488210B (en) | 2019-02-12 |
Family
ID=55675185
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510923726.7A Active CN105488210B (en) | 2015-12-11 | 2015-12-11 | A kind of batch data matching process and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105488210B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109741792A (en) * | 2018-12-21 | 2019-05-10 | 北京优迅医学检验实验室有限公司 | A kind of storage processing method and processing device of genetic test sample |
| CN109885591A (en) * | 2019-01-17 | 2019-06-14 | 平安城市建设科技(深圳)有限公司 | Information batch processing method, equipment, storage medium and device |
| CN110188030A (en) * | 2019-04-08 | 2019-08-30 | 平安科技（深圳）有限公司 | A kind of test data generating method, device and computer equipment, storage medium |
| CN110851687A (en) * | 2019-11-11 | 2020-02-28 | 厦门市美亚柏科信息股份有限公司 | Data identification method, terminal equipment and storage medium |
| CN111144334B (en) * | 2019-12-27 | 2023-09-26 | 北京天融信网络安全技术有限公司 | File matching method and device, electronic equipment and storage medium |
| CN111414141A (en) * | 2020-03-17 | 2020-07-14 | 山东浪潮易云在线科技有限公司 | Method and system for generating visual intelligent layout printing template based on SaaS mode |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102955802A (en) * | 2011-08-25 | 2013-03-06 | 阿里巴巴集团控股有限公司 | Method and device for acquiring data from data reports |
| CN104077369A (en) * | 2014-06-20 | 2014-10-01 | 用友软件股份有限公司 | Multi-dimension data matching device and method |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070005635A1 (en) * | 2005-07-01 | 2007-01-04 | Microsoft Corporation | Importing database data to a non-database program |
-
2015
- 2015-12-11 CN CN201510923726.7A patent/CN105488210B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102955802A (en) * | 2011-08-25 | 2013-03-06 | 阿里巴巴集团控股有限公司 | Method and device for acquiring data from data reports |
| CN104077369A (en) * | 2014-06-20 | 2014-10-01 | 用友软件股份有限公司 | Multi-dimension data matching device and method |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105488210A (en) | 2016-04-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105488210B (en) | A kind of batch data matching process and device | |
| CN110188096B (en) | Index creating method, device and equipment for data record | |
| CN110162662B (en) | Verification method, device and equipment for data records in block chain type account book | |
| CN103049271B (en) | The method and apparatus of the description document of automatic generation api interface | |
| CN104699718B (en) | Method and apparatus for being rapidly introduced into business datum | |
| CN111352935B (en) | Index creating method, device and equipment in block chain type account book | |
| CN110162526B (en) | Method, device and equipment for inquiring data records in block chain type account book | |
| CN104182484B (en) | A kind of method and apparatus for realizing HBase data and the mapping of Java field object | |
| TW202040387A (en) | Method for constructing index of data record | |
| CN103577516A (en) | Method and device for displaying contents | |
| CN106598672A (en) | Application configuration method and apparatus | |
| CN110349019B (en) | Verification method, device and equipment in block chain type account book | |
| CN105930325B (en) | A kind of file report compares the conversed analysis method and device of difference | |
| CN108241642B (en) | File analysis method and device | |
| CN106960020B (en) | A kind of method and apparatus creating concordance list | |
| CN110245145A (en) | Structure synchronization method and apparatus of the relevant database to Hadoop database | |
| CN104717251B (en) | OpenStack cloud computing management platform Cell node scheduling method and systems | |
| CN103714004A (en) | JVM online memory leak analysis method and system | |
| CN110019200B (en) | Index establishing and using method and device | |
| CN110879687B (en) | Data reading method, device and equipment based on disk storage | |
| CN106843820A (en) | Code process method and apparatus | |
| CN108241503A (en) | The generation method and device of explanatory notes | |
| CN106776779B (en) | Method for generating entity file by JSON data based on Mac platform | |
| CN108133017A (en) | A kind of multi-data source acquisition configuration method and device | |
| CN114153910A (en) | Data acquisition method and device, electronic device and computer program product |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |