Method and system for customizing configuration table

Abstract

The embodiment of the invention provides a method and system for customizing a configuration table, and the method comprises the steps: determining a table identifier of a target table requested to be displayed and a user identifier of a target user initiating the table display request according to a table display request; according to the table identifier and the user identifier, determining table data of a target table cached in a local database and user-defined attribute information of a target user on the target table, and determining code attribute information of the target table in codes; the table data is rendered and displayed through the custom attribute information and the coding attribute information, a table configuration component is rendered in the display page, and the table configuration component is a custom component for displaying the displayed table by the user. The invention aims to improve the working efficiency and user experience of a user.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of computer, in particular to a method and system for customizing configuration table. BACKGROUND

[0002] Under the trend of big data and intelligent era, users have more and more diversified demand for tables. At present, most popular front-end framework tables in the traditional table market are fixed table columns coded by developers, and then rendered and displayed. Since different users have different concerns about tables, the fixed coding method reduces work efficiency and system adaptability. SUMMARY

[0003] Therefore, the embodiments of the present application provide a method and system for customizing configuration table, aiming to improve the work efficiency and user experience.

[0004] The first aspect of the embodiments of the present application provides a method for customizing configuration table, characterized in that the method comprises:

[0005] According to a table display request, determining a table identifier of a target table requested to be displayed and a user identifier of a target user initiating the table display request;

[0006] According to the table identifier and the user identifier, determining table data of the target table cached in a local database and custom attribute information of the target table by the target user, and determining coding attribute information of the target table in coding;

[0007] Rendering and displaying the table data through the custom attribute information and the coding attribute information, and rendering a table configuration component in a display page, the table configuration component being a custom component for the target user to customize the displayed table.

[0008] Optionally, according to the table identifier and the user identifier, determining the table data of the target table cached in the local database and the custom attribute information of the target table by the target user, comprises:

[0009] According to the table identifier, determining the table data of the target table corresponding to the table identifier cached in the local database;

[0010] According to the table identifier and the user identifier, determining a target identifier matching both the table identifier and the user identifier;

[0011] The target identifier is compared with the custom attribute identifiers of the custom attribute information cached by the local database, and custom attribute information corresponding to a custom attribute identifier identical to the target identifier is determined as custom attribute information of the target table customized by the target user.

[0012] Optionally, the table data is rendered and displayed by using the custom attribute information and the coded attribute information, including:

[0013] The first column identifier of column data in the table data is compared with the second column identifier of coded attribute in the coded attribute information, and coded attribute corresponding to the second column identifier identical to the first column identifier is determined as coded attribute of the column data.

[0014] The first column identifier of column data in the table data is compared with the third column identifier of custom attribute in the custom attribute information, and custom attribute corresponding to the third column identifier identical to the first column identifier is determined as custom attribute of the column data.

[0015] The coded attribute and the custom attribute of each column data in the table data are used to render and display the column data corresponding to the coded attribute and the custom attribute respectively.

[0016] Optionally, in a case where it is determined that the local database caches the target table and does not cache the custom attribute information, the rendering and display of the table data by using the custom attribute information and the coded attribute information, and the rendering of the table configuration component in the display page, include:

[0017] The table data is rendered and displayed by using the coded attribute information, and the table configuration component is rendered in the display page.

[0018] Optionally, in a case where it is determined that the local database does not cache the target table and the custom attribute information, the method further includes:

[0019] An interface request is sent to query whether the custom attribute information is included in a remote database.

[0020] In a case where the custom attribute information is included in the remote database, table data of the target table and the custom attribute information in the remote database are obtained and stored in the local database.

[0021] In a case where the custom attribute information is not included in the remote database, table data of the target table in the remote database is obtained and stored in the local database.

[0022] The table data is rendered and displayed by the custom attribute information and the encoding attribute information, and a table configuration component is rendered in a display page, including:

[0023] The table data is rendered and displayed by the encoding attribute information, and a table configuration component is rendered in a display page.

[0024] Optionally, the method further comprises:

[0025] According to the custom attribute identifier of each custom attribute information, the user type corresponding to each custom attribute information and the table corresponding to each custom attribute information are determined;

[0026] By statistical analysis of the custom attribute information belonging to the same user type and belonging to the same table, the commonly used custom attribute information of each table for the same user type is determined;

[0027] Through the table configuration component, the commonly used custom attribute information of the current rendered table for the user of the same user type as the user who currently initiates the table display request is recommended.

[0028] Optionally, the method further comprises:

[0029] In response to the user selecting a pre-designed calculation type in the table configuration component, the selected region of the table data selected by the user is calculated according to the pre-designed calculation type, and the calculation result is displayed.

[0030] Optionally, the method further comprises:

[0031] In response to the user's custom operation on the displayed table data through the table configuration component, the table data is correspondingly custom adjusted;

[0032] According to the table identifier and the user identifier, the custom attribute information corresponding to the custom adjustment is marked with a corresponding custom attribute identifier;

[0033] The marked custom attribute information is stored in a local database and a remote database.

[0034] Optionally, the method further comprises:

[0035] Real-time monitoring of whether the remote database receives new custom attribute information;

[0036] In the case of receiving new custom attribute information, the user type corresponding to the new custom attribute information and the table corresponding to the new custom attribute information are determined;

[0037] According to the user type corresponding to the new custom attribute information and the corresponding table, the commonly used custom attribute information for the corresponding table under the corresponding user type is updated.

[0038] The second aspect of the embodiment of the application provides a system for customizing a table, and the system comprises:

[0039] An identification determining module is configured to determine a table identification of a target table requested to be displayed and a user identification of a target user initiating the table display request according to the table display request.

[0040] An attribute information determining module is configured to determine table data of the target table cached in a local database and custom attribute information of the target user for the target table according to the table identification and the user identification, and determine coding attribute information of the target table in coding.

[0041] A rendering display module is configured to render and display the table data through the custom attribute information and the coding attribute information, and render a table configuration component in a display page, the table configuration component being a custom component for the user to display the displayed table.

[0042] The method for customizing a table provided by the application has the following advantages:

[0043] The method for customizing a table provided by the embodiment of the application is configured to determine a table identification of a target table requested to be displayed and a user identification of a target user initiating the table display request according to the table display request, determine table data of the target table cached in a local database and custom attribute information of the target user for the target table according to the table identification and the user identification, and determine coding attribute information of the target table in coding, render and display the table data through the custom attribute information and the coding attribute information, and render a table configuration component in a display page, the table configuration component being a custom component for the user to display the displayed table.

