Table data processing method and related equipment

Abstract

The invention provides a table data processing method and related equipment. The method comprises the following steps: in response to a first operation on a first table, generating an isolation environment and a second table arranged in the isolation environment; the second table comprises table structure information and / or table data information of the first table; in response to a table configuration operation on the second table, table change information is generated; and in response to a deployment operation in the isolated environment, deploying at least part of the table change information to the first table. According to the table data processing method and the related equipment provided by the invention, modification of the table data in the isolation environment does not influence the table data in the production environment, so that the development and test cost of the table is reduced, and the safety of the table data is guaranteed.

Description

Technical Field

[0001] The present disclosure relates to the field of computer technology, and in particular to a data processing method and related equipment. Background Art

[0002] Online spreadsheets are widely used in various industries due to their convenience and security, enabling cloud storage of large-scale tabular data and multi-terminal data synchronization.

[0003] Currently, online tables can be modified directly in the production environment, or by modifying the replica table and then updating it to the production environment. Both methods are inconvenient and may affect the original production environment. Summary of the Invention

[0004] In view of this, the purpose of the present disclosure is to provide a data processing method and related devices.

[0005] Based on the above objectives, the present disclosure provides a first aspect of a table data processing method, comprising:

[0006] In response to a first operation on a first table, an isolation environment and a second table set in the isolation environment are generated; the second table includes table structure information and / or table data information of the first table;

[0007] generating table change information in response to a table configuration operation on the second table;

[0008] In response to a deployment operation in the isolation environment, at least part of the table change information is deployed to the first table.

[0009] In some embodiments, generating an isolated environment and a second table set in the isolated environment in response to the first operation on the first table includes:

[0010] In response to a triggering operation on a first control in the first table, displaying a first configuration page for the isolation environment;

[0011] In response to a first selection operation on the first configuration page, creating the isolation environment and the second table containing the table structure information;

[0012] In response to a second selection operation on the first configuration page, the isolation environment and the second table including the table structure information and the table data information are created.

[0013] In some embodiments, the method further comprises:

[0014] Displaying a second configuration page for the isolation environment;

[0015] In response to a triggering operation on a second control in the second configuration page, the second table is displayed in the isolated environment.

[0016] In some embodiments, the method further comprises:

[0017] In response to a refresh operation on the second table, the table structure information and / or the table data information of the first table are reacquired to generate the second table.

[0018] In some embodiments, the method further comprises:

[0019] Displaying the table change information on the second configuration page;

[0020] In response to a viewing operation on the table change information, displaying at least one of a name, a module, a change type, an operating user, an operating time, and an associated object of an object corresponding to the table change information;

[0021] In response to a trigger operation on the name, information of the object corresponding to the name in the second table is displayed.

[0022] In some embodiments, the table configuration operation includes one of adding, deleting, and modifying the object;

[0023] The object includes at least one of a field, a data table, a collection table, a form, a dashboard, a single automation, a single workflow, a single document, a single folder, a single data connector, advanced permissions, and a single plug-in.

[0024] In some embodiments, in response to the deployment operation in the isolation environment, deploying at least part of the table change information to the first table includes:

[0025] In response to a selection operation on the table change information, determining at least one piece of the table change information;

[0026] In response to a triggering operation on the deployment control in the second configuration page, at least one piece of the table change information is updated to the first table.

[0027] In some embodiments, the method further comprises:

[0028] performing conflict checking based on at least one piece of the table change information and the table structure information and / or the table data information of the first table;

[0029] In response to the conflict check being passed, displaying a first prompt message, wherein the first prompt message is used to indicate that the at least one piece of table change information has passed the check;

[0030] In response to the conflict check failing, second prompt information is displayed, where the second prompt information is used to indicate the target table change information that fails the conflict check in the at least one table change information and the reason for failing the conflict check.

[0031] In some embodiments, the method further comprises:

[0032] Displaying a deployment log; the deployment log includes at least one deployment record, the deployment record includes at least one of deployment time information, deployment user information, and deployment content information, the deployment content information is generated based on the table change information;

[0033] as well as,

[0034] In response to a restore operation based on the deployment record, the first table is restored.

[0035] In some embodiments, the method further comprises:

[0036] In response to a second operation on the isolation environment, the isolation environment, the second table, and the table change information are deleted.

[0037] In some embodiments, the method further comprises:

[0038] generating the isolation environment and the second table based on the first operation of the first type of user;

[0039] generating the table change information based on the table configuration operation of the first type of user; and

[0040] At least part of the table change information is updated to the first table based on the deployment operation of the first type of user.

[0041] In some embodiments, the method further comprises:

[0042] Based on the access operation of the second type of user, the isolation environment and the table change information are displayed.

[0043] A second aspect of the present disclosure provides a table data processing device, comprising:

[0044] a creation module configured to: generate an isolated environment and a second table set in the isolated environment in response to a first operation on the first table; the second table includes table structure information and / or table data information of the first table;

[0045] a configuration module configured to: generate table change information in response to a table configuration operation on the second table;

[0046] The deployment module is configured to: deploy at least part of the table change information to the first table in response to a deployment operation in the isolation environment.

[0047] A third aspect of the present disclosure provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the table data processing method as described in the first aspect when executing the computer program.

[0048] A fourth aspect of the present disclosure provides a non-transitory computer-readable storage medium, wherein the non-transitory computer-readable storage medium stores computer instructions, and the computer instructions are used to enable the computer to execute the table data processing method described in the first aspect.

[0049] A fifth aspect of the present disclosure provides a computer program product, comprising computer program instructions, which, when executed on a computer, enable the computer to execute the table data processing method as described in the first aspect.

[0050] As can be seen from the above, the table data processing method and related equipment provided by the present disclosure create an isolated environment corresponding to the first table, and generate a second table corresponding to the first table in the isolated environment. When it is necessary to perform a table configuration operation on the first table to modify its table structure information, the second table in the isolated environment can be modified first. After the modification is completed, the modified table change information is updated to the first table in the production environment, thereby completing the modification of the first table. During the modification process, even if the change points are large, numerous, complex, and there are conflicts, it is not easy to make mistakes, and it will not affect the table data in the production environment, thereby reducing the development and testing costs of the table and ensuring the security of the table data. BRIEF DESCRIPTION OF THE DRAWINGS

