CN113407536B - Method, device, terminal equipment and medium for associating table data - Google Patents
Method, device, terminal equipment and medium for associating table data Download PDFInfo
- Publication number
- CN113407536B CN113407536B CN202110651319.0A CN202110651319A CN113407536B CN 113407536 B CN113407536 B CN 113407536B CN 202110651319 A CN202110651319 A CN 202110651319A CN 113407536 B CN113407536 B CN 113407536B
- Authority
- CN
- China
- Prior art keywords
- field
- matched
- matching
- association
- table data
- 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
- 238000000034 method Methods 0.000 title claims abstract description 77
- 230000000875 corresponding effect Effects 0.000 claims description 102
- 230000000007 visual effect Effects 0.000 claims description 25
- 238000004590 computer program Methods 0.000 claims description 15
- 238000004458 analytical method Methods 0.000 claims description 11
- 230000002596 correlated effect Effects 0.000 claims description 8
- 238000010586 diagram Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application is applicable to the technical field of big data, and provides a table data association method, a device, terminal equipment and a medium, which are applied to the terminal equipment, wherein the method comprises the following steps: acquiring a plurality of tables to be associated; determining a first table to be associated and a second table to be associated from the plurality of tables to be associated based on the sequence of acquiring the plurality of tables to be associated; acquiring a first field to be matched contained in a first table to be associated and a plurality of second fields to be matched contained in a second table to be associated; according to the sequence, sequentially carrying out field name matching on the first field to be matched and a plurality of second fields to be matched in a second table to be associated from back to front; if the field names are successfully matched, establishing table data corresponding to the first field to be matched and association relation of table data corresponding to the matched second field to be matched. By adopting the method, when the terminal equipment establishes the association relation for the data among the data tables, the processing time for carrying out association matching on the data tables is reduced.
Description
Technical Field
The application belongs to the technical field of big data, and particularly relates to a table data association method, a table data association device, terminal equipment and a table data association medium.
Background
At present, in the process of designing and using a database, data is generally not stored in a single data table of the database, and different data are generally stored in a plurality of data tables.
However, when a user establishes an association relationship with data among a plurality of data tables, it is necessary to know the specific meaning of each field in each data table. In establishing a data association between a plurality of data tables, it is generally necessary to manually query the data tables to understand each field between the data tables. And setting corresponding association relations according to field names or paraphrases represented by the fields in the data table. Therefore, when the method is used for establishing the association relation of the data among the data tables, the efficiency of establishing the association relation is low.
Disclosure of Invention
The embodiment of the application provides a table data association method, a table data association device, terminal equipment and a medium, which can solve the problem of low efficiency in the existing method when an association relation among a plurality of data tables is established.
In a first aspect, an embodiment of the present application provides a method for associating table data, which is applied to a terminal device, and includes:
Acquiring a plurality of tables to be associated;
determining a first table to be associated from the plurality of tables to be associated and a second table to be associated with the first table to be associated based on the sequence of acquiring the plurality of tables to be associated;
Acquiring a first field to be matched contained in the first table to be associated and a plurality of second fields to be matched contained in the second table to be associated;
according to the sequence, sequentially matching field names of the first fields to be matched with a plurality of second fields to be matched in the second table to be associated from back to front;
If the field names are successfully matched, establishing table data corresponding to the first field to be matched and association relation of the table data corresponding to the matched second field to be matched.
In an embodiment, determining a first table to be associated from the plurality of tables to be associated and a second table to be associated with the first table to be associated based on a sequence of acquiring the plurality of tables to be associated includes:
and determining the last acquired table to be associated as a first table to be associated and determining other tables to be associated as a second table to be associated according to the sequence of acquiring the plurality of tables to be associated.
In an embodiment, the field name matches include at least one of an ID identifier match, a field name match, and a field annotation match; the first field to be matched comprises at least one of a first ID identifier, a first field name and a first field annotation, and the second field to be matched comprises at least one of a second ID identifier, a second field name and a second field annotation; according to the sequence, sequentially carrying out field name matching on the first field to be matched and a plurality of second fields to be matched in the second association table from back to front, wherein the field name matching comprises;
s1, based on the sequence, sequentially matching the first ID identifiers with second ID identifiers respectively corresponding to a plurality of second fields to be matched in the second table to be associated from back to front;
S2, in the matching process, if the first ID identifier is matched with a second ID identifier corresponding to any second field to be matched, establishing an association relationship between table data corresponding to the first ID identifier and table data corresponding to the second ID identifier, and ending the matching process;
and S3, if the first ID identifier is not matched with the second ID identifier corresponding to any second field to be matched, repeating the matching steps of S1 and S2 by sequentially using the first field name, the second field name, the first field annotation and the second field annotation until the matching process of the first field to be matched of the first table to be correlated and the plurality of second fields to be matched of the second table to be correlated ends.
In an embodiment, the terminal device further comprises a paraphrasing analysis model; in performing the matching of the first field annotation and the second field annotation, the method further comprises:
respectively inputting the first field annotation and second field annotations corresponding to the plurality of second fields to be matched into a paraphrase analysis model to obtain the matching degree of the first field annotation and each second field annotation;
If the matching degree of the maximum value is larger than or equal to the preset matching degree in the plurality of matching degrees, establishing a correlation relationship between the first field annotated table data and the second field annotated table data corresponding to the matching degree of the maximum value.
In an embodiment, the terminal device includes a visual operation interface; if the field names are successfully matched, establishing table data corresponding to the first field to be matched, and after the association relationship between the table data corresponding to the matched second field to be matched and the table data corresponding to the matched second field to be matched, further comprising;
Displaying the association relation in the visual operation interface;
And operating the association relation according to an input instruction of a user in the visual operation interface, wherein the operation comprises any one of deleting, adjusting and adding the association relation.
In an embodiment, after establishing the table data corresponding to the first field to be matched and the association relationship with the table data corresponding to the matched second field to be matched if the field name is successfully matched, the method further includes:
determining a target to-be-associated table for data query;
based on the association relation, determining a target matching field with the association relation established in the target to-be-associated table, and determining an association matching field with the association relation with the target matching field;
Traversing the association relation by taking the association matching field as a target matching field to repeatedly execute the determination of the association matching field with the association relation with the target matching field;
after the traversal of the association relation is finished, the acquired table data corresponding to the target matching fields are displayed in the visual operation interface.
In an embodiment, after the traversing of the association relationship is finished, displaying the table data corresponding to the obtained multiple target matching fields in the visual operation interface, the method further includes:
setting any one field of the target matching fields as a main key, setting other target matching fields as external keys, and establishing a main external key relation between the main key and the external keys; the primary foreign key relationship is used for modifying the table data in the target matching field corresponding to the foreign key when the table data in the target matching field corresponding to the primary key is modified.
In a second aspect, an embodiment of the present application provides a table data association apparatus, which is applied to a terminal device, where the apparatus includes:
the first acquisition module is used for acquiring a plurality of tables to be associated;
The first determining module is used for determining a first table to be associated from the plurality of tables to be associated and a second table to be associated with the first table to be associated based on the sequence of acquiring the plurality of tables to be associated;
the second acquisition module is used for acquiring a first field to be matched contained in the first table to be associated and a plurality of second fields to be matched contained in the second table to be associated;
The matching module is used for carrying out field name matching on the first field to be matched and a plurality of second fields to be matched in the second association table sequentially from back to front according to the sequence;
And the first establishing module is used for establishing the association relation between the table data corresponding to the first field to be matched and the table data corresponding to the matched second field to be matched if the field names are successfully matched.
In a third aspect, an embodiment of the present application provides a terminal device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, the processor implementing the method according to any one of the first aspects when executing the computer program.
In a fourth aspect, embodiments of the present application provide a computer readable storage medium storing a computer program which, when executed by a processor, implements a method as in any of the first aspects above.
In a fifth aspect, an embodiment of the application provides a computer program product for, when run on a terminal device, causing the terminal device to perform the method of any of the first aspects described above.
Compared with the prior art, the embodiment of the application has the beneficial effects that: and the terminal equipment sequentially determines each table to be associated as a first table to be associated to execute the association method of the table data according to the sequence of each table to be associated when being acquired. And determining a plurality of tables to be associated, which are sequentially positioned before the first table to be associated, as a second table to be associated when the association method of the table data is executed on the first table to be associated. And then, according to the sequence, carrying out field name matching on the first field to be matched in the first table to be associated and a plurality of second fields to be matched in the second table to be associated sequentially from back to front so as to fully mine association relations among the plurality of tables to be associated. And finally, when the field names are successfully matched, establishing table data corresponding to the first field to be matched and the association relation of the table data corresponding to the matched second field to be matched. Therefore, after the association relation between the table data, the terminal equipment can finish name matching between the first field to be matched and the second fields to be matched in the other second tables to be associated, so that the processing time for carrying out table data association on a plurality of tables to be associated is reduced.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are required to be used in the embodiments or the prior art descriptions will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained according to the drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart illustrating an implementation of a method for associating table data according to an embodiment of the present application;
FIG. 2 is a schematic diagram of an implementation manner of S104 of a table data association method according to an embodiment of the present application;
FIG. 3 is a flowchart of a method for associating table data according to another embodiment of the present application;
FIG. 4 is a flowchart of an implementation of a method for associating table data according to another embodiment of the present application;
FIG. 5 is a flowchart illustrating a method for associating table data according to another embodiment of the present application;
FIG. 6 is a schematic diagram of a table data association device according to an embodiment of the present application;
fig. 7 is a schematic structural diagram of a terminal device according to an embodiment of the present application.
Detailed Description
In the following description, for purposes of explanation and not limitation, specific details are set forth such as the particular system architecture, techniques, etc., in order to provide a thorough understanding of the embodiments of the present application. It will be apparent, however, to one skilled in the art that the present application may be practiced in other embodiments that depart from these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present application with unnecessary detail.
It should be understood that the terms "comprises" and/or "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
Furthermore, the terms "first," "second," "third," and the like in the description of the present specification and in the appended claims, are used for distinguishing between descriptions and not necessarily for indicating or implying a relative importance.
The table data association method provided by the embodiment of the application can be applied to terminal equipment such as tablet computers, notebook computers, ultra-mobile personal computer (UMPC) and netbooks, and the specific type of the terminal equipment is not limited.
Referring to fig. 1, fig. 1 shows a flowchart of an implementation of a table data association method according to an embodiment of the present application, where the method includes the following steps:
s101, acquiring a plurality of tables to be associated.
In an embodiment, any of the tables to be associated may be a data table stored in a database in advance. The table data included in each table to be associated may be partially the same or completely different, which is not limited. It will be appreciated that in the process of designing and using a database, data will not be stored in a single data table, but different data will be stored in multiple data tables, or data with correlation will be split into multiple data tables to be stored cooperatively.
For example, the related information of the teacher and the students can be stored in a plurality of data tables in a database of a school system. For example, a database may have stored therein teacher information tables, student information tables, curriculum tables, class tables, achievement tables, and the like. Each table contains corresponding data, and the data between the data tables has certain relativity.
In an embodiment, to set the association relationship between the data tables, the number of tables to be associated to be used should include at least two. Wherein, for a plurality of data tables contained in the database, it can select at least two tables from the plurality of data tables based on the operation instruction of the user, and determine to be associated table.
In an embodiment, the plurality of acquired tables to be associated may be selected from the database by the user, and dragged into the terminal device in sequence, and then displayed on a visual operation interface of the terminal device. Meanwhile, the user can delete the selected table to be associated in the visual operation interface, and the table to be associated is not limited.
S102, determining a first table to be associated and a second table to be associated with the first table to be associated from the plurality of tables to be associated based on the sequence of acquiring the plurality of tables to be associated.
In an embodiment, when the obtaining of the plurality of tables to be associated has been described in S101, the plurality of tables to be associated are sequentially input to the terminal device and displayed on the visual operation interface. Based on the above, it can be considered that the terminal device can record the sequence of each table to be associated when obtaining the corresponding table to be associated.
In an embodiment, the first table to be associated may be a data table currently executing the table data association method. Meanwhile, the terminal equipment can respectively determine the rest tables to be associated as second tables to be associated; or based on the sequence, determining the multiple tables to be associated with the sequence number before the sequence number of the first table to be associated as a second table to be associated, which is not limited.
For example, if the terminal device acquires multiple tables to be associated at the same time, the terminal device may perform association processing from the table to be associated with the sequence number of 2. The table to be associated with the sequence number of 2 is used as a first table to be associated, and meanwhile, the table to be associated with the sequence number of the first table to be associated (i.e. the table to be associated with the sequence number of 1) is determined as a second table to be associated, so that the table data association method is carried out. Thereafter, association processing may be performed on the table to be associated with the sequence number 3. The to-be-associated table with the sequence number of 3 is used as a first to-be-associated table, and the to-be-associated tables with the sequence number of the first to-be-associated table (i.e. to-be-associated tables with the sequence numbers of 1 and 2) are both determined as second to-be-associated tables, so that data association among a plurality of to-be-associated tables is completed.
Specifically, the number of tables to be associated is N (the sequence of each table to be associated is 1 to N respectively), and if the sequence number of the first table to be associated to be processed is M (M is less than or equal to N), the set of the second table to be associated is A= { L,1 is less than or equal to L is less than or equal to M-1}.
In another example, the terminal device may also determine, according to the order in which the multiple tables to be associated are acquired, the last acquired table to be associated as the first table to be associated, and determine the other tables to be associated as the second table to be associated. That is, each time the table to be associated is acquired, the currently acquired table to be associated is determined as the first table to be associated.
For example, after the terminal device obtains the table to be associated with the sequence number 1, the terminal device may determine the next obtained table to be associated with the sequence number 2 (compared with the table to be associated with the sequence number 1, that is, the table to be associated obtained last) as the first table to be associated, and determine the table to be associated with the sequence number 1 as the second table to be associated, and perform the above-mentioned field name matching procedure on the first table to be associated. And thus, the above operation is performed on the table to be associated which is located after the sequence number 2. Based on the above, the terminal device may redetermine the first table to be associated and the second table to be associated based on the table to be associated acquired each time and the corresponding sequence.
S103, obtaining a first field to be matched contained in the first table to be associated and a plurality of second fields to be matched contained in the second table to be associated.
In an embodiment, for the first field to be matched, the first field to be matched may be any one of a plurality of fields in the first table to be associated, or may be a matching field determined in the first table in advance by the user, which is not limited.
It should be noted that, if there are multiple fields in the first table to be associated, when the association relationship is established for the first table to be associated, each field is generally used as a first field to be matched, and steps S104-S105 are sequentially performed for each first field to be matched, which is not limited.
Similarly, for the second field to be matched in any second table to be associated, it may be any matching field in multiple fields in the second table to be associated, or may be a field set in the second table in advance by the user for matching association relationship, which is not limited.
And S104, according to the sequence, sequentially matching the field names of the first fields to be matched with a plurality of second fields to be matched in the second association table from back to front.
In one embodiment, the above sequence of inputting is already explained in S102, which will not be explained. Based on the sequence, in this embodiment, the first field to be matched and each second field to be matched in the second table to be associated are sequentially subjected to name matching in a sequence from back to front. That is, if the table sequence number of the first to-be-processed table is M, the first to-be-processed table is first subjected to field name matching with a plurality of second to-be-matched fields in the second to-be-processed table with the table sequence number of M-1. And then, when the matching is unsuccessful, matching with another table to be associated until the matching is successful, or executing the steps of S103-S105 with a second table to be associated with the sequence number of 1.
It should be specifically noted that, if the matching is performed from front to back each time when the association relation of the first table to be associated is matched, for any first table to be associated, there may be a matching relation between most of the first table to be associated and the table to be associated with the sequence number 1. That is, the association relation among the plurality of tables to be associated is not fully established, which is not beneficial to comprehensively analyzing the table data in the plurality of tables to be associated.
Based on the above, for any first table to be associated, according to the sequence, the first fields to be matched are sequentially subjected to field name matching with a plurality of second fields to be matched in the second tables to be associated from back to front, so that the association relation of table data among the plurality of tables to be associated can be fully mined and established.
S105, if the field names are successfully matched, establishing the association relationship between the table data corresponding to the first field to be matched and the table data corresponding to the matched second field to be matched.
In an embodiment, the matching between the first field to be matched and any second field to be matched is successful, that is, the field names of the first field to be matched and the second field to be matched are considered to be consistent, or the similarity is greater than a preset threshold, which is not limited.
It should be added that, after the association relationship is successfully established, the terminal device may terminate execution of field name matching between the first table to be associated and the remaining second tables to be associated. It can be understood that S104 above has described that the terminal device performs field name matching on the first field to be matched and the plurality of second fields to be matched in the second table to be associated sequentially from back to front. It will be appreciated, therefore, that this second table to be associated has been previously referred to as a "first table to be associated" and that a corresponding matching procedure has been performed on the fields to be matched that it contains.
Based on this, in this embodiment, the terminal device sequentially determines each table to be associated as the association method of the first table to be associated execution table data according to the sequence when each table to be associated is acquired. And determining a plurality of tables to be associated, which are sequentially positioned before the first table to be associated, as a second table to be associated when the association method of the table data is executed on the first table to be associated. And then, according to the sequence, carrying out field name matching on the first fields to be matched in the first tables to be associated and the second fields to be matched in the second tables to be associated sequentially from back to front so as to fully mine the association relation among the plurality of tables to be associated. And finally, when the field names are successfully matched, establishing the table data corresponding to the first field to be matched and the association relation of the table data corresponding to the matched second field to be matched. Therefore, after the association relation between the table data, the terminal equipment can finish name matching between the first field to be matched and the second fields to be matched in the other second tables to be associated, so that the processing time for carrying out table data association on a plurality of tables to be associated is reduced.
Referring to FIG. 2, in one embodiment, the field name matches include at least one of an ID identifier match, a field name match, and a field annotation match; the first field to be matched comprises at least one of a first ID identifier, a first field name and a first field annotation, and the second field to be matched comprises at least one of a second ID identifier, a second field name and a second field annotation; in step S104, according to the sequence, the field name matching is performed between the first field to be matched and a plurality of second fields to be matched in the second table to be associated sequentially from back to front, which specifically includes the following substeps S1041-1043, which are described in detail below:
S1041, based on the sequence, matching the first ID identifiers with second ID identifiers corresponding to a plurality of second fields to be matched in the second table to be associated sequentially from back to front.
S1042, in the matching process, if the first ID identifier is matched with a second ID identifier corresponding to any of the second fields to be matched, establishing an association relationship between table data corresponding to the first ID identifier and table data corresponding to the second ID identifier, and ending the matching process.
S1043, if the first ID identifier is not matched with the second ID identifier corresponding to any of the second fields to be matched, repeating the matching steps of S1041 and S1042 by sequentially using the first field name, the second field name, the first field annotation and the second field annotation until the matching process of the first field to be matched of the first table to be matched and the plurality of second fields to be matched of the second table to be associated is finished.
In one embodiment, the fields in any table to be associated generally have at least one of a corresponding field name, ID identifier, and field annotation. Thus, the above name matching includes, but is not limited to, matching based on one or more of an ID identifier, a field name, and a field annotation.
In one embodiment, the field name is generally the content recorded in the first cell of a list of cells. Each column in the table to be associated is a field, and a field name can be used to represent the data recorded in the field, which can be specified and edited by a user. The ID identifier is used to uniquely identify the corresponding field, and the identifier includes, but is not limited to, identification in the form of a special symbol, a number, etc. The above-mentioned field notes are used to understand the meaning represented by each field, and can be edited by the user when creating each table to be associated.
For example, for the first table to be associated, if it is a two-dimensional student relationship table, field names included in each field in the first row in the horizontal direction are respectively: serial number, name, etc. The "columns" corresponding to the serial number, the number and the name are collectively called "fields", and each "field" is used for containing information of a specific topic. At this time, the information contained in each "field" should be the column data corresponding to the "serial number, the number, and the name" respectively, and the "serial number, the number, and the name" are the field names. Based on this, the first field to be matched should be at least one of the fields of "serial number, and name". In addition, for any of the above fields to be matched, it may also have a unique computer-recognizable field identifier (i.e., an ID identifier) set by the user. For any table to be associated, the ID identifier of a "field" in each table should be unique in one table.
In an embodiment, when the first table to be associated includes at least one of a first ID identifier, a first field name, and a first field annotation match, the terminal device performs ID identifier matching based on the first ID identifier. And if the matching is not successful, matching is performed based on the first field name. Finally, matching is performed based on the first field annotation.
It should be noted that the above matching is preferably performed based on the first ID identifier for the purpose of: in conventional table designs, fields with ID identifiers associated therewith typically have unique indexes. Based on this, when data matching is performed according to the association relationship of the ID identifiers, the accuracy of the matched data can be increased. And then carrying out association matching based on the field names and the field notes in sequence. It will be appreciated that in field annotation matching, the machine is required to perform semantic recognition and make decisions as the field annotations require. Therefore, matching that correlates data based on field annotations can be considered to be less accurate. The terminal equipment can finally carry out association relation matching through the word section annotation.
In an embodiment, the step of matching using the first field name and the second field name, and the step of matching using the first field annotation and the second field annotation are similar to the matching steps of S1041 and S1042, which will not be described in detail.
Referring to FIG. 3, in one embodiment, the terminal device further includes a paraphrasing analysis model; in the process of matching the first field annotation and the second field annotation, the method specifically includes the following substeps S141-142, which are described in detail below:
s141, respectively inputting second field notes corresponding to the first field notes and the plurality of second fields to be matched into a paraphrase analysis model to obtain the matching degree of the first field notes and each second field note.
And S142, if the matching degree of the maximum value is greater than or equal to the preset matching degree in the plurality of matching degrees, establishing an association relationship between the first field annotated table data and the second field annotated table data corresponding to the matching degree of the maximum value.
In one embodiment, the paraphrase analysis model is used to model the first field annotation and the second field annotation to output paraphrase similarity (i.e., matching degree) of the two. The paraphrasing analysis model may be a plurality of existing semantic analysis models, which will not be described in detail.
Note that, for the matching process of making a field annotation, it is somewhat different from the matching process of making an ID identifier and the matching process of making a field name. Specifically, in the process of matching the ID identifiers, if the first ID identifier is matched with the second ID identifier corresponding to the Ren Yidi two fields to be matched, the association relationship between the table data corresponding to the first ID identifier and the table data corresponding to the second ID identifier is established, and the matching process is ended. I.e. the first ID identifier does not necessarily need to be matched with all the second ID identifiers.
However, in the matching process of the field notes, the first field notes need to be matched with each second field note in each second table to be associated, so as to obtain a corresponding matching degree. And if the matching degree of the maximum value is greater than or equal to the preset matching degree, establishing an association relationship between the first field annotated table data and the second field annotated table data corresponding to the matching degree of the maximum value. Otherwise, the terminal device may determine that the first field annotation does not match any of the second field annotations. Based on this, it can be appreciated that the first field annotation needs to be matched with each of the second field annotations. Therefore, when the terminal equipment performs matching based on the field annotation, the accuracy of the association matching of the table data can be improved as much as possible.
Referring to fig. 4, in an embodiment, the terminal device includes a visual operation interface; if the field name is successfully matched in S105, the method further includes the following steps S151-152, which are described in detail below, after establishing the association relationship between the table data corresponding to the first field to be matched and the table data corresponding to the second matched field to be matched:
and S151, displaying the association relation in the visual operation interface.
S152, operating the association relation according to an input instruction of a user in the visual operation interface, wherein the operation comprises any one of deleting, adjusting and adding the association relation.
In an embodiment, the visual operation interface is explained in S101, which will not be described. It should be noted that, after executing the steps in S102-S105 on the plurality of tables to be associated, the terminal device may obtain the association relationship between the plurality of tables to be associated and display the association relationship. And if the user does not recognize the established one or more association relationships or needs to add additional association relationships, the terminal equipment can carry out secondary modification on the established one or more association relationships based on the input instruction of the user in the visual operation interface.
Based on this, when the user does not have professional software program background knowledge or deep knowledge of the association relationship between the table structure and the table data, the association relationship between the tables may be established based on the method in S101 to S105. The user can further correct the obtained association relationship by using the method of S151 to S152. Therefore, the time for establishing the association relation for the plurality of tables to be associated can be reduced, and the accuracy of association matching of the table data can be improved.
Referring to fig. 5, in an embodiment, if the field names are successfully matched in S105, after establishing the table data corresponding to the first field to be matched and the association relationship between the table data corresponding to the second field to be matched, the method specifically further includes the following steps S153-156, which are described in detail below:
S153, determining a target to-be-associated table for data query.
S154, based on the association relation, determining a target matching field with the association relation established in the target to-be-associated table, and determining an association matching field with the association relation with the target matching field.
In an embodiment, the target table to be associated may be any one of a plurality of tables to be associated, which may be determined by a user. It should be noted that, if any one to-be-associated table does not establish an association relationship with other to-be-associated tables in the plurality of to-be-associated tables, the to-be-associated table having no association relationship should not be determined as the target to-be-associated table to be subjected to data query.
In an embodiment, because not all fields in the target table to be associated may be associated with fields in other tables to be associated. Therefore, the terminal device also needs to determine the target matching field from the target to-be-associated table based on the association relationship, and determine the association matching field having the association relationship with the target matching field from the rest of to-be-associated tables.
And S155, traversing the association relation by taking the association matching field as a target matching field so as to repeatedly execute the association matching field which is determined to have the association relation with the target matching field.
And S156, after the traversal of the association relation is finished, displaying the acquired table data corresponding to the target matching fields in the visual operation interface.
In an embodiment, when determining the association matching field having the association relation with the target matching field from the rest of the to-be-associated tables, the terminal device performs matching from back to front in the field name association matching process, and after the association relation between the first to-be-matched field and any second to-be-matched field in the first to-be-associated table is established, the matching process is ended. Therefore, for the target matching field in the target to-be-associated table, the association relationship directly established with the target matching field should have at most two.
For example, for five tables with sequence numbers 1,2,3, 4 and 5, if the table with sequence number 3 is a target table to be associated, the target matching field in the target table to be associated is a. Then, based on the association relation, determining the association relation with the tables to be associated before the sequence number (namely, the sequence number is 2); and matching with the table to be associated after the sequence number (i.e. sequence number 4). If the fact that the field a in the table to be associated with the sequence number 4 is matched with the target field A is determined based on the association relation, the field a is determined to be an association matching field. Then, based on the association relationship, the field a is used as a target matching field, and the fields in the multiple tables to be associated after the sequence number 4 (namely the sequence number 5) are matched. And if the fact that the a 'field is matched with the A target field is determined to be in the to-be-associated table with the sequence number of 2 based on the association relation, determining that the a' field is an association matching field. And then, based on the association relation, using the field a' as a target matching field, and matching the fields in the multiple tables to be associated before the sequence number is 2 (namely the sequence number is 1). And finishing traversing among the multiple tables to be associated based on the association relation, and displaying the acquired table data corresponding to the multiple target matching fields in the visual operation interface.
In an embodiment, after finishing the traversing of the association relationship in S156, the table data corresponding to the obtained multiple target matching fields is displayed in the visual operation interface, and the method specifically further includes the following steps, which are described in detail below:
Setting any one field of the target matching fields as a main key, setting other target matching fields as external keys, and establishing a main external key relation between the main key and the external keys; the primary foreign key relationship is used for modifying the table data in the target matching field corresponding to the foreign key when the table data in the target matching field corresponding to the primary key is modified.
In an embodiment, the primary key is used for uniquely identifying a field (such as a serial number, a school number, and a name), so that the correctness and rationality of the data in the table to be associated can be ensured, and the value is not null. The external key is used for establishing a connection between the data tables and ensuring the reference integrity of the data tables. For the foreign key in any data to be associated, the value of the foreign key may be null or not null. In the multiple data tables with the main external key association relationship, after the user modifies the data in the field to be matched corresponding to the main key, the data in the field to be matched of the corresponding external key is also modified. Therefore, the consistency and the correctness of the data in the plurality of table data of the database can be ensured, and the time for the user to modify the table data of the plurality of queried target matching fields one by one is reduced.
It should be noted that, although the primary key is used to uniquely identify a field, it is somewhat different from the ID identifier. Specifically, for any table to be associated, it should have only one primary key. Based on this, for the target matching field in any table to be associated, if the target matching field meets the setting requirement of the primary key (can be used to uniquely identify one field and take a value other than null and unique), the terminal device should determine one of the fields to be matched as the primary key. And setting the target matching fields in the rest of the tables to be associated as foreign keys, and correspondingly establishing the connection. At this time, in the table to be associated with the primary key, the remaining fields to be matched cannot be set as the primary key even if they meet the setting requirement of the primary key. I.e. it should have only one primary key for any table to be associated.
Referring to fig. 6, fig. 6 is a block diagram of a table data association device according to an embodiment of the application. The table data associating device in this embodiment includes modules for executing the steps in the embodiments corresponding to fig. 1 to 5. Please refer to fig. 1 to 5 and the related descriptions in the embodiments corresponding to fig. 1 to 5. For convenience of explanation, only the portions related to the present embodiment are shown. Referring to fig. 6, the table data association apparatus 600 includes: a first acquisition module 610, a first determination module 620, a second acquisition module 630, a matching module 640, and a first establishment module 650, wherein:
The first obtaining module 610 is configured to obtain a plurality of tables to be associated.
The first determining module 620 is configured to determine, based on a sequence of acquiring the plurality of tables to be associated, a first table to be associated from the plurality of tables to be associated, and a second table to be associated with the first table to be associated.
A second obtaining module 630, configured to obtain a first field to be matched included in the first table to be associated and a plurality of second fields to be matched included in the second table to be associated.
And the matching module 640 is configured to match field names of the first field to be matched with a plurality of second fields to be matched in the second table from back to front according to the sequence.
The first establishing module 650 is configured to establish a correlation relationship between the table data corresponding to the first field to be matched and the table data corresponding to the second field to be matched if the field name is successfully matched.
In an embodiment, the first determining module 620 is further configured to:
and determining the last acquired table to be associated as a first table to be associated and determining other tables to be associated as a second table to be associated according to the sequence of acquiring the plurality of tables to be associated.
In an embodiment, the field name matches include at least one of an ID identifier match, a field name match, and a field annotation match; the first field to be matched comprises at least one of a first ID identifier, a first field name and a first field annotation, and the second field to be matched comprises at least one of a second ID identifier, a second field name and a second field annotation; the matching module 640 is configured to:
S1, based on the sequence, sequentially matching the first ID identifiers with second ID identifiers respectively corresponding to a plurality of second fields to be matched in the second table to be associated from back to front; s2, in the matching process, if the first ID identifier is matched with a second ID identifier corresponding to any second field to be matched, establishing an association relationship between table data corresponding to the first ID identifier and table data corresponding to the second ID identifier, and ending the matching process; and S3, if the first ID identifier is not matched with a second ID identifier corresponding to any second field to be matched, repeating the matching steps of S1 and S2 by sequentially using the first field name, the second field name, the first field annotation and the second field annotation until the matching process of the first field to be matched of the first table to be correlated with the plurality of second fields to be matched of the second table to be correlated is finished.
In an embodiment, the terminal device further comprises a paraphrasing analysis model; the matching module 640 is configured to:
respectively inputting the first field annotation and second field annotations corresponding to the plurality of second fields to be matched into a paraphrase analysis model to obtain the matching degree of the first field annotation and each second field annotation; if the matching degree of the maximum value is larger than or equal to the preset matching degree in the plurality of matching degrees, establishing a correlation relationship between the first field annotated table data and the second field annotated table data corresponding to the matching degree of the maximum value.
In an embodiment, the terminal device includes a visual operation interface; the table data association apparatus 600 further includes:
The first display module is used for displaying the association relation in the visual operation interface.
And the operation module is used for operating the association relation according to an input instruction of a user in the visual operation interface, and the operation comprises any one of deleting, adjusting and adding the association relation.
In an embodiment, the table data association apparatus 600 further includes:
and the second determining module is used for determining a target to-be-associated table for data query.
The first establishing module is used for determining a target matching field with the established association relation in the target to-be-associated table based on the association relation, and determining an association matching field with the association relation with the target matching field.
And the traversing module is used for traversing the association relation by taking the association matching field as a target matching field so as to repeatedly execute the association matching field which is determined to have the association relation with the target matching field.
And the second display module is used for displaying the acquired table data respectively corresponding to the plurality of target matching fields in the visual operation interface after the traversal of the association relation is finished.
In an embodiment, the table data association apparatus 600 further includes:
The second establishing module is used for setting any one of the plurality of target matching fields as a main key, setting other target matching fields as external keys, and establishing a main external key relation between the main key and the external keys; the primary foreign key relationship is used for modifying the table data in the target matching field corresponding to the foreign key when the table data in the target matching field corresponding to the primary key is modified.
It should be understood that, in the block diagram of the table data association apparatus shown in fig. 6, each module is configured to perform each step in the embodiment corresponding to fig. 1 to 5, and each step in the embodiment corresponding to fig. 1 to 5 has been explained in detail in the foregoing embodiment, and specific reference is made to fig. 1 to 5 and related descriptions in the embodiment corresponding to fig. 1 to 5, which are not repeated herein.
Fig. 7 is a block diagram of a terminal device according to another embodiment of the present application. As shown in fig. 7, the terminal device 700 of this embodiment includes: a processor 710, a memory 720, and a computer program 730 stored in the memory 720 and executable on the processor 710, such as a program of an association method of table data. The processor 710, when executing the computer program 730, implements the steps of the embodiments of the above-described association method of table data, such as S101 to S105 shown in fig. 1. Or processor 710, when executing computer program 730, performs the functions of the modules in the embodiment corresponding to fig. 7, for example, the functions of modules 610 to 650 shown in fig. 6, refer to the related description in the embodiment corresponding to fig. 6.
By way of example, computer program 730 may be partitioned into one or more modules that are stored in memory 720 and executed by processor 710 to perform the present application. One or more of the modules may be a series of computer program instruction segments capable of performing the specified functions for describing the execution of the computer program 730 in the terminal device 700. For example, the computer program 730 may be divided into a first acquisition module, a first determination module, a second acquisition module, a matching module, and a first creation module, each module functioning specifically as above.
Terminal device 700 can include, but is not limited to, a processor 710, a memory 720. It will be appreciated by those skilled in the art that fig. 7 is merely an example of a terminal device 700 and does not constitute a limitation of the terminal device 700, and may include more or less components than illustrated, or may combine certain components, or different components, e.g., the terminal device may further include an input-output device, a network access device, a bus, etc.
The processor 710 may be a central processing unit, as well as other general purpose processors, digital signal processors, application specific integrated circuits, off-the-shelf programmable gate arrays or other programmable logic devices, discrete hardware components, etc. A general purpose processor may be a microprocessor or any conventional processor or the like.
Memory 720 may be an internal storage unit of terminal device 700, such as a hard disk or memory of terminal device 700. The memory 720 may also be an external storage device of the terminal device 700, such as a plug-in hard disk, a smart memory card, a flash memory card, etc. provided on the terminal device 700. Further, the memory 720 may also include both internal storage units and external storage devices of the terminal device 700.
The above embodiments are only for illustrating the technical solution of the present application, and are not limiting; although the application has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some of the technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present application, and are intended to be included in the scope of the present application.
Claims (8)
1. A method for associating table data, applied to a terminal device, the method comprising:
Acquiring a plurality of tables to be associated;
according to the sequence of acquiring the multiple tables to be associated, determining the last acquired table to be associated as a first table to be associated, and determining other tables to be associated as a second table to be associated;
Acquiring a first field to be matched contained in the first table to be associated and a plurality of second fields to be matched contained in the second table to be associated; the first field to be matched comprises at least one of a first ID identifier, a first field name and a first field annotation, and the second field to be matched comprises at least one of a second ID identifier, a second field name and a second field annotation;
According to the sequence, sequentially carrying out field name matching on the first field to be matched and a plurality of second fields to be matched in the second association table from back to front; the field name matching comprises at least one of ID identifier matching, field name matching and field annotation matching; the priority of the ID identifier matching is higher than that of the field name matching, and the priority of the field name matching is higher than that of the field annotation matching; the field notes are used for representing the meaning represented by each field;
if the field names are successfully matched, establishing table data corresponding to the first field to be matched and association relation of the table data corresponding to the matched second field to be matched;
if the association relation is successfully established, terminating executing field name matching between the first table to be associated and other second tables to be associated;
According to the sequence, sequentially carrying out field name matching on the first field to be matched and a plurality of second fields to be matched in the second association table from back to front, wherein the field name matching comprises;
S1, based on the sequence, sequentially matching the first ID identifiers with second ID identifiers respectively corresponding to a plurality of second fields to be matched in the second table to be associated from back to front;
S2, in the matching process, if the first ID identifier is matched with a second ID identifier corresponding to any second field to be matched, establishing an association relationship between table data corresponding to the first ID identifier and table data corresponding to the second ID identifier, and ending the matching process;
And S3, if the first ID identifier is not matched with a second ID identifier corresponding to any second field to be matched, repeating the matching steps of S1 and S2 by sequentially using the first field name, the second field name, the first field annotation and the second field annotation until the matching process of the first field to be matched of the first table to be correlated with the plurality of second fields to be matched of the second table to be correlated is finished.
2. The method of correlating table data according to claim 1, wherein the terminal device further includes a paraphrasing analysis model;
in performing the matching of the first field annotation and the second field annotation, the method further comprises:
Respectively inputting the first field annotation and second field annotations corresponding to the plurality of second fields to be matched into a paraphrase analysis model to obtain the matching degree of the first field annotation and each second field annotation;
if the matching degree of the maximum value is greater than or equal to the preset matching degree in the plurality of matching degrees, establishing an association relationship between the first field annotated table data and the second field annotated table data corresponding to the matching degree of the maximum value.
3. The method for associating table data according to claim 1 or 2, wherein the terminal device includes a visual operation interface;
If the field names are successfully matched, establishing table data corresponding to the first field to be matched, and after the association relation between the table data corresponding to the matched second field to be matched and the table data corresponding to the second field to be matched;
Displaying the association relation in the visual operation interface;
And operating the association relation according to an input instruction of a user in the visual operation interface, wherein the operation comprises any one of deleting, adjusting and adding the association relation.
4. The method for associating table data according to claim 3, further comprising, after establishing the table data corresponding to the first field to be matched and the association relationship with the table data corresponding to the second field to be matched if the field names are successfully matched:
determining a target to-be-associated table for data query;
Based on the association relation, determining a target matching field with the association relation established in the target to-be-associated table, and determining an association matching field with the association relation with the target matching field;
traversing the association relation by taking the association matching field as a target matching field so as to repeatedly execute the association matching field which is determined to have the association relation with the target matching field;
after the traversal of the association relation is finished, the acquired table data corresponding to the target matching fields are displayed in the visual operation interface.
5. The method for associating table data according to claim 4, wherein after the traversing of the association relation is completed, displaying the table data corresponding to each of the obtained plurality of object matching fields in the visual operation interface, further comprises:
Setting any one field of the target matching fields as a main key, setting other target matching fields as external keys, and establishing a main external key relation between the main key and the external keys; the primary foreign key relationship is used for modifying the table data in the target matching field corresponding to the foreign key when the table data in the target matching field corresponding to the primary key is modified.
6. A table data association apparatus, applied to a terminal device, comprising:
the first acquisition module is used for acquiring a plurality of tables to be associated;
The first determining module is used for determining the last acquired table to be associated as a first table to be associated and determining other tables to be associated as second tables to be associated according to the sequence of acquiring the plurality of tables to be associated;
the second acquisition module is used for acquiring a first field to be matched contained in the first table to be associated and a plurality of second fields to be matched contained in the second table to be associated; the first field to be matched comprises at least one of a first ID identifier, a first field name and a first field annotation, and the second field to be matched comprises at least one of a second ID identifier, a second field name and a second field annotation;
The matching module is used for carrying out field name matching on the first field to be matched and a plurality of second fields to be matched in the second association table sequentially from back to front according to the sequence; the field name matching comprises at least one of ID identifier matching, field name matching and field annotation matching; the priority of the ID identifier matching is higher than that of the field name matching, and the priority of the field name matching is higher than that of the field annotation matching; the field notes are used for representing the meaning represented by each field;
the first establishing module is used for establishing the association relation between the table data corresponding to the first field to be matched and the table data corresponding to the matched second field to be matched if the field names are successfully matched;
The termination module is used for terminating and executing field name matching between the first table to be associated and other second tables to be associated if the association relation is successfully established;
The matching module is also used for:
S1, based on the sequence, sequentially matching the first ID identifiers with second ID identifiers respectively corresponding to a plurality of second fields to be matched in the second table to be associated from back to front; s2, in the matching process, if the first ID identifier is matched with a second ID identifier corresponding to any second field to be matched, establishing an association relationship between table data corresponding to the first ID identifier and table data corresponding to the second ID identifier, and ending the matching process; and S3, if the first ID identifier is not matched with a second ID identifier corresponding to any second field to be matched, repeating the matching steps of S1 and S2 by sequentially using the first field name, the second field name, the first field annotation and the second field annotation until the matching process of the first field to be matched of the first table to be correlated with the plurality of second fields to be matched of the second table to be correlated is finished.
7. A terminal device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the method according to any of claims 1 to 5 when executing the computer program.
8. A computer readable storage medium storing a computer program, characterized in that the computer program when executed by a processor implements the method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110651319.0A CN113407536B (en) | 2021-06-10 | 2021-06-10 | Method, device, terminal equipment and medium for associating table data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110651319.0A CN113407536B (en) | 2021-06-10 | 2021-06-10 | Method, device, terminal equipment and medium for associating table data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113407536A CN113407536A (en) | 2021-09-17 |
| CN113407536B true CN113407536B (en) | 2024-05-31 |
Family
ID=77683443
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110651319.0A Active CN113407536B (en) | 2021-06-10 | 2021-06-10 | Method, device, terminal equipment and medium for associating table data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113407536B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113468186B (en) * | 2021-09-02 | 2021-12-21 | 四川大学华西医院 | Data table primary key association method and device, computer equipment and readable storage medium |
| CN115712691A (en) * | 2022-11-17 | 2023-02-24 | 创新奇智(重庆)科技有限公司 | Data relation processing method and system |
| CN116126893B (en) * | 2023-04-17 | 2023-06-27 | 广东粤港澳大湾区国家纳米科技创新研究院 | Data association retrieval method and device and related equipment |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7091959B1 (en) * | 1999-03-31 | 2006-08-15 | Advanced Digital Systems, Inc. | System, computer program product, computing device, and associated methods for form identification and information manipulation |
| CN107220251A (en) * | 2016-03-21 | 2017-09-29 | 阿里巴巴集团控股有限公司 | Generate the method and device of description information |
| WO2020015067A1 (en) * | 2018-07-19 | 2020-01-23 | 平安科技（深圳）有限公司 | Data acquisition method, device, equipment and storage medium |
| CN110795482A (en) * | 2019-10-16 | 2020-02-14 | 浙江大华技术股份有限公司 | Data benchmarking method, device and storage device |
| CN111831624A (en) * | 2020-07-14 | 2020-10-27 | 北京三快在线科技有限公司 | Data table creating method and device, computer equipment and storage medium |
| CN111831629A (en) * | 2019-04-15 | 2020-10-27 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN112115138A (en) * | 2020-08-19 | 2020-12-22 | 第四范式（北京）技术有限公司 | Method, device and equipment for determining association relation between data tables |
| CN112613917A (en) * | 2020-12-30 | 2021-04-06 | 平安壹钱包电子商务有限公司 | Information pushing method, device and equipment based on user portrait and storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111581216A (en) * | 2020-05-09 | 2020-08-25 | 北京百度网讯科技有限公司 | Data processing method, device, equipment and storage medium |
-
2021
- 2021-06-10 CN CN202110651319.0A patent/CN113407536B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7091959B1 (en) * | 1999-03-31 | 2006-08-15 | Advanced Digital Systems, Inc. | System, computer program product, computing device, and associated methods for form identification and information manipulation |
| CN107220251A (en) * | 2016-03-21 | 2017-09-29 | 阿里巴巴集团控股有限公司 | Generate the method and device of description information |
| WO2020015067A1 (en) * | 2018-07-19 | 2020-01-23 | 平安科技（深圳）有限公司 | Data acquisition method, device, equipment and storage medium |
| CN111831629A (en) * | 2019-04-15 | 2020-10-27 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN110795482A (en) * | 2019-10-16 | 2020-02-14 | 浙江大华技术股份有限公司 | Data benchmarking method, device and storage device |
| CN111831624A (en) * | 2020-07-14 | 2020-10-27 | 北京三快在线科技有限公司 | Data table creating method and device, computer equipment and storage medium |
| CN112115138A (en) * | 2020-08-19 | 2020-12-22 | 第四范式（北京）技术有限公司 | Method, device and equipment for determining association relation between data tables |
| CN112613917A (en) * | 2020-12-30 | 2021-04-06 | 平安壹钱包电子商务有限公司 | Information pushing method, device and equipment based on user portrait and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113407536A (en) | 2021-09-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113407536B (en) | Method, device, terminal equipment and medium for associating table data | |
| CN108052577B (en) | Universal text content mining method, device, server and storage medium | |
| WO2021184571A1 (en) | Dynamic form generation method, apparatus, computer device, and storage medium | |
| US20150026556A1 (en) | Systems and Methods for Extracting Table Information from Documents | |
| US10241974B2 (en) | Reformatting multiple paragraphs of text using the formatting of a sample object by creating multiple candidate combinations and selecting a closest match | |
| EP3819808A1 (en) | Text sequence segmentation method and device, and storage medium thereof | |
| CN107491536B (en) | Test question checking method, test question checking device and electronic equipment | |
| CN108733712B (en) | Question-answering system evaluation method and device | |
| CN111723870B (en) | Artificial intelligence-based data set acquisition method, apparatus, device and medium | |
| CN113963770A (en) | Report file generation method and device, computer equipment and storage medium thereof | |
| CN110688111A (en) | Configuration method, device, server and storage medium of business process | |
| CN116467171A (en) | Automatic test case construction device, method, electronic equipment and storage medium | |
| WO2021139242A1 (en) | Presentation file generation method, apparatus, and device and storage medium | |
| CN109871544B (en) | Entity identification method, device, equipment and storage medium based on Chinese medical record | |
| CN114528391A (en) | Method, device and equipment for training question-answer pair scoring model and storage medium | |
| CN113344079B (en) | Image tag semi-automatic labeling method, system, terminal and medium | |
| CN117725895A (en) | Document generation method, device, equipment and medium | |
| CN113050933B (en) | Brain graph data processing method, device, equipment and storage medium | |
| CN115422180A (en) | Data verification method and system | |
| CN111859985B (en) | AI customer service model test method and device, electronic equipment and storage medium | |
| CN114115831A (en) | Data processing method, device, equipment and storage medium | |
| CN112507703B (en) | Medical entity identification method, device, medium and electronic equipment | |
| CN112989823B (en) | Log processing method, device, equipment and storage medium | |
| CN113515423B (en) | Android application behavior characterization construction method based on execution track information | |
| CN108304430B (en) | Method for modifying database |
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 |