Data table file generation method, device, electronic device and computer readable medium

By selecting the association information identifier on the business data integration acquisition page and generating the association data table file, the resource waste caused by the difficulty of a single data table to meet the needs of multiple tables and the developers' understanding of differences is solved, and efficient business data acquisition and resources are achieved use.

CN118331966BActive Publication Date: 2024-11-12GONGYI (BEIJING) CLOUD TECH CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202410612473.0
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-05-17
Publication Date
2024-11-12
Estimated Expiration
2044-05-17

AI Technical Summary

Technical Problem

When obtaining business data in the prior art, a single data table is difficult to meet the business needs associated with multiple tables, resulting in increased consumption of computer computing resources. There may be differences in understanding when developers compiling data table connection codes, resulting in low accuracy and waste of resources. .

Method used

By displaying business data integration to obtain the page, select the business details container control and association information identification, generate the associated information identification set to be sent, send it to the server for data table connection, and display and export the connection data table file on the page to reduce multiple times Query and extraction processing.

Benefits of technology

Reduces the consumption of computer computing resources, improves the accuracy of data table connections, and reduces resource waste due to understanding differences.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118331966B_ABST
    Figure CN118331966B_ABST
Patent Text Reader

Abstract

The embodiments of the present disclosure disclose a data table file generation method, device, electronic device and computer-readable medium. A specific implementation of the method includes: displaying a business data integration acquisition page; displaying each associated information identification selection control corresponding to at least one selected business detail container control; determining each associated information identification as a set of associated information identifications to be sent; sending the set of associated information identifications to be sent to the server, so that the server can connect each data table corresponding to the set of associated information identifications to be sent to obtain a connection data table; decrypting the encrypted connection data table information to obtain a connection data table corresponding to the encrypted connection data table information; displaying the connection data table corresponding to the encrypted connection data table information as a connection data table to be exported at the first preset position of the business data integration acquisition page; generating a connection data table file. This implementation reduces the consumption of computer computing resources.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] Embodiments of the present disclosure relate to the field of computer technology, and in particular to a method, device, electronic device, and computer-readable medium for generating a data table file. Background Art

[0002] With the continuous development of the modern information technology industry, business data provides enterprises with objective and quantitative information, which helps enterprises make smarter and more scientific decisions. Data table file generation is a technology for obtaining business data. At present, when obtaining business data, the usual method is to obtain business data from a single data table or developers compile data table connection codes to connect multiple data tables according to the business needs provided by business personnel to obtain business data that meets business needs.

[0003] However, when using the above method to obtain business data, the following technical problems often occur:

[0004] First, as data processing needs continue to increase, it may be difficult to meet business needs by only obtaining business data from a single data table. For business data that needs to be associated with multiple tables, if it is only obtained from a single data table, it may be necessary to perform multiple queries and extraction processes on multiple single data tables to obtain business data that meets business needs, which increases the consumption of computer computing resources.

[0005] Second, when developers compile data table connection codes based on business requirements provided by business personnel, there may be differences in understanding of business requirements, resulting in low accuracy of data table connection codes, and the data table needs to be reconnected to obtain business data, which in turn leads to a waste of computer computing resources.

[0006] The above information disclosed in this Background section is only for enhancement of understanding of the background of the present disclosure concept and therefore it may contain information that does not form the prior art that is already known in this country to a person of ordinary skill in the art. Summary of the invention

[0007] The content of this disclosure is used to introduce concepts in a brief form, which will be described in detail in the detailed implementation section below. The content of this disclosure is not intended to identify the key features or essential features of the technical solution claimed for protection, nor is it intended to limit the scope of the technical solution claimed for protection.

[0008] Some embodiments of the present disclosure propose a data table file generation method, device, electronic device and computer-readable medium to solve one or more of the technical problems mentioned in the above background technology section.

[0009] In a first aspect, some embodiments of the present disclosure provide a method for generating a data table file, the method comprising: in response to receiving business component configuration completion information sent by a server, displaying a business data integration acquisition page, wherein the business data integration acquisition page includes various business detail container controls corresponding to preset businesses; in response to detecting a selection operation acting on at least one business detail container control among the various business detail container controls, displaying various associated information identification selection controls corresponding to the selected at least one business detail container control; in response to detecting a selection operation acting on at least one associated information identification selection control among the various associated information identification selection controls, determining various associated information identifications corresponding to the at least one associated information identification selection control as a set of associated information identifications to be sent, wherein the various associated information identifications among the various associated information identifications One association information identifier corresponds to one data table; the above-mentioned to-be-sent association information identifier set is sent to the above-mentioned server, so that the above-mentioned server can connect the various data tables corresponding to the above-mentioned to-be-sent association information identifier set to obtain a connection data table; in response to receiving the encrypted connection data table information corresponding to the above-mentioned connection data table sent by the above-mentioned server, the above-mentioned encrypted connection data table information is decrypted to obtain the connection data table corresponding to the above-mentioned encrypted connection data table information; the connection data table corresponding to the above-mentioned encrypted connection data table information is displayed as the connection data table to be exported at the first preset position of the above-mentioned business data integration acquisition page, and the export control is displayed at the second preset position of the above-mentioned business data integration acquisition page; in response to detecting the selection operation acting on the above-mentioned export control, a connection data table file is generated according to the above-mentioned connection data table to be exported.

