Data table replacement method, system and related device

Abstract

A data table replacement method, a system and a related device, which are applied to a data model. Model elements comprise any one or more of data tables, fields, an association relationship between the data tables, filters and calculated fields. The method comprises: when table replacement is required, a data table processing system determines model elements in a data model affected by replacing a second data table with a first data table, and generates prompt information on the basis of the affected model elements, so as to give a user a prompt on whether to execute an operation of replacing the second data table with the first data table, the affected model elements in the data model comprising model elements that will be updated and / or model elements that will be invalidated. When data tables in data models are replaced, the method can rapidly and accurately determine model elements in the data models affected by the replacement, and visually display the affected model elements to users without the need for the users to analyze the effects of table replacement on the data models, thus improving user experience.

Description

A data table replacement method, system and related equipment

[0001] This application claims priority to the Chinese patent application filed with the State Intellectual Property Office of China on December 29, 2023, with application number 202311871545.5 and application name “A Data Table Replacement Method, System and Related Equipment”, the entire contents of which are incorporated by reference into this application. Technical Field

[0002] The present application relates to the field of computer technology, and in particular to a data table replacement method, system, and related equipment. Background Art

[0003] After modeling the data tables in a database, if any of the tables used for modeling changes, such as replacing a table in the data model with a new one, some model elements (such as table relationships, filters, and calculated fields) in the model will change or even become invalid. Currently, when a table in a data model is replaced, users are required to analyze the potential impact on the model, which places a heavy burden on users. Summary of the Invention

[0004] The present application provides a data table replacement method, system and related equipment, which can quickly and accurately determine the affected model elements in the data model before and after the replacement when a data table in the data model is replaced, and can intuitively display the affected model elements to the user, eliminating the need for the user to analyze the impact of the table replacement on the data model, thereby improving the user experience.

[0005] In a first aspect, the present application provides a data table replacement method, which is applied to a data model, wherein the data model includes multiple data tables, and the model elements in the data model include any one or more of data tables, fields, associations between data tables, filters, and calculated fields. A data table processing system receives a data table replacement instruction, which instructs to replace a second data table in the data model with a first data table; the data table processing system obtains the first data table and the second data table, determines the model elements in the data model affected after the first data table replaces the second data table, and generates prompt information based on the affected model elements in the data model, so that the user determines whether to execute the operation of replacing the second data table with the first data table according to the prompt information. The affected model elements in the data model include model elements that will be updated and / or model elements that will become invalid; the prompt information is used to indicate the model elements in the data model affected after the first data table replaces the second data table.

[0006] By executing the above-mentioned data table processing method, when a data table in a data model is replaced, the affected model elements in the data model before and after the replacement can be quickly and accurately determined, and the affected model elements can be intuitively displayed to the user, eliminating the need for the user to analyze the impact of the table replacement on the data model, thereby improving the user experience.

[0007] In one possible implementation, the above-mentioned determination of the model elements affected in the data model after replacing the second data table with the first data table includes: determining the invalid fields based on the fields included in the first data table and the fields included in the second data table; the invalid fields are fields that exist in the second data table but do not exist in the first data table; and determining the model elements in the data model that depend on at least one field in the invalid fields, to obtain the model elements in the data model that will be invalid.

[0008] In one possible implementation, the above-mentioned determination of the model elements affected in the data model after replacing the second data table with the first data table includes: determining the update field based on the fields included in the first data table and the fields included in the second data table; the update field is a field in the first data table and the second data table with the same field name but different field values; determining the model elements in the data model that depend on at least one field in the update field, and obtaining the model elements in the data model that will be updated.

[0009] In one possible implementation, a model element in a data model that depends on at least one field in an invalid field is determined to obtain an invalid model element in the data model, including: a first calculated field is obtained based on at least one field in the invalid field, and it is determined that the first calculated field is a calculated field that will be invalid; the first calculated field is a calculated field in the data model; or, a second data table and a third data table establish an association relationship based on at least one field in the invalid field, and it is determined that the association relationship between the second data table and the third data table will be invalid; the third data table is a data table in the data model; or, a first filter is a filter established based on at least one field in the invalid field, and it is determined that the first filter will be invalid.

[0010] In one possible implementation, each model element in the data model corresponds to an element instance; determining the model element in the data model that depends on at least one field in the invalidation field, and obtaining the invalid model element in the data model, includes: sending a first message to the message bus through the element instance corresponding to the second data table, the first message including the table identifier and the invalidation field of the second data table; obtaining the first message through the first element instance, verifying through the first element instance that the model element corresponding to the first element instance depends on at least one field in the invalidation field, and determining that the model element corresponding to the first element instance is invalid, the first element instance being the element instance corresponding to any model element in the data model.

[0011] In a possible implementation, after generating prompt information based on the affected model elements in the data model, the following steps are further included:

[0012] Receive a confirmation operation from the user, where the confirmation operation is used to indicate an operation of replacing the second data table with the first data table; replace the field value of the first field in the second data table in the data model with the field value of the field with the same name in the first data table, where the field with the same name refers to a field in the first data table that has the same field name as the first field; the first field is one of the fields with the same field name included in the first data table and the second data table; add fields that exist in the first data table but do not exist in the second data table to the second data table, and delete fields that exist in the second data table but do not exist in the first data table to obtain a new second data table.

[0013] In a possible implementation, after the first data table and the second data table, the method further includes: determining difference information between the first data table and the second data table based on the fields included in the first data table and the fields included in the second data table, wherein the difference information indicates the difference between the fields included in the first data table and the fields included in the second data table; displaying a difference preview interface, wherein the difference preview interface includes the difference information; determining the model elements affected in the data model after the second data table is replaced with the first data table, including: receiving an operation of confirming the difference information by the user on the difference preview interface, and determining, in response to the operation of determining the difference information, the model elements affected in the data model after the second data table is replaced with the first data table.

[0014] In a possible implementation, before obtaining the first data table and the second data table, the method further includes: receiving an operation from a user to replace the second data table with the first data table.

[0015] In one possible implementation, after obtaining the new second data table, it also includes: displaying a difference interface, the difference interface including the invalid association relationship between the new second data table and other data tables in the data model, and / or the invalid calculation fields of the new second data table relative to the second data table.

[0016] In a second aspect, the present application provides a data table processing system, characterized by comprising:

[0017] an acquisition module, configured to receive a data table replacement instruction, the data table replacement instruction instructing to replace a second data table in a data model with a first data table; and acquire the first data table and the second data table, the second data table being a data table in the data model, the data model including a plurality of data tables;

[0018] a processing module, configured to determine model elements in the data model that are affected after the second data table is replaced with the first data table; wherein the model elements in the data model that are affected include model elements that will be updated and / or model elements that will be invalidated, and the model elements include any one or more of data tables, fields, relationships between data tables, filters, and calculated fields;

[0019] The processing module is further configured to generate prompt information based on the affected model elements in the data model, where the prompt information is used to indicate the affected model elements in the data model after the second data table is replaced with the first data table.

[0020] In a possible implementation, the processing module is specifically configured to:

[0021] Based on the fields included in the first data table and the fields included in the second data table, the invalid fields are determined; the invalid fields are fields that exist in the second data table but not in the first data table; the model elements in the data model that depend on at least one field in the invalid fields are determined, and the model elements in the data model that will become invalid are obtained.

[0022] In one possible implementation, the processing module is specifically used to: determine the update field based on the fields included in the first data table and the fields included in the second data table; the update field is a field with the same field name in the first data table and the second data table, but the field value is not exactly the same; determine the model element in the data model that depends on at least one field in the update field, and obtain the model element in the data model that will be updated.

[0023] In one possible implementation, the processing module is specifically used to: obtain a first calculated field based on at least one field in the invalid field, and determine that the first calculated field is a calculated field that will be invalid; the first calculated field is a calculated field in the data model; or, establish an association relationship between the second data table and the third data table based on at least one field in the invalid field, and determine that the association relationship between the second data table and the third data table will be invalid; the third data table is a data table in the data model; or, the first filter is a filter established based on at least one field in the invalid field, and determine that the first filter will be invalid.

[0024] In one possible implementation, each model element in the data model corresponds to an element instance; the processing module is specifically used to: send a first message to the message bus through the element instance corresponding to the second data table, the first message including the table identifier and invalidation field of the second data table; obtain the first message through the first element instance, verify at least one field in the invalidation field of the model element dependency corresponding to the first element instance through the first element instance, determine that the model element corresponding to the first element instance is invalid, and the first element instance is an element instance corresponding to any model element in the data model.

[0025] In one possible implementation, the system also includes a display module and an interaction module; the display module is used to display prompt information; the interaction module is also used to receive a user confirmation operation, and the confirmation operation is used to indicate an operation of replacing the second data table with the first data table; the processing module is also used to replace the field value of the first field in the second data table in the data model with the field value of the field with the same name in the first data table, and the field with the same name refers to a field in the first data table with the same field name as the first field; the first field is one of the fields with the same field name included in the first data table and the second data table; a field that exists in the first data table but does not exist in the second data table is added to the second data table to obtain a new second data table.

[0026] In one possible implementation, the system also includes a display module; a processing module, further used to determine difference information between the first data table and the second data table based on the fields included in the first data table and the fields included in the second data table, the difference information indicating the difference between the fields included in the first data table and the fields included in the second data table; a display module, used to display a difference preview interface, the difference preview interface including the difference information; determining the model elements affected in the data model after replacing the second data table with the first data table, including: an interaction module, further used to receive a user's operation of confirming the difference information on the difference preview interface; the processing module is specifically used to: in response to the operation of determining the difference information, determine the model elements affected in the data model after replacing the second data table with the first data table.

[0027] In a possible implementation, the system further includes an interaction module; the interaction module is configured to receive an operation from a user to replace the second data table with the first data table.

[0028] In one possible implementation, the display module is also used to display a difference interface, which includes the invalid association relationship between the new second data table and other data tables in the data model, and / or the invalid fields and calculation fields of the new second data table relative to the second data table.

[0029] In a third aspect, the present application provides a computing device comprising a processor and a memory, wherein the memory is used to store instructions and the processor is used to execute the instructions. When the processor executes the instructions, the method described in the first aspect or any possible implementation of the first aspect is implemented.

[0030] In a fourth aspect, a computer-readable storage medium comprises computer program instructions. When the computer program instructions are executed by a computing device, the computing device executes the method as described in the first aspect or any possible implementation of the first aspect. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] FIG1 is a schematic diagram of a data table processing system provided by the present application;

[0032] FIG2 is a flow chart of a data table processing method provided by the present application;

[0033] FIG3 is a schematic diagram of a data model provided by this application;

[0034] FIG4 is a schematic diagram of a difference preview interface provided by the present application;

[0035] FIG5 is a schematic diagram of a prompt interface provided by the present application;

[0036] FIG6 is a schematic diagram of another prompt interface provided by the present application;

[0037] FIG7 is a difference display interface provided by the present application;

[0038] FIG8 is a schematic diagram of a computing device provided by the present application;

[0039] FIG9 is a schematic diagram of a computing device cluster provided by the present application. DETAILED DESCRIPTION

[0040] The technical solution provided by this application is described in detail below with reference to the accompanying drawings.

[0041] A data model is a model created by a data analysis tool that visualizes the relationships between model elements. Model elements include data tables, fields, relationships between tables, filters, and calculated fields. Data analysis tools can include business intelligence (BI) models and Power BI.

[0042] A calculated field is a virtual field derived from existing fields. It generates new values ​​by performing mathematical operations, string concatenation, logical analysis, and other operations on other fields. For example, in a sales data table, a calculated field can be used to calculate total sales or profit margin. A filter is a condition used to filter data. It can select records that meet the conditions based on field values. Filters are often used in data queries or report creation to quickly find the required information within large amounts of data.

[0043] The following first introduces the data packet prompt system and its deployment method using the data table processing method provided by this application.

[0044] FIG1 is a schematic diagram of a data table processing system provided by the present application. The data table processing system 100 includes an acquisition module 110 and a processing module 120 .

[0045] The acquisition module 110 is configured to acquire a first data table and a second data table. The data model includes multiple data tables, and the second data table is one of the multiple data tables. The data model includes model elements, which include one or more of a data table, each field in each data table, relationships between data tables, filters, or calculated fields.

[0046] The processing module 120 is configured to, after obtaining the first data table and the second data table, determine, based on the fields included in the first data table and the fields included in the second data table, model elements in the data model that are affected after replacing the second data table with the first data table. The affected model elements in the data model are model elements that will be updated and / or invalidated after replacing the second data table with the first data table.

[0047] For example, if the second data table includes field A, and an association relationship is established between the second data table and the third data table depending on field A, and the first data table does not have field A, then after replacing the second data table with the first data table, an association relationship cannot be established between the first data table and the third data table based on field A. Therefore, the model element of the original association relationship between the second data table and the third data table will become invalid.

[0048] For another example, if the second data table includes field B, and there is a calculated field C in the data model that is obtained based on the data of field B in the second data table, and the first data table also includes field B, but the field value of field B in the first data table is not exactly the same as the field value of field B in the second data table, if the other fields that calculated field C depends on have not changed, after field B in the second data table is updated to field B in the first data table, the field value of calculated field C will also be updated, then calculated field C is a field that will be updated in the data model.

[0049] When determining invalid model elements, processing module 120 identifies fields that exist in the second data table but not in the first data table based on the fields included in the first data table and the fields included in the second data table. In this application, fields that exist in the second data table but not in the first data table are referred to as invalid fields. Invalid fields include one or more fields in the second data table. If processing module 120 determines that a model element in the data model depends on at least one field in the invalid fields, then the model element is considered an invalid model element.

[0050] When determining updated model elements, processing module 120 identifies fields in the second data table that have the same field names but different field values ​​as those in the first data table, based on the fields included in the first data table and the fields included in the second data table. In this application, fields in the second data table that have the same field names but different field values ​​as those in the first data table are referred to as updated fields, and updated fields include one or more fields. If processing module 120 determines that a model element in the data model depends on at least one field in the updated fields, then the model element is considered an updated model element.

[0051] The processing module 120 is also used to generate prompt information based on the affected model elements in the data model. The prompt information includes the affected model elements in the data model, and is used to indicate to the user the affected model elements in the data model after the first data table replaces the second data table, so that the user determines whether to replace the second data table with the first data table based on the prompt information.

[0052] Optionally, the data table processing system 100 further includes a sending module 130 and a display module 140 . The sending module 130 is configured to send prompt information to the display module 140 ; ​​the display module 140 is configured to display the prompt information on a display interface after acquiring the prompt information.

[0053] The data table processing system 100 also includes an interactive module 150, which is used to receive operations performed by the user on the display interface. For example, after viewing the above prompt information, if the user determines to replace the second data table in the data model with the first data table, the user can trigger the "Confirm" space of the display interface. After receiving the confirmation operation triggered by the user, the interactive module 150 generates a request to confirm the replacement. After receiving the request to confirm the replacement, the processing module 120 replaces the field value of the first field in the second data table in the data model with the field value of the field with the same name in the first data table, and adds fields that exist in the first data table but do not exist in the second data table to the second data table, and deletes fields that exist in the second data table but do not exist in the first data table, thereby obtaining a new second data table. Among them, the field with the same name refers to a field in the first data table that has the same field name as the first field; the above-mentioned first field is one of the fields with the same field name included in the first data table and the second data table.

[0054] It should be noted that after executing the above process, the data in the new second data table is identical to the data in the first data table, but other data related to the second data table in the data model is not deleted. For example, the name of the second data table is the same as the name of the original second data table. For another example, if the data model contains a filter based on the first field in the second data table, the filter is not deleted because the first data table has a field with the same name as the first field. For another example, if the data model contains relationships and calculated fields based on the first field, these relationships and calculated fields are not deleted during the above process.

[0055] Through the above replacement method, the relevant data of the original second data table in the data model can be retained, the workload of reconfiguration after table replacement is reduced, and the efficiency of table replacement work is improved.

[0056] It should be understood that FIG1 is only an exemplary illustration of a division method of the structure of the data table processing system. In actual applications, the data table processing system may also have other division methods, which are not specifically limited in this application.

[0057] In the present application, the data table processing system 100 may be a hardware system, or a software system deployed on a hardware device, or may be implemented through a combination of hardware and software.

[0058] When the data table processing system 100 is a software system, the data table processing system 100 can be deployed in the data center of the cloud platform. For example, the data table processing system 100 is a cloud service provided by a cloud service provider. In a specific implementation, the data table processing system 100 can be independently deployed on a computing instance in the data center of the cloud platform, or distributedly deployed on multiple computing instances in the data center of the cloud platform. Among them, computing instances include servers, virtual machines, and containers. The data table processing system 100 is deployed in the data center of the cloud platform and is abstracted by the cloud service provider as a cloud service. Users can log in to the cloud platform through a client or a web page, and the cloud platform provides data table processing services to users through the data table processing system 100.

[0059] In this application, the cloud platform can be a central cloud platform, an edge cloud platform, or a cloud platform including a central cloud and an edge cloud, and this application does not specifically limit it. Moreover, when the cloud platform is a cloud platform including a central cloud and an edge cloud, the data table processing system 100 can be partially deployed on the edge cloud platform and partially deployed on the central cloud platform.

[0060] In one possible deployment approach, some functional modules in the data table processing system 100 are deployed on a back-end computing device or computing device cluster (including at least one computing device), while some functional modules are deployed on a front-end user terminal device. For example, the acquisition module 110 and the processing module 120 are deployed on a back-end server, while the display module 140 and the interaction module 150 are deployed on a front-end terminal device.

[0061] In one possible deployment method, the data table processing system 100 can also be deployed on a terminal device used by the user. For example, the data table processing system 100 is an application that can run on a terminal device, and the terminal device includes a mobile phone, a laptop computer, a desktop computer, a tablet computer, etc.

[0062] The following describes the data table processing method provided by the present application in conjunction with the accompanying drawings. The prompt method is used to prompt the model elements in the data model that are affected after the data table is replaced when a data table is replaced in the data model, so that the user can determine whether to perform the data table replacement operation based on the prompt information. It should be understood that in the present application, the replacement of a data table includes replacing a data table in the data model with a data table, and also includes modifying a data table in the data model. The modification includes adding fields, deleting fields, modifying field values, adding records or deleting records, etc. In the present application, the method provided by the present application is introduced by taking replacing a data table in the data model with a data table as an example. As shown in Figure 2, Figure 2 is a flow chart of a data table processing method provided by the present application, and the method includes S201 to S205.

[0063] S201. Receive an operation of replacing a second data table with a first data table, and obtain the first data table and the second data table.

[0064] In this application, the second data table is a data table in a data model, which includes multiple data tables, data model data tables, fields, associations between different data tables, filters, calculated fields and other model elements.

[0065] In one possible implementation, the operation of replacing the second data table with the first data table may be triggered by the data table processing system 100. For example, the user modifies the values ​​of some fields of the second data table in the data model, deletes a field, etc. The modified data table is equivalent to a new data table, namely the above-mentioned first data table. After the data table processing system 100 detects the user's modification of the second data table, it is equivalent to receiving a data table replacement instruction. The data table replacement instruction instructs the first data table to replace the second data table in the data model. The data table processing system 100 then obtains the first data table and the second data table.

[0066] In one possible implementation, the operation of replacing the second data table with the first data table can also be triggered by the user. The data table processing system 100 displays the data model through the display interface. After the user loads the first data table into the data model through the interface provided by the data table processing system 100, the user selects the first data table with the mouse, and then drags the first data table onto the second data table by dragging, triggering the operation of replacing the second data table with the first data table. After receiving the operation of replacing the second data table with the first data table, the data table processing system 100 obtains the first data table and the second data table. It should be understood that the fields included in the first data table and the second data table can be all the same, can be partially the same, and the first data table and the second data table may not have the same fields. This application does not make specific limitations.

[0067] For example, Figure 3 is a schematic diagram of a data model provided by the present application. The data model includes data tables such as product table, store table, customer table, order table, and monthly statistics table. Among them, the product table includes fields such as product name, product identification (Identity, ID), product category name, product category ID and cost; the store table includes fields such as store name, store ID, region, province and city; the customer table includes fields such as unit name, unit ID, region, province and city; the order table includes fields such as order number, order date, region, month, store ID, unit ID, product ID, product category ID, quantity, unit price and cost. The monthly statistics table is based on the sales amount of each product ID corresponding to each product in each month. The monthly statistics table includes fields such as product ID, product category ID, month, unit price, sales quantity, sales amount and profit, among which profit is a calculated field in the monthly statistics table.

[0068] Among them, the product table and the order table are associated through the product ID, the store table and the order table are associated through the store ID, the customer table and the order table are associated through the unit ID, and the order table and the monthly statistics table are associated through the product ID and month.

[0069] In Figure 3, the Order Table is the second data table, and Order Table (1) is the first data table. The user triggers the operation of replacing the Order Table with Order Table (1) by dragging Order Table (1) above the Order Table. Among them, Order Table (1) includes fields such as order number, order date, region, month, product ID, product category ID, quantity, unit price, and order amount. Compared with the Order Table, Order Table (1) does not have the three fields of store ID, unit ID, and cost, but has an additional order amount field.

[0070] It should be understood that the display interface shown in FIG3 is only an example. The display interface shows some data tables of the data model, some or all fields included in each data table, and the association relationships between some data tables. Some model elements are not shown.

[0071] It should be understood that the data table processing system 100 can display the data model shown in Figure 3 above through the display module 140, receive the user's operation of replacing the second data table with the first data table through the interaction module 150, and obtain the first data table and the second data table through the acquisition module 110.

[0072] S202 . Determine difference information between the first data table and the second data table based on the fields included in the first data table and the fields included in the second data table.

[0073] After obtaining the first data table and the second data table, the data table processing system 100 compares the fields included in the first data table with the fields included in the second data table to determine difference information between the first data table and the second data table. The difference information is used to indicate the differences between the fields included in the first data table and the fields included in the second data table. The difference information includes fields that exist in the second data table but not in the first data table. The difference information may also include fields that exist in the first data table but not in the second data table.

[0074] It should be understood that in this application, if a field in the first data table has the same field name as a field in the second data table, it is determined that the field is included in both the first and second data tables, and no comparison is made as to whether the field values ​​of the field are the same. If a field in the first data table has a field name that does not exist in the second data table, then the field is a field that exists in the first data table but not in the second data table. If a field in the second data table has a field name that does not exist in the first data table, then the field is a field that exists in the second data table but not in the first data table.

[0075] FIG4 is a schematic diagram of a difference preview interface provided by the present application. After determining the above-mentioned difference information, the data table processing system 100 can generate a difference preview interface as shown in FIG4 . The difference preview interface includes the above-mentioned difference information. The difference preview interface includes the fields included in the second data table and the fields included in the first data table, and the difference information is highlighted, that is, the fields that exist in the second data table but do not exist in the first data table are highlighted. As shown in FIG4 , the order table (1) (i.e., the first data table) does not have the three fields of store ID, unit ID, and cost relative to the order table (i.e., the second data table). These three fields are highlighted in the figure. Optionally, the fields that exist in the first data table but do not exist in the second data table can also be highlighted.

[0076] It should be understood that the data table processing system 100 can determine the difference information between the first data table and the second data table through the processing module 120 , and can display the difference preview interface shown in FIG. 4 through the display module 140 .

[0077] S203. Determine the model elements in the data model that are affected after the second data table is replaced with the first data table.

[0078] In the present application, if it is determined that the first data table will replace the second data table, the data table processing system 100 will determine, based on the first data table and the second data table, the model elements in the data model that will be affected after the first data table replaces the second data table. The affected model elements include model elements that will be updated and / or model elements that will become invalid in the data model after the first data table replaces the second data table.

[0079] Among them, the model elements that will be updated are: if there is a model element in the data model that is established based on a second field in the second data table, and the second field also exists in the first data table, that is, there is a field with the same field name as the second field in the first data table, but the field value of the second field in the first data table is not exactly the same as the field value of the first field, then the model element established based on the second field in the second data table is the model element that will be updated. The model elements that will be invalidated are: if there is a model element in the data model that is established based on a third field in the second data table, but the third field does not exist in the first data table, then the model element established based on the third field is the model element that will be invalidated.

[0080] In the present application, after the data table processing system 100 obtains the first data table and the second data table, it first determines the invalid fields and / or update fields based on the fields included in the first data table and the fields included in the second data table; then, based on the invalid fields, it determines the model elements in the data model that depend on at least one of the above-mentioned invalid fields, and obtains the model elements in the data model that will be invalidated; and based on the update fields, it determines the model elements in the data model that depend on at least one of the above-mentioned invalid fields, and obtains the model elements in the data model that will be updated.