[0051] In order to more clearly illustrate the technical solutions in the present disclosure or related technologies, the following briefly introduces the drawings required for use in the embodiments or related technical descriptions. Obviously, the drawings described below are only embodiments of the present disclosure. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0052] Figure 1 A schematic diagram showing an exemplary system provided by an embodiment of the present disclosure is shown.

[0053] Figure 2 A flowchart of an exemplary method provided by an embodiment of the present disclosure is shown.

[0054] Figure 3AA schematic diagram of an exemplary page according to an embodiment of the present disclosure is shown.

[0055] Figure 3B Another schematic diagram of an exemplary page according to an embodiment of the present disclosure is shown.

[0056] Figure 3C Another schematic diagram of an exemplary page according to an embodiment of the present disclosure is shown.

[0057] Figure 3D Another schematic diagram of an exemplary page according to an embodiment of the present disclosure is shown.

[0058] Figure 3E Another schematic diagram of an exemplary page according to an embodiment of the present disclosure is shown.

[0059] Figure 3F Another schematic diagram of an exemplary page according to an embodiment of the present disclosure is shown.

[0060] Figure 3G Another schematic diagram of an exemplary page according to an embodiment of the present disclosure is shown.

[0061] Figure 3H Another schematic diagram of an exemplary page according to an embodiment of the present disclosure is shown.

[0062] Figure 3I Another schematic diagram of an exemplary page according to an embodiment of the present disclosure is shown.

[0063] Figure 3J Another schematic diagram of an exemplary page according to an embodiment of the present disclosure is shown.

[0064] Figure 4 A schematic diagram of an exemplary device provided by an embodiment of the present disclosure is shown.

[0065] Figure 5 A schematic diagram of the hardware structure of an exemplary computer device provided by an embodiment of the present disclosure is shown. DETAILED DESCRIPTION

[0066] In order to make the objectives, technical solutions and advantages of the present disclosure more clearly understood, the present disclosure is further described in detail below in conjunction with specific embodiments and with reference to the accompanying drawings.

[0067] It should be noted that, unless otherwise defined, the technical terms or scientific terms used in the embodiments of the present disclosure should have the usual meanings understood by people with ordinary skills in the field to which the present disclosure belongs. The "first", "second" and similar words used in the embodiments of the present disclosure do not indicate any order, quantity or importance, but are only used to distinguish different components. "Include" or "comprise" and similar words mean that the elements or objects appearing before the word include the elements or objects listed after the word and their equivalents, without excluding other elements or objects. "Connect" or "connected" and similar words are not limited to physical or mechanical connections, but may include electrical connections, whether direct or indirect. "Up", "down", "left", "right" and the like are only used to indicate relative position relationships. When the absolute position of the described object changes, the relative position relationship may also change accordingly.

[0068] It is understandable that before using the technical solutions of each embodiment of the present disclosure, the type, scope of use, usage scenarios, etc. of the personal information involved will be informed to the user in an appropriate manner, and the user's authorization will be obtained.

[0069] For example, in response to a user's active request, a prompt message is sent to the user to clearly inform the user that the requested operation will require the acquisition and use of the user's personal information. This allows the user to independently choose whether to provide personal information to the electronic device, application, server, storage medium, or other software or hardware that performs the operation of the disclosed technical solution based on the prompt message.

[0070] As an optional but non-limiting implementation, in response to a user's active request, the prompt information may be sent to the user in the form of a pop-up window, in which the prompt information may be presented in text form. Furthermore, the pop-up window may also contain a selection control for the user to select "agree" or "disagree" to provide personal information to the electronic device.

[0071] It is understandable that the above notification and user authorization process are merely illustrative and do not constitute a limitation on the implementation of the present disclosure. Other methods that comply with relevant laws and regulations may also be applied to the implementation of the present disclosure.

[0072] Here, for the convenience of explanation, some concepts that may be involved in this disclosure are first introduced.

[0073] A sandbox is a secure environment isolated from the production environment, with the same functionality as the production environment. Developers can develop and test safely here without worrying about affecting the production environment.

[0074] The online environment is the environment actually used by customers and contains real data.

[0075] Deployment is the process of synchronizing all changes to the production environment after development and debugging are completed in the test environment.

[0076] Refresh the sandbox. The data in the sandbox has been copied from the online environment for a long time and is no longer suitable for continued development. At this time, you can copy the data from the online environment again to update the sandbox.

[0077] Figure 1 FIG. 1 is a schematic diagram of an exemplary system 100 provided by an embodiment of the present disclosure.

[0078] like Figure 1 As shown, the system 100 can be used to implement table data processing functions and can include terminal devices 102A and 102B, a server 106, and a database server 108. A medium (e.g., a network) providing a communication link can be included between the terminal devices 102A and 102B and the server 106 and the database server 108. The network can include various connection types, such as wired or wireless communication links or fiber optic cables.

[0079] Various applications (APPs) or software may be installed on the terminal devices 102A and 102B, such as online spreadsheet management software, online document applications or software including online spreadsheet management functions, collaborative office applications or software, social networking applications or software, web browsers, and instant messaging tools. In some embodiments, these applications or software may be used to implement spreadsheet data processing functions.

[0080] The terminal devices 102A and 102B herein can be either hardware or software. When the terminal devices 102A and 102B are hardware, they can be various electronic devices with display screens, including but not limited to smartphones, tablet computers, e-book readers, MP3 players, laptop computers, and desktop computers (PCs). When the terminal devices 102A and 102B are software, they can be installed in the electronic devices listed above. They can be implemented as multiple software programs or software modules (for example, to provide distributed services), or as a single software program or software module. This is not specifically limited here.