[0010] In a second aspect, some embodiments of the present disclosure provide a data table file generation device, the device comprising: a first display unit, configured to display a business data integration acquisition page in response to receiving business component configuration completion information sent by a server, wherein the business data integration acquisition page includes various business detail container controls corresponding to preset businesses; a second display unit, configured to display various associated information identification selection controls corresponding to the selected at least one business detail container control in response to detecting a selection operation acting on at least one of the various business detail container controls; a determination unit, configured to determine various associated information identifiers corresponding to the at least one associated information identification selection control as a set of associated information identifiers to be sent in response to detecting a selection operation acting on at least one of the various associated information identification selection controls, wherein one associated information identifier in the various associated information identifiers is a The information identifier corresponds to a data table; the connection unit is configured to send the above-mentioned associated information identifier set to be sent to the above-mentioned server, so that the above-mentioned server can connect the various data tables corresponding to the above-mentioned associated information identifier set to be sent to obtain a connection data table; the decryption processing unit is configured to, in response to receiving the encrypted connection data table information corresponding to the above-mentioned connection data table sent by the above-mentioned server, decrypt the above-mentioned encrypted connection data table information to obtain the connection data table corresponding to the above-mentioned encrypted connection data table information; the third display unit is configured to display the connection data table corresponding to the above-mentioned encrypted connection data table information as the connection data table to be exported at the first preset position of the above-mentioned business data integration acquisition page, and display the export control at the second preset position of the above-mentioned business data integration acquisition page; the generation unit is configured to generate a connection data table file according to the above-mentioned connection data table to be exported in response to detecting a selection operation acting on the above-mentioned export control.

[0011] In a third aspect, some embodiments of the present disclosure provide an electronic device comprising: one or more processors; a storage device on which one or more programs are stored, and when the one or more programs are executed by the one or more processors, the one or more processors implement the method described in any implementation manner of the above-mentioned first aspect.

[0012] In a fourth aspect, some embodiments of the present disclosure provide a computer-readable medium having a computer program stored thereon, wherein when the program is executed by a processor, the method described in any implementation manner of the above-mentioned first aspect is implemented.

[0013] The above-mentioned embodiments of the present disclosure have the following beneficial effects: through the data table file generation method of some embodiments of the present disclosure, the consumption of computer computing resources is reduced. Specifically, the reason for the increase in computer computing resource consumption is that with the continuous increase in data processing requirements, it may be difficult to meet business needs by only obtaining business data from a single data table. For business data that needs to be associated with multiple tables, if it is only obtained from a single data table, it may be necessary to perform multiple queries and extraction processes on multiple single data tables respectively to obtain business data that meets business needs, which increases the consumption of computer computing resources. Based on this, the data table file generation method of some embodiments of the present disclosure, first, in response to receiving the business component configuration completion information sent by the service end, displays a business data integration acquisition page, wherein the above-mentioned business data integration acquisition page includes various business detail container controls corresponding to the preset business. Then, in response to detecting a selection operation acting on at least one business detail container control in the above-mentioned various business detail container controls, display various associated information identification selection controls corresponding to the selected at least one business detail container control. Thus, various associated information identification selection controls for determining the associated information identification set to be sent can be displayed. Next, in response to detecting a selection operation acting on at least one of the above-mentioned associated information identifier selection controls, each associated information identifier corresponding to the above-mentioned at least one associated information identifier selection control is determined as a set of associated information identifiers to be sent, wherein one of the above-mentioned associated information identifiers corresponds to a data table. Thus, a set of associated information identifiers to be sent for data table connection can be obtained. Then, the above-mentioned set of associated information identifiers to be sent is sent to the above-mentioned server, so that the above-mentioned server can connect each data table corresponding to the above-mentioned set of associated information identifiers to be sent to obtain a connection data table. Thus, each data table corresponding to the preset business and the set of associated information identifiers to be sent can be connected to obtain a connection data table (business data) representing the satisfaction of business requirements. Afterwards, in response to receiving the encrypted connection data table information corresponding to the above-mentioned connection data table sent by the above-mentioned server, the above-mentioned encrypted connection data table information is decrypted to obtain a connection data table corresponding to the above-mentioned encrypted connection data table information. Thus, the decrypted connection data table can be obtained. Then, the connection data table corresponding to the encrypted connection data table information is displayed as the connection data table to be exported at the first preset position of the business data integration acquisition page, and the export control is displayed at the second preset position of the business data integration acquisition page. Finally, in response to detecting the selection operation acting on the export control, a connection data table file is generated according to the connection data table to be exported. Thus, a connection data table file representing the business data can be obtained. Also, because the interactive operation of the business data integration acquisition page is adopted to connect the various data tables corresponding to the above-mentioned set of association information identifiers to be sent, the connection data table is obtained.A connection data table file representing business data is generated based on the connection data table. It is not necessary to perform multiple queries and extraction processes on multiple single data tables, thus reducing the consumption of computer computing resources. BRIEF DESCRIPTION OF THE DRAWINGS

[0014] The above and other features, advantages and aspects of the embodiments of the present disclosure will become more apparent with reference to the following detailed description in conjunction with the accompanying drawings. Throughout the accompanying drawings, the same or similar reference numerals represent the same or similar elements. It should be understood that the drawings are schematic and that components and elements are not necessarily drawn to scale.

[0015] Figure 1 is a flow chart of some embodiments of the data table file generation method according to the present disclosure;

[0016] Figure 2 It is a structural schematic diagram of some embodiments of the data table file generating device according to the present disclosure;

[0017] Figure 3 It is a schematic diagram of the structure of an electronic device suitable for implementing some embodiments of the present disclosure. DETAILED DESCRIPTION

[0018] Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be construed as being limited to the embodiments set forth herein. On the contrary, these embodiments are provided to provide a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are only for exemplary purposes and are not intended to limit the scope of protection of the present disclosure.

[0019] It should also be noted that, for ease of description, only the parts related to the invention are shown in the drawings. In the absence of conflict, the embodiments and features in the embodiments of the present disclosure can be combined with each other.