[0081] Specifically, the data table processing system 100 determines, based on the fields included in the first data table and the fields included in the second data table, that the fields that exist in the second data table but do not exist in the first data table are invalid fields, and the invalid fields include one or more fields in the second data table. If the data table processing system 100 determines that a model element in the data model depends on at least one field among the invalid fields, then the model element is an invalid model element. For example, if a first calculated field included in a data table in the data model is obtained based on at least one field in the invalid fields, then the first calculated field is determined to be an invalid calculated field; for another example, if the second data table and the third data table establish an association relationship based on at least one field in the invalid fields, then the association relationship between the second data table and the third data table is determined to be an invalid association relationship; for another example, if the first filter is a filter established based on at least one field in the invalid fields, then the first filter is determined to be an invalid filter.

[0082] Based on the fields included in the first data table and the fields included in the second data table, the data table processing system 100 determines the fields in the second data table that have the same field names but different field values ​​as the first data table, namely, update fields. The update fields include one or more fields in the second data table. If the data table processing system 100 determines that a model element in the data model depends on at least one field in the update fields, then the model element is the model element to be updated.

[0083] For example, the value of the "sales quantity" field in the monthly statistics table is obtained by counting the value of the "quantity" field in the order table, and the value of the "sales amount" field is calculated based on the values ​​of the "quantity" field and the "unit price" field in the order table. The order table (1) (i.e., the first data table) and the order table (i.e., the second data table) both include the "quantity" field. If the value of the "quantity" field corresponding to one or more order numbers in the order table (1) is different from the value of the "quantity" field corresponding to these order numbers in the order table, then in the monthly statistics table, the "sales quantity" field and the "sales amount" field are model elements that will be updated.

[0084] Since the order table (1) does not have the store ID and company ID fields, and the store table and order table are associated with each other based on the store ID, and the customer table and order table are associated with each other based on the company ID, after the first data table replaces the second data table, the association between the store table and order table in the data model will be invalid, and the association between the customer table and order table will be invalid.

[0085] In one possible implementation, each model element in the data model corresponds to an element instance. For example, each table corresponds to a table instance, and each field corresponds to a field instance. The element instance corresponding to each model element can send messages to the message bus and can also obtain messages from the message bus. After the data table processing system 100 detects the operation of replacing the second data table with the first data table, the element instance corresponding to the second data table sends a first message to the message bus. The first message includes the table identifier of the second data table, the names of the fields included in the above-mentioned invalidation field, and the names of the fields included in the above-mentioned update field.

[0086] Each element instance corresponding to a model element in the data table processing system 100 receives a first message from the message bus. Each element instance determines whether the first message is relevant to itself based on the invalidation fields and / or update fields in the first message. Taking the first element instance corresponding to the first model element as an example, the first model element can be any model element in the data model. After receiving the first message, the first element instance determines whether the first model element depends on at least one field in the invalidation fields in the first message. If the first model element depends on at least one field in the invalidation fields in the first message, the first element instance determines that the first model element will fail. The data table processing system 100 records that the first model element will fail and sends a second message to the message bus via the first element instance. This second message is used to notify other element instances of the failure of the first model element. If the first model element does not depend on at least one field in the invalidation fields in the first message or at least one field in the update fields in the first message, the first element instance does not send a message to the message bus.

[0087] The second element instance that receives the second message will determine whether the second model element depends on the first model element. If the second model element depends on the first model element, the data table processing system 100 records that the second model element will fail, and sends a third message to the message bus through the second element instance. The third message is used to notify other element instances that the second model element is invalid. If the second model element does not depend on the first model element, the second element instance does not send a message to the message bus.

[0088] Similarly, after receiving the first message, the first element instance determines whether the first model element depends on at least one of the updated fields in the first message. If so, the first element instance determines that the first model element will be updated. The data table processing system 100 records that the first model element will be updated and sends a fourth message to the message bus via the first element instance. This fourth message is used to notify other model instances that the first model element will be updated. If the first model element does not depend on at least one of the updated fields in the first message or at least one of the invalidated fields in the first message, the first element instance does not send a message to the message bus.

[0089] The second element instance that receives the fourth message will determine whether the second model element depends on the first model element. If the second model element does depend on the first model element, the data table processing system 100 will record that the second model element will be updated and send a fifth message to the message bus through the second element instance. The fifth message is used to notify other element instances that the second model element will be updated; if the second model element does not depend on the first model element, the second element instance will not send a message to the message bus.

[0090] According to the above method, each element instance that receives a message from the message bus will perform the above judgment. If it determines that its corresponding model element will be invalidated or updated, it will send a message to the message bus to notify other element instances. Through the above method, the data table processing system 100 can determine the affected model elements in the data model.

[0091] For example, the first data table mentioned above does not have a "cost" field relative to the second data table. The table instance corresponding to the second data table sends a first message to the message bus, which includes information that the "cost" field is invalid. The field value of the "profit" field in the monthly statistics table is calculated based on the "cost" field. Therefore, after the element instance corresponding to the "profit" field receives the first message, it determines that the calculation formula of the "profit" field includes the "cost" field. The element instance corresponding to the "profit" field then determines that the element instance of the "profit" field is invalid. The element instance corresponding to the "profit" field also sends information that the "profit" field in the monthly statistics table is invalid to the message bus. If the data model also includes an annual statistics table, which is used to calculate the profit of each product in the current year, the annual statistics table includes an "annual profit" field, which is calculated based on the "profit" field in the monthly statistics table. Therefore, if the "profit" model element is invalid, the "annual profit" model element will also be invalid.

[0092] In one possible implementation, the difference preview interface shown in FIG4 includes a "Confirm" control and a "Cancel" control. After the data table processing system 100 displays the differences between the first and second data tables to the user through the difference preview interface, if the user confirms the difference information, the user can trigger the "Confirm" control on the difference preview interface, for example, by clicking the "Confirm" control with a mouse. After receiving the confirmation operation, the data table processing system 100 determines the model elements in the data model that will be affected after replacing the second data table with the first data table based on the above-described method.

[0093] It should be understood that the data table processing system 100 can determine, through the processing module 120 , the model elements in the data model that are affected after the second data table is replaced with the first data table.

[0094] S204. Generate prompt information based on the affected model elements in the data model, where the prompt information is used to indicate the affected model elements in the data model after the second data table is replaced with the first data table.