[0081] Server 106 may be a server that provides various services, such as a backend server that supports various applications displayed on terminal devices 102A and 102B. Database server 108 may also be a database server that provides various services. It is understood that if server 106 can implement the relevant functions of database server 108, database server 108 may not be provided in system 100.

[0082] The server 106 and database server 108 herein can also be hardware or software. When they are hardware, they can be implemented as a distributed server cluster consisting of multiple servers, or as a single server. When they are software, they can be implemented as multiple software programs or software modules (for example, to provide distributed services), or as a single software program or software module. No specific limitations are imposed herein.

[0083] It should be noted that the table data processing method provided in the embodiment of the present disclosure can be executed by the server 106. It should be understood that Figure 1 The numbers of terminal devices, users, servers and database servers in the embodiment are merely illustrative. Any number of terminal devices, users, servers and database servers may be provided as required.

[0084] In some embodiments, terminal devices 102A and 102B may have a table data processing application or software installed, and users 104A and 104B may use the application or software installed on terminal devices 102A and 102B to process table data. Specifically, user 104A is a first-type user who can use the application or software installed on terminal device 102A to configure table data; user 104B is a second-type user who can use the application or software installed on terminal device 102B to view table data.

[0085] Currently, when the user 104A configures and iterates an online form that is currently in use and has a certain degree of complexity through the terminal device 102A, there are usually two ways to do so.

[0086] Method 1: Modify directly in the production environment.

[0087] This type of modification can only be made with very little workload and risk, because once the changes are slightly larger, more numerous, or risky, it may affect the use of the production environment; at the same time, if problems occur during the modification process, it will directly affect the use of the production environment.

[0088] Method 2: Create a copy, make changes in the copy table, and then manually move it to the production environment.

[0089] This modification method requires users to manually complete the entire process, from creating a replica, recording the change points, and moving the replica table to the table in the production environment, which is costly. It is also prone to errors when changing the number of points, and the modification requires that the table in the production environment must not be modified. Otherwise, conflicts will be difficult to detect. It involves multiple aspects of information such as personnel, messages, and schedules, which may still affect users and data in the production environment.

[0090] In view of this, an embodiment of the present disclosure provides a table data processing method to solve the above problems.

[0091] Figure 2 A flowchart of an exemplary method provided by an embodiment of the present disclosure is shown.

[0092] like Figure 2 As shown, the table data processing method includes:

[0093] Step S101 : generating an isolated environment and a second table set in the isolated environment in response to a first operation on a first table; the second table includes table structure information and / or table data information of the first table.

[0094] The first form can be an online form in a production environment. An online form stores spreadsheet data on a cloud server, exchanges data with the cloud server via network communication, and displays the form content through a display interface. Online forms enable cloud storage of spreadsheet data and multi-terminal data synchronization.

[0095] The isolated environment may include a sandbox, or may be other types of isolated environments, which are not limited in this embodiment. In this embodiment, the technical solution of the present disclosure is described in detail using a sandbox as an example.

[0096] In this embodiment, a sandbox is generated by a first operation on a first table. The sandbox also includes a second table. The second table is generated based on the first table. That is, the second table is generated based on at least part of the table structure information of the first table and / or at least part of the table data information of the first table. That is, in this embodiment, when the sandbox is created, part or all of the table structure information of the first table is synchronously copied and stored in the sandbox as the table structure information of the second table. At the same time, part or all of the table data information of the first table can also be copied and stored in the sandbox as the table data information of the second table.

[0097] That is, in this embodiment, after the sandbox is created, the second table will be displayed in the sandbox. The second table may include at least part of the table structure information of the first table and / or at least part of the table data information.

[0098] In some embodiments, the isolated environment and the second table are generated based on a first operation by a first type of user. The first type of user may be, for example, an administrator user, or another user configured with permission to manage the isolated environment, which is not limited in this embodiment. The first type of user, such as user 104A, may use terminal device 102A to perform the first operation on the isolated environment and the second table.

[0099] Step S103: generating table modification information in response to the table configuration operation on the second table.

[0100] In this embodiment, table configuration operations are performed on the second table in the sandbox to configure the table structure information, thereby generating table change information. The table change information includes table structure change information. Since the table structure information of the second table in the sandbox is identical to the table structure information of the first table, the table change information generated by performing the table configuration operation on the second table can also be applied to the first table. Furthermore, since the sandbox and production environments are isolated and do not affect each other, table configuration operations performed on the second table in the sandbox will not affect the first table in the production environment.

[0101] In some embodiments, the table change information may further include table data change information. In this embodiment, the table data change information is generated by editing the table structure information of the second table in the sandbox through a table configuration operation. Because the table data information of the second table in the sandbox is at least partially identical to the table data information of the first table, the table data change information generated by performing the table configuration operation on the second table can also be applied to the first table.

[0102] In some embodiments, the table modification information is generated based on the table configuration operation of the first type of user. That is, in this embodiment, the first type of user, such as user 104A, can use the terminal device 102A to perform the table configuration operation, thereby generating the table modification information.

[0103] In some embodiments, the sandbox and table change information are displayed based on access operations by a second type of user. The second type of user is, for example, a user configured with access to the sandbox. That is, in this embodiment, after the first type of user creates the sandbox and the second table and completes the table configuration operation to generate table change information, the second type of user, such as user 104B, can access the sandbox using terminal device 102B to view the table change information in the sandbox.

[0104] Step S105 : In response to the deployment operation in the isolated environment, update at least part of the table change information to the first table.

[0105] During the process of performing table configuration operations on the second table, table changes at multiple locations may be involved, and multiple modifications to the same location may also be involved. Conflicts and other issues may also arise during the modification process. Therefore, in this embodiment, table change information can be generated after the table changes and verification are completed in the sandbox. Subsequently, at least part of the table change information can be uniformly updated to the first table through a deployment operation. In this way, even if table changes at multiple locations or multiple modifications to the same location are involved, they will not be missed during the update and errors are less likely to occur. At the same time, even if conflicts and other issues may arise during the modification process, the modifications can be verified in the sandbox before being updated to the first table in the production environment, avoiding conflicts that are difficult to detect.

