Data table management method and apparatus, device and medium

Abstract

Provided are a data table management method and apparatus, a device, and a medium. The method comprises: presenting a collapsing control used for collapsing a data dimension group in a data table, the data dimension group comprising a basic data dimension and at least one other data dimension other than the basic data dimension; and in response to receiving an interaction request for the collapsing control, presenting the basic data dimension in the data dimension group, and hiding the at least one other data dimension. By using the exemplary implementation of the present disclosure, in the collapsed state, the basic data dimension will be displayed as a representative of the data dimension group, thereby enabling users to know that the data dimension group displayed after being collapsed is included in the data table.

Description

Method, apparatus, device and medium for managing a data table TECHNICAL FIELD

[0001] Exemplary implementations of the present disclosure generally relate to data storage, and in particular, to a method, apparatus, device and computer-readable storage medium for managing a data table. BACKGROUND

[0002] In a data storage scenario, a data table is a common way of data storage. As the amount of data increases, a data table can include a large number of data dimensions (e.g., data columns or data rows). This results in that all data dimensions cannot be shown at the same time when the data table is presented in a tiled manner, in which case a user needs to use a search control or a scroll bar to find the data dimension of interest. At this time, it is desirable to manage the data dimensions in the data table in a more convenient and efficient manner, and to improve data access efficiency.

[0003] SUMMARY

[0004] In a first aspect of the present disclosure, a method for managing a data table is provided. In the method, a fold control for folding a data dimension group in the data table is presented, the data dimension group including a base data dimension and at least one other data dimension other than the base data dimension. In response to receiving an interaction request for the fold control, the base data dimension in the data dimension group is presented, and the at least one other data dimension is hidden.

[0005] In a second aspect of the present disclosure, an apparatus for managing a data table is provided. The apparatus includes a presentation module configured to present a fold control for folding a data dimension group in the data table, the data dimension group including a base data dimension and at least one other data dimension other than the base data dimension; and a folding module configured to present the base data dimension in the data dimension group and hide the at least one other data dimension in response to receiving an interaction request for the fold control.

[0006] In a third aspect of the present disclosure, an electronic device is provided. The electronic device includes at least one processing unit; and at least one memory coupled to the at least one processing unit and storing instructions for execution by the at least one processing unit, the instructions when executed by the at least one processing unit cause the electronic device to perform the method according to the first aspect of the present disclosure.

[0007] In a fourth aspect of the present disclosure, a computer-readable storage medium having stored thereon a computer program, the computer program when executed by a processor causes the processor to implement the method according to the first aspect of the present disclosure.

[0008] In a fifth aspect of the present disclosure, a computer program product is provided, comprising a computer program, wherein the computer program, when executed by a processor, implements the method according to the first aspect of the present disclosure.

[0009] It is to be understood that the details set forth herein do not limit the key or critical features of the subject application, which are described in connection with the attached drawings and disclosed claims. Other features of the subject application will be apparent from consideration of the description and drawings in accordance with the principles set forth herein. BRIEF DESCRIPTION OF DRAWINGS

[0010] The above and other features, aspects and advantages of various implementations of the present disclosure will become more apparent from the following detailed description taken in conjunction with the accompanying drawings, in which like reference numerals designate similar elements in the figures, and wherein:

[0011] FIG. 1 illustrates a block diagram of an application environment according to one example implementation of the present disclosure;

[0012] FIG. 2 illustrates a block diagram for managing a data table according to some implementations of the present disclosure;

[0013] FIG. 3 illustrates a block diagram for setting a grouping according to some implementations of the present disclosure;

[0014] FIG. 4 illustrates a block diagram for expanding a data column grouping according to some implementations of the present disclosure;

[0015] FIG. 5 illustrates a block diagram for setting a color of a grouping according to some implementations of the present disclosure;

[0016] FIG. 6 illustrates a block diagram for managing a data column grouping according to some implementations of the present disclosure;

[0017] FIG. 7 illustrates a block diagram for adjusting a base column according to some implementations of the present disclosure;

[0018] FIG. 8 illustrates a block diagram for collapsing a grouping according to some implementations of the present disclosure;

[0019] FIG. 9 illustrates a flowchart of a method for managing a data table according to some implementations of the present disclosure;

[0020] FIG. 10 illustrates a block diagram of an apparatus for managing a data table according to some implementations of the present disclosure; and

[0021] FIG. 11 illustrates a block diagram of a device capable of implementing various implementations of the present disclosure. DETAILED DESCRIPTION

