CN110472216A - Determination method, apparatus, storage medium and the electronic device of field - Google Patents
Determination method, apparatus, storage medium and the electronic device of field Download PDFInfo
- Publication number
- CN110472216A CN110472216A CN201910765683.2A CN201910765683A CN110472216A CN 110472216 A CN110472216 A CN 110472216A CN 201910765683 A CN201910765683 A CN 201910765683A CN 110472216 A CN110472216 A CN 110472216A
- Authority
- CN
- China
- Prior art keywords
- field
- data
- tables
- priority
- scheduled
- 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.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides determination method, apparatus, storage medium and the electronic devices of a kind of field, comprising: determines the scheduled field recorded respectively in multiple tables of data, wherein content corresponding to the scheduled field recorded in each tables of data is different or part is identical；According to the table priority of multiple tables of data, and/or the field priority of the scheduled field recorded respectively in multiple tables of data, aiming field is determined from the scheduled field recorded respectively in multiple tables of data, and content corresponding to the aiming field is determined as object content.Through the invention, it solves and the problem of can not determining the field needed in fusion process in multiple identical fields is being carried out to multiple tables of data, and then achieved the effect that more efficient, accurate completion data fusion.
Description
Technical field
The present invention relates to the communications fields, in particular to determination method, apparatus, storage medium and the electricity of a kind of field
Sub-device.
Background technique
During map construction, data fusion is needed.By the data fusion in multiple tables in a table.In multiple tables
During data fusion, it can usually meet in multiple tables that there are duplicate fields, and data corresponding under duplicate field
Difference, at this point, can not determine that data corresponding under the field in which table are more accurate data.For example, carrying out data
Exist in the Tables 1 and 2 of fusion field " ID card No. ", and the data under 1 field of table " ID card No. " and 2 word of table
Data under section " ID card No. " are entirely different or that there are parts is identical, can not determine select in the tables of data of fusion at this time
Select the data under the data or 2 field of table " ID card No. " under 1 field of table " ID card No. ".
For in the related technology, carried out in fusion process to multiple tables of data, it can not be in multiple identical fields really
Not yet there is an effective solution scheme at present in the problem of field needed surely.
Summary of the invention
The embodiment of the invention provides determination method, apparatus, storage medium and the electronic devices of a kind of field, at least to solve
Certainly in the related technology multiple tables of data are being carried out not determine the field needed in fusion process in multiple identical fields
The problem of.
According to one embodiment of present invention, a kind of determination method of field is provided, comprising: determine in multiple tables of data
The scheduled field recorded respectively, wherein the difference of content corresponding to the scheduled field recorded in each tables of data or part phase
Together；According to the scheduled field recorded respectively in the table priority of multiple tables of data and/or multiple tables of data
Field priority determines aiming field from the scheduled field recorded respectively in multiple tables of data, and by the mesh
Content corresponding to marking-up section is determined as object content.
Optionally, it is recorded respectively in the table priority and/or multiple tables of data according to multiple tables of data
The field priority of the scheduled field determines target word from the scheduled field recorded respectively in multiple tables of data
Section, and before content corresponding to the aiming field is determined as object content, the method also includes: according to the data
The data quality checking result of table and/or the data source of the tables of data determine that the table priority and/or the field are excellent
First grade.
Optionally, it is determined according to the data source of the data quality checking result of the tables of data and/or the tables of data
The table priority and/or the field priority, comprising: the table priority is determined according to the data source of the tables of data
Afterwards, the field priority is determined further according to the data quality checking result of the tables of data.
Optionally, include the first tables of data and the second data packet table in multiple tables of data, determine first data
The scheduled field of table is the first scheduled field, and the scheduled field of second tables of data is the second scheduled field, wherein from multiple
Aiming field is determined in the scheduled field recorded respectively in the tables of data, comprising: in first scheduled field and institute
State the second scheduled field there are in the case where field priority, in first scheduled field and second scheduled field really
Determining the high field of field priority is the aiming field；It is not present in first scheduled field and second scheduled field
Field priority, and first tables of data and second tables of data be there are in the case where table priority, in first word
Determine that the high field of table priority is the aiming field in section and second field.
Optionally, aiming field is determined from the scheduled field recorded respectively in multiple tables of data, comprising: will
Multiple tables of data are fused to target matrix；There are the fields of field priority according to field in the target matrix
Priority is ranked up, and there is no the fields of field priority to be ranked up according to table priority；Determine sort it is forward described
Scheduled field is the aiming field.
Optionally it is determined that after the forward scheduled field of sequence is the aiming field, the method also includes: In
Other scheduled fields other than the aiming field are deleted in the target matrix.
According to another embodiment of the invention, a kind of determining device of field is provided, comprising: the first determining module,
For determining the scheduled field recorded respectively in multiple tables of data, wherein the scheduled field institute recorded in each tables of data is right
The content answered is different or part is identical；Second determining module, for the table priority according to multiple tables of data, and/or it is more
The field priority of the scheduled field recorded respectively in a tables of data records respectively from multiple tables of data
Aiming field is determined in the scheduled field, and content corresponding to the aiming field is determined as object content.
Optionally, described device further include: third determining module, for preferential in the table according to multiple tables of data
The field priority of the scheduled field recorded respectively in grade and/or multiple tables of data, from multiple tables of data
Aiming field is determined in the scheduled field recorded respectively, and content corresponding to the aiming field is determined as in target
Before appearance, determine that the table is excellent according to the data source of the data quality checking result of the tables of data and/or the tables of data
First grade and/or the field priority.
Optionally, the third determining module is also used to determine the table priority according to the data source of the tables of data
Afterwards, the field priority is determined further according to the data quality checking result of the tables of data.
Optionally, include the first tables of data and the second data packet table in multiple tables of data, determine first data
The scheduled field of table is the first scheduled field, and the scheduled field of second tables of data is the second scheduled field, wherein described the
Two determining modules include: the first determination unit, in first scheduled field and second scheduled field, there are fields
In the case where priority, determine that the high field of field priority is in first scheduled field and second scheduled field
The aiming field；Second determination unit, for field to be not present in first scheduled field and second scheduled field
Priority, and first tables of data and second tables of data be there are in the case where table priority, in first field and
Determine that the high field of table priority is the aiming field in second field.
According to still another embodiment of the invention, a kind of storage medium is additionally provided, meter is stored in the storage medium
Calculation machine program, wherein the computer program is arranged to execute the step in any of the above-described embodiment of the method when operation.
According to still another embodiment of the invention, a kind of electronic device, including memory and processor are additionally provided, it is described
Computer program is stored in memory, the processor is arranged to run the computer program to execute any of the above-described
Step in embodiment of the method.
Through the invention, due to by determining the scheduled field recorded respectively in multiple tables of data, wherein in each tables of data
Content corresponding to the scheduled field of record is different or part is identical；According to the table priority of multiple tables of data and/or multiple numbers
According to the field priority of the scheduled field recorded respectively in table, mesh is determined from the scheduled field recorded respectively in multiple tables of data
Marking-up section, and content corresponding to aiming field is determined as object content.Therefore, it can solve and carried out to multiple tables of data
In fusion process, can not be determined in multiple identical fields need field the problem of, reach more efficiently, accurately complete
The effect of data fusion.
Detailed description of the invention
The drawings described herein are used to provide a further understanding of the present invention, constitutes part of this application, this hair
Bright illustrative embodiments and their description are used to explain the present invention, and are not constituted improper limitations of the present invention.In the accompanying drawings:
Fig. 1 is a kind of hardware block diagram of the mobile terminal of the determination method of field of the embodiment of the present invention；
Fig. 2 is the flow chart of the determination method of field according to an embodiment of the present invention；
Fig. 3 is the structural block diagram of the determining device of field according to an embodiment of the present invention.
Specific embodiment
Hereinafter, the present invention will be described in detail with reference to the accompanying drawings and in combination with Examples.It should be noted that not conflicting
In the case of, the features in the embodiments and the embodiments of the present application can be combined with each other.
It should be noted that description and claims of this specification and term " first " in above-mentioned attached drawing, "
Two " etc. be to be used to distinguish similar objects, without being used to describe a particular order or precedence order.
Embodiment of the method provided by the embodiment of the present application one can be in mobile terminal, terminal or similar fortune
It calculates and is executed in device.For running on mobile terminals, Fig. 1 is a kind of shifting of the determination method of field of the embodiment of the present invention
The hardware block diagram of dynamic terminal.As shown in Figure 1, mobile terminal 10 may include one or more (only showing one in Fig. 1)
(processor 102 can include but is not limited to the processing dress of Micro-processor MCV or programmable logic device FPGA etc. to processor 102
Set) and memory 104 for storing data, optionally, above-mentioned mobile terminal can also include the transmission for communication function
Equipment 106 and input-output equipment 108.It will appreciated by the skilled person that structure shown in FIG. 1 is only to illustrate,
It does not cause to limit to the structure of above-mentioned mobile terminal.For example, mobile terminal 10 may also include it is more than shown in Fig. 1 or
Less component, or with the configuration different from shown in Fig. 1.
Memory 104 can be used for storing computer program, for example, the software program and module of application software, such as this hair
The corresponding computer program of determination method of field in bright embodiment, processor 102 are stored in memory 104 by operation
Computer program realize above-mentioned method thereby executing various function application and data processing.Memory 104 can wrap
Include high speed random access memory, may also include nonvolatile memory, as one or more magnetic storage device, flash memory or
Other non-volatile solid state memories.In some instances, memory 104 can further comprise long-range relative to processor 102
The memory of setting, these remote memories can pass through network connection to mobile terminal 10.The example of above-mentioned network include but
It is not limited to internet, intranet, local area network, mobile radio communication and combinations thereof.
Transmitting device 106 is used to that data to be received or sent via a network.Above-mentioned network specific example may include
The wireless network that the communication providers of mobile terminal 10 provide.In an example, transmitting device 106 includes a Network adaptation
Device (Network Interface Controller, referred to as NIC), can be connected by base station with other network equipments to
It can be communicated with internet.In an example, transmitting device 106 can for radio frequency (Radio Frequency, referred to as
RF) module is used to wirelessly be communicated with internet.
A kind of determination method of field for running on above-mentioned mobile terminal is provided in the present embodiment, and Fig. 2 is according to this
The flow chart of the determination method of the field of inventive embodiments, as shown in Fig. 2, the process includes the following steps:
Step S202 determines the scheduled field recorded respectively in multiple tables of data, wherein what is recorded in each tables of data is described
Content corresponding to scheduled field is different or part is identical；
Wherein, scheduled field is identical field in multiple tables of data.By taking multiple tables of data are two as an example, tables of data 1
With include " ID card No. " in tables of data 2, then " ID card No. " in tables of data 1 and tables of data 2 is scheduled field,
Data corresponding under " ID card No. " field can be entirely different in two tables of data, and it is identical that there may also be parts.
Step S204, according to what is recorded respectively in the table priority of multiple tables of data and/or multiple tables of data
The field priority of the scheduled field determines target word from the scheduled field recorded respectively in multiple tables of data
Section, and content corresponding to the aiming field is determined as object content.
Wherein, by taking the scheduled field " ID card No. " in tables of data 1 and tables of data 2 as an example, tables of data 1 and tables of data 2
Have with the scheduled field " ID card No. " in table priority or table 1 with the scheduled field " ID card No. " in table 2
Field priority can determine " the identity in a table according to table priority and/or field priority in table 1 or table 2
Demonstrate,prove number " it is used as aiming field, corresponding data are target data under aiming field, are carrying out fused number to tables of data
According to content corresponding to reservation aiming field in table and aiming field.
Through the above steps, due to by determining the scheduled field recorded respectively in multiple tables of data, wherein each tables of data
Content corresponding to the scheduled field of middle record is different or part is identical；According to the table priority of multiple tables of data and/or multiple
The field priority of the scheduled field recorded respectively in tables of data is determined from the scheduled field recorded respectively in multiple tables of data
Aiming field, and content corresponding to aiming field is determined as object content.Therefore, can solve to multiple tables of data into
In row fusion process, can not be determined in multiple identical fields need field the problem of, reach more efficiently, accurately it is complete
At the effect of data fusion.
Optionally, the executing subject of above-mentioned steps can be terminal etc., but not limited to this.
In an alternative embodiment, in the table priority and/or multiple tables of data according to multiple tables of data
The field priority of the scheduled field recorded respectively, from the scheduled field recorded respectively in multiple tables of data
Determine aiming field, and before content corresponding to the aiming field is determined as object content, the method also includes: root
According to the data quality checking result of the tables of data and/or the data source of the tables of data determine the table priority and/or
The field priority.In the present embodiment, the quality of data in tables of data can be assessed by data quality checking,
Control rate such as data is low, and uniqueness well so represents the height of the quality of data in the tables of data, and corresponding table priority is high, can also
To carry out data quality checking for field, the priority of the corresponding quality of data height so field of field is just high.It can also root
The priority of table or field is ranked up according to the source of data.The source of data can be from network, be also possible to
From physical mechanism.Since the data on network are there are certain uncertainty, network data is relative to from physical machine
The priority for the data that structure obtains is low.Correspondingly, can also be according to the data source corresponding to field to the preferential grading of field
Row sequence.The source of data can be by being labeled in table or in field.
In an alternative embodiment, according to the number of the data quality checking result of the tables of data and/or the tables of data
The table priority and/or the field priority are determined according to source, comprising: institute is determined according to the data source of the tables of data
After stating table priority, the field priority is determined further according to the data quality checking result of the tables of data.In the present embodiment
In, can first according to the source of tables of data carry out priority ranking, further according to data quality checking result to the field in table into
Row sequence.To avoid in the identical situation of table priority, aiming field can not be determined.That is, if the data of multiple tables of data
Source is network, then can carry out priority ranking to the field in table according to the quality measurements of data.
Include the first tables of data and the second data packet table in an alternative embodiment, multiple tables of data, determines institute
The scheduled field for stating the first tables of data is the first scheduled field, and the scheduled field of second tables of data is the second scheduled field,
Wherein, aiming field is determined from the scheduled field recorded respectively in multiple tables of data, comprising: pre- described first
Field and second scheduled field are determined there are in the case where field priority, in first scheduled field and described second pre-
Determine to determine that the high field of field priority is the aiming field in field；Make a reservation in first scheduled field and described second
Field is not present field priority, and first tables of data and second tables of data be there are in the case where table priority, In
Determine that the high field of table priority is the aiming field in first field and second field.In the present embodiment,
By taking multiple tables of data are two tables of data as an example, have in Tables 1 and 2 scheduled field " ID card No. ", the field in table 1
" ID card No. " corresponds to the first scheduled field, and the field " ID card No. " in table 2 corresponds to the second scheduled field, the
One scheduled field and the second scheduled field are there are in the case where field priority, for example, the priority of the first scheduled field is higher than
The priority of second scheduled field, then it is determined that high the first scheduled field of priority is aiming field, the first scheduled field institute
Corresponding data content is object content.The case where field priority is not present in the first scheduled field and the second scheduled field
Under, aiming field is determined according to the table priority of Tables 1 and 2, for example, if the priority of table 1 is greater than the priority of table 2, then
Determine that the first scheduled field " ID card No. " in table 1 is aiming field, the first scheduled field " ID card No. " institute in table 1
Corresponding data content is object content.
In an alternative embodiment, target word is determined from the scheduled field recorded respectively in multiple tables of data
Section, comprising: multiple tables of data are fused to target matrix；There are the words of field priority in the target matrix
Section is ranked up according to field priority, and there is no the fields of field priority to be ranked up according to table priority；Determine sequence
The forward scheduled field is the aiming field.In the present embodiment, to merge the data instance in Tables 1 and 2, first
By each field of field and the corresponding data fusion of field in a target matrix, in Tables 1 and 2 in Tables 1 and 2
On be labeled with the priority of table where the field or the priority of the field, firstly, all of field priority will be present
Field is ranked up according to priority, and the field of no field priority is ranked up according to the table priority where it,
It is come according to the field of table priority ranking under the field according to field sequence, determines the forward word that sorts according to priority orders
Section is aiming field.
In an alternative embodiment, determine that the forward scheduled field that sorts is the side after the aiming field
Method further include: other scheduled fields other than the aiming field are deleted in the target matrix.In the present embodiment
In, by taking scheduled field " ID card No. " existing in Tables 1 and 2 as an example, by the data fusion in Tables 1 and 2 to target
In tables of data, the scheduled field " ID card No. " of table 1 is the first scheduled field, and the scheduled field " ID card No. " of table 2 is
Second scheduled field, in the case where determining the first scheduled field is aiming field, by the first scheduled field and its is corresponding
Data are retained in target matrix, and the second scheduled field and its corresponding data are deleted in target matrix.If both
There is no field priority, and table priority is also not present, then determining aiming field by artificial detection.
Illustrate the application below by a specific embodiment.It mainly proposes to be based on field priority and table in the present embodiment
The comprehensive priority convergence strategy of grade priority carries out.
1) selection needs the original table and object table merged；
2) table level priority is first configured for multiple original tables, is carrying out field priority for certain special same fields
Sequence；
3) during fusion, if encountering has same field to need to be fused in the object table in multiple tables, lead to
It crosses under type such as and determines aiming field and object content corresponding thereto.
A. it if the field has field level priority, is ranked up according to the priority of field, takes in sequence first
Data in the table of this data non-empty；
B. if the field does not have field level priority, according to table level priority ranking, first this number in sequence is taken
According to the data in the table of non-empty.
4) the table level priority and field priority ranking of the original table in fusion process can be adjusted according to the effect of fusion,
The quality of data of optimization fusion；
5) it encounters new fusion situation and then 1) carries out circulate operation to 4) this mode according to above-mentioned.
For original table A1, A2 are fused to object table B, such as following step:
1) selection needs original table A1, the A2 and object table B merged；
2) for progress table level in multiple original tables and field level sequence, such as corresponding table segment priority: A1, A2, and
The corresponding field priority of special field " identification card number ": A2, A1；
3) during fusion, for generic field, then according to the sequence of table level priority, A1, A2 first is successively taken
Data in the table of a data non-empty；
For special field " identification card number ", then according to the sequence of field priority, first this data of A2, A1 are successively taken
Data in the table of non-empty；
4) it if it is checked that coming that the 2 table quality of data of Table A is integrally more preferable, is arranged according to the priority that the effect of fusion then adjusts table
Sequence is A2, A1, re-executes the fusion process, the quality of data of optimization fusion；
5) it encounters new fusion situation and then 1) carries out circulate operation to 4) this mode according to this.
Through the above description of the embodiments, those skilled in the art can be understood that according to above-mentioned implementation
The method of example can be realized by means of software and necessary general hardware platform, naturally it is also possible to by hardware, but it is very much
In the case of the former be more preferably embodiment.Based on this understanding, technical solution of the present invention is substantially in other words to existing
The part that technology contributes can be embodied in the form of software products, which is stored in a storage
In medium (such as ROM/RAM, magnetic disk, CD), including some instructions are used so that a terminal device (can be mobile phone, calculate
Machine, server or network equipment etc.) execute method described in each embodiment of the present invention.
Embodiment 2
A kind of determining device of field is additionally provided in the present embodiment, and the device is for realizing above-described embodiment and preferably
Embodiment, the descriptions that have already been made will not be repeated.As used below, predetermined function may be implemented in term " module "
The combination of software and/or hardware.Although device described in following embodiment is preferably realized with software, hardware, or
The realization of the combination of person's software and hardware is also that may and be contemplated.
Fig. 3 is the structural block diagram of the determining device of field according to an embodiment of the present invention, as shown in figure 3, the device includes:
First determining module 32, for determining the scheduled field recorded respectively in multiple tables of data, wherein the institute recorded in each tables of data
It states the difference of content corresponding to scheduled field or part is identical；Second determining module 34, for according to multiple tables of data
The field priority of the scheduled field recorded respectively in table priority and/or multiple tables of data, from multiple numbers
According to aiming field determining in the scheduled field recorded respectively in table, and content corresponding to the aiming field is determined as
Object content.
In an alternative embodiment, described device further include: third determining module, for according to multiple tables of data
Table priority and/or multiple tables of data in the field priority of the scheduled field that records respectively, from multiple described
Aiming field is determined in the scheduled field recorded respectively in tables of data, and content corresponding to the aiming field is determined
Before object content, determined according to the data source of the data quality checking result of the tables of data and/or the tables of data
The table priority and/or the field priority.
In an alternative embodiment, the third determining module is also used to determine institute according to the data source of the tables of data
After stating table priority, the field priority is determined further according to the data quality checking result of the tables of data.
Include the first tables of data and the second data packet table in an alternative embodiment, multiple tables of data, determines institute
The scheduled field for stating the first tables of data is the first scheduled field, and the scheduled field of second tables of data is the second scheduled field,
Wherein, second determining module includes: the first determination unit, in first scheduled field and second reserved word
Section determines field priority there are in the case where field priority in first scheduled field and second scheduled field
High field is the aiming field；Second determination unit, in first scheduled field and second scheduled field
There is no field priority, and first tables of data and second tables of data be there are in the case where table priority, described
Determine that the high field of table priority is the aiming field in first field and second field.
Optionally, described device is also used to multiple tables of data being fused to target matrix；In the target data
There are the fields of field priority in table is ranked up according to field priority, and it is excellent according to table that there is no the fields of field priority
First grade is ranked up；Determine that the forward scheduled field that sorts is the aiming field.
Optionally, described device is also used to after determining that the forward scheduled field that sorts is the aiming field
Other scheduled fields other than the aiming field are deleted in the target matrix.
It should be noted that above-mentioned modules can be realized by software or hardware, for the latter, Ke Yitong
Following manner realization is crossed, but not limited to this: above-mentioned module is respectively positioned in same processor；Alternatively, above-mentioned modules are with any
Combined form is located in different processors.
The embodiments of the present invention also provide a kind of storage medium, computer program is stored in the storage medium, wherein
The computer program is arranged to execute the step in any of the above-described embodiment of the method when operation.
Optionally, in the present embodiment, above-mentioned storage medium can be set to store by executing based on following steps
Calculation machine program:
S1 determines the scheduled field recorded respectively in multiple tables of data, wherein the reserved word recorded in each tables of data
Content corresponding to section is different or part is identical；
S2, it is described pre- according to being recorded respectively in the table priority of multiple tables of data and/or multiple tables of data
The field priority for determining field determines aiming field from the scheduled field recorded respectively in multiple tables of data, and
Content corresponding to the aiming field is determined as object content.
Optionally, in the present embodiment, above-mentioned storage medium can include but is not limited to: USB flash disk, read-only memory (Read-
Only Memory, referred to as ROM), it is random access memory (Random Access Memory, referred to as RAM), mobile hard
The various media that can store computer program such as disk, magnetic or disk.
The embodiments of the present invention also provide a kind of electronic device, including memory and processor, stored in the memory
There is computer program, which is arranged to run computer program to execute the step in any of the above-described embodiment of the method
Suddenly.
Optionally, above-mentioned electronic device can also include transmission device and input-output equipment, wherein the transmission device
It is connected with above-mentioned processor, which connects with above-mentioned processor.
Optionally, in the present embodiment, above-mentioned processor can be set to execute following steps by computer program:
S1 determines the scheduled field recorded respectively in multiple tables of data, wherein the reserved word recorded in each tables of data
Content corresponding to section is different or part is identical；
S2, it is described pre- according to being recorded respectively in the table priority of multiple tables of data and/or multiple tables of data
The field priority for determining field determines aiming field from the scheduled field recorded respectively in multiple tables of data, and
Content corresponding to the aiming field is determined as object content.
Optionally, the specific example in the present embodiment can be with reference to described in above-described embodiment and optional embodiment
Example, details are not described herein for the present embodiment.
Obviously, those skilled in the art should be understood that each module of the above invention or each step can be with general
Computing device realize that they can be concentrated on a single computing device, or be distributed in multiple computing devices and formed
Network on, optionally, they can be realized with the program code that computing device can perform, it is thus possible to which they are stored
It is performed by computing device in the storage device, and in some cases, it can be to be different from shown in sequence execution herein
Out or description the step of, perhaps they are fabricated to each integrated circuit modules or by them multiple modules or
Step is fabricated to single integrated circuit module to realize.In this way, the present invention is not limited to any specific hardware and softwares to combine.
The foregoing is only a preferred embodiment of the present invention, is not intended to restrict the invention, for the skill of this field
For art personnel, the invention may be variously modified and varied.It is all within principle of the invention, it is made it is any modification, etc.
With replacement, improvement etc., should all be included in the protection scope of the present invention.
Claims (10)
1. a kind of determination method of field characterized by comprising
Determine the scheduled field recorded respectively in multiple tables of data, wherein the scheduled field institute recorded in each tables of data is right
The content answered is different or part is identical；
According to the scheduled field recorded respectively in the table priority of multiple tables of data and/or multiple tables of data
Field priority, aiming field is determined from the scheduled field recorded respectively in multiple tables of data, and will be described
Content corresponding to aiming field is determined as object content.
2. the method according to claim 1, wherein in the table priority according to multiple tables of data, and/or
The field priority of the scheduled field recorded respectively in multiple tables of data records respectively from multiple tables of data
The scheduled field in determine aiming field, and before content corresponding to the aiming field is determined as object content,
The method also includes:
The table priority is determined according to the data source of the data quality checking result of the tables of data and/or the tables of data
And/or the field priority.
3. according to the method described in claim 2, it is characterized in that, according to the data quality checking result of the tables of data and/
Or the data source of the tables of data determines the table priority and/or the field priority, comprising:
After determining the table priority according to the data source of the tables of data, further according to the data quality checking of the tables of data
As a result the field priority is determined.
4. the method according to claim 1, wherein including the first tables of data and second in multiple tables of data
Data packet table determines that the scheduled field of first tables of data is the first scheduled field, the scheduled field of second tables of data
For the second scheduled field, wherein determine aiming field, packet from the scheduled field recorded respectively in multiple tables of data
It includes:
In first scheduled field and second scheduled field there are in the case where field priority, make a reservation for described first
Determine that the high field of field priority is the aiming field in field and second scheduled field；
Field priority, and first tables of data and institute is not present in first scheduled field and second scheduled field
The second tables of data is stated there are in the case where table priority, determines that table priority is high in first field and second field
Field be the aiming field.
5. a kind of determining device of field characterized by comprising
First determining module, for determining the scheduled field recorded respectively in multiple tables of data, wherein recorded in each tables of data
Content corresponding to the scheduled field is different or part is identical；
Second determining module, for remembering respectively in the table priority and/or multiple tables of data according to multiple tables of data
The field priority of the scheduled field of record determines mesh from the scheduled field recorded respectively in multiple tables of data
Marking-up section, and content corresponding to the aiming field is determined as object content.
6. device according to claim 5, which is characterized in that described device further include:
Third determining module, for distinguishing in the table priority and/or multiple tables of data according to multiple tables of data
The field priority of the scheduled field of record is determined from the scheduled field recorded respectively in multiple tables of data
Aiming field, and before content corresponding to the aiming field is determined as object content, according to the data of the tables of data
The data source of quality measurements and/or the tables of data determines the table priority and/or the field priority.
7. device according to claim 6, which is characterized in that the third determining module is also used to according to the tables of data
Data source determine the table priority after, determine that the field is excellent further according to the data quality checking result of the tables of data
First grade.
8. device according to claim 5, which is characterized in that include the first tables of data and second in multiple tables of data
Data packet table determines that the scheduled field of first tables of data is the first scheduled field, the scheduled field of second tables of data
For the second scheduled field, wherein second determining module includes:
First determination unit, for the case where there are field priority for first scheduled field and second scheduled field
Under, determine that the high field of field priority is the target word in first scheduled field and second scheduled field
Section；
Second determination unit, for field priority to be not present in first scheduled field and second scheduled field, and
First tables of data and second tables of data are there are in the case where table priority, in first field and second word
Determine that the high field of table priority is the aiming field in section.
9. a kind of storage medium, which is characterized in that be stored with computer program in the storage medium, wherein the computer
Program is arranged to execute method described in any one of Claims 1-4 when operation.
10. a kind of electronic device, including memory and processor, which is characterized in that be stored with computer journey in the memory
Sequence, the processor are arranged to run the computer program to execute side described in any one of Claims 1-4
Method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910765683.2A CN110472216B (en) | 2019-08-19 | 2019-08-19 | Method and device for determining field, storage medium and electronic device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910765683.2A CN110472216B (en) | 2019-08-19 | 2019-08-19 | Method and device for determining field, storage medium and electronic device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110472216A true CN110472216A (en) | 2019-11-19 |
| CN110472216B CN110472216B (en) | 2022-12-06 |
Family
ID=68511245
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910765683.2A Active CN110472216B (en) | 2019-08-19 | 2019-08-19 | Method and device for determining field, storage medium and electronic device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110472216B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111258981A (en) * | 2020-01-13 | 2020-06-09 | 中国建设银行股份有限公司 | Data processing method, device, equipment and storage medium |
| CN112527847A (en) * | 2020-11-12 | 2021-03-19 | 贝壳技术有限公司 | Data sorting method and device, electronic medium and storage medium |
| CN115391403A (en) * | 2022-08-29 | 2022-11-25 | 中电金信软件有限公司 | Data integration method and data integration device based on rule engine |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0174556A1 (en) * | 1984-09-12 | 1986-03-19 | BBC Brown Boveri AG | Method for searching memory addresses, and address comparing circuit |
| CN104731814A (en) * | 2013-12-23 | 2015-06-24 | 北京宸瑞科技有限公司 | System and method for flexibly comparing and analyzing data |
| CN106933934A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The connection method of tables of data and device |
| CN109918369A (en) * | 2017-12-13 | 2019-06-21 | 中兴通讯股份有限公司 | Date storage method and device |
-
2019
- 2019-08-19 CN CN201910765683.2A patent/CN110472216B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0174556A1 (en) * | 1984-09-12 | 1986-03-19 | BBC Brown Boveri AG | Method for searching memory addresses, and address comparing circuit |
| CN104731814A (en) * | 2013-12-23 | 2015-06-24 | 北京宸瑞科技有限公司 | System and method for flexibly comparing and analyzing data |
| CN106933934A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The connection method of tables of data and device |
| CN109918369A (en) * | 2017-12-13 | 2019-06-21 | 中兴通讯股份有限公司 | Date storage method and device |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111258981A (en) * | 2020-01-13 | 2020-06-09 | 中国建设银行股份有限公司 | Data processing method, device, equipment and storage medium |
| CN112527847A (en) * | 2020-11-12 | 2021-03-19 | 贝壳技术有限公司 | Data sorting method and device, electronic medium and storage medium |
| CN115391403A (en) * | 2022-08-29 | 2022-11-25 | 中电金信软件有限公司 | Data integration method and data integration device based on rule engine |
| CN115391403B (en) * | 2022-08-29 | 2023-08-25 | 中电金信软件有限公司 | Data integration method and data integration device based on rule engine |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110472216B (en) | 2022-12-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110472216A (en) | Determination method, apparatus, storage medium and the electronic device of field | |
| US11966877B2 (en) | Order processing method, apparatus, device, system, and storage medium | |
| CN109815013A (en) | Business data processing method, device, computer equipment and storage medium | |
| CN107395659A (en) | A kind of method and device of service handling and common recognition | |
| CN109658181A (en) | Information processing method and device | |
| CN108055264A (en) | Dispatching device, method and the computer readable storage medium of stream pushing server | |
| CN107980241B (en) | Gateway multi-connection method and device | |
| CN106155890A (en) | platform test method and system | |
| CN107689982A (en) | Multi-data source method of data synchronization, application server and computer-readable recording medium | |
| CN108681504A (en) | Automated testing method, test server and computer readable storage medium | |
| CN110113393A (en) | A kind of information push method, device, electronic equipment and medium | |
| CN106161256A (en) | A kind of processing method and processing device of Border Gateway Protocol (BGP) route | |
| CN110474959A (en) | Data interactive method, device, computer equipment and storage medium | |
| CN110427494A (en) | Methods of exhibiting, device, storage medium and the electronic device of knowledge mapping | |
| CN106130972A (en) | Resource access control method and device | |
| CN110276060A (en) | The method and device of data processing | |
| CN110362563A (en) | The processing method and processing device of tables of data, storage medium, electronic device | |
| CN113014502B (en) | Load balancing method and device based on line card | |
| CN104267985A (en) | Software loading method and device | |
| CN107959702A (en) | Method for routing and device | |
| CN110399423A (en) | Processing method and processing device, storage medium and the electronic device of metadata genetic connection | |
| CN108710514B (en) | Object jump control method and device, storage medium and electronic device | |
| CN109309858B (en) | Display method, device, equipment and medium of mutually exclusive icon | |
| CN110753001A (en) | Method and device for efficiently transmitting data and storage medium | |
| CN107784548B (en) | Order processing method and device |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |