CN120235127A

CN120235127A - A data table replacement method, system and related equipment

Info

Publication number: CN120235127A
Application number: CN202311871545.5A
Authority: CN
Inventors: 朱菲墨; 佘石泉; 邓键洲; 陈祖彬
Original assignee: Huawei Technologies Co Ltd
Current assignee: Huawei Technologies Co Ltd
Priority date: 2023-12-29
Filing date: 2023-12-29
Publication date: 2025-07-01
Also published as: WO2025140668A1

Abstract

A data table replacing method, a system and related equipment are applied to a data model, wherein model elements comprise any one or more of data tables, fields, association relations among the data tables, filters and calculation fields, when table replacement is needed, a data table processing system determines the affected model elements in the data model after a first data table is replaced by a second data table, and generates prompt information based on the affected model elements so as to prompt a user whether to execute operation of replacing the second data table by the first data table. Wherein the affected model elements in the data model include model elements that may be updated and/or model elements that may fail. According to the method, when the data table in the data model is replaced, the affected model elements in the data model before and after replacement can be rapidly and accurately determined, the affected model elements can be intuitively displayed to a user, the influence on the data model after the replacement of the table is not needed to be analyzed by the user, and the user experience is improved.

Description

Data table replacement method, system and related equipment

Technical Field

The present application relates to the field of databases, and in particular, to a method, a system, and related devices for replacing a data table.

Background

After the data modeling is performed on the data tables in the database to obtain a data model, if any data table used for modeling changes, for example, a new data table is used for replacing one data table in the data model, part of model elements (association relation among tables, a filter, a calculation field and the like) in the data model can change, and even failure situations can occur. Currently, when any one data table in the data model is replaced, the user is required to analyze the influence possibly caused by the data model after the table replacement, and the burden on the user is heavy.

Disclosure of Invention

The application provides a data table replacing method, a system and related equipment, which can quickly and accurately determine the affected model elements in the data model before and after replacement when the data table in the data model is replaced, can intuitively display the affected model elements to a user, does not need to analyze the influence of the table after replacement on the data model, and improves user experience.

In a first aspect, the present application provides a data table replacing method, applied to a data model, where the data model includes a plurality of data tables, and model elements in the data model include any one or more of a data table, a field, an association between data tables, a filter, and a calculation field, a data table processing system receives a data table replacing instruction, where the data table replacing instruction indicates that a second data table in the data model is replaced with a first data table, the data table processing system obtains the first data table and the second data table, determines a model element affected in the data model after the first data table is replaced with the second data table, and generates prompt information based on the affected model element in the data model, so that a user determines whether to execute an operation of replacing the second data table with the first data table according to the prompt information. The prompt information is used for indicating the affected model elements in the data model after the first data table is replaced by the second data table.

By executing the data table processing method, when the data table in the data model is replaced, the affected model elements in the data model before and after replacement can be quickly and accurately determined, the affected model elements can be intuitively displayed to a user, the influence on the data model after the replacement of the data table is not needed by the user to analyze, and the user experience is improved.

In one possible implementation manner, the determining of the affected model elements in the data model after the first data table is replaced with the second data table includes determining a failure field based on a field included in the first data table and a field included in the second data table, wherein the failure field is a field existing in the second data table but not in the first data table, and determining the model elements in the data model depending on at least one field in the failure field to obtain the model elements which can fail in the data model.

In one possible implementation manner, the determining of the affected model elements in the data model after the first data table is replaced with the second data table includes determining an updated field based on a field included in the first data table and a field included in the second data table, where the updated field is a field with the same field name but a field value not identical in the first data table and the second data table, and determining the model elements in the data model depending on at least one field in the updated field to obtain the model elements to be updated in the data model.

In one possible implementation manner, determining model elements of at least one field in a failure field in a data model to obtain the failure model elements in the data model includes obtaining a first calculation field based on the at least one field in the failure field, determining that the first calculation field is a calculation field which can fail, wherein the first calculation field is one calculation field in the data model, or establishing an association relationship between a second data table and a third data table based on the at least one field in the failure field, determining that the association relationship between the second data table and the third data table can fail, wherein the third data table is one data table in the data model, or determining that a first filter can fail based on a filter established by the at least one field in the failure field.

In one possible implementation, each model element in the data model corresponds to an element instance, the model elements of at least one field in the failure field in the data model are determined to obtain the failed model elements in the data model, the method comprises the steps of sending a first message to a message bus through the element instance corresponding to the second data table, wherein the first message comprises a table identifier and the failure field of the second data table, obtaining the first message through the first element instance, verifying 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 determining that the model element corresponding to the first element instance fails, wherein the first element instance is an element instance corresponding to any one model element in the data model.

In one possible implementation, after generating the hint information based on the affected model elements in the data model, the method further includes:

The method comprises the steps of receiving confirmation operation of a user, wherein the confirmation operation is used for indicating the operation of replacing a second data table by a first data table, replacing a field value of a first field in the second data table in a data model with a field value of a field with the same name in the first data table, wherein the field with the same name in the first data table is a field with the same name as the first field in the first data table, the first field is one of fields with the same name in the first data table and the second data table, adding fields which exist in the first data table but do not exist in the second data table, and deleting the fields which exist in the second data table but do not exist in the first data table to obtain a new second data table.

In one possible implementation, the method further comprises determining, based on the fields included in the first data table and the fields included in the second data table, difference information between the first data table and the second data table, the difference information indicating a difference between the fields included in the first data table and the fields included in the second data table, displaying a difference preview interface, the difference preview interface including the difference information, determining that the affected model elements in the data model after replacing the second data table with the first data table, including receiving an operation by the user to confirm the difference information at the difference preview interface, and determining, in response to the operation of determining the difference information, to replace the affected model elements in the data model after replacing the second data table with the first data table.

In one possible implementation, prior to obtaining the first data table and the second data table, the method further includes the operation of receiving a user replacement of the second data table with the first data table.

In one possible implementation, after the new second data table is obtained, the method further comprises displaying a difference interface, wherein the difference interface comprises an association relation of failure between the new second data table and other data tables in the data model, and/or a calculation field of failure of the new second data table relative to the second data table.

In a second aspect, the present application provides a data table processing system, comprising:

The system comprises an acquisition module, a data model, a data table replacement module and a data table generation module, wherein the acquisition module is used for receiving a data table replacement instruction, and the data table replacement instruction indicates that a second data table in a data model is replaced by a first data table;

A processing module, configured to determine an affected model element in the data model after the first data table is replaced with the second data table, where the affected model element in the data model includes a model element that may be updated and/or a model element that may fail, the model element includes any one or more of a data table, a field, an association between data tables, a filter, and a computation field,

And the processing module is also used for generating prompt information based on the affected model elements in the data model, wherein the prompt information is used for indicating the affected model elements in the data model after the first data table is replaced by the second data table.

In one possible implementation, the processing module is specifically configured to:

Determining an invalidation field based on the field included in the first data table and the field included in the second data table, wherein the invalidation field is a field existing in the second data table but not in the first data table, and determining a model element depending on at least one field in the invalidation field in the data model to obtain the model element which can be invalidated in the data model.

In one possible implementation, the processing module is specifically configured to determine an update field based on a field included in the first data table and a field included in the second data table, where the update field is a field having a same field name but a field value that is not identical in the first data table and the second data table, and determine a model element in the data model that depends on at least one field in the update field, so as to obtain a model element that is updated in the data model.

In one possible implementation, the processing module is specifically configured to obtain a first calculation field based on at least one field in the failure field, determine that the first calculation field is a calculation field that can fail, the first calculation field is one calculation field in the data model, or establish an association between the second data table and the third data table based on at least one field in the failure field, determine that the association between the second data table and the third data table can fail, the third data table is one data table in the data model, or determine that the first filter can fail based on a filter established by at least one field in the failure field.

In one possible implementation, each model element in the data model corresponds to an element instance, the processing module is specifically configured to send a first message to the message bus through an element instance corresponding to the second data table, the first message includes a table identifier and an invalidation field of the second data table, acquire the first message through the first element instance, verify at least one field in the model element dependency invalidation field corresponding to the first element instance through the first element instance, and determine that the model element corresponding to the first element instance fails, where the first element instance is an element instance corresponding to any one model element in the data model.

In one possible implementation manner, the system further comprises a display module and an interaction module, wherein the display module is used for displaying prompt information, the interaction module is further used for receiving confirmation operation of a user, the confirmation operation is used for indicating operation of replacing the second data table with the first data table, the processing module is further used for replacing a field value of a first field in the second data table in the data model with a field value of a same-name field in the first data table, the same-name field refers to a field with the same field name as the first field in the first data table, the first field is one of fields with the same field name included in the first data table and the second data table, and a new second data table is obtained by adding a field which exists in the first data table but does not exist in the second data table to the second data table.

In one possible implementation, the system further comprises a display module, a processing module, a display module and a processing module, wherein the processing module is further used for determining difference information between the first data table and the second data table based on fields included in the first data table and fields included in the second data table, the difference information indicates differences between the fields included in the first data table and the fields included in the second data table, the display module is used for displaying a difference preview interface, the difference preview interface comprises the difference information, the affected model elements in the data model after the first data table is replaced by the first data table are determined, the interaction module is further used for receiving operation of confirming the difference information by a user in the difference preview interface, and the processing module is particularly used for determining the affected model elements in the data model after the second data table is replaced by the first data table in response to the operation of determining the difference information.

In one possible implementation, the system further includes an interaction module for receiving an operation of the user to replace the second data table with the first data table.

In a possible implementation manner, the display module is further configured to display a difference interface, where the difference interface includes a failed association relationship between the new second data table and other data tables in the data model, and/or a field and a calculation field of the new second data table that are failed with respect to the second data table.

In a third aspect, the present application provides a computing device comprising a processor and a memory for storing instructions, the processor being for executing the instructions, the processor, when executing the instructions, implementing a method as described in the first aspect or any possible implementation of the first aspect.

In a fourth aspect, a computer readable storage medium comprising computer program instructions which, when executed by a computing device, perform a method as described in the first aspect or any possible implementation of the first aspect.

Drawings

FIG. 1 is a schematic diagram of a data table processing system provided by the present application;

FIG. 2 is a schematic flow chart of a data table processing method according to the present application;

FIG. 3 is a schematic diagram of a data model provided by the present application;

FIG. 4 is a schematic diagram of a difference preview interface provided by the present application;

FIG. 5 is a schematic illustration of a prompt interface provided by the present application;

FIG. 6 is a schematic diagram of another prompt interface provided by the present application;

FIG. 7 is a differential display interface provided by the present application;

FIG. 8 is a schematic diagram of a computing device provided by the present application;

FIG. 9 is a schematic diagram of a cluster of computing devices provided by the present application.

Detailed Description

The technical scheme provided by the application is described in detail below with reference to the accompanying drawings.

The data model is a model obtained by visualizing the relation among model elements by a data analysis tool, wherein the model elements comprise data tables, fields, association relations among the data tables, filters and calculation fields. The data analysis tools may be, for example, a business intelligence (business intelligence, BI) model, power BI, and the like.

The calculated field is a virtual field calculated based on the existing field. It can generate new values by performing operations such as mathematical operations, string concatenation, logical judgment, etc. on other fields. For example, in a sales data table, the sales sum or profit margin can be calculated by calculating the field. Filters are conditions used to filter data. It can filter out the data records meeting the condition according to the values of the fields. Filters are typically used to query data or create reports to quickly find desired information from a large amount of data.