[0106] In this embodiment, an isolated environment corresponding to the first table is created, and a second table corresponding to the first table is generated in the isolated environment. When it is necessary to perform a table configuration operation on the first table to modify its table structure information, the second table in the isolated environment can be modified first. After the modification is completed, the modified table change information is updated to the first table in the production environment, thereby completing the modification of the first table. During the modification process, even if the change points are large, numerous, complex, and there are conflicts, it is not easy to make mistakes, and it will not affect the table data in the production environment, thereby reducing the development and testing costs of the table and ensuring the security of the table data.

[0107] In some embodiments, generating an isolated environment and a second table set in the isolated environment in response to the first operation on the first table in step S103 includes:

[0108] Step S201: In response to a triggering operation on a first control in the first table, a first configuration page for the isolation environment is displayed.

[0109] like Figure 3A As shown, in this embodiment, the first form 101 includes a first control 1013 for creating an isolated environment. The first control 1013 may be a control for managing a sandbox. In some embodiments, a first-type user may trigger more controls 1011 in the first form 101 to display a control window, and then further trigger a sandbox control in the control window to display the first control 1013. Alternatively, the first control 1013 may be displayed directly on the page where the first form 101 is located, which is not limited in this embodiment.

[0110] like Figure 3B As shown, when the first type of user triggers the first control 1013, a sandbox is created and a first configuration page 102 for the sandbox is displayed. The first configuration page 102 may be a page for performing sandbox configuration.

[0111] Among them, the first configuration page may include a third prompt information 1021, and the third prompt information 1021 is used to indicate the properties and functions of the sandbox, that is, the third prompt information 1021 prompts the user that the sandbox is an isolated environment, and the user can experiment and test the table configuration operation in the sandbox, and update it to the first table in the production environment after completing the table configuration operation.

[0112] After the first type of user completes the creation of the isolation environment and the second table, the second type of user can access the isolation environment. Figure 3A As shown, the second type of user can trigger the access sandbox control 1014 to access the sandbox and view the content in the sandbox.

[0113] Step S203: In response to the first selection operation on the first configuration page, create the isolation environment and the second table containing the table structure information.

[0114] Step S205 : In response to the second selection operation on the first configuration page, creating the isolation environment and the second table including the table structure information and the table data information.

[0115] In this embodiment, the copy range of the second table is determined by triggering the first selection operation and the second selection operation on the first configuration page.

[0116] When the first type of user triggers the control 1022 for copying only the table structure, only part or all of the table structure information of the first table is synchronously copied as the table structure information of the second table.

[0117] When the first type of user triggers the control 1023 for copying the table structure and table data, part or all of the table structure information of the first table is copied as the table structure information of the second table, and part or all of the table data information of the first table is copied as the table data information of the second table.

[0118] By triggering the first selection operation or the second selection operation on the first configuration page 102 , the configuration of the sandbox and the second table is completed.

[0119] In some embodiments, the method further includes: in response to a configuration modification operation on the isolation environment, modifying at least one of a content scope obtained by the second table from the first table and an access user of the isolation environment.

[0120] In this embodiment, the configuration of the sandbox and the second table may also be modified.

[0121] like Figure 3JAs shown, in the configuration page, you can view the content range of the currently set second table obtained from the first table; you can also re-modify the content range that the second table obtains from the first table, that is, re-determine whether to synchronously copy only part or all of the table structure information of the first table as the table structure information of the second table, or to copy part or all of the table structure information of the first table as the table structure information of the second table, and at the same time copy part or all of the table data information of the first table as the table data information of the second table.

[0122] like Figure 3J As shown, on the configuration page, you can view the users who can currently access the isolated environment, and you can also add new users who can access the isolated environment.

[0123] like Figure 3J As shown, in the configuration page, the creation time of the isolation environment can be viewed, and the data of the isolation environment can be updated by triggering the refresh control 1051.

[0124] In some embodiments, the method further comprises:

[0125] Step S301: display a second configuration page of the isolation environment.

[0126] like Figure 3C As shown, the second configuration page 103 may be a change item page for displaying table change information.

[0127] In this embodiment, after completing the configuration of the sandbox and the second table, the second configuration page 103 may be displayed.

[0128] When the sandbox and the second table are created, there is no table change information on the second configuration page 103. Therefore, the second configuration page will display a fourth prompt message 1031. The fourth prompt message 1031 is used to indicate that there is no table change information in the current sandbox. The fourth prompt message 1031 can be, for example, "No changes have been made" or "No changes have been made to your sandbox."

[0129] Step S303: In response to a triggering operation on a second control in the second configuration page, display the second table in the isolated environment.

[0130] In this embodiment, the second configuration page 103 displays a second control 1032 for accessing the sandbox. Figure 3D As shown, when the first type of user triggers the second control 1032 , the user enters the sandbox and can display the second table 104 in the sandbox. The user can then perform table configuration operations on the second table 104 .

[0131] In some embodiments, the second table displayed in the sandbox also includes fifth prompt information 1041. The fifth prompt information 1041 is used to remind the user that the user is currently in a sandbox environment and all table configuration operations are ineffective and will only take effect after deployment to the production environment.

[0132] In some embodiments, the fifth prompt information 1041 may further include a statistical number of table modification information that has been generated, such as “X changes have been generated”.

[0133] In some embodiments, the method further includes: in response to a refresh operation on the second table, reacquiring the table structure information and / or the table data information of the first table to generate the second table.

[0134] like Figure 3D As shown, in this embodiment, the second table 104 displayed in the sandbox includes a refresh control 1043. When the first type of user triggers the refresh control 1043, the second table 104 can be refreshed. Through the refresh operation, the table structure information and / or table data information of the first table 101 can be retrieved to regenerate the second table 104 in the sandbox, so as to perform table configuration operations based on the regenerated second table 104, thereby ensuring that the table configuration operations of the first type of user are performed based on the current first table, avoiding modification conflicts caused by inconsistencies between the second table 104 in the sandbox and the first table 101 in the production environment.