[0022] Implementations of the present disclosure will be described more fully hereinafter with reference to the accompanying drawings. While several implementations of the present disclosure are described, it should be understood that the present disclosure can be embodied in many other forms and should not be construed as limited to the implementations set forth herein; rather, these implementations are provided so that this disclosure will be thorough and complete, and fully convey the scope of the present disclosure to those skilled in the art. It should be understood that the drawings and implementations described are for illustrative purposes only and are not intended to limit the scope of the present disclosure.

[0023] In the description of implementations of the present disclosure, the term "includes" and its derivatives mean "including but not limited to". The term "based on" means "based at least in part on". The term "one implementation" or "the implementation" means "at least one implementation". The term "some implementations" means "at least some implementations". Other explicit or implicit definitions can also be included below. As used herein, the term "model" can represent the relationship between various data. For example, the above relationship can be obtained based on various technical solutions known at present and / or to be developed in the future.

[0024] It can be understood that the data involved in the technical solutions of the present disclosure (including but not limited to the data itself, the acquisition or use of the data) should comply with the requirements of relevant laws and regulations and relevant provisions.

[0025] It can be understood that before using the technical solutions disclosed by the embodiments of the present disclosure, the type of personal information involved in the present disclosure, the scope of use, the scene of use, etc. should be informed to the user and the authorization of the user should be obtained through appropriate means according to relevant laws and regulations.

[0026] For example, in response to receiving the active request of the user, the user is sent prompt information to explicitly prompt the user that the operation requested to be executed will require the acquisition and use of the personal information of the user. Thus, the user can voluntarily choose whether to provide personal information to the software or hardware such as electronic device, application program, server or storage medium, etc. that executes the operation of the technical solutions of the present disclosure according to the prompt information.

[0027] As an optional but non-limiting implementation, in response to receiving the active request of the user, the way of sending prompt information to the user, for example, can be the way of pop-up window, and the prompt information can be presented in the form of text in the pop-up window. In addition, the pop-up window can also carry selection controls for the user to select "agree" or "disagree" to provide personal information to the electronic device.

[0028] It can be understood that the above notification and user authorization process is only illustrative, and does not limit the implementations of the present disclosure, and other ways that meet the relevant laws and regulations can also be applied to the implementations of the present disclosure.

[0029] The term "in response to" as used herein refers to a state in which a corresponding event occurs or a condition is satisfied. It will be understood that the timing of the execution of a subsequent action performed in response to the event or condition is not necessarily strongly correlated with the time at which the event occurs or the condition is satisfied. For example, in some cases, the subsequent action can be performed immediately upon the occurrence of the event or the satisfaction of the condition; in other cases, the subsequent action can be performed after a period of time has elapsed since the occurrence of the event or the satisfaction of the condition.

[0030] Example environment

[0031] As the amount of data increases, a data table can include a large number of data dimensions. This results in that all data dimensions cannot be simultaneously displayed when the data table is presented in a tiled manner. At this time, a user needs to use a search control or a control such as a scroll bar to find a data dimension desired to be viewed. Here, a data dimension can include a data column or a data row. For ease of description, in the following, specific details of managing a data table are described only by taking a data column as an example of a data dimension. An application environment according to some implementations of the present disclosure is described with reference to FIG. 1, which shows a block diagram 100 of an application environment according to one example implementation of the present disclosure. As shown in FIG. 1, a data table 110 includes a plurality of data columns, denoted as data columns A, B, C, D, E, F, G, and H, respectively. Existing data table management tools provide a function of "showing / hiding" a data column.

[0032] A user can select one or more data columns, for example, data columns B, C, D, and E, and set the data columns to a display state 120. At this time, the data columns B, C, D, and E are normally displayed. The user can hide one or more data columns, for example, can set the selected data columns B, C, D, and E to a hidden state 122. At this time, the data columns B, C, D, and E are hidden, and the data column A and the data column F are directly adjacent. Although the "showing / hiding" function can hide a part of data columns to thereby reduce the width of the data table 110, the user cannot know which data columns are hidden, and thus can miss key data in the data table. At this time, it is desired to manage each data column in the data table in a more convenient and effective manner, and to improve data access efficiency.

[0033] Summary of managing a data table

[0034] To at least partially address the deficiencies in the prior art, according to one example implementation of the present disclosure, a method for managing a data table is proposed. A summary according to one example implementation of the present disclosure is described with reference to FIG. 2, which shows a block diagram 200 for managing a data table according to some implementations of the present disclosure. As shown in FIG. 2, a collapse control, e.g., control 212, for collapsing a data column grouping in a data table 110 can be presented. Here, the data column grouping can include a base data column and at least one other data column other than the base data column. Specifically, the data column grouping includes a plurality of data columns B, C, D, E, where data column B is the base data column and the other data columns can include data columns C, D, E.