The following first describes a data packet prompting system and a deployment mode thereof applying the data table processing method provided by the application.

FIG. 1 is a schematic diagram of a data table processing system according to the present application. The data sheet processing system 100 includes an acquisition module 110 and a processing module 120.

The acquiring module 110 is configured to acquire a first data table and a second data table. Wherein the data model comprises a plurality of data tables, the second data table being one of the plurality of data tables. The data model includes model elements, the data model includes one or more of data tables, each field in each data table, associations between data tables and data tables, filters, or computation fields.

The processing module 120 is configured to determine, after acquiring the first data table and the second data table, an affected model element in the data model after replacing the second data table with the first data table based on a field included in the first data table and a field included in the second data table. Wherein affected model elements in the data model refer to model elements that may be updated and/or model elements that may fail after replacing the second data table with the first data table.

For example, if the second data table includes the field a, the second data table and the third data table rely on the field a to establish an association relationship, and the first data table does not have the field a, after the second data table is replaced by the first data table, the association relationship between the first data table and the third data table cannot be established based on the field a, so that the model element of the association relationship between the original second data table and the third data table will fail.

For another example, if the second data table includes a field B, a calculation field C in the data model is obtained by relying on the data of the field B in the second data table, and the first data table includes the field B as well, but the field value of the field B in the first data table is not identical to the field value of the field B in the second data table, if the other fields on which the calculation field C depends do not change, after the field B in the second data table is updated to the field B in the first data table, the field value of the calculation field C is updated, and the calculation field C belongs to the field that is updated in the data model.

When determining the failed model element, the processing module 120 determines a field that exists in the second data table but does not exist in the first data table based on the field included in the first data table and the field included in the second data table. If the processing module 120 determines that a model element in the data model depends on at least one of the failure fields, the model element is the failed model element.

When determining the updated model element, the processing module 120 determines, based on the fields included in the first data table and the fields included in the second data table, fields in the second data table and the first data table that have the same field names but not identical field values. In the application, fields with the same field names but different field values in the second data table and the first data table are called as update fields, and the update fields comprise one or more fields. If the processing module 120 determines that a model element in the data model depends on at least one of the updated fields, the model element is the updated model element.

The processing module 120 is further configured to generate hint information based on the affected model elements in the data model, where the hint information includes the affected model elements in the data model and is configured to instruct a user to replace the affected model elements in the data model with the first data table after the second data table is replaced, so that the user determines whether to replace the second data table with the first data table based on the hint information.

Optionally, the data table processing system 100 further includes a sending module 130 and a display module 140, where the sending module 130 is configured to send the prompt message to the display module 140, and the display module 140 is configured to display the prompt message on the display interface after the prompt message is acquired.

The data sheet processing system 100 also includes an interaction module 150, the interaction module 150 being configured to receive operations performed by a user on a display interface. For example, after the user checks the prompt information, if it is determined that the second data table in the data model is replaced by the first data table, the user can trigger a "confirm" space of the display interface, after receiving a confirmation operation triggered by the user, the interaction module 150 generates a request for confirming replacement, after receiving the request for confirming replacement, the processing module 120 replaces a field value of a first field in the second data table in the data model with a field value of a field with the same name in the first data table, adds a field existing in the first data table but not existing in the second data table, and deletes a field existing in the second data table but not existing in the first data table to obtain a new second data table. The same name field refers to a field with the same field name as the first field in the first data table, and the first field is one of the fields with the same field name included in the first data table and the second data table.

It should be noted that after the above procedure is performed, the data in the new second data table is the same as 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, and for example, if a filter established based on the first field in the second data table is provided in the data model, the filter is not deleted because the first data table has the same field as the field name of the first field. For another example, if the data model has the association relationship and the calculation field established based on the first field, the corresponding association relationship and calculation field will not be deleted in the above process.

By the replacement method, the related data of the original second data table in the data model can be reserved, the workload of reconfiguration after table replacement is reduced, and the efficiency in table replacement work is improved.

It should be understood that fig. 1 is merely an exemplary manner of dividing the structure of the data table processing system, and in practical applications, the data table processing system may have other manners of dividing, which are not limited in particular by the present application.

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

When the data sheet processing system 100 is a software system, the data sheet processing system 100 may be deployed at a data center of a cloud platform. For example, the data sheet processing system 100 is a cloud service provided by a cloud service provider. In particular implementations, data table processing system 100 may be deployed independently on one compute instance in a data center of a cloud platform or distributed across multiple compute instances in a data center of a cloud platform. Wherein, the computing examples comprise a server, a virtual machine, a container and the like. The data sheet processing system 100 is deployed at a data center of a cloud platform and is abstracted by a cloud service provider to be a cloud service. A user can log into the cloud platform through a client or web page, and the cloud platform processes services to the user's data sheet through the data sheet processing system 100.

In the application, the cloud platform can be a cloud platform of a center cloud, a cloud platform of an edge cloud or a cloud platform comprising the center cloud and the edge cloud, and the application is not particularly limited. Moreover, when the cloud platform is a cloud platform including a center cloud and an edge cloud, the data table processing system 100 may be partially deployed on the cloud platform of the edge cloud and partially deployed on the cloud platform of the center cloud.

In one possible deployment, some of the functional modules in the data sheet processing system 100 are deployed in a back-end computing device or cluster of computing devices (including at least one computing device), and some of the functional modules are deployed in a front-end user's terminal device. For example, the acquisition module 110 and the processing module 120 are deployed in a server at the back end, and the display module 140 and the interaction module 150 are deployed in a terminal device at the front end.

