CN115757400B - Data table processing method, device, electronic equipment and computer readable medium - Google Patents

Data table processing method, device, electronic equipment and computer readable medium Download PDF

Info

Publication number
CN115757400B
CN115757400B CN202211385946.5A CN202211385946A CN115757400B CN 115757400 B CN115757400 B CN 115757400B CN 202211385946 A CN202211385946 A CN 202211385946A CN 115757400 B CN115757400 B CN 115757400B
Authority
CN
China
Prior art keywords
data table
target
field
tag
association
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
Application number
CN202211385946.5A
Other languages
Chinese (zh)
Other versions
CN115757400A (en
Inventor
齐国栋
陈金华
文洪昌
潘丽超
朱松松
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Siji Location Service Co ltd
State Grid Information and Telecommunication Co Ltd
Beijing Guodiantong Network Technology Co Ltd
Original Assignee
State Grid Information and Telecommunication Co Ltd
Beijing Guodiantong Network Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by State Grid Information and Telecommunication Co Ltd, Beijing Guodiantong Network Technology Co Ltd filed Critical State Grid Information and Telecommunication Co Ltd
Priority to CN202211385946.5A priority Critical patent/CN115757400B/en
Publication of CN115757400A publication Critical patent/CN115757400A/en
Application granted granted Critical
Publication of CN115757400B publication Critical patent/CN115757400B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

Embodiments of the present disclosure disclose a data table processing method, apparatus, electronic device, and computer readable medium. One embodiment of the method comprises the following steps: acquiring a data table set and a data table label information set from a target database; transmitting the data table set to a data table display window; determining each selected tag as a target tag set; generating a target data table set according to the target tag set and the data table set, and displaying the target data table set in a data table display window; in response to detecting a second selection operation on any field included in any one of the set of target data tables, determining a target field association graph from the set of field association graphs, and displaying the target field association graph in the data table display window. This embodiment reduces the time to search the various data tables associated with the tags.

Description

Data table processing method, device, electronic equipment and computer readable medium
Technical Field
Embodiments of the present disclosure relate to the field of computer technology, and in particular, to a data table processing method, apparatus, electronic device, and computer readable medium.
Background
When the data table is managed, the data table association platform can be used for storing the data table information of the data table, and the data table to be searched is inquired through the data table association platform. Currently, when querying a data table stored in a data table association platform, the following methods are generally adopted: and querying the data table by a fuzzy query method.
However, when the data table stored in the data table association platform is queried in the above manner, there are often the following technical problems:
first, when the data table is queried by the fuzzy query method, all the data tables related to the tag cannot be searched according to the tag, so that a long time is required to search each data table related to the tag.
Second, when a modification is made to a field in a data table, it is often necessary to find the field blood-address of the modified field to modify the associated field. When the data table is queried by the fuzzy query method, the associated fields can be modified only after the associated data table is queried, so that the associated fields need to be modified in a long time.
Thirdly, after modifying the fields in the data table, the associated data table association relationship and field association relationship need to be modified. The data table association relationship and the field association relationship associated with the modified field cannot be queried through the fuzzy query method, so that long time is required to search and modify the associated data table association relationship and field association relationship.
Disclosure of Invention
The disclosure is in part intended to introduce concepts in a simplified form that are further described below in the detailed description. The disclosure is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used to limit the scope of the claimed subject matter.
Some embodiments of the present disclosure propose data sheet processing methods, apparatus, electronic devices, computer readable media and computer program products to solve one or more of the technical problems mentioned in the background section above.
In a first aspect, some embodiments of the present disclosure provide a data table processing method, the method including: acquiring a data table set and a data table label information set from a target database, wherein a data table in the data table set corresponds to data table label information in the data table label information set, and the data table label information in the data table label information set comprises at least one data table label; transmitting the data table set to a data table display window, and displaying the data table set by the data table display window; in response to detecting a first selection operation acting on at least one of the individual labels included in the label selection control, determining the selected individual label as a target label set; generating a target data table set according to the target tag set and the data table set, and displaying the target data table set in the data table display window; and in response to detecting a second selection operation on any field included in any target data table in the target data table set, determining a target field association diagram according to the field association diagram set, and displaying the target field association diagram in the data table display window, wherein the target field association diagram is a field association diagram corresponding to the selected field.
In a second aspect, some embodiments of the present disclosure provide a data table processing apparatus, the apparatus comprising: an obtaining unit configured to obtain a data table set and a data table tag information set from a target database, where a data table in the data table set corresponds to data table tag information in the data table tag information set, and the data table tag information in the data table tag information set includes at least one data table tag; a transmitting unit configured to transmit the data table set to a data table display window, so that the data table display window displays the data table set; a first determining unit configured to determine each of the selected tags as a target tag set in response to detection of a first selection operation acting on at least one of the respective tags included in the tag selection control; a generating unit configured to generate a target data table set according to the target tag set and the data table set, and display the target data table set in the data table display window; and a second determining unit configured to determine a target field association diagram according to a field association diagram set in response to detecting a second selection operation acting on any field included in any target data table in the target data table set, and display the target field association diagram in the data table display window, wherein the target field association diagram is a field association diagram corresponding to the selected field.
In a third aspect, some embodiments of the present disclosure provide an electronic device comprising: one or more processors; a storage device having one or more programs stored thereon, which when executed by one or more processors causes the one or more processors to implement the method described in any of the implementations of the first aspect above.
In a fourth aspect, some embodiments of the present disclosure provide a computer readable medium having a computer program stored thereon, wherein the program, when executed by a processor, implements the method described in any of the implementations of the first aspect above.
In a fifth aspect, some embodiments of the present disclosure provide a computer program product comprising a computer program which, when executed by a processor, implements the method described in any of the implementations of the first aspect above.
The above embodiments of the present disclosure have the following advantages: by the data table processing method of some embodiments of the present disclosure, the time for searching each data table related to the tag can be reduced. Specifically, the reason why it takes a long time to search the respective data tables related to the tag is that: when the data table is queried by the fuzzy query method, all the data tables related to the tag cannot be searched according to the tag, so that a long time is required to search each data table related to the tag. Based on this, the data table processing method of some embodiments of the present disclosure first acquires a data table set and a data table tag information set from a target database. Thus, data support is provided for searching the data table. Secondly, the data table set is sent to a data table display window, and the data table display window is used for displaying the data table set; in response to detecting a first selection operation on at least one of the individual labels included in the label selection control, the selected individual label is determined to be the target label set. Thus, the tags of the data table that need to be searched can be determined. Then, a target data table set is generated according to the target tag set and the data table set, and the target data table set is displayed in the data table display window. Thus, each data table related to the tag can be displayed in the data table display window, and thus, the time for searching each data table related to the tag can be reduced. Finally, in response to detecting a second selection operation on any field included in any target data table in the target data table set, determining a target field association diagram according to the field association diagram set, and displaying the target field association diagram in the data table display window. Thus, the respective data tables associated with the selected tags are displayed, reducing the time to search the respective data tables associated with the tags.
Drawings
The above and other features, advantages, and aspects of embodiments of the present disclosure will become more apparent by reference to the following detailed description when taken in conjunction with the accompanying drawings. The same or similar reference numbers will be used throughout the drawings to refer to the same or like elements. It should be understood that the figures are schematic and that elements and components are not necessarily drawn to scale.
FIG. 1 is a flow chart of some embodiments of a data table processing method according to the present disclosure;
FIG. 2 is a schematic diagram of the structure of some embodiments of a data table processing apparatus according to the present disclosure;
fig. 3 is a schematic structural diagram of an electronic device suitable for use in implementing some embodiments of the present disclosure.
Detailed Description
Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While certain embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete. It should be understood that the drawings and embodiments of the present disclosure are for illustration purposes only and are not intended to limit the scope of the present disclosure.
It should be noted that, for convenience of description, only the portions related to the present invention are shown in the drawings. Embodiments of the present disclosure and features of embodiments may be combined with each other without conflict.
It should be noted that the terms "first," "second," and the like in this disclosure are merely used to distinguish between different devices, modules, or units and are not used to define an order or interdependence of functions performed by the devices, modules, or units.
It should be noted that references to "one", "a plurality" and "a plurality" in this disclosure are intended to be illustrative rather than limiting, and those of ordinary skill in the art will appreciate that "one or more" is intended to be understood as "one or more" unless the context clearly indicates otherwise.
The names of messages or information interacted between the various devices in the embodiments of the present disclosure are for illustrative purposes only and are not intended to limit the scope of such messages or information.
The present disclosure will be described in detail below with reference to the accompanying drawings in conjunction with embodiments.
FIG. 1 illustrates a flow 100 of some embodiments of a data table processing method according to the present disclosure. The data table processing method comprises the following steps:
Step 101, acquiring a data table set and a data table label information set from a target database.
In some embodiments, the execution subject (e.g., server) of the data table processing method may obtain the data table set and the data table tag information set from the target database by means of a wired connection or a wireless connection. Wherein, the data table in the data table set corresponds to the data table label information in the data table label information set. The data table label information in the data table label information set comprises at least one data table label. The target database may be a database storing a set of data tables and a set of data table tag information. The data table label information in the data table label information set may be label information of a predetermined data table. The data table label may be a label that is preset to characterize the type of the data table. For example, the data table label may be "infrastructure control", and the type of the data table may be "infrastructure control" in response to a certain data table corresponding to the "infrastructure control" label. The data table in the data table set may be a pre-stored service data table. The data table of the data table set includes at least one field. The field of the at least one field may be a data field.
Step 102, the data table set is sent to a data table display window, so that the data table display window displays the data table set.
In some embodiments, the executing entity may send the data table set to a data table display window, so that the data table display window displays the data table set. The data table display window may be a window for displaying at least one data table in the data table set.
In response to detecting a first selection operation on at least one of the individual labels included in the label selection control, the selected individual label is determined to be the target label set, step 103.
In some embodiments, the executing entity may determine each of the labels included in the label selection control as the target label set in response to detecting a first selection operation on at least one of the labels. The label selection control may be a control for characterizing a selection label. The tag in each tag may be a pre-stored data table tag. The tab selection control is displayed in a tab selection interface. The label selection interface may be an interface for displaying a pre-stored data table label. The first selection operation may be an operation of selecting at least one tab from the tab selection interface and selecting a tab selection control. The first selection operation may include, but is not limited to, a click operation, a slide operation, a hover operation.
And 104, generating a target data table set according to the target tag set and the data table set, and displaying the target data table set in a data table display window.
In some embodiments, the execution body may generate a target data table set according to the target tag set and the data table set, and display the target data table set in the data table display window.
In practice, the executing entity may generate a target data table set by the following steps, and display the target data table set in the data table display window:
first, for each data table in the data table set, determining the data table as a tag data table in response to that each data table tag included in the data table tag information corresponding to the data table includes each data table tag identical to each target tag in the target tag set. As an example, in response to the data table tag information corresponding to the data table T1 being "a, B, C, D", the target tag set is "B, C", the data table T1 may be determined as a tag data table.
And a second step of determining each of the determined tag data tables as a tag data table set.
And thirdly, responding to the detection of the input operation acting on the keyword input window and the detection of the third selection operation acting on the search confirmation control, and reading at least one input keyword in the keyword input window as an input keyword set. The input operation may be an operation of inputting a keyword in the keyword input window. The keyword input window may be a window for inputting keywords. The search confirmation control may be a control for confirming a keyword of a search, which is displayed in the keyword input window. The third selection operation may be an operation of selecting the search confirmation control. The third selection operation may include, but is not limited to, a click operation, a slide operation, a hover operation.
Fourth, for each tag data table in the tag data table set, the following searching step is performed:
and a first searching step, performing fuzzy search on the tag data table according to each input keyword in the input keyword set to generate fuzzy search results. In practice, the execution body may perform fuzzy search on each input keyword in the input keyword set from the tag data table by using various methods to generate fuzzy search results. For example, a wild card may be used to perform a fuzzy search for each input keyword in the set of input keywords from the tag data table. Wherein the fuzzy search result may characterize that each of the input keywords in the set of input keywords is included or not included in the tag data table.
And a second searching step of determining the tag data table as a target data table in response to the fuzzy search result satisfying a preset search result condition. The preset search result condition may be that the fuzzy search result represents each input keyword in the tag data table, where the input keyword set includes the input keywords.
And fifthly, determining each determined target data table as a target data table set.
Optionally, before the sixth step, the tag data table set is determined as a target data table set in response to not detecting an input operation acting on the keyword input window and detecting a third selection operation acting on a search confirmation control.
And sixthly, displaying the target data table set in the data table display window.
In response to detecting a second selection operation on any field included in any one of the set of target data tables, determining a target field association diagram from the set of field association diagrams, and displaying the target field association diagram in a data table display window, step 105.
In some embodiments, the executing entity may determine a target field association diagram according to the field association diagram set in response to detecting a second selection operation on any field included in any target data table in the target data table set, and display the target field association diagram in the data table display window. The target field association diagram is a field association diagram corresponding to the selected field. In practice, a field association diagram including the same root node field as the selected field described above may be determined as the target field association diagram. The second selecting operation may be an operation of selecting any field included in any one of the target data tables. The second selection operation may include, but is not limited to, a click operation, a slide operation, a hover operation. The field association diagrams in the field association diagram set can represent the association diagrams of the association relations among the fields. The field association diagram may include a root node field and at least one child node field.
In practice, the execution subject may determine a target field association diagram by the following steps, and display the target field association diagram in the data table display window:
in response to detecting a second selection operation on any field included in any one of the target data tables in the target data table set, selecting a field association diagram including the same root node field as the selected field from the field association diagram set as a target field association diagram.
And a second step of displaying the target field association diagram on a field association information display window in the data table display window. The field association information display window may be a window for displaying a field association diagram in a data table display window.
Optionally, the field association diagram may be obtained by:
first, a data table information set and a data table configuration information set are acquired.
In some embodiments, the executing entity may obtain the set of data table information and the set of data table configuration information. Wherein the data table information in the data table information set corresponds to the data table configuration information in the data table configuration information set. The data table configuration information in the data table configuration information set may include, but is not limited to: the field association information set may include at least two fields. The data table information in the data table information set may include a data table name. The data table name may be a name of a certain data table stored in advance. The field association information in the field association information set may represent an association relationship between certain two fields.
And secondly, carrying out field extraction processing on field association information in each field association information set corresponding to each data table information in the data table information set to generate each extracted field which is extracted as an extracted field set.
In some embodiments, the execution body may perform a field extraction process on field association information in each field association information set corresponding to each data table information in the data table information set, so as to generate each extracted field extracted as the extracted field set. The field extraction process may be an extraction process of a field included in the field association modification information.
And thirdly, performing de-duplication treatment on each extracted field in the extracted field set to generate a de-duplication field set.
In some embodiments, the execution body may perform a deduplication process on each extraction field in the set of extraction fields to generate a set of deduplication fields.
Fourth, performing de-duplication processing on each field association information in each field association information set included in the data table configuration information set, so as to generate each field association information after de-duplication as a de-duplication field association information set.
In some embodiments, the executing body may perform deduplication processing on each field association information in each field association information set included in the data table configuration information set, so as to generate each field association information after deduplication as a deduplication field association information set.
And fifthly, generating a field association diagram set according to the de-duplication field set and the de-duplication field association information set.
In some embodiments, the execution body may generate a field association atlas from the deduplication field set and the deduplication field association information set.
In practice, the execution body may generate a field association atlas from the set of deduplication fields and the set of deduplication field association information by:
a first sub-step of, for each of the above-mentioned set of deduplication fields, performing the following generation step:
and a first generation step of determining the de-duplication field as a root node field.
And a second generation step of determining, for each piece of the duplication elimination field association information in the duplication elimination field association information set, a field different from the root node field among the respective fields included in the duplication elimination field association information as a child node field in response to the duplication elimination field association information including the same field as the root node field.
And a third generation step of generating a field association diagram according to the determined sub-node fields and the root node fields.
And a second sub-step of determining each generated field association graph as a field association graph set.
The related matters in the first step to the fifth step are taken as an invention point of the present disclosure, and the second technical problem mentioned in the background art is solved, and when the field in the data table is modified, the field blood edges of the modified field are generally required to be searched to modify the associated field. When the data table is queried by the fuzzy query method, the associated fields can be modified only after the associated data table is queried, so that the associated fields need to be modified in a long time. Factors that cause the associated fields to take longer to modify tend to be as follows: when modifying a field in a data table, it is often necessary to find the field blood-address of the modified field to modify the associated field. When the data table is queried by the fuzzy query method, the associated fields can be modified only after the associated data table is queried, so that the associated fields need to be modified in a long time. If the above factors are addressed, the effect of reducing the time to modify the associated field can be achieved. To achieve this, first, a data table information set and a data table configuration information set are acquired. Thus, data support may be provided for generating field association graphs. Secondly, field extraction processing is carried out on field association information in each field association information set corresponding to each data table information in the data table information set, so that each extracted field is generated as an extracted field set. Thus, the respective fields in which the association relationship exists can be determined. Then, performing de-duplication treatment on each extracted field in the extracted field set to generate a de-duplication field set; and performing de-duplication processing on each field association information in each field association information set included in the data table configuration information set to generate each field association information after de-duplication as a de-duplication field association information set. Thus, the repeated fields and the field association information can be removed, and generation of the repeated field association map can be prevented. And finally, generating a field association graph set according to the de-duplication field set and the de-duplication field association information set. Thereby, a field association atlas is generated. Thus, the associated field of the modified field can be quickly determined through the field association diagram, reducing the time to modify the associated field.
Optionally, in response to detecting a fourth selection operation acting on the data table association information in any one of the data tables in the data table set, a data table association graph including the root node data table name identical to the data table name included in the data table information corresponding to the selected data table is selected from the data table association graph as the target data table association graph.
In some embodiments, the executing body may select, as the target data table association graph, a data table association graph including a root node data table name identical to a data table name included in the data table information corresponding to the selected data table from the data table association graph in response to detecting the fourth selection operation acting on the data table association information in any one of the data tables. The fourth selection operation may be an operation of selecting data table association information in any one of the data tables in the data table set. The fourth selection operation described above may include, but is not limited to, a click operation, a slide operation, a hover operation.
Optionally, the target data table association diagram is displayed in a data table association information window in the data table display window.
In some embodiments, the execution body may display the target data table association diagram in a data table association information window in the data table display window. The data table association information window may be a window for displaying a data packet association map.
Optionally, in response to receiving the field association modification information, performing a field extraction process on the field association modification information to generate a modified field set.
In some embodiments, the execution body may perform a field extraction process on the field association modification information to generate a modified field set in response to receiving the field association modification information. The field association modification information may be information for adding or deleting an association relationship between any two fields. The field association modification information may characterize one of the following: field association addition information and field association deletion information. The above-described field association adding information may be information for adding an association relationship between any two fields. The above-described field association deletion information may be information for deleting an association relationship between any two fields. For example, the above-mentioned field association modification information may be "add the association relationship of the field a and the field B", where the above-mentioned field association modification information may characterize the field association addition information. As an example, the above-described execution subject may perform field extraction processing on the field association modification information "add association relationship of field a and field B" of the illustrated example to generate a modified field set "[ field a, field B ]".
Optionally, for each modification field in the modification field set described above, the following processing steps are performed:
and a first processing step of selecting a field association diagram corresponding to the modified field from the field association diagram set as a field association diagram to be modified.
In some embodiments, the execution body may select a field association diagram corresponding to the modification field from the field association diagram set as a field association diagram to be modified. In practice, the execution body may select, from the field association atlas, a field association atlas including the same root node field as the modification field as a field association atlas to be modified.
And a second processing step of updating the field association diagram to be modified according to the field association modification information so as to generate an updated field association diagram.
In some embodiments, the execution body may update the field association diagram to be modified according to the field association modification information, so as to generate an updated field association diagram. In practice, first, in response to the field association modification information characterizing field association addition information, a modification field different from the modification field in the modification field set is determined as a child node field, and the child node field is added to the field association graph to be modified, so as to generate an updated field association graph. Secondly, responding to the field association modification information to represent a field association deletion field, determining modification fields which are different from the modification fields in the modification field set as fields to be deleted, and deleting the fields to be deleted in the field association graph to be modified so as to generate an updated field association graph.
And a third processing step of replacing the field association diagram corresponding to the field association diagram to be modified in the field association diagram set with the updated field association diagram to generate a replaced field association diagram set.
In some embodiments, the execution body may replace a field association diagram corresponding to the field association diagram to be modified in the field association diagram set with the updated field association diagram to generate a replaced field association diagram set.
And a fourth processing step of selecting at least one data table association diagram corresponding to the modification field from the data table association diagram set as a data table association diagram set to be modified.
In some embodiments, the execution body may select at least one data table association diagram corresponding to the modification field from the data table association diagram set as the data table association diagram set to be modified. In practice, first, at least one data table including the above-mentioned modification field may be selected from the data table set as the data table set to be selected. Secondly, for each data table to be selected in the data table set to be selected, in response to the modification field existing in the data table to be selected, selecting a data table association graph with the same name of the root node data table as the data table association graph to be modified from the data table association graph set. Thirdly, determining the selected data table association graphs to be modified as a data table association graph set to be modified.
And a fifth processing step of updating each data table association diagram to be modified in the data table association diagram set to be modified according to the field association modification information so as to generate an updated data table association diagram set.
In some embodiments, the executing body may update each of the to-be-modified data table association graphs in the to-be-modified data table association graph set according to the field association modification information, so as to generate an updated data table association graph set. In practice, first, in response to the field association modification information characterizing field association addition information, a modification field in the modification field set, which is different from the modification field, is determined as a child node field, and a data table name of each data table in the data table set, which includes the child node field, is determined as a child node data table, so as to obtain a child node data table set. Second, for each data table association graph to be modified in the data table association graph set to be modified, adding the data table names of the sub-node data tables in the sub-node data table set to the data table association graph to be modified to generate an updated data table association graph. Thirdly, in response to the field association modification information characterizing field association deletion information, determining modification fields different from the modification fields in the modification field set as fields to be deleted, and determining a data table name of each data table including the fields to be deleted in the data table set as a data table to be deleted, thereby obtaining a data table set to be deleted. Fourth, for each data table association diagram to be modified in the data table association diagram set to be modified, deleting the data table names of the data tables to be deleted included in the data table association diagram to be modified, so as to generate an updated data table association diagram.
And a sixth processing step of replacing each data table association diagram of the data table association diagram set corresponding to each data table association diagram to be modified in the data table association diagram set to each updated data table association diagram in the updated data table association diagram set so as to generate a replaced data table association diagram set.
In some embodiments, the executing entity may replace each data table association diagram of the data table association diagram set corresponding to each data table association diagram to be modified in the data table association diagram set with each updated data table association diagram of the updated data table association diagram set to generate a replaced data table association diagram set.
The above optional related content is taken as an invention point of the present disclosure, which solves the third technical problem mentioned in the background art, that the associated data table association relationship and field association relationship need to be modified after the fields in the data table are modified. The data table association and the field association associated with the modified field cannot be queried through the fuzzy query method, so that the associated data table association and field association need to be searched and modified in a long time. Factors that cause the need to take a long time to find and modify the associated data table associations and field associations are often as follows: after modifying the fields in the data table, the associated data table association relationship and field association relationship need to be modified. The data table association relationship and the field association relationship associated with the modified field cannot be queried through the fuzzy query method, so that long time is required to search and modify the associated data table association relationship and field association relationship. If the above factors are solved, the effect of reducing the time for modifying the associated data table association and field association can be achieved. To achieve this effect, first, in response to receiving the field association modification information, the above-described field association modification information is subjected to field extraction processing to generate a modified field set. Thus, the fields that need to be modified can be determined. Next, for each modification field in the modification field set described above, the following processing steps are performed: first, a field association diagram corresponding to the modification field is selected from the field association diagram set as a field association diagram to be modified. Thus, a field association diagram that needs to be modified can be determined. And secondly, updating the field association diagram to be modified according to the field association modification information so as to generate an updated field association diagram. Therefore, the field association relation associated with the modified field can be modified through modifying the field association diagram, and the time for modifying the associated field association relation is reduced. Then, the field association diagram corresponding to the field association diagram to be modified in the field association diagram set is replaced with the updated field association diagram to generate a replaced field association diagram set. Thus, the field association atlas after the field is modified can be updated. And then, selecting at least one data table association diagram corresponding to the modification field from the data table association diagram set as the data table association diagram set to be modified. Thus, the data table association diagram that needs to be modified can be determined. And then, updating each data table association diagram to be modified in the data table association diagram set to be modified according to the field association modification information so as to generate an updated data table association diagram set. Therefore, the data table association relation associated with the modified field can be modified through modifying the data table association diagram, and the time for modifying the associated data table association relation is reduced. And finally, replacing each data table association diagram of the data table association diagram set corresponding to each data table association diagram to be modified in the data table association diagram set to each updated data table association diagram in the updated data table association diagram set so as to generate a replaced data table association diagram set. Therefore, the associated data table association relationship and field association relationship are modified, and the time for modifying the associated data table association relationship and field association relationship is reduced.
The above embodiments of the present disclosure have the following advantages: by the data table processing method of some embodiments of the present disclosure, the time for searching each data table related to the tag can be reduced. Specifically, the reason why it takes a long time to search the respective data tables related to the tag is that: when the data table is queried by the fuzzy query method, all the data tables related to the tag cannot be searched according to the tag, so that a long time is required to search each data table related to the tag. Based on this, the data table processing method of some embodiments of the present disclosure first acquires a data table set and a data table tag information set from a target database. Thus, data support is provided for searching the data table. Secondly, the data table set is sent to a data table display window, and the data table display window is used for displaying the data table set; in response to detecting a first selection operation on at least one of the individual labels included in the label selection control, the selected individual label is determined to be the target label set. Thus, the tags of the data table that need to be searched can be determined. Then, a target data table set is generated according to the target tag set and the data table set, and the target data table set is displayed in the data table display window. Thus, each data table related to the tag can be displayed in the data table display window, and thus, the time for searching each data table related to the tag can be reduced. Finally, in response to detecting a second selection operation on any field included in any target data table in the target data table set, determining a target field association diagram according to the field association diagram set, and displaying the target field association diagram in the data table display window. Thus, the respective data tables associated with the selected tags are displayed, reducing the time to search the respective data tables associated with the tags.
With further reference to fig. 2, as an implementation of the method shown in the above figures, the present disclosure provides some embodiments of a data table processing apparatus, which correspond to those method embodiments shown in fig. 1, and which are particularly applicable in various electronic devices.
As shown in fig. 2, the data table processing apparatus 200 of some embodiments includes: an acquisition unit 201, a transmission unit 202, a first determination unit 203, a generation unit 204, and a second determination unit 205. Wherein the obtaining unit 201 is configured to obtain a data table set and a data table tag information set from the target database, where a data table in the data table set corresponds to data table tag information in the data table tag information set, and the data table tag information in the data table tag information set includes at least one data table tag; the transmitting unit 202 is configured to transmit the data table set to a data table display window, so that the data table display window displays the data table set; the first determining unit 203 is configured to determine, in response to detecting a first selection operation acting on at least one of the respective labels included in the label selection control, the selected respective labels as a target label set; the generating unit 204 is configured to generate a target data table set according to the target tag set and the data table set, and display the target data table set in the data table display window; the second determining unit 205 is configured to determine, in response to detecting a second selection operation acting on any field included in any target data table in the target data table set, a target field association diagram according to a field association diagram set, and display the target field association diagram in the data table display window, where the target field association diagram is a field association diagram corresponding to the selected field.
It will be appreciated that the elements described in the data sheet processing apparatus 200 correspond to the various steps in the method described with reference to fig. 1. Thus, the operations, features and advantages described above for the method are equally applicable to the data table processing device 200 and the units contained therein, and are not described herein.
Referring now to fig. 3, a schematic diagram of an electronic device 300 suitable for use in implementing some embodiments of the present disclosure is shown. The electronic devices in some embodiments of the present disclosure may include, but are not limited to, mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), car terminals (e.g., car navigation terminals), and the like, as well as stationary terminals such as digital TVs, desktop computers, and the like. The electronic device shown in fig. 3 is merely an example and should not impose any limitations on the functionality and scope of use of embodiments of the present disclosure.
As shown in fig. 3, the electronic device 300 may include a processing means (e.g., a central processing unit, a graphics processor, etc.) 301 that may perform various suitable actions and processes in accordance with a program stored in a Read Only Memory (ROM) 302 or a program loaded from a storage means 308 into a Random Access Memory (RAM) 303. In the RAM303, various programs and data required for the operation of the electronic apparatus 300 are also stored. The processing device 301, the ROM 302, and the RAM303 are connected to each other via a bus 304. An input/output (I/O) interface 305 is also connected to bus 304.
In general, the following devices may be connected to the I/O interface 305: input devices 306 including, for example, a touch screen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; an output device 307 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; and communication means 309. The communication means 309 may allow the electronic device 300 to communicate with other devices wirelessly or by wire to exchange data. While fig. 3 shows an electronic device 300 having various means, it is to be understood that not all of the illustrated means are required to be implemented or provided. More or fewer devices may be implemented or provided instead. Each block shown in fig. 3 may represent one device or a plurality of devices as needed.
In particular, according to some embodiments of the present disclosure, the processes described above with reference to flowcharts may be implemented as computer software programs. For example, some embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method shown in the flow chart. In such embodiments, the computer program may be downloaded and installed from a network via communications device 309, or from storage device 308, or from ROM 302. The above-described functions defined in the methods of some embodiments of the present disclosure are performed when the computer program is executed by the processing means 301.
It should be noted that, the computer readable medium described in some embodiments of the present disclosure may be a computer readable signal medium or a computer readable storage medium, or any combination of the two. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples of the computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In some embodiments of the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In some embodiments of the present disclosure, however, the computer-readable signal medium may comprise a data signal propagated in baseband or as part of a carrier wave, with the computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, fiber optic cables, RF (radio frequency), and the like, or any suitable combination of the foregoing.
In some implementations, the clients, servers may communicate using any currently known or future developed network protocol, such as HTTP (HyperText Transfer Protocol ), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), the internet (e.g., the internet), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future developed networks.
The computer readable medium may be contained in the electronic device; or may exist alone without being incorporated into the electronic device. The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: and acquiring a data table set and a data table label information set from the target database, wherein the data table in the data table set corresponds to the data table label information in the data table label information set, and the data table label information in the data table label information set comprises at least one data table label. And sending the data table set to a data table display window, and displaying the data table set by the data table display window. In response to detecting a first selection operation on at least one of the individual labels included in the label selection control, the selected individual label is determined to be the target label set. And generating a target data table set according to the target tag set and the data table set, and displaying the target data table set in the data table display window. And in response to detecting a second selection operation on any field included in any target data table in the target data table set, determining a target field association diagram according to the field association diagram set, and displaying the target field association diagram in the data table display window, wherein the target field association diagram is a field association diagram corresponding to the selected field.
Computer program code for carrying out operations for some embodiments of the present disclosure may be written in one or more programming languages, including an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).
The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in some embodiments of the present disclosure may be implemented by means of software, or may be implemented by means of hardware. The described units may also be provided in a processor, for example, described as: a processor includes an acquisition unit, a transmission unit, a first determination unit, a generation unit, and a second determination unit. The names of these units do not limit the unit itself in some cases, and the acquisition unit may also be described as "a unit that acquires a data table set and a data table tag information set from a target database", for example.
The functions described above herein may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: a Field Programmable Gate Array (FPGA), an Application Specific Integrated Circuit (ASIC), an Application Specific Standard Product (ASSP), a system on a chip (SOC), a Complex Programmable Logic Device (CPLD), and the like.
Some embodiments of the present disclosure also provide a computer program product comprising a computer program which, when executed by a processor, implements any of the data table processing methods described above.
The foregoing description is only of the preferred embodiments of the present disclosure and description of the principles of the technology being employed. It will be appreciated by those skilled in the art that the scope of the invention in the embodiments of the present disclosure is not limited to the specific combination of the above technical features, but encompasses other technical features formed by any combination of the above technical features or their equivalents without departing from the spirit of the invention. Such as the above-described features, are mutually substituted with (but not limited to) the features having similar functions disclosed in the embodiments of the present disclosure.

