Table data processing method and device, electronic equipment, readable storage medium and computer program product

Abstract

The invention provides a table data processing method and device, electronic equipment, a readable storage medium and a computer program product, and belongs to the technical field of data processing. The method comprises the steps that a cross-data-source operation request received in a second data container is responded, permission verification is carried out, and the cross-data-source operation request is triggered through target configuration operation; based on the permission verification result, a first data source is displayed, and the first data source comprises a first data container, a first data table in the first data container and a first field in the first data table; and in response to a selection operation on the first data source, establishing a data association relationship between the target configuration operation and the first data source. According to the invention, data intercommunication between different tables in the same spatial range can be realized.

Description

TECHNICAL FIELD

[0001] Embodiments of the present disclosure relate to the technical field of data processing, in particular to a table data processing method and device, electronic equipment, readable storage medium and computer program product. BACKGROUND

[0002] When facing data from different data sources, how to intercommunicate data across data sources is a problem often involved in database processing. At present, the conventional solution to this problem is to redundantly store data from different data sources in the same data source, and then perform cross-table operations in the same data source.

[0003] For example, for two tables A and B not in the same database, when table A of database A needs to reference data of table B of database B, the conventional method is to associate database B with database A, add a mirror field to database A, store the field in database B into database A through the mirror field, and finally make table A and table B in the same database, and then perform cross-table operations in the same database.

[0004] The above method needs to add a mirror field to the current database first, which complicates the structure of the current database, and the above method needs to consume a large amount of storage resources, especially in big data processing, since the capacity of each data table is very large, this method undoubtedly causes a huge waste of storage resources. SUMMARY

[0005] Embodiments of the present disclosure provide a table data processing method and device, electronic equipment, readable storage medium and computer program product, which can solve the problem that the existing cross-data-source data intercommunication implementation complicates the structure of the current database and causes a huge waste of storage resources.

[0006] To solve the above technical problem, the present disclosure is implemented as follows: In a first aspect, a table data processing method is provided, comprising: In response to receiving a cross-data-source operation request in a second data container, performing permission verification, the cross-data-source operation request being triggered by a target configuration operation; Based on the permission verification result, displaying a first data source, wherein the first data source includes a first data container, a first data table in the first data container, and a first field in the first data table; In response to a selection operation on the first data source, establishing a data association relationship between the target configuration operation and the first data source.

[0007] In a second aspect, a table data processing device is provided, comprising: The acquisition module is configured to receive a cross-data source operation request at a second data container, the cross-data source operation request being triggered by a target configuration operation; The verification module is configured to, in response to receiving the cross-data source operation request at the second data container, perform permission verification, and display a first data source based on a permission verification result, wherein the first data source includes a first data container, a first data table in the first data container, and a first field in the first data table. The data processing module is configured to, in response to a selection operation on the first data source, establish a data association relationship between the target configuration operation and the first data source.

[0008] In a third aspect, an electronic device is provided, which includes a processor and a memory, the memory storing at least one computer program, the at least one computer program being loaded and executed by the processor to implement the table data processing method described above.

[0009] In a fourth aspect, a readable storage medium is provided, the readable storage medium storing at least one computer program, the computer program being loaded and executed by a processor to implement the table data processing method described above.

[0010] In a fifth aspect, a computer program product is provided, the computer program product including at least one computer program, the computer program being loaded and executed by a processor to implement the table data processing method provided in various optional implementation manners described above.

[0011] The table data processing method, device, electronic device, readable storage medium, and computer program product provided by the embodiments of the present disclosure can enable data intercommunication between different tables within the same spatial range, without adding fields in the current data container, simplifying the operation path and the underlying structure, simplifying the table structure, and not changing the storage location of the data source, thereby overcoming the problem of wasting a large amount of storage resources and causing great waste of storage resources in the prior art.

[0012] It should be understood that the foregoing general description and the following detailed description are only exemplary and explanatory, and cannot limit the present disclosure. BRIEF DESCRIPTION OF DRAWINGS

[0013] The accompanying drawings, which are incorporated into the specification and constitute a part of the specification, illustrate embodiments consistent with the present disclosure and, together with the specification, serve to explain the principles of the present disclosure.

[0014] Figure 1 FIG. 3 shows a field diagram of a data table under Base according to an example embodiment of the present disclosure; Figure 2A flow chart of a table data processing method provided by an example embodiment of the present disclosure is shown. Figure 3 A visitor cross-data-source access flow chart provided by an example embodiment of the present disclosure is shown. Figure 4 A block diagram of a table data processing apparatus provided by an example embodiment of the present disclosure is shown. Figure 5 A structural block diagram of an electronic device provided by an example embodiment of the present disclosure is shown. DETAILED DESCRIPTION

[0015] The example embodiments will be described in detail herein, with examples shown in the accompanying drawings. When the following description refers to the drawings, the same numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the following example embodiments do not represent all implementations consistent with the present disclosure. Instead, they are merely examples of apparatuses and methods consistent with some aspects of the present disclosure as detailed in the appended claims.

[0016] To solve the problem in the prior art that the implementation of cross-data-source data intercommunication needs to add a mirror field in the current database first, store the field in database B into database A through the mirror field, and finally make table A and table B in the same database, which complicates the current database structure and needs to consume a large amount of storage resources, causing a huge waste of storage resources, the present disclosure provides a table data processing method and apparatus.

[0017] To facilitate the understanding of the table data processing method provided by the embodiments of the present disclosure, first, the architecture of the cross-data-source collaboration platform provided by the embodiments of the present disclosure is briefly introduced.

[0018] The cross-data-source collaboration platform provided by the embodiments of the present disclosure includes three levels, the highest level is the tenant layer, including administrators and tenant members, and the tenant layer includes multiple workspaces (Workspaces) below, each Workspace is an independent workspace, used to separate different projects or departments, such as product development, market activities, etc. The Workspace can include multiple data containers (Base) below, used for specific management and collaboration, such as project management, customer relationship management, etc. Each data container (Base) is composed of a data table (Table) and a field (Field) below the data table, the data table is a visual display of data, and the field is a column in the data table, representing a specific item or task.

[0019] The types of Workspace include: private (Private) and shared (Open), private Workspace is only visible to members, and all tenant members are default readers of shared Workspace. The roles are divided into administrator, editor and reader. For example, the administrator has the management right to manage the entire Workspace, the editor has the editing right to the Base in the Workspace, and the reader has the reading right to the Base in the Workspace.

[0020] The Base layer can inherit the permissions of the Workspace. For example, Base A created in the Open Workspace automatically inherits the permissions of the Open Workspace, and the members have the reading right to Base A by default, and the editor has the editing right to Base A.

[0021] Figure 1 A field diagram of a data table under the Base according to an example embodiment of the present disclosure is shown. As shown, for example, there is a data table A under Base A, and the fields of the data table A include project name, project manager, customer contact person, expected delivery time and delivery, wherein the fields of "project name", "project manager" and "delivery" have reading rights, and the fields of "customer contact person" and "expected delivery time" have no reference rights. Figure 1

[0022] Those skilled in the art can understand that the above-described cross-data-source collaboration platform is taken as an example to introduce the table data processing method and device provided by the present disclosure, which is only an example and does not limit the present disclosure.

[0023] Figure 2 A flowchart of a table data processing method according to an example embodiment of the present disclosure is shown. As shown, Figure 2 The table data processing method mainly includes the following steps (S101-S103): S101, in response to receiving a cross-data-source operation request in the second data container, performing permission verification, the cross-data-source operation request is triggered by a target configuration operation; In the present embodiment, the second data container is currently in, and the cross-data-source operation request initiated by the user for the target configuration operation is received, which requests to reference some data of the first data source. Permission verification is needed, and the data of the first data source can be referenced only after the verification is passed, so as to realize the data intercommunication across data sources.

[0024] In some embodiments, the first data source includes: a first data container, a first data table in the first data container, and a first field in the first data table. ​

[0025] In this embodiment, the second data container is the Base that needs to reference data, and the first data container is the Base that is requested to reference data. In some embodiments, the first data container includes multiple. For example, in a collaboration platform of an enterprise, the sales department has a dedicated Workspace, which contains multiple Bases for managing different aspects of business data, such as a customer information Base, a sales order Base, and the like. If the builder needs to reference data under the sales order Base in the customer information Base, a cross-data-source operation request can be initiated to achieve this.

[0026] In some embodiments, the first data table in the first data container includes multiple, for example, in the sales order Base, there are multiple data tables, such as a completed order table, an uncompleted order table, and the like. In some embodiments, the target field in the target data table can include multiple, for example, in the customer data table of the customer information Base, there are fields such as customer name, contact information, purchase record, and the like.

[0027] In this embodiment, the multi-dimension and multi-element of data can provide more comprehensive and detailed data support for users when building cross-data-source data association relationships.

[0028] In some embodiments, in response to receiving a cross-data-source operation request in the second data container, a permission check is performed, including: (1) determining whether the first data container and the second data container belong to the same workspace, and in the case of belonging to the same workspace, the check is passed; and / or, (2) determining whether the user initiating the cross-data-source operation request has reading permission for the first data container and all rows of the first data table and / or all rows of the first field, and in the case of having reading permission for the first data container and all rows of the first data table and / or all rows of the first field, the check is passed.