[0035] In the expanded mode 230, the plurality of data columns B, C, D, E in the data column grouping are all presented. The control 212 can be provided to display the plurality of data columns in the data column grouping in the collapsed state 220. In response to receiving an interaction request 240 for the collapse control, only the base data column in the data column grouping is presented and the at least one other data column is hidden. As shown on the right side of FIG. 2, only the base data column B is displayed in the collapsed state 220 and the other data columns C, D, E are hidden. Further, the control 210 can be presented in a flag icon to indicate the location of the base data column B.

[0036] With the example implementations of the present disclosure, the data column grouping can include a base data column and at least one other normal data column. A data column that can represent the plurality of data columns can be selected as the base data column and only the base data column is displayed in the collapsed state. In this way, in the collapsed state, the base data column will be displayed as a representative of the data column grouping, thereby making the user aware that the data column grouping is included in the data table that is displayed in the collapsed state.

[0037] Detailed procedure for managing a data table

[0038] Having described a summary according to some implementations of the present disclosure, more details regarding managing a data table will be described in the following. According to some implementations of the present disclosure, a user can select a plurality of data columns in a data table and create a data column grouping. More details are described with reference to FIG. 3, which shows a block diagram 300 for setting a grouping according to some implementations of the present disclosure. As shown in FIG. 3, a user can select (e.g., by marqueeing, etc.) to select a plurality of data columns 310. In response to receiving a selection request for the plurality of data columns 310 in the data table, a grouping control, e.g., control 320, for setting a data column grouping can be presented. The user can click on the grouping control to set a data grouping. In response to receiving an interaction request for the grouping control, the plurality of data columns 310 can be added to the data column grouping.

[0039] It should be appreciated that the selected multiple data columns can be consecutively ordered or can not be consecutively ordered. At this time, the non-base data columns in the multiple data columns added to the data column group can be hidden. For example, the user can select data columns B, D and F in FIG. 3, and if data column B is the base data column, data columns D and F will be hidden in the collapsed state. In this way, flexible selection of data columns desired to be added to the group can be supported.

[0040] According to some implementations of the present disclosure, in the case that the multiple data columns 310 are selected, the user can click the control 320 to directly create a new data column group based on the multiple data columns 310. Alternatively and / or additionally, in response to detecting that the control 320 is clicked, a further settings page can be popped up. For example, the page can include a control 330, and the user can click the control 330 to create a data column group. Alternatively and / or additionally, one or more data column groups that already exist can be presented, and the user can select a data column group from the one or more data column groups that already exist and add the multiple data columns 310 to the selected data column group. In this way, multiple flexible ways for setting the group can be provided to manage the data table in a more simple and efficient manner.

[0041] According to some implementations of the present disclosure, a data column at a predetermined position in the multiple data columns 310 can be set as the default base data column. For example, the first data column, the data column at the middle position, or the last data column can be set as the default data column. Alternatively and / or additionally, the data column corresponding to the interaction request (e.g., the mouse cursor or the user finger position) can be set as the default data column. In this way, the flexibility of setting the base data column can be facilitated to manage the data table in a more simple and efficient manner.

[0042] According to some implementations of the present disclosure, after the data column group has been created, a control 340 for collapsing the group can be presented. At this time, in response to detecting an interaction request for the control 340, only the base data column B can be displayed, and the other data columns C, D and E in the data column group can be hidden.

[0043] According to some implementations of the present disclosure, in the collapsed state, a control for expanding the data column grouping can be presented. Further, in response to receiving an interaction request for the control for expanding, at least one other data column in the data column grouping can be presented. See FIG. 4 for more details, which illustrates a block diagram 400 for expanding a data column grouping according to some implementations of the present disclosure. As shown on the left side of FIG. 4, in the collapsed state 220, a control 420 can be presented. In response to detecting an interaction request 410 for the control 420, the collapsed data column grouping can be expanded. As shown on the right side of FIG. 4, the data column grouping is in the expanded state 230, and all data columns B, C, D, E are displayed. Further, a control 430 for collapsing the data column grouping can be presented. With some implementations of the present disclosure, the display of the data column grouping can be toggled in a more convenient and efficient manner.

[0044] According to some implementations of the present disclosure, a control for setting the data column grouping can be presented. In response to receiving an interaction request for the control for setting, a settings page can be presented, which includes a color setting control for setting the color of the data column grouping. See FIG. 5 for more details, which illustrates a block diagram 500 for setting the color of a grouping according to some implementations of the present disclosure. As shown in FIG. 5, the control can be presented as a flag icon, such as control 210. The control 210 can be clicked to present a settings page that includes more controls. For example, the settings page can include a color setting control 510, in response to receiving an interaction request for the color setting control 510, the color of the data column grouping can be set.