In one possible deployment, the data sheet processing system 100 may also be deployed on a terminal device used by a user, for example, the data sheet processing system 100 is an application program capable of running on a terminal device, and the terminal device includes a mobile phone, a notebook computer, a desktop computer, a tablet computer, and the like.

The following describes a data table processing method provided by the application with reference to the accompanying drawings, wherein the prompting method is used for prompting the affected model elements in the data model after the data table is replaced when the data table is replaced in the data model, so that a user can determine whether to execute the data table replacing operation based on prompting information. It should be understood that in the present application, replacing a data table includes replacing a data table in a data model with a data table, and also includes modifying a data table in a data model, where the modifying includes adding a field, deleting a field, modifying a value of a field, adding a record or deleting a record, etc., and in the present application, the method provided by the present application is described taking as an example replacing a data table in a data model with a data table. As shown in FIG. 2, FIG. 2 is a flow chart of a data table processing method provided by the application, and the method comprises S201-S205.

S201, receiving an operation of replacing a second data table with the first data table, and obtaining the first data table and the second data table.

In the application, the second data table is one data table in a data model, and the data model comprises a plurality of data tables, data model data tables, fields, association relations among different data tables, a filter, calculation fields and other model elements.

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 a value of a field of the second data table portion in the data model, deletes a field, etc., where the modified data table corresponds to a new data table, i.e., the first data table, and after detecting the modification of the second data table by the user, the data table processing system 100 corresponds to receiving a data table replacement instruction, where the data table replacement instruction indicates that the second data table in the data model is replaced with the first data table, and the data table processing system 100 further obtains the first data table and the second data table.

In one possible implementation, the operation of replacing the second data table with the first data table may also be user-triggered. The data table processing system 100 displays the data model through a display interface, a user loads a first data table into the data model through an interface provided by the data table processing system 100, then selects the first data table through a mouse, drags the first data table to the upper side of a second data table in a dragging mode, triggers the operation of replacing the second data table by the first data table, and after receiving the operation of replacing the second data packet table by the first data table, the data table processing system 100 acquires 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 may be all the same, may be partially the same, and the first data table and the second data table may not have the same field, which is not specifically limited in the present application.

Fig. 3 is a schematic diagram of a data model according to the present application. The data model comprises a data table such as a product table, a store table, a client table, an order table, a month statistics table and the like. The product table comprises fields such as a product name, a product identification (Identity), a product category name, a product category ID, cost and the like, the store table comprises fields such as a store name, a store ID, a region, a province, a city and the like, the client table comprises fields such as a unit name, a unit ID, a region, a province, a city and the like, and the order table comprises fields such as an order number, an order date, a region, a month, a store ID, a unit ID, a product category ID, a quantity, a unit price, cost and the like. The month statistics table is sales amount of a product corresponding to each product ID based on the product ID statistics, and comprises fields of the product ID, the product category ID, the month, unit price, sales quantity, sales amount, profit and the like, wherein the profit is a calculation field in the month statistics table.

The method comprises the steps of establishing an association relationship between a product table and an order table through a product ID, establishing an association relationship between a store table and the order table through a store ID, establishing an association relationship between a client table and the order table through a unit ID, and establishing an association relationship between the order table and a month statistics table through a product ID and a month.

In fig. 3, the order table is a second data table, the order table (1) is a first data table, and the user triggers the operation of replacing the order table with the order table (1) by dragging the order table (1) over the order table. Wherein, the order table (1) comprises fields of order number, order date, region, month, product ID, product category ID, quantity, unit price, order amount and the like, and compared with the order table, the order table (1) has no three fields of store ID, unit ID and cost, but the order amount field is increased.

It should be understood that the display interface shown in fig. 3 is only an example, in which a part of a data table of a data model, a part or all of fields included in each data table, and an association relationship between part of the data tables are displayed, and part of model elements are not shown.

It should be appreciated that the data sheet processing system 100 is capable of displaying the data model shown in FIG. 3 and described above via the display module 140, receiving a user's operation of replacing a second data sheet with a first data sheet via the interaction module 150, and obtaining the first and second data sheets via the obtaining module 110.

S202, 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.

After the first data table and the second data table are acquired, the data table processing system 100 compares the fields included in the first data table with the fields included in the second data table, and determines difference information between the first data table and the second data table. The difference information is used for indicating the difference between the fields included in the first data table and the fields included in the second data table, the difference information includes the fields existing in the second data table but not in the first data table, and the difference information can also include the fields existing in the first data table but not in the second data table.

It should be understood that in the present application, if the field name of a field in the first data table is the same as the field name of a field in the second data table, that is, it is determined whether the field is included in both the first data table and the second data table, and it is not compared whether the field values of the fields are the same. If the field name of a field in the first data table does not exist in the second data table, the field is a field that exists in the first data table but does not exist in the second data table. If the field name of a field in the second data table does not exist in the first data table, the field is a field that exists in the second data table but does not exist in the first data table.

FIG. 4 is a schematic diagram of a difference preview interface provided by the present application, where after determining the difference information, the data table processing system 100 is capable of generating a difference preview interface as shown in FIG. 4, where the difference preview interface includes the difference information, and the difference preview interface includes fields included in the second data table and fields included in the first data table, and highlighting the difference information, that is, highlighting the fields that are present in the second data table but not present in the first data table. As shown in fig. 4, the order table (1) (i.e., the first data table) has no three fields of store ID, unit ID, and cost, which are highlighted with respect to the order table (i.e., the second data table). Alternatively, fields that exist in the first data table but not in the second data table may also be highlighted.

It should be appreciated that the data sheet processing system 100 is capable of determining difference information between the first data sheet and the second data sheet via the processing module 120 and displaying the difference preview interface shown in fig. 4 via the display module 140.