[0044] Thus, the application first determines the specific table (i.e., the target table) to be displayed and who (i.e., the target user) to display the specific table based on the table display request, and then finds the table data of the target table and the custom attribute information of the target table for the user initiating the table display request in the local browser database. At the same time, in order to reduce the cache amount of the local browser database for a single table, thereby improving the cache amount of the local browser database for tables as a whole, other properties of the table that can be determined from the front-end code (such as column display name, column area rendering method, and the like, for example, the method of defining the column area as a button) are not cached in the local browser database, but the other properties of the target table that can be determined from the front-end code (i.e., the coding attribute information of the target table) are found in the code based on the table identifier of the target table. Then, the table data of the target table is rendered based on the custom attribute information of the target table determined from the local browser database and the coding attribute information of the target table determined from the code, and a table configuration component is rendered in the displayed page, which is used for the user to further customize the display of the displayed table. In this way, the user can customize the display of the table based on his own needs (such as displaying the data of some columns, hiding the data of some columns, freezing the data of some columns, etc.), thereby showing the user the table data that he is more concerned about, improving the user's work efficiency and user experience, and at the same time, storing the table data and custom attribute information in the local browser database can avoid frequent interface requests to the remote database in the back end to request table data and custom attribute information, thereby saving resources. BRIEF DESCRIPTION OF DRAWINGS

[0045] In order to more clearly illustrate the technical solutions of the embodiments of the application, the following will briefly introduce the drawings needed to be used in the description of the embodiments of the application. Obviously, the drawings in the following description are only some embodiments of the application, and other drawings can also be obtained by those skilled in the art without creative labor.

[0046] Figure 1 A flowchart of a method for customizing and configuring a table according to an embodiment of the application is shown.

[0047] Figure 2 A flowchart of rendering a table and a component in a method for customizing and configuring a table according to an embodiment of the application is shown.

[0048] Figure 3 A flowchart of component customization in a method for customizing and configuring a table according to an embodiment of the application is shown.

[0049] Figure 4A schematic diagram of a system for customizing a configuration table according to an embodiment of the present application. DETAILED DESCRIPTION

[0050] With reference to the accompanying drawings, the technical solutions in the embodiments of the present application will be clearly and completely described below. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all the embodiments of the present application. Based on the embodiments of the present application, all other embodiments obtained by those of ordinary skill in the art without creative effort should fall within the scope of the present application.

[0051] Reference Figure 1 , Figure 1 A flowchart of a method for customizing a configuration table according to an embodiment of the present application is shown in FIG. 2. As shown in FIG. 2, the method comprises the following steps. Figure 1

[0052] Step S1: According to a table display request, determining a table identifier of a target table requested to be displayed and a user identifier of a target user initiating the table display request.

[0053] In the embodiment, a user initiates a table display request through a browser of a terminal device, the table display request carries a table identifier of a table requested to be displayed, the table is the target table, and the table display request carries a user identifier of the user initiating the table display request, the user is the target user. The table identifier has a unique corresponding relationship with the table, for example, a table A1 corresponds to a table identifier a1, and the table identifier carried in the table display request of any user requesting to display the table A1 is the table identifier a1; the user identifier has a unique corresponding relationship with the user, for example, a user B1 corresponds to a user identifier b1, and the user identifier carried in the table display request of the user B1 initiating the table display request for any table is the user identifier b1. The user identifier of a user can be determined based on relevant information that is unique in the account information of the user logging into the account of the user and does not involve personal information. The table identifier and the user identifier carried in the received table display request are determined, the table identifier is used to point to the table requested to be displayed in the table display request, the table is the target table, and the user identifier is used to point to the user initiating the table display request, the user is the target user.

[0054] For example, the user B1 logs into the account of the user, and then initiates a table display request for requesting to display the table A1 through the browser of the terminal device, the table display request carries the table identifier a1 and the user identifier b1, the table identifier a1 is used to determine that the user wants to request to display the table A1, and the user identifier b1 is used to determine that the user B1 requests to display the table A1. ​

[0055] Step S2: According to the table identifier and the user identifier, determine the table data of the target table cached in the local database and the custom attribute information of the target table customized by the target user, and determine the encoding attribute information of the target table in the encoding.

[0056] In this embodiment, after determining the table identifier and the user identifier in the table display request, the table data of the target table and the custom attribute information of the display mode customized by the user for the target table are queried and obtained from the local browser database based on the table identifier and the user identifier. At the same time, the encoding attribute information of the target table in the encoding is determined based on the table identifier.

[0057] Step S3: Render and display the table data through the custom attribute information and the encoding attribute information, and render a table configuration component in the display page, the table configuration component being a component customized by the user for the display of the table.

[0058] In this embodiment, after obtaining the custom attribute information for the target table and the table data of the target table from the local browser database, and determining the encoding attribute information for the target table in the encoding, the table data of the requested target table is rendered and displayed through the custom attribute information and the encoding attribute information. At the same time, a table configuration component is rendered in the web page displaying the table data of the target table, the table configuration component being a component for the custom operation of the user for the display of the table. The user can perform custom operation for the display of the table data of the target table through the operation of the table configuration component. For example, through the operation of the table configuration component by the user, the data of some columns in the displayed table data of the target table can be hidden, the data of some columns in the displayed table data of the target table can be frozen, the data of some columns in the displayed table data of the target table can be sorted, etc. The encapsulated table configuration component is fixed in the upper right corner or the upper left corner of the table. The table configuration component can be displayed by clicking the icon in the upper right corner or the upper left corner, and the table configuration component can be hidden by clicking other places.

[0059] The method for customizing and configuring a table provided by the embodiment of the present application comprises the following steps: determining the table identifier of a target table and the user identifier of a target user who initiates a table display request according to the table display request; determining the table data of the target table cached in a local database and the custom attribute information of the target table by the target user according to the table identifier and the user identifier, and determining the encoding attribute information of the target table in the encoding; and rendering and displaying the table data according to the custom attribute information and the encoding attribute information, and rendering a table configuration component in a display page, wherein the table configuration component is a custom component for the target user to customize the display of the target table.

[0060] Therefore, the present application first determines the specific table (i.e., the target table) to be displayed and who (i.e., the target user) to display the specific table according to the table display request, and then finds the table data of the target table and the custom attribute information of the target table by the user who initiates the table display request in the local browser database. In order to reduce the cache amount of the local browser database for a single table and improve the overall cache amount of the local browser database for tables, other attributes of the table (such as column display name, column area rendering method, etc.) that can be determined from the front-end encoding are not cached in the local browser database, but the table identifier of the target table is used to find the other attributes of the target table (i.e., the encoding attribute information of the target table) in the encoding. Then, the table data of the target table is rendered based on the custom attribute information of the target table determined from the local browser database and the encoding attribute information of the target table determined from the encoding, and a table configuration component is rendered in the display page, which is used for the target user to further customize the display of the target table. In this way, the target user can customize the display of the target table according to his own needs (such as displaying the data of some columns, hiding the data of some columns, freezing the data of some columns, etc.), so as to show the target user the table data that he is more concerned about, thereby improving the work efficiency and user experience of the target user. Meanwhile, storing the table data and the custom attribute information in the local browser database can avoid frequently initiating an interface request to the remote database in the back end to request the table data and the custom attribute information, thereby saving resources.

