CN110263314B - Form processing method and device, storage medium and electronic device - Google Patents
Form processing method and device, storage medium and electronic device Download PDFInfo
- Publication number
- CN110263314B CN110263314B CN201910533725.XA CN201910533725A CN110263314B CN 110263314 B CN110263314 B CN 110263314B CN 201910533725 A CN201910533725 A CN 201910533725A CN 110263314 B CN110263314 B CN 110263314B
- Authority
- CN
- China
- Prior art keywords
- field
- target
- mapping
- priority
- determining
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mobile Radio Communication Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a form processing method and device, a storage medium and an electronic device. Wherein the method comprises the following steps: determining a first mapping relation between a first field in a first table and a target field in a target table and a second mapping relation between a second field in a second table and the target field in the target table, wherein the first field, the second field and the target field have the same attribute; determining a priority relation between the first field and the second field by using the first mapping relation and the second mapping relation, and determining attribute information of the target field based on the priority relation; and fusing the first table or the second table into the target table according to the attribute information and the priority relation of the target field. The invention solves the technical problem of fusing the table in the related technology.
Description
Technical Field
The present invention relates to the field of computers, and in particular, to a method and apparatus for processing a table, a storage medium, and an electronic apparatus.
Background
The knowledge graph is also called scientific knowledge graph, is a graph-based data structure and consists of nodes (points) and edges (edges). In the knowledge graph, each node represents an entity existing in the real world, and each side is a relationship or event between the entities. Knowledge maps are the most efficient way to represent relationships or events. In popular terms, a knowledge graph is a network of relationships that is obtained by linking together all the different kinds of information. Knowledge maps provide the ability to analyze problems from both a relationship and event perspective. However, the entities of the knowledge graph often face the problem of data fusion, because there may be multiple data sources of the knowledge graph, and different expressions of the same entity exist in different data sources, even if the situations exist in the same data source, the data sources need to be combined by a certain means.
At present, a data fusion method based on table priority is adopted in the process of constructing the data fusion of the knowledge graph, namely, the tables to be fused are prioritized, the coverage priority with high priority is low, if unique information exists, the information is not prioritized, and the information is fused. This approach can handle fusion of data, but has poor control over granularity, and is difficult to satisfy complex business scenarios. In addition, the method is based on the field level number fusion method, the priority configuration of each field is carried out on the table to be fused, and the field with high priority is selected, so that the method can achieve fine control of granularity, can meet complex service scenes, has higher configuration cost, needs manual configuration on all fields, and becomes unrealistic under the condition of huge data volume.
In view of the above problems, no effective solution has been proposed at present.
Disclosure of Invention
The embodiment of the invention provides a table processing method and device, a storage medium and an electronic device, which are used for at least solving the technical problem of table fusion in the related technology.
According to an aspect of an embodiment of the present invention, there is provided a table processing method, including: determining a first mapping relation between a first field in a first table and a target field in a target table, and a second mapping relation between a second field in a second table and the target field in the target table, wherein the first field, the second field and the target field have the same attribute; determining a priority relation between the first field and the second field by using the first mapping relation and the second mapping relation, and determining attribute information of the target field based on the priority relation; and fusing the first table or the second table into the target table according to the attribute information of the target field and the priority relation.
Optionally, determining a priority relation between the first field and the second field by using the first mapping relation and the second mapping relation, and determining attribute information of the target field based on the priority relation, including at least one of the following: determining that the priority of the first field is higher than that of the second field under the condition that a first mapping value in the first mapping relation is larger than a second mapping value in the second mapping relation, and determining attribute information of the first field as the attribute information of the target field, wherein the first mapping value is used for identifying the first field, and the second mapping value is used for identifying the second field; and under the condition that a first mapping value in the first mapping relation is smaller than a second mapping value in the second mapping relation, determining that the priority of the second field is higher than that of the first field, and determining the attribute information of the second field as the attribute information of the target field.
Optionally, fusing the first table or the second table into the target table according to the attribute information of the target field and the priority relation, including: fusing the content corresponding to the first field in the first table into the content corresponding to the target field in the target table under the condition that the priority of the first field is higher than that of the second field; and fusing table contents corresponding to the second field in the second table into contents corresponding to the target field in the target table under the condition that the priority of the second field is higher than that of the second field.
Optionally, determining the first mapping relationship between the first field in the first table and the target field in the target table, and the second mapping relationship between the second field in the second table and the target field in the target table includes: determining a first Identification (ID) of the first field, and establishing a first mapping relation between the first ID and a target ID of the target field, wherein the first mapping relation comprises a first mapping value corresponding to the first ID; and determining a second identification ID of the second field, and establishing a second mapping relation between the second ID and the target ID of the target field, wherein the second mapping relation comprises a second mapping value corresponding to the second ID.
Optionally, before determining the first mapping relationship between the first field in the first table and the target field in the target table, and the second mapping relationship between the second field in the second table and the target field in the target table, the method further includes: establishing the target table; setting the target field in the target table; determining a third mapping relation between the first table and the target table and a fourth mapping relation between the second table and the target table; and determining priorities of the first table and the second table by utilizing the third mapping relation and the fourth mapping relation so as to determine a table fused to the target table.
Optionally, determining priorities of the first table and the second table by using the third mapping relation and the fourth mapping relation to determine a table fused to the target table includes one of the following: determining that the priority of the first table is higher than the priority of the second table in the case that the third mapping value in the third mapping relation is larger than the fourth mapping value in the fourth mapping relation, and determining the first table as a table fused to the target table; and determining that the priority of the second table is higher than that of the first table and determining the first table as a table fused to the target table when the third mapping value in the third mapping relation is smaller than the fourth mapping value in the fourth mapping relation.
Optionally, fusing the first table or the second table into the target table according to the attribute information of the target field, the priority of the first field and the priority of the second field, including one of the following: fusing table contents corresponding to the first field in the first table into a table corresponding to the target field in the target table under the condition that the priorities of the first field and the second field are the same and the priority of the first table is higher than that of the second table; and fusing the table contents corresponding to the second field in the second table into the table corresponding to the target field in the target table under the condition that the priorities of the first field and the second field are the same and the priorities of the second table are higher than the priorities of the first table.
According to another aspect of the embodiment of the present invention, there is also provided a table processing apparatus, including: a first determining module, configured to determine a first mapping relationship between a first field in a first table and a target field in a target table, and a second mapping relationship between a second field in a second table and the target field in the target table, where the first field, the second field, and the target field have the same attribute; the second determining module is used for determining a priority relation between the first field and the second field by utilizing the first mapping relation and the second mapping relation, and determining attribute information of the target field based on the priority relation; and the fusion module is used for fusing the first table or the second table into the target table according to the attribute information of the target field and the priority relation.
According to a further embodiment of the invention, there is also provided a storage medium having stored therein a computer program, wherein the computer program is arranged to perform the steps of any of the method embodiments described above when run.
According to a further embodiment of the invention, there is also provided an electronic device comprising a memory having stored therein a computer program and a processor arranged to run the computer program to perform the steps of any of the method embodiments described above.
In the embodiment of the invention, a first mapping relation between a first field in a first table and a target field in a target table and a second mapping relation between a second field in a second table and the target field in the target table are determined, wherein the first field, the second field and the target field have the same attribute; determining a priority relation between the first field and the second field by using the first mapping relation and the second mapping relation, and determining attribute information of the target field based on the priority relation; and fusing the first table or the second table into the target table according to the attribute information and the priority relation of the target field. The purpose of fusing the table by the priority of the fields can be achieved. And further solves the technical problem of fusing the table in the related technology.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiments of the invention and together with the description serve to explain the invention and do not constitute a limitation on the invention. In the drawings:
Fig. 1 is a block diagram of a hardware structure of a mobile terminal of a form processing method according to an embodiment of the present invention;
FIG. 2 is a flow chart of a table processing method according to an embodiment of the invention;
FIG. 3 is a schematic diagram of a destination table and a source table according to an embodiment of the invention;
FIG. 4 is a flow chart of field adjustment according to an embodiment of the invention;
FIG. 5 is a flow of mapping and priority of a setup table according to an embodiment of the invention;
FIG. 6 is a flow chart of establishing mapping and priority of fields according to an embodiment of the invention;
FIG. 7 is a flow chart of a method of data fusion according to an embodiment of the invention;
fig. 8 is a schematic diagram of a form processing apparatus according to an embodiment of the present invention.
Detailed Description
The invention will be described in detail hereinafter with reference to the drawings in conjunction with embodiments. It should be noted that, in the case of no conflict, the embodiments and features in the embodiments may be combined with each other.
It should be noted that the terms "first," "second," and the like in the description and the claims of the present invention and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order.
The method embodiments provided by the embodiments of the present application may be performed in a mobile terminal, a computer terminal, or similar computing device. Taking the mobile terminal as an example, fig. 1 is a block diagram of a hardware structure of the mobile terminal of a form processing method according to an embodiment of the present invention. As shown in fig. 1, the mobile terminal 10 may include one or more (only one is shown in fig. 1) processors 102 (the processor 102 may include, but is not limited to, a microprocessor MCU or a processing device such as a programmable logic device FPGA) and a memory 104 for storing data, and optionally a transmission device 106 for communication functions and an input-output device 108. It will be appreciated by those skilled in the art that the structure shown in fig. 1 is merely illustrative and not limiting of the structure of the mobile terminal described above. For example, the mobile terminal 10 may also include more or fewer components than shown in FIG. 1 or have a different configuration than shown in FIG. 1.
The memory 104 may be used to store a computer program, for example, a software program of application software and a module, such as a computer program corresponding to a table processing method in an embodiment of the present invention, and the processor 102 executes the computer program stored in the memory 104 to perform various functional applications and data processing, that is, implement the above-mentioned method. Memory 104 may include high-speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 104 may further include memory located remotely from the processor 102, which may be connected to the mobile terminal 10 via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The transmission means 106 is arranged to receive or transmit data via a network. The specific examples of networks described above may include wireless networks provided by the communication provider of the mobile terminal 10. In one example, the transmission device 106 includes a network adapter (Network Interface Controller, simply referred to as NIC) that can connect to other network devices through a base station to communicate with the internet. In one example, the transmission device 106 may be a Radio Frequency (RF) module, which is used to communicate with the internet wirelessly.
In this embodiment, a table processing method is provided, fig. 2 is a flowchart of the table processing method according to an embodiment of the present invention, and as shown in fig. 2, the flowchart includes the following steps:
step S202, determining a first mapping relation between a first field in a first table and a target field in a target table and a second mapping relation between a second field in a second table and the target field in the target table, wherein the first field, the second field and the target field have the same attribute;
step S204, determining a priority relation between the first field and the second field by using the first mapping relation and the second mapping relation, and determining attribute information of the target field based on the priority relation;
step S206, fusing the first table or the second table into the target table according to the attribute information and the priority relation of the target field.
According to the invention, a first mapping relation between a first field in a first table and a target field in a target table and a second mapping relation between a second field in a second table and the target field in the target table are determined, wherein the first field, the second field and the target field have the same attribute; determining a priority relation between the first field and the second field by using the first mapping relation and the second mapping relation, and determining attribute information of the target field based on the priority relation; and fusing the first table or the second table into the target table according to the attribute information and the priority relation of the target field. The purpose of fusing the table by the priority of the fields can be achieved. And further solves the technical problem of fusing the table in the related technology.
Alternatively, the execution subject of the above steps may be a terminal or the like, but is not limited thereto.
Alternatively, the above description may be applied to a scenario in which tables are fused, where the target table may be a pre-established table, and the table contents are not included therein. The first table and the second table may be source data tables that need to be fused into the target table.
Alternatively, the attribute of the field in the present embodiment may be attribute information for identifying the table contents, for example, an "age" field, a "specialty" field, or the like in the student table. The attributes of the first field and the second field may be the same meaning as indicated by the fields. For example, the first field is "phone number", the second field is "phone number", that is, the meaning of the first field and the second field are both phone numbers, and the priority of "phone number" may be set higher than "phone number". Then the fusion may be with the "cell phone number" when fusing into the target table.
Alternatively, the fields in the target table may be user-defined. For example, a field of "cell phone number" is set.
Optionally, the fusion of the table includes, but is not limited to, fusion of fields, fusion of table contents.
In an alternative embodiment, the first mapping relation and the second mapping relation are used to determine a priority relation between the first field and the second field, and the attribute information of the target field is determined based on the priority relation, including at least one of the following:
s1, determining that the priority of a first field is higher than that of a second field under the condition that a first mapping value in a first mapping relation is larger than a second mapping value in a second mapping relation, and determining attribute information of the first field as attribute information of a target field, wherein the first mapping value is used for identifying the first field, and the second mapping value is used for identifying the second field;
s2, determining that the priority of the second field is higher than that of the first field when the first mapping value in the first mapping relation is smaller than the second mapping value in the second mapping relation, and determining the attribute information of the second field as the attribute information of the target field.
Alternatively, in this embodiment, the priority of the field may be represented by a mapping value, which may be determined using the identification ID of the field. For example, the first field is "cell phone number" and the ID is 2. The second field is "phone number" and ID is 1. The mapped value of the first field is greater than the mapped value of the second field. The priority of "phone number" is set higher than "phone number".
In an alternative embodiment, fusing the first table or the second table into the target table according to the attribute information and the priority relation of the target field includes:
s1, fusing the content corresponding to the first field in the first table into the content corresponding to the target field in the target table under the condition that the priority of the first field is higher than that of the second field;
s2, fusing table contents corresponding to the second field in the second table into contents corresponding to the target field in the target table when the priority of the second field is higher than that of the second field.
Alternatively, in this embodiment, the fields and the contents corresponding to the fields may be fused into the target table.
In an alternative embodiment, determining a first mapping between a first field in the first table and a target field in the target table, and a second mapping between a second field in the second table and a target field in the target table comprises:
s1, determining a first identification ID of a first field, and establishing a first mapping relation between the first ID and a target ID of a target field, wherein the first mapping relation comprises a first mapping value corresponding to the first ID;
S2, determining a second identification ID of the second field, and establishing a second mapping relation between the second ID and the target ID of the target field, wherein the second mapping relation comprises a second mapping value corresponding to the second ID.
Alternatively, for example, the ID of the first field is 2. The ID of the second field is 1. The first mapping value of the first field may be 2 and the second mapping value of the second field may be 1.
In an alternative embodiment, before determining the first mapping relationship between the first field in the first table and the target field in the target table, and the second mapping relationship between the second field in the second table and the target field in the target table, the method further comprises:
s1, establishing a target table;
s2, setting a target field in a target table;
s3, determining a third mapping relation between the first table and the target table and a fourth mapping relation between the second table and the target table;
and S4, determining the priorities of the first table and the second table by utilizing the third mapping relation and the fourth mapping relation so as to determine the table fused to the target table.
Alternatively, in the present embodiment, the purpose of establishing the mapping relationship is to associate the first table and the second table with the target table.
In an alternative embodiment, determining the priorities of the first table and the second table using the third mapping relationship and the fourth mapping relationship to determine the table fused to the target table includes one of:
s1, determining that the priority of a first table is higher than that of a second table under the condition that a third mapping value in a third mapping relation is larger than a fourth mapping value in a fourth mapping relation, and determining the first table as a table fused to a target table;
s2, when the third mapping value in the third mapping relation is smaller than the fourth mapping value in the fourth mapping relation, determining that the priority of the second table is higher than that of the first table, and determining the first table as a table fused to the target table.
Optionally, in this embodiment, the priorities of the tables and the priorities of the fields are combined to fuse the tables, on the basis of which the priorities of the fields are finely regulated, and some data with higher priorities of the fields in lower priorities of the tables are set to global higher positions, so that the cost of configuration in the fusion process only needs to finely regulate and control those special fields. Thus, the whole manual configuration cost is reduced, and complex service scenes are satisfied.
In an alternative embodiment, the first table or the second table is fused into the target table according to the attribute information of the target field and the priority of the first field and the priority of the second field, including one of the following:
s1, under the condition that the priorities of a first field and a second field are the same and the priority of a first table is higher than that of a second table, fusing table contents corresponding to the first field in the first table into a table corresponding to a target field in a target table;
s2, fusing the table contents corresponding to the second field in the second table into the table corresponding to the target field in the target table under the condition that the priorities of the first field and the second field are the same and the priority of the second table is higher than that of the first table.
Optionally, in the process of form fusion, the priority of the fields is considered preferentially, and then the priority of the forms is considered, so that the fusion accuracy is improved.
The invention will be described in detail with reference to specific examples below:
the embodiment provides a control method based on mixed priority in map construction based on a data fusion mode of table priority and field priority. The method comprises the following steps:
S1, M represents an entity table, L and N represent a source table, as shown in FIG. 3.
S2, mapping all the target tables M with the source table L and the source table N, and selecting the priority of the source table.
S3, mapping is built for the fields of the target table, and the priority is adjusted for the specific fields, as shown in FIG. 4.
S4, setting two levels of priority strategies in the fusion process, wherein one is the table priority and the other is the field priority with finer granularity, and single-value fusion is to say, when fusion is carried out, if keys are the same, a table with high priority covers a table with low priority and a field with high priority covers a field with low priority, and the fields are reserved if the fields are set to be multiple values, wherein the field priority is higher than the table priority.
The specific process of mapping and priority of the table establishment in this embodiment, as shown in fig. 5, includes the following steps:
s501: establishing a target table name;
s502: establishing mapping with a source table;
s503: the priority of establishing the source table mapping is adjusted.
As shown in fig. 6, the mapping and priority of the fields are established in this embodiment, and as shown in fig. 6, the method includes the following steps:
s601: establishing mapping between a target table and a source table field;
S602: the priority of the mapping field is adjusted.
As shown in fig. 7, a flow chart of a method for data fusion in this embodiment, as shown in fig. 7, includes the following steps:
s701: creating a target table of mapped fields;
s702: starting to execute a data fusion strategy;
s703: non-null covers null;
s704: the field mapping priority MAX covers other, same as MAX random;
s705: the field mapping priority MIN will be covered by other non-null;
s706: a table-mapped priority overlay that does not specify a field-mapped priority;
s707: the same table maps that the overlay data version is low, which is high;
s708: and (5) data fusion is finished.
In summary, in the process of constructing the atlas of the continuous data management task, the embodiment greatly reduces the cost of labor while meeting the condition of complex business scenes, thereby greatly improving the efficiency of data management.
It should be noted that, for simplicity of description, the foregoing method embodiments are all described as a series of acts, but it should be understood by those skilled in the art that the present invention is not limited by the order of acts described, as some steps may be performed in other orders or concurrently in accordance with the present invention. Further, those skilled in the art will also appreciate that the embodiments described in the specification are all preferred embodiments, and that the acts and modules referred to are not necessarily required for the present invention.
According to another aspect of the embodiment of the present invention, there is also provided a form processing apparatus for implementing the above form processing method. As shown in fig. 8, the apparatus includes: the first determining module 82, the second determining module 84, and the fusing module 86 are described in detail below:
a first determining module 82, configured to determine a first mapping relationship between a first field in the first table and a target field in the target table, and a second mapping relationship between a second field in the second table and the target field in the target table, where the first field, the second field, and the target field have the same attribute;
a second determining module 84, configured to determine a priority relationship between the first field and the second field using the first mapping relationship and the second mapping relationship, and determine attribute information of the target field based on the priority relationship;
and the fusion module 86 is configured to fuse the first table or the second table into the target table according to the attribute information and the priority relation of the target field.
According to the invention, a first mapping relation between a first field in a first table and a target field in a target table and a second mapping relation between a second field in a second table and the target field in the target table are determined, wherein the first field, the second field and the target field have the same attribute; determining a priority relation between the first field and the second field by using the first mapping relation and the second mapping relation, and determining attribute information of the target field based on the priority relation; and fusing the first table or the second table into the target table according to the attribute information and the priority relation of the target field. The purpose of fusing the table by the priority of the fields can be achieved. And further solves the technical problem of fusing the table in the related technology.
Alternatively, the above description may be applied to a scenario in which tables are fused, where the target table may be a pre-established table, and the table contents are not included therein. The first table and the second table may be source data tables that need to be fused into the target table.
Alternatively, the attribute of the field in the present embodiment may be attribute information for identifying the table contents, for example, an "age" field, a "specialty" field, or the like in the student table. The attributes of the first field and the second field may be the same meaning as indicated by the fields. For example, the first field is "phone number", the second field is "phone number", that is, the meaning of the first field and the second field are both phone numbers, and the priority of "phone number" may be set higher than "phone number". Then the fusion may be with the "cell phone number" when fusing into the target table.
Alternatively, the fields in the target table may be user-defined. For example, a field of "cell phone number" is set.
Optionally, the fusion of the table includes, but is not limited to, fusion of fields, fusion of table contents.
In an alternative embodiment, the second determining module 84 includes at least one of:
A first determining unit, configured to determine that, when a first mapping value in the first mapping relationship is greater than a second mapping value in the second mapping relationship, a priority of the first field is higher than that of the second field, and determine attribute information of the first field as attribute information of the target field, where the first mapping value is used to identify the first field, and the second mapping value is used to identify the second field;
and a second determining unit configured to determine that the priority of the second field is higher than the priority of the first field, and determine the attribute information of the second field as the attribute information of the target field, in a case where the first mapping value in the first mapping relationship is smaller than the second mapping value in the second mapping relationship.
Alternatively, in this embodiment, the priority of the field may be represented by a mapping value, which may be determined using the identification ID of the field. For example, the first field is "cell phone number" and the ID is 2. The second field is "phone number" and ID is 1. The mapped value of the first field is greater than the mapped value of the second field. The priority of "phone number" is set higher than "phone number".
In an alternative embodiment, the fusion module 86 includes:
A first fusing unit, configured to fuse, in a case where the priority of the first field is higher than the priority of the second field, the content corresponding to the first field in the first table into the content corresponding to the target field in the target table;
and the second fusing unit is used for fusing the table contents corresponding to the second field in the second table into the contents corresponding to the target field in the target table under the condition that the priority of the second field is higher than that of the second field.
Alternatively, in this embodiment, the fields and the contents corresponding to the fields may be fused into the target table.
In an alternative embodiment, the first determining module 82 includes:
the first establishing unit is used for determining a first identification ID of the first field and establishing a first mapping relation between the first ID and a target ID of the target field, wherein the first mapping relation comprises a first mapping value corresponding to the first ID;
the second establishing unit is configured to determine a second ID of the second field, and establish a second mapping relationship between the second ID and the target ID of the target field, where the second mapping relationship includes a second mapping value corresponding to the second ID.
Alternatively, for example, the ID of the first field is 2. The ID of the second field is 1. The first mapping value of the first field may be 2 and the second mapping value of the second field may be 1.
In an optional embodiment, the apparatus further includes a building module, configured to build the target table before determining a first mapping relationship between the first field in the first table and the target field in the target table, and a second mapping relationship between the second field in the second table and the target field in the target table;
the setting module is used for setting target fields in the target table;
a third determining module, configured to determine a third mapping relationship between the first table and the target table, and a fourth mapping relationship between the second table and the target table;
and the fourth determining module is used for determining the priorities of the first table and the second table by utilizing the third mapping relation and the fourth mapping relation so as to determine the table fused to the target table.
Alternatively, in the present embodiment, the purpose of establishing the mapping relationship is to associate the first table and the second table with the target table.
In an alternative embodiment, the fourth determining module includes one of:
a third fusing unit, configured to determine that the priority of the first table is higher than the priority of the second table, and determine the first table as a table fused to the target table, when the third mapping value in the third mapping relationship is greater than the fourth mapping value in the fourth mapping relationship;
And a fourth fusing unit configured to determine that the priority of the second table is higher than the priority of the first table, and determine the first table as a table fused to the target table, in a case where the third mapping value in the third mapping relationship is smaller than the fourth mapping value in the fourth mapping relationship.
Optionally, in this embodiment, the priorities of the tables and the priorities of the fields are combined to fuse the tables, on the basis of which the priorities of the fields are finely regulated, and some data with higher priorities of the fields in lower priorities of the tables are set to global higher positions, so that the cost of configuration in the fusion process only needs to finely regulate and control those special fields. Thus, the whole manual configuration cost is reduced, and complex service scenes are satisfied.
In an alternative embodiment, the fusion module 86 of the above includes one of:
a fifth fusing unit, configured to fuse, when the priorities of the first field and the second field are the same and the priority of the first table is higher than the priority of the second table, table contents corresponding to the first field in the first table into a table corresponding to the target field in the target table;
And a sixth fusing unit, configured to fuse, in a case where the priorities of the first field and the second field are the same and the priority of the second table is higher than the priority of the first table, the table contents corresponding to the second field in the second table into the table corresponding to the target field in the target table.
Optionally, in the process of form fusion, the priority of the fields is considered preferentially, and then the priority of the forms is considered, so that the fusion accuracy is improved.
The integrated units in the above embodiments may be stored in the above-described computer-readable storage medium if implemented in the form of software functional units and sold or used as separate products. Based on such understanding, the technical solution of the present invention may be embodied in essence or a part contributing to the prior art or all or part of the technical solution in the form of a software product stored in a storage medium, comprising several instructions for causing one or more computer devices (which may be personal computers, servers or network devices, etc.) to perform all or part of the steps of the method described in the embodiments of the present invention.
In the foregoing embodiments of the present invention, the descriptions of the embodiments are emphasized, and for a portion of this disclosure that is not described in detail in this embodiment, reference is made to the related descriptions of other embodiments.
In several embodiments provided in the present application, it should be understood that the disclosed client may be implemented in other manners. The above-described embodiments of the apparatus are merely exemplary, and the division of the units, such as the division of the units, is merely a logical function division, and may be implemented in another manner, for example, multiple units or components may be combined or may be integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be through some interfaces, units or modules, or may be in electrical or other forms.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The foregoing is merely a preferred embodiment of the present invention and it should be noted that modifications and adaptations to those skilled in the art may be made without departing from the principles of the present invention, which are intended to be comprehended within the scope of the present invention.
Claims (7)
1. A form processing method, comprising:
determining a first mapping relation between a first field in a first table and a target field in a target table, and a second mapping relation between a second field in a second table and the target field in the target table, wherein the first field, the second field and the target field have the same attribute;
determining a priority relation between the first field and the second field by using the first mapping relation and the second mapping relation, and determining attribute information of the target field based on the priority relation;
fusing the first table or the second table into the target table according to the attribute information of the target field and the priority relation;
the method comprises the steps of determining a priority relation between a first field and a second field by utilizing the first mapping relation and the second mapping relation, and determining attribute information of the target field based on the priority relation, wherein the attribute information comprises at least one of the following steps:
Determining that the priority of the first field is higher than that of the second field under the condition that a first mapping value in the first mapping relation is larger than a second mapping value in the second mapping relation, and determining attribute information of the first field as the attribute information of the target field, wherein the first mapping value is used for identifying the first field, and the second mapping value is used for identifying the second field;
determining that the priority of the second field is higher than the priority of the first field under the condition that a first mapping value in the first mapping relation is smaller than a second mapping value in the second mapping relation, and determining attribute information of the second field as the attribute information of the target field;
fusing the first table or the second table into the target table according to the attribute information of the target field and the priority relation, wherein the fusing comprises the following steps:
fusing the content corresponding to the first field in the first table into the content corresponding to the target field in the target table under the condition that the priority of the first field is higher than that of the second field;
fusing table contents corresponding to the second field in the second table into contents corresponding to the target field in the target table under the condition that the priority of the second field is higher than that of the first field;
Determining a first mapping relationship between a first field in a first table and a target field in a target table, and a second mapping relationship between a second field in a second table and the target field in the target table comprises:
determining a first identification ID of the first field, and establishing a first mapping relation between the first identification ID and a target ID of the target field, wherein the first mapping relation comprises a first mapping value corresponding to the first identification ID;
determining a second identification ID of the second field, and establishing a second mapping relation between the second identification ID and a target ID of the target field, wherein the second mapping relation comprises a second mapping value corresponding to the second identification ID.
2. The method of claim 1, wherein prior to determining the first mapping between the first field in the first table and the target field in the target table and the second mapping between the second field in the second table and the target field in the target table, the method further comprises:
establishing the target table;
setting the target field in the target table;
Determining a third mapping relation between the first table and the target table and a fourth mapping relation between the second table and the target table;
and determining priorities of the first table and the second table by utilizing the third mapping relation and the fourth mapping relation so as to determine a table fused to the target table.
3. The method of claim 2, wherein determining priorities of the first table and the second table using the third mapping relationship and the fourth mapping relationship to determine a table fused to the target table comprises one of:
determining that the priority of the first table is higher than the priority of the second table in the case that the third mapping value in the third mapping relation is larger than the fourth mapping value in the fourth mapping relation, and determining the first table as a table fused to the target table;
and determining that the priority of the second table is higher than that of the first table and determining the first table as a table fused to the target table when the third mapping value in the third mapping relation is smaller than the fourth mapping value in the fourth mapping relation.
4. A method according to claim 3, wherein fusing the first table or the second table into the target table according to the attribute information of the target field and the priorities of the first field and the second field comprises one of:
fusing table contents corresponding to the first field in the first table into a table corresponding to the target field in the target table under the condition that the priorities of the first field and the second field are the same and the priority of the first table is higher than that of the second table;
and fusing the table contents corresponding to the second field in the second table into the table corresponding to the target field in the target table under the condition that the priorities of the first field and the second field are the same and the priorities of the second table are higher than the priorities of the first table.
5. A form processing apparatus, comprising:
a first determining module, configured to determine a first mapping relationship between a first field in a first table and a target field in a target table, and a second mapping relationship between a second field in a second table and the target field in the target table, where the first field, the second field, and the target field have the same attribute;
The second determining module is used for determining a priority relation between the first field and the second field by utilizing the first mapping relation and the second mapping relation, and determining attribute information of the target field based on the priority relation;
the fusion module is used for fusing the first table or the second table into the target table according to the attribute information of the target field and the priority relation;
wherein the second determination module is further configured to at least one of: determining that the priority of the first field is higher than that of the second field under the condition that a first mapping value in the first mapping relation is larger than a second mapping value in the second mapping relation, and determining attribute information of the first field as the attribute information of the target field, wherein the first mapping value is used for identifying the first field, and the second mapping value is used for identifying the second field; determining that the priority of the second field is higher than the priority of the first field under the condition that a first mapping value in the first mapping relation is smaller than a second mapping value in the second mapping relation, and determining attribute information of the second field as the attribute information of the target field;
The fusion module is also used for: fusing the content corresponding to the first field in the first table into the content corresponding to the target field in the target table under the condition that the priority of the first field is higher than that of the second field; fusing table contents corresponding to the second field in the second table into contents corresponding to the target field in the target table under the condition that the priority of the second field is higher than that of the first field;
the first determining module is further configured to: determining a first identification ID of the first field, and establishing a first mapping relation between the first identification ID and a target ID of the target field, wherein the first mapping relation comprises a first mapping value corresponding to the first identification ID;
determining a second identification ID of the second field, and establishing a second mapping relation between the second identification ID and a target ID of the target field, wherein the second mapping relation comprises a second mapping value corresponding to the second identification ID.
6. A storage medium having a computer program stored therein, characterized in that the computer program is arranged to perform the method of any of claims 1 to 4 when run.
7. An electronic device comprising a memory and a processor, characterized in that the memory has stored therein a computer program, the processor being arranged to run the computer program to perform the method of any of the claims 1 to 4.
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 CN110263314A (en) | 2019-09-20 |
| CN110263314B true 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) |
Families Citing this family (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 |
| CN111694923A (en) * | 2020-04-27 | 2020-09-22 | 平安科技（深圳）有限公司 | Name mapping-based parameter assignment method and device, and computer equipment |
| 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 |
| CN114297993B (en) * | 2021-12-31 | 2024-06-18 | 重庆允丰科技有限公司 | Form data association method and system |
| CN115391403B (en) * | 2022-08-29 | 2023-08-25 | 中电金信软件有限公司 | Data integration method and data integration device based on rule engine |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (1)
| 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 |
-
2019
- 2019-06-19 CN CN201910533725.XA patent/CN110263314B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110263314A (en) | 2019-09-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110263314B (en) | Form processing method and device, storage medium and electronic device | |
| US20190394132A1 (en) | System and Method for Network Slicing for Service-Oriented Networks | |
| CN103118140B (en) | By sharing files to the method, system and device of relation loop other user terminals outer | |
| CN110166409A (en) | Equipment cut-in method, related platform and computer storage medium | |
| CN105940377A (en) | Methods, systems, and computer readable media for a cloud-based virtualization orchestrator | |
| CN103780467B (en) | communication connection method, communication device and communication system | |
| CN111629371B (en) | Screen projection method and system | |
| CN110245128A (en) | Method for building up and device, storage medium, the electronic device of meta-model | |
| CN103607418A (en) | Large-scale data partitioning system and partitioning method based on cloud service data characteristics | |
| CN110544159B (en) | Map information processing method and device, readable storage medium and electronic equipment | |
| CN105630419A (en) | Partition view sending method of resource pools and management node | |
| CN114024886A (en) | Cross-resource-pool network intercommunication method, electronic equipment and readable storage medium | |
| CN104363187A (en) | Gateway resource response method and gateway resource response device for internet of things | |
| Godinho et al. | A reconfigurable resource management framework for fog environments | |
| CN111159577A (en) | Community division method and device, storage medium and electronic device | |
| CN102594924A (en) | Internet architecture and internet service method and system thereof | |
| CN114398397A (en) | Data processing method, device, storage medium and system | |
| CN112714146B (en) | Resource scheduling method, device, equipment and computer readable storage medium | |
| CN110300222A (en) | A kind of short message display method, system and terminal device | |
| CN106326295A (en) | Method and device for storing semantic data | |
| CN109495305A (en) | A kind of polymorphic flow network reliability estimation method of the more commodity of mostly distribution and device | |
| CN112396151B (en) | Rumor event analysis method, rumor event analysis device, rumor event analysis equipment and computer readable storage medium | |
| CN110300007B (en) | VNFD multi-deployment-specification deployment method and device, network element equipment, management equipment and storage medium | |
| CN112738213A (en) | Block chain-based task demand response method, device, system and storage medium | |
| CN110751204A (en) | Data fusion method and device, storage medium and electronic 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 |