S203, determining affected model elements in the data model after the first data table is replaced by the second data table.

In the present application, if it is determined to replace the second data table with the first data table, the data table processing system 100 determines, based on the first data table and the second data table, the affected model elements in the data model after the first data table replaces the second data table. Affected model elements include model elements that may be updated and/or model elements that may fail in the data model after replacing the second data table with the first data table.

The model element to be updated refers to that if there is a model element established depending on a second field in the second data table in the data model, the second field also exists in the first data table, that is, a field with the same field name as the second field exists 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, the model element established depending on the second field in the second data table is the model element to be updated. The model element that may fail refers to the model element that is built in dependence on a third field in the second data table if the model element is present in the data model but the third field is not present in the first data table.

In the present application, after the data table processing system 100 obtains the first data table and the second data table, determining an invalidation field and/or an update field according to a field included in the first data table and a field included in the second data table, then determining a model element depending on at least one field in the invalidation field in the data model based on the invalidation field to obtain a model element that can be invalidated in the data model, and determining a model element depending on at least one field in the invalidation field in the data model based on the update field to obtain a model element that can be updated in the data model.

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, fields that are present in the second data table but not in the first data table, i.e., failure fields, which 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 of the above-described failure fields, the model element is the failed model element. For example, a first calculation field included in one data table in the data model is obtained based on at least one field in the failure field, and then the first calculation field is determined to be a calculation field which can fail, for example, a second data table and a third data table establish an association relationship based on at least one field in the failure field, and then the association relationship between the second data table and the third data table is determined to be an association relationship which can fail, for example, a first filter is determined to be a filter which can fail based on at least one field in the failure field.

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, fields in the second data table and the first data table that have the same field names but are not identical in field values, i.e., update fields, the update fields including 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 of the updated fields, the model element is the model element that will be updated.

Illustratively, the value of the "sales number" field in the month statistics table is obtained by statistics depending on the value of the "number" field in the order table, and the value of the "sales amount" field is obtained by calculation depending on the values of the "number" 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 comprise a "quantity" field, and 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, the "sales quantity" field and the "sales amount" are model elements that will be updated in the monthly statistics table.

Since the order table (1) has no two fields of store ID and unit ID, and the association relationship is established between the store table and the order table depending on the store ID, the association relationship is established between the client table and the order table depending on the unit ID. After the first data table replaces the second data table, the association relationship between the store table and the order table in the data model is an association relationship which can be disabled, and the association relationship between the client table and the order table is an association relationship which can be disabled.

In one possible implementation, each model element in the data model corresponds to an element instance, e.g., 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 a message to the message bus and can acquire the message from the message bus. After detecting the operation of replacing the second data table by the first data table, the data table processing system 100 sends a first message to the message bus by using the element instance corresponding to the second data table, where the first message includes the table identifier of the second data table, the name of the field included in the failure field, and the name of the field included in the update field.

The element instance corresponding to each model element in the data table processing system 100 will obtain the first message from the message bus, and each element instance will determine whether the first message is relevant to itself based on the failure field and/or the update field in the first message. Taking the first element instance corresponding to the first model element as an example, the first model element may be any model element in the data model. After the first element instance obtains the first message, it is determined whether the first model element depends on at least one of the failure fields in the first message, and if the first model element depends on at least one of the failure 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 is invalid and sends a second message to the message bus via the first element instance, the second message being used to notify other element instances that the first model element is invalid, and if the first model element does not depend on at least one of the invalid fields in the first message or on at least one of the updated fields in the first message, the first element instance does not send a message to the message bus.

The second element instance that receives the second message may 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 may fail and sends a third message to the message bus via the second element instance, the third message being used to notify other element instances that the second model element fails, and 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.

Similarly, after the first element instance obtains the first message, it is determined whether the first model element depends on at least one of the updated fields in the first message, and if the first model element depends on at least one of the updated fields in the first message, the first element instance determines that the first model element is to be updated. The data table processing system 100 records that the first model element is to be updated and sends a fourth message to the message bus via the first element instance informing other model instances that the first model element is to be updated, and if the first model element does not depend on at least one of the updated fields in the first message or on at least one of the failed fields in the first message, the first element instance does not send a message to the message bus.

The second element instance that receives the fourth message may determine whether the second model element depends on the first model element, and if the second model element depends on the first model element, the data table processing system 100 may record that the second model element is updated and send a fifth message to the message bus via the second element instance, the fifth message being used to inform other element instances that the second model element is updated, and 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.

According to the method, each element instance acquiring the message from the message bus can make the judgment, and if the corresponding model element is determined to be invalid or updated, the message is sent to the message bus to inform other element instances. By the above method, the data sheet processing system 100 is able to determine the model elements affected in the data model.

For example, the first data table 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, the first message includes information that the "cost" field is invalid, and the field value of the "profit" field in the monthly statistics table is calculated according to the "cost" field, so after the element instance corresponding to the "profit" field acquires the first message, it is determined that the element instance corresponding to the "profit" field includes the "cost" field, and then the element instance corresponding to the "profit" field determines that the element instance corresponding to the "profit" field is invalid, and the element instance corresponding to the "profit" field also sends the information that the "profit" field is invalid in the monthly statistics table to the message bus. If a yearly statistics table is also included in the data model, the yearly statistics table is used to count the profit of each product in the year, the yearly statistics table includes a "yearly profit" field, which is calculated depending on the "profit" field in the yearly statistics table, so that if the model element "profit" fails, the model element "yearly profit" also fails.