[0045] With some implementations of the present disclosure, different colors are allowed to distinguish different data column groupings. For example, the color can be used to set the background color of each data column in the data column grouping, the color of the header, the background color of the wireframe, and / or the text color of the data items in the data column, etc. In this way, the user can highlight the data column of interest, and thus the visualization of the data table can be improved.

[0046] According to some implementations of the present disclosure, a settings control can be presented at a location corresponding to the base data column. As shown in FIG. 5, the control 210 can be displayed at the header location of the base data column B. With some implementations of the present disclosure, the base data column can be easily distinguished from the other data columns, and thus the further operations of the user can be facilitated. Alternatively and / or additionally, other markers can be used to indicate the base data column, such as bold, large, highlight, underline, etc. The settings control can be displayed across the headers of multiple data columns in the data column grouping. For example, a semi-transparent layer can be provided at the header location or other location of the multiple data columns, and the settings control can be displayed in the layer, etc.

[0047] According to some implementations of the present disclosure, the settings page further includes a cancel control for canceling the data column grouping. In response to receiving an interaction request for the cancel control, the data column grouping can be canceled. More details are described with reference to FIG. 6, which illustrates a block diagram 600 for managing data column grouping according to some implementations of the present disclosure. As shown in FIG. 6, in response to receiving an interaction request for the control 210, a settings page including a control 610 can be presented. The control 610 is for canceling the current data column grouping. Specifically, in response to determining that a user clicks the control 610, the plurality of data columns B, C, D, and E can be restored to regular data columns. At this time, the grouping is canceled and the plurality of data columns B, C, D, and E are no longer in the grouping. According to some implementations of the present disclosure, a data column can be designated to be added to only a single data column grouping. In this way, a display state conflict can be avoided.

[0048] According to some implementations of the present disclosure, the settings page can further include an update control, such as the control 612, for updating the data column grouping. In response to receiving an interaction request for the update control, the plurality of data columns in the data column grouping is updated based on the interaction request. In response to receiving an interaction request for the control 612, the identification of the plurality of data columns included in the current grouping can be presented. A user can select the identification of a data column desired to be deleted from the current grouping. Alternatively and / or additionally, the identification of the plurality of data columns not included in the current grouping can be presented in a different format for a user to select one or more data columns desired to be added to the current grouping. With some implementations of the present disclosure, a data table can be managed in a more flexible and efficient manner.

[0049] According to some implementations of the present disclosure, a user can perform other interaction operations with individual data columns in the data column grouping. In response to determining that an interaction request with the data column grouping satisfies a predetermined condition, a settings control for setting the data column grouping can be presented. For example, a user can click on a data column other than the base data column, can hover a mouse cursor over a data column, and so on. At this time, the settings control can be provided, more details of which are described with reference to FIG. 7, which illustrates a block diagram 700 for adjusting a base column according to some implementations of the present disclosure. As shown in FIG. 7, in response to determining that a user clicks on the data column E or a dwell time at the data column E is higher than a certain time threshold (e.g., 2 seconds or other value), a settings control, such as the control 740, can be presented.

[0050] Further, in response to receiving the user interaction with the space 740, a settings page can be provided. The settings page can include a base column setting control for setting the base data column, such as the control 710 in FIG. 7. In response to receiving an interaction request for the base column setting control, a target data column in the at least one other data column is set as the base data column of the data column grouping. At this time, the current data column E can be set as the base data column. In this way, the base data column can be quickly modified, thereby improving the management efficiency of the data table.

[0051] After setting the data column E as the base data column, a block diagram as shown in FIG. 8 can be presented, which illustrates a block diagram 800 for folding a grouping according to some implementations of the present disclosure. As shown on the left side of FIG. 8, the base data column of the data column grouping has been updated from the data column B to the data column E. The right side of FIG. 8 illustrates the data column grouping in the folded state 220, at which time only the data column E is displayed, and the other data columns B, C, D are hidden.

[0052] Returning to FIG. 7, the settings page can further include a control 720 for canceling the current data column grouping, and a control 730 for updating the current data column grouping. Here, the functions of the controls 720 and 730 are similar to those of the controls 610 and 612 in FIG. 6, and thus will not be described again.

[0053] It should be appreciated that although the above describes a case where one data column grouping includes only one base data column, alternatively and / or additionally, one data column grouping can include multiple base data columns. For example, the settings page in FIG. 7 can further include an increase control for increasing the base column. In response to receiving a user interaction for the increase control, the data column E can also be set as another base data column, at which time the data column grouping can include two base data columns: the data columns B and E. At this time, the flag mark can be displayed at the header position of both the data columns B and E, so as to indicate the base data column. When folding the data column grouping, the data columns B and E will be displayed, and the data columns C and D will be hidden.