Claims (8)

1. A data table processing method, comprising:
acquiring a data table set and a data table label information set from a target database, wherein a data table in the data table set corresponds to data table label information in the data table label information set, and the data table label information in the data table label information set comprises at least one data table label;
transmitting the data table set to a data table display window so that the data table display window can display the data table set;
in response to detecting a first selection operation acting on at least one of the individual labels included in the label selection control, determining the selected at least one label as a target label set;
Generating a target data table set according to the target tag set and the data table set, and displaying the target data table set in the data table display window;
in response to detecting a second selection operation acting on any field included in any target data table in the target data table set, determining a target field association diagram according to a field association diagram set, and displaying the target field association diagram in the data table display window, wherein the target field association diagram is a field association diagram corresponding to the selected field.
2. The method of claim 1, wherein the generating a target data table set from the target tag set and the data table set and displaying the target data table set in the data table display window comprises:
for each data table in the data table set, determining the data table as a tag data table in response to the fact that each data table tag included in the data table tag information corresponding to the data table includes each data table tag identical to each target tag in the target tag set;
Determining each of the determined tag data tables as a set of tag data tables;
in response to detecting an input operation acting on a keyword input window and detecting a third selection operation acting on a search confirmation control, reading at least one input keyword in the keyword input window as an input keyword set;
for each tag data table in the set of tag data tables, performing the following searching steps:
performing fuzzy search on the tag data table according to each input keyword in the input keyword set to generate fuzzy search results;
determining the tag data table as a target data table in response to the fuzzy search result meeting a preset search result condition;
determining each determined target data table as a target data table set;
and displaying the target data table set in the data table display window.
3. The method of claim 2, wherein prior to said displaying the set of target data tables in the data table display window, the method further comprises:
in response to not detecting an input operation on the keyword input window, and detecting a third selection operation on a search confirmation control, determining the set of tag data tables as a set of target data tables.
4. The method of claim 1, wherein the determining a target field association graph from a field association graph set in response to detecting a second selection operation on any field included in any target data table in the set of target data tables, and displaying the target field association graph in the data table display window comprises:
in response to detecting a second selection operation acting on any field included in any target data table in the target data table set, selecting a field association diagram including a root node field identical to the selected field from the field association diagram set as a target field association diagram;
and displaying the target field association diagram in a field association information display window in the data table display window.
5. The method of claim 1, wherein the method further comprises:
in response to detecting a fourth selection operation acting on data table association information in any one of the data table sets, selecting, as a target data table association graph, a data table association graph including the same root node data table name as the data table name included in the data table information corresponding to the selected data table from the data table association graph;
And displaying the target data table association diagram in a data table association information window in the data table display window.
6. A data table processing apparatus comprising:
an obtaining unit configured to obtain a data table set and a data table tag information set from a target database, wherein a data table in the data table set corresponds to data table tag information in the data table tag information set, and the data table tag information in the data table tag information set includes at least one data table tag;
a sending unit configured to send the data table set to a data table display window, so that the data table display window displays the data table set;
a first determination unit configured to determine at least one of the individual labels included in the label selection control as a target label set in response to detection of a first selection operation acting on the selected at least one label;
a generating unit configured to generate a target data table set according to the target tag set and the data table set, and display the target data table set in the data table display window;
And a second determining unit configured to determine a target field association diagram according to a field association diagram set in response to detection of a second selection operation acting on any field included in any target data table in the target data table set, and display the target field association diagram in the data table display window, wherein the target field association diagram is a field association diagram corresponding to the selected field.
7. An electronic device, comprising:
one or more processors;
a storage device having one or more programs stored thereon;
when executed by the one or more processors, causes the one or more processors to implement the method of any of claims 1 to 5.
8. A computer readable medium having stored thereon a computer program, wherein the program when executed by a processor implements the method of any of claims 1 to 5.
CN202211385946.5A 2022-11-07 2022-11-07 Data table processing method, device, electronic equipment and computer readable medium Active CN115757400B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211385946.5A CN115757400B (en) 2022-11-07 2022-11-07 Data table processing method, device, electronic equipment and computer readable medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211385946.5A CN115757400B (en) 2022-11-07 2022-11-07 Data table processing method, device, electronic equipment and computer readable medium

