CN110263314A - Form processing method and device, storage medium, electronic device - Google Patents
Form processing method and device, storage medium, electronic device Download PDFInfo
- Publication number
- CN110263314A CN110263314A CN201910533725.XA CN201910533725A CN110263314A CN 110263314 A CN110263314 A CN 110263314A CN 201910533725 A CN201910533725 A CN 201910533725A CN 110263314 A CN110263314 A CN 110263314A
- Authority
- CN
- China
- Prior art keywords
- field
- priority
- mapping relations
- target
- mapping
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Abstract
The invention discloses a kind of form processing method and device, storage medium, electronic devices.Wherein, this method comprises: determining the first mapping relations between the aiming field in the first field and target table in the first table, and the second mapping relations between the aiming field in the second the second field and target table in table, wherein, the attribute of the first field, the second field and aiming field is identical；The priority relationship between the first field and the second field is determined using the first mapping relations and the second mapping relations, and the attribute information of aiming field is determined based on priority relationship；The first table or the second table are fused in target table according to the attribute information of aiming field, priority relationship.The present invention solves the technical issues of merging present in the relevant technologies to table.
Description
Technical field
The present invention relates to computer fields, in particular to a kind of form processing method and device, storage medium, electricity
Sub-device.
Background technique
Knowledge mapping is also known as mapping knowledge domains, is a kind of data structure based on figure, by node (Point) and side
(Edge) it forms.In knowledge mapping, each node indicates entity present in real world, each edge be entity and entity it
Between relationship or event.Knowledge mapping is the most effective representation of relationship or event.Generally, knowledge mapping is exactly handle
A relational network obtained from all different types of information link together.Knowledge mapping is provided from relationship and event
Angle goes the ability of problem analysis.However the entity of knowledge mapping often faces the problem of data fusion, because knowledge mapping
Data source may have multiple, have the difference expression to same entity in different data sources, even if can also in the same data source
There can be such case, need to be merged by certain means.
Currently, having the data fusion method based on table priority in the data fusion process of building knowledge mapping, that is, give
The table to be merged divides priority, and the high covering priority of priority is low, regardless of priority if having exclusive information, these
Information can all be merged.This mode can handle the fusion of data, but poor to the control of granularity, be difficult to meet complicated
Business scenario.Another is the number fusion method based on field level, carries out the preferential of each field to the table that need to be merged
The high field of priority is chosen in grade configuration, and this mode can accomplish the precise controlling to granularity, can satisfy complicated business
Scene but this method is higher in deployment cost all needs all fields to carry out human configuration, in the huge feelings of data volume
It will become under condition very unrealistic.
For above-mentioned problem, currently no effective solution has been proposed.
Summary of the invention
The embodiment of the invention provides a kind of form processing method and device, storage medium, electronic devices, at least to solve
The technical issues of table is merged present in the relevant technologies.
According to an aspect of an embodiment of the present invention, a kind of form processing method is provided, comprising: determine in the first table
The first field and target table in aiming field between the first mapping relations and the second field in the second table with
The second mapping relations between the aiming field in the target table, wherein first field, second field
And the attribute of the aiming field is identical；Described first is determined using first mapping relations and second mapping relations
Priority relationship between field and second field, and determine based on the priority relationship category of the aiming field
Property information；According to the attribute information of the aiming field, the priority relationship by first table or second table
It is fused in the target table.
Optionally, first field and described the are determined using first mapping relations and second mapping relations
Priority relationship between two fields, and determine based on the priority relationship attribute information of the aiming field, including
At least one of: it is greater than the second mapping in second mapping relations in the first mapping value in first mapping relations
In the case where value, determine that the priority of first field is higher than the priority of second field, by first field
Attribute information is determined as the attribute information of the aiming field, wherein and first mapping value is used to identify first field,
Second mapping value is for identifying second field；The first mapping value in first mapping relations is less than described the
In the case where the second mapping value in two mapping relations, determine that the priority of second field is higher than the excellent of first field
The attribute information of second field is determined as the attribute information of the aiming field by first grade.
Optionally, according to the attribute information of the aiming field, the priority relationship by first table or described
Second table is fused in the target table, comprising: is higher than the excellent of second field in the priority of first field
In the case where first grade, by content mergence corresponding with first field in first table into the target table with institute
It states in the corresponding content of aiming field；The case where the priority of second field is higher than the priority of second field
Under, table content corresponding with second field in second table is fused in the target table and the target
In the corresponding content of field.
Optionally it is determined that the first mapping between the first field in the first table and the aiming field in target table is closed
System and the second table in the second field and the target table in aiming field between the second mapping relations include:
The first identifier ID for determining first field, first established between the first ID and the Target id of the aiming field are reflected
Penetrate relationship, wherein include the first mapping value corresponding with the first ID in first mapping relations；Determine second word
The second identifier ID of section, establishes the second mapping relations between the 2nd ID and the Target id of the aiming field, wherein institute
Stating in the second mapping relations includes the second mapping value corresponding with the 2nd ID.
Optionally, it is determining between the aiming field in the first field and the target table in first table
Second between the aiming field in the second field and the target table in first mapping relations and second table
Before mapping relations, the method also includes: establish the target table；The target word in the target table is set
Section；Determine third mapping relations between first table and the target table and second table and the mesh
Mark the 4th mapping relations between table；First table is determined using the third mapping relations and the 4th mapping relations
The priority of lattice and second table, to determine to be fused to the table of the target table.
Optionally, first table and described the are determined using the third mapping relations and the 4th mapping relations
The priority of two tables includes following one to determine to be fused to the table of the target table: mapping and closes in the third
In the case that third mapping value in system is greater than the 4th mapping value in the 4th mapping relations, first table is determined
Priority is higher than the priority of second table, and first table is determined as to be fused to the table of the target table；
In the case where the third mapping value in the third mapping relations is less than four mapping value in the 4th mapping relations, really
The priority of fixed second table is higher than the priority of first table, first table is determined as being fused to described
The table of target table.
Optionally, according to the priority and second word of the attribute information of the aiming field and first field
First table or second table are fused in the target table by the priority of section, including following one: in institute
State that the first field is identical as the priority of second field, and the priority of first table is higher than second table
In the case where priority, table content corresponding with first field in first table is fused to the target table
In in table corresponding with the aiming field；It is identical and described in first field and the priority of second field
The priority of second table be higher than first table priority in the case where, by second table with second word
The corresponding table content of section is fused in the target table in table corresponding with the aiming field.
According to another aspect of an embodiment of the present invention, a kind of Form Handle device is additionally provided, comprising: first determines mould
Block, for determining the first mapping relations between the first field in the first table and the aiming field in target table, and
The second mapping relations between the aiming field in the second field and the target table in second table, wherein institute
The attribute for stating the first field, second field and the aiming field is identical；Second determining module, for utilizing described the
One mapping relations and second mapping relations determine the priority relationship between first field and second field, and
The attribute information of the aiming field is determined based on the priority relationship；Fusion Module, for according to the aiming field
Attribute information, first table or second table be fused in the target table by the priority relationship.
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.
In embodiments of the present invention, using determine the first table in the first field and target table in aiming field it
Between the first mapping relations and aiming field in the second field and target table in the second table between the second mapping
Relationship, wherein the attribute of the first field, the second field and aiming field is identical；It is mapped using the first mapping relations and second
Relationship determines the priority relationship between the first field and the second field, and the category of aiming field is determined based on priority relationship
Property information；The first table or the second table are fused in target table according to the attribute information of aiming field, priority relationship.
It can achieve the purpose merged by the priority of field to table.And then it solves present in the relevant technologies to table
The technical issues of being merged.
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 form processing method of the embodiment of the present invention；
Fig. 2 is the flow chart of form processing method according to an embodiment of the present invention；
Fig. 3 is the schematic diagram of target table according to an embodiment of the present invention Yu source table；
Fig. 4 is the flow chart according to an embodiment of the present invention to field adjustment；
Fig. 5 is the process of the mapping according to an embodiment of the present invention for establishing table and priority；
Fig. 6 is the flow chart of the mapping according to an embodiment of the present invention for establishing field and priority；
Fig. 7 is the method flow diagram of data fusion according to an embodiment of the present invention；
Fig. 8 is the schematic diagram of Form Handle device 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 can be in mobile terminal, terminal or similar operation
It is executed in device.For running on mobile terminals, Fig. 1 is a kind of mobile end of form processing method of the embodiment of the present invention
The hardware block diagram at end.As shown in Figure 1, mobile terminal 10 may include one or more (only showing one in Fig. 1) processing
Device 102 (processing unit that processor 102 can include but is not limited to Micro-processor MCV or programmable logic device FPGA etc.) and
Memory 104 for storing data, optionally, above-mentioned mobile terminal can also include the transmission device for communication function
106 and input-output equipment 108.It will appreciated by the skilled person that structure shown in FIG. 1 is only to illustrate, simultaneously
The structure of above-mentioned mobile terminal is not caused to limit.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 form processing method in bright embodiment, processor 102 are stored in memory 104 by operation
Computer program realizes above-mentioned method thereby executing various function application and data processing.Memory 104 may include
High speed random access memory, may also include nonvolatile memory, as one or more magnetic storage device, flash memory or its
His non-volatile solid state memory.In some instances, memory 104 can further comprise remotely setting relative to processor 102
The memory set, these remote memories can pass through network connection to mobile terminal 10.The example of above-mentioned network includes but not
It is 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 form processing method is provided in the present embodiment, and Fig. 2 is Form Handle side according to an embodiment of the present invention
The flow chart of method, as shown in Fig. 2, the process includes the following steps:
Step S202 determines the first mapping between the first field in the first table and the aiming field in target table
The second mapping relations between the aiming field in the second field and target table in relationship and the second table, wherein the
The attribute of one field, the second field and aiming field is identical；
Step S204 is determined excellent between the first field and the second field using the first mapping relations and the second mapping relations
First grade relationship, and determine based on priority relationship the attribute information of aiming field；
First table or the second table are fused to by step S206 according to the attribute information of aiming field, priority relationship
In target table.
Through the invention, using the between the aiming field in the first field and target table determined in the first table
The second mapping relations between the aiming field in the second field and target table in one mapping relations and the second table,
Wherein, the attribute of the first field, the second field and aiming field is identical；It is true using the first mapping relations and the second mapping relations
Priority relationship between fixed first field and the second field, and determine that the attribute of aiming field is believed based on priority relationship
Breath；The first table or the second table are fused in target table according to the attribute information of aiming field, priority relationship.It can be with
Achieve the purpose that merge table by the priority of field.And then it solves and table is carried out present in the relevant technologies
The technical issues of fusion.
Optionally, the executing subject of above-mentioned steps can be terminal etc., but not limited to this.
Optionally, it can be applied among the above in the scene merged to table, in this scenario, target table can be with
It is the table pre-established, wherein not including table content.First table and the second table, which can be, to be needed to be fused to target
Source data table in table.
Optionally, the attribute of the field in the present embodiment can be the attribute information for identifying table content, for example, learning
" age " field, " profession " field in raw table etc..The attribute of first field and the second field can be represented by field
It is equivalent in meaning.For example, the first field is " phone number ", the second field is " phone number ", i.e. the first field and the second field institute
The meaning of expression is all phone number, the priority of " phone number " can be set above " phone number ".Then it is being fused to
It, can be with " phone number be merged " when in target table.
Optionally, the field in target table can be the customized setting of user.For example, the word of setting " phone number "
Section.
It optionally, include but is not limited to the fusion of the fusion of field, table content to the fusion of table.
In an alternative embodiment, the first field and second is determined using the first mapping relations and the second mapping relations
Priority relationship between field, and determine based on priority relationship the attribute information of aiming field, including it is following at least it
One:
The case where S1, the first mapping value in the first mapping relations is greater than the second mapping value in the second mapping relations
Under, it determines that the priority of the first field is higher than the priority of the second field, the attribute information of the first field is determined as target word
The attribute information of section, wherein the first mapping value is for identifying the first field, and the second mapping value is for identifying the second field；
The case where S2, the first mapping value in the first mapping relations is less than the second mapping value in the second mapping relations
Under, it determines that the priority of the second field is higher than the priority of the first field, the attribute information of the second field is determined as target word
The attribute information of section.
Optionally, in the present embodiment, the priority of field can be indicated with mapping value, and mapping value, which can be, utilizes field
Mark ID determine.For example, the first field is " phone number ", ID is 2.Second field is " phone number ", and ID is 1.Then
The mapping value of one field is greater than the mapping value of the second field.The priority of " phone number " is set above " phone number ".
In an alternative embodiment, according to the attribute information of aiming field, priority relationship by the first table or
Two tables are fused in target table, comprising:
S1, in the case where the priority of the first field is higher than the priority of the second field, by the first table with first
The corresponding content mergence of field is into target table in content corresponding with aiming field；
S2, in the case where the priority of the second field is higher than the priority of the second field, by the second table with second
The corresponding table content of field is fused in target table in content corresponding with aiming field.
Optionally, in the present embodiment, field and the corresponding content of field can be fused in target table.
In an alternative embodiment, determine the first field in the first table and the aiming field in target table it
Between the first mapping relations and aiming field in the second field and target table in the second table between the second mapping
Relationship includes:
S1, determines the first identifier ID of the first field, and first established between the first ID and the Target id of aiming field is reflected
Penetrate relationship, wherein include the first mapping value corresponding with the first ID in the first mapping relations；
S2, determines the second identifier ID of the second field, and second established between the 2nd ID and the Target id of aiming field is reflected
Penetrate relationship, wherein include the second mapping value corresponding with the 2nd ID in the second mapping relations.
Optionally, for example, the ID of the first field is 2.The ID of second field is 1.Then the first mapping value of the first field can
To be 2, the second mapping value of the second field can be 1.
In an alternative embodiment, the first field in the first table and the aiming field in target table are being determined
Between the first mapping relations and aiming field in the second field and target table in the second table between second reflect
It penetrates before relationship, method further include:
S1 establishes target table；
The aiming field in target table is arranged in S2；
S3, determine third mapping relations between the first table and target table and the second table and target table it
Between the 4th mapping relations；
S4 determines the priority of the first table and the second table, using third mapping relations and the 4th mapping relations with true
Make the table for being fused to target table.
Optionally, in the present embodiment, the purpose for establishing mapping relations is by the first table and the second table and object table
Lattice are associated.
In an alternative embodiment, the first table and second are determined using third mapping relations and the 4th mapping relations
The priority of table includes following one with the table for determining to be fused to target table:
S1, the case where the third mapping value in third mapping relations is greater than four mapping value in the 4th mapping relations
Under, it determines that the priority of the first table is higher than the priority of the second table, is determined as the first table to be fused to target table
Table；
S2, the case where the third mapping value in third mapping relations is less than four mapping value in the 4th mapping relations
Under, it determines that the priority of the second table is higher than the priority of the first table, is determined as the first table to be fused to target table
Table.
Optionally, in the present embodiment, the priority of the priority of table and field is combined and table is merged,
The subtle regulation of field priority is carried out on the basis of this, field priority very high number of certain table priority ratios in lower
According to its priority being set to global relatively high position, it is special to those that the cost configured in such fusion process is only needed
Field carries out some subtle priority regulations.Artificial deployment cost entire in this way is lower, while meeting complexity
Business scenario.
In an alternative embodiment, according to the attribute information of aiming field and the priority and second of the first field
First table or the second table are fused in target table by the priority of field, including following one:
S1, it is identical as the priority of the second field in the first field, and the priority of the first table is higher than the second table
In the case where priority, table content corresponding with the first field in the first table is fused in target table and aiming field
In corresponding table；
S2, it is identical as the priority of the second field in the first field, and the priority of the second table is higher than the first table
In the case where priority, table content corresponding with the second field in the second table is fused in target table and aiming field
In corresponding table.
Optionally, during table merges, the priority of field is paid the utmost attention to, the priority of table is considered further that, mentions
High fusion it is accurate.
The present invention is described in detail combined with specific embodiments below:
Data fusion mode of the present embodiment based on table priority and field priority proposes to be based in a kind of map construction
The control method of mix of priorities.Include the following steps:
S1 indicates an entity table with M, indicates source table with L, N, as shown in Figure 3.
It is established with source table L and source table N and is mapped to all object table M by S2, and selects the priority of source table.
S3 establishes mapping to the field of object table, and adjusts priority to specific fields, as shown in Figure 4.
S4 sets the priority policy of two ranks in fusion process, and one is table priority, the other is more
Fine-grained field priority, and monodrome fusion that is, when fusion when, it is excellent if encountered in the identical situation of key
The low field of the high field covering priority of the low table of the high table covering priority of first grade, priority, field is if being set as multivalue
All retained, wherein field priority is higher than table priority.
This implementation specifically establishes the mapping of table and the process of priority, as shown in Figure 5, comprising the following steps:
S501: target table name is established；
S502: it establishes and maps with source table；
S503: the priority of source table mapping is established in adjustment.
As shown in fig. 6, be the schematic diagram for the mapping and priority for establishing field in the present embodiment, as shown in fig. 6, include with
Lower step:
S601: object table and source literary name section are established and are mapped；
S602: the priority of map field is adjusted.
As shown in fig. 7, be the method flow diagram of data fusion in the present embodiment, as shown in fig. 7, comprises following steps:
S701: the object table of the field of mapping is created；
S702: start to execute Strategy of data fusion；
S703: non-null covers null；
S704: field mapping priority MAX covers other, is all the random of MAX；
S705: the meeting that field maps priority MIN is covered by other non-null；
S706: not specified field reflects covering by table mapping priority for priority；
S707: the high covering versions of data of identical table mapping versions of data is low；
S708: data fusion terminates.
In conclusion the present embodiment is meeting complicated business during the map construction of continuous data management task
While the case where scene, artificial cost is greatly reduced, so that the efficiency for administering data is greatly improved.
It should be noted that for the various method embodiments described above, for simple description, therefore, it is stated as a series of
Combination of actions, but those skilled in the art should understand that, the present invention is not limited by the sequence of acts described because
According to the present invention, some steps may be performed in other sequences or simultaneously.Secondly, those skilled in the art should also know
It knows, the embodiments described in the specification are all preferred embodiments, and related actions and modules is not necessarily of the invention
It is necessary.
Other side according to an embodiment of the present invention additionally provides a kind of for implementing the table of above table processing method
Lattice processing unit.As shown in figure 8, the device includes: the first determining module 82, the second determining module 84 and Fusion Module 86,
The device is described in detail below:
First determining module 82, for determining between the first field in the first table and the aiming field in target table
The first mapping relations and the second table in the second field and target table in aiming field between second mapping close
System, wherein the attribute of the first field, the second field and aiming field is identical；
Second determining module 84, for determining the first field and the second word using the first mapping relations and the second mapping relations
Priority relationship between section, and determine based on priority relationship the attribute information of aiming field；
Fusion Module 86, for according to aiming field attribute information, priority relationship is by the first table or the second table
It is fused in target table.
Through the invention, using the between the aiming field in the first field and target table determined in the first table
The second mapping relations between the aiming field in the second field and target table in one mapping relations and the second table,
Wherein, the attribute of the first field, the second field and aiming field is identical；It is true using the first mapping relations and the second mapping relations
Priority relationship between fixed first field and the second field, and determine that the attribute of aiming field is believed based on priority relationship
Breath；The first table or the second table are fused in target table according to the attribute information of aiming field, priority relationship.It can be with
Achieve the purpose that merge table by the priority of field.And then it solves and table is carried out present in the relevant technologies
The technical issues of fusion.
Optionally, it can be applied among the above in the scene merged to table, in this scenario, target table can be with
It is the table pre-established, wherein not including table content.First table and the second table, which can be, to be needed to be fused to target
Source data table in table.
Optionally, the attribute of the field in the present embodiment can be the attribute information for identifying table content, for example, learning
" age " field, " profession " field in raw table etc..The attribute of first field and the second field can be represented by field
It is equivalent in meaning.For example, the first field is " phone number ", the second field is " phone number ", i.e. the first field and the second field institute
The meaning of expression is all phone number, the priority of " phone number " can be set above " phone number ".Then it is being fused to
It, can be with " phone number be merged " when in target table.
Optionally, the field in target table can be the customized setting of user.For example, the word of setting " phone number "
Section.
It optionally, include but is not limited to the fusion of the fusion of field, table content to the fusion of table.
In an alternative embodiment, above-mentioned second determining module 84, including at least one of:
First determination unit is greater than second in the second mapping relations for the first mapping value in the first mapping relations
In the case where mapping value, determine that the priority of the first field is higher than the priority of the second field, by the attribute information of the first field
It is determined as the attribute information of aiming field, wherein the first mapping value is for identifying the first field, and the second mapping value is for identifying the
Two fields；
Second determination unit, for the first mapping value in the first mapping relations less than second in the second mapping relations
In the case where mapping value, determine that the priority of the second field is higher than the priority of the first field, by the attribute information of the second field
It is determined as the attribute information of aiming field.
Optionally, in the present embodiment, the priority of field can be indicated with mapping value, and mapping value, which can be, utilizes field
Mark ID determine.For example, the first field is " phone number ", ID is 2.Second field is " phone number ", and ID is 1.Then
The mapping value of one field is greater than the mapping value of the second field.The priority of " phone number " is set above " phone number ".
In an alternative embodiment, above-mentioned Fusion Module 86 includes:
First integrated unit, in the case where for being higher than the priority of the second field in the priority of the first field, by the
In one table and the corresponding content mergence of the first field is into target table in content corresponding with aiming field；
Second integrated unit, in the case where for being higher than the priority of the second field in the priority of the second field, by the
It is fused in target table in content corresponding with aiming field in two tables with the corresponding table content of the second field.
Optionally, in the present embodiment, field and the corresponding content of field can be fused in target table.
In an alternative embodiment, above-mentioned first determining module 82 includes:
First establishing unit establishes the target of the first ID and aiming field for determining the first identifier ID of the first field
The first mapping relations between ID, wherein include the first mapping value corresponding with the first ID in the first mapping relations；
Second establishes unit, for determining the second identifier ID of the second field, establishes the target of the 2nd ID and aiming field
The second mapping relations between ID, wherein include the second mapping value corresponding with the 2nd ID in the second mapping relations.
Optionally, for example, the ID of the first field is 2.The ID of second field is 1.Then the first mapping value of the first field can
To be 2, the second mapping value of the second field can be 1.
In an alternative embodiment, above-mentioned apparatus further includes establishing module, for determining in the first table
The second field and target in the first mapping relations and the second table between aiming field in one field and target table
Before the second mapping relations between aiming field in table, target table is established；
Setup module, the aiming field for being arranged in target table；
Third determining module, for determining third mapping relations and the second table between the first table and target table
The 4th mapping relations between lattice and target table；
4th determining module, for determining the first table and the second table using third mapping relations and the 4th mapping relations
Priority, to determine the table for being fused to target table.
Optionally, in the present embodiment, the purpose for establishing mapping relations is by the first table and the second table and object table
Lattice are associated.
In an alternative embodiment, above-mentioned 4th determining module includes following one:
Third integrated unit, for being greater than the 4th in the 4th mapping relations in the third mapping value in third mapping relations
In the case where mapping value, determines that the priority of the first table is higher than the priority of the second table, the first table is determined as merging
To the table of target table；
4th integrated unit, in the third mapping value in third mapping relations less than the 4th in the 4th mapping relations
In the case where mapping value, determines that the priority of the second table is higher than the priority of the first table, the first table is determined as merging
To the table of target table.
Optionally, in the present embodiment, the priority of the priority of table and field is combined and table is merged,
The subtle regulation of field priority is carried out on the basis of this, field priority very high number of certain table priority ratios in lower
According to its priority being set to global relatively high position, it is special to those that the cost configured in such fusion process is only needed
Field carries out some subtle priority regulations.Artificial deployment cost entire in this way is lower, while meeting complexity
Business scenario.
In an alternative embodiment, Fusion Module 86 among the above includes following one:
5th integrated unit, for identical as the priority of the second field in the first field, and the priority of the first table
In the case where priority higher than the second table, table content corresponding with the first field in the first table is fused to object table
In lattice in table corresponding with aiming field；
6th integrated unit, for identical as the priority of the second field in the first field, and the priority of the second table
In the case where priority higher than the first table, table content corresponding with the second field in the second table is fused to object table
In lattice in table corresponding with aiming field.
Optionally, during table merges, the priority of field is paid the utmost attention to, the priority of table is considered further that, mentions
High fusion it is accurate.
If the integrated unit in above-described embodiment is realized in the form of SFU software functional unit and as independent product
When selling or using, it can store in above-mentioned computer-readable storage medium.Based on this understanding, skill of the invention
Substantially all or part of the part that contributes to existing technology or the technical solution can be with soft in other words for art scheme
The form of part product embodies, which is stored in a storage medium, including some instructions are used so that one
Platform or multiple stage computers equipment (can be personal computer, server or network equipment etc.) execute each embodiment institute of the present invention
State all or part of the steps of method.
In the above embodiment of the invention, it all emphasizes particularly on different fields to the description of each embodiment, does not have in some embodiment
The part of detailed description, reference can be made to the related descriptions of other embodiments.
In several embodiments provided herein, it should be understood that disclosed client, it can be by others side
Formula is realized.Wherein, the apparatus embodiments described above are merely exemplary, such as the division of the unit, and only one
Kind of logical function partition, there may be another division manner in actual implementation, for example, multiple units or components can combine or
It is desirably integrated into another system, or some features can be ignored or not executed.Another point, it is shown or discussed it is mutual it
Between coupling, direct-coupling or communication connection can be through some interfaces, the INDIRECT COUPLING or communication link of unit or module
It connects, can be electrical or other forms.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
In network unit.It can select some or all of unit therein according to the actual needs to realize the mesh of this embodiment scheme
's.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of software functional units.
The above is only a preferred embodiment of the present invention, it is noted that for the ordinary skill people of the art
For member, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications are also answered
It is considered as protection scope of the present invention.
Claims (10)
1. a kind of form processing method characterized by comprising
Determine the first mapping relations and second between the first field in the first table and the aiming field in target table
The second mapping relations between the aiming field in the second field and the target table in table, wherein described
The attribute of one field, second field and the aiming field is identical；
It is determined between first field and second field using first mapping relations and second mapping relations
Priority relationship, and determine based on the priority relationship attribute information of the aiming field；
First table or second table are merged according to the attribute information of the aiming field, the priority relationship
To in the target table.
2. the method according to claim 1, wherein being closed using first mapping relations and second mapping
It is the priority relationship determined between first field and second field, and institute is determined based on the priority relationship
State the attribute information of aiming field, including at least one of:
The case where the first mapping value in first mapping relations is greater than the second mapping value in second mapping relations
Under, determine that the priority of first field is higher than the priority of second field, by the attribute information of first field
It is determined as the attribute information of the aiming field, wherein first mapping value is for identifying first field, and described second
Mapping value is for identifying second field；
The case where the first mapping value in first mapping relations is less than the second mapping value in second mapping relations
Under, determine that the priority of second field is higher than the priority of first field, by the attribute information of second field
It is determined as the attribute information of the aiming field.
3. the method according to claim 1, wherein according to the attribute information of the aiming field, described preferential
First table or second table are fused in the target table by grade relationship, comprising:
The priority of first field be higher than second field priority in the case where, will in first table and
The corresponding content mergence of first field is into the target table in content corresponding with the aiming field；
The priority of second field be higher than second field priority in the case where, will in second table and
The corresponding table content of second field is fused in the target table in content corresponding with the aiming field.
4. the method according to claim 1, wherein determining in the first field and the target table in the first table
Aiming field between the first mapping relations and the second field in the second table and the target word in the target table
Section between the second mapping relations include:
The first identifier ID for determining first field establishes between the first ID and the Target id of the aiming field
One mapping relations, wherein include the first mapping value corresponding with the first ID in first mapping relations；
The second identifier ID for determining second field establishes between the 2nd ID and the Target id of the aiming field
Two mapping relations, wherein include the second mapping value corresponding with the 2nd ID in second mapping relations.
5. the method according to claim 1, wherein determine the first field in first table with it is described
The second field and the target in the first mapping relations and second table between aiming field in target table
Before the second mapping relations between aiming field in table, the method also includes:
Establish the target table；
The aiming field in the target table is set；
Determine third mapping relations between first table and the target table and second table and the mesh
Mark the 4th mapping relations between table；
The excellent of first table and second table is determined using the third mapping relations and the 4th mapping relations
First grade, to determine to be fused to the table of the target table.
6. according to the method described in claim 5, it is characterized in that, being closed using the third mapping relations and the 4th mapping
System determines the priority of first table and second table, to determine that the table for being fused to the target table includes
Following one:
The case where the third mapping value in the third mapping relations is greater than four mapping value in the 4th mapping relations
Under, it determines that the priority of first table is higher than the priority of second table, first table is determined as merging
To the table of the target table；
The case where the third mapping value in the third mapping relations is less than four mapping value in the 4th mapping relations
Under, it determines that the priority of second table is higher than the priority of first table, first table is determined as merging
To the table of the target table.
7. according to the method described in claim 6, it is characterized in that, according to the attribute information of the aiming field and described
First table or second table are fused to the mesh by the priority of the priority of one field and second field
It marks in table, including following one:
It is identical as the priority of second field in first field, and the priority of first table is higher than described the
In the case where the priority of two tables, table content corresponding with first field in first table is fused to described
In target table in table corresponding with the aiming field；
It is identical as the priority of second field in first field, and the priority of second table is higher than described the
In the case where the priority of one table, table content corresponding with second field in second table is fused to described
In target table in table corresponding with the aiming field.
8. a kind of Form Handle device characterized by comprising
First determining module, for determining first between the first field in the first table and the aiming field in target table
The second mapping between the aiming field in the second field and the target table in mapping relations and the second table
Relationship, wherein the attribute of first field, second field and the aiming field is identical；
Second determining module, for using first mapping relations and second mapping relations determine first field with
Priority relationship between second field, and determine that the attribute of the aiming field is believed based on the priority relationship
Breath；
Fusion Module, for according to the aiming field attribute information, the priority relationship is by first table or institute
The second table is stated to be fused in the target table.
9. a kind of storage medium, computer program is stored in the storage medium, which is characterized in that the computer program quilt
It is set as executing method described in any one of claim 1 to 7 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 claim 1 to 7
Method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910533725.XA CN110263314B (en) | 2019-06-19 | 2019-06-19 | Form processing method and device, storage medium and electronic device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910533725.XA CN110263314B (en) | 2019-06-19 | 2019-06-19 | Form processing method and device, storage medium and electronic device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110263314A true CN110263314A (en) | 2019-09-20 |
| CN110263314B CN110263314B (en) | 2023-07-11 |
Family
ID=67919539
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910533725.XA Active CN110263314B (en) | 2019-06-19 | 2019-06-19 | Form processing method and device, storage medium and electronic device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110263314B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110751204A (en) * | 2019-10-16 | 2020-02-04 | 北京明略软件系统有限公司 | Data fusion method and device, storage medium and electronic device |
| CN112597168A (en) * | 2020-12-28 | 2021-04-02 | 恩亿科(北京)数据科技有限公司 | Processing method, device and platform of multi-source customer data and storage medium |
| WO2021218063A1 (en) * | 2020-04-27 | 2021-11-04 | 平安科技（深圳）有限公司 | Method and apparatus for assigning parameter with value on the basis of name mapping, and computer device |
| CN113704266A (en) * | 2021-08-31 | 2021-11-26 | 深信服科技股份有限公司 | Asset information processing method and device, electronic equipment 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 |
|---|---|---|---|---|
| US20080208735A1 (en) * | 2007-02-22 | 2008-08-28 | American Expresstravel Related Services Company, Inc., A New York Corporation | Method, System, and Computer Program Product for Managing Business Customer Contacts |
| CN102395162A (en) * | 2011-11-02 | 2012-03-28 | 上海电机学院 | Method and system for transmitting multihop wireless sensor network data |
| CN108572945A (en) * | 2018-03-09 | 2018-09-25 | 吉贝克信息技术（北京）有限公司 | Create method, system, storage medium and the electronic equipment of report |
| CN109783490A (en) * | 2018-12-25 | 2019-05-21 | 杭州数梦工场科技有限公司 | Data fusion method, device, computer equipment and storage medium |
-
2019
- 2019-06-19 CN CN201910533725.XA patent/CN110263314B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080208735A1 (en) * | 2007-02-22 | 2008-08-28 | American Expresstravel Related Services Company, Inc., A New York Corporation | Method, System, and Computer Program Product for Managing Business Customer Contacts |
| CN102395162A (en) * | 2011-11-02 | 2012-03-28 | 上海电机学院 | Method and system for transmitting multihop wireless sensor network data |
| CN108572945A (en) * | 2018-03-09 | 2018-09-25 | 吉贝克信息技术（北京）有限公司 | Create method, system, storage medium and the electronic equipment of report |
| CN109783490A (en) * | 2018-12-25 | 2019-05-21 | 杭州数梦工场科技有限公司 | Data fusion method, device, computer equipment and storage medium |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110751204A (en) * | 2019-10-16 | 2020-02-04 | 北京明略软件系统有限公司 | Data fusion method and device, storage medium and electronic device |
| WO2021218063A1 (en) * | 2020-04-27 | 2021-11-04 | 平安科技（深圳）有限公司 | Method and apparatus for assigning parameter with value on the basis of name mapping, and computer device |
| CN112597168A (en) * | 2020-12-28 | 2021-04-02 | 恩亿科(北京)数据科技有限公司 | Processing method, device and platform of multi-source customer data and storage medium |
| CN113704266A (en) * | 2021-08-31 | 2021-11-26 | 深信服科技股份有限公司 | Asset information processing method and device, electronic equipment 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 |
|---|---|
| CN110263314B (en) | 2023-07-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110263314A (en) | Form processing method and device, storage medium, electronic device | |
| CN106910288B (en) | A kind of method and management platform, charging pile, electric vehicle of charging | |
| US10284705B2 (en) | Method and apparatus for controlling smart device, and computer storage medium | |
| CN104426972B (en) | Terminal location sharing method and device | |
| CN111310932A (en) | Method, device and equipment for optimizing horizontal federated learning system and readable storage medium | |
| CN103294809B (en) | A kind of user organizes matching process and device | |
| CN107947977B (en) | A kind of configuration method of interchanger, device, electronic equipment and storage medium | |
| CN110276060A (en) | The method and device of data processing | |
| CN104322023B (en) | Stream forwarding method, equipment and system | |
| CN110245128A (en) | Method for building up and device, storage medium, the electronic device of meta-model | |
| CN109597822A (en) | A kind of storage of user data and querying method and user data processing unit | |
| CN109191201A (en) | A kind of information matching method and relevant device | |
| CN112822051B (en) | Service acceleration method based on service perception | |
| CN110430590A (en) | Network is sliced matching process and device | |
| CN109697776A (en) | A kind of intelligent control method, device, equipment and the medium of unmanned gymnasium | |
| CN109816543A (en) | A kind of image lookup method and device | |
| CN108650011A (en) | Multiple no-manned plane and ground network efficient collaboration, both data relay method and system | |
| CN106227597A (en) | Task priority treating method and apparatus | |
| CN109697249A (en) | Search for method, system and the storage medium of target object and issue object | |
| CN107181825A (en) | The on-line processing method of terminal device data | |
| CN104363187A (en) | Gateway resource response method and gateway resource response device for internet of things | |
| CN108418752A (en) | A kind of creation method and device of aggregation group | |
| CN110162769A (en) | Text subject output method and device, storage medium and electronic device | |
| CN109376981A (en) | Determination method, apparatus, server and the data processing method of data processing method | |
| Bronisz et al. | Towards interactive solutions in a bargaining problem |
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 |