[0020] It should be noted that the concepts such as "first" and "second" mentioned in the present disclosure are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

[0021] It should be noted that the modifications of "one" and "plurality" mentioned in the present disclosure are illustrative rather than restrictive, and those skilled in the art should understand that unless otherwise clearly indicated in the context, it should be understood as "one or more".

[0022] The names of the messages or information exchanged between multiple devices in the embodiments of the present disclosure are only used for illustrative purposes and are not used to limit the scope of these messages or information.

[0023] The present disclosure will be described in detail below with reference to the accompanying drawings and in conjunction with embodiments.

[0024] Figure 1 The process 100 of some embodiments of the data table file generation method according to the present disclosure is shown. The data table file generation method comprises the following steps:

[0025] Step 101: In response to receiving the business component configuration completion information sent by the server, a business data integration acquisition page is displayed.

[0026] In some embodiments, the execution subject (e.g., computing device) of the data table file generation method may display a business data integration acquisition page in response to receiving the business component configuration completion information sent by the server. The business data integration acquisition page includes various business detail container controls corresponding to the preset business. The business component configuration completion information may be text information indicating that the configuration of various components corresponding to the preset business is complete. The preset business may be, but is not limited to, one of the following: goods circulation (sales), goods production, and research and development business. The business data integration acquisition page may be a page for acquiring business data. The business detail container control in each of the business detail container controls may be a container control for selecting various associated information identifiers corresponding to the preset business. One of the associated information identifiers may be the name of a data table. The associated information identifiers may include, but are not limited to, a legal person code and a research and development project identifier. The execution subject may be a client that acquires business data. The server may configure various business components, connect data tables, and send the connected data tables (business data) to the client.

[0027] In some optional implementations of some embodiments, each business component corresponding to the above business component configuration completion information may be configured through the following steps:

[0028] The first step is to display a business component configuration page, wherein the business component configuration page includes a configuration control corresponding to the preset business, wherein the configuration control may be a control for selecting the business to be configured.

[0029] In the second step, in response to detecting a selection operation acting on the configuration control, the service identifier corresponding to the configuration control is determined as the service identifier to be queried.

[0030] The third step is to query each associated information identifier corresponding to the service identifier to be queried from a preset database. The preset database may be a MySQL database storing each associated information identifier.

[0031] In the fourth step, each piece of business component information corresponding to the above-mentioned business identifier to be queried is determined as each piece of target business component information.

[0032] The fifth step is to establish the relationship data models between the data tables corresponding to the above-mentioned respective association information identifiers and the above-mentioned respective target business component information according to the preset comparison relationship information set. Among them, each relationship data model in the above-mentioned respective relationship data models corresponds to a set of association information identifiers. The above-mentioned preset comparison relationship information set can be used to describe the corresponding relationship between each association information identifier and each business component information. For example, one preset comparison relationship information in the above-mentioned preset comparison relationship information set can be expressed as "when each association information identifier is {identifier A, identifier B}, each association information identifier {identifier A, identifier B} corresponds to business component information 1". The above-mentioned business component information 1 can be one business component information in each business component information. One business component information in each business component information can be a programming language code that connects each data table corresponding to the above component information according to the connection method corresponding to the business component information. For example, the above-mentioned connection method can be to left-connect data table A with data table B. The above-mentioned data table A and the above-mentioned data table B can be the table names of data tables. As an example, the above-mentioned respective association information identifiers can be "identifier A, identifier B, identifier C". The data tables corresponding to identifier A, identifier B, and identifier C can be "tableA, tableB, tableC". The information of each business component can be {"SELECT*FROM tableA LEFT JOIN tableB ON tableA.id=tableB.id;"}. Each relational data model can be expressed as {tableA, tableB, "SELECT*FROM tableA LEFT JOIN tableB ONtableA.id=tableB.id;", the relationship between TableA and TableB is connected to TableA.id through TableB.id}. The relational data model {tableA, tableB, "SELECT*FROM tableA LEFT JOIN tableB ONtableA.id=tableB.id;", the relationship between TableA and TableB is connected to TableA.id through TableB.id} corresponds to the associated information identifier set {identifier A, identifier B}. It should be noted that the above tableA can be entity table A. The above tableB can be entity table B. The above tableC can be entity table C.

[0033] The sixth step is to identify the created relational data models as configured business components.

[0034] In some optional implementations of some embodiments, the server may establish, according to a preset reference relationship information set, relationship data models between the data tables corresponding to the association information identifiers and the target business component information through the following steps:

[0035] The first step is to store the above-mentioned various associated information identifiers into a preset sequence to obtain an associated information identifier sequence.

[0036] In the second step, the number of association information identifiers in the association information identifier sequence is determined as a first value.

[0037] The third step is to determine the difference between the first value and the first preset value as the quantity to be added. The first preset value may be 1.

[0038] Step 4: For the first associated information identifier in the associated information identifier sequence, perform the following generation steps according to the number to be added:

[0039] In the first sub-step, in response to determining that the number to be added is greater than the second preset value, the following processing steps are performed:

[0040] Sub-step 1: determining the number to be added as the sliding window size. The second preset value may be 2.

[0041] Sub-step 2: According to the size of the sliding window, each of the associated information identifiers except the first associated information identifier in the associated information identifier sequence is divided to obtain each set of associated information identifiers to be added. As an example, the associated information identifier sequence may be {associated information identifier A, associated information identifier B, associated information identifier C}. The above sliding window size may be 2, and each of the associated information identifiers except the associated information identifier A in {associated information identifier A, associated information identifier B, associated information identifier C} is divided, and each set of associated information identifiers to be added may be {associated information identifier B, associated information identifier C}.