[0061] In combination with the above embodiment, in an implementation manner, the embodiment of the present application further provides a method for customizing and configuring a table. In the method for customizing and configuring a table, step S2 can comprise steps S21 to S23:

[0062] Step S21: determining the table data of a target table corresponding to the table identifier cached in a local database according to the table identifier.

[0063] In the embodiment, when the table data of the table is cached in the local browser database, the table identifier of the table is cached simultaneously. Therefore, after the table identifier of the target table in the table display request is determined, the cached table data in the local browser database is searched based on the table identifier of the target table, so that the table data recorded with the table identifier of the target table in the local browser database is determined, and the table data is the table data of the target table.

[0064] Step S22: determining a target identifier matching the table identifier and the user identifier simultaneously based on the table identifier and the user identifier.

[0065] In the embodiment, after the table identifier and the user identifier in the table display request are determined, a target identifier matching the table identifier and the user identifier simultaneously is determined based on the table identifier and the user identifier. An optional implementation is to splice the table identifier and the user identifier directly to obtain a target identifier matching the table identifier and the user identifier simultaneously. The target identifier is used to determine the custom attribute information of the table corresponding to the table identifier customized by the user corresponding to the user identifier.

[0066] Step S23: comparing the target identifier with the custom attribute identifiers of the custom attribute information cached in the local database, and determining that the custom attribute information corresponding to the custom attribute identifier same as the target identifier is the custom attribute information of the target table customized by the target user.

[0067] In the embodiment, the custom attribute information is the attribute information of a specific table recorded by a specific user after a custom display configuration of the specific table is configured, for example, the custom display configuration of sorting the specific table and the custom display configuration of hiding the third column data in the specific table. The custom attribute information corresponding to the two custom display configurations is generated. When the user displays the specific table subsequently, the specific table is sorted and the third column data in the specific table is hidden based on the custom attribute information. The application sets the custom attribute identifier corresponding to each custom attribute information. The custom attribute identifier is used to distinguish the custom attribute information configured by which user identifier and the custom attribute information of which table.

[0068] In the embodiment, after determining the target identifier matching the table identifier and the user identifier in the table display request, the target identifier is compared with the custom attribute identifiers of the custom attribute information cached in the local browser database, a custom attribute identifier same as the target identifier is determined, and then the custom attribute information corresponding to the custom attribute identifier is determined as the custom attribute information configured by the target user corresponding to the user identifier for the target table corresponding to the table identifier. The custom display of the table in the custom attribute information includes but is not limited to sorting the columns in the table, freezing the columns in the table, displaying or hiding the columns in the table.

[0069] In combination with the above embodiments, in an implementation, the embodiment of the present application further provides a method for customizing and configuring a table. In the method for customizing and configuring a table, step S3 can include steps S31 to S33.

[0070] Step S31: comparing the first column identifier of the column data in the table data with the second column identifier of the encoding attribute in the encoding attribute information, and determining that the encoding attribute corresponding to the second column identifier same as the first column identifier as the encoding attribute of the column data.

[0071] In the embodiment, the column data of each column in the table data in the present application is composed of a key-value pair. The value in the key-value pair of the column data of one column in one table represents the column data content of the column in the table, and the key in the key-value pair represents the identifier of the column in the table, that is, the first identifier of the column data of the column, which is used to distinguish different columns in the table. For example, the table A1 includes 3 column data, the key of the column data of the first column is set as x1, the key of the column data of the second column is set as x2, and the key of the column data of the third column is set as x3.

[0072] Meanwhile, the encoding attribute information in the present application includes the encoding attribute configured for the column data of each column in the table, and the corresponding identifier, that is, the second column identifier, is set for each encoding attribute, which is used to distinguish each column to which each encoding attribute in the encoding attribute information is directed. For example, the encoding attribute information includes the encoding attribute for the 3 column data in the table A1, the column data of the first column in the table A1 has a corresponding encoding attribute p1, and the identifier x1 is set for the encoding attribute p1; the column data of the second column in the table A1 has a corresponding encoding attribute p2, and the identifier x2 is set for the encoding attribute p2; and the column data of the third column in the table A1 has a corresponding encoding attribute p3, and the identifier x3 is set for the encoding attribute p3.

[0073] In the embodiment, after obtaining the table data of the target table, the first column identifier of the column data of each column in the table data is compared with the second column identifier of the encoding attribute configured for the column data of each column in the encoding attribute information determined in step S2. In the case that the first column identifier of the column data of one column is the same as the second column identifier of one encoding attribute, it is determined that the encoding attribute is the encoding attribute of the column data of the column. Thus, for the column data of each column in the table data of the target table, the corresponding encoding attribute is determined to be the encoding attribute configured for itself.

[0074] For example, the table Al includes 3 column data, the first column identifier x1 is set for the column data of the first column, the first column identifier x2 is set for the column data of the second column, and the first column identifier x3 is set for the column data of the third column; the encoding attribute information for encoding attribute configuration of the table Al includes the encoding attributes for the 3 column data in the table Al, the second column identifier x1 is set for the encoding attribute pl configured for the column data of the first column in the table Al, the second column identifier x2 is set for the encoding attribute p2 configured for the column data of the second column in the table Al, and the second column identifier x3 is set for the encoding attribute p3 configured for the column data of the third column in the table Al. The first column identifier of the column data of each column in the table Al is compared with the second column identifier of each encoding attribute in the encoding attribute information for encoding attribute configuration of the table Al, it is determined that the first column identifier of the column data of the first column in the table Al is the same as the second column identifier of the encoding attribute pl, thus it is determined that the encoding attribute pl is the encoding attribute configured for the column data of the first column in the table Al; it is determined that the first column identifier of the column data of the second column in the table Al is the same as the second column identifier of the encoding attribute p2, thus it is determined that the encoding attribute p2 is the encoding attribute configured for the column data of the second column in the table Al; it is determined that the first column identifier of the column data of the third column in the table Al is the same as the second column identifier of the encoding attribute p3, thus it is determined that the encoding attribute p3 is the encoding attribute configured for the column data of the third column in the table Al.