[0054] With some implementations of the present disclosure, the user is allowed to set multiple data columns of which he desires to focus as the base data column, thereby improving the flexibility of the data table management. Specifically, assuming that the data table is a transcript of a student, one data column grouping can include multiple math scores, such as the overall score, the final exam score, the midterm exam score, and the homework score. At this time, the user "user01" (e.g., a math teacher) can set the overall score and the final exam score as the base data column. In this way, the other data columns of which the user desires to focus less can be hidden.

[0055] According to some implementations of the present disclosure, the data column grouping can be associated with a user viewing the data table. For example, another data column grouping in the data table can include a plurality of English grades, such as a total grade, a final exam grade, a midterm exam grade, and a homework grade. At this time, the user "user02" (e.g., an English teacher) can set the total grade and the final exam grade of English as the base data columns. In this way, other data columns of less interest, such as the English midterm exam grade, the English homework grade, and all math grades, can be hidden.

[0056] According to some implementations of the present disclosure, the state information of the data column grouping can be stored in the configuration data of the user associated with the data table. The state information can include at least one of an identification of the data column grouping, a color, a presentation state of the data column grouping, an identification of the plurality of data columns, and an identification of the base data columns. Continuing the above example, the state information about the data column grouping "group01" can be written in the configuration data of the user "user01". The group01 can include the state information of the plurality of data columns associated with the math grades. For another example, the state information about the data column grouping "group02" can be written in the configuration data of the user "user02". The group02 can include the state information of the plurality of data columns associated with the English grades. Alternatively and / or additionally, the configuration data can be set to present only the relevant data of a certain data column grouping. In this way, each user is allowed to define the grouping and the corresponding state information according to his / her own needs, thereby improving the management efficiency of the data table.

[0057] According to some implementations of the present disclosure, before a user accesses a certain data table, the relevant configuration information can be read first, and then each data column in the data table is presented according to the configuration information. Specifically, in response to receiving an interaction request from a user for accessing a data table, the state information of the data column grouping is read from the configuration data of the user. Further, the data table can be presented based on the state information. Continuing the above example, the user "user01" can be presented with the data columns about the math grades, and the user "user02" can be presented with the data columns about the English grades. In this way, the data columns of more interest to each user can be displayed according to the configuration data, thereby improving the efficiency of the user in obtaining information.

[0058] According to some implementations of the present disclosure, the attribute of the electronic device accessing the data table can be further acquired, and the detailed presentation manner can be determined based on the attribute. For example, assuming that the electronic device is a portable electronic device with a limited display area, the resolution of the display area can be acquired, and the display width of each data column can be set based on the resolution. For another example, the configuration data can further include time information of each data column group being unfolded / folded, and one or more data column groups can be folded based on the time information. For example, even if the data column group group01 is currently unfolded, if the configuration data indicates that the data column group group01 has been in a folded state for a long time in the past, the data column group group01 can be folded, and so on.

[0059] According to some implementations of the present disclosure, the data table can be a local data table located at the electronic device. Alternatively and / or additionally, the data table can be an online data table, in which case the electronic device does not include a copy of the data table locally, but only serves as a browsing device to view the content of the data table located remotely. In this way, by providing the function of setting and folding groups, it is allowed to view a large-scale data table with a large number of data columns at a regular electronic device.

[0060] According to some implementations of the present disclosure, an editing tool of the configuration data can be provided to set the state of the data column group in a specified format. For example, the identification of each data column in the data table can be acquired, a group of data columns can be selected and a group created, and the state of the group can be set. Further, the above-mentioned state can be stored in the configuration data, so that the data table can be presented based on the configuration data when the data table is accessed next time. It should be understood that although the above only shows the case where the data table includes one data column group, in which case the data table can include multiple data column groups. Each data column group can be processed in a similar process as described above. In this way, the data table management efficiency can be improved.

[0061] With some implementations of the present disclosure, a data column capable of representing multiple data columns can be selected as a base data column, and only the base data column is displayed in the folded state. In this way, in the folded state, the base data column will be displayed as a representative of the data column group, thereby making the user aware that the data column group being folded is included in the data table.

[0062] It should be understood that although the above describes the process of managing the data table with data columns as an example. Alternatively and / or additionally, the data dimension can include data rows, and in particular, the data row group can be set, the base data row can be set for the data row group, and the data row group can be folded or unfolded by using similar methods described above. With some implementations of the present disclosure, flexible and efficient operations on the data rows in the data table are allowed.

[0063] Example process