[0029] In the embodiments of the present disclosure, it is first necessary to verify whether the second data container and the first data container belong to the same workspace. The two data containers of cross-data-source need to belong to the same Workspace to ensure the association and consistency of data reference, so that the data between different tables within the same space range can be intercommunicated. For example, in the Workspace of the sales department described above, there is a business association between different Bases, and only the Bases within the same Workspace can reference data to each other, avoiding confusion of data between different departments or business modules.

[0030] Secondly, it is necessary to verify whether the user initiating the cross-data-source operation request has reading permission for the first data container and all rows and / or all rows of the first field of the first data table, and only the cross-data-source operation request initiated by the user with reading permission can be allowed to ensure the security and compliance of the data. For example, only the sales manager or personnel with specific permissions have the right to quote the data of the financial Base, and ordinary sales personnel do not have this right, so as to ensure the security of the financial data and the compliance of quoting the financial data. Without reading permission for the target Base, the data association relationship with the target base cannot be established, and the data of the target Base cannot be quoted. For example, in the marketing promotion Workspace, there are marketing activity Base and sales data Base. If the marketing staff does not have reading permission for the sales data Base, the marketing staff cannot perform the quoting operation on the data under the sales data Base. In specific implementation, when the user selects other Base under "cross-multi-dimensional table quoting", only "marketing activity Base" is selectable, and "sales data Base" is displayed in gray or not displayed, indicating that there is no reading permission. The user can only select the data table under the "marketing activity Base", and finally select the field in the data table to complete the cross-multi-dimensional table quoting configuration.

[0031] In the embodiment, the user needs to have reading permission for all rows of the first data table. For example, in a project management Base, there is a task data table, and only personnel with reading permission for all rows of the data table can quote the data table when configuring the lookup reference field. In the embodiment, the user needs to have reading permission for all rows of the first field under the first data table. For example, in the customer data table of the customer information Base, there are customer name, contact information, purchase record and other fields. If the user only has reading permission for all rows of the customer name and purchase record fields, when configuring the lookup reference field, only these two fields can be quoted.

[0032] S102, display the first data source based on the permission verification result; In the embodiment, after permission verification, based on the permission verification result, the user can be displayed the first data source with permission. For example, by default, the current Base can be selected by dropping down to select other quotable Base, and all quotable Base and all data tables of the user are displayed by default. The current Base is arranged at the first position of the list, and other Base is sorted according to the latest access time. The data table and the field are also selected by default, and the first one is sorted, and other data tables and fields can be sorted according to the latest access time.

[0033] S103, in response to the selection operation on the first data source, establishing a data association relationship between the target configuration operation and the first data source.

[0034] In some embodiments, the target configuration operation includes, but is not limited to, at least one of the following: formula, associated field, lookup reference, dashboard component, and workflow.

[0035] In some embodiments, the target configuration operation is associated with data of the first data source, including at least one of the following: a1. configuring a formula in the second data container, taking the first data source as a calculation item of the formula; a2. configuring an associated field in a second data table in the second data container, and displaying data of the first data source in the associated field; a3. configuring a lookup reference field in the second data table in the second data container, and taking data of the first data source as a data source of the lookup reference field; a4. configuring a dashboard component in the second data container to present data in a chart, and taking the first data source as a data source of the dashboard component; a5. configuring a workflow in the second data container, and performing data processing on the first data source through the workflow, the workflow being used for automatic processing of data of a data table in the first data container.

[0036] In the above manner a1, the target configuration operation is associated with data of the first data source by configuring a formula in the second data container, taking the first data source as a calculation item of the formula. For example, in a sales management collaboration platform, the sum of order data in different bases can be calculated through a formula. In a specific implementation, the current base is defaulted, and a switch can be pulled to other referable bases, a data table in a selected base is selected, a field in the data table is selected, and a selection operation on the first data source is completed. A formula is configured, a field in the data table is selected, or a specific value is selected as a calculation item of the formula. The present disclosure supports cross-base reference of data through the above manner a1, completes real-time cross-base calculation, and realizes data intercommunication between different tables in the same space range.