[0095] The data table processing system 100 generates prompt information after determining the model elements in the data model that are affected after the second data table is replaced by the first data table. The prompt information is used to indicate the model elements in the data model that are affected after the second data table is replaced by the first data table, so that the user can confirm whether to replace the second data table with the first data table based on the prompt information.

[0096] In the present application, the data table processing system 100 can display the above prompt information through a prompt interface, which includes three tabs: "Related Fields" option, "Relationship" option and "Filter" option. After each option is selected, the prompt interface can display the corresponding prompt information. Figure 5 is a schematic diagram of a prompt interface provided by the present application. After the "Related Fields" option in Figure 5 is selected, the prompt interface can display the affected fields and calculated fields determined in the above S203. The "Related Fields" option includes two columns of data: "Fields / Calculated Fields" and "Table Fields". Among them, the "Fields / Calculated Fields" column is used to display the affected fields and calculated fields in the data model, including fields that will be updated, calculated fields that will be updated, fields that will be invalidated, and calculated fields that will be invalidated; the "Table Fields" column is used to display updated fields and invalidated fields. For example, as shown in Figure 5, the above-mentioned order table (1) lacks the cost field relative to the order table, so the "Profit" field in the monthly statistics table and the "Annual Profit" field in the annual statistics table will be invalid.

[0097] Optionally, the data table processing system 100 can display the model elements that will be updated and the model elements that will become invalid in different display modes, for example, displaying the model elements that will be updated and the model elements that will become invalid in different colors, or highlighting the model elements that will become invalid, etc. This application does not impose any specific restrictions.

[0098] Figure 6 is a schematic diagram of another prompt interface provided by the present application. After the "association relationship" option in Figure 6 is selected, the prompt interface can display the affected association relationship determined in the above S203, and the "association relationship" option includes three columns of data: "Starting table", "Target table" and "Table field". Among them, the "Starting table" column is used to display the table name of the starting table in the affected association relationship, the "Target table" column is used to display the table name of the target table in the affected association relationship, and the "Table field" column is used to display the fields that cause the association relationship to be affected. For example, in Figure 3, there is an association relationship between the product table and the order table, the product table is the starting table, and the order table is the target table. It should be understood that in this application, the association relationship is affected usually refers to the invalidation of the association relationship, that is, the field that establishes the association relationship between the two data tables belongs to the above-mentioned invalid field; in Figure 6, the starting table and the target table in the same row have an association relationship, and the association relationship is affected because the field corresponding to the field in the same row table is invalid. For example, the management relationship between the store table and the order table in Figure 6 is affected because the store ID in the order table is invalid.

[0099] Similarly, after the "Filter" option is selected, the prompt interface can display the affected filters determined in the above S203. The "Filter" option includes two columns of data: "Filter Type" and "Table Field". Among them, the "Filter Type" column is used to display the type of affected filters, and the "Table Field" column is used to display the fields that cause the filters to be affected. Among them, the filter types include ordinary filters and permission filters. It should be understood that in the prompt interface corresponding to the "Filter" tab, the filter type located in the same row as a field indicates the type of filter set for the field.

[0100] It should be understood that the data table processing system 100 can generate the above prompt information through the processing module 120 and display it through the display module 140 to prompt the user whether to perform the operation of replacing the second data table with the first data table.

[0101] S205: Receive a confirmation operation from the user, and execute an operation of replacing the second data table with the first data table.

[0102] After receiving a confirmation operation input by the user, the data table processing system 100 replaces the second data table in the data model with the first data table. Specifically, the field value of the first field in the second data table in the data model is replaced with the field value of the field with the same name in the first data table. The field with the same name refers to a field in the first data table that has the same field name as the first field; the first field is one of the fields with the same field name included in the first and second data tables. Fields that exist in the first data table but not in the second data table are added to the second data table, and fields that exist in the second data table but not in the first data table are deleted, thereby obtaining a new second data table.

[0103] It should be noted that after executing the above process, the data in the new second data table is identical to the data in the first data table, but other data related to the second data table in the data model is not deleted. For example, the name of the second data table is the same as the name of the original second data table. For another example, if the data model contains a filter based on the first field in the second data table, the filter is not deleted because the first data table has a field with the same name as the first field. For another example, if the data model contains relationships and calculated fields based on the first field, these relationships and calculated fields are not deleted during the above process.

[0104] In the present application, the prompt interface shown in FIG. 5 or FIG. 6 includes a "Confirm" control and a "Cancel" control. If the user triggers the "Confirm" control on the prompt interface, the data table processing system 100 can receive the confirmation operation and, in response to the confirmation operation, perform the above-mentioned operation of replacing the first data table with the second data table. If the user triggers the "Cancel" control on the prompt interface, the data table processing system 100 does not perform the operation of replacing the first data table with the second data table.

[0105] Optionally, as shown in FIG7 , FIG7 is a difference display interface provided by the present application. The difference display interface includes invalid associations between the new second data table and other data tables in the data model, and / or fields that do not exist in the new second data table relative to the original second data table and invalid calculated fields. In FIG7 , invalid associations are represented by dotted lines. Since the "store ID" field and the "unit ID" field are no longer in the data table (1), the association between the store table and the order table is invalid, as is the association between the customer table and the order table.

[0106] By executing the above method, when replacing a table in a data model with another table, the affected model elements in the data model before and after the replacement can be quickly and accurately determined, and the affected model elements can be intuitively displayed to the user, eliminating the need for the user to analyze the impact of the table replacement on the data model. This reduces the requirements for users during the table replacement process and improves the user experience. When replacing a table in a data model with another table, the relevant data of the replaced table in the data model can be retained, reducing the workload required for reconfiguration during the table replacement process and improving the efficiency of the table replacement process.

[0107] For the above method embodiments, for the sake of simplicity of description, they are all expressed as a series of action combinations, but those skilled in the art should know that the present invention is not limited by the order of the actions described. For example, the above S202 may not be performed, or the difference may not be displayed in the form shown in Figure 4. Secondly, those skilled in the art should also know that the embodiments described in the specification are all preferred embodiments, and the actions involved are not necessarily required by the present invention. Other reasonable step combinations that can be thought of by those skilled in the art based on the above description also fall within the scope of protection of the present invention.