[0064] FIG. 9 illustrates a flowchart of a method 900 for managing a data table, according to some implementations of the present disclosure. At block 910, a collapse control for collapsing a data dimension grouping in the data table is presented, the data dimension grouping including a base data dimension and at least one other data dimension other than the base data dimension. At block 920, in response to receiving an interaction request for the collapse control, the base data dimension in the data dimension grouping is presented and the at least one other data dimension is hidden.

[0065] According to some implementations of the present disclosure, the data dimension grouping is determined based on: presenting a grouping control for setting the data dimension grouping in response to receiving a selection request for a plurality of data dimensions in the data table; and adding the plurality of data dimensions to the data dimension grouping in response to receiving an interaction request for the grouping control.

[0066] According to some implementations of the present disclosure, the method further includes: presenting an expand control for expanding the data dimension grouping; and presenting the at least one other data dimension in the data dimension grouping in response to receiving an interaction request for the expand control.

[0067] According to some implementations of the present disclosure, the method further includes: presenting a settings control for setting the data dimension grouping; presenting a settings page in response to receiving an interaction request for the settings control, the settings page including a color settings control for setting a color of the data dimension grouping; and setting the color of the data dimension grouping in response to receiving an interaction request for the color settings control.

[0068] According to some implementations of the present disclosure, presenting the settings control includes: presenting the settings control at a location corresponding to the base data dimension.

[0069] According to some implementations of the present disclosure, the settings page further includes a cancel control for canceling the data dimension grouping, and the method further includes: canceling the data dimension grouping in response to receiving an interaction request for the cancel control.

[0070] According to some implementations of the present disclosure, the settings page further includes: an update control for updating the data dimension grouping; and the method further includes: updating the plurality of data dimensions in the data dimension grouping based on the interaction request in response to receiving an interaction request for the update control.

[0071] According to some implementations of the present disclosure, the method further includes: in response to determining that the interaction request with the data dimension grouping satisfies a predetermined condition, presenting a base column setting control for setting a base data dimension; and in response to receiving an interaction request for the base column setting control, setting a target data dimension in the at least one other data dimension as the base data dimension of the data dimension grouping.

[0072] According to some implementations of the present disclosure, the method further includes: storing, in configuration data of a user associated with the data table, state information of the data dimension grouping, the state information including at least any of: an identification of the data dimension grouping, a color, a presentation state of the data dimension grouping, identifications of the plurality of data dimensions, and an identification of the base data dimension.

[0073] According to some implementations of the present disclosure, the method further includes: in response to receiving an interaction request from the user for accessing the data table, reading the state information of the data dimension grouping from the configuration data of the user; and presenting the data table based on the state information.

[0074] According to some implementations of the present disclosure, wherein the data dimensions include at least any of: data rows and data columns.

[0075] Example apparatuses and devices

[0076] FIG. 10 illustrates a block diagram of an apparatus 1000 for managing a data table, according to some implementations of the present disclosure. The apparatus 1000 includes: a presentation module 1010 configured to present a collapse control for collapsing a data dimension grouping in a data table, the data dimension grouping including a base data dimension and at least one other data dimension other than the base data dimension; and a collapse module 1020 configured to, in response to receiving an interaction request for the collapse control, present the base data dimension in the data dimension grouping and hide the at least one other data dimension.

[0077] According to some implementations of the present disclosure, the apparatus 1000 further includes a grouping module configured to: in response to receiving a selection request for a plurality of data dimensions in the data table, present a grouping control for setting a data dimension grouping; and in response to receiving an interaction request for the grouping control, add the plurality of data dimensions to the data dimension grouping.

[0078] According to some implementations of the present disclosure, the apparatus 1000 further includes an expand module configured to: present an expand control for expanding the data dimension grouping; and in response to receiving an interaction request for the expand control, present the at least one other data dimension in the data dimension grouping.

[0079] According to some implementations of the present disclosure, the apparatus 1000 further includes a setting module configured to: present a setting control for setting a data dimension group; in response to receiving an interaction request for the setting control, present a setting page, the setting page including a color setting control for setting a color of the data dimension group; and in response to receiving an interaction request for the color setting control, set the color of the data dimension group.

[0080] According to some implementations of the present disclosure, the setting module is further configured to: present the setting control at a position corresponding to a base data dimension.

[0081] According to some implementations of the present disclosure, the setting page further includes a cancel control for canceling the data dimension group, and the setting module is further configured to: in response to receiving an interaction request for the cancel control, cancel the data dimension group.

[0082] According to some implementations of the present disclosure, the setting page further includes: an update control for updating the data dimension group; and the setting module is further configured to: in response to receiving an interaction request for the update control, update a plurality of data dimensions in the data dimension group based on the interaction request.