[0037] In the above manner a2, in the embodiment, the data of the first data source is displayed in the association field by configuring the association field in the second data table in the second data container, and the association relationship between the target configuration operation and the data of the first data source is established. The one-way association field can associate the customer information in one Base to the sales order data in another Base; the two-way association can realize the mutual association and synchronization of data between two Bases. In specific implementation, the current Base is defaulted, and the other referable Base can be switched by pulling down, the data table under the corresponding Base is selected, the field under the data table is selected, and the selection operation of the first data source is completed; the one-way or two-way association field is configured, the field under the data table is selected, or the specific value is selected to be displayed in the association field. For one-way association, the user needs to have the reading permission of all rows, and for two-way association, the user needs to have the permission of adding the field. For the user who passes the permission check, the association panel can be viewed by clicking the cell (the user has the reading permission of the associated data table), and the record details can be viewed by clicking the associated record (the user has the reading permission of the record). The associated data table can display the associated Base and the data table under the Base, and supports jumping to the data table by opening a new tab. In the embodiment, the AI recommendation entrance is configured, and the AI recommendation entrance is hidden in the case that the association field is associated with the data table of the other Base. In the embodiment, if the user does not have the editing permission of the associated data table, the data table is grayed out. The above manner a2 supports the configuration of the one-way or two-way association field across the Bases, realizes the real-time cross-Base association data reference, and realizes the data intercommunication between different tables in the same space range.

[0038] In the above manner a3, in the embodiment, the data of the first data source is displayed in the association field by configuring the association field in the second data table in the second data container, and the association relationship between the target configuration operation and the data of the first data source is established. The one-way association field can associate the customer information in one Base to the sales order data in another Base; the two-way association can realize the mutual association and synchronization of data between two Bases. In specific implementation, the current Base is defaulted, and the other referable Base can be switched by pulling down, the data table under the corresponding Base is selected, the field under the data table is selected, and the selection operation of the first data source is completed; the one-way or two-way association field is configured, the field under the data table is selected, or the specific value is selected to be displayed in the association field. For one-way association, the user needs to have the reading permission of all rows, and for two-way association, the user needs to have the permission of adding the field. For the user who passes the permission check, the association panel can be viewed by clicking the cell (the user has the reading permission of the associated data table), and the record details can be viewed by clicking the associated record (the user has the reading permission of the record). The associated data table can display the associated Base and the data table under the Base, and supports jumping to the data table by opening a new tab. In the embodiment, the AI recommendation entrance is configured, and the AI recommendation entrance is hidden in the case that the association field is associated with the data table of the other Base. In the embodiment, if the user does not have the editing permission of the associated data table, the data table is grayed out. The above manner a2 supports the configuration of the one-way or two-way association field across the Bases, realizes the real-time cross-Base association data reference, and realizes the data intercommunication between different tables in the same space range.

[0039] In the above manner a4, in the embodiment, by configuring a dashboard component presenting data in a chart in the second data container, establishing a data association relationship between the target configuration operation and the first data source, taking the first data source as the data source of the dashboard component. In specific implementation, the user opens the configuration panel of the dashboard component and starts to configure the data source; by default, the current Base can be switched to other referable Base by drop-down, selecting the data table under the Base, the user will be displayed all the referable Base and all the data tables of the current dashboard, the current Base is arranged at the first position of the list by default, other Base is sorted by the latest access time, the data table and field are also selected by default as the first one; at the following points, the selection of the field under the data table is supported: (1) the filtering condition of the component, (2) the data visible range of the view; (3) the category / series / row / column value field of the component; (4) the optional field of sector grouping and sector value, that is, the selection operation of the first data source is completed; finally, the selection of the field under the data table or the selection of the specific value will be taken as the data source of the dashboard component. In the embodiment, the dashboard component includes chart, view and other components. One dashboard component can select multiple data tables under multiple Base as the data source. These components can integrate multiple aspects of data for display by cross-Base reference data source. For example, it can support the functions such as cross-base component configuration slicer, picture linkage and TOPN. Through the above manner a4, the present disclosure supports the cross-Base data source as the data source of the dashboard component, completes the real-time cross-Base dashboard display, and realizes the data intercommunication between different tables in the same space range.