[0135] In some embodiments, after generating the table change information in step S103, the method further includes:

[0136] Step S401: displaying the table change information on the second configuration page.

[0137] like Figure 3E As shown, in this embodiment, after the table change information is generated, the table change information is displayed in the second configuration page 103.

[0138] Step S403 : in response to the viewing operation on the table change information, display at least one of the name, module, change type, operating user, operating time, and associated entity of the object corresponding to the table change information.

[0139] In this embodiment, by viewing any table change information in the second configuration page 103, for example, triggering the viewing control 1034 for any table change information, all table change information related to the object to which the table change information belongs can be displayed, including the name of the object, the module to which the object belongs, the change type, the operating user, the operation time, the associated objects, etc.

[0140] In some embodiments, the second configuration page 103 can filter and view the table change information based on conditions such as the module to which the object belongs, the operating user, and the operation time.

[0141] The change type refers to the type of table configuration operation, and may include, for example, one of adding, deleting, and modifying.

[0142] Among them, when an object is both added and updated, the change type is added, and only one table change information of the object is displayed; when an object is both added and deleted, the object is not displayed; when an object has multiple updates, the updates of the same object are displayed in the same table change information.

[0143] In some embodiments, for a target object among the objects, different information before and after the table configuration operation is performed on the object may be displayed.

[0144] The object includes at least one of a field, a data table, a collection table, a form, a dashboard, a single automation, a single workflow, a single document, a single folder, a single data connector, advanced permissions, and a single plug-in.

[0145] In this embodiment, all table change information can be displayed by triggering the viewing control 1034 corresponding to each table change information.

[0146] Step S405 : In response to the triggering operation on the name, information of the object corresponding to the name in the second table is displayed.

[0147] In this embodiment, by triggering the name of the object, the corresponding object in the second table in the sandbox can be displayed.

[0148] In some embodiments, when the user triggers the access sandbox control 1033, the user can enter the sandbox again and display the second table 104 in the sandbox. The user can then perform table configuration operations on the second table 104 again.

[0149] In some embodiments, in response to the deployment operation in the isolated environment, updating at least part of the table change information to the first table in step S105 includes:

[0150] Step S501 : In response to a selection operation on the table change information, determining at least one piece of the table change information.

[0151] Step S503: in response to a triggering operation on the deployment control in the second configuration page, updating at least one piece of the table change information to the first table.

[0152] like Figure 3FAs shown, in this embodiment, the first type of user can select one or more table change information for deployment.

[0153] A deployment control 1035 may be displayed in the second configuration page 103 . By triggering the deployment control 1035 , one or more table change information selected by the first type of user is updated to the first table 101 .

[0154] In some embodiments, the method further comprises:

[0155] Step S601 : performing conflict check based on at least one piece of table change information and table structure information and / or table data information of the first table.

[0156] In this embodiment, when at least one table change information in the sandbox is updated to the first table by triggering the deployment control 1035 , conflict check is performed using the at least one table change information in the sandbox and the table structure information and / or table data information of the first table.

[0157] Among them, the conflict check may include: whether the information on which at least one table change information in the sandbox depends exists in the first table, whether the information on which at least one table change information in the sandbox depends conflicts with the data in the first table, whether the data type of the field added in the table change information matches, whether the content of the field added in the table change information can be obtained in real time or asynchronously, whether the conditions support the data type of the field, etc.

[0158] Step S603 : In response to the conflict check being passed, displaying a first prompt message, wherein the first prompt message is used to indicate that the at least one piece of table modification information has passed the check.

[0159] like Figure 3G As shown, in this embodiment, when the conflict check passes, a first prompt message 1041 may be displayed in the deployment check window 104. The first prompt message 1041 is used to indicate that the table change information check has passed. At this time, if the first type of user continues to trigger the start deployment control 1043, the corresponding table change information may be updated to the first table.

[0160] At the same time, the deployment verification window 104 may also display the change information of each table that has passed the verification, and the detailed information of the change information of each table that has passed the verification may be displayed by triggering the expansion detail control 1042 .

[0161] Step S605 : In response to the conflict check failing, displaying a second prompt message, wherein the second prompt message is used to indicate the target table change information that fails the conflict check in the at least one table change information and the reason for failing the conflict check.

[0162] like Figure 3H As shown, in this embodiment, when the conflict check fails, a second prompt message 1044 can be displayed in another tab page (tab page) of the deployment check window 104. The second prompt message 1044 is used to indicate the target table change information that failed the conflict check in the table change information and the reason for failing the conflict check. At this time, the start deployment control 1043 is set to an untriggerable state, and the first type of user cannot trigger the start deployment control 1043 to perform the deployment operation. In this embodiment, through conflict checking, it is ensured that the table change information in the first table deployed to the production environment will not have an adverse effect on the first table.

[0163] In some embodiments, the method further includes: displaying a deployment log; the deployment log includes at least one deployment record, the deployment record includes at least one of deployment time information, deployment user information, and deployment content information, and the deployment content information is generated based on the table change information.

[0164] like Figure 3I As shown, in this embodiment, the deployment log is displayed on the deployment log display page. The deployment log includes at least one deployment record displayed in a timeline format. The deployment record may include at least one of deployment time information, deployment user information, and deployment content information. The deployment content information is generated based on the table change information, that is, the deployment content information is used to indicate which objects in the first table were modified by this deployment.

[0165] In some embodiments, the method further includes: restoring the first table in response to a restore operation based on the deployment record.

[0166] In this embodiment, the deployment record may be stored in a Time Machine manner, so that a restore operation can be performed on the deployment record, thereby restoring the first table.

[0167] In some embodiments, the method further includes: deleting the isolation environment, the second table, and the table change information in response to a second operation on the isolation environment.