[0042] Sub-step three: determining the difference between the number to be added and the first preset value as the updated value.

[0043] Sub-step four: updating the quantity to be added to the updated value to update the quantity to be added.

[0044] Sub-step five: in response to determining that the updated number to be added is greater than the second preset value, the above processing steps are executed again according to the updated number to be added.

[0045] In the second sub-step, in response to determining that the updated number to be added is less than or equal to the second preset value, the first association information identifier is added to each of the association information identifier sets to be added, so as to update each of the association information identifier sets to be added. As an example, the above-mentioned association information identifier sets to be added can be {association information identifier B}, {association information identifier C}, {association information identifier B, association information identifier C}.

[0046] The third sub-step is to determine the updated association information identification sets to be added as the target association information identification sets. As an example, the target association information identification sets may be {association information identification A, association information identification B}, {association information identification A, association information identification C}, {association information identification A, association information identification B, association information identification C}. It should be noted that the number of target association information identifications in each target association information identification set is greater than or equal to 2.

[0047] The fourth sub-step is to delete the first association information identifier from the association information identifier sequence to update the association information identifier sequence.

[0048] In a fifth sub-step, in response to determining that the number of associated information identifiers in the updated associated information identifier sequence is greater than or equal to a preset threshold, the generation step is performed again according to the updated associated information identifier sequence. The preset threshold may be 2.

[0049] Step 5: For each target association information identification set in the generated target association information identification sets, perform the following steps:

[0050] The first sub-step is to query the business component information corresponding to the target association information identification set from the comparison relationship information set.

[0051] The second sub-step is to determine the queried business component information and each data table corresponding to the above target association information identification set as a relational data model.

[0052] The above technical solution and its related contents are combined with steps 101 to 103 and the first to fifth steps of step 104 as an inventive point of an embodiment of the present disclosure, which solves the second technical problem mentioned in the background technology: "When developers compile data table connection codes according to business requirements provided by business personnel, there may be differences in understanding of business requirements, resulting in low accuracy of data table connection codes, and it is necessary to reconnect data tables to obtain business data, which leads to waste of computer computing resources." The factors that lead to waste of computer computing resources are often as follows: When developers compile data table connection codes according to business requirements provided by business personnel, there may be differences in understanding of business requirements, resulting in low accuracy of data table connection codes, and it is necessary to reconnect data tables to obtain business data, which leads to waste of computer computing resources. If the above factors are solved, the effect of reducing the waste of computer computing resources can be achieved. In order to achieve this effect, first, the above-mentioned various associated information identifiers are stored in a preset sequence to obtain an associated information identifier sequence. Thus, the associated information identifier sequence can be obtained. Then, the number of associated information identifiers in the associated information identifier sequence is determined as a first value. Next, the difference between the first value and the first preset value is determined as the number to be added. Thus, the number to be added for the generation step can be obtained. Afterwards, for the first associated information identifier in the associated information identifier sequence, according to the number to be added, the following generation step is performed: the first sub-step, in response to determining that the number to be added is greater than the second preset value, the following processing steps are performed: sub-step one, the number to be added is determined as the sliding window size. Thus, the sliding window size for dividing each associated information identifier can be obtained. Sub-step two, according to the sliding window size, each associated information identifier in the associated information identifier sequence except the first associated information identifier is divided to obtain each set of associated information identifiers to be added. Thus, each set of associated information identifiers to be added for generating each target set of associated information identifiers can be obtained. Sub-step three, the difference between the number to be added and the first preset value is determined as the updated value. Sub-step four, the number to be added is updated to the updated value to update the number to be added. Sub-step five, in response to determining that the updated number to be added is greater than the second preset value, the above processing steps are performed again according to the updated number to be added. In a second sub-step, in response to determining that the updated number to be added is less than or equal to the second preset value, the first association information identifier is added to each of the association information identifier sets to be added, so as to update each of the association information identifier sets to be added. In a third sub-step, the updated association information identifier sets to be added are determined as the target association information identifier sets. Thus, the target association information identifier sets for determining the relational data model can be obtained. In a fourth sub-step, the first association information identifier is deleted from the association information identifier sequence, so as to update the association information identifier sequence.The fifth sub-step, in response to determining that the number of associated information identifiers in the updated associated information identifier sequence is greater than or equal to the preset threshold, execute the above generation step again according to the updated associated information identifier sequence. Afterwards, for each target associated information identifier set in each generated target associated information identifier set, execute the following steps: the first sub-step, querying the business component information corresponding to the above target associated information identifier set from the above reference relationship information set reference relationship information set. The second sub-step, determining the queried business component information and each data table corresponding to the above target associated information identifier set as a relational data model. Thus, a relational data model can be obtained. In combination with steps 101 to 103, business personnel can determine the to-be-sent associated information identifier set representing business needs through the business data integration acquisition page. In combination with the first to fifth steps of step 104, the server can connect each data table corresponding to the to-be-sent associated information identifier set based on the target relational data model corresponding to the to-be-sent associated information identifier set in each relational data model to obtain a connection data table (business data). Because the business data integration acquisition page is used to determine the set of associated information identifiers to be sent that meet business requirements, and the data table is connected through the relational data model corresponding to the set of associated information identifiers to be sent that meet business requirements, the possibility of connection code errors caused by differences in developers' understanding of business requirements is reduced. The number of times the data table is reconnected to obtain business data is reduced, thereby reducing the waste of computer computing resources.

[0053] Step 102: in response to detecting a selection operation on at least one of the business detail container controls, displaying each associated information identification selection control corresponding to the selected at least one business detail container control.