[0040] In the above manner a5, the second data container is configured with a workflow, and the first data source is processed by the workflow. In this embodiment, the workflow is used to automatically process the data of the data table in the first data container, thereby establishing an association between the target configuration operation and the data of the first data source. In this embodiment, when the workflow involves trigger nodes (Trigger) and execution nodes (Action) related to record operations, the data source selection of the Trigger and Action nodes supports other data of the Base. Trigger includes when a new record is added, when a record is modified, when the added / modified record meets the condition, when the time in the record is reached, and when the button is clicked (unique to automation), etc. For example, when a new sales order record is added in a Base, trigger the inventory data update in another Base; when the order amount meets certain conditions, trigger the corresponding approval process. Action includes adding a record, modifying a record, finding a record, AI generating a record (unique to automation), etc. For example, based on customer demand in a Base, automatically generate a new product design record in another Base. Operation records and logs record operation items, operators (multi-dimensional table assistant), timestamps, etc. at the add record and modify record nodes. For example, when a user modifies a customer information record in a Base, the system records the specific content of the modification, the user who made the modification, and the time of the modification. In specific implementation, the current Base is selected by default, and other referable Bases can be switched to by pulling down to select the data table under the corresponding Base. In specific configuration, for the Trigger node: when a new record is added, select the non-nullable field; when a record is modified, select the field of interest; when the added / modified record meets the condition, configure the condition expression and select the field under the data table; when the time in the record is reached, select the date field in the data table; and when the button is clicked, select the button field in the data table. In specific configuration, for the Action node, select the record, support selecting the preposed Base node, and select the field under the data table in the corresponding Base; set the filtering condition: the field of the condition expression supports selecting the field under the data table in the target Base; set the record content: support selecting the field under the data table in the target Base and configuring the content. In some embodiments, in the configuration panel authentication, taking the workflow of Base A referencing the data source of Base B as an example, if the user of Base A does not have the reading permission of Base B, the related data of Base B cannot be viewed in the configuration panel of Base A. In some embodiments, in the running log authentication, taking the workflow of Base A modifying the data of Base B as an example, if the user does not have the reading permission of Base B, the automatic node related to Base B cannot be expanded in the running log.In some embodiments, in the history record display, taking the modification of the data of Base B by the workflow of Base A as an example, the change is recorded in the history record of the target Base (Base B), and the operator is Base A. Clicking can jump to Base A (a new tab is opened). The present disclosure supports the configuration formula to reference the data across the bases and completes the real-time cross-base calculation through the above-mentioned manner a5. In the workflow scenario, the trigger event can come from the data source change of other bases, the action can modify the data of other bases, and the data interconnection between different tables in the same space range is realized.

[0041] In the present embodiment, the target configuration operation includes but is not limited to the above-mentioned several operations, and any functional operation that needs to reference the data across the bases is applicable to the present embodiment. Those skilled in the art can understand that the present embodiment only takes the above-mentioned several target configuration operations as examples to introduce the manner of establishing the data association relationship between the target configuration operation and the first data source of the present disclosure, which is only an exemplary description and does not limit the present disclosure.

[0042] In the present embodiment of the present disclosure, based on the established data association relationship between the target configuration operation and the first data source, the direct result of the target configuration operation after the cross-data source can be directly displayed to the user. For example, in the customer relationship Workspace, there are customer information Base and order record Base. The customer service personnel configures the lookup reference field in the customer information Base, establishes the data association relationship with the historical order data table of the order record Base, and can display the historical order of a certain customer to the user. For another example, in the enterprise operation Workspace, there are sales data Base, production data Base and financial data Base. When the operation manager configures the dashboard chart component, references the “sales amount” and “sales quantity” fields in the sales data Base, and can display the comprehensive data related to sales, production and finance.

[0043] In some embodiments, taking the reference of the data of Base B by Base A as an example, after the data association relationship between the target configuration operation and the first data source is established, if the permission of Base B of the user is withdrawn or the user is dismissed. The target configuration operation of the formula, the associated field, the lookup reference, and the dashboard component can remind the Workspace administrator through the message, for example, whether to handle the configuration of Base A referencing Base B, the permission of the builder of Base A has been withdrawn. The target configuration operation of the workflow can be transferred to the administrator. But it does not affect the data association relationship of the target configuration operation (including the above-mentioned formula, associated field, lookup reference, dashboard component and workflow) that has been established.

[0044] In some embodiments, based on the established data association relationship of the target configuration operation and the first data source, the visitor can also view the specific details based on the data of different bases. In this scenario, the access permission of the visitor needs to be checked. Figure 3 As shown in FIG. 8, in some embodiments, after the cross-data-source data association relationship of the to-be-configured operation is established, the table data processing method provided by the embodiments of the present disclosure further includes a cross-data-source access process of the visitor, specifically including the following steps (S201-S203): S201, obtaining an access request of the visitor to the content of the first data source; In this embodiment, the visitor can also view the specific content (such as order amount details) of the fields in the data table under other bases based on the data association relationship of the target configuration operation and the first data source, but this requires the visitor to have reading permission to show it to him.

[0045] S202, checking the access permission of the visitor; In some embodiments, it is necessary to verify whether the visitor has reading permission for the specific content of the first data source. In the case that the visitor has reading permission for the specific content of the first data source, the check is passed. In actual implementation, for example, when viewing the specific entries of customer data, it is decided what content to show according to whether the visitor has reading permission for the specific entries.