[0168] like Figure 3A As shown, in this embodiment, the first form 101 includes a delete sandbox control 1015. The first type of user can delete the sandbox by triggering the delete sandbox control 1015, and at the same time clear the second form, form change information and other contents in the sandbox. After that, the first type of user can recreate the sandbox.

[0169] In some embodiments, the method further includes: generating first information for sending to a first application based on the table configuration operation, and simulating a process of sending the first information to the first application in the isolation environment.

[0170] In this embodiment, when a table configuration operation is performed on the first table, information needs to be generated for sending to a first application outside the first table. The first application can be, for example, an instant messaging system. When the corresponding first information is generated based on the table configuration operation of the second table in the isolated environment, the first information will not be sent to the first application outside the isolated environment, but the sending process of the first information will be simulated in the isolated environment. It should be noted that the method of the embodiment of the present disclosure can be executed by a single device, such as a computer or server. The method of this embodiment can also be applied in a distributed scenario and completed by multiple devices cooperating with each other. In the case of such a distributed scenario, one of the multiple devices can only execute one or more steps in the method of the embodiment of the present disclosure, and the multiple devices will interact with each other to complete the described method.

[0171] It should be noted that the above description is limited to some embodiments of the present disclosure. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims may be performed in an order different from that described in the above embodiments and still achieve the desired results. Furthermore, the processes depicted in the accompanying drawings do not necessarily require the specific order or sequential order shown to achieve the desired results. In certain embodiments, multitasking and parallel processing are also possible or may be advantageous.

[0172] Based on the same inventive concept, corresponding to any of the above-mentioned embodiments and methods, the present disclosure also provides a device.

[0173] refer to Figure 4 , the table data processing device comprises:

[0174] The creation module 11 is configured to: generate an isolated environment and a second table set in the isolated environment in response to a first operation on the first table; the second table includes table structure information and / or table data information of the first table;

[0175] The configuration module 13 is configured to: generate table change information in response to a table configuration operation on the second table;

[0176] The deployment module 15 is configured to: deploy at least part of the table change information to the first table in response to a deployment operation in the isolation environment.

[0177] In some embodiments, the creation module 11 is further configured to:

[0178] In response to a triggering operation on a first control in the first table, displaying a first configuration page for the isolation environment;

[0179] In response to a first selection operation on the first configuration page, creating the isolation environment and the second table containing the table structure information;

[0180] In response to a second selection operation on the first configuration page, the isolation environment and the second table including the table structure information and the table data information are created.

[0181] In some embodiments, the apparatus is further configured to:

[0182] Displaying a second configuration page for the isolation environment;

[0183] In response to a triggering operation on a second control in the second configuration page, the second table is displayed in the isolated environment.

[0184] In some embodiments, the apparatus is further configured to:

[0185] In response to a refresh operation on the second table, the table structure information and / or the table data information of the first table are reacquired to generate the second table.

[0186] In some embodiments, the apparatus is further configured to:

[0187] Displaying the table change information on the second configuration page;

[0188] In response to a viewing operation on the table change information, displaying at least one of a name, a module, a change type, an operating user, an operating time, and an associated object of an object corresponding to the table change information;

[0189] In response to a trigger operation on the name, information of the object corresponding to the name in the second table is displayed.

[0190] In some embodiments, the table configuration operation includes one of adding, deleting, and modifying the object;

[0191] The object includes at least one of a field, a data table, a collection table, a form, a dashboard, a single automation, a single workflow, a single document, a single folder, a single data connector, advanced permissions, and a single plug-in.

[0192] In some embodiments, the deployment module 15 is further configured to:

[0193] In response to a selection operation on the table change information, determining at least one piece of the table change information;

[0194] In response to a triggering operation on the deployment control in the second configuration page, at least one piece of the table change information is updated to the first table.

[0195] In some embodiments, the apparatus is further configured to:

[0196] performing conflict checking based on at least one piece of the table change information and the table structure information and / or the table data information of the first table;

[0197] In response to the conflict check being passed, displaying a first prompt message, wherein the first prompt message is used to indicate that the at least one piece of table change information has passed the check;

[0198] In response to the conflict check failing, second prompt information is displayed, where the second prompt information is used to indicate the target table change information that fails the conflict check in the at least one table change information and the reason for failing the conflict check.

[0199] In some embodiments, the apparatus is further configured to:

[0200] Displaying a deployment log; the deployment log includes at least one deployment record, the deployment record includes at least one of deployment time information, deployment user information, and deployment content information, the deployment content information is generated based on the table change information;

[0201] as well as,

[0202] In response to a restore operation based on the deployment record, the first table is restored.

[0203] In some embodiments, the apparatus is further configured to:

[0204] In response to a second operation on the isolation environment, the isolation environment, the second table, and the table change information are deleted.

[0205] In some embodiments, the apparatus is further configured to:

[0206] generating the isolation environment and the second table based on the first operation of the first type of user;

[0207] generating the table change information based on the table configuration operation of the first type of user; and

[0208] At least part of the table change information is updated to the first table based on the deployment operation of the first type of user.

[0209] In some embodiments, the apparatus is further configured to:

[0210] Based on the access operation of the second type of user, the isolation environment and the table change information are displayed.

[0211] For the convenience of description, the above devices are described as being functionally divided into various modules. Of course, when implementing the present disclosure, the functions of each module can be implemented in the same or multiple software and / or hardware.

[0212] The apparatus of the above embodiment is used to implement the corresponding table data processing method in any of the above embodiments, and has the beneficial effects of the corresponding method embodiment, which will not be described in detail here.

[0213] Based on the same inventive concept, corresponding to any of the above-mentioned embodiments and methods, the present disclosure also provides an electronic device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the program, the table data processing method described in any of the above embodiments is implemented.

[0214] Figure 5 10 is a schematic diagram showing a more specific hardware structure of an electronic device provided in this embodiment. The device may include: a processor 1010, a memory 1020, an input / output interface 1030, a communication interface 1040, and a bus 1050. The processor 1010, the memory 1020, the input / output interface 1030, and the communication interface 1040 are communicatively connected to each other within the device via the bus 1050.