[0054] In some embodiments, the execution subject may, in response to detecting a selection operation on at least one of the business detail container controls, display each associated information identifier selection control corresponding to the selected at least one business detail container control. Among them, one of the associated information identifier selection controls may be an interactive element for selecting an associated information identifier. For example, the associated information identifier selection control may be a radio button.

[0055] Step 103: in response to detecting a selection operation on at least one of the associated information identifier selection controls, determining the associated information identifiers corresponding to the at least one associated information identifier selection control as an associated information identifier set to be sent.

[0056] In some embodiments, the execution subject may, in response to detecting a selection operation on at least one of the above-mentioned associated information identifier selection controls, determine each associated information identifier corresponding to the above-mentioned at least one associated information identifier selection control as an associated information identifier set to be sent. Wherein, one of the above-mentioned associated information identifiers corresponds to a data table. One of the above-mentioned at least one associated information identifier selection controls corresponds to one of the above-mentioned associated information identifiers.

[0057] Step 104 : sending the to-be-sent association information identification set to the server, so that the server can connect the data tables corresponding to the to-be-sent association information identification set to obtain a connection data table.

[0058] In some embodiments, the execution subject may send the to-be-sent association information identification set to the server, so that the server can connect each data table corresponding to the to-be-sent association information identification set to obtain a connection data table.

[0059] In some optional implementations of some embodiments, the server may connect the data tables corresponding to the to-be-sent association information identification set through the following steps to obtain a connection data table:

[0060] In the first step, each associated information identification set corresponding to each relational data model is determined as each target associated information identification set.

[0061] In the second step, the similarity between the to-be-sent association information identification set and each target association information identification set in the target association information identification sets is determined as the similarity to be screened. The similarity may be cosine similarity.

[0062] In the third step, the similarities to be screened that meet a preset condition among the determined similarities to be screened are determined as the screening similarities, wherein the preset condition may be the maximum similarity value.

[0063] The fourth step is to determine the relational data model corresponding to the above-mentioned screening similarity as the target relational data model. The above-mentioned target relational data model includes: business component information and various data tables corresponding to the set of associated information identifiers to be sent.

[0064] The fifth step is to execute the connection task corresponding to the business component information to connect the data tables corresponding to the set of associated information identifiers to be sent to obtain a connection data table. The connection data table can be a data table obtained by connecting the data tables.

[0065] In some optional implementations of some embodiments, the execution subject may send the to-be-sent association information identifier set to the server through the following steps:

[0066] The first step is to perform a reachability test on the network connection status with the above-mentioned server to obtain a reachability test result. In practice, the above-mentioned execution subject can use the Ping command to detect the status of the network connection with the server to obtain a reachability test result. The above-mentioned reachability test result can be represented by a Boolean value. For example, if the above-mentioned reachability test result is true, it means that the network is reachable. If the above-mentioned reachability test result is false, it means that the network is unreachable.

[0067] In the second step, in response to detecting that the reachability detection result indicates that the network is reachable, the to-be-sent association information identifier set is sent to the server.

[0068] Step 105: in response to receiving the encrypted connection data table information corresponding to the connection data table sent by the server, decrypt the encrypted connection data table information to obtain a connection data table corresponding to the encrypted connection data table information.

[0069] In some embodiments, the execution subject may, in response to receiving the encrypted connection data table information corresponding to the connection data table sent by the server, decrypt the encrypted connection data table information to obtain a connection data table corresponding to the encrypted connection data table information.

[0070] In some optional implementations of some embodiments, the execution subject may decrypt the encrypted connection data table information through the following steps to obtain a connection data table corresponding to the encrypted connection data table information:

[0071] The first step is to determine the above encrypted connection data table information as the ciphertext to be decrypted.

[0072] The second step is to obtain the decryption algorithm information and decryption key corresponding to the ciphertext to be decrypted from the preset database. The decryption algorithm information may represent a preset decryption algorithm. For example, the decryption algorithm may be an AES algorithm.

[0073] The third step is to execute the decryption operation corresponding to the decryption algorithm information according to the decryption key to decrypt the ciphertext to be decrypted and obtain the connection data table corresponding to the ciphertext to be decrypted.

[0074] Step 106: Display the connection data table corresponding to the encrypted connection data table information as the connection data table to be exported at a first preset position of the business data integration acquisition page, and display an export control at a second preset position of the business data integration acquisition page.

[0075] In some embodiments, the execution subject may display the connection data table corresponding to the encrypted connection data table information as the connection data table to be exported at a first preset position on the business data integration acquisition page, and display an export control at a second preset position on the business data integration acquisition page. The export control may be an interactive element for exporting the data table in a file format.

[0076] Step 107 , in response to detecting a selection operation acting on the export control, generating a connection data table file according to the connection data table to be exported.

[0077] In some embodiments, the execution subject may generate a connection data table file according to the connection data table to be exported in response to detecting a selection operation acting on the export control.

[0078] In some optional implementations of some embodiments, the execution subject may generate a connection data table file according to the connection data table to be exported in response to detecting a selection operation acting on the export control through the following steps:

[0079] In the first step, in response to detecting a selection operation on the export control, the connection data table to be exported is exported in a file format, for example, the file format may be Excel format.

[0080] The second step is to determine the exported file as a connection data table file.

