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.