[0215] The processor 1010 can be implemented using a general-purpose CPU (Central Processing Unit), a microprocessor, an application-specific integrated circuit (ASIC), or one or more integrated circuits, and is used to execute relevant programs to implement the technical solutions provided in the embodiments of this specification.

[0216] The memory 1020 can be implemented in the form of ROM (Read Only Memory), RAM (Random Access Memory), static storage devices, dynamic storage devices, etc. The memory 1020 can store an operating system and other application programs. When the technical solutions provided in the embodiments of this specification are implemented through software or firmware, the relevant program code is stored in the memory 1020 and is called and executed by the processor 1010.

[0217] The input / output interface 1030 is used to connect input / output modules to implement information input and output. The input / output modules can be configured as components within the device (not shown in the figure) or can be externally connected to the device to provide corresponding functions. Input devices may include a keyboard, mouse, touch screen, microphone, various sensors, etc., and output devices may include a display, speaker, vibrator, indicator light, etc.

[0218] The communication interface 1040 is used to connect to a communication module (not shown) to enable communication between the device and other devices. The communication module can communicate via a wired method (such as USB, network cable, etc.) or a wireless method (such as mobile network, WiFi, Bluetooth, etc.).

[0219] The bus 1050 comprises a path for transmitting information between the various components of the device (eg, the processor 1010 , the memory 1020 , the input / output interface 1030 , and the communication interface 1040 ).

[0220] It should be noted that although the above device only shows the processor 1010, the memory 1020, the input / output interface 1030, the communication interface 1040, and the bus 1050, in a specific implementation, the device may also include other components necessary for normal operation. In addition, it will be understood by those skilled in the art that the above device may only include the components necessary to implement the embodiments of this specification, and does not necessarily include all the components shown in the figure.

[0221] The electronic device of the above embodiment is used to implement the corresponding table data processing method in any of the above embodiments, and has the beneficial effects of the corresponding method embodiment, which will not be described in detail here.

[0222] Based on the same inventive concept, corresponding to any of the above-mentioned embodiment methods, the present disclosure also provides a non-transitory computer-readable storage medium, which stores computer instructions, and the computer instructions are used to enable the computer to execute the table data processing method described in any of the above embodiments.

[0223] The computer-readable media of this embodiment include permanent and non-permanent, removable and non-removable media that can be used to store information by any method or technology. The information can be computer-readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, read-only compact disc read-only memory (CD-ROM), digital versatile disc (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device.

[0224] The computer instructions stored in the storage medium of the above embodiment are used to enable the computer to execute the table data processing method described in any of the above embodiments, and have the beneficial effects of the corresponding method embodiments, which will not be repeated here.

[0225] Based on the same inventive concept, corresponding to any of the above-described embodiments and methods, the present disclosure further provides a computer program product comprising a computer program. In some embodiments, the computer program is executable by one or more processors to cause the processors to perform the table data processing method. For each step in each embodiment of the method, the processor executing the step may be a member of the corresponding execution entity.

[0226] The computer program product of the above embodiment is used to enable the processor to execute the table data processing method described in any of the above embodiments, and has the beneficial effects of the corresponding method embodiment, which will not be repeated here.

[0227] Those skilled in the art will appreciate that embodiments of the present disclosure may be implemented as a system, method, or computer program product. Therefore, the present disclosure may be implemented in the following forms: entirely in hardware, entirely in software (including firmware, resident software, microcode, etc.), or in a combination of hardware and software, generally referred to herein as a "circuit," "module," or "system." Furthermore, in some embodiments, the present disclosure may also be implemented in the form of a computer program product in one or more computer-readable media containing computer-readable program code.

[0228] Any combination of one or more computer-readable media can be used. A computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. A computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or component, or any combination thereof. More specific examples (non-exhaustive examples) of computer-readable storage media can include, for example: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof. In this document, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, device or device.

[0229] A computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, which carries computer-readable program code. Such propagated data signals may take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. A computer-readable signal medium may also be any computer-readable medium other than a computer-readable storage medium that can transmit, propagate, or transport a program for use by or in conjunction with an instruction execution system, apparatus, or device.

[0230] Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

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

[0232] It should be understood that each block in the flowchart and / or block diagram, and combinations of blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device to produce a machine. These computer program instructions are executed by the computer or other programmable data processing device to produce a device that implements the functions / operations specified in the blocks in the flowchart and / or block diagram.

[0233] These computer program instructions can also be stored in a computer-readable medium that enables a computer or other programmable data processing device to operate in a specific manner. In this way, the instructions stored in the computer-readable medium produce a product that includes an instruction device that implements the functions / operations specified in the blocks in the flowchart and / or block diagram.

[0234] Computer program instructions may also be loaded onto a computer, other programmable data processing apparatus, or other device so that a series of operational steps are performed on the computer, other programmable data processing apparatus, or other device to produce a computer-implemented process, such that the instructions executed on the computer or other programmable apparatus provide a process that implements the functions / operations specified in the blocks in the flowchart and / or block diagram.

[0235] Furthermore, although the operations of the disclosed method are described in a particular order in the accompanying drawings, this does not require or imply that the operations must be performed in that particular order, or that all of the operations shown must be performed to achieve the desired results. Rather, the steps depicted in the flowcharts may be performed in a different order. Additionally or alternatively, certain steps may be omitted, multiple steps may be combined into a single step, and / or a single step may be broken down into multiple steps.

[0236] The flowcharts and block diagrams in the accompanying drawings illustrate the possible implementation architecture, functions and operations of the systems, methods and computer program products according to various embodiments of the present application. Among them, each box in the flowchart or block diagram can represent a module, program segment, or part of the code, and the above-mentioned module, program segment, or part of the code contains one or more executable instructions for implementing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in an order different from that marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flowchart, and the combination of boxes in the block diagram or flowchart, can be implemented with a dedicated hardware-based system that performs the specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0237] It should be noted that, although several modules or units of the device for action execution are mentioned in the above detailed description, this division is not mandatory. In fact, according to the embodiment of the application, the features and functions of two or more modules or units described above can be concretized in one module or unit. On the contrary, the features and functions of one module or unit described above can be further divided into multiple modules or units to be concretized.