[0083] According to some implementations of the present disclosure, the setting module is further configured to: in response to determining that the interaction request with the data dimension group satisfies a predetermined condition, present a base column setting control for setting a base data dimension; and in response to receiving an interaction request for the base column setting control, set a target data dimension in the at least one other data dimension as the base data dimension of the data dimension group.

[0084] According to some implementations of the present disclosure, the setting module is further configured to: store state information of the data dimension group in configuration data of a user associated with the data table, the state information including at least any of: an identification of the data dimension group, a color, a presentation state of the data dimension group, identifications of the plurality of data dimensions, and an identification of the base data dimension.

[0085] According to some implementations of the present disclosure, the setting module is further configured to: in response to receiving an interaction request from the user for accessing the data table, read the state information of the data dimension group from the configuration data of the user; and present the data table based on the state information.

[0086] According to some implementations of the present disclosure, wherein the data dimension includes at least any of: a data row and a data column.

[0087] FIG. 11 illustrates a block diagram of a device 1100 that is capable of implementing the various implementations of the present disclosure. It should be appreciated that the computing device 1100 illustrated in FIG. 11 is merely an example and should not be construed as any limitation of the functionality and scope of the implementations described herein. The computing device 1100 illustrated in FIG. 11 can be used to implement the methods described above.

[0088] As illustrated in FIG. 11, the computing device 1100 is in the form of a general-purpose computing device. Components of the computing device 1100 can include, but are not limited to, one or more processors or processing units 1110, a memory 1120, a storage device 1130, one or more communication units 1140, one or more input devices 1150, and one or more output devices 1160. The processing unit 1110 can be a real or virtual processor and is capable of executing various processing in accordance with programs stored in the memory 1120. In a multi-processing system, multiple processing units execute computer-executable instructions in parallel to improve the processing power of the computing device 1100.

[0089] The computing device 1100 typically includes a plurality of computer storage media. Such media can be removable, non-removable, or a combination thereof. The memory 1120 can be volatile (such as, for example, registers, cache, RAM), non-volatile (such as, for example, ROM, EEPROM, flash memory), or some combination thereof. The storage device 1130 can be a removable or non-removable media, and can include machine-readable media, such as flash drives, disks, or any other media capable of storing information and / or data (e.g., training data for training) and accessible by the computing device 1100.

[0090] The computing device 1100 can further include additional removable / non-removable, volatile / non-volatile storage media. Although not shown in FIG. 11, a disk drive or other computer-readable media drive can be provided for reading from or writing to a removable, non-removable, volatile, or non-volatile media. In these instances, each drive can be connected to the bus (not shown) by one or more data media interfaces. The memory 1120 can include a computer program product 1125 having one or more program modules configured to carry out the various methods or actions of the implementations of the present disclosure.

[0091] The communication unit 1140 enables communication with other computing devices over a communication medium. Additionally, the functionality of the components of the computing device 1100 can be implemented in a single computing cluster or a plurality of computer machines that are capable of communicating with each other through a communication connection. Thus, the computing device 1100 can operate in a networked environment using logical connections to one or more other servers, network personal computers (PCs), or another network nodes in the networking environment.

[0092] The input device 1150 can be one or more input devices, such as a mouse, a keyboard, a trackball, etc. The output device 1160 can be one or more output devices, such as a display, a speaker, a printer, etc. The computing device 1100 can also communicate with one or more external devices (not shown), such as a storage device, a display device, etc., through the communication unit 1140, as needed, one or more devices that enable a user to interact with the computing device 1100, or any devices (e.g., a network card, a modem, etc.) that enable the computing device 1100 to communicate with one or more other computing devices. Such communication can be carried out through an input / output (I / O) interface (not shown).

[0093] According to an example implementation of the present disclosure, a computer readable storage medium is provided, having stored thereon computer executable instructions, wherein the computer executable instructions are executed by a processor to implement the method described above. According to an example implementation of the present disclosure, a computer program product is also provided, which is tangibly stored on a non-transitory computer readable medium and includes computer executable instructions, wherein the computer executable instructions are executed by a processor to implement the method described above. According to an example implementation of the present disclosure, a computer program product is provided, having stored thereon a computer program, which when executed by a processor implements the method described above.

[0094] Various aspects of the disclosure are described herein with reference to flowchart illustrations and / or block diagrams of methods, apparatuses, and computer program products according to this disclosure. 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 readable program instructions.

[0095] The computer readable program instructions can also be loaded onto a computer, other programmable data processing apparatus, or other device to cause a series of operational steps to be performed on the computer, other programmable apparatus or other device to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide processes for implementing the functions / acts specified in the flowchart and / or block diagram block or blocks.