[0081] The above-mentioned embodiments of the present disclosure have the following beneficial effects: through the data table file generation method of some embodiments of the present disclosure, the consumption of computer computing resources is reduced. Specifically, the reason for the increase in computer computing resource consumption is that with the continuous increase in data processing requirements, it may be difficult to meet business needs by only obtaining business data from a single data table. For business data that needs to be associated with multiple tables, if it is only obtained from a single data table, it may be necessary to perform multiple queries and extraction processes on multiple single data tables respectively to obtain business data that meets business needs, which increases the consumption of computer computing resources. Based on this, the data table file generation method of some embodiments of the present disclosure, first, in response to receiving the business component configuration completion information sent by the service end, displays a business data integration acquisition page, wherein the above-mentioned business data integration acquisition page includes various business detail container controls corresponding to the preset business. Then, in response to detecting a selection operation acting on at least one business detail container control in the above-mentioned various business detail container controls, display various associated information identification selection controls corresponding to the selected at least one business detail container control. Thus, various associated information identification selection controls for determining the associated information identification set to be sent can be displayed. Next, in response to detecting a selection operation acting on at least one of the above-mentioned associated information identifier selection controls, each associated information identifier corresponding to the above-mentioned at least one associated information identifier selection control is determined as a set of associated information identifiers to be sent, wherein one of the above-mentioned associated information identifiers corresponds to a data table. Thus, a set of associated information identifiers to be sent for data table connection can be obtained. Then, the above-mentioned set of associated information identifiers to be sent is sent to the above-mentioned server, so that the above-mentioned server can connect each data table corresponding to the above-mentioned set of associated information identifiers to be sent to obtain a connection data table. Thus, each data table corresponding to the preset business and the set of associated information identifiers to be sent can be connected to obtain a connection data table (business data) representing the satisfaction of business requirements. Afterwards, in response to receiving the encrypted connection data table information corresponding to the above-mentioned connection data table sent by the above-mentioned server, the above-mentioned encrypted connection data table information is decrypted to obtain a connection data table corresponding to the above-mentioned encrypted connection data table information. Thus, the decrypted connection data table can be obtained. Then, the connection data table corresponding to the encrypted connection data table information is displayed as the connection data table to be exported at the first preset position of the business data integration acquisition page, and the export control is displayed at the second preset position of the business data integration acquisition page. Finally, in response to detecting the selection operation acting on the export control, a connection data table file is generated according to the connection data table to be exported. Thus, a connection data table file representing the business data can be obtained. Also, because the interactive operation of the business data integration acquisition page is adopted to connect the various data tables corresponding to the above-mentioned set of association information identifiers to be sent, the connection data table is obtained.A connection data table file representing business data is generated based on the connection data table. It is not necessary to perform multiple queries and extraction processes on multiple single data tables, thus reducing the consumption of computer computing resources.

[0082] Further references Figure 2 As an implementation of the methods shown in the figures, the present disclosure provides some embodiments of a data table file generating device, and these device embodiments are similar to Figure 1 Corresponding to the method embodiments shown, the device can be specifically applied to various electronic devices.

[0083] like Figure 2 As shown, the data table file generation device 200 of some embodiments includes: a first display unit 201, a second display unit 202, a determination unit 203, a connection unit 204, a decryption processing unit 205, a third display unit 206 and a generation unit 207. The first display unit 201 is configured to display a business data integration acquisition page in response to receiving the business component configuration completion information sent by the server, wherein the business data integration acquisition page includes various business detail container controls corresponding to the preset business; the second display unit 202 is configured to display various associated information identifier selection controls corresponding to the selected at least one business detail container control in response to detecting a selection operation acting on at least one of the various business detail container controls; the determination unit 203 is configured to determine various associated information identifiers corresponding to the at least one associated information identifier selection control as the associated information identifier set to be sent in response to detecting a selection operation acting on at least one of the various associated information identifier selection controls, wherein one of the various associated information identifiers corresponds to a data table; the connection unit 204 is configured to display various associated information identifiers corresponding to the at least one associated information identifier selection control as the associated information identifier set to be sent, wherein one of the various associated information identifiers corresponds to a data table; 204 is configured to send the above-mentioned to-be-sent associated information identification set to the above-mentioned server, so that the above-mentioned server can connect the various data tables corresponding to the above-mentioned to-be-sent associated information identification set to obtain a connection data table; the decryption processing unit 205 is configured to, in response to receiving the encrypted connection data table information corresponding to the above-mentioned connection data table sent by the above-mentioned server, decrypt the above-mentioned encrypted connection data table information to obtain the connection data table corresponding to the above-mentioned encrypted connection data table information; the third display unit 206 is configured to display the connection data table corresponding to the above-mentioned encrypted connection data table information as the connection data table to be exported at the first preset position of the above-mentioned business data integration acquisition page, and display the export control at the second preset position of the above-mentioned business data integration acquisition page; the generation unit 207 is configured to generate a connection data table file according to the above-mentioned connection data table to be exported in response to detecting a selection operation acting on the above-mentioned export control.

[0084] It is understood that the units described in the device 200 are similar to those described in the reference Figure 1 Therefore, the operations, features and beneficial effects described above for the method are also applicable to the device 200 and the units contained therein, and will not be described in detail here.

[0085] Reference below Figure 3 , which shows a structural schematic diagram of an electronic device 300 suitable for implementing some embodiments of the present disclosure. Figure 3 The electronic device shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.

[0086] like Figure 3 As shown, the electronic device 300 may include a processing device (e.g., a central processing unit, a graphics processing unit, etc.) 301, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 302 or a program loaded from a storage device 308 into a random access memory (RAM) 303. In the RAM 303, various programs and data required for the operation of the electronic device 300 are also stored. The processing device 301, the ROM 302, and the RAM 303 are connected to each other via a bus 304. An input / output (I / O) interface 305 is also connected to the bus 304.