[0046] S203, after the check is passed, providing the content of the first data source associated with the target configuration operation to the visitor based on the data association relationship of the target configuration operation and the first data source.

[0047] Through the permission check of the visitor to the specific content of the first data source, the security and compliance of the data are ensured, and after the check is passed, the visitor can realize the access of the specific details across the data sources.

[0048] In some embodiments, after the data association relationship of the target configuration operation and the first data source is established, the data processing method provided by the embodiments of the present disclosure further includes: listening to an abnormal event, modifying the data association relationship according to the abnormal event, and updating the data association relationship. In some embodiments, the abnormal event includes that the data of the first data source is deleted or modified, or the modified or deleted data is restored. Thus, the real-time update and maintenance of the cross-data-source data association relationship are ensured, and the normal use of each function across the data sources is ensured.

[0049] In some embodiments, for example, Base A references data of Base B, if the referenced Base B is deleted, modified, moved out / switched Workspace, an abnormal event occurs, causing the data association relationship across Base data references to be disconnected, Base A and the data association relationship of the Base B with the abnormal event are disconnected, and a pop-up window prompts the user.

[0050] In some embodiments, for example, Base A references data of Base B, if a certain data table or field under the referenced Base B is deleted or modified, the changed fields or data tables in the multi-dimensional data association relationship of Base A to Base B and the data table and field under Base B need to be updated and stored in the Workspace, and the deleted or modified data source is marked as an invalid data source.

[0051] In some embodiments, the modified or deleted data is restored. After the data is modified or deleted, it enters a logical deletion state. After recovery, it is only necessary to restore the previous data association relationship, and the data source is restored from an invalid state to a valid state. In actual application, if the "financial statement Base" is mistakenly deleted, the system will pop up a window prompt when it is deleted. If it is found in the recycle bin and restored to the original location, the data association relationship of the data dependent on the Base will be automatically restored.

[0052] The table data processing method provided by the embodiments of the present disclosure can enable data intercommunication between different tables within the same space range, without the need to add fields in the current data container, simplify the operation path and underlying structure, simplify the table structure, and the storage location of the data source does not change, thereby overcoming the problem of wasting a large amount of storage resources and causing a huge waste of storage resources in the prior art.

[0053] An example embodiment of the present disclosure provides a table data processing device 10. Figure 4 The structure block diagram of the table data processing device provided by an example embodiment of the present disclosure is shown. The above table data processing device can implement all or part of the contents of any of the embodiments described above. The structure and function of the table data processing device are briefly described below. For other details, please refer to the related description in the above table data processing method. The embodiments of the table data processing device correspond to the embodiments of the above table data processing method. Each implementation process and implementation manner of the above method embodiments can be applied to the table data processing device embodiments, and the same technical effects can be achieved. Figure 2 or Figure 3 The above table data processing device can implement all or part of the contents of any of the embodiments described above. The structure and function of the table data processing device are briefly described below. For other details, please refer to the related description in the above table data processing method. The embodiments of the table data processing device correspond to the embodiments of the above table data processing method. Each implementation process and implementation manner of the above method embodiments can be applied to the table data processing device embodiments, and the same technical effects can be achieved.

[0054] The above table data processing device can implement all or part of the contents of any of the embodiments described above. The structure and function of the table data processing device are briefly described below. For other details, please refer to the related description in the above table data processing method. The embodiments of the table data processing device correspond to the embodiments of the above table data processing method. Each implementation process and implementation manner of the above method embodiments can be applied to the table data processing device embodiments, and the same technical effects can be achieved. Figure 4As shown, the table data processing apparatus 10 comprises an acquisition module 100, a verification module 200 and a data processing module 300. In this embodiment, the acquisition module 100 is configured to receive a cross-data-source operation request in a second data container, the cross-data-source operation request being triggered by a target configuration operation; the verification module 200 is configured to, in response to receiving the cross-data-source operation request in the second data container, perform permission verification, and display a first data source based on a permission verification result, wherein the first data source comprises a first data container, a first data table in the first data container and a first field in the first data table; and the data processing module 300 is configured to, in response to a selection operation on the first data source, establish a data association relationship between the target configuration operation and the first data source.

[0055] In some embodiments, the first data source comprises a first data container, a first data table in the first data container and a first field in the first data table; in some embodiments, the first data container comprises a plurality of, the first data table comprises a plurality of, and the first field comprises a plurality of. In this embodiment, the diversification of data can provide more comprehensive and detailed data support for users when building a data association relationship across data sources.