[0238] Those skilled in the art should understand that the discussion of any of the above embodiments is merely illustrative and is not intended to imply that the scope of the present disclosure (including the claims) is limited to these examples. Within the scope of the present disclosure, the technical features in the above embodiments or different embodiments may be combined, the steps may be implemented in any order, and there are many other variations of the different aspects of the embodiments of the present disclosure as described above, which are not provided in detail for the sake of simplicity.

[0239] In addition, to simplify the description and discussion, and so as not to obscure the embodiments of the present disclosure, known power / ground connections to integrated circuit (IC) chips and other components may or may not be shown in the provided figures. In addition, devices may be shown in the form of block diagrams to avoid obscuring the embodiments of the present disclosure, and this also takes into account the fact that the details of the implementation of these block diagram devices are highly dependent on the platform on which the embodiments of the present disclosure are to be implemented (i.e., these details should be fully within the purview of those skilled in the art). Where specific details (e.g., circuits) are set forth to describe exemplary embodiments of the present disclosure, it will be apparent to those skilled in the art that the embodiments of the present disclosure may be implemented without these specific details or with variations in these specific details. Therefore, these descriptions should be considered illustrative rather than restrictive.

[0240] Although the present disclosure has been described in conjunction with specific embodiments thereof, many alternatives, modifications, and variations of these embodiments will be apparent to those skilled in the art based on the foregoing description. For example, other memory architectures (e.g., dynamic RAM (DRAM)) may use the embodiments discussed.

[0241] The embodiments of the present disclosure are intended to cover all such substitutions, modifications, and variations that fall within the broad scope of the appended claims. Therefore, any omissions, modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the embodiments of the present disclosure should be included in the scope of protection of the present disclosure.

Claims

1. A table data processing method, comprising: In response to a first operation on a first table, generating an isolation environment and a second table set in the isolation environment; The second table includes table structure information and / or table data information of the first table; generating table change information in response to a table configuration operation on the second table; In response to a deployment operation in the isolation environment, at least part of the table change information is deployed to the first table.

2. The method according to claim 1, wherein The step of generating an isolated environment and a second table set in the isolated environment in response to a first operation on the first table includes: In response to a triggering operation on a first control in the first table, displaying a first configuration page for the isolation environment; In response to a first selection operation on the first configuration page, creating the isolation environment and the second table containing the table structure information; In response to a second selection operation on the first configuration page, the isolation environment and the second table including the table structure information and the table data information are created.

3. The method according to claim 1, further comprising: Displaying a second configuration page for the isolation environment; In response to a triggering operation on a second control in the second configuration page, the second table is displayed in the isolated environment.

4. The method according to claim 1, further comprising: In response to a refresh operation on the second table, the table structure information and / or the table data information of the first table are reacquired to generate the second table.

5. The method according to claim 3, further comprising: Displaying the table change information on the second configuration page; In response to a viewing operation on the table change information, displaying at least one of a name, a module, a change type, an operating user, an operating time, and an associated object of an object corresponding to the table change information; In response to a trigger operation on the name, information of the object corresponding to the name in the second table is displayed.

6. The method according to claim 5, wherein: The table configuration operation includes one of adding, deleting, and modifying the object; The object includes at least one of a field, a data table, a collection table, a form, a dashboard, a single automation, a single workflow, a single document, a single folder, a single data connector, advanced permissions, and a single plug-in.

7. The method according to claim 5, wherein: In response to the deployment operation in the isolation environment, deploying at least part of the table change information to the first table includes: In response to a selection operation on the table change information, determining at least one piece of the table change information; In response to a triggering operation on the deployment control in the second configuration page, at least one piece of the table change information is updated to the first table.

8. The method according to claim 7, further comprising: performing conflict checking based on at least one piece of the table change information and the table structure information and / or the table data information of the first table; In response to the conflict check being passed, displaying a first prompt message, wherein the first prompt message is used to indicate that the at least one piece of table change information has passed the check; In response to the conflict check failing, second prompt information is displayed, where the second prompt information is used to indicate the target table change information that fails the conflict check in the at least one table change information and the reason for failing the conflict check.

9. The method according to claim 1, further comprising: Displaying a deployment log; the deployment log includes at least one deployment record, the deployment record includes at least one of deployment time information, deployment user information, and deployment content information, the deployment content information is generated based on the table change information; as well as, In response to a restore operation based on the deployment record, the first table is restored.

10. The method according to claim 1, further comprising: In response to a second operation on the isolation environment, the isolation environment, the second table, and the table change information are deleted.

11. The method according to any one of claims 1 to 10, further comprising: generating the isolation environment and the second table based on the first operation of the first type of user; generating the table change information based on the table configuration operation of the first type of user; as well as, At least part of the table change information is updated to the first table based on the deployment operation of the first type of user.

12. The method according to any one of claims 1 to 10, further comprising: Based on the access operation of the second type of user, the isolation environment and the table change information are displayed.

13. A table data processing device, comprising: a creation module configured to: generate an isolated environment and a second table set in the isolated environment in response to a first operation on the first table; the second table includes table structure information and / or table data information of the first table; a configuration module configured to: generate table change information in response to a table configuration operation on the second table; The deployment module is configured to: deploy at least part of the table change information to the first table in response to a deployment operation in the isolation environment.

14. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the table data processing method according to any one of claims 1 to 12 when executing the computer program. 15 . A non-transitory computer-readable storage medium storing computer instructions, wherein the computer instructions are used to cause the computer to execute the table data processing method according to claim 1 .

16. A computer program product, characterized in that The method comprises computer program instructions, which, when executed on a computer, enable the computer to execute the table data processing method according to any one of claims 1 to 12.

Images