In one possible implementation, the difference preview interface shown in fig. 4 includes a "confirm" control and a "cancel" control, and the data sheet processing system 100, after presenting the difference between the first data sheet and the second data sheet to the user via the difference preview interface, if the user confirms the difference information, the user can trigger the "confirm" control of the difference preview interface, for example, by clicking the "confirm" control with a mouse. Upon receipt of the validation operation, the data table processing system 100 determines the affected model elements in the data model after replacing the second data table with the first data table based on the method described above.

It should be appreciated that the data table processing system 100 is capable of determining, based on the determination by the processing module 120, the affected model elements in the data model after replacing the second data table with the first data table.

S204, generating prompt information based on the affected model elements in the data model, wherein the prompt information is used for indicating the affected model elements in the data model after the first data table is replaced by the second data table.

The data table processing system 100 generates hint information indicating the affected model elements in the data model after the second data table is replaced with the first data table upon determining the affected model elements in the data model after the second data table is replaced with the first data table, so that the user confirms whether to replace the second data table with the first data table based on the hint information.

In the present application, the data table processing system 100 can display the above-mentioned prompt information through a prompt interface, where the prompt interface includes three tabs of "related field" options, "association relationship" options and "filter" options, and after each option is selected, the prompt interface can display the corresponding prompt information. Fig. 5 is a schematic diagram of a prompt interface provided by the present application. After the "related fields" option in fig. 5 is selected, the prompt interface can display the affected fields and the calculated fields determined in S203, where the "related fields" option includes two columns of data, namely "fields/calculated fields" and "table fields". Wherein a list of "fields/computation fields" is used to show affected fields and computation fields in the data model, including fields that will be updated, computation fields that will be updated, fields that will be invalidated, and computation fields that will be invalidated, and a list of "table fields" is used to show update fields and invalidation fields. For example, as shown in fig. 5, if the order table (1) lacks a cost field with respect to the order table, the "profit" field of the monthly statistics table and the "annual profit" field of the annual statistics table will be disabled.

Alternatively, the data table processing system 100 can display the model elements that will be updated and the model elements that will fail in different display manners, for example, display the model elements that will be updated and the model elements that will fail in different colors, highlight the model elements that will fail, etc., and the present application is not limited in particular.

FIG. 6 is a schematic diagram of another prompt interface provided by the present application. In fig. 6, after the "association" option is selected, the prompt interface may display the affected association determined in S203, where the "association" option includes three columns of data, including "start table", "target table" and "table field". Wherein, a column of the initial table is used for showing the table name of the initial table in the affected association, a column of the target table is used for showing the table name of the target table in the affected association, and a column of the table field is used for showing the field causing the association to be affected. For example, in fig. 3, there is an association between a product table, which is a start table, and an order table, which is a target table. It should be understood that, in the present application, the fact that the association relationship is affected generally means that the association relationship fails, that is, the field in which the association relationship is established between two data tables belongs to the failure field, and in fig. 6, there is an association relationship between the start table and the target table located in the same row, where the association relationship is affected due to the failure of the field corresponding to the field in the table in the same row. For example, the management relationship between the store table and the order table in fig. 6 is affected due to a store ID failure in the order table.

Similarly, when the "filter" option is selected, the prompt interface can display the affected filter determined in S203, where the "filter" option includes two columns of data, namely "filter type" and "table field". Wherein a column of "filter types" is used to show the type of filter that is affected and a column of "table fields" is used to show the fields that result in the filter being affected. The filter types comprise a common filter and an authority filter, and it is understood that in a prompt interface corresponding to a 'filter' tab, the filter type which is positioned in the same row with a field represents the type of the filter set for the field.

It should be appreciated that the data sheet processing system 100 is capable of generating the aforementioned prompt message based on the processing module 120 and displaying the prompt message via the display module 140 to prompt the user whether to perform an operation to replace the second data sheet with the first data sheet.

S205, receiving confirmation operation of the user, and executing operation of replacing the second data table with the first data table.

The data table processing system 100 performs an operation of replacing the second data table in the data model with the first data table after receiving the confirmation operation input by the user. Specifically, the field value of the first field in the second data table in the data model is replaced by the field value of the field with the same name in the first data table. The same name field refers to a field with the same field name as the first field in the first data table, and the first field is one of the fields with the same field name included in the first data table and the second data table. And adding fields which exist in the first data table but do not exist in the second data table, deleting fields which exist in the second data table but do not exist in the first data table, and obtaining a new second data table.

In the present application, the prompt interface shown in fig. 5 or fig. 6 includes a "confirm" control and a "cancel" control, and if the user triggers the "confirm" control on the prompt interface, the data table processing system 100 can receive the confirm operation, and respond to the confirm operation, and execute the operation of replacing the first data table with the second data table. If the user triggers the "cancel" control at the prompt interface, then the data sheet processing system 100 does not perform the operation of replacing the first data sheet with the second data sheet.

Alternatively, as shown in fig. 7, fig. 7 is a differential display interface provided by the present application. The differential display interface comprises invalid association relations between the new second data table and other data tables in the data model, and/or fields of the new second data table which are not existed relative to the original second data table and invalid calculation fields. Fig. 7 shows the association relationship of failures by a broken line. Since the data table (1) has no "store ID" field and "unit ID" field, the association between the store table and the order table and the association between the customer table and the order table are invalidated.

By executing the method, when one data table in the data models is replaced by one data table, the affected model elements in the data models before and after replacement can be quickly and accurately determined, the affected model elements can be intuitively displayed to a user, the influence on the data models after the table replacement is not required to be analyzed by the user, the requirement on the user in the table replacement process is reduced, and the user experience is improved. In the process of replacing one table in the data model by one data table, the related data of the replaced data table in the data model can be reserved, the workload of reconfiguration in the table replacement process is reduced, and the efficiency in the table replacement work is improved.