[0075] Step S32: comparing the first column identifier of the column data in the table data with the third column identifier of the custom attribute in the custom attribute information, and determining that the custom attribute corresponding to the third column identifier same as the first column identifier is the custom attribute of the column data.

[0076] In the embodiment, the custom attribute information in the application includes custom attributes configured for column data of each column, and a corresponding representation is set for each custom attribute, that is, a third identifier, which is used to distinguish each column to which each custom attribute in the custom attribute information is directed. For example, the custom attribute information includes custom attributes for column data of the first column and column data of the third column in the three column data in the table A1, and the custom attribute q1 corresponding to the column data of the first column in the table A1 is set with the identifier x1; the custom attribute q3 corresponding to the column data of the third column in the table A1 is set with the identifier x3.

[0077] In the embodiment, after obtaining the table data of the target table, the first identifier of the column data of each column in the table data is compared with the third column identifier of the custom attribute of the column data of each column in the custom attribute information determined in step S2. In the case that the first identifier of the column data of one column is the same as the third column identifier of one custom attribute, it is determined that the custom attribute is the custom attribute of the column data of the column. Thus, for the column data of each column in the table data of the target table, if there is a corresponding custom attribute, the custom attribute used for configuration of itself will be determined.

[0078] For example, the table A1 includes three column data, the first identifier x1 is set for the column data of the first column, the first identifier x2 is set for the column data of the second column, and the first identifier x3 is set for the column data of the third column; the custom attribute information used for custom attribute configuration of the table A1 includes custom attributes for column data of the first column and column data of the third column in the three column data in the table A1, and the custom attribute q1 used for configuration of the column data of the first column in the table A1 is set with the third identifier x1, and the custom attribute q3 used for configuration of the column data of the third column in the table A1 is set with the third identifier x3. The first identifier of the column data of each column in the table A1 is compared with the third identifier of each custom attribute in the custom attribute information used for custom attribute configuration of the table A1, it is determined that the first identifier of the column data of the first column in the table A1 is the same as the third identifier of the custom attribute q1, and thus it is determined that the custom attribute q1 is the custom attribute used for configuration of the column data of the first column in the table A1; it is determined that the first identifier of the column data of the third column in the table A1 is the same as the third identifier of the custom attribute q3, and thus it is determined that the custom attribute q3 is the custom attribute used for configuration of the column data of the third column in the table A1.

[0079] Step S33: rendering and displaying each corresponding column data respectively with the encoding attribute and the custom attribute of each column data in the table data.

[0080] In the embodiment, after the encoding attribute and the custom attribute of the column data of each column in the table data of the target table are determined through the steps S31 and S32, the column data of each column is rendered and displayed based on the corresponding encoding attribute and custom attribute.

[0081] For example, continuing with the example in the steps S31 and S32, for the column data of the three columns in the table A1, it is determined that the column data of the first column includes the corresponding encoding attribute p1 and custom attribute q1, the column data of the second column includes the corresponding encoding attribute p2, and the column data of the third column includes the corresponding encoding attribute p3 and custom attribute q3. Therefore, when the table A1 is rendered and displayed, the column data of the first column in the table A1 is rendered and displayed based on the encoding attribute p1 and custom attribute q1, the column data of the second column in the table A1 is rendered and displayed based on the encoding attribute p2, and the column data of the third column in the table A1 is rendered and displayed based on the encoding attribute p3 and custom attribute q3, so as to obtain the final rendering and display result of the table A1.

[0082] In combination with the above embodiments, in an implementation, the embodiment of the present application further provides a method for customizing and configuring a table. In the method for customizing and configuring a table, in a case where it is determined that the target table is cached in the local database and the custom attribute information is not cached, the step S3 can include: rendering and displaying the table data based on the encoding attribute information, and rendering a table configuration component in a display page.

[0083] In the embodiment, the custom attribute information of the table customized by the user in the present application is generated after the user performs corresponding custom display configuration on the table through operation on the rendered table configuration component in a case where the table is rendered and displayed. The custom attribute information is stored in the local browser database of the current terminal of the user and the remote database of the backend at the same time. In a case where it is determined that the table data of the target table is cached in the local browser database based on the table identifier and the user identifier in the table display request, and the custom attribute information of the target table customized by the user corresponding to the target user identifier is not cached, it is determined that the user has rendered and displayed the table data of the target table in the current terminal but has not performed custom operation on the display of the target table (such as hiding the column data of a specific column in the target table or freezing the column data of a specific column in the target table, etc.). At this time, the table data of the target table is directly rendered and displayed based on the determined encoding attribute information corresponding to the target table, and a table configuration component is rendered in a display page to provide a port for the user to perform custom operation on the currently displayed table data.

[0084] In combination with the above embodiments, in an implementation, the embodiments of the present application further provide a method for customizing a table. In the method for customizing a table, in a case where it is determined that the local database does not cache the target table and the custom attribute information, the method further includes:

[0085] Step S01: querying, through an interface, whether the custom attribute information is included in the remote database.

[0086] In the present embodiment, as shown in Figure 2 Figure 2 A flowchart of rendering a table and components in a method for customizing a table according to an embodiment of the present application is shown. Based on the table identifier and the user identifier in the table display request, it is determined that the table data of the target table is not cached in the local browser database, and the custom attribute information of the target user corresponding to the user identifier for the target table is not cached. In this case, it is determined that the target user corresponding to the user identifier does not request to display the target table through the current browser in the current terminal. Since the table data needs to be displayed and is necessarily stored in the remote database in the backend, at this time, it is only necessary to query, through an interface, whether the custom attribute information of the target user corresponding to the user identifier for the target table is included in the remote database in the backend.

[0087] In the present embodiment, in a case where the user replaces a browser and makes a first request for displaying a specific table, the local browser database corresponding to the replaced browser will not cache the table data of the specific table and the custom attribute information of the user for the specific table. At this time, the table data of the specific table and the custom attribute information of the user for the specific table stored in the remote database in the backend are directly queried through an interface.

[0088] Step S02: in a case where the custom attribute information is included in the remote database, obtaining the table data of the target table and the custom attribute information in the remote database and storing them in the local database.

[0089] In the present embodiment, as shown in Figure 2 ​In the case that it is determined that the custom attribute information of the target user for the target table is included in the remote database of the backend, the table data of the target table and the custom attribute information of the target user for the target table are acquired from the remote database of the backend, and the acquired table data of the target table and the acquired custom attribute information of the target user for the target table are stored in the local browser database while being used for rendering and display. It should be understood that the implementation of querying the table data of the target table and the custom attribute information of the target user for the target table in the remote database of the backend is the same as the implementation of querying the table data of the target table and the custom attribute information of the target user for the target table in the local browser database, which will not be repeated here. After the table data of the target table and the custom attribute information of the target user for the target table are acquired and the corresponding coding attribute information of the target table is determined, corresponding rendering and display are performed.