Publications (2)

Publication Number Publication Date
CN115757400A CN115757400A (en) 2023-03-07
CN115757400B true CN115757400B (en) 2023-06-13

Family

ID=85357041

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211385946.5A Active CN115757400B (en) 2022-11-07 2022-11-07 Data table processing method, device, electronic equipment and computer readable medium

Country Status (1)

Country Link
CN (1) CN115757400B (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117290561B (en) * 2023-11-27 2024-03-29 北京衡石科技有限公司 Service state information feedback method, device, equipment and computer readable medium
CN117370361B (en) * 2023-12-08 2024-03-08 朴道征信有限公司 Data table operation method, device, electronic equipment and computer readable medium
CN117608500B (en) * 2024-01-23 2024-03-29 四川省华存智谷科技有限责任公司 Method for rescuing effective data of storage system when data redundancy is insufficient

Citations (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107665228A (en) * 2017-05-10 2018-02-06 平安科技(深圳)有限公司 A kind of related information querying method, terminal and equipment
CN109933311A (en) * 2019-03-20 2019-06-25 青岛叁壹信息科技有限公司 A kind of information system creation method and relevant apparatus
CN110008232A (en) * 2019-04-11 2019-07-12 北京启迪区块链科技发展有限公司 Generation method, device, server and the medium of structured query sentence
CN110609954A (en) * 2019-08-30 2019-12-24 深圳壹账通智能科技有限公司 Data acquisition method and device, computer equipment and storage medium
CN110928928A (en) * 2019-12-09 2020-03-27 中国建设银行股份有限公司 Data statistics method and device for investment subject, electronic equipment and storage medium
CN111414410A (en) * 2019-01-07 2020-07-14 阿里巴巴集团控股有限公司 Data processing method, device, equipment and storage medium
CN113946721A (en) * 2021-09-26 2022-01-18 北京锐安科技有限公司 Data query method, device, equipment and storage medium
CN114003843A (en) * 2021-11-01 2022-02-01 上海浦东发展银行股份有限公司 Page generation method, device, equipment and storage medium
CN114020772A (en) * 2021-11-15 2022-02-08 北京嘉和美康信息技术有限公司 Query condition configuration method, system, electronic device and storage medium
CN114117199A (en) * 2021-10-21 2022-03-01 网易(杭州)网络有限公司 Data processing method, data processing apparatus, storage medium, and electronic apparatus
CN114637780A (en) * 2022-03-22 2022-06-17 深圳壹账通智能科技有限公司 Data query processing method and device, computer equipment and medium
CN114997126A (en) * 2022-06-07 2022-09-02 北京五八信息技术有限公司 Electronic form display method and device, electronic equipment and storage medium
CN115168352A (en) * 2022-07-07 2022-10-11 深圳市布博卡科技有限公司 Data association method, terminal and storage medium

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20040135811A1 (en) * 2003-01-14 2004-07-15 Craig Pickering Method and system for displaying data fields
US20050021538A1 (en) * 2003-07-25 2005-01-27 Activeviews, Inc. Method and system for displaying a relational abstraction of a data store

Patent Citations (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107665228A (en) * 2017-05-10 2018-02-06 平安科技(深圳)有限公司 A kind of related information querying method, terminal and equipment
CN111414410A (en) * 2019-01-07 2020-07-14 阿里巴巴集团控股有限公司 Data processing method, device, equipment and storage medium
CN109933311A (en) * 2019-03-20 2019-06-25 青岛叁壹信息科技有限公司 A kind of information system creation method and relevant apparatus
CN110008232A (en) * 2019-04-11 2019-07-12 北京启迪区块链科技发展有限公司 Generation method, device, server and the medium of structured query sentence
CN110609954A (en) * 2019-08-30 2019-12-24 深圳壹账通智能科技有限公司 Data acquisition method and device, computer equipment and storage medium
CN110928928A (en) * 2019-12-09 2020-03-27 中国建设银行股份有限公司 Data statistics method and device for investment subject, electronic equipment and storage medium
CN113946721A (en) * 2021-09-26 2022-01-18 北京锐安科技有限公司 Data query method, device, equipment and storage medium
CN114117199A (en) * 2021-10-21 2022-03-01 网易(杭州)网络有限公司 Data processing method, data processing apparatus, storage medium, and electronic apparatus
CN114003843A (en) * 2021-11-01 2022-02-01 上海浦东发展银行股份有限公司 Page generation method, device, equipment and storage medium
CN114020772A (en) * 2021-11-15 2022-02-08 北京嘉和美康信息技术有限公司 Query condition configuration method, system, electronic device and storage medium
CN114637780A (en) * 2022-03-22 2022-06-17 深圳壹账通智能科技有限公司 Data query processing method and device, computer equipment and medium
CN114997126A (en) * 2022-06-07 2022-09-02 北京五八信息技术有限公司 Electronic form display method and device, electronic equipment and storage medium
CN115168352A (en) * 2022-07-07 2022-10-11 深圳市布博卡科技有限公司 Data association method, terminal and storage medium

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
于Yii2框架的智慧校园后端服务器软件实现;康彦博;中国优秀硕士学位论文全文数据库信息科技辑(第06期);I137-82 *
基于异构集成的元数据及其多表动态查询算法;李润洲;方明;;计算机工程;第33卷(第17期);117-119 *
面向多源异构大数据的元数据服务管理平台的设计与实现;谭泽华;中国优秀硕士学位论文全文数据库信息科技辑(第01期);I138-829 *

Also Published As

Publication number Publication date
CN115757400A (en) 2023-03-07

Similar Documents

Publication Publication Date Title
CN115757400B (en) Data table processing method, device, electronic equipment and computer readable medium
CN111400625B (en) Page processing method and device, electronic equipment and computer readable storage medium
CN111857720B (en) User interface state information generation method and device, electronic equipment and medium
CN111597107B (en) Information output method and device and electronic equipment
CN112115153A (en) Data processing method, device, equipment and storage medium
CN111273830A (en) Data display method and device, electronic equipment and computer readable medium
CN111241823A (en) Dependency configuration management method and device, electronic equipment and storage medium
CN110852720A (en) Document processing method, device, equipment and storage medium
CN113918659A (en) Data operation method and device, storage medium and electronic equipment
CN111813685B (en) Automatic test method and device
CN111241137B (en) Data processing method, device, electronic equipment and storage medium
CN113807056B (en) Document name sequence error correction method, device and equipment
CN112084441A (en) Information retrieval method and device and electronic equipment
CN112507676B (en) Method and device for generating energy report, electronic equipment and computer readable medium
CN111782895B (en) Retrieval processing method and device, readable medium and electronic equipment
CN111460020B (en) Method, device, electronic equipment and medium for resolving message
CN113393288A (en) Order processing information generation method, device, equipment and computer readable medium
CN112307723A (en) Method and device for generating code document and electronic equipment
CN111753238A (en) Data mapping method and device and electronic equipment
CN111787043A (en) Data request method and device
CN110543491A (en) Search method, search device, electronic equipment and computer-readable storage medium
CN111857879B (en) Data processing method, device, electronic equipment and computer readable medium
CN115374320B (en) Text matching method and device, electronic equipment and computer medium
CN114040014B (en) Content pushing method, device, electronic equipment and computer readable storage medium
CN111399902B (en) Client source file processing method and device, readable medium and electronic equipment

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
TR01 Transfer of patent right

Effective date of registration: 20231116

Address after: 100085 32-3-4108-4109, building 32, Chuangye Middle Road, Haidian District, Beijing

Patentee after: BEIJING GUODIANTONG NETWORK TECHNOLOGY Co.,Ltd.

Patentee after: STATE GRID INFORMATION & TELECOMMUNICATION GROUP Co.,Ltd.

Patentee after: State Grid Siji Location Service Co.,Ltd.

Address before: Room 32-3-4108-4109, building 32, Chuangye Middle Road, Haidian District, Beijing 100089

Patentee before: BEIJING GUODIANTONG NETWORK TECHNOLOGY Co.,Ltd.

Patentee before: STATE GRID INFORMATION & TELECOMMUNICATION GROUP Co.,Ltd.

TR01 Transfer of patent right