For the purposes of simplicity of explanation, the above method embodiments are presented as a series of acts, but one skilled in the art will appreciate that the present invention is not limited by the order of acts described. For example, S202 described above may not be performed, or the difference may not be displayed in the form shown in fig. 4. Further, those skilled in the art will appreciate that the embodiments described in the specification are presently preferred embodiments, and that the acts are not necessarily required for the present invention. Other reasonable combinations of steps that can be conceived by those skilled in the art based on the foregoing description are also within the scope of the invention.

The application also provides a computing device, as shown in fig. 8, and fig. 8 is a schematic diagram of the computing device. Computing device 800 includes bus 802, processor 804, memory 806, and communication interface 808. Communication between processor 804, memory 806, and communication interface 808 is via bus 802. Computing device 800 may be a server or a terminal device. It should be understood that the present application is not limited to the number of processors, memories in computing device 800.

Bus 802 may be a peripheral component interconnect (PERIPHERAL COMPONENT INTERCONNECT, PCI) bus, or an extended industry standard architecture (extended industry standard architecture, EISA) bus, among others. The buses may be divided into address buses, data buses, control buses, etc. For ease of illustration, only one line is shown in fig. 8, but not only one bus or one type of bus. Bus 802 may include a path to transfer information between various components of computing device 800 (e.g., memory 806, processor 804, communication interface 808).

The processor 804 may be any one of a central processing unit (Central Processing Unit, CPU), a CPU and other hardware chips, and the hardware chips may be any one of a plurality of types, for example, a co-processing unit, including a graphics processor (graphics processing unit, GPU), a tensor processor (tensor processing unit, TPU), a programmable logic device (programmable logic device, PLD), a complex programmable logic device (complex programmable logic device, CPLD), a field-programmable gate array (field programmable GATE ARRAY, FPGA), or a digital signal processor (DIGITAL SIGNAL processor, DSP), and the computing device 800 may include one or more hardware chips of any one of the plurality of types, or may include any one of a plurality of types of hardware chips, which is not specifically limited by the present application.

The memory 806 may include volatile memory (RAM), such as random access memory (random access memory). The memory 806 may also include non-volatile memory (ROM), such as read-only memory (ROM), flash memory, mechanical hard disk (HARD DISK DRIVE, HDD) or solid state disk (SSD STATE DRIVE).

The memory 806 has stored therein executable program code and data which the processor 804 executes to implement the method described in the corresponding method embodiment of fig. 2. That is, the memory 806 stores program codes for implementing the functions of the data table processing system 100, thereby implementing the data table processing method shown in fig. 2, where the program codes include one or more software modules, and the one or more software modules include the acquisition module 110 and the processing module 120 in the data table processing system 100 shown in fig. 1, and the executable program codes are executed by the processor 804 to implement the corresponding method of fig. 2, which will not be described herein.

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, etc. The wired interface may be an ethernet interface, a local interconnect network (local interconnect network, LIN), etc., and the wireless interface may be a cellular network interface or use a wireless local area network interface, etc.

The application also provides a computing device cluster. The computing device cluster includes a plurality of computing devices 800. The computing device may be a server, such as a central server, an edge server, a local server in a local data center, or a server of a data center of a cloud environment, or the like. In some embodiments, the computing device may also be a terminal device such as a desktop, notebook, or smart phone.

Fig. 9 is a schematic diagram of a computing device cluster according to the present application, as shown in fig. 9. The same program code for implementing the method in the embodiment shown in fig. 2 may be stored in the memory 806 in a plurality of computing devices 800 in a computing device cluster.

In some possible implementations, the memories 806 of the plurality of computing devices 800 in the computing device cluster may also each have stored therein a portion of the instructions for performing the method described above, i.e., the memories 806 of the different computing devices 800 in the computing device cluster may each have stored therein a different instruction for performing a portion of the functionality of the method shown in fig. 2, and the combination of the plurality of computing devices 800 may together implement the method in the embodiment shown in fig. 2.

In some possible implementations, multiple computing devices 800 in a cluster of computing devices may be connected by a network. Wherein the network may be a wide area network or a local area network, etc. For example, two computing devices are connected via a network. Specifically, the connection to the network is made through a communication interface in each computing device.

The application also provides a computer program product containing instructions. The computer program product may be software or a program product containing instructions capable of running on a computing device or stored in any useful medium. The computer program product, when run on at least one computing device, causes the at least one computing device to implement the method of the embodiment shown in fig. 2.

The application also provides a computer readable storage medium. The computer readable storage medium may be any available medium that can be stored by a computing device or a data storage device such as a data center containing one or more available media. The usable medium may be a magnetic medium (e.g., floppy disk, hard disk, magnetic tape), an optical medium, or a semiconductor medium (e.g., solid state disk), etc. The computer-readable storage medium includes instructions that instruct a computing device to implement the method in the embodiment shown in fig. 2.

It should be noted that the above-mentioned embodiments are merely for illustrating the technical solution of the present invention, and not for limiting the same, and although the present invention has been described in detail with reference to the above-mentioned embodiments, it should be understood by those skilled in the art that the technical solution described in the above-mentioned embodiments may be modified or some technical features may be equivalently replaced, and these modifications or substitutions do not make the essence of the corresponding technical solution deviate from the protection scope of the technical solution of the embodiments of the present invention.

Claims

1. A data table replacing method, characterized in that a data model includes a plurality of data tables, model elements in the data model include any one or more of data tables, fields, association relations between data tables, filters and calculation fields, and the method includes:

receiving a data table replacement instruction, the data table replacement instruction indicating replacement of a second data table in the data model with a first data table;

acquiring the first data table and the second data table;

Determining the affected model elements in the data model after replacing the second data table with the first data table, wherein the affected model elements in the data model comprise model elements which can be updated and/or model elements which can be disabled;