[0090] Step S03: In the case that the custom attribute information is not included in the remote database, the table data of the target table in the remote database is acquired and stored in the local database.

[0091] In the embodiment, as shown in Figure 2 In the case that it is determined that the custom attribute information of the target user for the target table is not included in the remote database of the backend, only the table data of the target table is acquired from the remote database of the backend, and the acquired table data of the target table is stored in the local browser database while being used for rendering and display.

[0092] In the case that the method for customizing and configuring a table provided in the present application further includes step S03, step S3 includes: rendering and displaying the table data according to the coding attribute information, and rendering a table configuration component in a display page.

[0093] In the embodiment, as shown in Figure 2 In the case that only the table data of the target table is acquired from the remote database of the backend and the corresponding coding attribute information of the target table is determined, the table data of the target table is rendered and displayed, and a table configuration component is rendered in a display page.

[0094] In combination with the above embodiments, in an implementation, the embodiments of the present application further provide a method for customizing and configuring a table. In the method for customizing and configuring a table, the method further includes:

[0095] Step S4: determining the user type and the table corresponding to each custom attribute information according to the custom attribute identifier of each custom attribute information.

[0096] In the embodiment, the custom attribute identifier of the custom attribute information is generated based on the table identifier and the user identifier corresponding to the custom attribute information, and the custom attribute identifier of one custom attribute information records the table identifier and the user identifier corresponding to the custom attribute information. The user type field is set in the user identifier of the user, so as to distinguish the user types of different users, and the purpose of distinguishing the user types of different users is to accurately determine the commonly used custom attribute information subsequently. Different user types can be different departments of users, different age groups of users, different personality categories of users, and other types, which are not limited here.

[0097] In the embodiment, the custom attribute information stored in the remote database of the backend is the most complete, and the application determines the user type to which each custom attribute information belongs based on the user identifier in the custom attribute identifier of each custom attribute information, and determines the table to which each custom attribute information belongs based on the table identifier in the custom attribute identifier of each custom attribute information.

[0098] For example, the custom attribute information Z1 to Z3 in the remote database of the backend is obtained, the user type of the user to which the custom attribute information Z1 belongs is determined to be the user of b1 department based on the user identifier in the custom attribute identifier U1 in the custom attribute information Z1, and the custom attribute information is the custom attribute information for table a1; the user type of the user to which the custom attribute information Z2 belongs is also determined to be the user of b1 department based on the user identifier in the custom attribute identifier U2 in the custom attribute information Z2, and the custom attribute information is also the custom attribute information for table a1; the user type of the user to which the custom attribute information Z3 belongs is determined to be the user of b2 department based on the user identifier in the custom attribute identifier U3 in the custom attribute information Z3, and the custom attribute information is the custom attribute information for table a3.

[0099] Step S5: The commonly used custom attribute information of each table for the same user type is determined by statistical analysis of the custom attribute information belonging to the same user type and belonging to the same table.

[0100] In the embodiment, after determining the user type corresponding to each custom attribute information and the table corresponding to each custom attribute information in step S4, statistical analysis is performed on all the custom attribute information. The principle of the statistical analysis is to divide the custom attribute information belonging to the same user type and belonging to the same table into the same set. Therefore, the records in the same set are all the custom attribute information of all users of a certain user type for a certain table. Then, statistical analysis is performed on the custom attributes of the column data of the same column in all the custom attribute information in the same set. The most common custom attribute of the column data of the same column is determined as the common custom attribute of the column data of the same column. Thus, a corresponding common custom attribute is obtained for the column data of each column in the table corresponding to the custom attribute information in the set. Then, the common custom attribute information of all the columns is determined as the common custom attribute information of the table corresponding to the set for the users of the user type corresponding to the set.

[0101] For example, by performing statistical analysis on all the custom attribute information obtained from the remote database, all the custom attribute information of the users belonging to user type b for table a is obtained, including Z1 to Z3. The custom attribute information Z1 to Z3 is divided into the same set. Table a includes 3 column data. The custom attribute of the first column data of table a in custom attribute information Z1 is q3, the custom attribute of the second column data of table a is q2, and the custom attribute of the third column data of table a is q1. The custom attribute of the first column data of table a in custom attribute information Z2 is q3, the custom attribute of the second column data of table a is q2, and the custom attribute of the third column data of table a is q1. The custom attribute of the first column data of table a in custom attribute information Z3 is q3, the custom attribute of the second column data of table a is q1, and the custom attribute of the third column data of table a is q1. Then, statistical analysis is performed on the custom attributes of the column data of the same column in the custom attribute information in the set to obtain the corresponding result. The result is that the most common custom attribute of the first column data of table a in all the custom attribute information of the users of user type b for table a is custom attribute q3, the most common custom attribute of the second column data of table a is custom attribute q2, and the most common custom attribute of the third column data of table a is custom attribute q1. Therefore, the custom attribute q3 of the first column data of table a, the custom attribute q2 of the second column data of table a, and the custom attribute q1 of the third column data of table a are collectively determined as the common custom attribute information of table a for user type b.

[0102] Step S6: recommending, by the table configuration component, the commonly used custom attribute information of the same user type as the user to the user who initiates the table display request currently.

[0103] In the embodiment, after determining the commonly used custom attribute information of the same user type to the same table through step S5, when a user initiates a table display request through a browser currently, the user type of the user is determined based on the user identifier in the table display request, and the table requested by the user is determined based on the table identifier in the table display request. Then, the table configuration component is rendered and displayed while rendering and displaying the requested table for the user, and the corresponding commonly used custom attribute information is recommended to the user in the table configuration component. The commonly used custom attribute information is of the same user type as the user type of the user, and the table to which the commonly used custom attribute information is directed is the table requested by the user.

[0104] For example, a user of user type b requests to display table a through a browser, and the table configuration component is rendered and displayed while rendering and displaying the requested table a for the user, and the commonly used custom attribute information of user type b to table a is recommended to the user in the table configuration component.

[0105] In combination with the above embodiments, in an implementation, the embodiment of the present application further provides a method for customizing and configuring a table. In the method for customizing and configuring a table, the method further includes: in response to a user selecting a pre-designed calculation type in the table configuration component, performing calculation of the selected area of the table data selected by the user according to the pre-designed calculation type, and displaying the calculation result.