[0056] In some embodiments, the verification module 200 performs permission verification in response to receiving the cross-data-source operation request in the second data container by: determining whether the first data container and the second data container belong to the same workspace, and verifying if they belong to the same workspace; and / or determining whether a user initiating the cross-data-source operation request has reading permission for the first data container and all rows of the first data table and / or all rows of the first field, and verifying if the user has reading permission for the first data container and all rows of the first data table and / or all rows of the first field. In the embodiment of the present disclosure, the first data container and the second data container across data sources need to belong to the same Workspace to ensure the association and consistency of data references. Only the cross-data-source operation request initiated by a user with reading permission can be allowed to ensure the security and compliance of data.

[0057] In some embodiments, the target configuration operation includes at least one of a formula, an associated field, a lookup reference, a dashboard component, and a workflow. In some embodiments, the establishing of the data association between the target configuration operation and the first data source includes at least one of: a1, configuring a formula in the second data container, and taking the first data source as a calculation item of the formula; a2, configuring an associated field in a second data table in the second data container, and displaying data of the first data source in the associated field; a3, configuring a lookup reference field in the second data table in the second data container, and taking data of the first data source as a data source of the lookup reference field; a4, configuring a dashboard component for presenting data in a chart in the second data container, and taking the first data source as a data source of the dashboard component; and a5, configuring a workflow in the second data container, and performing data processing on the first data source through the workflow, the workflow being used for automatic processing of data of a data table in the first data container. In this way, the data association between the target configuration operation and the first data source is established, and data intercommunication between different tables within the same space range is achieved. For specific descriptions and examples, please refer to the descriptions of the method embodiments above, which will not be repeated here.

[0058] In some embodiments, the obtaining module 100 is further configured to obtain an access request of the visitor to the content of the first source data; the checking module 200 is further configured to perform access permission checking on the visitor; and the data processing module 300 is further configured to, after the checking, provide the content of the first data source associated with the target configuration operation to the visitor based on the data association between the target configuration operation and the first data source. Through the permission checking on the content of the first data source by the visitor, the safety and compliance of the data are ensured, and after the checking, the visitor can achieve specific and detailed access across data sources.

[0059] In some embodiments, the data processing module 300 is further configured to listen to an abnormal event, modify the data association according to the abnormal event, and update the data association. In some embodiments, the abnormal event includes that the data of the first data source is deleted or modified, or the modified or deleted data is restored. In the embodiments of the present disclosure, through the listening to the abnormal event, real-time updating and maintenance of the data association across data sources are ensured, and normal use of various functions across data sources is ensured.

[0060] Through the table data processing apparatus provided in the embodiments of the present disclosure, data intercommunication between different tables within the same space range can be achieved, without the need to add fields in the current data container, the operation path and the underlying structure are simplified, the table structure is simple, and the storage location of the data source does not change, thereby overcoming the problem of wasting a large amount of storage resources and causing huge waste of storage resources in the prior art.

[0061] Figure 5A structural block diagram of an electronic device 1000 is shown according to an example embodiment of the present disclosure. The electronic device 1000 can be implemented as the table data processing apparatus described above, which can be configured in an electronic device such as a smartphone, a tablet computer, a notebook computer, a desktop computer, a smart watch, a television, or a server.

[0062] Generally, the electronic device 1000 includes a processor 1001 and a memory 1002.

[0063] The processor 1001 can include one or more processing cores, such as a 4-core processor, a 10-core processor, etc. The processor 1001 can be implemented in at least one of a hardware form of a DSP (Digital Signal Processing), an FPGA (Field-Programmable Gate Array), a PLA (Programmable Logic Array). The processor 1001 can also include a main processor and a coprocessor, the main processor being a processor for processing data in an awake state, also referred to as a CPU (Central Processing Unit), and the coprocessor being a low-power processor for processing data in a standby state. In some embodiments, the processor 1001 can be integrated with a GPU (Graphics Processing Unit) for rendering and drawing content required to be displayed on a display screen. In some embodiments, the processor 1001 can further include an AI (Artificial Intelligence) processor for processing computing operations related to machine learning.

[0064] The memory 1002 can include one or more computer-readable storage media, which can be non-transitory. The memory 1002 can also include a high-speed random access memory, and a non-volatile memory such as one or more disk storage devices, flash storage devices. In some embodiments, the non-transitory computer-readable storage medium in the memory 1002 is used to store at least one instruction for being executed by the processor 1001 to implement all or part of the steps of the table data processing method shown in the method embodiments of the present disclosure.

[0065] Those skilled in the art can understand that the structure shown in the above description is not a limitation on the electronic device 1000, and can include more or fewer components than shown, or combine certain components, or use different component arrangements. Figure 5 The structure shown in the above description does not constitute a limitation on the electronic device 1000, and can include more or fewer components than shown, or combine certain components, or use different component arrangements.