[0108] This application also provides a computing device, as shown in Figure 8, which is a schematic diagram of a computing device provided by this application. Computing device 800 includes a bus 802, a processor 804, a memory 806, and a communication interface 808. Processor 804, memory 806, and communication interface 808 communicate with each other via bus 802. Computing device 800 can be a server or a terminal device. It should be understood that this application does not limit the number of processors and memories in computing device 800.

[0109] Bus 802 may be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus, among others. Buses may be classified as address buses, data buses, control buses, and the like. For ease of illustration, FIG8 illustrates a single bus line, but this does not imply a single bus or type of bus. Bus 802 may include a path for transmitting information between various components of computing device 800 (e.g., memory 806, processor 804, and communication interface 808).

[0110] The above-mentioned processor 804 can be a central processing unit (CPU), or it can include a CPU and other hardware chips. The above-mentioned hardware chips can be of various types. For example, it can be a co-processing unit, including any one of chips such as a graphics processing unit (GPU), a tensor processing unit (TPU), a programmable logic device (PLD), a complex programmable logic device (CPLD), a field programmable gate array (FPGA) or a digital signal processor (DSP). The computing device 800 can include one or more hardware chips of any of the above types, or it can include multiple types of the above hardware chips, which is not specifically limited in this application.

[0111] The memory 806 may include volatile memory, such as random access memory (RAM). The memory 806 may also include non-volatile memory, such as read-only memory (ROM), flash memory, hard disk drive (HDD), or solid state drive (SSD).

[0112] Executable program code and data are stored in the memory 806. The processor 804 executes the executable program code to implement the method described in the method embodiment corresponding to FIG2 . In other words, the memory 806 stores program code for implementing the functions of the data table processing system 100, thereby implementing the data table processing method shown in FIG2 . The program code includes one or more software modules, including the acquisition module 110 and the processing module 120 in the data table processing system 100 shown in FIG1 . The processor 804 executes the executable program code to implement the method corresponding to FIG2 , and no further description is given herein.

[0113] The communication interface 808 may be a wired interface or a wireless interface for communicating with other modules or devices, such as receiving user operations on a display interface. The wired interface may be an Ethernet interface, a local interconnect network (LIN), or the like, and the wireless interface may be a cellular network interface or a wireless local area network interface.

[0114] The present application also provides a computing device cluster. The computing device cluster includes multiple computing devices 800. The computing devices can be servers, such as central servers, edge servers, local servers in a local data center, or servers in a data center in a cloud environment. In some embodiments, the computing devices can also be terminal devices such as desktop computers, laptop computers, or smartphones.

[0115] As shown in Figure 9, which is a schematic diagram of a computing device cluster provided by the present application, the memories 806 of multiple computing devices 800 in the computing device cluster may store the same program code for implementing the method in the embodiment shown in Figure 2.

[0116] In some possible implementations, the memories 806 of the multiple computing devices 800 in the computing device cluster may also respectively store partial instructions for executing the above-mentioned method, that is, the memories 806 in different computing devices 800 in the computing device cluster can store different instructions, which are respectively used to execute partial functions in the method shown in Figure 2. The combination of multiple computing devices 800 can jointly implement the method in the embodiment shown in Figure 2.

[0117] In some possible implementations, multiple computing devices 800 in a computing device cluster may be connected via a network. The network may be a wide area network (WAN) or a local area network (LAN). For example, two computing devices may be connected via a network. Specifically, the connection to the network may be via a communication interface in each computing device.

[0118] The present application also provides a computer program product comprising instructions. The computer program product may be software or a program product comprising instructions that can be run on a computing device or stored in any available medium. When the computer program product is run on at least one computing device, the at least one computing device performs the method of the embodiment shown in FIG. 2 .

[0119] The present application also provides a computer-readable storage medium. The computer-readable storage medium can be any available medium capable of storing data on a computing device, or a data storage device such as a data center that contains one or more available media. The available medium can be a magnetic medium (e.g., a floppy disk, a hard disk, a magnetic tape), an optical medium, or a semiconductor medium (e.g., a solid-state drive). The computer-readable storage medium includes instructions that instruct the computing device to implement the method in the embodiment shown in FIG. 2 .

[0120] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the protection scope of the technical solutions of the various embodiments of the present invention.

Claims

1. A data table replacement method, characterized in that, The data model includes multiple data tables. The model elements in the data model include any one or more of data tables, fields, associations between data tables, filters, and calculated fields, including: receiving a data table replacement instruction, wherein the data table replacement instruction instructs to replace a second data table in the data model with a first data table; Obtaining the first data table and the second data table; Determine the model elements in the data model that are affected after the second data table is replaced with the first data table; wherein the model elements in the data model that are affected include model elements that will be updated and / or model elements that will become invalid; Prompt information is generated based on the affected model elements in the data model, where the prompt information is used to indicate the affected model elements in the data model after the first data table replaces the second data table.

2. The method according to claim 1, wherein The determining the model elements in the data model that are affected after the second data table is replaced with the first data table includes: Determine a disabled field based on the fields included in the first data table and the fields included in the second data table; the disabled field is a field that exists in the second data table but does not exist in the first data table; Determine a model element in the data model that depends on at least one of the invalid fields, and obtain a model element in the data model that will be invalidated.

3. The method according to claim 1 or 2, characterized in that The determining the model elements in the data model that are affected after the second data table is replaced with the first data table includes: Based on the fields included in the first data table and the fields included in the second data table, determining an update field; the update field is a field in the first data table and the second data table with the same field name but different field values; Determine a model element in the data model that depends on at least one of the update fields, and obtain a model element in the data model that will be updated.

4. The method according to claim 2, wherein The determining of the model elements in the data model that depend on at least one of the invalid fields to obtain the invalid model elements in the data model includes: The first calculated field is obtained based on at least one field in the invalid fields, and it is determined that the first calculated field is a calculated field that will be invalidated; the first calculated field is a calculated field in the data model; or, The second data table and the third data table establish an association relationship based on at least one field in the invalid fields, and determine that the association relationship between the second data table and the third data table will be invalid; the third data table is a data table in the data model; or The first filter is a filter established based on at least one of the invalid fields, and it is determined that the first filter will be invalid.