[0106] In the embodiment, the present application sets multiple pre-designed calculation types in the table configuration component, such as Figure 3 As shown in the table, first, the table configuration component is rendered and displayed, when a user needs to perform calculation on a specified column, the specified column is checked, then the range of the row area in the specified column that needs to be calculated (for example, the 3rd column includes 10 rows, and the input is to perform calculation on the 1st to 8th rows) is input, then the corresponding pre-designed calculation type in the table configuration component is selected, the calculation of the selected pre-designed calculation type is performed, and the obtained calculation result is displayed on the display page to facilitate the user to perform data statistics and analysis. At this time, the calculation result is only feedback to the user about the calculation result of the selected area, and will not edit and change the table data rendered and displayed. The pre-designed calculation type includes but is not limited to summation, average value, maximum value, minimum value, etc., and the calculation type formula is as follows: summation = eval(initial row of selected column + … end row of selected column); maximum value = Math.max(data1, data2…data n).

[0107] In the embodiment, the table configuration component is divided into three areas, as shown in Figure 3 , Figure 3 The flowchart of the component customization in the method of customizing a table shown in an embodiment of the present application, the first area is a recommendation area, after the user requests to display a specific table, the recommendation area recommends the user with the commonly used customized attribute information of the specific table to the users belonging to the same user type as the user, to facilitate one-key reuse and reduce complex display configuration operations; the second area is a column function area, rendering all table columns, reordering the columns by dragging the table columns, such as dragging a column at the back of the table to the first column, to facilitate column operations to change the display order of the columns, defining column sorting fields to facilitate subsequent sorting, configuring a checkbox for each column to configure the display / hide function of the column through the checkbox, configuring a switch for each column to realize the freezing function of the column through the opening and closing operations of the switch; the third area is a calculation area, pre-designing calculation types, the user selecting the calculation type and columns that need to be calculated, inputting the row range of the calculation (defaulting to selecting all rows of the column), and automatically performing data calculation and displaying the results.

[0108] In combination with the above embodiments, in an implementation, the embodiment of the present application further provides a method of customizing a table. In the method of customizing a table, the method further includes:

[0109] Step S7: in response to the user's customizing operation on the displayed table data through the table configuration component, performing corresponding customizing adjustment on the table data.

[0110] In the embodiment, after rendering and displaying the table data and the table configuration component in the page, the user can perform corresponding customizing display operation on the displayed table through the operation of the table configuration component, such as hiding some column data, freezing some column data, etc. In response to the user's customizing display operation on the displayed table data through the table configuration component, the displayed table data is correspondingly customized and adjusted, and the corresponding customized attribute information is generated.

[0111] Step S8: according to the table identifier and the user identifier, performing corresponding customizing attribute identifier annotation on the customized attribute information.

[0112] In the embodiment, in the case that the user requests to display a table for the first time and performs customizing display operation on the table for the first time, the table identifier and the user identifier in the table display request initiated by the user are used to perform corresponding customizing attribute identifier annotation on the customized attribute information generated after the user performs corresponding customizing display operation on the displayed table through the operation of the table configuration component.

[0113] Step S9: store the labeled custom attribute information into the local database and the remote database.

[0114] In this embodiment, after the custom attribute identification of the custom attribute information is labeled through step S8, the labeled custom attribute information with the custom attribute identification is stored into the local browser database and the remote database in the backend.

[0115] In this embodiment, in the case that the custom attribute information of the table displayed according to the current user request is cached in the database, when the user performs the corresponding custom display operation on the displayed table through the table configuration component, the displayed table data is first adjusted correspondingly, and the corresponding custom attribute information is generated, then the custom attribute information matching the table identification and the user identification in the database is determined based on the table identification and the user identification in the user-initiated table display request, and finally the generated custom attribute information is merged into the matched custom attribute information.

[0116] For example, the custom attribute information Z of the table a displayed according to the user b request is cached in the database, when the user performs the corresponding custom display operation on the displayed table a through the table configuration component, the displayed table data is first adjusted correspondingly, and the corresponding custom attribute information Z0 is generated, then the custom attribute information Z matching the table identification and the user identification in the database is determined based on the table identification and the user identification in the user-initiated table display request, and finally the generated custom attribute information Z0 is stored into the database and merged into the matched custom attribute information Z.

[0117] In combination with the above embodiments, in an implementation, the embodiments of the present application further provide a method for customizing and configuring a table. In the method for customizing and configuring a table, the method further comprises:

[0118] Step S001: monitor whether the remote database receives new custom attribute information in real time.

[0119] In this embodiment, the new custom attribute information is stored into the remote database in the backend synchronously, and the present application monitors whether the remote database receives the new custom attribute information in real time. The new custom attribute information can be the custom attribute information updated after the user performs a new custom display operation, or can be the initial custom attribute information.

[0120] Step S002: in the case that the new custom attribute information is received, determine the corresponding user type and the corresponding table of the new custom attribute information.

[0121] In the embodiment, based on the custom attribute identifier in the new custom attribute information, the user type corresponding to the new custom attribute information and the corresponding table are determined.

[0122] Step S003: updating the commonly used custom attribute information for the corresponding table under the corresponding user type according to the user type corresponding to the new custom attribute information and the corresponding table.

[0123] In the embodiment, after the user type corresponding to the new custom attribute information and the corresponding table are determined, the set of all custom attribute information for the corresponding table under the corresponding user type will also change, at this time, the set of all custom attribute information for the corresponding table under the corresponding user type is re-analyzed to obtain the new commonly used custom attribute information for the corresponding table under the corresponding user type, and the statistical analysis method is the same as the above statistical analysis method, which will not be described here. Thus, the commonly used custom attribute information of the user under the same user type for the same table can be updated in real time, so as to ensure that the commonly used custom attribute information recommended for the user can more accurately reflect the table display mode concerned by the user type to which the user belongs.

[0124] The method for customizing a table provided by the application can effectively improve the work efficiency of a user, the user can customize the display of each column of a displayed table, including customizing the display / hiding of a table column, displaying attention data, and hiding redundant data; the sorting of a table column is performed through a drag operation, and the data of interest is moved to a front position; a configuration option is selected to select a frozen column as a reference for other data columns; the corresponding custom attribute information generated after the user customizes the display of the table is stored, the commonly used custom attribute information of the same table for the same user type is counted according to the user type, and then the commonly used custom attribute information is recommended to the user of the corresponding user type, so as to reduce the burden of the user of the same user type for repeatedly configuring the display of the table, and the user can reuse one key; a calculation attribute area is selected to select a calculation type and a column to be calculated, and the result is automatically calculated and displayed; the storage of the custom attribute information is performed through a local browser database, when a user renders a table for the first time, the local browser database is first queried to check whether the custom attribute information of the corresponding user for the table exists, if not, a backend database is queried, so as to avoid frequent interface requests and save resources. Avoid storing too much data, waste local browser database and backend remote database storage resources, each time the table is stored, only the important attributes of the table column, such as the identification, order, display / hide, and whether to freeze, are stored, and the remaining attributes (column name, area rendering method, etc.) are not stored, only the column identification and the coding attribute of each column of the table in the table data in the database need to be compared to determine the coding attribute (i.e. the remaining attributes mentioned above) of each column.