[0087] Typically, the following devices may be connected to the I / O interface 305: input devices 306 including, for example, a touch screen, a touch pad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; output devices 307 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; storage devices 308 including, for example, a magnetic tape, a hard disk, etc.; and communication devices 309. The communication devices 309 may allow the electronic device 300 to communicate with other devices wirelessly or by wire to exchange data. Although Figure 3 The electronic device 300 is shown with various devices, but it should be understood that it is not required to implement or possess all the devices shown. More or fewer devices may be implemented or possessed instead. Figure 3 Each block shown in the figure may represent one device, or may represent multiple devices as required.

[0088] In particular, according to some embodiments of the present disclosure, the process described above with reference to the flowchart can be implemented as a computer software program. For example, some embodiments of the present disclosure include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes a program code for executing the method shown in the flowchart. In some such embodiments, the computer program can be downloaded and installed from the network through the communication device 309, or installed from the storage device 308, or installed from the ROM 302. When the computer program is executed by the processing device 301, the functions defined in the method of some embodiments of the present disclosure are executed.

[0089] It should be noted that the computer-readable medium recorded 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 may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, 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 disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof. In some embodiments of the present disclosure, a computer-readable storage medium may be any tangible medium containing or storing a program that may be used by or in conjunction with an instruction execution system, device or device. In some embodiments of the present disclosure, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, in which a computer-readable program code is carried. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. The computer readable signal medium may also be any computer readable medium other than a computer readable storage medium, which may send, propagate or transmit a program for use by or in conjunction with an instruction execution system, apparatus or device. The program code contained on the computer readable medium may be transmitted using any suitable medium, including but not limited to: wires, optical cables, RF (radio frequency), etc., or any suitable combination thereof.

[0090] In some embodiments, the client and the server 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"), an internet (e.g., the Internet), and a peer-to-peer network (e.g., an ad hoc peer-to-peer network), as well as any currently known or future developed network.

[0091] The computer-readable medium may be included in the electronic device; or it may exist independently without being installed in the electronic device. The computer-readable medium carries one or more programs. When the one or more programs are executed by the electronic device, the electronic device: in response to receiving the business component configuration completion information sent by the server, displays the business data integration acquisition page, wherein the business data integration acquisition page includes each business detail container control corresponding to the preset business; in response to detecting a selection operation on at least one of the above-mentioned business detail container controls, displays each associated information identification selection control corresponding to the selected at least one business detail container control; in response to detecting a selection operation on at least one of the above-mentioned associated information identification selection controls, determines each associated information identification corresponding to the above-mentioned at least one associated information identification selection control as the associated information identification set to be sent, wherein the above-mentioned each associated An associated information identifier in the information identifier corresponds to a data table; the above-mentioned associated information identifier set to be sent is sent to the above-mentioned server, so that the above-mentioned server can connect the various data tables corresponding to the above-mentioned associated information identifier set to be sent to obtain a connection data table; in response to receiving the encrypted connection data table information corresponding to the above-mentioned connection data table sent by the above-mentioned server, the above-mentioned encrypted connection data table information is decrypted to obtain the connection data table corresponding to the above-mentioned encrypted connection data table information; the connection data table corresponding to the above-mentioned encrypted connection data table information is displayed as the connection data table to be exported at the first preset position of the above-mentioned business data integration acquisition page, and the export control is displayed at the second preset position of the above-mentioned business data integration acquisition page; in response to detecting the selection operation acting on the above-mentioned export control, a connection data table file is generated according to the above-mentioned connection data table to be exported.

[0092] Computer program code for performing the operations of some embodiments of the present disclosure may be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages, such as Java, Smalltalk, C++, and conventional procedural programming languages, such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving a remote computer, the remote computer may be connected to the user's computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0093] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present disclosure. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some implementations as replacements, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0094] The units described in some embodiments of the present disclosure may be implemented by software or by hardware. The described units may also be set in a processor, for example, it may be described as: a processor includes a first display unit 201, a second display unit 202, a determination unit 203, a connection unit 204, a decryption processing unit 205, a third display unit 206 and a generation unit 207. Among them, the names of these units do not constitute a limitation on the units themselves under certain circumstances. For example, the connection unit may also be described as "sending the above-mentioned set of associated information identifiers to be sent to the above-mentioned server, so that the above-mentioned server can connect the various data tables corresponding to the above-mentioned set of associated information identifiers to be sent, and obtain a unit connecting the data tables".

[0095] 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: field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), and the like.

[0096] The above descriptions are only some preferred embodiments of the present disclosure and an explanation of the technical principles used. Those skilled in the art should understand that the scope of the invention involved in the embodiments of the present disclosure is not limited to the technical solutions formed by a specific combination of technical features, but should also cover other technical solutions formed by any combination of technical features or their equivalent features without departing from the inventive concept. For example, a technical solution formed by replacing the features with (but not limited to) the technical features with similar functions disclosed in the embodiments of the present disclosure.

Claims