And generating prompt information based on the affected model elements in the data model, wherein the prompt information is used for indicating the affected model elements in the data model after the first data table is replaced by the second data table.

2. The method of claim 1, wherein said determining affected model elements in the data model after replacing the second data table with the first data table comprises:

Determining an invalidation field based on the field included in the first data table and the field included in the second data table, wherein the invalidation field is a field existing in the second data table but not in the first data table;

And determining model elements which depend on at least one field in the failure fields in the data model, and obtaining model elements which can fail in the data model.

3. The method according to claim 1 or 2, wherein said determining the affected model elements in the data model after replacing the second data table with the first data table comprises:

determining an updated field based on a field included in the first data table and a field included in the second data table, wherein the updated field is a field with the same field name but different field value in the first data table and the second data table;

and determining model elements which depend on at least one field in the updated fields in the data model to obtain model elements which can be updated in the data model.

4. The method according to claim 2, wherein determining model elements in the data model that depend on at least one of the failed fields, results in model elements in the data model that fail, comprises:

A first calculation field is obtained based on at least one field in the failure fields, the first calculation field is determined to be the calculation field which can fail, the first calculation field is one calculation 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 failure field, and determine that the association relationship between the second data table and the third data table fails, wherein the third data table is one data table in the data model, or

The first filter is a filter established based on at least one of the failure fields, and the first filter is determined to fail.

5. The method of claim 2 or 4, wherein each model element in the data model corresponds to an element instance;

determining model elements which depend on at least one field in the failure fields in the data model to obtain the failure model elements in the data model, wherein the determining comprises the following steps:

Sending a first message to a message bus through an element instance corresponding to the second data table, wherein the first message comprises a table identifier of the second data table and the failure field;

And acquiring the first message through a first element instance, verifying that a model element corresponding to the first element instance depends on at least one field in the failure field through the first element instance, and determining that the model element corresponding to the first element instance fails, wherein 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, wherein after generating hint information based on the affected model elements in the data model, further comprising:

Receiving a confirmation operation of a user, wherein the confirmation operation is used for indicating the operation of replacing the second data table by the first data table;

Replacing a field value of a first field in a second data table in the data model with a field value of a field with the same name in the first data table, wherein the field with the same name is a field with the same field name as the first field in the first data table;

and adding fields which exist in the first data table but do not exist in the second data table, deleting the fields which exist in the second data table but do not exist in the first data table, and obtaining a new second data table.

7. The method of any of claims 1-6, further comprising, after the first data table and the second data table:

Determining, based on the fields included in the first data table and the fields included in the second data table, difference information between the first data table and the second data table, the difference information indicating a 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 comprises the difference information;

The determining the affected model elements in the data model after replacing the second data table with the first data table comprises:

And receiving the operation of confirming the difference information by the user on the difference preview interface, and determining the affected model elements in the data model after the first data table is replaced with the second data table in response to the operation of determining the difference information.

8. The method of any of claims 1-7, further comprising, prior to said obtaining the first data table and the second data table, receiving a user replacement of the second data table with the first data table.

9. The method of claim 6, wherein after obtaining the new second data table, further comprising:

and displaying a difference interface, wherein the difference interface comprises an invalid association relation between the new second data table and other data tables in the data model, and/or a calculation field of the new second data table invalid relative to the second data table.

10. A data table processing system, comprising:

An acquisition module for receiving a data table replacement instruction indicating replacement of a second data table in the data model with a first data table;

Acquiring a first data table and a second data table;

The processing module is used for determining the affected model elements in the data model after the first data table is replaced with the second data table, wherein the affected model elements in the data model comprise model elements which can be updated and/or model elements which can be disabled, and the model elements comprise any one or more of data tables, fields, association relations among the data tables, filters and calculation fields;

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

11. The system according to claim 10, wherein the processing module is specifically configured to:

12. The system according to claim 10 or 11, wherein the processing module is specifically configured to:

13. The system according to claim 11, wherein the processing module is specifically configured to:

14. The system of claim 11 or 13, wherein each model element in the data model corresponds to an element instance;

The processing module is specifically configured to:

15. The system of any one of claims 10-14, further comprising a display module and an interaction module;

the display module is used for displaying the prompt information;

The interaction module is further used for receiving a confirmation operation of a user, wherein the confirmation operation is used for indicating the operation of replacing the second data table with the first data table;

the processing module is further configured to replace a field value of a first field in a second data table in the data model with a field value of a 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 with the same field name as the first field;

And adding fields which exist in the first data table but do not exist in the second data table to obtain a new second data table.

16. The system of any one of claims 10-15, further comprising a display module;

The processing module is further configured to determine difference information between the first data table and the second data table based on a field included in the first data table and a field included in the second data table, where the difference information indicates a difference between the field included in the first data table and the field included in the second data table;

the display module is used for displaying a difference preview interface, and the difference preview interface comprises the difference information;

the interaction module is further used for receiving the operation that the user confirms the difference information on the difference preview interface;

the processing module is specifically configured to determine, in response to the operation of determining the difference information, an affected model element in the data model after replacing the second data table with the first data table.

17. The system of any one of claims 10-16, wherein the system further comprises an interaction module;

and the interaction module is used for receiving the operation that the user replaces the second data table with the first data table.

18. The system of claim 15, wherein the system further comprises a controller configured to control the controller,

The display module is further configured to display a difference interface, where the difference interface includes an association relationship between the new second data table and other data tables in the data model, and/or a field and a calculation field where the new second data table fails with respect to the second data table.

19. A computing device comprising a processor and a memory, the memory to store instructions, the processor to execute the instructions to implement the method of any of claims 1-9.

20. A computer readable storage medium comprising computer program instructions which, when executed by a computing device, perform the method of any of claims 1-9.