[0096] The computer readable program instructions can also be loaded onto a computer, other programmable data processing apparatus, or other device to cause a series of operational steps to be performed on the computer, other programmable apparatus or other device to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide processes for implementing the functions / acts specified in the flowchart and / or block diagram block or blocks.

[0097] The computer readable program instructions can also be loaded onto a computer, other programmable data processing apparatus, or other device to cause a series of operational steps to be performed on the computer, other programmable apparatus or other device to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide processes for implementing the functions / acts specified in the flowchart and / or block diagram block or blocks.

[0098] The implementations of the disclosure have been described above with the intent to be illustrative rather than limiting. Although being shown and described in terms of certain implementations and overall functions, the implementations are not intended to exclude other implementations or technologies. Alterations and permutations of certain implementations could produce still other implementations that fall within the scope of the implementations. Accordingly, the phrase "consisting essentially of is defined to not include processes, systems, articles, or materials that do not "consist essentially of the recited elements. The phrase "consisting essentially of is defined to include processes, systems, articles, or materials that "consist essentially of the recited elements, as well as such processes, systems, articles, or materials that also have additional, nonessential elements.

Claims

1. A method for managing a data table, comprising: presenting a collapse control for collapsing a data dimension grouping in the data table, the data dimension grouping comprising a base data dimension and at least one other data dimension other than the base data dimension; and in response to receiving an interaction request for the collapse control, presenting the base data dimension in the data dimension grouping and hiding the at least one other data dimension.

2. The method of claim 1, wherein the data dimension grouping is determined based on: in response to receiving a selection request for a plurality of data dimensions in the data table, presenting a grouping control for setting a data dimension grouping; and in response to receiving an interaction request for the grouping control, adding the plurality of data dimensions to the data dimension grouping.

3. The method of claim 1, further comprising: presenting an expand control for expanding the data dimension grouping; and in response to receiving an interaction request for the expand control, presenting the at least one other data dimension in the data dimension grouping.

4. The method of claim 1, further comprising: presenting a setting control for setting the data dimension grouping; in response to receiving an interaction request for the setting control, presenting a setting page, the setting page comprising a color setting control for setting a color of the data dimension grouping; and in response to receiving an interaction request for the color setting control, setting the color of the data dimension grouping. presenting the setting control at a location corresponding to the base data dimension.

5. The method of claim 4, wherein presenting the settings control comprises: in response to receiving an interaction request for the cancel control, canceling the data dimension grouping.

6. The method of claim 4, wherein the settings page further comprises a cancel control for canceling the data dimension grouping, and the method further comprises: an update control for updating the data dimension grouping; and the method further comprising, in response to receiving an interaction request for the update control, updating the plurality of data dimensions in the data dimension grouping based on the interaction request.

7. The method of claim 4, wherein the settings page further comprises:

8. The method of claim 1, further comprising: in response to determining that an interaction request with the data dimension grouping satisfies a predetermined condition, presenting a base column setting control for setting the base data dimension; and in response to receiving an interaction request for the base column setting control, setting a target data dimension in the at least one other data dimension as the base data dimension of the data dimension grouping.

9. The method of claim 1, further comprising: storing state information of the data dimension grouping in configuration data of a user associated with the data table, the state information comprising at least any of: an identification of the data dimension grouping, a color, a presentation state of the data dimension grouping, an identification of the plurality of data dimensions, and an identification of the base data dimension.

10. The method of claim 9, further comprising: in response to receiving an interaction request from the user for accessing the data table, reading the state information of the data dimension grouping from the configuration data of the user; and presenting the data table based on the state information. ​ ​ ​ 11. The method of claim 1, wherein the data dimensions include at least either of a data row and a data column.

12. An apparatus for managing a data table, comprising: a presentation module configured for presenting a collapse control for collapsing a grouping of data dimensions in a data table, the grouping of data dimensions including a base data dimension and at least one other data dimension other than the base data dimension; and a collapse module configured for presenting the base data dimension in the grouping of data dimensions and hiding the at least one other data dimension in response to receiving an interaction request for the collapse control.

13. An electronic device, comprising: at least one processing unit; and at least one memory coupled to the at least one processing unit and storing instructions for execution by the at least one processing unit, the instructions which when executed by the at least one processing unit cause the electronic device to perform the method according to any one of claims 1-11.

14. A computer readable storage medium having stored thereon a computer program which, when executed by a processor, causes the processor to implement the method according to any one of claims 1-11.

15. A computer program product comprising a computer program which, when executed by a processor, implements the method according to any one of claims 1-11. ​ ​

Images