[0066] In an exemplary embodiment, a readable storage medium is also provided, in which a program or instruction is stored, the program or instruction being executed by a processor to implement all or part of the steps of the above table data processing method. For example, the computer readable storage medium can be a Read-Only Memory (ROM), a Random Access Memory (RAM), a Compact Disc Read-Only Memory (CD-ROM), a magnetic tape, a floppy disk, and an optical data storage device, etc.

[0067] In an exemplary embodiment, a computer program product is also provided, which includes a computer program stored on a non-transitory computer readable storage medium, the computer program including program instructions that, when executed by a computer, cause the computer to perform all or part of the above table data processing method. Figures 2 to 3 all or part of the steps of the table data processing method shown in any embodiment.

[0068] Other embodiments of the present disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the aspects of the present disclosure disclosed herein. It is intended that the present disclosure cover any and all variations of the present disclosure that come within the scope of the following claims and their equivalents. It is intended that the specification and examples be considered exemplary only, with the true scope and spirit of the present disclosure being indicated by the following claims.

[0069] It should be understood that the present disclosure is not limited to the precise structures as herein described and illustrated in the drawings, and that various modifications and changes can be made by those skilled in the art without departing from the scope of the present disclosure. The scope of the present disclosure is limited only by the appended claims.

Claims

1. A table data processing method, characterized in that: include: In response to receiving a cross-data source operation request in the second data container, performing a permission check, the cross-data source operation request being triggered by a target configuration operation; Based on the permission verification result, displaying a first data source, wherein the first data source includes: a first data container, a first data table in the first data container, and a first field in the first data table; In response to a selection operation on the first data source, a data association relationship between the target configuration operation and the first data source is established.

2. The method according to claim 1, characterized in that The establishing of a data association relationship between the target configuration operation and the first data source includes at least one of the following: Configuring a formula in the second data container, and using the first data source as a calculation item of the formula; Configuring an associated field in the second data table in the second data container, and displaying the data of the first data source in the associated field; Configuring a lookup reference field in the second data table in the second data container, and using the data from the first data source as the data source of the lookup reference field; configuring a dashboard component for presenting data in a chart in the second data container, and using the first data source as a data source for the dashboard component; A workflow is configured in the second data container, and data processing is performed on the first data source through the workflow. The workflow is used to automatically process data in the data table in the first data container.

3. The method according to claim 1, characterized in that The performing permission verification in response to receiving a cross-data source operation request in the second data container includes: Determine whether the first data container and the second data container belong to the same workspace, and if they do, verify that they pass; and / or, Determine whether the user who initiates the cross-data source operation request has read permission for the first data container and all rows of the first data table and / or all rows of the first field. If the user has read permission for the first data container and all rows of the first data table and / or all rows of the first field, the verification passes.

4. The method according to claim 1, wherein After establishing the data association relationship between the target configuration operation and the first data source, the method further includes: Obtaining a visitor's request for access to the content of the first source data; Performing access rights verification on the visitor; After the verification is passed, based on the data association relationship between the target configuration operation and the first data source, the content of the first data source associated with the target configuration operation is provided to the visitor.

5. The method according to claim 1, wherein After establishing the data association relationship between the target configuration operation and the first data source, the method further includes: Monitor abnormal events; The data association relationship is modified according to the abnormal event, and the data association relationship is updated.

6. The method according to claim 5, characterized in that The abnormal event includes: data of the first data source is deleted or modified, or the modified or deleted data is restored.

7. A table data processing device, characterized in that: include: An acquisition module, configured to receive a cross-data source operation request in a second data container, wherein the cross-data source operation request is triggered by a target configuration operation; a verification module, configured to, in response to receiving the cross-data source operation request in the second data container, perform a permission verification, and display the first data source based on a permission verification result, wherein the first data source includes: a first data container, a first data table in the first data container, and a first field in the first data table; A data processing module is configured to establish a data association relationship between the target configuration operation and the first data source in response to a selection operation on the first data source.

8. An electronic device, characterized in that: The electronic device includes a processor and a memory, wherein the memory stores programs or instructions that can be run on the processor, and when the programs or instructions are executed by the processor, the steps of the table data processing method according to any one of claims 1 to 6 are implemented.

9. A readable storage medium, characterized in that: The readable storage medium stores a program or instruction, and when the program or instruction is executed by a processor, the steps of the table data processing method according to any one of claims 1 to 6 are implemented.

10. A computer program product, comprising a computer program stored on a non-transitory computer-readable storage medium, wherein the computer program comprises program instructions, which, when executed by a computer, cause the computer to perform the steps of the table data processing method according to any one of claims 1 to 6.

Images