[0125] Based on the same inventive concept, an embodiment of the application provides a system for customizing a table, as shown in Figure 4 Figure 4 A schematic diagram of a system for customizing a table is shown in an embodiment of the application, the system 400 comprises:

[0126] An identification determination module 401 is configured to determine the table identification of a target table requested to be displayed and the user identification of a target user who initiates a table display request according to the table display request;

[0127] An attribute information determination module 402 is configured to determine the table data of the target table cached in a local database and the custom attribute information of the target table of the target user according to the table identification and the user identification, and determine the coding attribute information of the target table in coding;

[0128] ​The rendering display module 403 is configured to render and display the table data according to the custom attribute information and the encoding attribute information, and render a table configuration component in a display page, the table configuration component being a component customized by a user for displaying the displayed table.

[0129] Optionally, the attribute information determination module 402 comprises:

[0130] The table data determination module is configured to determine, according to the table identifier, table data of a target table corresponding to the table identifier in a local database cache.

[0131] The target identifier determination module is configured to determine a target identifier that matches both the table identifier and the user identifier.

[0132] The attribute information determination sub-module is configured to compare the target identifier with custom attribute identifiers of each custom attribute information in the local database cache, and determine custom attribute information corresponding to a custom attribute identifier identical to the target identifier as custom attribute information of the target table customized by the target user.

[0133] Optionally, the rendering display module 403 comprises:

[0134] The encoding attribute determination module is configured to compare a first column identifier of column data in the table data with a second column identifier of an encoding attribute in the encoding attribute information, and determine an encoding attribute corresponding to the second column identifier identical to the first column identifier as an encoding attribute of the column data.

[0135] The custom attribute determination module is configured to compare a first column identifier of column data in the table data with a third column identifier of a custom attribute in the custom attribute information, and determine a custom attribute corresponding to the third column identifier identical to the first column identifier as a custom attribute of the column data.

[0136] The rendering display sub-module is configured to render and display each column data in the table data according to the encoding attribute and the custom attribute of the column data, respectively.

[0137] Optionally, the rendering display module 403 is configured to render and display the table data according to the encoding attribute information, and render a table configuration component in a display page, in a case where it is determined that the local database caches the target table and does not cache the custom attribute information.

[0138] Optionally, the system 400 further comprises:

[0139] The self-defined attribute information determination module is configured to, in a case where it is determined that the local database does not cache the target table and the self-defined attribute information, request, through an interface, whether the self-defined attribute information is included in the remote database;

[0140] The first obtaining module is configured to, in a case where the remote database includes the self-defined attribute information, obtain table data of the target table and the self-defined attribute information in the remote database and store them in the local database.

[0141] The second obtaining module is configured to, in a case where the remote database does not include the self-defined attribute information, obtain table data of the target table in the remote database and store them in the local database.

[0142] The rendering and displaying module 403 is configured to, in a case where only the table data of the target table is obtained from the remote database, render and display the table data through the coding attribute information, and render a table configuration component in a display page.

[0143] Optionally, the system 400 further includes:

[0144] The corresponding relationship determination module is configured to determine, according to self-defined attribute identifiers of each self-defined attribute information, a user type corresponding to each self-defined attribute information and a table corresponding to each self-defined attribute information.

[0145] The statistical analysis module is configured to determine, by statistical analysis of self-defined attribute information belonging to a same user type and belonging to a same table, commonly used self-defined attribute information of each table by a same user type.

[0146] The recommendation module is configured to, through the table configuration component, recommend, for a user currently initiating a table display request, commonly used self-defined attribute information of a currently rendered table and of a same user type as the user.

[0147] Optionally, the system 400 further includes:

[0148] The calculation module is configured to, in response to a user selecting a pre-designed calculation type in the table configuration component, perform calculation of the selected calculation type on a selected region of the table data selected by the user, and display a calculation result.

[0149] Optionally, the system 400 further includes:

[0150] The self-defined display adjustment module is configured to, in response to a user performing a self-defined operation on the displayed table data through the table configuration component, perform corresponding self-defined adjustment on the table data.

[0151] The labeling module is configured to label the corresponding custom attribute information according to the table identifier and the user identifier.

[0152] The data storage module is configured to store the labeled custom attribute information in a local database and a remote database.

[0153] Optionally, the system 400 further comprises:

[0154] The monitoring module is configured to monitor whether the remote database receives new custom attribute information in real time.

[0155] The corresponding relationship determining sub-module is configured to determine a user type corresponding to the new custom attribute information and a table corresponding to the new custom attribute information when the new custom attribute information is received.

[0156] The updating module is configured to update the commonly used custom attribute information for the corresponding table under the corresponding user type according to the corresponding user type and the corresponding table corresponding to the new custom attribute information.

[0157] For the system embodiment, it is basically similar to the method embodiment, so the description is relatively simple, and the relevant parts can be referred to the part of the system embodiment.

[0158] It should be noted that, for the method embodiment, in order to simply describe, it is expressed as a series of action combinations, but those skilled in the art should know that the embodiment of the present application is not limited by the described action sequence, because according to the embodiment of the present application, some steps can be performed in other order or simultaneously. Secondly, those skilled in the art should know that the embodiments described in the specification all belong to preferred embodiments, and the actions involved are not necessarily necessary for the embodiment of the present application.

[0159] Each embodiment in the specification is described in a progressive manner, and each embodiment focuses on the difference from other embodiments. The same and similar parts between the embodiments can be referred to each other.

[0160] Those skilled in the art should understand that the embodiments of the present application can be provided as a method, a system, or a computer program product. Therefore, the embodiments of the present application can be in the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware aspects. Moreover, the embodiments of the present application can be in the form of a computer program product implemented on one or more computer usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer usable program code.

[0161] The embodiments of the present application are described with reference to the flowchart illustrations and / or block diagrams of the methods, terminal devices (systems) and computer program products according to the embodiments of the present application. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing terminal devices to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing terminal devices, create means for implementing the functions specified in the flowchart illustrations and / or block diagrams. Figure 1 one or more functions specified in the flowchart illustrations and / or block diagrams. Figure 1 one or more functions specified in the flowchart illustrations and / or block diagrams.

[0162] These computer program instructions can also be stored in a computer-readable memory that can direct a computer or other programmable data processing terminal devices to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instructions which implement the function specified in the flowchart illustrations and / or block diagrams. Figure 1 one or more functions specified in the flowchart illustrations and / or block diagrams. Figure 1 one or more functions specified in the flowchart illustrations and / or block diagrams.

