CN110427604A - Table integration method and device - Google Patents
Table integration method and device Download PDFInfo
- Publication number
- CN110427604A CN110427604A CN201910755222.7A CN201910755222A CN110427604A CN 110427604 A CN110427604 A CN 110427604A CN 201910755222 A CN201910755222 A CN 201910755222A CN 110427604 A CN110427604 A CN 110427604A
- Authority
- CN
- China
- Prior art keywords
- gauge outfit
- target
- column
- data
- gauge
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Document Processing Apparatus (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of table integration method and devices.Wherein, this method comprises: obtaining the gauge outfit of each column of each original table in multiple original tables, the first gauge outfit collection is obtained；Obtain the attribute information that the first gauge outfit concentrates each gauge outfit, wherein the attribute of data column where attribute information is used to indicate gauge outfit；The target gauge outfit for belonging to same alike result is obtained according to attribute information；By target gauge outfit and the corresponding Data Integration of target gauge outfit into target table.The present invention solves the technical issues of integrating table low efficiency in the related technology.
Description
Technical field
The present invention relates to computer fields, in particular to a kind of table integration method and device.
Background technique
In the related technology, during being integrated multiple tables of data, it usually needs whether the gauge outfit of comparison data
It is identical, if gauge outfit is identical, then identical gauge outfit is determined as the gauge outfit in target table, this target table is known as crosstab
Crosstable。
If however, then during integrating table, being merely capable of integrating the table of identical gauge outfit using the above method
Lattice, remaining content can not then be integrated, and the low efficiency for integrating table is caused.
For above-mentioned problem, currently no effective solution has been proposed.
Summary of the invention
The embodiment of the invention provides a kind of table integration method and devices, at least to solve to integrate table in the related technology
The technical issues of low efficiency.
According to an aspect of an embodiment of the present invention, a kind of table integration method is provided, comprising: obtain multiple original tables
In each original table each column gauge outfit, obtain the first gauge outfit collection；Obtain the category that above-mentioned first gauge outfit concentrates each gauge outfit
Property information, wherein the attribute of data column where above-mentioned attribute information is used to indicate above-mentioned gauge outfit；It is obtained according to above-mentioned attribute information
Belong to the target gauge outfit of same alike result；By above-mentioned target gauge outfit and the corresponding Data Integration of above-mentioned target gauge outfit to target table
In.
According to another aspect of an embodiment of the present invention, a kind of table integrating apparatus is additionally provided, comprising: first obtains list
Member obtains the first gauge outfit collection for obtaining the gauge outfit of each column of each original table in multiple original tables；Second obtains list
Member concentrates the attribute information of each gauge outfit for obtaining above-mentioned first gauge outfit, wherein above-mentioned attribute information is used to indicate above-mentioned table
The attribute of data column where head；Third acquiring unit, for obtaining the object table for belonging to same alike result according to above-mentioned attribute information
Head；Integral unit is used for above-mentioned target gauge outfit and the corresponding Data Integration of above-mentioned target gauge outfit into target table.
As a kind of optional example, above-mentioned third acquiring unit includes: the second determining module, for believing in above-mentioned attribute
In the case that breath includes the character information in above-mentioned gauge outfit, by the character information of the character information of the first gauge outfit and the second gauge outfit
It, will be upper in the identical situation of character information for being converted to two gauge outfits of same-language format after being converted to same-language format
State the first object gauge outfit that the first gauge outfit is determined as in above-mentioned target table；Above-mentioned integral unit includes；Third shift module is used
In the non vacuum data of the first gauge outfit above-mentioned in above-mentioned multiple original tables and/or above-mentioned second gauge outfit column is transferred to above-mentioned mesh
Mark the above-mentioned first object gauge outfit column in table.
As a kind of optional example, above-mentioned third acquiring unit includes: third determining module, for believing in above-mentioned attribute
In the case that breath includes the character information in above-mentioned gauge outfit, in the character information of the character information and the second gauge outfit of the first gauge outfit
Similarity is greater than the first object gauge outfit in the case where first threshold, above-mentioned first gauge outfit being determined as in above-mentioned target table；
Above-mentioned integral unit includes: the 4th shift module, is used for the first gauge outfit above-mentioned in above-mentioned multiple original tables and/or above-mentioned second
The non vacuum data of gauge outfit column is transferred to the above-mentioned first object gauge outfit column in above-mentioned target table.
As a kind of optional example, above-mentioned apparatus further include: the first determination unit, for by above-mentioned target gauge outfit and
After the corresponding Data Integration of target gauge outfit is stated into target table, above-mentioned gauge outfit is concentrated, in addition to above-mentioned target gauge outfit
In gauge outfit, the second object table that the third gauge outfit at least two above-mentioned original tables is determined as in above-mentioned target table is appeared in
Head；Buanch unit, for the non vacuum data of third gauge outfit column above-mentioned in above-mentioned multiple original tables to be transferred to above-mentioned target
Above-mentioned second target gauge outfit column in table.
As a kind of optional example, above-mentioned third acquiring unit further include: the 4th determining module, in above-mentioned attribute
In the case where the data format of data in information including above-mentioned gauge outfit column, in the first gauge outfit and the second gauge outfit column
In the identical situation of data format, the first object gauge outfit that the first gauge outfit is determined as in above-mentioned target table；Above-mentioned integration list
Member includes: the 5th shift module, is used for the first gauge outfit above-mentioned in above-mentioned multiple original tables and/or above-mentioned second gauge outfit column
Non vacuum data be transferred to the above-mentioned first object gauge outfit column in above-mentioned target table.
In embodiments of the present invention, it using the gauge outfit for obtaining each column of each original table in multiple original tables, obtains
First gauge outfit collection；Obtain the attribute information that above-mentioned first gauge outfit concentrates each gauge outfit, wherein above-mentioned attribute information is used to indicate
The attribute of data column where stating gauge outfit；The target gauge outfit for belonging to same alike result is obtained according to above-mentioned attribute information；By above-mentioned target
The mode of gauge outfit and the corresponding Data Integration of above-mentioned target gauge outfit into target table.In the above method, due to integrating table
It is that the gauge outfit of identical data is determined as to target gauge outfit, and by target gauge outfit and corresponding Data Integration to mesh during lattice
It marks in table, without integration table could be improved by Data Integration into target table in the identical situation of gauge outfit
The efficiency of lattice solves the technical issues of integrating table low efficiency in the related technology.
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 flow diagram of optional table integration method according to an embodiment of the present invention；
Fig. 2 is a kind of schematic diagram of optional table integration method according to an embodiment of the present invention；
Fig. 3 is the schematic diagram of another optional table integration method according to an embodiment of the present invention；
Fig. 4 is the schematic diagram of another optional table integration method according to an embodiment of the present invention；
Fig. 5 is a kind of structural schematic diagram of optional table integrating apparatus according to an embodiment of the present invention.
Specific embodiment
In order to enable those skilled in the art to better understand the solution of the present invention, below in conjunction in the embodiment of the present invention
Attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is only
The embodiment of a part of the invention, instead of all the embodiments.Based on the embodiments of the present invention, ordinary skill people
The model that the present invention protects all should belong in member's every other embodiment obtained without making creative work
It encloses.
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.It should be understood that using in this way
Data be interchangeable under appropriate circumstances, so as to the embodiment of the present invention described herein can in addition to illustrating herein or
Sequence other than those of description is implemented.In addition, term " includes " and " having " and their any deformation, it is intended that cover
Cover it is non-exclusive include, for example, the process, method, system, product or equipment for containing a series of steps or units are not necessarily limited to
Step or unit those of is clearly listed, but may include be not clearly listed or for these process, methods, product
Or other step or units that equipment is intrinsic.
According to an aspect of an embodiment of the present invention, a kind of table integration method is provided, optionally, as a kind of optional
Embodiment, as shown in Figure 1, above table integration method includes:
S102 obtains the gauge outfit of each column of each original table in multiple original tables, obtains the first gauge outfit collection；
S104 obtains the attribute information that the first gauge outfit concentrates each gauge outfit, wherein attribute information is used to indicate where gauge outfit
The attribute of data column；
S106 obtains the target gauge outfit for belonging to same alike result according to attribute information；
S108, by target gauge outfit and the corresponding Data Integration of target gauge outfit into target table.
Optionally, above table integration method can be, but not limited to during being applied to data merging, for example, by above-mentioned
During method is applied to table merging.In the related technology, during merging table, usually by table in two tables
Identical table is merged into one big table.However, if, then since gauge outfit is identical, data could close using the above method
And cause to integrate the low efficiency of table.And in the present solution, two gauge outfits be used to indicate gauge outfit where the attribute letter that arranges of data
Manner of breathing merges the data of two gauge outfits into target table in the case where, improves the efficiency for integrating table to realize
Effect.
Optionally, the target table in this programme is crosstable.
Optionally, the target table in this programme can be the multiple tables different from original table.For example, being deposited in this programme
Can wrap in multiple original tables for integrating of needs, multiple original tables containing data, and in addition prepare a blank or
The stored target table for having thin consolidation data, by the Data Integration of multiple original tables into target table.In integration process
In, qualified data will be integrated into target table, and ineligible data will be retained in each original table.
Optionally, it in this programme when integrating the data in original table into target table, needs using corresponding condition
It is integrated.It should be noted that the case where including the first, second equal terms in gauge outfit or target gauge outfit mentioned below, the
One, second just to distinguish, and be not to do particular determination to gauge outfit.
Optionally, the gauge outfit in this programme refers generally to the cell of the top of the column data in table not merged,
It is generally used to refer to the content of the column data.For example, including the name of multiple students, the gauge outfit of the column data in a column data
It can be the cell that the column top side is not merged, include " name " in cell.
Optionally, in integral data, the attribute information of available each gauge outfit.It may include gauge outfit in attribute information
Character information.Above-mentioned character information is the character in gauge outfit.Such as the character data of the gauge outfit of " name " column can be " surname
The two characters of name ".
Data Integration can integrate the gauge outfit and data for meeting following condition in this programme:
1, the character information of gauge outfit can be compared in this programme.If there are the feelings for including entirely in the character information of two gauge outfits
The character information of condition, such as the first gauge outfit includes the character information of the second gauge outfit entirely, then it is assumed that the data of two gauge outfit columns are
The data that can be integrated into target table.And entirely comprising referring to the character information of a gauge outfit by the character information of another gauge outfit
Include.As " ID card No. " five characters contain " identity card " three characters, then it is assumed that, " ID card No. " contains entirely
" identity card ".At this point, by by comprising gauge outfit be determined as the first object gauge outfit in target table.And the first gauge outfit and the second table
Non vacuum data in head will be transferred to first object gauge outfit column.For example, as shown in Fig. 2, including table 1 and table in Fig. 2
Lattice 2, " ID card No. " in table 1 include that identity card is determined as mesh in the case by " identity card " in table 2
The gauge outfit in table is marked, and column data where " ID card No. " in table 1 and " identity card " in table 2 is transferred to mesh
Mark " identity card " column of gauge outfit.
Optionally, in this programme can also the character information of above-mentioned first gauge outfit include entirely the second gauge outfit character information
In the case where, if the first gauge outfit concentrates the abbreviation including the first gauge outfit and/or the second gauge outfit, then need multiple original tables
In, the non vacuum data of the abbreviation column of the first gauge outfit and/or the second gauge outfit is transferred to first object gauge outfit institute in target table
It is arranging.If the second gauge outfit is that " xingming " first gauge outfit is concentrated including " xm ", " xm " is the abbreviation of " xingming ".Then need
By the Data Integration of " xm " column into target table " xingming " column.
2, the character information of gauge outfit can be there are many language form in this programme.Such as Chinese, English and abbreviation type (contracting
It writes including english abbreviation and Pinyin abbreviation).After if the character information that the first gauge outfit is concentrated is converted to same-language format, conversion
Character information for two gauge outfits of same-language format is identical, then the data of two gauge outfits should merge.For example, gauge outfit
" xingming " and gauge outfit " xm " is " xm " after " xingming " is converted to abbreviation format, then gauge outfit " xingming " and table
Data in head " xm " should be integrated into target table.In the process, generally it regard one in English gauge outfit as mesh
The gauge outfit in table is marked, and abbreviations table head is generally not as the gauge outfit in target table.
For example, as shown in figure 3, including table 1 and table 2 in Fig. 3, in " xingming " and table 2 in table 1
" xm " can be indicated with abbreviation " xm ".In the case, and by table 1 " xingming " and table 2 in " xm "
Column non vacuum data is transferred to " xingming " column of target gauge outfit.
3, the similarity of character information can also be compared in this programme.For example, being all the character letter of two gauge outfits of Chinese
Breath, be perhaps all English two gauge outfits character information or be all abbreviation two gauge outfits character information, for two
The editing distance that editing distance calculation formula calculates two characters can be used, in above-mentioned editing distance greatly less than one in character
In the case where first threshold, such as 3, then it is assumed that the similarity of above-mentioned two gauge outfit is very high, and the data under two gauge outfits should be by
Merge.
4, the gauge outfit for meeting one or more of above-mentioned condition 1,2,3 is being determined as target gauge outfit in this programme, and
By target gauge outfit and the corresponding Data Integration of target gauge outfit into target table after, can also the first gauge outfit concentrate it is remaining
It in gauge outfit, searches whether to include third gauge outfit, third gauge outfit is the gauge outfit appeared at least two original tables.By third gauge outfit
The second target gauge outfit being determined as in target table；The non vacuum data of third gauge outfit column in multiple original tables is transferred to mesh
Mark the second target gauge outfit column in table.
It optionally, as another embodiment, is the comparison carried out to the character information of gauge outfit in above-mentioned condition 1,2,3
Or judgement.On this basis, this programme can also judge the data format of gauge outfit.For example, meeting in gauge outfit above-mentioned
Any one of condition, and in the first gauge outfit situation identical with the data format of data under the second gauge outfit, it just can be by first
Data in gauge outfit and the second gauge outfit are merged into target table.
For example, as shown in figure 4, " identity card " and " ID card No. " two gauge outfits meet above-mentioned condition 1, and " identity card "
Data with " ID card No. " two gauge outfit columns are 18 numbers.In the case, " identity card " and " identity card
Data Integration under two gauge outfits of number " is into target table.
It should be noted that in this programme by the corresponding Data Integration of target gauge outfit collection target gauge outfit into target table
Later, the data being integrated in each original table will be deleted, and the data retained in each original table are that each is original
The distinctive data of table.
It is illustrated below in conjunction with an example.
For example, obtaining each column of each original table in multiple original tables during multiple original tables are integrated
Gauge outfit, obtain the first gauge outfit collection.If there are identical gauge outfits for the gauge outfit that the first gauge outfit is concentrated, then duplicate removal is carried out.
Then, it is determined that the first gauge outfit concentrate whether comprising the characters of two gauge outfits there are inclusion relations.For example, " identity card
Number " contains " identity card ", then by by comprising gauge outfit be determined as the gauge outfit in target table, in each original table, table
Head is comprising in the case where " ID card No. " or " identity card ", the data under " ID card No. " or " identity card " can be integrated into
Column in target table where " identity card ".After merging all data there are the gauge outfit of inclusion relation, it is merged
The corresponding gauge outfit of data will the first gauge outfit concentrate delete." ID card No. " and " identity card " will not exist and the first table
Head is concentrated.Then the first remaining gauge outfit of gauge outfit collection is judged.For the gauge outfit comprising abbreviation, for example, " xingming "
It then include the gauge outfit that the gauge outfit " xingming " of abbreviation will be targeted in table comprising abbreviation " xm ".And in original table,
The non vacuum data of " xingming " or " xm " column will be integrated into target table " xingming " column.
" xingming " and " xm " will be concentrated in the first gauge outfit and be deleted.First gauge outfit concentrates remaining gauge outfit, can be divided into Chinese gauge outfit,
English gauge outfit and abbreviation gauge outfit, then calculate the editing distance of any two Chinese gauge outfit, English gauge outfit or gauge outfit of abridging.If
Less than one first threshold of the editing distance of two gauge outfits, then it is assumed that the similarity of two gauge outfits has been greater than predetermined threshold, such as " material
Matter " and " material " as the gauge outfit in target table, and will wrap one in two gauge outfits such as " material " in each original table
The Data Integrations of the column of " material " or " material " " material " column into target table is contained." material " or " material " will by from
First gauge outfit, which is concentrated, deletes.In remaining gauge outfit, the gauge outfit " number " at least two original tables will appear in as target
Gauge outfit in table, and by original table include " number " gauge outfit column Data Integration into target table " number " place
Column." number " will be deleted by concentrating from the first gauge outfit.After integration, the data for including in each original table are that the original table is peculiar
Data.
It should be noted that the data in target table can store incidence relation by way of pointer.Such as " Zhang San ",
Data such as " 29 " are located at a line in an original table, and after by the Data Integration into target table, one can be located at
Row, can also be located at different rows.The incidence relation that pointer etc. stores above-mentioned two data can be used.
Through this embodiment, table is integrated by the above method, so as to avoid being merely capable of integrating the table of identical gauge outfit
The problem of lattice, realizes the effect for improving the integration efficiency of table.
As a kind of optional embodiment,
Belonging to the target gauge outfit of same alike result according to attribute information acquisition includes: S1, includes in gauge outfit in attribute information
In the case where character information, the inclusion relation of character information is compared, includes the word of the second gauge outfit in the character information of the first gauge outfit
In the case where according with information, the first object gauge outfit that the second gauge outfit is determined as in target table；
It include: S1 into target table by target gauge outfit and the corresponding Data Integration of target gauge outfit, it will be in multiple original tables
The non vacuum data of first gauge outfit and/or the second gauge outfit column is transferred to first object gauge outfit column.
Optionally, first can also be compared on the basis of comparing character information with the presence or absence of inclusion relation in this programme
Whether the data format of gauge outfit data corresponding with the second gauge outfit is identical.For example, data format is all 5 bit digitals or data
Format is all 3 Chinese characters, then by by comprising the second gauge outfit be determined as the first object gauge outfit in target table.
Through this embodiment, by the above method, so as to which by multiple tables, there are inclusion relation and data for gauge outfit
The identical Data Integration of format realizes the effect for improving the integration efficiency of table into target table.
As a kind of optional embodiment, by the first gauge outfit in multiple original tables and/or the second gauge outfit column
Non vacuum data is transferred to after first object gauge outfit column, further includes:
S1 will be multiple original in the case where the first gauge outfit includes the first abbreviation and/or the second gauge outfit includes the second abbreviation
The non vacuum data of the first abbreviation and/or the second abbreviation column is transferred to where the first object gauge outfit in target table in table
Column.
Optionally, the abbreviation in this programme may include Pinyin abbreviation or english abbreviation.It concentrates and exists in the first gauge outfit
The case where first abbreviation of the first table, also needs the data format of column data where comparing the first table and the abbreviation of the first table
Whether the data format of place column data is identical, identical, can just carry out the data of the first table and the abbreviation of the first table whole
It closes.The case where there are the abbreviations of the second table is concentrated in the first gauge outfit, also needs the data lattice of column data where comparing the second table
Whether formula is identical as the data format of column data where the abbreviation of the second table, identical, just can be by the second table and the second table
The data of abbreviation integrated.
Through this embodiment, by the above method, thus in the case where the first gauge outfit and/or the second gauge outfit include abbreviation
By the Data Integration for column of abridging into target table, the effect for improving table integration efficiency is realized.
As a kind of optional embodiment, belonging to the target gauge outfit of same alike result according to attribute information acquisition includes: S1,
In the case where attribute information includes the character information in gauge outfit, by the character of the character information of the first gauge outfit and the second gauge outfit
After information is converted to same-language format, in the identical situation of character information for being converted to two gauge outfits of same-language format,
The first object gauge outfit first gauge outfit being determined as in target table；
It include: S1 into target table by target gauge outfit and the corresponding Data Integration of target gauge outfit, it will be in multiple original tables
The non vacuum data of first gauge outfit and/or the second gauge outfit column is transferred to the first object gauge outfit column in target table.
Optionally, the first gauge outfit can be concentrated in the gauge outfit there is no inclusion relation in this programme, it is determined whether exist
The abbreviation of first gauge outfit.In the case where the first gauge outfit exists and abridges, the first gauge outfit is determined as the gauge outfit in target table, and
By in original table, the column data where the first gauge outfit and/or abbreviation is integrated into the column in target table where the first gauge outfit.
Through this embodiment, the data of table are integrated by the above method, improve table integration efficiency to realize
Effect.
As a kind of optional embodiment,
Belonging to the target gauge outfit of same alike result according to attribute information acquisition includes: S1, includes in gauge outfit in attribute information
In the case where character information, it is greater than first threshold in the similarity of the character information of the character information and the second gauge outfit of the first gauge outfit
In the case where, the first object gauge outfit that the first gauge outfit is determined as in target table；
It include: S1 into target table by target gauge outfit and the corresponding Data Integration of target gauge outfit, it will be in multiple original tables
The non vacuum data of first gauge outfit and/or the second gauge outfit column is transferred to the first object gauge outfit column in target table.
Optionally, the first gauge outfit can be concentrated in this programme, inclusion relation is not present, and without corresponding abbreviation, or do not have
There is the corresponding Chinese or gauge outfit without corresponding to English to be divided into Chinese gauge outfit collection, English gauge outfit collection and abbreviation gauge outfit collection, and in calculating
Literary gauge outfit collection, English gauge outfit collection and abbreviation gauge outfit concentrate the similarity of every two gauge outfit.Similarity can be true according to editing distance
It is fixed.Two gauge outfits that similarity is higher than a predetermined threshold will be integrated into target table.
Through this embodiment, the data of table are integrated by the above method, improve table integration efficiency to realize
Effect.
As a kind of optional embodiment, by target gauge outfit and the corresponding Data Integration of target gauge outfit into target table
Later, further includes:
S1 concentrates gauge outfit, in the gauge outfit in addition to target gauge outfit, appears in the third gauge outfit at least two original tables
The second target gauge outfit being determined as in target table；
S2, the second object table non vacuum data of third gauge outfit column in multiple original tables being transferred in target table
Head column.
Optionally, in the present solution, in the gauge outfit that inclusion relation will be present or the gauge outfit of abbreviation, Huo Zhexiang can be included
After being integrated into target table like the gauge outfit that degree is greater than first threshold, at least two can also be appeared in by remaining gauge outfit
Gauge outfit in a original table is determined as the gauge outfit in target table.And carry out Data Integration.
Through this embodiment, the data of table are integrated by the above method, improve table integration efficiency to realize
Effect.
As a kind of optional embodiment,
Belonging to the target gauge outfit of same alike result according to attribute information acquisition includes: S1, includes gauge outfit institute in attribute information
In the case where the data format of the data of column, in the first gauge outfit situation identical as the data format of the second gauge outfit column
Under, the first object gauge outfit that the first gauge outfit is determined as in target table；
It include: S2 into target table by target gauge outfit and the corresponding Data Integration of target gauge outfit, it will be in multiple original tables
The non vacuum data of first gauge outfit and/or the second gauge outfit column is transferred to the first object gauge outfit column in target table.
Optionally, comparison data format can be the length of column data where the first gauge outfit of comparison and the second gauge outfit in this programme
Degree what/or type.If length is 11, type is number or length is 2-4, and type is Chinese character etc..
Through this embodiment, the data of table are integrated by the above method, improve table integration efficiency to realize
Effect.
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 integration method
Lattice integrating apparatus.As shown in figure 5, the device includes:
(1) first acquisition unit 502 are obtained for obtaining the gauge outfit of each column of each original table in multiple original tables
To the first gauge outfit collection；
(2) attribute information of each gauge outfit is concentrated for obtaining the first gauge outfit in second acquisition unit 504, wherein attribute letter
The attribute of data column where breath is used to indicate gauge outfit；
(3) third acquiring unit 506, for obtaining the target gauge outfit for belonging to same alike result according to attribute information；
(4) integral unit 508 are used for target gauge outfit and the corresponding Data Integration of target gauge outfit into target table.
Optionally, above table integrating apparatus can be, but not limited to during being applied to data merging, for example, by above-mentioned
During method is applied to table merging.In the related technology, during merging table, usually by table in two tables
Identical table is merged into one big table.However, if, then since gauge outfit is identical, data could close using the above method
And cause to integrate the low efficiency of table.And in the present solution, two gauge outfits be used to indicate gauge outfit where the attribute letter that arranges of data
Manner of breathing merges the data of two gauge outfits into target table in the case where, improves the efficiency for integrating table to realize
Effect.
Optionally, the target table in this programme can be the multiple tables different from original table.For example, being deposited in this programme
Can wrap in multiple original tables for integrating of needs, multiple original tables containing data, and in addition prepare a blank or
The stored target table for having thin consolidation data, by the Data Integration of multiple original tables into target table.In integration process
In, qualified data will be integrated into target table, and ineligible data will be retained in each original table.
Optionally, it in this programme when integrating the data in original table into target table, needs using corresponding condition
It is integrated.It should be noted that the case where including the first, second equal terms in gauge outfit or target gauge outfit mentioned below, the
One, second just to distinguish, and be not to do particular determination to gauge outfit.
Optionally, the gauge outfit in this programme refers generally to the cell of the top of the column data in table not merged,
It is generally used to refer to the content of the column data.For example, including the name of multiple students, the gauge outfit of the column data in a column data
It can be the cell that the column top side is not merged, include " name " in cell.
Optionally, in integral data, the attribute information of available each gauge outfit.It may include gauge outfit in attribute information
Character information.Above-mentioned character information is the character in gauge outfit.Such as the character data of the gauge outfit of " name " column can be " surname
The two characters of name ".
Data Integration can integrate the gauge outfit and data for meeting following condition in this programme:
1, the character information of gauge outfit can be compared in this programme.If there are the feelings for including entirely in the character information of two gauge outfits
The character information of condition, such as the first gauge outfit includes the character information of the second gauge outfit entirely, then it is assumed that the data of two gauge outfit columns are
The data that can be integrated into target table.And entirely comprising referring to the character information of a gauge outfit by the character information of another gauge outfit
Include.As " ID card No. " five characters contain " identity card " three characters, then it is assumed that, " ID card No. " contains entirely
" identity card ".At this point, by by comprising gauge outfit be determined as the first object gauge outfit in target table.And the first gauge outfit and the second table
Non vacuum data in head will be transferred to first object gauge outfit column.For example, as shown in Fig. 2, including table 1 and table in Fig. 2
Lattice 2, " ID card No. " in table 1 include " identity card " in table 2, then identity card are determined as in target table
Gauge outfit, and column data where " ID card No. " in table 1 and " identity card " in table 2 is transferred to target gauge outfit
" identity card " column.
Optionally, in this programme can also the character information of above-mentioned first gauge outfit include entirely the second gauge outfit character information
In the case where, if the first gauge outfit concentrates the abbreviation including the first gauge outfit and/or the second gauge outfit, then need multiple original tables
In, the non vacuum data of the abbreviation column of the first gauge outfit and/or the second gauge outfit is transferred to first object gauge outfit institute in target table
It is arranging.Concentrating such as the first gauge outfit includes " sfz ", and " sfz " is the abbreviation of " identity card ".It then needs the data of " sfz " column
" identity card " column is integrated into target table.
2, the character information of gauge outfit can be there are many language form in this programme.Such as Chinese, English and abbreviation type (contracting
It writes including english abbreviation and Pinyin abbreviation).After if the character information that the first gauge outfit is concentrated is converted to same-language format, conversion
Character information for two gauge outfits of same-language format is identical, then the data of two gauge outfits should merge.For example, gauge outfit
" xingming " and gauge outfit " xm " is " xm " after " xingming " is converted to abbreviation format, then gauge outfit " xingming " and table
Data in head " xm " should be integrated into target table.In the process, generally it regard one in English gauge outfit as mesh
The gauge outfit in table is marked, and abbreviations table head is generally not as the gauge outfit in target table.
For example, as shown in figure 3, including table 1 and table 2 in Fig. 3, in " xingming " and table 2 in table 1
" xm " can be indicated with abbreviation " xm ".In the case, and by table 1 " xingming " and table 2 in " xm "
Column non vacuum data is transferred to " identity card " column of target gauge outfit.
3, the similarity of character information can also be compared in this programme.For example, being all the character letter of two gauge outfits of Chinese
Breath, be perhaps all English two gauge outfits character information or be all abbreviation two gauge outfits character information, for two
The editing distance that editing distance calculation formula calculates two characters can be used in character, in above-mentioned editing distance the less than one
One threshold value, such as in the case where 3, then it is assumed that the similarity of above-mentioned two gauge outfit is very high, and the data under two gauge outfits should be closed
And.
4, the gauge outfit for meeting one or more of above-mentioned condition 1,2,3 is being determined as target gauge outfit in this programme, and
By target gauge outfit and the corresponding Data Integration of target gauge outfit into target table after, can also the first gauge outfit concentrate it is remaining
It in gauge outfit, searches whether to include third gauge outfit, third gauge outfit is the gauge outfit appeared at least two original tables.By third gauge outfit
The second target gauge outfit being determined as in target table；The non vacuum data of third gauge outfit column in multiple original tables is transferred to mesh
Mark the second target gauge outfit column in table.
It optionally, as another embodiment, is the comparison carried out to the character information of gauge outfit in above-mentioned condition 1,2,3
Or judgement.On this basis, this programme can also judge the data format of gauge outfit.For example, meeting in gauge outfit above-mentioned
Any one of condition, and in the first gauge outfit situation identical with the data format of data under the second gauge outfit, it just can be by first
Data in gauge outfit and the second gauge outfit are merged into target table.
For example, as shown in figure 4, " identity card " and " ID card No. " two gauge outfits meet above-mentioned condition 1, and " identity card "
Data with " ID card No. " two gauge outfit columns are 18 numbers.In the case, " identity card " and " identity card
Data Integration under two gauge outfits of number " is into target table.
It should be noted that in this programme by the corresponding Data Integration of target gauge outfit collection target gauge outfit into target table
Later, the data being integrated in each original table will be deleted, and the data retained in each original table are that each is original
The distinctive data of table.
It is illustrated below in conjunction with an example.
For example, obtaining each column of each original table in multiple original tables during multiple original tables are integrated
Gauge outfit, obtain the first gauge outfit collection.If there are identical gauge outfits for the gauge outfit that the first gauge outfit is concentrated, then duplicate removal is carried out.
Then, it is determined that the first gauge outfit concentrate whether comprising the characters of two gauge outfits there are inclusion relations.For example, " identity card
Number " contains " identity card ", then by by comprising gauge outfit be determined as the gauge outfit in target table, in each original table, table
Head is comprising in the case where " ID card No. " or " identity card ", the data under " ID card No. " or " identity card " can be integrated into
Column in target table where " identity card ".After merging all data there are the gauge outfit of inclusion relation, it is merged
The corresponding gauge outfit of data will the first gauge outfit concentrate delete." ID card No. " and " identity card " will not exist and the first table
Head is concentrated.Then the first remaining gauge outfit of gauge outfit collection is judged.For the gauge outfit comprising abbreviation, for example, " xingming "
It then include the gauge outfit that the gauge outfit " xingming " of abbreviation will be targeted in table comprising abbreviation " xm ".And in original table,
The non vacuum data of " xingming " or " xm " column will be integrated into target table " xingming " column.
" xingming " and " xm " will be concentrated in the first gauge outfit and be deleted.First gauge outfit concentrates remaining gauge outfit, can be divided into Chinese gauge outfit,
English gauge outfit and abbreviation gauge outfit, then calculate the editing distance of any two Chinese gauge outfit, English gauge outfit or gauge outfit of abridging.If
The editing distance of two gauge outfits has been greater than a first threshold, then it is assumed that the similarity of two gauge outfits has been greater than predetermined threshold, such as
" material " and " material " by one in two gauge outfits such as " material " as the gauge outfit in target table, and will be in each original table
Contain the Data Integrations of the column of " material " or " material " " material " column into target table." material " or " material " will be by
It concentrates and deletes from the first gauge outfit.In remaining gauge outfit, the gauge outfit " number " at least two original tables will appear in as mesh
Mark table in gauge outfit, and by original table include " number " gauge outfit column Data Integration into target table " number " institute
It is arranging." number " will be deleted by concentrating from the first gauge outfit.After integration, the data for including in each original table are that the original table is special
Some data.
It should be noted that the data in target table can store incidence relation by way of pointer.Such as " Zhang San ",
Data such as " 29 " are located at a line in an original table, and after by the Data Integration into target table, one can be located at
Row, can also be located at different rows.The incidence relation that pointer etc. stores above-mentioned two data can be used.
Through this embodiment, table is integrated by the above method, so as to avoid being merely capable of integrating the table of identical gauge outfit
The problem of lattice, realizes the effect for improving the integration efficiency of table.
As a kind of optional embodiment,
Above-mentioned third acquiring unit includes: (1) first determining module, for including the character letter in gauge outfit in attribute information
In the case where breath, the inclusion relation of character information is compared, includes the character information of the second gauge outfit in the character information of the first gauge outfit
In the case where, the first object gauge outfit that the second gauge outfit is determined as in target table；
Above-mentioned integral unit includes: (1) first shift module, is used for the first gauge outfit and/or second in multiple original tables
The non vacuum data of gauge outfit column is transferred to first object gauge outfit column.
Optionally, first can also be compared on the basis of comparing character information with the presence or absence of inclusion relation in this programme
Whether the data format of gauge outfit data corresponding with the second gauge outfit is identical.For example, data format is all 5 bit digitals or data
Format is all 3 Chinese characters, then by by comprising the second gauge outfit be determined as the first object gauge outfit in target table.
Through this embodiment, by the above method, so as to which by multiple tables, there are inclusion relation and data for gauge outfit
The identical Data Integration of format realizes the effect for improving the integration efficiency of table into target table.
As a kind of optional embodiment, above-mentioned integral unit further include:
(1) second shift module, for by the non-empty of the first gauge outfit in multiple original tables and/or the second gauge outfit column
Data are transferred to after first object gauge outfit column, and in the first gauge outfit include the first abbreviation and/or the second gauge outfit includes second
In the case where abbreviation, the non vacuum data of the first abbreviation in multiple original tables and/or the second abbreviation column is transferred to object table
First object gauge outfit column in lattice.
Optionally, the abbreviation in this programme may include Pinyin abbreviation or english abbreviation.It concentrates and exists in the first gauge outfit
The case where first abbreviation of the first table, also needs the data format of column data where comparing the first table and the abbreviation of the first table
Whether the data format of place column data is identical, identical, can just carry out the data of the first table and the abbreviation of the first table whole
It closes.The case where there are the abbreviations of the second table is concentrated in the first gauge outfit, also needs the data lattice of column data where comparing the second table
Whether formula is identical as the data format of column data where the abbreviation of the second table, identical, just can be by the second table and the second table
The data of abbreviation integrated.
Through this embodiment, by the above method, thus in the case where the first gauge outfit and/or the second gauge outfit include abbreviation
By the Data Integration for column of abridging into target table, the effect for improving table integration efficiency is realized.
As a kind of optional embodiment,
Above-mentioned third acquiring unit includes: (1) second determining module, for including the character letter in gauge outfit in attribute information
In the case where breath, after the character information of the character information of the first gauge outfit and the second gauge outfit is converted to same-language format, turn
It is changed in the identical situation of character information of two gauge outfits of same-language format, the first gauge outfit is determined as in target table
First object gauge outfit；
Above-mentioned integral unit includes: (1) third shift module, is used for the first gauge outfit and/or second in multiple original tables
The non vacuum data of gauge outfit column is transferred to the first object gauge outfit column in target table.
Optionally, the first gauge outfit can be concentrated in the gauge outfit there is no inclusion relation in this programme, it is determined whether exist
The abbreviation of first gauge outfit.In the case where the first gauge outfit exists and abridges, the first gauge outfit is determined as the gauge outfit in target table, and
By in original table, the column data where the first gauge outfit and/or abbreviation is integrated into the column in target table where the first gauge outfit.
Through this embodiment, the data of table are integrated by the above method, improve table integration efficiency to realize
Effect.
As a kind of optional embodiment,
Above-mentioned third acquiring unit includes: (1) third determining module, for including the character letter in gauge outfit in attribute information
In the case where breath, the case where the similarity of the character information of the character information and the second gauge outfit of the first gauge outfit is greater than first threshold
Under, the first object gauge outfit that the first gauge outfit is determined as in target table；
Above-mentioned integral unit includes: (1) the 4th shift module, is used for the first gauge outfit and/or second in multiple original tables
The non vacuum data of gauge outfit column is transferred to the first object gauge outfit column in target table.
Optionally, the first gauge outfit can be concentrated in this programme, inclusion relation is not present, and without corresponding abbreviation, or do not have
There is the corresponding Chinese or gauge outfit without corresponding to English to be divided into Chinese gauge outfit collection, English gauge outfit collection and abbreviation gauge outfit collection, and in calculating
Literary gauge outfit collection, English gauge outfit collection and abbreviation gauge outfit concentrate the similarity of every two gauge outfit.Similarity can be true according to editing distance
It is fixed.Two gauge outfits that similarity is higher than a predetermined threshold will be integrated into target table.
Through this embodiment, the data of table are integrated by the above method, improve table integration efficiency to realize
Effect.
As a kind of optional embodiment, above-mentioned apparatus further include:
(1) first determination unit, for by target gauge outfit and the corresponding Data Integration of target gauge outfit into target table it
Afterwards, gauge outfit is concentrated, in the gauge outfit in addition to target gauge outfit, the third gauge outfit appeared at least two original tables is determined as mesh
Mark the second target gauge outfit in table；
(2) buanch unit, for the non vacuum data of third gauge outfit column in multiple original tables to be transferred to target table
In the second target gauge outfit column.
Optionally, in the present solution, in the gauge outfit that inclusion relation will be present or the gauge outfit of abbreviation, Huo Zhexiang can be included
After being integrated into target table like the gauge outfit that degree is greater than first threshold, at least two can also be appeared in by remaining gauge outfit
Gauge outfit in a original table is determined as the gauge outfit in target table.And carry out Data Integration.
Through this embodiment, the data of table are integrated by the above method, improve table integration efficiency to realize
Effect.
As a kind of optional embodiment,
Above-mentioned third acquiring unit further include: (1) the 4th determining module, for including gauge outfit column in attribute information
Data data format in the case where, in the first gauge outfit situation identical with the data format of the second gauge outfit column, will
First gauge outfit is determined as the first object gauge outfit in target table；
Above-mentioned integral unit includes: (1) the 5th shift module, is used for the first gauge outfit and/or second in multiple original tables
The non vacuum data of gauge outfit column is transferred to the first object gauge outfit column in target table.
Optionally, comparison data format can be the length of column data where the first gauge outfit of comparison and the second gauge outfit in this programme
Degree what/or type.If length is 11, type is number or length is 2-4, and type is Chinese character etc..
Through this embodiment, the data of table are integrated by the above method, improve table integration efficiency to realize
Effect.
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 table integration method characterized by comprising
The gauge outfit for obtaining each column of each original table in multiple original tables obtains the first gauge outfit collection；
Obtain the attribute information that first gauge outfit concentrates each gauge outfit, wherein the attribute information is used to indicate the gauge outfit
The attribute of place data column；
The target gauge outfit for belonging to same alike result is obtained according to the attribute information；
By the target gauge outfit and the corresponding Data Integration of the target gauge outfit into target table.
2. the method according to claim 1, wherein
It includes described that the target gauge outfit for belonging to same alike result according to attribute information acquisition, which includes: in the attribute information,
In the case where character information in gauge outfit, the inclusion relation of the character information is compared, includes in the character information of the first gauge outfit
In the case where the character information of second gauge outfit, the first object gauge outfit that second gauge outfit is determined as in the target table；
It is described include: into target table by the target gauge outfit and the corresponding Data Integration of the target gauge outfit will be the multiple
The non vacuum data of first gauge outfit described in original table and/or the second gauge outfit column is transferred to the first object gauge outfit institute
It is arranging.
3. according to the method described in claim 2, it is characterized in that, by the first gauge outfit described in the multiple original table and/
Or the non vacuum data of the second gauge outfit column is transferred to after the first object gauge outfit column, further includes:
It, will be described more in the case where first gauge outfit includes the first abbreviation and/or second gauge outfit includes the second abbreviation
The non vacuum data of first abbreviation described in a original table and/or the second abbreviation column is transferred in the target table
The first object gauge outfit column.
4. the method according to claim 1, wherein
It includes described that the target gauge outfit for belonging to same alike result according to attribute information acquisition, which includes: in the attribute information,
It is identical being converted to the character information of the character information of the first gauge outfit and the second gauge outfit in the case where character information in gauge outfit
After language format, in the identical situation of character information for being converted to two gauge outfits of same-language format, by first gauge outfit
The first object gauge outfit being determined as in the target table；
It is described include: into target table by the target gauge outfit and the corresponding Data Integration of the target gauge outfit will be the multiple
The non vacuum data of first gauge outfit described in original table and/or the second gauge outfit column is transferred to the institute in the target table
State first object gauge outfit column, wherein the target table is crosstab.
5. the method according to claim 1, wherein
It includes described that the target gauge outfit for belonging to same alike result according to attribute information acquisition, which includes: in the attribute information,
In the case where character information in gauge outfit, it is greater than in the similarity of the character information and the character information of the second gauge outfit of the first gauge outfit
In the case where first threshold, the first object gauge outfit that first gauge outfit is determined as in the target table；
It is described include: into target table by the target gauge outfit and the corresponding Data Integration of the target gauge outfit will be the multiple
The non vacuum data of first gauge outfit described in original table and/or the second gauge outfit column is transferred to the institute in the target table
State first object gauge outfit column.
6. the method according to claim 1, wherein by the target gauge outfit and the corresponding number of the target gauge outfit
After being integrated into target table, further includes:
The gauge outfit is concentrated, in the gauge outfit in addition to the target gauge outfit, appears at least two original tables
Three gauge outfits are determined as the second target gauge outfit in the target table；
Described in the non vacuum data of third gauge outfit column described in the multiple original table is transferred in the target table
Second target gauge outfit column.
7. the method according to claim 1, wherein
The target gauge outfit for belonging to same alike result according to attribute information acquisition includes: in the attribute information including institute
It is identical as the data format of the second gauge outfit column in the first gauge outfit in the case where the data format for stating the data of gauge outfit column
In the case where, the first object gauge outfit that the first gauge outfit is determined as in the target table；
It is described include: into target table by the target gauge outfit and the corresponding Data Integration of the target gauge outfit will be the multiple
The non vacuum data of first gauge outfit described in original table and/or the second gauge outfit column is transferred to the institute in the target table
State first object gauge outfit column.
8. a kind of table integrating apparatus characterized by comprising
First acquisition unit obtains the first gauge outfit for obtaining the gauge outfit of each column of each original table in multiple original tables
Collection；
Second acquisition unit concentrates the attribute information of each gauge outfit for obtaining first gauge outfit, wherein the attribute information
The attribute of data column where being used to indicate the gauge outfit；
Third acquiring unit, for obtaining the target gauge outfit for belonging to same alike result according to the attribute information；
Integral unit is used for the target gauge outfit and the corresponding Data Integration of the target gauge outfit into target table.
9. device according to claim 8, which is characterized in that
The third acquiring unit includes: the first determining module, for including the character in the gauge outfit in the attribute information
In the case where information, the inclusion relation of the character information is compared, includes the word of the second gauge outfit in the character information of the first gauge outfit
In the case where according with information, the first object gauge outfit that second gauge outfit is determined as in the target table；
The integral unit includes: the first shift module, for by the first gauge outfit described in the multiple original table and/or described
The non vacuum data of second gauge outfit column is transferred to the first object gauge outfit column.
10. device according to claim 9, which is characterized in that the integral unit further include:
Second shift module, for by the first gauge outfit described in the multiple original table and/or the second gauge outfit column
Non vacuum data be transferred to after the first object gauge outfit column, first gauge outfit include first abbreviation and/or institute
In the case where the second gauge outfit is stated including the second abbreviation, by the first abbreviation described in the multiple original table and/or second contracting
The non vacuum data for writing column is transferred to the first object gauge outfit column in the target table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910755222.7A CN110427604B (en) | 2019-08-15 | 2019-08-15 | Form integration method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910755222.7A CN110427604B (en) | 2019-08-15 | 2019-08-15 | Form integration method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110427604A true CN110427604A (en) | 2019-11-08 |
| CN110427604B CN110427604B (en) | 2022-12-06 |
Family
ID=68416561
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910755222.7A Active CN110427604B (en) | 2019-08-15 | 2019-08-15 | Form integration method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110427604B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111104784A (en) * | 2019-12-19 | 2020-05-05 | 金蝶软件（中国）有限公司 | Data integration method and related device |
| CN111782658A (en) * | 2020-07-08 | 2020-10-16 | 支付宝(杭州)信息技术有限公司 | Cross table processing method, cross table processing device, electronic equipment and storage medium |
| CN112528613A (en) * | 2020-12-21 | 2021-03-19 | 金蝶软件（中国）有限公司 | Data table generation method and related equipment thereof |
| CN114254599A (en) * | 2021-10-11 | 2022-03-29 | 上海新氦类脑智能科技有限公司 | Form merging method, processing chip and electronic equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060259507A1 (en) * | 2005-05-16 | 2006-11-16 | International Business Machines Corporation | Method and apparatus for processing a dimension table and deriving a hierarchy therefrom |
| CN105630986A (en) * | 2015-12-25 | 2016-06-01 | 中国航天系统工程有限公司 | Method for acquiring multidimensional data from database for grid display |
| CN109376162A (en) * | 2018-09-03 | 2019-02-22 | 平安普惠企业管理有限公司 | Table data processing method, terminal device and computer readable storage medium |
| CN109635011A (en) * | 2018-10-31 | 2019-04-16 | 北京辰森世纪科技股份有限公司 | Multistage gauge outfit report processing method, device and equipment based on data service metadata |
-
2019
- 2019-08-15 CN CN201910755222.7A patent/CN110427604B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060259507A1 (en) * | 2005-05-16 | 2006-11-16 | International Business Machines Corporation | Method and apparatus for processing a dimension table and deriving a hierarchy therefrom |
| CN105630986A (en) * | 2015-12-25 | 2016-06-01 | 中国航天系统工程有限公司 | Method for acquiring multidimensional data from database for grid display |
| CN109376162A (en) * | 2018-09-03 | 2019-02-22 | 平安普惠企业管理有限公司 | Table data processing method, terminal device and computer readable storage medium |
| CN109635011A (en) * | 2018-10-31 | 2019-04-16 | 北京辰森世纪科技股份有限公司 | Multistage gauge outfit report processing method, device and equipment based on data service metadata |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111104784A (en) * | 2019-12-19 | 2020-05-05 | 金蝶软件（中国）有限公司 | Data integration method and related device |
| CN111104784B (en) * | 2019-12-19 | 2024-03-12 | 金蝶软件（中国）有限公司 | Data integration method and related device |
| CN111782658A (en) * | 2020-07-08 | 2020-10-16 | 支付宝(杭州)信息技术有限公司 | Cross table processing method, cross table processing device, electronic equipment and storage medium |
| CN112528613A (en) * | 2020-12-21 | 2021-03-19 | 金蝶软件（中国）有限公司 | Data table generation method and related equipment thereof |
| CN114254599A (en) * | 2021-10-11 | 2022-03-29 | 上海新氦类脑智能科技有限公司 | Form merging method, processing chip and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110427604B (en) | 2022-12-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110427604A (en) | Table integration method and device | |
| CN106570456B (en) | Handwritten Chinese character text recognition method based on full convolution Recursive Networks | |
| CN104123374B (en) | The method and device of aggregate query in distributed data base | |
| US9367605B2 (en) | Abstract generating search method and system | |
| WO2020233269A1 (en) | Method and apparatus for reconstructing 3d model from 2d image, device and storage medium | |
| CN107092639A (en) | A kind of search engine system | |
| CN109325132A (en) | Expertise recommended method, device, computer equipment and storage medium | |
| CN106156365A (en) | A kind of generation method and device of knowledge mapping | |
| CN107203507B (en) | Feature vocabulary extracting method and device | |
| WO2007088536A3 (en) | Method and system for searching data using a virtual assistant | |
| CN105893615B (en) | Owner's characteristic attribute method for digging and its system based on Mobile Phone Forensics data | |
| CN105843956A (en) | Paging query method and system | |
| CN108121697A (en) | Method, apparatus, equipment and the computer storage media that a kind of text is rewritten | |
| CN109918627A (en) | Document creation method, device, electronic equipment and storage medium | |
| CN105159927B (en) | Method and device for selecting subject term of target text and terminal | |
| CN101661484A (en) | Query method and query system | |
| CN106155769A (en) | A kind of workflow processing method, device and workflow engine | |
| CN108153719A (en) | Merge the method and apparatus of electrical form | |
| CN110209780B (en) | Question template generation method and device, server and storage medium | |
| CN104572736A (en) | Keyword extraction method and device based on social networking services | |
| CN108388556A (en) | The method for digging and system of similar entity | |
| CN103514284B (en) | Data display system and data display method | |
| CN110222103A (en) | Extract method and device, the computer equipment, storage medium of excel data | |
| CN104462151B (en) | Assess the method and relevant apparatus of Homepage Publishing time | |
| CN106844338A (en) | Detection method based on the entity row of the network form of dependence between attribute |
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 |