1. A method for generating a data table file, comprising: In response to receiving the business component configuration completion information sent by the server, a business data integration acquisition page is displayed, wherein the business data integration acquisition page includes each business detail container control corresponding to the preset business, and each business component corresponding to the business component configuration completion information is configured through the following steps: Displaying a business component configuration page, wherein the business component configuration page includes a configuration control corresponding to the preset business; In response to detecting a selection operation acting on the configuration control, determining a service identifier corresponding to the configuration control as a service identifier to be queried; Querying each associated information identifier corresponding to the service identifier to be queried from a preset database; Determine each piece of service component information corresponding to the service identifier to be queried as each piece of target service component information; According to the preset reference relationship information set, establish each data table corresponding to each association information identifier and each relationship data model of each target business component information, wherein each relationship data model in each relationship data model corresponds to one association information identifier set; Determine each created relational data model as each configured business component; In response to detecting a selection operation acting on at least one of the business detail container controls, displaying each associated information identifier selection control corresponding to the selected at least one business detail container control; In response to detecting a selection operation acting on at least one of the associated information identifier selection controls, determining the associated information identifiers corresponding to the at least one associated information identifier selection control as an associated information identifier set to be sent, wherein one of the associated information identifiers corresponds to a data table; The to-be-sent association information identification set is sent to the server, so that the server connects the data tables corresponding to the to-be-sent association information identification set to obtain a connection data table, wherein the to-be-sent association information identification set is connected to obtain the connection data table, including: Determine each associated information identification set corresponding to each relational data model as each target associated information identification set; Determine the similarity between the to-be-sent association information identification set and each target association information identification set in each target association information identification set as the similarity to be screened; Determine the similarities to be screened that meet the preset conditions among the determined similarities to be screened as the screening similarities; Determining the relational data model corresponding to the screening similarity as the target relational data model, wherein the target relational data model includes: business component information and various data tables corresponding to the set of associated information identifiers to be sent; Execute a connection task corresponding to the business component information to connect each data table corresponding to the set of association information identifiers to be sent to obtain a connection data table; In response to receiving the encrypted connection data table information corresponding to the connection data table sent by the server, decrypting the encrypted connection data table information to obtain a connection data table corresponding to the encrypted connection data table information; Displaying the connection data table corresponding to the encrypted connection data table information as the connection data table to be exported at a first preset position on the business data integration acquisition page, and displaying an export control at a second preset position on the business data integration acquisition page; In response to detecting a selection operation acting on the export control, a connection data table file is generated according to the connection data table to be exported.

2. The method according to claim 1, wherein: The decrypting the encrypted connection data table information to obtain a connection data table corresponding to the encrypted connection data table information includes: Determining the encrypted connection data table information as ciphertext to be decrypted; Obtaining decryption algorithm information and a decryption key corresponding to the ciphertext to be decrypted from a preset database; According to the decryption key, a decryption operation corresponding to the decryption algorithm information is performed to decrypt the ciphertext to be decrypted, and a connection data table corresponding to the ciphertext to be decrypted is obtained.

3. The method according to claim 1, wherein: In response to detecting the selection operation acting on the export control, generating a connection data table file according to the connection data table to be exported includes: In response to detecting a selection operation acting on the export control, exporting the connection data table to be exported in a file format; Determine the exported file as a connection data table file.

4. The method according to claim 1, wherein: The step of sending the to-be-sent association information identifier set to the server includes: Performing a reachability test on the network connection status with the server to obtain a reachability test result; In response to detecting that the reachability detection result indicates that the network is reachable, the set of identifications of the to-be-sent association information is sent to the server.

5. A data table file generating device, comprising: The first display unit is configured to display a business data integration acquisition page in response to receiving the business component configuration completion information sent by the service end, wherein the business data integration acquisition page includes various business detail container controls corresponding to the preset business, and the various business components corresponding to the business component configuration completion information are configured through the following steps: displaying a business component configuration page, wherein the business component configuration page includes a configuration control corresponding to the preset business; in response to detecting a selection operation acting on the configuration control, determining the business identifier corresponding to the configuration control as the business identifier to be queried; querying various associated information identifiers corresponding to the business identifier to be queried from a preset database; determining various business component information corresponding to the business identifier to be queried as various target business component information; establishing various data tables corresponding to the various associated information identifiers and various relationship data models of the various target business component information according to a preset reference relationship information set, wherein each of the various relationship data models corresponds to an associated information identifier set; determining the various created relationship data models as various configured business components; A second display unit is configured to, in response to detecting a selection operation acting on at least one of the business detail container controls, display each associated information identification selection control corresponding to the selected at least one business detail container control; a determining unit configured to, in response to detecting a selection operation acting on at least one of the respective associated information identifier selection controls, determine the respective associated information identifiers corresponding to the at least one associated information identifier selection control as a set of associated information identifiers to be sent, wherein one of the respective associated information identifiers corresponds to a data table; A connection unit is configured to send the to-be-sent associated information identification set to the server, so that the server can connect the various data tables corresponding to the to-be-sent associated information identification set to obtain a connection data table, wherein the connection of the various data tables corresponding to the to-be-sent associated information identification set to obtain a connection data table includes: determining the various associated information identification sets corresponding to the various relationship data models as various target associated information identification sets; determining the similarity between the to-be-sent associated information identification set and each target associated information identification set in the various target associated information identification sets as the similarity to be screened; determining the similarity to be screened that meets a preset condition among the determined similarities to be screened as the screening similarity; determining the relationship data model corresponding to the screening similarity as the target relationship data model, wherein the target relationship data model includes: business component information and various data tables corresponding to the to-be-sent associated information identification set; executing the connection task corresponding to the business component information to connect the various data tables corresponding to the to-be-sent associated information identification set to obtain a connection data table; a decryption processing unit, configured to, in response to receiving the encrypted connection data table information corresponding to the connection data table sent by the server, decrypt the encrypted connection data table information to obtain a connection data table corresponding to the encrypted connection data table information; A third display unit is configured to display the connection data table corresponding to the encrypted connection data table information as the connection data table to be exported at a first preset position of the business data integration acquisition page, and to display an export control at a second preset position of the business data integration acquisition page; The generating unit is configured to generate a connection data table file according to the connection data table to be exported in response to detecting a selection operation acting on the export control.

6. An electronic device comprising: one or more processors; a storage device having one or more programs stored thereon; When the one or more programs are executed by the one or more processors, the one or more processors implement the method according to any one of claims 1 to 4.

7. A computer readable medium having a computer program stored thereon, wherein: When the program is executed by a processor, the method according to any one of claims 1 to 4 is implemented.