[0163] These computer program instructions can also be loaded onto a computer or other programmable data processing terminal devices, such that a series of operational steps are carried out on the computer or other programmable terminal devices to produce a computer implemented process so that the instructions executed on the computer or other programmable terminal devices provide steps for implementing the functions specified in the flowchart illustrations and / or block diagrams. Figure 1 one or more functions specified in the flowchart illustrations and / or block diagrams. Figure 1 one or more functions specified in the flowchart illustrations and / or block diagrams.

[0164] Although preferred embodiments of the present application have been described, those skilled in the art will be able to make additional modifications and variations to the embodiments without departing from the scope of the present application. Accordingly, the appended claims are intended to encompass all such modifications and variations as falling within the scope of the embodiments of the present application.

[0165] Finally, it is to be understood that the phraseology or terminology such as "first" and "second" etc. used herein is merely intended to differentiate one entity or operation from another entity or operation, without necessarily requiring or implying any actual such relationship or order between such entities or operations. Moreover, the terms "comprising", "including", or any other closure, are intended to cover the non-exclusive inclusion such that a process, method, article, or apparatus that comprises a list of elements does not include those elements alone but can include other elements not expressly listed or even include elements inherent in such process, method, article, or apparatus. Without more limitations, the element defined by the statement "comprising a" does not exclude the presence of additional identical elements in the process, method, article, or apparatus including the element.

[0166] The above describes in detail the method and system for customizing the configuration table provided by the present application. The principles and implementation modes of the present application are described by using specific examples. The above description of the examples is only used to help understand the method of the present application and its core idea. Meanwhile, for those skilled in the art, the specific implementation modes and application ranges can be changed according to the idea of the present application. In summary, the content of the specification should not be understood as a limitation of the present application.

Claims

1. A method of customizing a configuration table, characterized by, The method comprises: According to the table display request, determining the table identifier of the target table requested to be displayed and the user identifier of the target user initiating the table display request; According to the table identifier and the user identifier, determining the table data of the target table cached in the local database and the custom attribute information of the target table by the target user, and determining the encoding attribute information of the target table in the encoding; The table data is rendered and displayed through the custom attribute information and the encoding attribute information, and a table configuration component is rendered in the display page, and the table configuration component is a component customized by the user for displaying the displayed table.

2. The method of customizing a table according to claim 1, wherein, According to the table identifier and the user identifier, determining the table data of the target table cached in the local database and the custom attribute information of the target table by the target user, comprises: According to the table identifier, determining the table data of the target table corresponding to the table identifier cached in the local database; According to the table identifier and the user identifier, determining the target identifier matching the table identifier and the user identifier at the same time; Comparing the target identifier with the custom attribute identifiers of each custom attribute information cached in the local database, determining that the custom attribute information corresponding to the custom attribute identifier same as the target identifier is the custom attribute information of the target table by the target user.

3. The method of customizing a table according to claim 1, wherein, The table data is rendered and displayed through the custom attribute information and the encoding attribute information, comprising: Comparing the first column identifier of the column data in the table data with the second column identifier of the encoding attribute in the encoding attribute information, determining that the encoding attribute corresponding to the second column identifier same as the first column identifier is the encoding attribute of the column data; Comparing the first column identifier of the column data in the table data with the third column identifier of the custom attribute in the custom attribute information, determining that the custom attribute corresponding to the third column identifier same as the first column identifier is the custom attribute of the column data; The encoding attribute and the custom attribute of each column data in the table data are respectively rendered and displayed on the column data corresponding to each of them.

4. The method of customizing a table according to claim 1, wherein, In the case that it is determined that the local database caches the target table and does not cache the custom attribute information, the table data is rendered and displayed through the custom attribute information and the encoding attribute information, and a table configuration component is rendered in the display page, comprising: The table data is rendered and displayed through the encoding attribute information, and a table configuration component is rendered in the display page.

5. The method of customizing a table according to claim 1, wherein, In the case that it is determined that the local database does not cache the target table and the custom attribute information, the method further comprises: Querying whether the custom attribute information is included in the remote database through an interface request; In the case that the custom attribute information is included in the remote database, storing the table data of the target table and the custom attribute information in the remote database into the local database; In the case that the custom attribute information is not included in the remote database, table data of the target table in the remote database is acquired and stored in a local database; The rendering display of the table data and the rendering of the table configuration component in the display page are performed by using the custom attribute information and the encoding attribute information. The rendering display of the table data and the rendering of the table configuration component in the display page are performed by using the custom attribute information and the encoding attribute information.

6. The method of customizing a table according to claim 2, wherein, The method further comprises: According to the custom attribute identifier of each custom attribute information, the user type corresponding to each custom attribute information and the table corresponding to each custom attribute information are determined; By statistically analyzing the custom attribute information belonging to the same user type and belonging to the same table, the commonly used custom attribute information of each table for the same user type is determined. The commonly used custom attribute information for the currently rendered table and the same user type as the user type of the user currently initiating the table display request is recommended to the user through the table configuration component.

7. The method of customizing a table according to claim 1, wherein, The method further comprises: In response to the user selecting a pre-designed calculation type in the table configuration component, the calculation of the selected area of the table data selected by the user is performed according to the pre-designed calculation type, and the calculation result is displayed.

8. The method of customizing a table according to claim 1, wherein, The method further comprises: In response to the user's custom operation on the displayed table data through the table configuration component, the table data is correspondingly adjusted; According to the table identifier and the user identifier, the custom attribute identifier of the custom attribute information corresponding to the custom adjustment is annotated; The annotated custom attribute information is stored in the local database and the remote database.

9. The method of customizing a table according to claim 6, wherein, The method further comprises: The remote database is monitored in real time to determine whether new custom attribute information is received; In the case that new custom attribute information is received, the user type corresponding to the new custom attribute information and the table corresponding to the new custom attribute information are determined; According to the user type corresponding to the new custom attribute information and the table corresponding to the new custom attribute information, the commonly used custom attribute information for the corresponding table under the corresponding user type is updated.

10. A system for customizing a configuration table, the system comprising: The system comprises: An identifier determination module is configured to determine, according to a table display request, a table identifier of a target table requested to be displayed and a user identifier of a target user initiating the table display request; An attribute information determination module is configured to determine, according to the table identifier and the user identifier, table data of the target table cached in a local database and custom attribute information of the target table of the target user, and determine encoding attribute information of the target table in an encoding; A rendering display module is configured to perform the rendering display of the table data and the rendering of a table configuration component in a display page by using the custom attribute information and the encoding attribute information.

Images