5. The method according to claim 2 or 4, characterized in that, Each model element in the data model corresponds to an element instance; The determining of the model elements in the data model that depend on at least one of the invalid fields to obtain the invalid model elements in the data model includes: Sending a first message to the message bus through the element instance corresponding to the second data table, wherein the first message includes a table identifier of the second data table and the invalidation field; Obtain the first message through the first element instance, verify that the model element corresponding to the first element instance depends on at least one field in the failure field through the first element instance, and determine that the model element corresponding to the first element instance fails. The first element instance is an element instance corresponding to any model element in the data model.

6. The method according to any one of claims 1-5, characterized in that, After generating the prompt message based on the affected model elements in the data model, it further includes: Receiving a confirmation operation from the user, where the confirmation operation is used to indicate the operation of replacing the second data table with the first data table; Replacing the field value of the first field in the second data table in the data model with the field value of the same-named field in the first data table. The same-named field refers to the field in the first data table that has the same field name as the first field; the first field is one of the fields with the same field name included in the first data table and the second data table; Adding the fields that exist in the first data table but do not exist in the second data table to the second data table, and deleting the fields that exist in the second data table but do not exist in the first data table to obtain a new second data table.

7. The method according to any one of claims 1-6, characterized in that, After the first data table and the second data table, it further includes: Based on the fields included in the first data table and the fields included in the second data table, determining the difference information between the first data table and the second data table, where the difference information indicates the difference between the fields included in the first data table and the fields included in the second data table; Displaying a difference preview interface, where the difference preview interface includes the difference information; The determining of the affected model elements in the data model after replacing the second data table with the first data table includes: Receiving the operation of the user confirming the difference information in the difference preview interface, and in response to determining the operation of the difference information, determining the affected model elements in the data model after replacing the second data table with the first data table.

8. The method according to any one of claims 1-7, characterized in that, Before obtaining the first data table and the second data table, it further includes: receiving the operation of the user replacing the second data table with the first data table.

9. The method according to claim 6, wherein After obtaining the new second data table, it further includes: Displaying a difference interface, where the difference interface includes the invalid association relationships between the new second data table and other data tables in the data model, and / or the calculated fields where the new second data table is invalid relative to the second data table.

10. A data table processing system, characterized in that, It includes: An obtaining module, configured to receive a data table replacement instruction, where the data table replacement instruction indicates using a first data table to replace a second data table in the data model; Obtaining the first data table and the second data table; A processing module, configured to determine the affected model elements in the data model after replacing the second data table with the first data table; where the affected model elements in the data model include the model elements that will be updated and / or the model elements that will fail, and the model elements include any one or more of data tables, fields, association relationships between data tables, filters, and calculated fields; The processing module is further configured to generate a prompt message based on the affected model elements in the data model, where the prompt message is used to indicate the affected model elements in the data model after replacing the second data table with the first data table.

11. The system according to claim 10, wherein Specifically, the processing module is configured to: Determine invalid fields based on the fields included in the first data table and the fields included in the second data table; the invalid fields are the fields that exist in the second data table but do not exist in the first data table; Determine the model elements in the data model that depend on at least one of the invalid fields to obtain the model elements that will become invalid in the data model.

12. The system according to claim 10 or 11, wherein Specifically, the processing module is configured to: Determine updated fields based on the fields included in the first data table and the fields included in the second data table; the updated fields are the fields with the same field name in the first data table and the second data table, but the field values are not exactly the same; Determine the model elements in the data model that depend on at least one of the updated fields to obtain the model elements that will be updated in the data model.

13. The system according to claim 11, wherein, Specifically, the processing module is configured to: If a first calculated field is obtained based on at least one of the invalid fields, determine that the first calculated field is a calculated field that will become invalid; the first calculated field is a calculated field in the data model; or, If an association relationship is established between the second data table and a third data table based on at least one of the invalid fields, determine that the association relationship between the second data table and the third data table will become invalid; the third data table is a data table in the data model; or, If a first filter is a filter established based on at least one of the invalid fields, determine that the first filter will become invalid.

14. The system according to claim 11 or 13, characterized in that, Each model element in the data model corresponds to an element instance; Specifically, the processing module is configured to: Send a first message to the message bus through the element instance corresponding to the second data table, where the first message includes the table identifier of the second data table and the invalid fields; Obtain the first message through a first element instance, verify through the first element instance that the model element corresponding to the first element instance depends on at least one of the invalid fields, and determine that the model element corresponding to the first element instance becomes invalid, where the first element instance is an element instance corresponding to any model element in the data model.

15. The system according to any one of claims 10-14, characterized in that, The system further includes a display module and an interaction module; The display module is configured to display the prompt message; The interaction module is further configured to receive a confirmation operation from the user, where the confirmation operation is used to indicate the operation of replacing the second data table with the first data table; The processing module is further configured to replace the field value of a first field in the second data table in the data model with the field value of the field with the same name in the first data table, where the field with the same name refers to the field in the first data table that has the same field name as the first field; the first field is one of the fields with the same field name included in the first data table and the second data table; Add the fields that exist in the first data table but do not exist in the second data table to the second data table to obtain a new second data table.

16. The system according to any one of claims 10-15, characterized in that, The system further includes a display module; The processing module is further configured to determine the difference information between the first data table and the second data table based on the fields included in the first data table and the fields included in the second data table, where the difference information indicates the difference between the fields included in the first data table and the fields included in the second data table; The display module is configured to display a difference preview interface, and the difference preview interface includes the difference information; Determining the affected model elements in the data model after replacing the second data table with the first data table includes: The interaction module is further configured to receive an operation of the user confirming the difference information on the difference preview interface; The processing module is specifically configured to: in response to the operation of determining the difference information, determine the affected model elements in the data model after replacing the second data table with the first data table.

17. The system according to any one of claims 10-16, characterized in that, The system further includes an interaction module; The interaction module is configured to receive an operation of the user replacing the second data table with the first data table.

18. The system according to claim 15, wherein The display module is further configured to display a difference interface, and the difference interface includes the invalidated association relationships between the new second data table and other data tables in the data model, and / or the invalidated fields and calculated fields of the new second data table relative to the second data table.

19. A computing device, characterized in that, Comprising a processor and a memory, the memory is used to store instructions, and the processor is used to execute the instructions to implement the method according to any one of claims 1-9.

20. A computer-readable storage medium, characterized in that, Comprising computer program instructions, when the computer program instructions are executed by a computing device, the computing device executes the method according to any one of claims 1-9.

Images